Instructions: Use the information given below to set up and solve an LP, solve in excel using Solver, and provide the manager with the relevant information needed to make the optimal decision about how to move forward.

Expedition manufacturers a variety of specialty clothing for 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. Expeditions manufacturing plant only has 120 hours of cutting time and 140 hours of sewing time available. There is plenty of material to make the coats, except the fact that the zipper union is on strike and there are only 340 zippers. Because management believes that the Mount Everest Parka is a unique coat that will enhance the image of the firm, management has specified that at least 80 of this model must be produced. Each Mount Everest Parka requires 30 minutes of cutting time and 45 minutes of sewing time; the Labor and Material cost is $150 and the retail price is $250. Each Rocky Mountain Parka requires 20 minutes of cutting time and 15 minutes of sewing time; the Labor and Material cost is $50 and the retail price is $200. How many units of each model should be produced?