LIFO method assumes that goods received later are sold first
perpetual method calculates inventory after every transaction
and not only at the end of period(month or year)
Dunne Co.
Schedule of Cost of Merchandise Sold
LIFO Method
For the three-months ended June 30 |
|
Purchases |
Cost of Merchandise
Sold |
Inventory |
Date |
Quantity |
Unit Cost |
Total Cost |
Quantity |
Unit Cost |
Total Cost |
Quantity |
Unit Cost |
Total Cost |
Apr. 3 |
42 |
$375 |
$15,750 |
|
|
|
42 |
$375 |
$15,750 |
Apr. 8 |
84 |
$450 |
$37,800 |
|
|
|
42 |
$375 |
$15,750 |
84 |
$450 |
$37,800 |
Apr. 11 |
|
|
|
56 |
$450 |
$25,200[56*$450] |
42 |
$375 |
$15,750 |
28[84-56] |
$450 |
$12,600 |
Apr. 30 |
|
|
|
28 |
$450 |
$12,600 [28*450] |
35[42-7] |
$375 |
$13,125 |
7[35-28] |
$375 |
$2,625 [7*375] |
May 8 |
70 |
$500 |
$35,000 |
|
|
|
35 |
$375 |
$13,125 |
70 |
$500 |
$35,000 |
May 10 |
|
|
|
42 |
$500 |
$21,000 |
35 |
$375 |
$13,125 |
28[70-42] |
$500 |
$14,000 |
May 19 |
|
|
|
21 |
$500 |
$10,500 |
35 |
$375 |
$13,125 |
7 |
$500 |
$3,500 |
May 28 |
70 |
$550 |
$38,500 |
|
|
|
35 |
$375 |
$13,125 |
7 |
$500 |
$3,500 |
70 |
$550 |
$38,500 |
June 5 |
|
|
|
42 |
$550 |
$23,100 |
35 |
$375 |
$13,125 |
7 |
$500 |
$3,500 |
[70-42]28 |
$550 |
$15,400 |
June 16 |
|
|
|
28 |
$550 |
$15,400 |
14[35-21] |
$375 |
$5,250 |
7 |
$500 |
$3,500 |
|
|
|
21[56-28-7] |
$375 |
$7,875 |
|
|
|
June 21 |
126 |
$600 |
$75,600 |
|
|
|
14 |
$375 |
$5,250 |
126 |
$600 |
$75,600 |
June 28 |
|
|
|
63 |
$600 |
$37,800 |
14 |
$375 |
$5,250 |
63[126-63] |
$600 |
$37,800 |
June 30 |
|
|
|
|
|
$159,600 |
77 |
|
$43,050[$5,250+37,800] |
2.
Total sales |
$404,215[$70,000+43,750+52,500+26,250+55,230+73,640+82,845] |
Total cost of merchandise sold |
$159,600 |
Gross profit |
$244,615 |
3.ending inventory ciost as on June 30 is $43,050 as can be seen
from above
Please upvote
if you find this helpful.Incase of query pelase
comment.