Quarter $($t$)$

Demand Forecast $($Ft$)$

Quarter $($t$)$

Demand Forecast $($Ft$)$

$1$

$1198$

$11$

$1482$

$2$

$1495$

$12$

$485$

$3$

$1480$

$13$

$1037$

$4$

$1138$

$14$

$1449$

$5$

$488$

$15$

$681$

$6$

$1112$

$16$

$1437$

$7$

$570$

$17$

$1175$

$8$

$927$

$18$

$1003$

$9$

$854$

$19$

$1498$

$10$

$605$

$20$

$736$

Starting Inventory

$400$

units

Target Days of Supply

$20$

days

Employee Productivity

$40$

units$/$employee$/$quarter

Starting Employees

$30$

people

Inventory Holding Cost

$$20$

$/$unit$/$quarter

Inventory Shortage Cost

$$35$

$/$unit

Hiring Cost

$$2,000$

$/$employee

Firing Cost

$$6,000$

$/$employee

Days in Qtr

$66$

days

Consider the data above that shows the forecast for the number of cars sold by an electric car maker for each quarter for the next $5$ years. The table below also shows the parameters for the production or supply plan for the company. For example, the target days of supply is $20$ days, and the starting inventory is $400$ units.

Develop a chase plan for the company indicating the supply for each quarter in the next five years, the ending inventory, the average inventory, the no$.$ of employees required, the hiring plan, the firing plan, and the total cost of the chase plan for each period.