Question: could somebody show step by step how to solve this with solver on excel? 4. A manufacturing company makes three products, and it has three
could somebody show step by step how to solve this with solver on excel?
4. A manufacturing company makes three products, and it has three machines available as resources as given in the following LP problem: Maximizecontribution=4X1+4X2+7X3Subjectto:1X1+7X2+4X3100(hoursonmachine1)2X1+1X2+7X3110(hoursonmachine2)8X1+4X2+1X3100(hoursonmachine3) a) Determine the optimal solution using LP software. b) Is there unused time available on any of the machines with the optimal solution? c) What would it be worth to the firm to make an additional hour of time available on the third machine? d) How much would the firm's profit increase if an extra 10 hours of time were made available on the second machine at no extra 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
