Excel Intermediate
Shavone05
ex_k-7.xlsxProfit
| Custom Bookcases | |||||||
| Hourly labor cost | $70.00 | ||||||
| Component cost | $55.00 | ||||||
| Hours per Unit | Components per Unit | Cost to Produce | Retail Price | Unit Profit | Units Produced | Total Profit | |
| Model A | 8.00 | 6 | $ 890.00 | $ 1,695.00 | $ 805.00 | 51 | $ 41,055.00 |
| Model B | 10.00 | 9 | $ 1,195.00 | $ 2,200.00 | $ 1,005.00 | 73 | $ 73,365.00 |
| Model C | 15.00 | 12 | $ 1,710.00 | $ 2,900.00 | $ 1,190.00 | 67 | $ 79,730.00 |
| Model D | 17.00 | 14 | $ 1,960.00 | $ 3,100.00 | $ 1,140.00 | 55 | $ 62,700.00 |
| Total Profit | $ 194,150.00 | ||||||
