CH 7 Perpetual Inventory System
CH 7 Perpetual Inventory System
CH 7 Perpetual Inventory System
1
Example on Calculation of Ending Inventory and Cost of Goods Sold Under a Perpetual
Inventory System
DEF Company provided you with the following data for the year 2xxx:
Units Unit Cost Total Cost
January 1 balance 90 $15.00 $1,350
March 15 purchase 60 $16.00 960
June 20 purchase 100 $17.50 1,750
Goods available for sale 250 $4,060
110 units were sold on May 25 and another 90 units were sold on August 11
Required: Compute the cost of ending inventory and cost of goods sold under the FIFO,
LIFO and moving average methods
FIFO
Date Purchases Cost of Goods Sold Inventory Balance
Jan 1 90 x $15 = $1,350
Mar 15 60 @ $16 = $960 90 x $15 + 60 x $16 =
$2,310
May 25 90 @ $15 + 20 @ $16 = $1,670 40 x $16 = $640
Jun 20 100 @ $17.50= 40 x $16 + 100 x $17.50
$1,750 = $2,390
Aug 11 40 @ $16 + 50 @ $17.50 = 50 x $17.50 = $875
$1,515
Total cost of goods sold for
year = $3,185
2
LIFO
Date Purchases Cost of Goods Sold Inventory Balance
Jan 1 90 x $15 = $1,350
Mar 15 60 @ $16 = $960 90 x $15 + 60 x $16 =
$2,310
May 25 60 @ $16 + 50 @ $15 = $1,710 40 x $15 = $600
Jun 20 100 @ $17.50 = 40 x $15 + 100 x $17.50
$1,750 = $2,350
Aug 11 90 @ $17.50 = $1,575 40 x $15 + 10 x $17.50 =
$775
Total cost of goods sold for year
= $3,285