Below is the profit model spreadsheet for a shoe manufacturer in the month of January.
1) Calculate the revenue for units sold.
2) Calculate the variable cost of production.
3) Calculate the total profit
|
Profit Model for January
|
Cost in Dollars
|
|
Unit Price
|
49
|
|
Unit Cost
|
23
|
|
Fixed Cost for Production
|
350,000
|
|
Demand
|
40,000
|
|
|
|
|
Model
|
|
|
|
|
|
Unit Price
|
49
|
|
Quantity Sold
|
38,000
|
|
Revenue
|
|
|
|
|
|
Unit Cost
|
23
|
|
Quantity Produced
|
38,000
|
|
Variable Cost
|
|
|
Fixed Cost
|
300,000
|
|
|
|
|
Profit
|
|