A large hardware store is placing an order for garden wagons from its supplier. Four models can be ordered: the full wagons LargeTerrain and the CountrySlider, and the three-wheeled wagons (wheelbarrows) the SuperSize and the ToughBlazer. It is assumed that every wagon ordered will be sold, and their profits, respectively, are 30, 25, 22, and 20. The goal of the Linear Programming model is to maximize profit subject to several restrictions: The store has 500 square feet of space and each full wagon need two square feet and each wheelbarrow needs only one square foot.. There are 1200 hours of assembly time available. The wheelbarrows need 4 hours of assembly time; the LargeTerrain needs 5 hours and the CountrySlider needs 6 hours. The store would like to place an order for at least 275 wagons.

a. Formulate a model for this problem.

b. Solve your model using Excel Solver. Be sure to save your Answer and Sensitivity Reports.

c. How many of each kind of wagon should 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. If the profit on the CountrySlider increases to $35, will any of the CountrySlider wagons be ordered?

f. Over what range of assembly hours is the shadow price applicable?

g. If we require 5 more wagons in inventory, what will happen to the value of the optimal solution?

h. Which resource should the company work to increase, inventory space or assembly time?

Solve using Solver. Answer all questions in Excel