4 . 3 . 4 . 3 . Reboot, I spreadsheet model and then solve it . . for boots is highly sear is a

$4\mathrm{.}3.$ Reboot, I spreadsheet model and then solve it$.$

for boots is highly sear is a manufacturer of hiking boots. Demand year is expected to beas in particular, the demand in the next boots in quarters $1,2,3,000,4,000,8,000,$ and $7,000$ pairs of duction facility, the $1,3,$ and $4,$ respectively. With its current proboots in any quarter. demand, so it will need Reboot would like to meet all the expected later quarters. Each pair of boots sold generates a profit of $$20$ per pair. Each pair of boots in inventory at the end of a quarter incurs $$8$ in storage and capital recovery costs. Reboot has $1,000$ pairs of boots in inventory at the start of quarter $1.$ Reboot's top management has given you the assignment of doing some spreadsheet modeling to analyze what the production schedule should be for the next four quarters and making a recommendation.

a$.$ Visualize where you want to finish. What are the decisions that need to be made? What should the objective be$?$ What numbers are needed?

b$.$ Suppose that Reboot were to produce $5,000$ pairs of boots in each of the first two quarters. Calculate by hand what the ending cash positions would be after year $1$ and year $2.$

c$.$ Make a rough sketch of a spreadsheet model, with blocks laid out for the data cells, changing cells, output cells, and objective cell.

d$.$ Build a spreadsheet model for years $1$ and $2,$ and then thoroughly test the model.

e$.$ Expand the model to full scale and then solve it$.$