Formulate an ilp model to determine how many units of

Assignment Help Business Management
Reference no: EM13781774

A company manufactures three products: A, B, and C. The company currently has an order for three units of product A, 7 units of product B, and 4 units of product C. There is no inventory for any of these products. All three products require special processing that can be done on one of two machines. The cost of producing each product on each machine is summarized below:

 

Cost of producing the unit a b c
Machine

1 13 9 10
2 11 12 8

The time required to produce each product on each machine is summarized below:

Machine hours needed      
Machine a b C
1 .4 1.1 .9
2 .5 1.2 1.3

Assume that machine 1 can be used for eight hours and machine 2 can be used for six hours. Each machine must undergo a special setup operation to prepare it to produce each product. After completing this setup for a product, any number of that product type can be produced. The setup costs for producing each product on each machine are summarized below.

Set up Costs      
Machine a b c
1 55 93 60
2 65 58 75

a. Formulate an ILP model to determine how many units of each product to produce on each machine to meet demand at a minimum cost.

b. Implement your model in a spreadsheet and solve it.

c. What is the optimal solution? 

 

Reference no: EM13781774

Questions Cloud

Arizona health care cost containment system : She is underinsured, and the cost of a surgery would be beyond her means without some sort of write-off or assistance. However, her family makes too much to qualify for Arizona Health Care Cost Containment System (AHCCCS).
Write a draft paper about addicted to social media : Write a draft paper about "Addicted to social Media".
Violated the agreement : Facts: Davis apprenticed himself to Mason, a surgeon/apothecary in Thetford, England. They agreed that if Davis left the practice, he would not set up a competing establishment within 10 miles of Thetford within 14 years. Davis promised to pay 200 po..
Considered an unethical buzz marketing strategy : Which of the following is NOT considered an unethical buzz marketing strategy? The difference between distribution centers and storage warehouses is that distribution centers are designed to ________. Which of the following types of sales promotions ..
Formulate an ilp model to determine how many units of : A company manufactures three products: A, B, and C. The company currently has an order for three units of product A, 7 units of product B, and 4 units of product C. There is no inventory for any of these products. All three products require special p..
Write a paper on the poem love in place by nikki giovanni : Write a 1,050- to 1,400- word paper based on a close reading of the poem Love in Place By Nikki Giovanni. Include your interpretation of the poet's thoughts and feelings, along with details.
What information federal agencies have about grapple : Grapple Market Share Corporation would like to know what information federal agencies have about Grapple's operations, so that the firm will know what its competitors may be able to learn about it. Can Grapple require the agencies to dis­close whatev..
Identify a company that is no longer in business : Identify a company that is no longer in business. What critical data within this organization may have contributed to its downfall? Was this a business of which you were a customer? Do you believe this company would be still around if it had approach..
Elements of thought to a personal experience : Evaluate the various elements of thought and relate these elements of thought to a personal experience in which you had to evaluate a situation using those elements of thought.

Reviews

Write a Review

Business Management Questions & Answers

  Temporary difference and permanent differencewhy is it

temporary difference and permanent differencewhy is it important to understand the difference between an originating

  Explain chain analysis is useful at the business level

Explain chain analysis is useful at the business level to highlight specific activities in the business where information systems are most likely to have a strategic impact

  Estimate the sustainability of long-term business operations

Estimate the sustainability of long-term business operations. Describe how the global market affects business strategy.

  The listed cas board members is with the boeing company

From the e-Activity, one of the listed CAS board members is with the Boeing Company, an international airline and aerospace company. Analyze two (2) possible extra-contractual motivators that Boeing might consider when bidding on future military cont..

  Explaining favoritism and bounded ethicality

Research the driving forces behind his seemingly unethical behavior and discuss your findings. How did favoritism and bounded ethicality come into play in this case?

  Replacing striking workers

n 1981, President Ronald Regan fired striking air traffic controllers and kept air traffic going with replacement controllers. Since then the practice of replacing striking workers with replacement workers has been used on several occasions.

  Dealing with conflicts in leadershiplars larsen was your

dealing with conflicts in leadershiplars larsen was your first boss at the medical center. you had problems from the

  Explain the forecasters sensitize to cultural patterns

Forecasters sensitize to cultural patterns - What product category interactions are indicative of the Zeitgeist?

  System and structure analysis

Show and discuss the mission statement of the organization in a narrative. You should quote the mission statement and cite the source in APA format.

  Compare and contrast team leadership

Compare and contrast team leadership and small business management.

  Memo of a pet peeveplease write a memo about one of your

memo of a pet peeveplease write a memo about one of your pet peeves using the guidelines from cialdini conger andor

  Human resources- workforce mangement and workforce

human resources- workforce mangement and workforce developmentworkforce management and workforce development plays a

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