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

Analyse the cost - benefits and resources , Undertake Systems based analysi...

Undertake Systems based analysis, including: i. Developing a systems based diagnosis of the ‘situation'; ii. Analyse one or more processes which are considered to be problem

How to perform a decision tree analysis for problem, Mountain States Electr...

Mountain States Electric Service is an electrical utility company serving several states in the Rocky Mountains region. It is considering replacing some of its equipment at a gener

Explain what use of the term sale rather than demand presume, What does use...

What does use of the term sales rather than demand presume?

Explain what price would you try to negotiate, You have just received 10 un...

You have just received 10 units of a special sub assembly from an electronics manufacturer at a price of $250 per unit. A new order has also just come in for your computer's produc

Explain three major important roles of entrepreneurship, Describe three maj...

Describe three major important roles of entrepreneurship in the American economy.

Explain what is the horizon value, Current and projected cash flows for Ran...

Current and projected cash flows for Randell Global Operatons are shown below. Growth is expected to be constant after 2012, and the weighted average cost of capital is 11%. What i

Explain traditional inventory models, The information technology department...

The information technology department of State University buys paper for its copier machine frequently. The office manager would like to determine the best quantity to order each

Major concerns confronting thomas regarding the management, Analyze the thr...

Analyze the three primary concerns confronting Thomas regarding the management of this project. Suggest a method of addressing each of the three concerns

What are some merits of a pay-for-knowledge pay system, What are some advan...

What are some advantages of a pay-for-knowledge pay system?

Outline one attribute or capacity of servant leadership, 1 Address the foll...

1 Address the following questions and concepts: 1) Describe one attribute or capacity of servant leadership and explain how and where you might apply this pri

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