Practical Management Science
aaduarte
Sh03_33.xlsxModel
| Manufacturing two products | |||||
| Times (hours) needed to product each product on each machine | |||||
| Machine 1 | Machine 2 | ||||
| Product 1 | 0.4 | 0.3 | |||
| Product 2 | 0.7 | 0.4 | |||
| Demands and prices | |||||
| Demands | Prices | ||||
| Month 1 | Month 2 | Month 1 | Month 2 | ||
| Product 1 | 1000 | 1900 | $55 | $12 | |
| Product 2 | 1400 | 1300 | $65 | $32 | |
| Month 1 production | |||||
| Machine 1 | Machine 2 | Total | Market | ||
| Product 1 | |||||
| Product 2 | |||||
| Month 2 production | |||||
| Machine 1 | Machine 2 | Total | Market | ||
| Product 1 | |||||
| Product 2 | |||||
| Hours used per month | Available hours per month | ||||
| Machine 1 | Machine 2 | Machine 1 | Machine 2 | ||
| Month 1 | |||||
| Month 2 | |||||
| Total revenue |
Problem 2.13
