Sales and Operations Planning

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)

JanFebMarAprMayJunJulAugSepOctNov Dec410385450560420180140150300145370 400There 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 plan2. Develop a Level planFor each plan, calculate the end of month inventory (or shortage) level. Upload your spreadsheet on to Canvas by the due date.