The Morton Supply Company produces clothing, footwear, and accessories for dancing and gymnastics. They produce three models of pointe shoes used by ballerinas to balance on the tips of their toes. The shoes are produced from four materials: cardstock, satin, plain fabric, and leather. The number of square inches of each type of material used in each model of shoe, the amount of material available, and the profit/model are shown below:
Q: The Morton Supply Company produces clothing, footwear, and accessories for dancing and gymnastics. They produce three models of pointe shoes used by ballerinas to balance on the tips of their toes. The shoes are produced from four materials: cardstock, satin, plain fabric, and leather. The number of square inches of each type of material used in each model of shoe, the amount of material available, and the profit/model are shown below:
| Material (measured in square inches) | Model 1 | Model 2 | Model 3 | Material Available |
| Cardstock | 12 | 10 | 14 | 1200 |
| Satin | 24 | 20 | 15 | 2000 |
| Plain fabric | 40 | 40 | 30 | 7500 |
| Leather | 11 | 11 | 10 | 1000 |
| Profit per model | $50 | $44 | $40 |
a) Generate the Answer Report using SOLVER in EXCEL. Then, clearly answer what is the optimal solution? What is the resulting profit?
b) Generate the Sensitivity Report for the model that you built. Interpret, in context, the Shadow Price for the Leather and the Satin constraints. Include units in your interpretations.
Step by step
Solved in 6 steps with 30 images
