In the table below is a production schedule for a manufacturer. James have been hired on to figure out the optimal 6 month production schedule usingthe Wagner-Whitin Algorithm. Explain the rationale behind the answer you found and what is the most dominant variable in your calculations? how to doWagner-Whitin Algorithm this in excel?Answer solved in excel sheet will be appreciated.

Period (t)	1	2	3	4	5	6
Demand (Dt)	1000	300	500	200	800	1000
Unit Cost (ct)	21	21	21	21	21	21
Setup Cost (At)	326	326	326	326	326	326
Holding Cost (ht)	54	54	54	54	54	54