Kalyan Singhal Corp. makes three products, and it has three machines available as resources as given in the following LP problem:
Maximize contribution = 3X₁ +5X2 +7X3 1X₁ +7X₂ + 4X3 ≤ 100 (C₁: hours on machine 1)
2X₁ + 1X₂ +7X3 ≤ 110 (C₂: hours on machine 2)
8X₁ +4X₂ + 1X3 ≤ 100 (C3: hours on machine 3)
X₁, X₂, X3 >0 a) Using a computer software for solving LP, the optimal solution achieved is: X₁ = ___ (round your response to two decimal places).
1.Please show answer for X1, X2, X3 and objective value
2.Unused hour time for all machines
3.Additional hour of third machine worth
4.Additional 10 hours of second machine worth.
Last time I posted this question I asked for the steps to solve in excel but the responder did not provide any of that. I simply don't know how to use the solve function to find the answers and would love some help. If thats too much to ask then just the answers is fine!