LIFO Perpetual Inventory
The beginning inventory for Dunne Co. and data on purchases and sales for a three-month period are as follows:
Date | Transaction | Number of Units |
Per Unit | Total | ||||
Apr. 3 | Inventory | 25 | $1,200 | $30,000 | ||||
8 | Purchase | 75 | 1,240 | 93,000 | ||||
11 | Sale | 40 | 2,000 | 80,000 | ||||
30 | Sale | 30 | 2,000 | 60,000 | ||||
May 8 | Purchase | 60 | 1,260 | 75,600 | ||||
10 | Sale | 50 | 2,000 | 100,000 | ||||
19 | Sale | 20 | 2,000 | 40,000 | ||||
28 | Purchase | 80 | 1,260 | 100,800 | ||||
June 5 | Sale | 40 | 2,250 | 90,000 | ||||
16 | Sale | 25 | 2,250 | 56,250 | ||||
21 | Purchase | 35 | 1,264 | 44,240 | ||||
28 | Sale | 44 | 2,250 | 99,000 |
Required:
1. Record the inventory, purchases, and cost of goods sold data in a perpetual inventory record similar to the one illustrated in Exhibit 4, using the last-in, first-out method. Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Goods Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column.
Correct Answer:
Total sales |
$ 525,250.00 |
Total cost of goods sold |
$ 312,080.00 |
Gross profit |
$ 213,170.00 |
Ending inventory |
26 units |
$ 31,560.00 |
Working:
Perpetual LIFO |
|||||||||
Date |
Goods Purchased |
Cost of Goods Sold |
Inventory Balance |
||||||
# of Units |
Cost Per Unit |
Cost of Goods Available for sale |
# of Units Sold |
Cost per Unit |
Cost of Goods Sold |
# of Units |
Cost per Unit |
Inventory Balance |
|
03-Apr |
25 |
$ 1,200.00 |
$ 30,000.00 |
||||||
08-Apr |
75 |
$ 1,240.00 |
$ 93,000.00 |
75 |
$ 1,240.00 |
$ 93,000.00 |
|||
25 |
$ 1,200.00 |
$ 30,000.00 |
|||||||
11-Apr |
40 |
$ 1,240.00 |
$ 49,600.00 |
35 |
$ 1,240.00 |
$ 43,400.00 |
|||
25 |
$ 1,200.00 |
$ 30,000.00 |
|||||||
30-Apr |
30 |
$ 1,240.00 |
$ 37,200.00 |
5 |
$ 1,240.00 |
$ 6,200.00 |
|||
25 |
$ 1,200.00 |
$ 30,000.00 |
|||||||
08-May |
60 |
$ 1,260.00 |
$ 75,600.00 |
60 |
$ 1,260.00 |
$ 75,600.00 |
|||
5 |
1240 |
$ 6,200.00 |
|||||||
25 |
$ 1,200.00 |
$ 30,000.00 |
|||||||
10-May |
50 |
$ 1,260.00 |
$ 63,000.00 |
10 |
$ 1,260.00 |
$ 12,600.00 |
|||
5 |
$ 1,240.00 |
$ 6,200.00 |
|||||||
25 |
$ 1,200.00 |
$ 30,000.00 |
|||||||
19-May |
10 |
$ 1,260.00 |
$ 12,600.00 |
20 |
$ 1,200.00 |
$ 24,000.00 |
|||
5 |
$ 1,240.00 |
$ 6,200.00 |
|||||||
5 |
$ 1,200.00 |
$ 6,000.00 |
|||||||
28-May |
80 |
$ 1,260.00 |
$ 100,800.00 |
80 |
$ 1,260.00 |
$ 100,800.00 |
|||
20 |
$ 1,200.00 |
$ 24,000.00 |
|||||||
05-Jun |
40 |
$ 1,260.00 |
$ 50,400.00 |
40 |
$ 1,260.00 |
$ 50,400.00 |
|||
20 |
$ 1,200.00 |
$ 24,000.00 |
|||||||
16-Jun |
25 |
$ 1,260.00 |
$ 31,500.00 |
15 |
$ 1,260.00 |
$ 18,900.00 |
|||
20 |
$ 1,200.00 |
$ 24,000.00 |
|||||||
21-Jun |
35 |
$ 1,264.00 |
$ 44,240.00 |
35 |
$ 1,264.00 |
$ 44,240.00 |
|||
15 |
$ 1,260.00 |
$ 18,900.00 |
|||||||
20 |
$ 1,200.00 |
$ 24,000.00 |
|||||||
28-Jun |
35 |
$ 1,264.00 |
$ 44,240.00 |
6 |
$ 1,260.00 |
$ 7,560.00 |
|||
9 |
$ 1,260.00 |
$ 11,340.00 |
20 |
$ 1,200.00 |
$ 24,000.00 |
||||
Totals |
250 |
$ 313,640.00 |
249 |
$ 312,080.00 |
26 |
$ 31,560.00 |
End of answer.
Please give a thumbs-up, it will be highly appreciated.
Thanks
LIFO Perpetual Inventory The beginning inventory for Dunne Co. and data on purchases and sales for...
Weighted average method cost LIFO Perpetual Inventory The beginning inventory for Dunne Co. and data on purchases and sales for a Number of Units Date Transaction Per Unit Total Apr. 3 Inventory $1,200 8 Purchase 1,240 $30,000 93,000 80,000 60,000 11 Sale 2,000 30 Sale May 8 10 2,000 1,260 2,000 Sale 19 28 June 5 Sale Purchase Sale 2,000 1,260 75,600 100,000 40,000 100,800 90,000 16 Sale 56,250 2,250 252,250 1,264 2,250 21 Purchase 44,240 28 Sale 99,000 Legg...
.............. Weighted Average Cost Method with Perpetual Inventory The beginning inventory for Dunne Co. and data on purchases and sales for a three-month period are as follows: Number of Units Date Transaction Per Unit Total Apr. 3 8 Inventory Purchase $1,200 1,240 $30,000 93,000 80,000 11 Sale 2,000 30 Sale 2,000 60,000 May 8 Purchase 1,260 75,600 10 Sale 2,000 100,000 40,000 Sale 2,000 28 Purchase 1,260 100,800 June 5 Sale 2,250 2,250 16 21 Sale Purchase 90,000 56,250 44,240...
Weighted Average Cost Method with Perpetual Inventory The beginning inventory for Dunne Co. and data on purchases and sales for a three-month period are as follows: Date Transaction Number of Units Per Unit Total Apr. 3 Inventory 25 $1,200 $30,000 8 Purchase 75 1,240 93,000 11 Sale 40 2,000 80,000 30 Sale 30 2,000 60,000 May 8 Purchase 60 1,260 75,600 10 Sale 50 2,000 100,000 19 Sale 20 2,000 40,000 28 Purchase 80 1,260 100,800 June 5 Sale 40...
..................... LIFO Perpetual Inventory The beginning inventory at Dunne Co. and data on purchases and sales for a three-month period are as follows: Number Total of Units Date Transaction Per Unit 375 24,750 Apr. 3 Inventory 66 Purchase 8 132 450 59,400 11 Sale 88 1,250 110,000 30 Sale 55 1,250 68,750 Purchase 55,000 May 8 110 500 Sale 10 66 1,250 82,500 Sale 19 33 1,250 41,250 550 Purchase 28 110 60,500 Sale June 5 66 1,315 86,790 Sale...
LIFO Perpetual Inventory The beginning inventory at Dunne Co. and data on purchases and sales for a three-month period are as follows: Date Transaction Number of Units Per Unit Total Apr. 3 Inventory 66 $ 300 $ 19,800 8 Purchase 132 360 47,520 11 Sale 88 1,000 88,000 30 Sale 55 1,000 55,000 May 8 Purchase 110 400 44,000 10 Sale 66 1,000 66,000 19 Sale 33 1,000 33,000 28 Purchase 110 440 48,400 June 5 Sale 66 1,050 69,300...
FIFO Perpetual Inventory The beginning inventory of merchandise at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows: Number of Units Date Transaction Per Unit Total Apr. 3 Inventory $1,200 $30,000 8 Purchase 1,240 93,000 11 Sale 2,000 80,000 60,000 30 Sale May 8 Purchase 2,000 1,260 2,000 2,000 1,260 75,600 100,000 10 Sale 19 Sale 40.000 28 Purchase 100,800 June 5 Sale 2,250 90,000 16 Sale 2.250 56,250 21 Purchase...
LIFO Perpetual Inventory The beginning inventory at Dunne Co. and data on purchases and sales for a three-month period are as follows: Date Transaction Number of Units Per Unit Total Apr. 3 Inventory 54 $ 225 $ 12,150 8 Purchase 108 270 29,160 11 Sale 72 750 54,000 30 Sale 45 750 33,750 May 8 Purchase 90 300 27,000 10 Sale 54 750 40,500 19 Sale 27 750 20,250 28 Purchase 90 330 29,700 June 5 Sale 54 790 42,660...
LIFO Perpetual Inventory The beginning inventory at Dunne Co. and data on purchases and sales for a three-month period are as follows: Number Date Transaction of Units Per Unit Total Apr. 3 Inventory 84 $450 $37,800 Purchase 168 540 90,720 11 Sale 113 1,500 169,500 Sale 30 71 1,500 106,500 May 8 Purchase 140 600 84,000 Sale 10 84 1,500 126,000 19 Sale 42 1,500 63,000 28 Purchase 140 660 92,400 June 5 Sale 84 1,575 132,300 16 Sale 112...
LIFO Perpetual Inventory The beginning inventory of merchandise at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows: Date Transaction Number of Units Per Unit Total Apr. 3 Inventory 84 $525 $44,100 8 Purchase 168 630 105,840 11 Sale 113 1,750 197,750 30 Sale 71 1,750 124,250 May 8 Purchase 140 700 98,000 10 Sale 84 1,750 147,000 19 Sale 42 1,750 73,500 28 Purchase 140 770 107,800 June 5 Sale...
LIFO Perpetual Inventory The beginning inventory of merchandise at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows: Date Transaction Number of Units Per Unit Total Apr. 3 Inventory 78 $450 $35,100 8 Purchase 156 540 84,240 11 Sale 105 1,500 157,500 30 Sale 66 1,500 99,000 May 8 Purchase 130 600 78,000 10 Sale 78 1,500 117,000 19 Sale 39 1,500 58,500 28 Purchase 130 660 85,800 June 5 Sale...