During 2016, The Y, a nonprofit organization, bought and used containers of pool chemicals as shown in the table below. Under FIFO what was the Ys pool-chemical expense for the fiscal year 2016? The Y uses the Periodic method of inventory and takes a count of the inventory on 12/31/16. Please show your work in an Excel spreadsheet.

Units Purchase Units Used Bought Price 50 $100 January 1 February 15 90 $80 120 Used Through June 30 90 $90 August 15 October 30 120 $80 160 Used through December 31 Total 280 350