Explore BrainMass

# Southern Sporting Goods: Linear Programming using EXCEL Solver

Not what you're looking for? Search our solutions OR ask your own Custom question.

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?