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
390	355	445	580	220	110	160	240	400	390	420	450

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

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.

Upload your spreadsheet on to Canvas by the due date.

Please can you post the excel file not only a picture of the solution.

thanks a lot