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

Define evaluation of the merits or reliability of the source, Share a sourc...

Share a source you are planning to use in writing your Resource Scheduling Methods Analysis Paper. Provide an APA citation for the source. Provide a brief summary of the source, an

Explain intent or motive behind sexual harassment activities, Should be int...

Should be intent or motive behind Lewiston's conduct be considered when deciding sexual harassment activities? Explain

Describe katie''s liability, Katie is a 17-year-old (a minor) who graduated...

Katie is a 17-year-old (a minor) who graduated from high school two months ago. In August, she started attending a university 150 miles from home and has contracted to rent an apar

Logical process modelling, What is logical process modelling? What is physi...

What is logical process modelling? What is physical modelling?

Product layout, how to identify layout ex holidays resort

how to identify layout ex holidays resort

Explain stock outstanding, Assume a company has 10 million shares of stock ...

Assume a company has 10 million shares of stock outstanding and that its Income Statement for Year 12 is as follows: Income Statement Data Year 12 (in 000s) Net Revenues from Footw

Order losers - operations strategy, Order Losers - Operations Strategy ...

Order Losers - Operations Strategy These are characteristics which denote poor performance in the operations management function and can cause losses in current or future busi

The budget projections for the cost of computer hardware, The final element...

The final element of the information systems plan specifies resources required to carry it out. The capital budget should include projections for the cost of computer hardware, net

Explain value-based and manufacturing-base, Discuss how a fast-food restaur...

Discuss how a fast-food restaurant could measure its quality effectiveness using each of the following definitions of quality; product-based, user-based, value-based, manufacturing

Explain implementation and communication of a strategic plan, Why is it imp...

Why is it important to continuously update the implementation and communication of a strategic plan? Who should be responsible for updating and communicating a strategic plan? Why?

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