Student name:

Ch $19-$ Procedure Problem

EM$3310$

Solve these problems and upload your solution to Canvas. Make sure you upload the Excel file with your Excel model for Problem $1.$

Show all your work $($typed in the document or pasting a scanned image of your handwritten solution$).$ Save your solution document in a $.$pdf file and upload it to Canvas along with an Excel file for calculations performed in Excel.

Problem $1(30$ points$)$

Formulate a Linear Programming model to identify the optimum production quantity, so the company maximizes its profit. An appliance manufacturer produces two models of microwave ovens: $\backslash ($ H $\backslash )$ and $\backslash ($ W $\backslash ).$ Both models require fabrication and assembly work; each $\backslash ($ H $\backslash )$ uses four hours of fabrication and two hours of assembly, and each $\backslash ($ W $\backslash )$ uses two hours of fabrication and six hours of assembly. There are $600$ fabrication hours available this week and $480$ hours of assembly.

Each $\backslash ($ H $\backslash )$ contributes $\backslash (\backslash$$ $40\backslash )$ to profits, and each $\backslash ($ W $\backslash )$ contributes $\backslash (\backslash$$ $30\backslash )$ to profits. What quantities of $\backslash ($ H $\backslash )$ and $\backslash ($ W $\backslash )$ will maximize profit? Use the Graphical LP and enumeration methods to find the optimum solution. $[$Hint: You can use Excel to confirm you got the correct solution.$]$