13.pdf - Requirement (1) Units Beginning inventory...

Requirement (1)
Units Unit cost Amount
Beginning inventory 100 50.00 $ 5,000
Purchases:
Mar-05 400 55.00 $ 22,000
Mar-18 120 60.00 $ 7,200
Mar-25 200 62.00 $ 12,400
Goods available for sale 820 46,600
Requirement (2)
Units
Beginning inventory 100
Purchases:
Mar-05 400
Mar-18 120
Mar-25 200
Goods available for sale 820
Sales (580)
Units in ending inventory 240
Requirement (3)
Perpetual FIFO
Date Units Unit Cost Units Unit Cost Cost of Goods Sold Units Unit Cost Inventory Balance
Mar-01 100 50.00 $ 5,000.00 $
Mar-05 400.00 55.00 $ 100 50.00 $ 5,000.00 $
400 55.00 $ 22,000.00 $
500 27,000.00 $
Mar-09 100 50.00 $ 5,000.00 $
320 55.00 $ 17,600.00 $ 80 55.00 $ 4,400.00 $
22,600.00 $ 80 4,400.00 $
Mar-18 120.00 60.00 $ - 50.00 $ - $
80 55.00 $ 4,400.00 $
120 60.00 $ 7,200.00 $
200 11,600.00 $
Mar-25 200.00 62.00 $ - 50.00 $ - $
80 55.00 $ 4,400.00 $
120 60.00 $ 7,200.00 $
200 62.00 $ 12,400.00 $
400 24,000.00 $
Mar-29 - - 50.00 $ -
80 55.00 $ 4,400.00 $ - 55.00 $ -
80 60.00 $ 4,800.00 $ 40 60.00 $ 2,400.00 $
200 62.00 $ 12,400.00 $
9,200.00 $ - $
Totals 580 31,800.00 $ 240 14,800.00 $
Weighted Average Perpetual
Date Units Unit Cost Units Unit Cost Cost of Goods Sold Units Unit Cost Inventory Balance
Mar-01 100 50.00 $ 5,000 $
Mar-05 400 55.00 $ 100 50.00 $ 5,000 $
400 55.00 $ 22,000 $
Average 500 54.00 $ 27,000 $
Mar-09 420 54.00 $ 22,680 $ 80 54.00 $ 4,320 $
Average 80 54 4,320
Mar-18 120 60.00 $ 80 54.00 $ 4,320 $
120 60.00 $ 7,200 $
Average 200 57.60 $ 11,520 $
Mar-25 200 62.00 $ 200 57.60 $ 11,520 $
200 62.00 $ 12,400 $
400 59.80 $ 23,920 $
Mar-29 160 59.80 $ 9,568 $ 240 59.80 $ 14,352 $
Totals 580 32,248 $ 240 14,352
Goods Purchased Cost of Goods Sold Inventory Balance
Goods Purchased Cost of Goods Sold Inventory Balance

Perpetual LIFO
Date Units Unit Cost Units Unit Cost Cost of Goods Sold Units Unit Cost Inventory Balance
Mar-01 100 50.00 $ 5,000.00 $
Mar-05 400 55.00 $ 100 50.00 $ 5,000.00 $
400 55.00 $ 22,000.00 $
500 27,000.00 $
Mar-09 20 50.00 $ 1,000.00 $ 80 50.00 $ 4,000.00 $
400 55.00 $ 22,000.00 $ - 55.00 $ - $
23,000.00 $ 80 4,000.00 $
Mar-18 120 60.00 $ 80 50.00 $ 4,000.00 $
- 55.00 $ - $
120 60.00 $ 7,200.00 $
200