Apply graphical analysis to draw each constraint and

This preview shows page 2 - 4 out of 4 pages.

b. Apply graphical analysis to draw each constraint and identify the resulting feasible region and the optimal solution with the line of same profit method.
c. Use solver add-in to solve the problem.
Provide sufficient documentation along the way to show your work. Submit completed homework as an attachment, including the excel solver file. Decision VariableTablesChairs93.75468.75Objective Functiontotal profit1657048281.25RHSContraintsCushion Availability01468.75 <=500Wood Availability932250 <=2250Minimum Chair Ratio141968.75 >=4Maximum Chair Ratio162906.25 <=6Max Production Time (Weekly)10.6375 <=375Microsoft Excel 16.0 Sensitivity ReportWorksheet: [Discussion 1.xlsx]AB SolverReport Created: 10/24/2018 11:57:20 AMVariable CellsFinalReducedObjectiveAllowableAllowableCellNameValueCostCoefficientIncreaseDecrease$D$4Tables93.75016545 48.33333333$E$4Chairs468.750702915ConstraintsFinalShadowConstraintAllowableAllowableCellNameValuePriceR.H. SideIncreaseDecrease$F$10 Wood Availability total profit2250 12.083333332250112575$F$13 Max Production Time (Weekly) total profit37556.25375 8.333333333125$F$9Cushion Availability total profit468.750

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture