Explain what is the optimal solution, Operation Management

Assignment Help:

Kentwood Electronics manufactures three components for stereo systems: CD players, tape decks, and stereo tuners. The wholesale price and manufacturing cost of each item are: Component Wholesale Price Manufacturing Cost CD Player $150 $75Tape Deck $85 $35Stereo Tuner $70 $30Each CD player produced requires three hours of assembly; each tape deck requires two hours of assembly; and each tuner requires one hour of assembly. However, the company manufactures these products only in batches of 150 - partial batches are not allowed. The marketing department believes that it can sell no more than 150,000 CD Players, 100,000 tape decks, and 90,000 stereo tuners. It expects a demand for at least 50,000 units of each item and wants to be able to meet this demand. If Kentwood has 400,000 hours of assembly time available, how many batches of CD players, tape decks, and stereo tuners should it produce to maximize profits while meeting the minimum demand figures supplied by marketing? A. Formulate an ILP model for this problem. (Hint: Let your decision variables represent the number of batches of each item to produce.)B. Create a spreadsheet model for this problem and solve it. C. What is the optimal solution? I have quite a bit of this done, but I don't see where I can put an attachment up. Please let me know if you can help.


Related Discussions:- Explain what is the optimal solution

Describe presence of an outside threat correlates, Some people argue that t...

Some people argue that the presence of an outside threat correlates with high degree of team cohesion. Would you agree or disagree?

Explain benefits of free international trade, What are the benefits and dis...

What are the benefits and disadvantages of free international trade for the United States? Examples would be helpful also.

Order winning and order qualifying criteria, 1. What you think might be the...

1. What you think might be the order winning and order qualifying criteria for: McDonald's, Southwest Airlines and a university?  Answer:

Molecular response to thyroid hormones, Molecular Response to Thyroid Hormo...

Molecular Response to Thyroid Hormones during Metamorphosis Thyroid hormones can cause obtainable tissues to break down or can remold the tissues to their adult function. The

Describe the basic idea underlying the contingency view, Explain the basic ...

Explain the basic idea underlying the contingency view

Activities relating to production system designing, Activities Relating to ...

Activities Relating to Production System Designing Decision relating to the production system design is the firm and foremost activity of the production management. This activi

Political risk for an organisation, Identify, with examples, groups that ma...

Identify, with examples, groups that may represent a significant political risk for an organisation that is considering engaging in Foreign Direct Investment.  When companies a

Describe does anyone have a screenshot of page, Does anyone have a screensh...

Does anyone have a screenshot of page 91 so that I can do question 3.14? My book has not come in yet and the eBook trail that I have been using does not have that question in it. I

Explain how the employees effectively execute strategy, Select a company th...

Select a company that you believe uses employees to achieve a competitive advantage. Discuss how the employees effectively execute the strategy and how the company can sustain this

Calculate annual breakeven number of meals, The restaurant would serve dinn...

The restaurant would serve dinner Tuesday through Saturday. Brian has noticed a restaurant for lease. The restaurant has seven tables, each of which can seat four. Tables can be mo

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd