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.

Please submit your chase plan here in ONE spreadsheet file. Then answer the next several questions based on this data above.

N Quarter (t) Demand Forecast (Ft) 1 1198 1495 3 1480 4 1138 5 488 6 1112 7 570 8 927 854 9 10 605 11 1482 12 485 13 1037 14 1449 15 681 16 1437 17 1175 18 1003 19 1498 736 20 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 N Quarter (t) Demand Forecast (Ft) 1 1198 1495 3 1480 4 1138 5 488 6 1112 7 570 8 927 854 9 10 605 11 1482 12 485 13 1037 14 1449 15 681 16 1437 17 1175 18 1003 19 1498 736 20 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