Question: Please solve this in Excle B D E F H L M N 0 P Q R Min 6000A + 10000B + 2000C + 7500D

Please solve this in Excle
B D E F H L M N 0 P Q R Min 6000A + 10000B + 2000C + 7500D + 15000E + 80x_A + 60x_B+ 110x_C + 75 x d +40 X E s.t. X_Ac=102 A X_B=350 E=0 X_A>=100A or X_A-100A>=0 x_i: integers, l: binary i A, B, C, D, E. A D Fixed Cost Variable Cost Unit Prod. Time (hrs) Capacity (hrs) B 6000 80 5 5 510 10000 60 6 480 2000 110 10 600 E 7500 75 4 15000 40 3 440 480 Demand 350 Decision variables X_A X_B X_C X_D X_E A B D E LHS sign RHS Coefficients -510 5 350 0 Objective (Min total cost) B D E F H L M N 0 P Q R Min 6000A + 10000B + 2000C + 7500D + 15000E + 80x_A + 60x_B+ 110x_C + 75 x d +40 X E s.t. X_Ac=102 A X_B=350 E=0 X_A>=100A or X_A-100A>=0 x_i: integers, l: binary i A, B, C, D, E. A D Fixed Cost Variable Cost Unit Prod. Time (hrs) Capacity (hrs) B 6000 80 5 5 510 10000 60 6 480 2000 110 10 600 E 7500 75 4 15000 40 3 440 480 Demand 350 Decision variables X_A X_B X_C X_D X_E A B D E LHS sign RHS Coefficients -510 5 350 0 Objective (Min total cost)Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
