Question: solve in EXCEL please Given this linear prohramming model, solve the model and then answer the question that follow Maximize Z=121+182+153 Where xi= the quantity

solve in EXCEL please
solve in EXCEL please Given this linear prohramming model, solve the model

Given this linear prohramming model, solve the model and then answer the question that follow Maximize Z=121+182+153 Where xi= the quantity of product ' i ' to make Subject to: MachineLaborMaterialsProduct251+42+3341+102+4321+22+43X21,2,3160minutes288hours200pounds16units0 a. Are any constraints binding? If so, which one(s)? b. If the profit on product 3 were changed to $22 a unit, what would the values of the decision variables be? The objective function? Explain c. If the profit on product 1 were changed to $22 a unit, what would be the vales of the decision variables be? The objective function? Explain d. If 10 hours less of labor time were available, what would be the vales of the decision variables be? The objective function? Explain e. If the manager decided that as many as 20 units of product 2 could be produced ( instead of 16), how much additional profit would be generated? f. If profit per unit on each product increased by $1, would the optimal values of the decision variables change: Explain. What would the optimal value of the objective function be

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!