Written Assignment
CAsky
ProfitModel-DataforAnalysis.xlsxSheet1
| Profit Model | ||||
| Model Inputs | ||||
| Unit Price | $1,000.00 | |||
| Unit Cost | $600.00 | |||
| Fixed Cost | $50,000.00 | |||
| Demand | 140 | |||
| Model | ||||
| Unit Price | $1,000.00 | |||
| Quantity Sold | 140 | |||
| Revenue | $140,000.00 | |||
| Unit Cost | $600.00 | |||
| Quantity Produced | 140 | |||
| Variable Cost | $84,000.00 | |||
| Fixed Cost | $50,000.00 | |||
| Profit | $6,000.00 | |||
| Quantity Produced ( 120 ) | Quantity Produced (130 ) | Quantity Produced ( 140 ) | Quantity Produced (150 ) | Quantity Produced (160 ) |
| -$4,077.20 | -$2,668.80 | -$1,260.40 | -$4,983.00 | -$8,705.60 |
