Please solve using Excel & show calculations

Problem 1 Exquisite Cookie Company started in business in 2017 and sells high-end decorated cookies. The following details purchases of cookies for resale in 2017 and 2018: Per # of Unit Units Cost 10 $12 $14 201 $15 $17 120 Date 1/1/2017 2/5/2017 6/23/2017 9/28/2017 Total 40 Total Cost $120 $560 $300 $850 $1,830 50 3/3/2018 7/4/2018 11/24/2018 Total 25 30 60 115 $20 $24 $25 $500 $720 $1,500 $2,720 Ending inventory on December 31, 2017 was 25 cookies and on December 31, 2018 was 35 cookies. If Exquisite Cookie Company uses a periodic inventory system, determine the following dollar amounts using the indicated cost flow assumption. 1. Weighted Average a. Ending Inventory, 2017 b. Cost of Goods Sold, 2017 C. Ending Inventory, 2018 d. Cost of Goods Sold, 2018