Solve this model in Excel and copy$/$paste your spreadsheet results as the essay answer. Like, literally highlight the cells from top to bottom so that I can see all the numbers.

A company is planning production for the next four quarters. It wants to minimize the cost of production. The production cost is stable, but demand and production capacity vary from quarter to quarter. The maximum amount of inventory that can be held is $12,000$ units, and management wants to keep at least $3,000$ units on hand. Quarterly inventory holding cost is $3\%$ of the cost of production. The company estimates the number of units carried in inventory each month by averaging the beginning and ending inventory for each month. There are currently $5,000$ units in inventory. The company wants to produce at no less than one half of its maximum capacity in any quarter.

Quarter

$1$

$2$

$3$

$4$

Unit production cost

$ $300$

$ $300$

$ $300$

$ $300$

Units demanded

$2,000$

$9,000$

$12,000$

$11,000$

Maximum production

$8,000$

$7,000$

$8,000$

$9,000$