Inventory Valuation: FIFO, LIFO and AVERAGE

The company reported the following inventory data for the year.

Description	Units	Cost per Unit
Beginning Inventory	300	$17.50
Purchases:
March 23	900	$18.00
September 16	1,200	$18.25
Units remaining at year-end	400

Compute the ending inventory assuming the following methods:

a. FIFO inventory valuation

b. LIFO inventory valuation

c. Average Cost inventory valuation

The company uses a periodic inventory system.

Note: Please set this answer up into a table like you would in Microsoft Excel. Thanks in advance.