teamcdatasheet.w3.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 | 10,000 | 15,000 |
| | Likely | 20,000 | 15,000 |
| | Optimistic | 30,000 | 15,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 |
| | Likely | 20,000 | 18,000 |
| | Optimistic | 30,000 | 18,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 |
| | Likely | 20,000 | 20,000 |
| | Optimistic | 30,000 | 20,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 |
| | Likely | 20,000 | 24,000 |
| | Optimistic | 30,000 | 24,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 |
| | Likely | 20,000 | 28,000 |
| | Optimistic | 30,000 | 28,000 |
Question 4
| Order Quantity |
| Purchase Cost per unit | $ 16.00 |
| | Sales | | Order Quantity | Total Cost | Total Revenue | | Profit |
| | | | | | @ $24.00 | @ $5.00 |
| | Pessimistic | 10,000 |
| | Likely | 20,000 |
| | Optimistic | 30,000 |
ttonkin
