OMeara Sales sells golf bags and uses a perpetual inventory system. OMearas inventory records show that at March 1, there were 30 units on hand at a cost of $135 each. Transactions related to purchase and sale of golf bags in March were as follows:

Date	transaction	unit	cost	Sale price
Mar 2	purchase	17	$127
Mar 5	sale	10		$150
Mar 15	purchase	12	$125
mar20	purchase	5	$120
mar30	sale	50		$150

Instructions Create a chart and calculate the following using the FIFO Inventory costing method.

i) the ending inventory at March 31

ii) the cost of goods sold at March 31

iii) Prove the inventory balance. (Opening Inv. + Purchases COGS = Ending Inv.) (You could copy and paste part of an Excel Spreadsheet here.)