I ideally need this in Excel/Spreadsheet form. Please and thanks!

Problem 2: The accounting records of Redman Sporting Goods Inc., a wholesaler of various types of sports equipment, shows the following data regarding the purchases and sales of a particular model of baseball bat during the past year as follows: Units 60 180 300 60 50 Cost per unit $28 32 34 35 36 Beginning inventory Purchases: Apr 15 Jun 22 Sep 30 Nov 15 A physical count of inventory at the end of the period shows that 80 units are still on hand. Redman uses the periodic inventory system. Determine the cost that should be included in cost of goods sold and ending inventory if Redman uses the following FIFO B. Moving Average C. LIFO