Southern Sporting Goods: Linear Programming using EXCEL Solver
Southern Sporting Goods Company makes basketballs and footballs. Each product is produced from two resources rubber and leather. The resource requirements for each product and the total resources available are as follows:
Resource Requirements per Unit
Product Basketball Football Total resources available
Rubber (lb.) 3 2 500 lb.
Leather (ft2) 4 5 800 ft2
a. State the optimal solution.
b. What would be the effect on the optimal solution if the profit for a basketball changed from $12 to $13? What would be the effect if the profit for a football changed from $16 to $15?
c. What would be the effect on the optimal solution if 500 additional pounds of rubber could be obtained? What would be the effect if 500 additional square feet of leather could be obtained?