Show in Excel

ABC Manufacturing is developing their 2021 SOP. The sales plan is already developed, using the forecast obtained from Demand Management and is as follows: (the numbers are in 1000s)

Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
410	385	450	560	420	180	140	150	300	145	370	400

There is an initial inventory of 100,000 units. There is a required ending inventory of 150,000 units. This means that the operations plan should be appropriately augmented to leave this ending inventory in December 2021.

Use Excel to:

1. Develop a Chase plan
2. Develop a Level plan

For each plan, calculate the end of month inventory (or shortage) level.