Compute Arthur Lloyd's ending inventory and cost of goods sold under each of the following cost-flow methods assuming the company uses a perpetual inventory system (round your answer for cost per unit to two decimal places):

a. Moving Average

b. FIFO

c. LIFO

Arthur Llyod Associates
Moving Average
Current Year
In Excel Format Transaction Unit Purchased Unit Cost Cumulative Unit Cost Cumulative Cost Average Cost Per Unit	Units Purchased/ Sold	Unit Cost	Cumulative Units	Cost	Cumulative Cost	Average Cost Per Unit
Ending Inventory Cost of Goods Sold b. FIFO In Excel Format Transaction Units Purchased Unit Cost Total Cost Units Sold Cost of Goods Sold per Unit Cost of Good Sold	VALUE	VALUE	FORMULA	VALUE	FORMULA	FORMULA
Ending Inventory	VALUE	VALUE	FORMULA	VALUE	FORMULA	FORMULA
c. LIFO	VALUE	VALUE	FORMULA	VALUE	FORMULA	FORMULA
In Excel Format	VALUE	VALUE	FORMULA	VALUE	FORMULA	FORMULA
Transaction Units Purchased Unit Cost Total Cost Units Sold Cost of Goods Sold per Unit Cost of Good Sold	VALUE	VALUE	FORMULA	VALUE	FORMULA	FORMULA
Ending Inventory	VALUE	VALUE	FORMULA	VALUE	FORMULA	FORMULA
	VALUE	VALUE	FORMULA	VALUE	FORMULA	FORMULA
	VALUE	VALUE	FORMULA	VALUE	FORMULA	FORMULA
Ending Inventory	-
Cost of Goods Sold	#VALUE!
Arthur Llyod Associates FIFO Perpetual Current Year Transaction Unit Purchased Unit Cost Cumulative Unit Cost Cumulative Cost Average Cost Per Unit Units Purchased Unit Cost Total Cost Units Sold Cost of Goods Sold per Unit Cost of Goods Sold VALUE VALUE FORMULA VALUE VALUE FORMULA VALUE VALUE FORMULA FORMULA VALUE VALUE VALUE FORMULA VALUE VALUE FORMULA VALUE VALUE FORMULA VALUE VALUE VALUE FORMULA Cost of Goods Available for Sale FORMULA Cost of Goods Sold FORMULA Description Description VALUE VALUE Ending Inventory FORMULA Arthur Llyod Associates LIFO Pertpetual Current Year Transaction Unit Purchased Unit Cost Total Cost Unit Sold Cost of Goods Sold Per Unit Cost of Good Sold Cost of Goods Sold FORMULA FORMULA FORMULA DESCRIPTION VALUE Ending Inventory FORMULA