Use Excel and show all computation bases. Preparing a same type of table for each of the FIFO, LIFO, and average costing methods is suggested.

Please compute (1) Cost of goods sold (COGS), and (2) Ending inventory (EI) costs for the following case using (a) FIFO, (b) LIFO, and (c) average costing methods: Case: Date Transaction Units Unit Cost Unit Selling Price 9-1 BI $ 800 1,025 9-3 Purchase 9-17 Sale $1,500 9-22 Purchase 9-26 1,100 1,200 1,450 9-29 1,500 9-30 Sale