In the table below is a production schedule for a manufacturer. James have been hired on to figure out the optimal 3 month production schedule using the Wagner-Whitin Algorithm. answers in excel sheet and formula for opening and ending inventory should be mentioned

Period (t)	1	2	3
Demand (Dt)	1000	300	500
Unit Cost (ct) cost per unit	21	21	21
Setup Cost / ordering cost(At)	326	326	326
Holding Cost (ht)	54	54	54