QUESTION 15 Module 2 - Technical as the following information Qui 15-20 Alore sporting goods store is placing an order for beydes with its supplier. Pour models can be ordered the adult Open Trial, the aduk Cityscape the gris Sea Sprite, and the boy's Trad Blazer. It is sumed trut every bike Srdered will be sold and their profits, respectively, re 05., and The model should masine profit. The store needs to worry several conditions. One of these is space to hold the inventory. An adults bile needs we feet but a child's kennis only one too. The store for at space. There are 2000 euro arbiy time with the child based 4 hours of amerby time, the Open Traineeds 5 hours and me formation of the prokurid the computerized Mey reports rower ResortUmes Resort und Seestwity Reports are provided below the ber of adult Cityscape border 3thor of Sea Sprice testo order NA- the roof boys Tracer blestore MAX 50 X165242064 SUBJECT TO 2X120.70XA-575 5X1 X2 43 4X4 2000 X1 X3 X5 Anwer Report Objectives Cell NE Overnal Value The $21.900.00 2.000 Verstelle Time Open City ene Online 0 Com I can Call ane Cla Wach 0 2000 ten Oct Cul We Gerli Vi L Limits Report Objective Cell Name $G$2 Value $ 21,300.00 Value Variable Cell Name $B$2 Open Trail $C$2 Cityscape $D$2 SeaSprite $E$2 TrailBlazer 0 150 275 0 Lower Objective Limit Result 0 21300 50 14800 175 17100 0 21300 Upper Objective Limit Result 0 21300 150 21300 275 21300 0 21300 Sensitivity Report Variable Cells Cell Name $e$2 OpenTrail $C$2 Cityscape $D$2 SeaSprite $E$2 TrailBlazer Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 0 -5.5 50 5.5 1E+30 150 0 65 19 2 275 0 42 1.333333333 6 0 -6 36 6 1E+30 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $F$5 Inventory space 575 4 575 91.66666667 75 $F$6 Assembly time 2000 9.5 2000 300 200 $F$7 Order quantity 425 0 325 100 1E+30 How many of each kind of bike should be ordered, and what will the profit be? O A Order 75 Open Trails, 100 Cityscapes, 200 Sea Sprites, and 10 Trail Blazers The profit will be $19,010. OB. Order 50 Open Trails, 150 Cityscapes, 175 Sea Sprites, and Trail Blazers. The profit will be $19,600. OC. Order 75 Opon Trails, 2000 Cityscapes, 0 Sea Sprites, and Trail Blazers The profit will be $21,300. O D.Order 0 Open Trails, 150 Cityscapes, 275 Sea Sprites, and Trail Blazers The profit will be $21,300. QUESTION 16 The company is considering making an investment to increase one of the resources: laventory space, or assembly time. The investment will cost $5.00 per 1 unit of resource Increase. Which resource should the company work to increase, inventory space, or assembly time? A inventory space because its shadow price is greater than $5.00 O Bassembly time because its shadow price is greater than $5.00 O ventory space because its shadow price is less than $5.00 sembly time because its shadow price is less than 35.00 QUESTION 17 Over what mange of sembly hours in the shadow price applicable? O A 1700 to 2200 3.200 to 100 OC 1800 to 2300 ODNOTY to 100 QUESTION 18 What would the profiebe if the store had more feet of worage space OA 121,409 3.519.00 C1320 OD. 123.022 QUESTION 19 QUESTION 19 If the profit on the TrailBlazer increases to 43, will any of the Trail Blazer bikes be ordered? O A Yes. The $7 increase is above the reduced cost. OB. No. The $10 increase is below the reduced cost. QUESTION 20 If we require 5 more bikes in inventory, what will happen to the value of the optimal solution? O A. It will increase by $9.50, OB. It will stay the same. OC. It will increase by $47.5. OD. It will decrease by $20