Quantitative Assignment- Excel
Mark3433
Module2ProblemWorkbook.xlsxP3-26
| Manufacturing desks and chairs | |||
| Inputs | |||
| Desks | Chairs | ||
| Unit margins | |||
| Wood usage per unit | |||
| Decisions | |||
| Desks | Chairs | ||
| Units produced | |||
| Constraint on wood | |||
| Wood used | Wood available | ||
| Constraint on chairs | |||
| Chairs produced | Chairs required | ||
| Objective to maximize | |||
| Profit |
Problem 2.2
p3-34
| River pollutants | ||||||
| Factory 1 | Factory 2 | Factory 3 | ||||
| Cost/ton | ||||||
| Factory 1 | Factory 2 | Factory 3 | Reduction | Required | ||
| P1 | ||||||
| P2 | ||||||
| Processed | ||||||
| Total cost |
Problem 2.14
