In: Finance
Gladstone Company tracks the number of units purchased and sold
throughout each accounting period but applies its inventory costing
method at the end of each period, as if it uses a periodic
inventory system. Assume its accounting records provided the
following information at the end of the annual accounting period,
December 31.
Transactions | Units | Unit Cost | |||||||
Beginning inventory, January 1 | 2,300 | $ | 60 | ||||||
Transactions during the year: | |||||||||
a. | Purchase, January 30 | 3,500 | 72 | ||||||
b. | Sale, March 14 ($100 each) | (1,950 | ) | ||||||
c. | Purchase, May 1 | 2,200 | 90 | ||||||
d. | Sale, August 31 ($100 each) | (2,400 | ) | ||||||
Assuming that for Specific identification method (item 1d) the
March 14 sale was selected two-fifths from the beginning inventory
and three-fifths from the purchase of January 30. Assume that the
sale of August 31 was selected from the remainder of the beginning
inventory, with the balance from the purchase of May 1.
Required:
i) Under LIFO & FIFO method:
LIFO Method | FIFO Method | |||||||||||||||
Receipt | Issue | Balance | Issue | Balance | ||||||||||||
Date | Transaction | Units | Rate | Cost | Units | Rate | Cost | Units | Rate | Cost | Units | Rate | Cost | Units | Rate | Cost |
1-Jan | Opening Balance | 2300 | 60 | $ 138,000 | 2300 | 60 | $ 138,000 | |||||||||
30-Jan | Purchases | 3500 | 72 | $252,000 | 2300 | 60 | $ 138,000 | 2300 | 60 | $ 138,000 | ||||||
3500 | 72 | $ 252,000 | 3500 | 72 | $ 252,000 | |||||||||||
14-Mar | Sale | 1950 | 72 | $140,400 | 2300 | 60 | $ 138,000 | 1950 | 60 | $117,000 | 350 | 60 | $ 21,000 | |||
1550 | 72 | $ 111,600 | 3500 | 72 | $ 252,000 | |||||||||||
1-May | Purchases | 2200 | 90 | $198,000 | 2300 | 60 | $ 138,000 | 350 | 60 | $ 21,000 | ||||||
1550 | 72 | $ 111,600 | 3500 | 72 | $ 252,000 | |||||||||||
2200 | 90 | $ 198,000 | 2200 | 90 | $ 198,000 | |||||||||||
31-Aug | Sale | 2200 | 90 | $198,000 | 2300 | 60 | $ 138,000 | 350 | 60 | $21,000 | 1450 | 72 | $ 104,400 | |||
200 | 72 | $14,400 | 1350 | 72 | $ 97,200 | 2050 | 72 | $147,600 | 2200 | 90 | $ 198,000 |
Amount of goods available for sale = Balance after 31st aug sale = $138000+$97200 = $235,200
Ending inventory 2300units @ $60 & 1350 units @ $72
Cost of goods sold = ΣIssue cost = 140400+198000+14400 = $352,800
ii) Under FIFO method:
Amount of goods available for sale = Balance after 31st aug sale = $104400+$198000 = $302,400
Ending inventory 1450units @ $72 & 2200 units @ $90
Cost of goods sold = ΣIssue cost = 117000+21000+147600 = $285,600
iii) Weighted average method:
Receipt | Issue | Balance | ||||||||
Date | Transaction | Units | Rate | Cost | Units | Rate | Cost | Units | Rate | Cost |
1-Jan | Opening Balance | 2300 | 60 | $ 138,000 | ||||||
30-Jan | Purchases | 3500 | 72 | $252,000 | 5800 | $ 67.24 | $ 390,000 | |||
14-Mar | Sale | 1950 | $67.24 | $131,121 | 3850 | $ 67.24 | $ 258,879 | |||
1-May | Purchases | 2200 | 90 | $198,000 | 6050 | $ 75.52 | $ 456,879 | |||
31-Aug | Sale | 2400 | $75.52 | $181,241 | 3650 | $ 75.52 | $ 275,638 |
Amount of goods available for sale = Balance after 31st aug sale = $275,638
Ending inventory 3650units @ $75.52
Cost of goods sold = ΣIssue cost = 131121+181241 = $312,362
iv) Specific identification method:
Receipt | Issue | Balance | ||||||||
Date | Transaction | Units | Rate | Cost | Units | Rate | Cost | Units | Rate | Cost |
1-Jan | Opening Balance | 2300 | 60 | $ 138,000 | ||||||
30-Jan | Purchases | 3500 | 72 | $252,000 | 2300 |
Related SolutionsGladstone Company tracks the number of units purchased and sold throughout each accounting period but applies...Gladstone Company tracks the number of units purchased and sold
throughout each accounting period but applies its inventory costing
method at the time of each sale, as if it uses a perpetual
inventory system. Assume its accounting records provided the
following information at the end of the annual accounting period,
December 31.
Transactions
Units
Unit Cost
Beginning inventory, January 1
1,400
$
50
Transactions during the year:
a.
Purchase, January 30
2,100
62
b.
Sale, March 14
($100 each)
(1,370...
Gladstone Company tracks the number of units purchased and sold throughout each accounting period but applies...
Gladstone Company tracks the number of units purchased and sold
throughout each accounting period but applies its inventory costing
method at the end of each period, as if it uses a periodic
inventory system. Assume its accounting records provided the
following information at the end of the annual accounting period,
December 31.
Transactions
Units
Unit Cost
Beginning inventory, January 1
3,400
$
50
Transactions during the year:
a.
Purchase, January 30
4,700
65
b.
Sale, March 14 ($100 each)
(3,050...
Gladstone Company tracks the number of units purchased and sold throughout each accounting period but applies...Gladstone Company tracks the number of units purchased and sold
throughout each accounting period but applies its inventory costing
method at the end of each period, as if it uses a periodic
inventory system. Assume its accounting records provided the
following information at the end of the annual accounting period,
December 31.
Transactions
Units
Unit Cost
Beginning inventory, January 1
1,600
$
45
Transactions during the year:
a.
Purchase, January 30
2,300
49
b.
Sale, March 14 ($100 each)
(1,250...
Gladstone Company tracks the number of units purchased and sold throughout each accounting period but applies...
Gladstone Company tracks the number of units purchased and sold
throughout each accounting period but applies its inventory costing
method at the end of each period, as if it uses a periodic
inventory system. Assume its accounting records provided the
following information at the end of the annual accounting period,
December 31.
Transactions
Units
Unit Cost
Beginning inventory, January 1
1,100
$
50
Transactions during the year:
a.
Purchase, January 30
2,150
60
b.
Sale, March 14 ($100 each)
(750...
Gladstone Company tracks the number of units purchased and sold throughout each accounting period but applies...Gladstone Company tracks the number of units purchased and sold
throughout each accounting period but applies its inventory costing
method at the end of each period, as if it uses a periodic
inventory system. Assume its accounting records provided the
following information at the end of the annual accounting period,
December 31.
Transactions
Units
Unit Cost
Beginning inventory, January 1
3,200
$
45
Transactions during the year:
a.
Purchase, January 30
4,550
55
b.
Sale, March 14 ($100 each)
(2,850...
Gladstone Company tracks the number of units purchased and sold throughout each accounting period but applies...Gladstone Company tracks the number of units purchased and sold
throughout each accounting period but applies its inventory costing
method at the end of each period, as if it uses a periodic
inventory system. Assume its accounting records provided the
following information at the end of the annual accounting period,
December 31.
Transactions
Units
Unit Cost
Beginning inventory, January 1
1,600
$
40
Transactions during the year:
a.
Purchase, January 30
3,650
54
b.
Sale, March 14 ($100 each)
(2,000...
Gladstone Company tracks the number of units purchased and sold throughout each accounting period but applies...Gladstone Company tracks the number of units purchased and sold
throughout each accounting period but applies its inventory costing
method at the end of each period, as if it uses a periodic
inventory system. Assume its accounting records provided the
following information at the end of the annual accounting period,
December 31.
Transactions
Units
Unit Cost
Beginning inventory,
January 1
1,700
$
50
Transactions during
the year:
a.
Purchase, January
30
3,200
63
b.
Sale, March 14 ($100 each)
(1,350...
Gladstone Company tracks the number of units purchased and sold throughout each accounting period but applies...
Gladstone Company tracks the number of units purchased and sold
throughout each accounting period but applies its inventory costing
method at the end of each period, as if it uses a periodic
inventory system. Assume its accounting records provided the
following information at the end of the annual accounting period,
December 31.
Transactions
Units
Unit Cost
Beginning inventory, January 1
1,800
$
50
Transactions during the year:
a.
Purchase, January 30
2,500
62
b.
Sale, March 14 ($100 each)
(1,450...
Gladstone Company tracks the number of units purchased and sold throughout each accounting period but applies...Gladstone Company tracks the number of units purchased and sold
throughout each accounting period but applies its inventory costing
method at the end of each period, as if it uses a periodic
inventory system. Assume its accounting records provided the
following information at the end of the annual accounting period,
December 31.
Transactions
Units
Unit Cost
Beginning inventory, January 1
3,200
$
45
Transactions during the year:
a.
Purchase, January 30
4,550
55
b.
Sale, March 14 ($100 each)
(2,850...
Gladstone Company tracks the number of units purchased and sold throughout each accounting period but applies...Gladstone Company tracks the number of units purchased and sold
throughout each accounting period but applies its inventory costing
method at the end of each period, as if it uses a periodic
inventory system. Assume its accounting records provided the
following information at the end of the annual accounting period,
December 31.
Transactions
Units
Unit Cost
Beginning inventory, January 1
1,800
$
50
Transactions during the year:
a.
Purchase, January 30
2,500
62
b.
Sale, March 14 ($100 each)
(1,450...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|