Formulate an ilp model to determine how many units of
Course:- Business Management
Reference No.:- EM13781774

Assignment Help
Expertsmind Rated 4.9 / 5 based on 47215 reviews.
Review Site
Assignment Help >> Business Management

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

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? 


Put your comment

Ask Question & Get Answers from Experts
Browse some more (Business Management) Materials
illustrate what ways might the cognitive and affective components of attitude influence the behaviour of employees who are faced with learning an entirely new set of compute
Discuss the process by which the patient in the case study is referred through the healthcare system from primary care to tertiary care and rehabilitation. What parts of thi
Document all of the steps needed to create a specific strategic group map for the beer industry. Then create a strategic group map, based upon the following industry definit
The after-tax cost of dept is 6.00%, the cost of preferred is 7.50%, and the cost of common using retained earnings is 12.75%. The firm will not be issuing any new stock. Wh
Analyze two global corporate citizenship efforts of the original company you selected, and assess the extent to which these efforts are effective in accomplishing the compan
Be thorough when discussing the following questions about e-business and entrepreneurial functions. Why is there a trend toward cross-functional integrated enterprise systems
Typical trading partners include the United States, Germany, and other countries in the European Union (EU). Exports include machinery, transportation equipment, petroleum,
For this week's discussion, pick an organization you are familiar with and discuss what competitive information do you think that organization should keep in mind when plann