TITLE: Printer ROI Analysis - Cost vs. Profit for 2 Years

DESCRIPTION: I analyzed a two-year printer investment scenario for two users with the different daily printing requirements. The analysis compared three printer options based on purchase cost, supply cost, printing capacity, projected revenue and estimated two-year profit.

WHAT I DID:

• Organized printer specifications, capacity and cost data.

• Calculated estimated daily, annual and two-year printing volumes.

• Calculated total printer and supply costs.

• Projected revenue using the assumed $2-per-page rate.

• Calculated estimated two-year profit for each printer and user.

• Created charts to compare projected profitability.

• Applied cost-benefit and ROI analysis to evaluate the options.

KEY FINDINGS:

Under the assumptions used in the model, the Zero printer produced the highest projected two-year profit for both users, while the results varied considerably based on daily printing volume and printer costs.

RESULT:

The completed Excel model provided a structured comparison of printer costs, projected revenue and profitability, making it easier to evaluate the options under the scenario's assumptions.

TOOLS USED: Microsoft Excel, ROI Modeling, Cost-Benefit Analysis, Profit Calculation, Bar Charts and Business Case Analysis.