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 types of organizational culture, Choose two specific features of or...

Choose two specific features of organizational structure described in chapters 5, 6, 8, and/or 9 and discuss how these specific features might lead to specific types of organizatio

Explain terminals and arrive at a message concentrator, Messages are transm...

Messages are transmitted from low speed terminals and arrive at a message concentrator at a Poisson rate of 600/hr. They are held in a buffer until a hi-speed trunk line is free to

Explain breakeven point in dollars of sales, A firm is selling two products...

A firm is selling two products, chairs and bar stools, each at $50 per unit. Chairs have a variable cost of $25 and bar stools $20 Fixed cost for the firm is $200 a. if the sales m

Describe fully and provide citations, On February 1, Mary verbally agrees t...

On February 1, Mary verbally agrees to work as a businessperson on a temporary basis for the firm of Blacke & Blewe, P.C. The job that Mary is assigned to do will take eight months

Explain first-line supervisor understand the organization, Why should a fir...

Why should a first-line supervisor understand the organization's objectives?

Explain unethical behaviour proposed by saul gellerman, Of the four commonl...

Of the four commonly held rationalizations for unethical behaviour proposed by Saul Gellerman, which one do you thing gets use most often? Why?

[email protected], Modelling – meaning and process, Certainty and uncertainty...

Modelling – meaning and process, Certainty and uncertainty in models, importance of understanding data before modelling , modelling with spreadsheet in simple decision situations.

Define productivity percentage change for each category, 1 Eric Johnson mak...

1 Eric Johnson makes billiard balls in his New England plant. With recent increases in his costs, he has a newfound interest in efficiency. Eric is interested in determining the pr

Determine the supply and aggregate supply curve , In the food processing se...

In the food processing sector of a country, 100 identical small firms produce frozen fruits. Each producer is a price-taker in the market and faces the following cost conditions:

Explain what is the formula for calculating duration, Answer the following ...

Answer the following questions (use MS Project help if necessary)- Define effort-driven? Under what circumstances would you turn off effort driven scheduling? Use a real-w

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