French press net income analysis average price per

This preview shows page 9 - 14 out of 14 pages.

French Press - Net Income Analysis Average Price per Unit $ 60.99 $ 65.99 $ 70.99 $ 75.99 105,870 170,870 235,870 300,870 116,865 184,365 251,865 319,365 127,860 197,860 267,860 337,860 138,855 211,355 283,855 356,355 149,850 224,850 299,850 374,850 160,845 238,345 315,845 393,345 171,840 251,840 331,840 411,840 182,835 265,335 347,835 430,335 193,830 278,830 363,830 448,830 00 14,000 15,000 16,000 17,000 18,000 $55.99 $60.99 $65.99 $70.99 $75.99 Units Sold
Image of page 9

Subscribe to view the full document.

Cortona Coffee Makers - Espresso Maker Suppliers Viva Domestics Allgood Universal SPQ Worldwide Total Units Produced 4,200 4,200 1,600 10,000 Fixed Costs $ 50,000.00 $ 60,000.00 $ 75,000.00 Fixed Cost per Unit 11.90 14.29 46.88 Variable Costs 261,240.00 269,850.00 104,800.00 Variable Cost per Unit 62.20 64.25 65.50 Total Costs $ 311,240 $ 329,850 $ 179,800 $ 820,890 Minimum Total Cost Model $ 820,890 3 1 1 1 1 32767 0
Image of page 10
Scenario Summary No Change Subcontract Changing Cells: Price_Per_Unit_Single_Cup $ 99.99 $ 99.99 Price_Per_Unit_Auto_Drip $ 79.99 $ 79.99 Price_Per_Unit_French_Press $ 55.99 $ 55.99 Fixed_Costs_Single_Cup $ 200,000.00 $ 180,000.00 Fixed_Costs_Auto_Drip $ 260,000.00 $ 240,000.00 Fixed_Costs_French_Press $ 180,000.00 $ 150,000.00 Variable_Unit_Single_Cup $ 79.00 $ 74.00 Variable_Unit_Auto_Drip $ 52.00 $ 48.00 Variable_Unit_French_Press $ 39.00 $ 35.00 Result Cells: Profit_per_Unit_Sold_Single_Cup $8.49 $14.74 Profit_per_Unit_Sold_Auto_Drip $7.19 $12.79 Profit_per_Unit_Sold_French_Pre $5.38 $11.31 Notes: Current Values column represents values of changing cells at time Scenario Summary Report was created. Changing cells for each scenario are highlighted in gray.
Image of page 11

Subscribe to view the full document.

Raise Prices 10% $ 109.99 $ 87.99 $ 60.99 $ 200,000.00 $ 260,000.00 $ 180,000.00 $ 79.00 $ 52.00 $ 39.00 $18.49 $15.19 $10.38
Image of page 12
Profit per Unit Sold Row Labels Single Cup Auto Drip French Press No Change $8.49 $7.19 5.38 Raise Prices 10% $18.49 $15.19 10.38 Subcontract $14.74 $12.79 11.31 No Change Raise Prices 10% Subcontract $0.00 $2.00 $4.00 $6.00 $8.00 $10.00 $12.00 $14.00 $16.00 $18.00 $20.00 Single Cup Auto Drip French Press
Image of page 13

Subscribe to view the full document.

Cortona Coffee Makers - Product Mix Single Cup Automatic Drip French Press Revenues Units Sold 16,000 12,500 15,500 Price Per Unit $ 99.99 $ 79.99 $ 55.99 Total Sales $ 1,599,840.00 $ 999,875.00 $ 867,845.00 Cost of Goods Sold Units Manufactured 16,000 12,500 15,500 Fixed Costs $ 200,000.00 $ 260,000.00 $ 180,000.00 Variable Cost per Unit $ 79.00 $ 52.00 $ 39.00 Variable Costs $ 1,264,000.00 $ 650,000.00 $ 604,500.00 Total Costs $ 1,464,000.00 $ 910,000.00 $ 784,500.00 Total Profit $ 135,840 $ 89,875 $ 83,345 Profit per Unit Sold $8.49 $7.19 $5.38
Image of page 14
You've reached the end of this preview.
  • Spring '17
  • total variable costs, Cortona Coffee Makers

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern