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

How to promote a business senior village, Have to set up a Blog for the my ...

Have to set up a Blog for the my inanganiry business, The Business is called "Senior Village" its a whole city in a gated community, the Seniors will not have to leave the grounds

Explain compensation as a motivator of behavior, 1. Does your company's com...

1. Does your company's compensation plans help to attract and retain people with the right skills, knowledge and motivation to help the company succeed? Explain.Company;NYC Dept. f

Describe how cultural diversity can affect the functioning, Explain how cul...

Explain how cultural diversity can affect the effective functioning of virtual teams operating in a global economy Assess a company's marketing strategy, with a focus on marketing

Explain sarbanes-oxley act promote ethical behaviour, Identify three of the...

Identify three of the criminal penalties that can be charged under the Sarbanes-Oxley Act. How do these sections of the Sarbanes-Oxley Act promote ethical behaviour by corporations

Discuss about the holding inventory control systems, Discuss about the Hold...

Discuss about the Holding Inventory Control Systems. Holding Inventory Control Systems: Holding great levels of inventory enables an organisation to be extra flexible to

Explain what is the college education fee, On the day his son was born, a f...

On the day his son was born, a father decided to establish a fund for his son's college education. The father wants the son to be able to withdraw $4000 from the fund on his 18th b

Explain average inventory level, 1. Custom Computers, Inc. assembles custom...

1. Custom Computers, Inc. assembles custom home computer systems. The fan assemblies needed are bought for $24 each and are ordered in quantities of 1500 units. Annual demand is 75

Management information Systems, my instructor gave a diagram depicting om p...

my instructor gave a diagram depicting om processess of a manufacturing company. from that diagram he wants me to identify specific data fields that likely compromise each of the f

Limitations of basic wage rate, What is the concept of comparative norm in ...

What is the concept of comparative norm in determining the basic wage rate? Why there are limitations to this approach? What has led companies to grant various forms of individual

What is the capacity represented by dso, What is the capacity represented b...

What is the capacity represented by "DSO"? a. 56Kbps b. 64 Kbps c. 255 Kbps d. 768 Kbps

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