Explore BrainMass
Share

Southern Sporting Goods: Linear Programming using EXCEL Solver

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

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?

© BrainMass Inc. brainmass.com March 22, 2019, 3:46 am ad1c9bdddf
https://brainmass.com/business/business-math/southern-sporting-goods-linear-programming-using-excel-solver-641347

Solution Summary

The solution has been performed using EXCEL Solver for the Southern Sporting Goods Company.

$2.19