Answer Happy

Use the Excel Solver output for a maximization LP problem to determine which constraints are binding. Objective Function Value = 7475.00 Variable Cells Final Reduced Objective Allowable Allowable Coefficient Increase Decrease Name Value Cost P1 8 0 100 12.5 1E+30 5 P2 0 -5 120 1E+30 P3 17 0 150 12.5 25 P4 33 0 125 25 5 Constraints Final Shadow Value Price Constraint Allowable Allowable R.H. Side Increase Decrease Name Constraint A 108 0 118 15.75 8 157 10 157 1E+30 63 Constraint B Constraint Constraint D 25 25 25 33 17 8.5 50 -25 50 4 Constraint D only

Final Reduced Objective Allowable Allowable Coefficient Increase Decrease Name Value Cost P1 8 0 100 1E+30 12.5 P2 0 -5 120 5 1E+30 P3 17 0 150 12.5 25 P4 33 0 125 25 5 Constraints Final Shadow Value Price Constraint Allowable Allowable R.H. Side Increase Decrease Name 108 0 118 15.75 8 Constraint A Constraint B Constraint C 157 10 157 1E+30 63 25 25 25 33 17 Constraint D 50 -25 50 4 8.5 Constraint D only Constraints B.C. & D only Constraints A & C only All the constraints are binding Constraints B & D only

Determine the new objective function value if the RHS of the Space Constraint increases by 5 units. Objective Function Value = $51.00 Variable Cells Final ReducedObjective AllowableAllowable ValueCost Coefficientincrease Decrease Name Variable15 0 6 4 1 Variable23 0 7 1.5 2.67 Constraints Final Shadow Constraint Allowable Allowable Name ValuePrice R.H. Side Increase Decrease Labor 12 4 12 3 3 Wood 6.40 14 7.6. 1E+30 Space 12 3 12 6 1.8 Limit 3.20 10 6.8 1E+30 Must recalculate because increase exceeded the range of feasibility $47 $15 $66

Create a forecast for Week 5 using a 2-week weighted moving average if the most current weight is 0.65. Week Sales 1 90 2. 97 3 105 4 110 94.55 108.25 O 93.5 107.5 106,75