Please answer part A and B

New Exercise Bank Content Qu. 07-03 Reboot Incorporated is a manufacturer of hiking boots. Demand for boots is highly seasonal. In particular, the demand in the next year is expected to be 4,000, 3,000, 7,000, and 6,000 pairs of boots in quarters 1, 2. 3, and 4, respectively. With its current production facility, the company can produce at most 6,000 pairs of boots in any quarter. Reboot would like to meet all the expected demand, so it will need to carry inventory to meet demand in the 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. Click here for the Excel Data File Build a spreadsheet model and then solve it. 4 a. What should be the production schedule for the next four quarters? b. Determine the net profit. Complete this question by entering your answers in the tabs below. Required A Required B What should be the production schedule for the next four quarters? Production Quarter 1 Quarter 2 Quarter 3 Quarter 4 Required B &gt