Individual Assignment 10 Set up the model below in Excel and solve for the optim

Question

Individual Assignment 10 Set up the model below in Excel and solve for the optimal production plan. Submit your Excel model sheet, answer report, and sensitivity report. X1= Number of stoves produced weekly X2 = Number of washers produced weekly X3 = Number of electric dryers produced weekly X4 = Number of gas dryers produced weekly X5 = Number of refrigerators produced weekly MAX 110X1+ 90X2 + 75X3 + 8OX4 + 130X5 S.T. 5.5X1 + 5.2X2 + 5.0X3 + 5.1X4 + 7.5X5 LE 4800 (Molding/pressing) 4.5X1 LE 1200 (Stove assembly) 4.5X2+ 4.0X3+ 3.0X4 LE 2400 (Washer/dryer assemb 9.0X5 LE 1200 (Refrigerator assembly 4.0X1 + 3.0X2 + 2.5X3 + 2.0X4 + 4.0X5 LE 3000 (Packaging) All X's GE 0

Explanation / Answer

Individual Assignment 10 Set up the model below in Excel and solve for the optim

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---