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

Describe implications for the video game industry, Case Study- Implications...

Case Study- Implications for the Video Game Industry To consider the viability of Nintendo's new strategy, the CEO of Nintendo, has brought you in as a consultant. Your task is

Explain the principle helps in judgment, Your responses should be well-roun...

Your responses should be well-rounded and analytical and should not just provide a conclusion or an opinion without explaining the reason for the choice. For full credit, you need

Reduce failures and improve productivity, Question: What Maintenance po...

Question: What Maintenance policies to be done by the operations manager to reduce failures and improve productivity? • Emphasize on suitable maintenance practices. • Give a

Explain expects to perform the modifications to vehicles, Honda Motor Compa...

Honda Motor Company has discovered a problem in the exhaust system of one of its automobile lines and has voluntarily agreed to make the necessary modifications to conform with gov

#title., Ask questiondiscuss the advisability of using modular assemblies i...

Ask questiondiscuss the advisability of using modular assemblies in manufacturing. what are the advantages and disadvantages #Minimum 100 words accepted

Explain essentially relativism reject the notion, Essentially relativism re...

Essentially relativism reject the notion that there is are no absolutes that govern our behaviour. How then do we determine how we behave? How reasonable and plausible is this posi

Compensation and benefits employer can offer their employees, Compensation ...

Compensation and benefits; what are all that an employer can offer their employees? What kind of compensation? What kind of benefits?

Explain particulates and ph balance, Please give a detailed explanation for...

Please give a detailed explanation for the answer for the following scenario: You are a division manager of a manufacturing facility that produces waste? Water that must be treated

Explain the companys core competencies, As the end of the year comes to a c...

As the end of the year comes to a close, the CEO is evaluating Motorola's strategic approach and its ability to produce desired results for the company in the future. The CEO has a

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