MAT 540 Week 6 Discussion and Homework Quantiative Methods Strayer
xoon
hw6_answer_sheet_1.xlsxP2
| Product Lines | ||||
| Product #1 | Product #2 | |||
| Profits for each product | 6 | 4 | ||
| Total hours | Available hours | |||
| Time required on Line #1 | 10 | 10 | <= | 100 |
| Time required on Line #2 | 7 | 3 | <= | 42 |
| Product #1 | ||||
| Product #2 | ||||
| Maximized profits | ||||
| Please use graphic method to solve the problem | ||||
| Please enter your solution in Yellow cells |
P6 and P7
| Pinewood Furniture | ||||
| Table | Chair | |||
| Profits for each product | 100 | 400 | ||
| Resources | Available labor & material resources | Unused resources | ||
| Labor | 10 | 8 | <= | 80 |
| wood | 6 | 2 | <= | 36 |
| Chair demands | <= | 6 | ||
| Tables | Please enter unused resources for problem #7 | |||
| Chairs | ||||
| Maximized profits | ||||
| Please use graphic method to solve the problem | ||||
| Please enter your solution in Yellow cells |
P12
| Elixer Drug Company | ||||
| Ingredient #1 | Ingredient #2 | |||
| Profits for each product | 80 | 50 | ||
| Antibiotic amounts | Required antibiotics | |||
| Antibiotic #1 | 3 | 1 | >= | 6 |
| Antibiotic #2 | 1 | 1 | >= | 4 |
| Antibiotic #3 | 2 | 6 | >= | 12 |
| Ingredient #1 | ||||
| Ingredient #2 | ||||
| Minimized cost | ||||
| Please use graphic method to solve the problem | ||||
| Please enter your solution in Yellow cells |
P16
| Clothier | ||||
| Coats | Slacks | |||
| Profits for each product | 50 | 40 | ||
| Resources | Available Resources | |||
| Wool | 3 | 5 | <= | 150 |
| Labor | 10 | 4 | <= | 200 |
| Coat | ||||
| Slacks | ||||
| Maximized profits | ||||
| Please use graphic method to solve the problem | ||||
| Please enter your solution in Yellow cells |
P20
| Clothier | ||||
| x1 | x2 | |||
| weights | 5 | 8 | ||
| Resources | Available Resources | |||
| constraint #1 | 3 | 5 | <= | 50 |
| constraint #2 | 2 | 4 | <= | 40 |
| x1 | <= | 8 | ||
| x2 | <= | 10 | ||
| x1 | ||||
| x2 | ||||
| Z | ||||
| Please use graphic method to solve the problem | ||||
| Please enter your solution in Yellow cells |
