Purchase Solution

Southern Sporting Goods: Linear Programming using EXCEL Solver

Not what you're looking for?

Ask Custom Question

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?

Purchase this Solution
Solution Summary

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

Solution provided by:
Anwesha Ghosh, MSc
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!!!!"
Purchase this Solution
Free BrainMass Quizzes
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

View More Free Quizzes
Related BrainMass Solutions

  • Linear programming

    92468 The Southern Sporting Goods Company (See attached file for full problem description) --- Problem 5 The Southern Sporting Goods Company makes basketballs and footballs. Each product is produced from two resources- rubber and leather.

  • Linear programming problem

    Solution of linear programming problems using graphical method.

  • Linear Programming: Minimize Costs for Four Cargo Ships

    Thanks for using Brainmass. The Solution finds the best result with minimal costs in Linear Programming Problem using EXCEL Solver.

  • Linear programming problem

    You may like to see excel sheet attached for the solution obtained using excel solver tool. Thanks Excel File contain optimal solution of the linear programming problem. Excel solver is used.

  • Operations Management - Linear Programming

    Please open Excel Solver tool to see the formulation. The last file contains help on Excel Solver tool. Operations management for linear programming is analyzed.

  • Linear Programming Using Excel Solver

    214291 Linear Programming Using Excel Solver I need the following two attached problems done in excel using the built in excel solver. For these problems we need to formulate our own constraints.

  • Linear programming model, Excel Solver

    Formulate a linear programming model b. Solve this model using a grid line I need help on solving this in solver and on a graph line. Please see attached file. The solution formulates a Linear programming model and solves it using Excel Solver

  • Linear Programming Problem for Print Media Advertising (PMA)

    a) Formulate the linear programming model for the problem. b) Use the Graphical method to find the optimal solution. Show all steps. c) Use Excel Solver to find the optimal solution.

  • Question about Linear programming problem using Excel Solver

    (using Solver) Hi Please find attached the solution to your problem. Hope its useful. regards This posting contains solution to following linear programming maximization problem using excel solver.

View More Related Solutions