| Set up the problem in an excel worksheet, using the sandwich problem done in class as a template. The only difference will be that you have a. If the profit for Standard bags increases by $5/bag, does the optimal solution change? Explain why or why not. b. If the optimal solution does NOT change, will the value of the objective function at the optimal solution change? If it does, calculate the new profit. If it does not, explain why not. c. If the profit for Deluxe bags decreases by $5/bag, does the optimal solution change? Explain why or why not. (Note: this change is made WITHOUT changing the profit for Standard bags.) d. If the optimal solution does NOT change, will the value of the objective function at the optimal solution change? If it does, calculate the new profit. If it does not, explain why not. e. If the profit for Standard bags increases by $5/bag and the profit for Deluxe bags decreases by $5/bag, does the optimal solution change? (Hint: Use the 100% Rule) f. If the optimal solution does NOT change, will the value of the objective function at the optimal solution change? If it does, calculate the new profit. If it does not, explain why not. Consider now the sensitivity report for changing the RHS of a constraint. g. If the amount of premium leather available decreases by 10 square yards, by how much will the profit change? Why can you say this? h. Holding all the other RHS values fixed at the original values, how much will the objective function change if a part-timer working 5 extra hours per week on finishing is hired? Why can you say this? i. If the amount of premium leather available decreases by 10 square yards and the part-timer works an extra 5 hours by how much will the objective function change? Why can you say this? (Hint: 100% rule.) | 
