A sporting goods company makes basketballs and footballs. Each product is produced from two resources - rubber and leather. The resource requirement for each product and the total resources available are as follows: Each basketball produced results in a profit of $12, and each football earns $16 in profit. a) Formulate an LP model to determine the number of basketballs and footballs to produce in order to maximize profit. b) Solve the model graphically. c) Identify the amount of unused resources at each of the graphical extreme (corner) points. d) What would be the effect on the optimal solution if the profit for a basketball changed from $12 to $13 ? e) What would be the effect on the optimal solution if the profit for a football changed from $16 to $15 ? f) Determine the sensitivity ranges for the objective function coefficients using graphical analysis. g) Solve the problem by Excel Solver. Provide model, solution and sensitivity reports. h) Compare and comment on the answer and sensitivity reports, and your solutions in parts a-f