Consider the data below 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.

1. Create a chase plan excel sheet

2. What is the optimal number of days of supply to minimize total cost of the chase plan over 20 quarters?

3. What is the minimum possible total cost of this chase plan over 20 quarters?

4. What is the number of employees retired for Quarter 18?

5. What is the ending inventory for Quarter 2?

6. What is the total cost of this chase plan over 20 quarters?

7. What is the chase supply for Quarter 20?

8. What is the average inventory for Quarter 9?
 
 

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