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 mean flow time, Jane Reed bakes breads and cakes in her home for pa...

Jane Reed bakes breads and cakes in her home for parties and other affairs on a contract basis. Jane has only one oven for baking. One particular Monday morning she finds that she

Explain level of competitive intensity in an industry, According to Porter,...

According to Porter, what determines the level of competitive intensity in an industry?

Sub optimisation - operations function, Sub optimisation - Operations Funct...

Sub optimisation - Operations Function Another important issue raised by the systems approach is that of sub-optimisation. This is of considerable significance for managers, a

Descibe the stages of contract formation, Maria, who lives in Seattle, sent...

Maria, who lives in Seattle, sent Koji a letter via first class mail, stating, "Koji, I think your 2003 Ford SUV is worth $20,000. I will give you $20,000 cash for it." Koji receiv

Describe why you agree or disagree with the results, Write your formal anal...

Write your formal analysis of your Color Q self-assessment results. I will look for the following information What primary and secondary color type are you? (MY COLOR ARE GOL

How is the chase demand strategy opposite of level capacity, How is the cha...

How is the chase demand strategy opposite of level capacity? Chase demand strategies: Chase demand strategies are the totally opposite of level capacity in which the orga

Explain the steps involved in conducting a risk, Describe the steps involve...

Describe the steps involved in conducting a risk and opportunity assessment.

How the organization you researched could become productive, Make one solid...

Make one solid recommendation for how the organization you researched could become more productive by applying one of the lessons learned. Explain your rationale.

Explain repetition of new product, You are a consultant called in to estima...

You are a consultant called in to estimate the costs after the employees learn how to do a job more efficiently by repetition of new product. You find a company can produce a produ

Policies that contribute and relate main business objectives, How can a fir...

How can a firm's security policies contribute and relate to the six main business objectives? Give examples.

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