Purchase Solution

# Southern Sporting Goods: Linear Programming using EXCEL Solver

Not what you're looking for?

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?

##### Solution Summary

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

Solution provided by:
###### Education
• MSc, Osmania University
• MSc, Indian Institute of Technology - Roorkee (I.I.T.-ROORKEE)
• BSc, Banaras Hindu University
###### Recent Feedback
• "Very fast turnaround. Excellent communication! Much appreciated!"
• "excellent"
• "excellent"
• "excellent work"
• "Fantastic..great solution and very well explained!!!!"

##### Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

##### Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

##### Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

##### SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

##### Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking