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

Calculate the cost of cohen''s plan, Forrester and Cohen is a small account...

Forrester and Cohen is a small accounting firm, managerd by Joseph Cohen since the retirement in December of his parnter Brad Forrester. Cohen and his 3 CPA's can together bill 640

Application of operations research, application of operations research in m...

application of operations research in managerial decision making

Explain delays in the project mean that the center, Your in charge of a pro...

Your in charge of a project at the local community center. The center needs to remodel one of the room in time for the start of a new program. Delays in the project mean that the c

Explain what is the average number of customers in the bank, From 11:00 AM ...

From 11:00 AM to 12:00 Noon, 30 people arrive at a bank on average. When they enter they get in line to wait for a cashier. On average there are 3 customers in line waiting. On ave

Explain people discriminate when prejudice impacts their, People discrimina...

People discriminate when prejudice impacts their Answer beliefs. attitudes. intentions. behavior.

Explain what are the four major goals for it, What are the four major goals...

What are the four major goals for IT? How are the four goals achieved? How does the integration of IT improve the management of supply chains?

Give example of groupthink, You have been assigned the task of assembling a...

You have been assigned the task of assembling a team to accomplish some task or project in your organization. What do you do? What is important for you to know? What do you need to

Define in haifa israel its illegal to take what to the beach, In Haifa Isra...

In Haifa Israel its illegal to take what to the beach

Define the functional flexibility workforce, Define the functional flexibil...

Define the functional flexibility workforce. Functional flexibility (task flexibility or multi-skilled employees) associates breaking down traditional occupational restricti

Importance of performance measurement, Importance of performance measuremen...

Importance of performance measurement  1. Research reveals that many institutional investors are basing their decisions, in part, on a review of company's non financial perfor

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