Here is the question below

During 2020. The Y, a nonprofit organization, bought and used containers of pool chemicals as shown in the table below. Under FIFO what was the Y's pool-chemical expense for the fiscal year 2020? The Y uses the Periodic method of inventory and takes a count of the inventory on 12/31/20. Please show your work in an Excel spreadsheet. Remember that the inventory is calculated for the entire year, not based on bi-annual usage. Units Purchase Bought Price Units Used January 1 50 $ 100 February 15 90 $80 Used Through June 30 120 August 15 90 $90 October 30 120 $80 Used through December 31 160 Total 350 280