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

Give specific example of all type of strategy marketing plan, Imagine that ...

Imagine that you are creating a marketing plan for a company that will sell motor scooters . As you consider the marketing program, what types of strategy should you consider inc

Explain the rival principles of distribution, Discuss the rival principles ...

Discuss the rival principles of distribution. Why is it necessary to have different views?

Product focused production system, Product Focused Production System ...

Product Focused Production System In this type of production processing, the production departments are organized according to the type of product / service being produced, a

What is the mixed strategies range, For the given matrix, what is the mixed...

For the given matrix, what is the mixed strategies range , Bob could make use  to dominate Middle ? Assume three Offices (A, B, and C) in downtown,  simultaneously decide whethe

What are the ways in which corporations can demonstrate, What are three way...

What are three ways in which corporations can demonstrate a sense of social responsibility?

Mgt455, Discuss an example of a work-related project that is able to be bro...

Discuss an example of a work-related project that is able to be broken down into structure, tasks, subtasks, and work packages, and why project management in the form of a CPM/PERT

Regal marine, Computer-Aided Design is one of the techniques used by Regal ...

Computer-Aided Design is one of the techniques used by Regal Marine in the manufacturing of boats. With the aid of examples, critically discuss FIVE (5) techniques that are import

Describe what order quantity is optimal, The manager of a car wash received...

The manager of a car wash received a revised price list from the vendor who supplies soap, and a promise of a shorter lead time for deliveries. Formerly the lead time was four days

Describe schedule of matches for the couples, Chris Lane, the head professi...

Chris Lane, the head professional at Royal Oak Country club, must develop a schedule of matches for the couples' golf league that begins its season at 4PM tomorrow. Eighteen couple

I need to describe forecasting, I need to explain forecasting, also how it ...

I need to explain forecasting, also how it is performed at St. Arnold's Brewery (Houston, TX) also what forecasting error is and if there has been any in the past.

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