Question \\( 6 \\mathrm{~A} \\) A large sporting goods store is placing an order for bicycles with its suppler, four modeis can be ordered: the adult opea Trait, the aduit cityscape, the girl's Sea Spite, and the conditions that the store needs to worry about. One of these is space to hold the imentory. An adults bilke needs two feet, but a childs bilke necds only one foot. The store has 300 feet of space. There are 1200 hours of asaembly time avallable. The childs bike need 4 hours of assembly time, the open Trad needs 5 tiours and the cityscape needs 6 bours. The store would like to place an order for at least 27 s blket a. Formulate a model for this problem. b. Solve your model with any cornputer pockage wailable to you c. How mary of each kind of bike shocld be ordered and what will the profit be? d. What would the profit be if the store had 100 more feet of storage space? e. It the profit on the cityscape increases to \\( \\$ 35 \\), will ary of the citycape bikes be ardered? f. Over what range of assembly hours is the dual price applicoble? 9. If we require 5 more bikes in inventory, what will happen to the valua of the optimal solubon? h. Which resource should the company wark, to increase, irventory space or assenbly tane? Please take a picture of all your hand wilings and the detall of your work and upload here. Upload all your excel fles sherwing your wark here \\& you have not done so in the previous questions