Quant Powerpoint
Sheet1
| Method I | Method II | Method III | Method I | Method II | Method III | Method I | Method II | Method III | ||||||
| Fixed Cost | 200,000 | 800,000 | 2,000,000 | Fixed Cost | 200,000 | 800,000 | 2,000,000 | Fixed Cost | 200,000 | 800,000 | 2,000,000 | |||
| VC | 40 | 10 | 2 | VC | 40 | 10 | 2 | VC | 40 | 10 | 2 | |||
| Production (Units) | 20000 | Production (Units) | 150000.00000001 | Production (Units) | 47368 | |||||||||
| Total Cost | 1000000 | 1000000 | 2040000 | Total Cost | 6200000.00000039 | 2300000.0000001 | 2300000.00000002 | Total Cost | 2094720 | 1273680 | 2094736 | |||
| I&II | II&III | I&III | I&II | II&III | I&III | I&II | II&III | I&III | ||||||
| Breakeven point | 0 | 1040000 | 1040000 | Breakeven point | -3900000.00000029 | 0 | -3900000.00000037 | Breakeven point | -821040 | 821056 | 16 | |||
| Units | Method I | Method II | Method III | |||||||||||
| 0 | 200000 | 800000 | 2000000 | |||||||||||
| 5000 | 400000 | 850000 | 2010000 | |||||||||||
| 10000 | 600000 | 900000 | 2020000 | |||||||||||
| 15000 | 800000 | 950000 | 2030000 | |||||||||||
| 20000 | 1000000 | 1000000 | 2040000 | |||||||||||
| 25000 | 1200000 | 1050000 | 2050000 | |||||||||||
| 30000 | 1400000 | 1100000 | 2060000 | |||||||||||
| 35000 | 1600000 | 1150000 | 2070000 | |||||||||||
| 40000 | 1800000 | 1200000 | 2080000 | |||||||||||
| 45000 | 2000000 | 1250000 | 2090000 | |||||||||||
| 50000 | 2200000 | 1300000 | 2100000 | |||||||||||
| 55000 | 2400000 | 1350000 | 2110000 | |||||||||||
| 60000 | 2600000 | 1400000 | 2120000 | |||||||||||
| 65000 | 2800000 | 1450000 | 2130000 | |||||||||||
| 70000 | 3000000 | 1500000 | 2140000 | |||||||||||
| 75000 | 3200000 | 1550000 | 2150000 | |||||||||||
| 80000 | 3400000 | 1600000 | 2160000 | |||||||||||
| 85000 | 3600000 | 1650000 | 2170000 | |||||||||||
| 90000 | 3800000 | 1700000 | 2180000 | |||||||||||
| 95000 | 4000000 | 1750000 | 2190000 | |||||||||||
| 100000 | 4200000 | 1800000 | 2200000 | |||||||||||
| 105000 | 4400000 | 1850000 | 2210000 | |||||||||||
| 110000 | 4600000 | 1900000 | 2220000 | |||||||||||
| 115000 | 4800000 | 1950000 | 2230000 | |||||||||||
| 120000 | 5000000 | 2000000 | 2240000 | |||||||||||
| 125000 | 5200000 | 2050000 | 2250000 | |||||||||||
| 130000 | 5400000 | 2100000 | 2260000 | |||||||||||
| 135000 | 5600000 | 2150000 | 2270000 | |||||||||||
| 140000 | 5800000 | 2200000 | 2280000 | |||||||||||
| 145000 | 6000000 | 2250000 | 2290000 | |||||||||||
| 150000 | 6200000 | 2300000 | 2300000 | |||||||||||
| 155000 | 6400000 | 2350000 | 2310000 | |||||||||||
| 160000 | 6600000 | 2400000 | 2320000 |
Method I 0 5000 10000 15000 20000 250 00 30000 35000 40000 45000 50000 55000 60000 65000 70000 75000 80000 85000 90000 95000 100000 105000 110000 115000 120000 125000 130000 135000 140000 145000 150000 155000 160000 200000 400000 600000 800000 1000000 1200000 1400000 1600000 1800000 2000000 2200000 2400000 2600000 2800000 3000000 3200000 3400000 3600000 3800000 4000000 4200000 44000 00 4600000 4800000 5000000 5200000 5400000 5600000 5800000 6000000 6200000 6400000 6600000 Method II 0 5000 10000 15000 20000 25000 30000 35000 40000 45000 50000 55000 60000 65000 70000 75000 80000 85000 90000 95000 100000 105000 110000 115000 120000 125000 130000 135000 140000 145000 150000 155000 160000 800000 850000 900000 950000 1000000 1050000 1100000 1150000 1200000 1250000 1300000 1350000 1400000 1450000 1500000 1550000 1600000 1650000 1700000 1750000 1800000 1850000 1900000 1950000 2000000 2050000 2100000 2150000 2200000 2250000 2300000 2350000 2400000 Method III 0 5000 10000 15000 20000 25000 30000 35000 40000 45000 50000 55000 60000 65000 70000 75000 80000 85000 90000 95000 100000 105000 110000 115000 120000 125000 130000 135000 140000 145000 150000 155000 160000 2000000 2010000 2020000 2030000 2040000 2050000 2060000 2070000 2080000 2090000 2100000 2110000 2120000 2130000 2140000 2150000 2160000 2170000 2180000 2190000 2200000 2210000 2220000 2230000 2240000 2250000 2260000 2270000 2280000 2290000 2300000 2310000 2320000