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
One of the limitations to FreshPet products is the product must be refrigerated in the store, which limits the number and types of retailers that will adopt the product.  Mo
As the project manager, how do you change the culture? How do you ensure that your project is completed? What type of leadership style might work in this organizational sett
What is business, society, and stakeholders? How do they relate and interact together? Why should business organization build positive and mutually beneficial relationships
The Valley Wine Company produces two types of wine-Valley Nectar as well as Valley Red. The wines are produced from 64 tons of grapes the company has acquired this season.
Stock Values The next dividend payment by Mosby, Inc., will be $2.45 per share. The dividend are anticipated to maintain a 5.5 growth rate, Forever. If the stock currently s
Your employer has tasked you with designing a social networking website. You are free to design either a blog, a micro-blog, or a wiki. Create visual representations of
Select a topic with which you are familiar that involves making a decision. Prepare an argument in which you label each of these parts: In what kind of sphere is the decisio
1. What target market or markets can you identify for Wilson? How could she forecast sales for her service in each market? 2. What advantage does her business have over existi