Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$4 IG1...

 

Transcribed Image Text:

Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$4 IG1 8000 0 9 1E+30 0.2 $D$4 TG1 15000 0 7 0.25 1E+30 $E$4 IG2 30000 0 8 0.2 1E+30 $F$4 TG2 8000 0 6 1E+30 0.25 Constraints Cell Name LHS Final Value $G$15 LHS Shadow Price 38000 9.714285714 Constraint Allowable Allowable R.H. Side Increase Decrease 38000 5250 1750 $G$16 LHS $G$9 Cutting 1 LHS 23000 46 8.142857143 23000 4200 1400 0 80 1E+30 34 $G$10 Cutting 2 LHS 54.28571429 0 80 1E+30 25.71428571 $G$11 Edging 1 LHS 80 -285.7142857 80 5.6 13.125 $G$12 Edging 2 LHS 80 -857.1428571 80 3.5 10.5 $G$13 Furnace 1 LHS $G$14 Furnace 2 LHS 45 0 80 1E+30 35 60 0 80 1E+30 20 Pre-Assignment Meeting #2 The first two problems are based on the Newfort Glass Co, which you tackled before our first meeting. You may want to revisit your formulation and make corrections (if necessary). You may also use my solutions as a starting point if you prefer. 1. Generate the Sensitivity Report in Excel for this LP problem. Based on that report, answer the following questions. Be as specific as possible (cite relevant numbers), but only short answers are needed. You may answer "Would need to resolve" where appropriate. Note: "1E+30" in Excel means infinity. A. How would adding four (4) hours in the edging department at Plant 1 affect costs? B. What if the furnace at Plant 1 was shut down for 30 hours. How would this affect costs? C. How would total costs change if you lost four (4) hours of the edging capacity in Plant 1, but gained two (2) hours of edging capacity in plant 2? D. Suppose both furnaces are shut down for 15 hours. How would this affect costs? E. Consider the objective function cost of IG at Plant 1. Would raising it $1 affect the optimal protection schedule? F. Consider the cost of IG at Plant 2. How would raising it $.5 per SQFT affect the optimal production schedule? G. Suppose you needed to eliminate four (4) hours from the edging department at both plants. How much would this impact your costs? H. Suppose you needed to eliminate one 8-hr shift in the edging department at both plants in the coming week. How much would this impact your costs? 1. Suppose the cost of glass increases by $.10 per SQFT for all four products. Would this affect your optimal production schedule? J. What happens if the cost of insulated (IG) glass decreases by $.15 per SQFT at Plant 1 but increases by $.15 per SQFT at Plant 2? K. Suppose the amount of IG glass needed this week increases by 1000 SQFT (via an emergency order). How much more does each additional SQFT of IG glass cost Newfort? How does this compare with the variable costs of IG glass (per SQFT) at each plant? Can you explain why this is the case? Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$4 IG1 8000 0 9 1E+30 0.2 $D$4 TG1 15000 0 7 0.25 1E+30 $E$4 IG2 30000 0 8 0.2 1E+30 $F$4 TG2 8000 0 6 1E+30 0.25 Constraints Cell Name LHS Final Value $G$15 LHS Shadow Price 38000 9.714285714 Constraint Allowable Allowable R.H. Side Increase Decrease 38000 5250 1750 $G$16 LHS $G$9 Cutting 1 LHS 23000 46 8.142857143 23000 4200 1400 0 80 1E+30 34 $G$10 Cutting 2 LHS 54.28571429 0 80 1E+30 25.71428571 $G$11 Edging 1 LHS 80 -285.7142857 80 5.6 13.125 $G$12 Edging 2 LHS 80 -857.1428571 80 3.5 10.5 $G$13 Furnace 1 LHS $G$14 Furnace 2 LHS 45 0 80 1E+30 35 60 0 80 1E+30 20 Pre-Assignment Meeting #2 The first two problems are based on the Newfort Glass Co, which you tackled before our first meeting. You may want to revisit your formulation and make corrections (if necessary). You may also use my solutions as a starting point if you prefer. 1. Generate the Sensitivity Report in Excel for this LP problem. Based on that report, answer the following questions. Be as specific as possible (cite relevant numbers), but only short answers are needed. You may answer "Would need to resolve" where appropriate. Note: "1E+30" in Excel means infinity. A. How would adding four (4) hours in the edging department at Plant 1 affect costs? B. What if the furnace at Plant 1 was shut down for 30 hours. How would this affect costs? C. How would total costs change if you lost four (4) hours of the edging capacity in Plant 1, but gained two (2) hours of edging capacity in plant 2? D. Suppose both furnaces are shut down for 15 hours. How would this affect costs? E. Consider the objective function cost of IG at Plant 1. Would raising it $1 affect the optimal protection schedule? F. Consider the cost of IG at Plant 2. How would raising it $.5 per SQFT affect the optimal production schedule? G. Suppose you needed to eliminate four (4) hours from the edging department at both plants. How much would this impact your costs? H. Suppose you needed to eliminate one 8-hr shift in the edging department at both plants in the coming week. How much would this impact your costs? 1. Suppose the cost of glass increases by $.10 per SQFT for all four products. Would this affect your optimal production schedule? J. What happens if the cost of insulated (IG) glass decreases by $.15 per SQFT at Plant 1 but increases by $.15 per SQFT at Plant 2? K. Suppose the amount of IG glass needed this week increases by 1000 SQFT (via an emergency order). How much more does each additional SQFT of IG glass cost Newfort? How does this compare with the variable costs of IG glass (per SQFT) at each plant? Can you explain why this is the case?