Manufactures a variety of specially clothing for hiking

Assignment Help Operation Management

Reference no: EM131420017

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.

please indicate the excel spreadsheet model which is the most needed.

Reference no: EM131420017

Questions Cloud

Diversification is most frequently associated with strategy : When a company purchases another business that does something different from what the purchasing company does, the purchasing company is using a strategy of. Diversification is most frequently associated with a strategy of.

Health care administrators keep patient well-being : How can health care administrators keep patient well-being at the forefront of their priorities and decision making. Discuss practical ideas, concrete suggestions, and, where possible, give practical examples.

Describe the culture of corporate retail sales organizations : How would you describe the culture of Corporate Retail Sales organizations ? What are the things that you can point to in your organization that contribute to your conclusion? If you had the ability to change something, what would it be and why?

Company is considering entering the argentinean market : Imagine you are the marketing manager for a U.S. manufacturer of paper products (including paper plates, paper towels, napkins, toilet paper, and tissues). Your company is considering entering the Argentinean market.

Manufactures a variety of specially clothing for hiking : 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 Roc..

Influence training and development professionals : Of the trends (e.g. technology, workforce diversity, big data, mobile learning, etc.), which two or three do you think will influence Training and Development professionals in organizations the most in the next decade?

A days worth of routine message : For this discussion thread you will refer to the Case Scenario “A Day’s Worth of Routine Message” on page 134 in your textbook. Read the case scenario in its entirety. Then, go to Task #4 on page 135 under the header “Spending a Few Moments to Create..

Use inductive and deductive reasoning in decision-making : As a manager, when and how would you use inductive and deductive reasoning in decision-making? Is there a time when it would be preferable to use one but not the other? Justify your response using a scholarly source.

Using effective vocal delivery in a professional context : Suggest three (3) reasons for using effective vocal delivery in a professional context. Next, consider two (2) possible consequences of failing to use effective vocal delivery in a professional context.

User Account

All Pages