Sporting Goods Resource Requirements per Unit (a) Product Basketball Football Rubber (lb.) 2.8 1.5 Resource Requirements per Unit (c-1) Leather (f2) 3.7 5.2 Product Basketball Football Rubber (lb.) 2.8 1.5 Leather (f2) 3.7 5.2 1000 900 Basketball 11 Football 15 input Constraints Total resources available Profits ($) 600 Basketball 11 Total resources available 900 Football 15 Profits ($) Basketball Football Decision variables Basketball Football Maximized profits Objective function Maximized profits (b) Product Basketball Football Resource Requirements per Unit Rubber (lb.) Leather (f2) 2.8 3.7 1.5 5.2 (C-2) Product Basketball Football Resource Requirements per Unit Rubber (lb.) Leather (f2) 2.8 3.7 1.5 5.2 input Constraints Total resources available Profits ($) 600 Basketball 12 Total resources available 900 Football 15 Profits ($) Basketball Football Decision variables Basketball Football Maximized profits Objective function Maximized profits Please use computer method to solve the problem Please enter your solution in Yellow cells 600 1500 Basketball 11 Football 15 A & B products (a) Product A B Total Hours Profits ($) Product A Product B Maximized profits Hours/ Unit Line 1 Line2 11 5 6 9 65 40 65 40 A 11 Constraints B 15 5 1.6666666667 decision variables 80.00 Objective function (b) Sensitivity Range for the coefficient of # of units of product A in the objectivefunction Sensitivity Range for the coefficient of # of units of product B in the objectivefunction (c') Shadow Price for additional hours of production time on Line 1 Shadow Price for additional hours of production time on Line 2 Which one of the two the company would prefer (Line 1 or Line 2?) 0.347826087 1.4347826087 Line 2 8.3333333333 6 27.5 19.8 Irwin textile mills (a) Profits for each product Corduroy 3.25 denim 2.5 Resources Cotton Labor Corduroy denim 8 4 6 3 <= <= Demands <= <= Available Resources 6500 3000 510 1000000 Maximized profits Write the standard form of the LP model in the space provided below (b) How much extra cotton and processing time are lef at the optimal solution? Cotton Processing Time Is the demand for Corduroy met? ('c) If Irwin Mills can obtain additional cotton or processing time, but not both, which should it select? Processing Time or additional cottone? How much? How much? Bradley Family (a) Let X1 = # of acres of corn and X2 = # of acres of tobacco Corn 520 1 210 1 X1 Land Budget Govt. Restriction 300 1 105 0 Resources Available Tobacco X2 <= <= <= 410 52500 100 Government Restriction Decision Variables Objective function (b) How many acres of farm land will not be cultivated at the optimal solution? Do the Bradleys use the entire 100 acre tobacco allotment? ('c) Should the Bradleys' lease extral land from their neighbor at $110 per acre? What is the maximum price the Bradleys' should pay their neighbor? And how much land shoud they lease? maximum price # of acres of land (d) For each dollar they borrow , how much additional profit will they make? If they borrowed a additional $1000, would the number of acres of corn and tobacco they plant change