Explore BrainMass

Explore BrainMass

    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 June 4, 2020, 5:30 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

    ADVERTISEMENT