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

Explain expected return on the market, Assume that the risk-free rate is 7....

Assume that the risk-free rate is 7.0% and the expected return on the market is 8%. What is the required rate of return on a stock with a beta of 1.4? Round your answer to two deci

Explain inefficiency factor, A JIT system uses kanban cards to authorize mo...

A JIT system uses kanban cards to authorize movement of incoming parts. In one portion of the system, a work center uses an average of 93 parts per hour while running. The manager

Describe concentrate on one source of competitive advantage, Do you think i...

Do you think it is better to concentrate on one source of competitive advantage (cost versus differentiation versus speed) or to nurture all three in a firm's operation?

How maximize total advertising revenue, A local television station plans to...

A local television station plans to drop four Friday evening programs at the end of the season. Steve Botuchis, the station manager, developed a list of six potential replacement p

Implementation of the cost of quality, Question: What are different con...

Question: What are different conditions which a company has to make sure before the implementation of the Cost of Quality? Description/Definition of cost of Quality • The

Define compare the effectiveness, Compare the effectiveness of 2 week, 4wee...

Compare the effectiveness of 2 week, 4week 6week. I just need the moving averages. For 2,4 and 6 weeks from managing operations across the supply chain book the question is startin

Generate a decision tree to help expando, Expando, Inc., is considering the...

Expando, Inc., is considering the possibility of building an additional factory that would produce a new addition to its product line. The company is currently considering two opti

Explain objectives of organisational development, Explain objectives of org...

Explain objectives of organisational development. Objectives of Organisational Development (i) Enhancement in the performance of the organisation. (ii) Enhancement in t

Explain methods of quantitative analysis, Name four methods of quantitative...

Name four methods of quantitative analysis that are useful in informing the facility location decision. How can each of the methods assist you in location decisions? Provide exampl

#operational performance, what are the 5 operational performance objectives...

what are the 5 operational performance objectives may influence decision making associated to process design and layouts

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