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

User Account

All Pages