please help me to solve detailed solution by using excel . Thanks.I need a complete solutions

6.11 Consider a company facing a demand pattern and costs as follows: Sequential Number 1 2 3 4 5 Month January February March April May June July August September October November December Requirements (units) 200 300 180 70 50 20 10 30 90 120 150 190 1410 7 9 10 11 12 Total A r (per month) $160.00 $0.10 $5.00 b. Repeat using the Wagner-Whitin Algorithm. e. Repeat using the Part-Period Balancing method