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

How to determine the sample standard deviation, Determine the sample standa...

Determine the sample standard deviation(s) for the following data: 7, 9, 2, 0, 1, and 5. s = 2.805 s = 3.266 s = 2.927 s = 3.578

Explain matching supply with demand, From "Matching Supply with Demand" Cac...

From "Matching Supply with Demand" Cachon/Terwiesch (Inventory Cost) A manufacturing company producing medical devices reported $60,000,000 in sales over the last year. At the e

Explain complete the forward and backward pass, You are creating a customer...

You are creating a customer database for Winston-Salem Warthogs minor league baseball team. Draw a project network given the information below. Complete the forward and backward pa

Factors that influence the role played by operations manager, 1. Having con...

1. Having considered the changes in agriculture and manufacturing sectors in the industrial era, speculate what might happen to the service sector in the post-industrial era. What

Explain drink equally appealing to men, Do you think Diet Coke could have b...

Do you think Diet Coke could have been repositioned to change consumers' perceptions of it enough to be considered a drink equally appealing to men? Why or why not?

Compute the reorder point, The Norwitch Company uses a continuous review (s...

The Norwitch Company uses a continuous review (s, Q) system for inventory control.  Weekly demand for an item, Pressure Valve #5 (PV5), is distributed Normally with a mean and stan

Explain cause and effect diagram and pareto analysis, What are the advantag...

What are the advantages and disadvantages of using a Cause and Effect diagram and Pareto Analysis in terms of analyzing quality issues? Respond to at least two of your classmates'

Describe modern healthcare systems, Discuss the Chaos Theory (Be sure to re...

Discuss the Chaos Theory (Be sure to read the lectures concerning this theory, as well as go through the additional links) in relation to the health care system today. In addition,

Explain responsibility towards importers and exporters, The U.S. State Depa...

The U.S. State Department has some responsibility towards Importers and Exporters. What are these responsibilities?

Explain what is the current capacity flow chart for cpc, Define the product...

Define the product you will be offering at College Pretzel Company (CPC) in detail. Create any necessary documentation such as an engineering drawing or a bill of material for the

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