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

Pressume that a security model is needed for the protection, Assume that a ...

Assume that a security model is needed for the protection of information in your class. Using the CNSS model, examine each of the cells and write a brief statement on how you would

Explain if a wireless signal collides with an object, If a wireless signal ...

If a wireless signal collides with an object whose dimensions are much larger than the signal's wavelength, what is the signal most likely to do? a. reflect b. refract c.

Explain does not fall in the resulting confidence interval, If the point es...

If the point estimate in a paired difference estimation example does not fall in the resulting confidence interval, the decision maker can conclude that the two populations likely

What are individual and group decisions, What are individual and group deci...

What are individual and group decisions? Individual decisions are taken through a single individual in context of routine decisions whether guidelines are already given. Group

Explain major organizational characteristics, How would you go about analyz...

How would you go about analyzing an organizational structure in terms of creating a work breakdown structure? What are the major organizational characteristics that you would evalu

Is focused factory concept applicable in service sector, Is the 'focused fa...

Is the 'focused factory' concept described by Skinner applicable in the service sector? Answer:  Yes, think of Schmenner's service-process matrix and the lower quadrant entitled

Explain enable them to limit the probability of a stockout, A wine company'...

A wine company's daily demand is normally distributed with a mean of 18 bottles, and a standard deviation of 4 bottles. This company checks their winery's stock every 30 days. In t

How marketing consultant brought in to help a company, Imagine you are a ma...

Imagine you are a marketing consultant brought in to help a company who has a product that is so successful they cannot keep up with customer demand. What questions would you as

Discuss-incorporation is no longer the special privilege, "...incorporation...

"...incorporation is no longer the special privilege it once was". Discuss this statement. Does it have any impact on businesses (those not incorporated?)

Explain principles of delegation, Explain principles of delegation The...

Explain principles of delegation The Principles of Delegation are as follows:- (i) Parity in between responsibility and authority - There must be complete parity between

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