Please answer fast! Especially part a and b fast! Thank you!!

Golf Shafts, Inc. (GSI), produces graphite shafts for several manufactures of golf clubs. Two GSI manufacturing facilities, one located in San Diego and the other in Tampa, have the capability to produce shafts in varying degrees of stiffness, ranging from regular models used primarily by average golfers to extra stiff models used primarily by low-handicap and professional golfers. GSI just received a contract for the production of 200,000 regular shafts and 75,000 stiff shafts. Both plants are currently producing shafts for previous orders, which means that neither plant has sufficient capacity by itself to fill the new order. The San Diego plant can produce up to a total of 120,000 shafts and the Tampa plant can produce up to a total of 180,000 shafts. Because of equipment differences at each of the plants and differing labor costs, the per-unit production costs vary as shown here:

Use this for part b

Golf Shafts, Inc. (GSI), produces graphite shafts for several manufactures of golf clubs. Two GSI manufacturing facilities, one located in San Diego and the other in Tampa, have the capability to produce shafts in varying degrees of stiffness, ranging from regular models used primarily by average golfers to extra stiff models used primarily by low-handicap and professional golfers. GSI just received a contract for the production of 200,000 regular shafts and 75,000 stiff shafts. Both plants are currently producing shafts for previous orders, which means that neither plant has sufficient capacity by itself to fill the new order. The San Diego plant can produce up to a total of 120,000 shafts and the Tampa plant can produce up to a total of 180,000 shafts. Because of equipment differences at each of the plants and differing labor costs, the per-unit production costs vary as shown here: a. Formulate a linear programming model to determine how GSI should schedule production for the new order in order to minimize the total production cost. (10 points) b. Use Solver in Microsoft Excel to solve the model that you developed in part (a). Give the values of each decision variable and the objective function. You MUST attach a copy of the solution report. (5 points) c. Suppose that resources are available to increase the production capacity at the Tampa plant by an additional 10,000 units. Would this option be feasible? Also, what impact will this have on the Objective Function value? Explain. (5 points) d. Suppose that the cost to produce a stiff shaft in Tampa had been incorrectly computed, and that the correct cost is $5.30 per shaft. What effect, if any, would this change have on the optimal solution developed in part (b)? What effect would it have on total production cost? (5 points)