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 up in a table like you would in Microsoft Excel. I'm struggling on how I could answer this question. If you could help me out and walk me through how you answered my question, it would be greatly appreciated. Thanks in advance.