Question: Please help! If you could go step by step or explain the excel process I would be very appreciative! I'm rather lost right now Kalyan

Please help! If you could go step by step or explain the excel process I would be very appreciative! I'm rather lost right now
Kalyan Singhal Corp. makes three products, and it has three machines available as resources as given in the following LP problem: Maximize contribution = 6X +8X2 +4X3 1X +7X +4X3 72 2X + 1X +7X3 76 8X + 4X + 1X3 72 X1, X, X3 20 (C: hours on machine 1) (C: hours on machine 2) (C3: hours on machine 3) a) Using a computer software for solving LP, the optimal solution achieved is: 6 (round your response to two decimal places). X = = X = 4.57 (round your response to two decimal places). X3 = 8.59 (round your response to two decimal places). Contribution (objective value) = 104.76 (round your response to two decimal places). b) Machine 1 has 0.00 hours of unused time available at the optimal solution (round your response to two decimal places). Machine 2 has 0.00 hours of unused time available at the optimal solution (round your response to two decimal places). Machine 3 has 0.00 hours of unused time available at the optimal solution (round your response to two decimal places). c) An additional hour of time available for third machine, is worth 0.64 dollars to the firm (round your response to two decimal places). d) An additional 10 hours of time available for the second machine, at no cost to the firm, are going to increase the objective value by 0.40 dollars (round your response to two decimal places)Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
