QUESTION 16 3 pc A large sporting goods store is placing an order for bicycles with its supplier. Four models can be ordered the adult Open Trall, the adult Cityscape, the girl's Sea Sprite, and the boy's Trail Blazer. It is assumed that every bike ordered will be sold, and their profits, respectively, are 30, 25, 22, and 20. 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 one fool. The store has 500 feet of space. There are 1200 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 275 bikes. QUESTION 20 The following information is obtained from the Answer and Sensitivity reports generated by Excel Solver. Name Cell Value Formula Status Slack Order quantity 275$F$7>=$H$7 Binding Inventory space 375 $F$6c-$H$5 Not Binding 125 Assembly time 1200 SF$6c-SH$6 Binding 0 0 Name Order quantity Inventory space Assembly time Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 275 -10 275 25 35 375 0 500 1E430 125 1200 8 1200 125 100 Over what range of assembly hours is the dual price applicable? The 58 shadow price is applicable when: s assembly hours s QUESTION 21 The following information is obtained from the Answer and Sensitivity reports generated by Excel Solver. Name Cell Value Formula Status Slack Order quantity 275$F$7>$H$7 Binding 0 Inventory space 375$F$5c$H$5 Not Binding 125 Assembly time 1200 $F$6c=$H$6 Binding 0 Name Order quantity Inventory space Assembly time Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 275 -10 275 25 35 375 0 500 1E430 125 1200 8 1200 125 100 If we require 5 more bikes in inventory, what will happen to the value of the optimal solution? It will (decrease/ increase) by $ Answer format: Please type either decrease or increase in the first box above