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?
could somebody show step by step how to solve
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 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!