Question: A company has decided to use 0 1 integer programming to help make some investment decisions. There are three possible investment alternatives from which to

A company has decided to use 01 integer programming to help make some investment decisions. There are three possible investment alternatives from which to choose, but if it is decided that a particular alternative is to be selected, the entire cost of that alternative will be incurred (i.e., it is impossible to build one-half of a factory). The integer programming model is as follows:
Maximize 5000 X1+7000X2+9000X3
Subject to: X1+ X2+ X3<=2 Constraint 1
-X1+ X2<=0 Constraint 2
25,000 X1+32,000 X2+29,000 X3<=62,000(budget limit)
16 X1+14 X2+19 X3<=36(resource limitation)
all variables =0 or 1
where X1=1 if alternative 1 is selected, 0 otherwise
X2=1 if alternative 2 is selected, 0 otherwise
X3=1 if alternative 3 is selected, 0 otherwise
Solve the problem using the Excel Template provided in Module 6 Brightspace.
Table 10-3 presents an integer programming problem. What is true about Constraint 1 and the optimal objective function? PLEASE SOLVE IT IN EXCEL

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!