PLEASE FOLLOW THE INSTRUCTIONS AND DO THIS TYPEWRITTEN ONLY. I WILL UPVOTE FOR YOUR GREATEST EFFORT. KINDLY SKIP THIS IF YOU HAVE ALREADY ANSWERED. THANK YOU SO MUCH GENERATE THE DECISION VARIABLE SOLUTION ANDGENERATE A SENSITIVITY REPORT1. Southern Sporting Goods Company makes basketballs and footballs. Each product is produced fromtwo resources-rubber and leather. The resource requirements for each product and the totalresources available are as follows:Resource requirements per unitRubber (lb)Leather (ft2)ProductBasketball34Football25800 ft2Total Resources available500 lbEach basketball produced results in a profit of $12, and each football earns $16 in profit.Required:a. Solve the model formulated for Southern Sporting Goods Company using the computer.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 couldbe obtained? What would be the effect if 500 additional square feet of leather could beobtained?

Objective Functions and Constraints: Based on the given details, the objective…

1. 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 Rubber (lb) Leather (ft2) Product Basketball 3 4 Football 2 5 Total Resources available 500 lb 800 ft2 Each basketball produced results in a profit of $12, and each football earns $16 in profit. Required: a. Solve the model formulated for Southern Sporting Goods Company using the computer. 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? 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? c.

1. 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 Rubber (lb) Leather (ft2) Product Basketball 3 4 Football 2 5 Total Resources available 500 lb 800 ft2 Each basketball produced results in a profit of $12, and each football earns $16 in profit. Required: a. Solve the model formulated for Southern Sporting Goods Company using the computer. 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? 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? c.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

A resume is a standard tool and follows the same format for all careers and all job seekers. True O False
6. In not more than two (2) sentences, briefly explain why it is important to have an agenda before a meeting. 7. In one sentence, briefly explain why a secretary must finalize his or her minutes in the shortest possible time after a meeting has ended.
Explain the security of payment, personal information,complaint handling and dispute resolution in brief. I need to prepare 5 - 10 minutes presentation for it.
During a job analysis interview, a job incumbent tells you that the job requires a great deal of “writing ability,” and “communication skills.” Would you use these terms in the list of KSAOs required for this job? Write four sentences to describe the job with more concrete, specific details.
Which of the following is true of just-in-time processing? a.In just-in-time processing, supervisors enter materials into manufacturing so as to keep all the manufacturing departments (processes) operating. b.It assigns service activities to centralized service departments. c.It is a management approach that focuses on reducing time and cost and eliminating poor quality. d.In just-in-time processing, a worker typically performs only one function.
On the job, the telephone numbers of doctors, hospitals, and ambulances must be: a. conspicuously posted on the project b. distributed by memo to each employee c. kept in everyone's lunch kit d. displayed on each piece of equipment Explain
A cover letter that accompanies a resume is the applicant's opportunity to explain what they are looking for in a career position. This is the perfect companion to the resume which shows that the candidate is qualified for the position. True ○ False
Your task is to write an email to your instructor to introduce yourself. Put your first and last name and the assignment title in the subject line. For example: Maria Ruiz Assignment 1 Your message should address the following: Reasons for taking this class Your career goals (short term/long term) Familiarity with computer technology A brief discussion of how you view your current communication skill levels. Were there any parts of the quiz that surprised you? What are your strongest and weakest skills? Is there anything in the class/syllabus that worries you? Any topic you are excited about or have extensive experience with?
The statement I'm completely disappointed with your service" is a common sentence in a complaint letter Select one O True O False
During every job interview, the main actor is the interviewer largely
Which sentence could be included in a response to a complaint in order to reaffirm the customer's value to the company? Your business and patience are greatly appreciated. Thank you for making me aware of the situation. We apologize for any inconvenience. I have met with the employee you mentioned to discuss the issue.
Which of the following is not correct about inside address? a. Inside address is the name and address of the signatory b. Inside address is the name and address of the receiver O c. Inside address is the address that is visible through the panel in a window envelope O d. Inside address and address on the envelope are same