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 impact far beyond their firm boundaries, Multinational enterprises ...

Multinational enterprises (MNEs) have an impact far beyond their firm boundaries. Assume you are working for a small firm that supplies a product or service to an MNE. How might yo

Define conflict within a project team, What are the consequences of ignorin...

What are the consequences of ignoring a conflict within a project team?

What kind of transmission path does a fixed wireless signal, What type of t...

What type of transmission path does a fixed wireless signal require?

Define construct a stem-and-leaf display, Use the data in Exhibit 16-5 to c...

Use the data in Exhibit 16-5 to construct a stem-and-leaf display

Explain competencies required of hr management, Review the competencies req...

Review the competencies required of HR management and recommend at least two additional areas in which HR managers should be competent. Provide specific examples to support your re

Explain fiedler''s contingency model, Write a 500-750-word paper that analy...

Write a 500-750-word paper that analyzes the two leadership case studies, "Coach Knight: A Will to Win" and "Coach K: A Matter of the Heart." Address the following questions a

Lowest cost entry method, Lowest Cost Entry method s( LCEM) or Matrix Minim...

Lowest Cost Entry method s( LCEM) or Matrix Minima Method: Step1: Determine  the smallest  cost in  the cost matrix of the transportation table. Let it be ( C ij ). Allocate

Explain how will you account for any wastage, You are the branch operations...

You are the branch operations manager for a leading manufacturing company. The following are the bill of materials (BOM), Master Production Schedule, and Inventory Record Sheet for

Explain subcontractors for a government project want, The government spends...

The government spends a large amount of money each year on contracts. In fact, the federal procurement department spent over $425 billion in the fiscal year 2006 with over $33 mill

Explain google''s customer value proposition, Describe Google's customer va...

Describe Google's customer value proposition and profit formula linked to its business model. What strategies has Google relied upon to build competitive advantage in the industry?

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