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

Management Science: XY Company manufactures and sells LCD monitor at P5000 each. The production officer reported the following: Sale price: P5000 per monitor direct materials cost: P1000 per unit direct labor cost: P550 per unit other overhead cost P950 per unit Fixed costs related to the production are also reported: salary of management: P200,000 rent for the factory: P150,000, other salaries: P140,000 depreciation of equipment: P12,000Compute total cost (TC) function
4GE 10:01 A company has production costs of item and can produce 270 $15 per items for a total cost of $6,925. The company brings in a total of $3,995 in revenue from selling 85 of these items. Determine each of the following functions. Enter all answers below in slope-intercept form, using exact numbers. a. Find the company's linear revenue function. R(x) b. Find the company's linear profit function. P(x) Submit answer
Formulate an LP model for the following problems.1. A furniture company makes two products: book shelves selling for ₱5,000 and cabinetsselling for ₱8,000. The direct cost per unit is ₱3,000 and ₱4,000, respectively. Thecompany has no difficulty in selling all the products it can manufacture. The assemblydepartment has 60 hours available per week and the finishing department can handleup to 48 hours of work per week. Manufacturing one book shelf requires 4 hours inassembly and 2 hours in finishing. Each cabinet requires 2 hours in assembly and 4hours in finishing. How can the management allocate the limited man-hour of the twodepartments in a way which will secure the largest possible net return?
Kpogas produces chairs and tables. Using economic forecast for the next month, Kpogas’ marketing manager has judged that during that period, it will be possible to sell as many chairs or tables as the company can produce. Management must now recommend a production target for next month. That is, how many chairs and tables should be produced if Kpogas’ management wishes to maximize next month’s profit contribution? Making this decision requires a consideration of the following key factors: ● Kpogas’s unit contribution margin is GH¢ 5,000 on each chair that is sold and GH¢ 4,000 on each table that is sold. ● Each product is put through Kpogas’s machining operations in both department A and department B. For next month’s production, the two departments have 150 and 160 hours available time, respectively. Each chair produced uses 10 hours of machining in department A and 20 hours of machining in department B, whereas each table produced uses 15 hours of machining in department A and 10…
A relatively small privately owned coal-mining company has the sales results summarized below. Determine the annual percentage depletion for the coal mine. Assume the company's taxable income is $125,000 each year. Sales, Tons 34,300 Year Spot Sales Price, $/Ton 1 9.82 2. 50,100 11.5 71,900 11.23 50% of the Gross Depletion Allowed Year taxable Income, $ amount Depletion amount 1. 3.
Scranton Shipyards has $20 million in total investor-supplied operating capital. The company’s WACC is 10 percent. Thecompany has the following income statement: Sales 10.0 millionOperating costs (6.0 million)Operating income (EBIT) 4.0 millionInterest expense (2.0 million)Earnings before taxes (EBT) 2.0 millionTaxes (40%) (0.8 million)Net income 1.2 million What is Scranton’s EVA?
3-2) The optimal quantity of the three products and resulting revenue for Taco Loco is: A) 28 beef, 80 cheese, and 39.27 beans for $147.27. B) 10.22 beef, 5.33 cheese, and 28.73 beans for $147.27. C) 1.45 Z, 8.36 Y, and 0 Z for $129.09. D) 14 Z, 13 Y, and 17 X for $9.81. 3-3) Taco Loco is unsure whether the amount of beef that their computer thinks is in inventory is correct. What is the range in values for beef inventory that would not affect the optimal product mix? A) 26 to 38.22 pounds B) 27.55 to 28.45 pounds C) 17.78 to 30 pounds D) 12.22 to 28 pounds
Direct Materials and Direct Labor Variance Analysis Shasta Fixture Company manufactures faucets in a small manufacturing facility. The faucets are made from brass. Manufacturing has 50 employees. Each employee presently provides 32 hours of labor per week. Information about a production week is as follows: Standard wage per hour $12.00 Standard labor time per unit 15 min. Standard number of lbs. of brass 1.5 lbs. Standard price per lb. of brass $11.00 Actual price per lb. of brass $11.25 Actual lbs. of brass used during the week 11,124 lbs. Number of units produced during the week 7,200 Actual wage per hour $12.36 Actual hours for the week (50 employees × 32 hours) 1,600 Required: a. Determine the standard cost per unit for direct materials and direct labor. Round the cost per unit to two decimal places. Direct materials standard cost per unit $fill in the blank 1 Direct labor standard cost per unit $fill in the blank 2 Total standard cost per unit $fill in…
Zhu Manufacturing is considering the Introduction of a family of new products. Long-term demand for the product group is somewhat predictable, so the manufacturer must be concemed with the risk of choosing a process that is inappropriate. Faye Zhu is VP of operations. She can choose among batch manufacturing or custom manufacturing, or she can invest in group technology, Zhu won't be able to forecast demand accurately until after she makes the process choice. Demand will be classified into four compartments: poor, fair, good, and excellebt The table below indicates the payoffs (profits) associated with each processidemand combination, as well as the probabilities of each long-term demand level: Demand Poor Fair Good Excellent Probability Batch Custom 0.15 0.40 -$300,000 $100,000 $1,200,000 $800,000 $400,000 $00,000 0.30 $1,200,000 $750,000 $500,000 0.15 $1,300,000 $800,000 $2,200,000 Group technology a) The alternative that provides Zhu the greatest expected monetary value (EMV) is…
The following information relates to the performance of a manager in 2020. Benchmark weight Return on the benchmark Actual returnActual Weight Equity Bonds Cash 7.28% 0.6 0.5 6.00% 3.20% 0.90% 3.60% 0.90% 0.2 0.3 0.2 0.2 Details of investments in different sectors of the equity market are as follows: Sector Beginning of month weights S&P 500 Sector return Basic material 1.96 6.30 6.9 Business services 5.80 7.10 7.0 Capital goods 1.91 8.80 4.1 Consumer cyclical 8.47 12.50 8.8 Consumer non-cyclical 40.37 19.40 10.0 Credit sensitive 24.01 20.80 5.0 Energy Technology 13.53 13.20 2.6 3.95 11.90 0.6
A local semiconductor firm, Superchip, is planning its workforce and productionlevels over the next year. The firm makes a variety of microprocessors and usessales dollars as its aggregate production measure. Based on orders received and sales forecasts provided by the marketing department, the estimate of dollarsales for the next year by month is as follows:Production Predicted DemandMonth Days (in $10,000)January 22 340February 16 380March 21 220April 19 100May 23 490June 20 625July 24 375August 12 310September 19 175October 22 145November 20 120December 16 165Inventory holding costs are based on a 25 percent annual interest charge. It is anticipatedthat there will be 675 workers on the payroll at the end of the current year and inventorieswill amount to $120,000. The firm would like to have at least $100,000 of inventory at theend of December next year. It is estimated that each worker accounts for an average of$60,000 of production per year (assume that one year consists of 250…
Factors of Production of P&G (Procter&Gamble) Demonstrate your understanding of the five factors of production by providing two examples for each used by the business in the production of goods/products and services. Land/Natural Resources: Identify two natural resources the business uses and explain how each natural resource relates to specific products/services offered by the organization. Labor/Human Resources: Identify two human resources the business uses and explain how each human resource relates to specific products/services offered by the organization. Capital: Identify two uses of capital by the business and explain how each use of capital relates to products/services offered by the organization. Entrepreneurship: Identify two entrepreneurs and specifically state what each entrepreneur has done to start, grow or maintain the business. (You have the option to exchange one of the entrepreneurs with an intrapreneur who serves in a leadership role within the…