Question: Please solve the following linear programming problem. For part a, submit your screenshot or picture of the graph. For part b, submit an Excel spreadsheet.

 Please solve the following linear programming problem. For part a, submit

Please solve the following linear programming problem. For part a, submit your screenshot or picture of the graph. For part b, submit an Excel spreadsheet. 1. An appliance manufacturer produces two models of microwave ovens: H and W. Both models require fabrication and assembly work; each H uses four hours of fabrication and two hours of assembly, and each W uses two hours of fabrication and six hours of assembly. There are 600 fabrication hours available this week and 480 hours of assembly. Each H contributes $40 to profits, and each W contributes $30 to profits. What quantities of H and W will maximize profits? a. Use the graphing approach to find the optimal decision variables that maximizes the objective function. (10 points) b. Use Excel Solver to find the optimal decision variables that maximizes the objective function. Please solve the following linear programming problem. For part a, submit your screenshot or picture of the graph. For part b, submit an Excel spreadsheet. 1. An appliance manufacturer produces two models of microwave ovens: H and W. Both models require fabrication and assembly work; each H uses four hours of fabrication and two hours of assembly, and each W uses two hours of fabrication and six hours of assembly. There are 600 fabrication hours available this week and 480 hours of assembly. Each H contributes $40 to profits, and each W contributes $30 to profits. What quantities of H and W will maximize profits? a. Use the graphing approach to find the optimal decision variables that maximizes the objective function. (10 points) b. Use Excel Solver to find the optimal decision variables that maximizes the objective function

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!