| Materials and Labor Costs | | | | Resources Per Unit |
| | | | | | Custom Build | Standard Build |
| Hourly Rate | $ 12.10 | | | Labor (hours) | 15 | 4 |
| Primary Materials
per unit | $ 315.00 | | | Primary Materials per unit | 1 | 1 |
| Additional Materials per oz | $ 2.50 | | | Additional Materials (oz) | 25 | 11 |
| | | | | Selling Price | $ 750.00 | $ 450.00 |
| | Custom Build | Standard Build | | Material Constraints |
| # of Units Produced | 27 | 33 | | | Used | | Available |
| | <= | <= | | Labor (hours) | 537 | <= | 350 |
| Estimated Max Demand | 27 | 45 | | Primary Materials per unit | 60 | <= | 70 |
| | | | | Additional Materials (oz) | 1,038 | <= | 1100 |
| | Custom Builds | Standard Builds | Totals |
| Revenue |
| Costs |
| Labor |
| Primary Materials |
| Additional Materials |
| Profits |
| Saved Solver Model |
mk12345
Koza_Excel_BU05_PS2_ProductMix.xlsx
