LOOKING AT SOLVER!!! 1. Suppose a small company is in the business of making golf bags to be sold at a local golf course where state championships are often held. They make 2 types of golf bags, a standard bag and a deluxe bag. The table below gives the information for limitations of materials and labor hours, and also for the profit for each type of bag. The materials and labor hours are the amount available per week, and the profit is the profit per week as well.

Units are per bag	Standard Leather (square feet)	Premium Leather (square feet)	Cutting and Sewing Labor hours	Finishing Labor Hours	Profit
Standard	7	1	3	1	25
Deluxe	0	9	4	2	65
Total available	210	180	120	40

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.)