Question: Expedition Outfitters manufactures a variety of specially clothing for hiking, skiing and mountain climbing. The company has decided to begin production on two new parkas designed for use in extremely cold weather: The Mount Everest Parka and the Rocky Mountain Parka. Expedition's manufacturing plant has 120 hours of cutting time and 120 hours of sewing time available for producing these two parkas. Each Mount Everest Parka requires 30 minutes of cutting time and 45 minutes of sewing time, and each Rocky Mountain Parka requires 20 minutes of cutting time and 15 minutes of sewing time. The labor and material cost is $150 for each Mount Everest Parka and $50 for each Rocky Mountain Parka, and the retail prices through the firms mail order catalog are $250 for the Mount Everest Parka and $200 for the Rocky Mountain Parka. Because management believes that Mount Everest Parka will enhance the image of the firm, at least 20% of the total production must consist of this model. Assuming that Expedition can sell as many coats of each type as it can produce, how many units of each model should it manufacture to maximize the total profit contribution?
a- formulate an LP model to find the number of units of each product to be produced to maximize the profit.
b- develop an excel spreadsheet model to find the optimal solution.