LIFO: | Perpectual | |||||||
Goods Purchased | Cost of Goods Sold | Inventory Balance | ||||||
Date | # of units | Cost per unit | # of units sold | Cost per unit | Cost of Goods Sold | # of units | Cost per unit | Inventory Balance |
3-Apr | 42 | 225 | 9450 | |||||
8-Apr | 84 | 270 | 42 | 225 | 9450 | |||
84 | 270 | 22680 | ||||||
11-Apr | 56 | 270 | 15120 | 42 | 225 | 9450 | ||
28 | 270 | 7560 | ||||||
30-Apr | 28 | $270.00 | $7,560 | 35 | 225 | $ 7,875 | ||
7 | 225 | $1,575 | ||||||
$9,135 | ||||||||
8-May | 70 | 300 | 35 | 225 | $ 7,875 | |||
70 | 300 | 21000 | ||||||
10-May | 42 | 300 | 12600 | 35 | 225 | 7875 | ||
28 | 300 | 8400 | ||||||
19-May | 21 | 300 | 6300 | 35 | 225 | 7875 | ||
7 | 300 | 2100 | ||||||
28-May | 70 | 330 | 35 | 225 | 7875 | |||
7 | 300 | 2100 | ||||||
70 | 330 | 23100 | ||||||
5-Jun | 42 | 330 | 13860 | 35 | 225 | 7875 | ||
7 | 300 | 2100 | ||||||
28 | 225 | 6300 | ||||||
16-Jun | 28 | 225 | 6300 | |||||
7 | 300 | 2100 | ||||||
21 | 225 | 4725 | 14 | 225 | 3150 | |||
13125 | ||||||||
21-Jun | 126 | 360 | 14 | 225 | 3150 | |||
126 | 360 | 45360 | ||||||
28-Jun | 63 | 360 | 22680 | |||||
14 | 225 | 3150 | ||||||
63 | 360 | 22680 | ||||||
Totals | $92,820.00 | 77 | $25,830.00 |
eBook Show Me How Calculator LIFO Perpetual Inventory The beginning inventory at Dunne Co. and data...
eBook Show Me How Calculator FIFO Perpetual Inventory The beginning inventory at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows: Date Number of Units Transaction Inventory Purchase Sale Apr. 3 8 11 Per Unit $375 450 Total $29,250 1,250 30 Sale 1,250 500 May 8 10 19 Purchase Sale Sale 1,250 70,200 130,000 81,250 65,000 97,500 48,750 71,500 102,570 136,760 1,250 550 28 Purchase 130 June 5 Sale 1,315 16...
eBook Show Me How Calculator FIFO Perpetual Inventory The beginning inventory at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows: Date TransactionNumber of UnitsPer UnitTotal Apr. 3 Inventory90 $600 $54,000 8 Purchase180 720 129,600 11 Sale120 2,000 240,000 30 Sale75 2,000 150,000 May 8 Purchase150 800 120,000 10 Sale90 2,000 180,000 19 Sale45 2,000 90,000 28 Purchase150 880 132,000 June 5 Sale90 2,100 189,000 16 Sale120 2,100 252,000 21 Purchase270 960...
jan. 1 inventory 10,000 units
The
beginning inventory at Dunne Co. and data on purxhasea
iru Perpetual inventory The beginning inventory at Dunne Co. and data on purchases and sales for a three-month period ending June ding June 30 are as follows: Number of Units Date Apr. 3 Per Unit Total Transaction Inventory Purchase 42 $450 $18,900 8 540 1,500 11 Sale Sale 1,500 30 May 8 Purchase 600 1,500 Sale Sale 1,500 660 19 28 June 5 16 21...
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...
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 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...
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 $32,400 77,760 8 Purchase $450 540 1,500 1,500 11 Sale 144,000 30 Sale 90,000 May 8 Purchase 600 72,000 10 Sale 19 Sale 36 . 1,500 1,500 660 1,575 108,000 54,000 79,200 28 Purchase June 5 Sale 113,400 1.575 16 21 Sale...
.....................
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 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...