Parker's Golf Associates (PGA) produces two types of golf bags. The standard (S) bag generates a profit of $10 per bag and the deluxe (D) bag generates a profit of $9 per bag.

Each type of bag must go through 4 stages of production as seen in the constraints below. For example, in the cutting and dyeing department there are 630 hours of labor time available for production and each standard bag needs 7/10 of an hour to be processed and each deluxe bag requires 1 hour. The other constraints have a similar interpretation.

Max profit 10S + 9D

Subject to the constraints

(7/10)S + 1D 630 Cutting & Dyeing C&D

(1/2)S + (5/6)D 600 Sewing Sw

1S + (2/3)D 708 Finishing F

(1/10)S + (1/4)D 135 Inspection & Packaging I&P

S, D 0 (We see a negative amount of either type of bag can not be produced.)

The PGA would like to maximize the total profit it can generate from the production of the two types of golf bags, while not violating any constraint.

Create Excel file and use the Solver tool to solve this problem, include an answer and sensitivity report with your Excel file and submit the file with you work. Then write out complete

sentences to the following questions.

By the way, in Excel when you need to type fraction like 5/6 in a cell just go to the cell and type =5/6. This is better than using a calculator for 5/6 and rounding.

A-what amount of standard bags and what amount of deluxe bags should be produced to maximize profit with the limits of the constraints?

B-what is the maximum amount of profit generated at the optimal solution?

C-how much of the total time in each stage of production is used up at the optimal solution?

D-from the sensitivity report in the variable cells section, for the standard bag, explain what the allowable increase and the allowable decrease mean in that row (you want to apply definitional concepts by using the numerical values in the problem).

E-from the sensitivity report in the constraints section, for the finishing stage, explain what the allowable increase and the allowable decrease mean in that row (you want to apply definitional concepts by using the numerical values in the problem). Plus, how does the shadow price number fit in the discussion?

F-from the sensitivity report in the constraints section, for the inspection and packaging stage, what does the shadow price of 0 mean?