Explain and formulate an linear programming model

Assignment Help Business Management

Reference no: EM1359218

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 shown in the following table:

CD Player $150 Price $75 Cost
Tape Deck $85 Price $35 Cost
Stereo Tuner $70 Price $30 Cost

Each CD player produced requires 3 hours of assembly; each tape deck requires 2 hours of assembly; and each tuner requires 1 hour of assembly. The marketing department has indicated that it can sell no more than 150,000 CD players, 100,000 tape decks and 90,000 stereo tuners. However, the demand is expected to be at least 50,000 units of each item, and Kentwood wants to meet this demand. If Kentwood has 400,000 hours of assembly time available, how many CD players, tape decks, and stereo tuners should it produce to maximize profits while meeting the minimum demand figures?

A) Formulate an linear programming model for this problem.

B) Create a spreadsheet model for this problem and solve it using Solver.

C) What is the optimal solution?

Reference no: EM1359218

Questions Cloud

Draw an entity-relationship for jcbc : Each team plays two games (home and visitor) against each of the other teams during the season and the score needs to be captured. Draw an entity-relationship for JCBC (in 3NF).

Industry and globalization : Choose two countries (other than the U.S.) within the same region of the world. Assess the political risks, economic risks, and legal risks of each country.

What is the minimum time necessary for crossing : What is the minimum time necessary for crossing.

Importance of active listening : Importance of Active Listening - Explain a time when you did not actively listen during either a professional or personal conversation.

Explain and formulate an linear programming model : Explain and Formulate an linear programming model for this problem and Create a spreadsheet model for this problem and solve it using Solver.

Determine stock selling price : The risk free rate of return, r RF, is 6%; the required rate of return on the market is 10%; and Upton Company's stock has a beta coefficient of 1.5.

Categories and diagnoses are mood disorders : The most common categories and diagnoses are mood disorders, anxiety disorders, personality disorder, schizophrenia, and addiction.

Elucidate how the sheepskin effect is analogous : one receives a higher salary with the successful completion of degrees or the earning of diplomas. Elucidate how the sheepskin effect is analogous to SIGNALING MODEL.

What is the average force his feet exert on the ground : Treating our rigid legged friend as a particle, what is the average force his feet exert on the ground when he slows down.

User Account

All Pages