In the excel sheet, if possible! Thank you!

E6A-1 The periodic inventory records of Flexon Prosthetics indicate the follow. ing at October 31: goods .. Oct. 1 8 15 26 Beginning inventory .. Purchase ........ Purchase.......... Purchase ........... 9 units @ $60 4 units @ 60 10 units @ 70 3 units @ 80 At October 31 Flexon counts 8 units of inventory on hand. continued... Requirements Compute ending inventory and cost of goods sold, using each of the fol- lowing methods. 1. Average cost (round average unit cost to the nearest cent) (pp. 346-347) 2. First-in, first-out (pp. 346-347) 3. Last-in, first-out (pp. 346-347)