A large sporting Goods Store is placing an order for bicycles who four models can be ordered: X1, X2, X3, and 4. time that every bike red bed, and ther unit profits are 30. 25. 22 and 20. respectively. The store wants to move profit, while it needs to worry about several conditions. One of these to hold the inventory as X and X2 bikes need two feet each, but Xandes need only one foot of space each. The store has 500 feet of space. There are 1200 hours and me available. X and X4 bikes need 4 hours of assembly time sheds hours, and X2 needs 6 hours. The store would like to place an order for at least 275 A computer solution for this problem is ven below OBJECTIVE FUNCTION VALLE 2) 6850.0000 VARIABLE VALUE REDUCED COST X1 100.000000 0.000000 0.000000 13.000000 175.000000 0.000000 X 0.000000 2.000000 ROW 21 31 SLACK OR SURPLUS DUAL PRICE 125.000000 0.000000 0.000000 8.000000 0.000000 -10.000000 VARIABLE UN NO. TERATIONS 2 RANGES IN WHICH THE BASIS IS UNCANGED B1. COCIENT RANGES ALLOWABLE ALLOBLE COEFFICIENT INCREASE DECREASE 30.000000 INFINITY 2500000 25.000000 13.000000 INITY 22.000000 2.000000 2.000000 20.000000 2.000000 X X RIGHTSAND SIDE RANGES ROW 2 3 CURRENT ALLOWABLE BHS INCREASE 500.000000 INFINITY 1.200.000000 125.000000 225.000000 25.000000 ELLABLE DELEASE 125.000000 100.000000 1.000000 Formulate a linear programming equation model for this problem How many of each kind of bad were and what were What would the profit be the store had 100 more feet of rage Explain why d the profit on incrementos, does it make sense to order mon Why? over what range of assembly hours is the tal price 2000 bine more bls are required in inventary, what will happen to the solution Which resource should the company increase first to interpretand why