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 uninformed aspiring international business executive, Our Internati...

Our International Management text cites in Reading 1.2 that:"U.S Management theories contain a number of idiosyncrasies not necessarily shared by management elsewhere" and then pro

Describe skills or abilities you would need to develop, "CIOs" Please respo...

"CIOs" Please respond to the following: •Assess the role of the CIO within any health care organization and describe the key characteristics a CIO would need to possess to be effec

Find the loss for a quality characteristic, A quality characteristic has a ...

A quality characteristic has a manufacturing specification (in cm) of 0.200 ± 0.05. Historical data indicate that if the quality characteristic takes on values larger than 0.25 cm

Make an aggregate plan using a spreadsheet, Helter Industries, a company th...

Helter Industries, a company that produces a line of women's bathing suits, hires temporaries to help produce its summer product demand. For the current four-month rolling schedule

Regional regulations and room of expansion, Regional Regulations and Room o...

Regional Regulations and Room of Expansion Regional Regulations: It is important to check at an early stage that the proposed location does not infringe any local regulat

Define diversification as a strategy, Diversification as a strategy. Con...

Diversification as a strategy. Consider GE and how large and global it is. What problems do you think GE's most senior executives encounter in trying to stay on top of all th

Explain the utilization and the efficiency of each situation, Determine the...

Determine the utilization and the efficiency for each of these situations: a. A loan processing operation that processes an average of 7 loans per day. The operation has a design c

EOQ model, Division X is growing and is in constant need of trained employe...

Division X is growing and is in constant need of trained employees. The demand rate for trained employees is relatively constant at 5 each month. The division can run a gaining p

Process planning procedure, Process Planning Procedure  The process pl...

Process Planning Procedure  The process planning procedure has the followings steps as shows in figure as

Explain wbs is referred to as, Generally speaking, the lowest level in the ...

Generally speaking, the lowest level in the WBS is referred to as: Answer Level 3 Level 4 Level 5 The work package

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