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 INSTRUCTIONS:1. Read and understand the cases/problems properly.2. Create an excel solution for each problem, using the solver engine to generate the decision variablesolution. Create a separate SHEET for each problem. Also, for each problem, generate an ANSWERREPORT and a SENSITIVITY REPORT.1. 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?

Linear programming is a method for determining the most optimal solution to a problem given…

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 could be obtained? What would be the effect if 500 additional square feet of leather could be obtained?

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 could be obtained? What would be the effect if 500 additional square feet of leather could be obtained?

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

You're trying to lay out your t-shirt business office. There are 3 rooms in a row (room 1 | room 2 | room 3) wtih 1 door in between room 1 and 2 and 1 door between room 2 and 3. You need to fit your three functions into the rooms -- administration, bleaching, and coloring. You go between administration and bleaching 30 times a day, you go between administration and coloring 100 times a day, and you go between bleaching and coloring 107 times a day. If you lay out your functions in a way that minimize the total number of doors you need to open, how many doors do you open each day?
13 In addition to the legislation and guidelines that may apply, the investment policythat is decided upon by the investment manager (for a client) should include allthe following elements EXCEPT rate of return expectations (including timeframe) and expected volatility specific goals about continuing education an investment review process the asset classes for investment a policy review process
For all the following problems, word-process your solutions within this template. Do not create a new file. Show all steps used in arriving at the final answers. Incomplete solutions will receive partial credit. Word-process formulas using Equation Editor and diagrams using Drawing Tool. Use Solver to obtain computer solutions in an Excel workbook. Submit the Word and the Excel workbook(s) separately as attachments. Problem 1 Determine the optimum solution for each of the following LPs by enumerating all basic solution maximize z=2x1 -4x2 +5x3 -6x4, subject to: x_1+4〖 x〗_2-2 x_3+8〖 x〗_4≤2 -x_1+2〖 x〗_2+3 x_3+4〖 x〗_4≤1 x_1 ,〖 x〗_2,x_3 ,〖 x〗_4≥0
The reading portion is the missing piece that you need to complete this assignment. 1. Calculate a pro-forma income statement for the first year of CCC (assume Steve Davidson does make and sell 30 canoes). Use a price that you think Steve should charge and briefly explain why you chose this price. Also, use 2 other prices (i.e., one that is lower and one that is higher) to examine how CCCs profit could change based on the price he charges. Please consider using Excel for this analysis. (Note that the case says that ‘Davidson projected almost $90,000 in sales in 1998 with gross profits of $52,000’. I’m not sure what this means, since it looks like he is starting the business in Aug., 1998. For your analysis, please ignore this information when doing your calculations).
Part I. True/False Questions. (1) ______ A linear PMLC model consists of a number of dependent phases that are executed in a sequential order with no feedback loops. (2) _____ The purpose of the planning process group is to develop and gain approval of a general statement of the goal and business value of the project. (3) ______ Estimating the total cost of the work belongs to the launching process group. (4)_______Excellent time management in project management requires the planning, scheduling, monitoring and controlling of all project activities. (5) _______Databases belong to the electronic communications management. (6) _______A requirement is a desired end-state whose successful integration into the solution meets more than one needs and delivers specific, measurable, and incremental business value to the organization. (7) _______Functional requirements specify what the product or service must do. (8) _____The work breakdown structure is a hierarchical description…
1) what is the Importance of problem formulationProblem definition & project objectives2. what are the steps in data science (analytics) problem solving approachExplain basic steps & important aspects
One of your colleagues will be taking a one-year work assignment in Beijing, China. As a compensation analyst, you must prepare an estimate of her new base pay and incentive payments. Her base pay is being increased 5 percent from her current $75,000 because the assignment will require additional responsibilities. Your colleague will be awarded a 20 percent foreign service premium, a 15 percent hardship allowance, and a quarters allowance equal to $58,200. Questions: 13-10. Calculate your colleague’s new base pay rate. 13-11. Calculate the (a) foreign service premium, (b) hardship allowance, and (c) quarters allowance. 13-12. Based on your calculations for the previous questions, how much will your colleague receive for her one-year assignment in Beijing, China?
Which of the following statements is correct? I. Tax loss carrybacks result in deferred tax assets. II. Tax loss carryforwards result in deferred tax assets. III. The tax valuation account is used to adjust deferred tax liabilities if it is "more likely than not" that they will not result in increased future taxes. 1.I only 2.II only 3.III only 4.I and II
1.What type of decision process does Pitcher seem to be using in his work with other departments? What type of process should he be using in this situation? Explain. 2. How would Davidson apply the Carnegie model to make a decision about Pitcher at this point? Explain. 3. Does the type of decision process Pitcher appears to use when working with other departments reflect any personal constraints (Exhibit 13.3)? Any cognitive biases? Explain.
Goal congruence is (CPA Adapted) The desire and the commitment to achieve a specific goal The extent to which individuals have the authority to make decisions O The extent of the attempt to accomplish a specific goal O The sharing of goals by supervisors and subordinates
Complete the Case-Analysis Worksheet--both the symptoms, causes, and theoretical explanations rows; and the conclusions, recommendations, and ethical consideration (based on your use of the Markkula Center Framework to evaluate your recommendations)--for this case and share it with the class. (Copy and paste into your comments rather than attaching a file). Use your complete knowledge of management principles we have been studying, i.e., planning, organizing, leading, and controlling. In replying to the work of others, discuss what you saw differently about the symptoms (problems), their causes, and esp. the theoretical (management principles) that help explain the problems/causes.
This assignment will require you to research, discover, analyze, and write a complete Business Report. "FIRST IN-N-OUT BURGER OPENS -- Harry Snyder introduces California's first drive-thru hamburger stand in a space barely 10 square feet at Francisquito and Garvey in Baldwin Park. Every day before dawn, Harry visits the meat and produce markets to pick out fresh ingredients, which he prepares by hand. Meanwhile, his wife Esther diligently takes care of all the accounting for the new restaurant at their home right around the corner. It's been a few years since then, and In-n-Out Burger is now a favorite of millions. Your Team Research Project is designed as a business case study to improve the operations of this very successful company. (Note: With instructor approval, your team may change the focal company of this project, as long as you maintain the intent of the project.) Your report will contain these elements: Company Background (Past, Present, and Future) Current Business Model…