SuperFunAssignmentData.xlsx
Profit Projections
| Order Quantity | 15,000 |
| Purchase Cost per unit | $ 16.00 |
| | Sales | | Order Quantity | Total Cost | Total Revenue | | Profit |
| | | | | | @ $24.00 | @ $5.00 |
| | Pessimistic | 10000 | 15000 | $240,000 | $240,000 | $25,000 | $25,000 |
| | Likely | 20000 | 15000 | $240,000 | $480,000 | -$25,000 | $215,000 |
| | Optimistic | 30000 | 15000 | $240,000 | $720,000 | -$75,000 | $405,000 |
| Order Quantity | 18,000 |
| Purchase Cost per unit | $ 16.00 |
| | Sales | | Order Quantity | Total Cost | Total Revenue | | Profit |
| | | | | | @ $24.00 | @ $5.00 |
| | Pessimistic | 10,000 | 18,000 | $ 288,000 | $240,000 | $40,000 | -$8,000 |
| | Likely | 20,000 | 18,000 | $ 288,000 | $480,000 | $0 | $192,000 |
| | Optimistic | 30,000 | 18,000 | $ 288,000 | $720,000 | $0 | $432,000 |
| Order Quantity | 20,000 |
| Purchase Cost per unit | $ 16.00 |
| | Sales | | Order Quantity | Total Cost | Total Revenue | | Profit |
| | | | | | @ $24.00 | @ $5.00 |
| | Pessimistic | 10,000 | 20,000 | $ 320,000 | $240,000 | $50,000 | -$30,000 |
| | Likely | 20,000 | 20,000 | $ 320,000 | $480,000 | $0 | $160,000 |
| | Optimistic | 30,000 | 20,000 | $ 320,000 | $720,000 | $0 | $400,000 |
| Order Quantity | 24,000 |
| Purchase Cost per unit | $ 16.00 |
| | Sales | | Order Quantity | Total Cost | Total Revenue | | Profit |
| | | | | | @ $24.00 | @ $5.00 |
| | Pessimistic | 10,000 | 24,000 | $ 384,000 | $240,000 | $70,000 | -$74,000 |
| | Likely | 20,000 | 24,000 | $ 384,000 | $480,000 | $20,000 | $116,000 |
| | Optimistic | 30,000 | 24,000 | $ 384,000 | $720,000 | $0 | $336,000 |
| Order Quantity | 28,000 |
| Purchase Cost per unit | $ 16.00 |
| | Sales | | Order Quantity | Total Cost | Total Revenue | | Profit |
| | | | | | @ $24.00 | @ $5.00 |
| | Pessimistic | 10,000 | 28,000 | $ 448,000 | $240,000 | $90,000 | -$118,000 |
| | Likely | 20,000 | 28,000 | $ 448,000 | $480,000 | $40,000 | $72,000 |
| | Optimistic | 30,000 | 28,000 | $ 448,000 | $720,000 | $0 | $272,000 |
jttrsne3
