Will rate answers!

Module 2 - Technical Please use the following information to answer Question 15-20. A large sporting goods store is placing an order for bicycles with its supplier. Four models can be ordered: the adult Open Trail, the adult Cityscape, the girl's Sea Sprite, and the boy's Trail Blazer. It is assumed that every bike ordered will be sold, a their profits, respectively, are 50, 65, 42, and 36. The LP model should maximize profit. The store needs to worry about several conditions. One of these is space to hold the inventory. An adult's bike needs two feet, but a child's bike needs only on foot. The store has 575 feet of space. There are 2000 hours of assembly time available. The child's bikes need 4 hours of assembly time, the Open Trail needs 5 hours, and the Cityscape needs 6 hours. The store would like to place an order for at least 325 bikes The LP formulation of the problem and the computerized sensitivity reports (Answer Report, Limits Report, and Sensitivity Report) are provided below. X1= the number of adult Open Trail bikes to order X2= the number of adult Cityscape bikes to order X3= the number of girl's Sea Sprite bikes to order X4= the number of boy's Trail Blazer bikes to order MAX 50 X1 + 65 X2 +42 X3 + 36 X4 SUBJECT TO 2 X1 + 2 x2 + x3 + X4 = 325 Answer Report Objective Cell (Max) Cell Name Original Value Final Value $G$2 $ 21,300.00 $ 21,300.00 Variable Cells Cell Name $B$2 OpenTrail $C$2 Cityscape $D$2 SeaSprite $E$2 TrailBlazer Original Value Final Value Integer 0 O Contin 150 150 Contin 275 275 Contin 0 O Contin Constraints Cell Name $F$5 Inventory space $F$6 Assembly time $F$7 Order quantity Cell Value Formula Status Slack 575 $F$5=$H$7 Not Binding 100 Limits Report Objective Cell Name $G$2 Value $ 21,300.00 Variable Cell Name $B$2 Open Trail $C$2 Cityscape $D$2 SeaSprite $E$2 TrailBlazer Value 0 150 Lower Objective Upper Objective Limit Result Limit Result 0 21300 0 21300 50 14800 150 21300 175 17100 275 21300 0 21300 0 21300 275 0 Sensitivity Report Variable Cells Cell Name $B$2 Open Trail $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 50 Open Trails, 150 Cityscapes, 175 Sea Sprites, and 0 Trail Blazers. The profit will be $19,600. OB. Order 0 Open Trails, 150 Cityscapes, 275 Sea Sprites, and 0 Trail Blazers. The profit will be $21,300. OC Order 75 Open Trails, 2000 Cityscapes, O Sea Sprites, and Trail Blazers. The profit will be $21,300. OD. Order 75 Open Trails, 100 Cityscapes, 200 Sea Sprites, and 10 Trail Blazers. The profit will be $19,010. QUESTION 16 The company is considering making an investment to increase one of the resources: inventory 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? O A. inventory space because its shadow price is greater than $5.00 O B. inventory space because its shadow price is less than $5.00 O C. assembly time because its shadow price is greater than $5.00 O D. assembly time because its shadow price is less than $5.00 QUESTION 17 If the profit on the TrailBlazer increase eases to 43, will any of the TrailBlazer bikes be ordered? O A. No. The $10 increase is below the reduced cost. B. Yes. The $7 increase is above the reduced cost. QUESTION 18 If we require 5 more bikes in inventory, what will happen to the value of the optimal solution? O A. It will stay the same. B. It will increase by $47.5. C. It will decrease by $20. D. It will increase by $9.50. O 0 QUESTION 19 What would the profit be if the store had 5 more feet of storage space? O A. $19,300 O B. $21,409 O C. $23,022 OD. $21,320 QUESTION 20 Over what range of assembly hours is the shadow price applicable? A. 1800 to 2300 B. -INFINITY to 100 O C. 200 to 300 O D. 1700 to 2200