Formulating an ilp model

Assignment Help Operation Management
Reference no: EM13110158

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 CostCD 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.

Reference no: EM13110158

Questions Cloud

How are flowers of monocots different from those of dicots : In what way does the fertilization and development of the conifer seed differ from that of the angiosperm?
Explain the concept of bacterial evolution : Explain the concept of Bacterial Evolution. What are the main differences between the three groups of the Domains? (Archaea, Bacteria, and Eukarya)
Linear relationship between explanatory variables : Rewrite the model to show that this is in fact a two-variable model rather than a three-variable model. Define the parameters
Why would some microorganisms grow on the surface : Why would some microorganisms grow on the surface of some broth in a test-tube?
Formulating an ilp model : 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 CostCD Player.
Does the gymnosperm embryo use the same nutritive tissue : What further adaptations have gymnosperms made for life on land when compared with the ferns?
Research and evaluation : What value is business research and hypothesis testing to a company? How long should it take a company to complete a scientific research study?
Reviews the earnings of three divisions : A corporate CEO reviews the earnings of three divisions over the last eighteen months. Each division reports its earnings quarterly.
How role of human resources provide valuable advice : HR planning should be focused on helping the organization achieve its strategic intent, which derives from its vision. These strategies need to both service the short-term, operational concerns and the slightly longer-term strategic.

Reviews

Write a Review

Operation Management Questions & Answers

  Search the internet about the enron scandal

Search the Internet about the enron scandal , read and understand the story about the scandal , then after reading you will submit a reaction paper

  Riverside oil company in eastern kentucky produces

Riverside oil company in eastern Kentucky produces 3 different grades of gasoline. They are regular, premium, and supreme grades. Each barrel of regular grade sells for $82 while premium grade sells for $88 per barrel and supreme grade sells for $..

  Determine the level production rate

The forecasted demand for fudge for the next four months is 140,160,90 and 70 pounds. What is the recommended production rate if a level strategy is adopted with no back orders or stockouts?

  Assist with finding advertising appeals and persuading

What two ways would you appeal to the buying behaviors of this target market, and why? Based on this information, discuss with your colleagues the ways in which your company should segment the targeted customer groups to assist with finding adverti..

  R illustrate what range of demand would mechanized process

Over illustrate what range of demand would manual process be preferred over mechanized process. Over illustrate what range of demand would mechanized process be preferred over manual process.

  What types of people have more difficulty being team players

What types of people have more difficulty being team players? What helps promote good team player behavior? What do you think is more important for a good IT professional: strong technical skills or strong people skills?

  Creating c chart at 99.73 percent levels

Airlines lose thousands of checked bags every day, and America South Airlines is no exception to the industry rule. Over the past 6 weeks, the number of bags "misplaced" on America South flights has been 18, 10, 4, 6, 12, and 10.

  How mnc managers manage conflict

How do MNC managers manage conflict? Compare or contrast managing conflict resolutions using the instrumental-oriented conflict approach and the expressive-oriented conflict approach

  Nonaka theory of knowledge creation

Compare the models and information found with Nonaka's Theory of Knowledge Creation. Consider ways knowledge creation works in an organizations.

  Illustrate what are methods used to deal with capacity

Illustrate what is Capacity balance. Why is it hard to achieve. Illustrate what are methods used to deal with capacity imbalances.

  Find the best approach for small ebusiness customer service

After struggling to get the Wise Epicure started, I have taken my own advice and decided to hire people who can assist me in making my startup the strongest it can be.

  What is the annual total cost of continuing

Clement Bait & Tackle has been buying a chemical water conditioner for its bait (to help keep its baitfish alive) in an optimal fashion using EOQ analysis. The supplier has now offered Clement a discount of $0.50 off all units if the firm will mak..

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