Perpetual Inventory Using LIFO
Beginning inventory, purchases, and sales data for portable game players are as follows:
Apr. 1 | Inventory | 56 units @ $76 | |
10 | Sale | 40 units | |
15 | Purchase | 68 units @ $79 | |
20 | Sale | 39 units | |
24 | Sale | 12 units | |
30 | Purchase | 26 units @ $84 |
The business maintains a perpetual inventory system, costing by the last-in, first-out method.
Determine the cost of merchandise sold for each sale and the inventory balance after each sale, presenting the data in the form illustrated in Exhibit 4.
Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Merchandise Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column.
Correct Answer:
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 |
|
01-Apr |
56 |
$ 76.00 |
$ 4,256.00 |
||||||
10-Apr |
40 |
$ 76.00 |
$ 3,040.00 |
16 |
$ 76.00 |
$ 1,216.00 |
|||
15-Apr |
68 |
$ 79.00 |
$ 5,372.00 |
68 |
79 |
$ 5,372.00 |
|||
16 |
$ 76.00 |
$ 1,216.00 |
|||||||
20-Apr |
39 |
$ 79.00 |
$ 3,081.00 |
29 |
$ 79.00 |
$ 2,291.00 |
|||
16 |
$ 76.00 |
$ 1,216.00 |
|||||||
24-Apr |
12 |
$ 79.00 |
$ 948.00 |
17 |
$ 79.00 |
$ 1,343.00 |
|||
16 |
$ 76.00 |
$ 1,216.00 |
|||||||
30-Apr |
26 |
$ 84.00 |
$ 2,184.00 |
26 |
$ 84.00 |
$ 2,184.00 |
|||
17 |
$ 79.00 |
$ 1,343.00 |
|||||||
16 |
$ 76.00 |
$ 1,216.00 |
|||||||
Cost of goods sold |
Ending Inventory |
||||||||
Total |
91 |
$ 7,069.00 |
59 |
$ 4,743.00 |
End of answer.
Please give a thumbs-up, it will be highly appreciated.
Thanks.
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for portable game players are as...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for portable game players are as follows: Apr. 1 Inventory 77 units @ $76 10 Sale 56 units 15 Purchase 98 units @ $80 20 Sale 57 units 24 Sale 15 units 30 Purchase 27 units @ $84 The business maintains a perpetual inventory system, costing by the last-in, first-out method. Determine the cost of merchandise sold for each sale and the inventory balance after each sale, presenting the data...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for portable game players are as follows: Apr. 1 Inventory 65 units @ $52 Sale 49 units 15 79 units $55 Purchase Sale 20 46 units 24 Sale 11 units Purchase 38 units $57 The business maintains a perpetual inventory system, costing by the last-in, first-out method. Determine the cost of merchandise sold for each sale and the inventory balance after each sale, presenting the data in the form illustrated...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for portable game players are as follows: 76 units@ $100 Apr. 1 Inventory Sale 55 units 10 Purchase 95 units @ $106 15 55 units Sale 20 Sale 14 units 24 Purchase 38 units @ $111 30 The business maintains a perpetual inventory system, costing by the last-in, first-out method. Determine the cost of merchandise sold for each sale and the inventory balance after each sale, presenting the data in...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for portable game players are as follows: Apr. 1 Inventory 46 units @ $65 10 Sale 35 units 15 Purchase 57 units @ $68 20 Sale 33 units 24 Sale 8 units 30 Purchase 38 units @ $71 The business maintains a perpetual inventory system, costing by the last-in, first-out method. Determine the cost of merchandise sold for each sale and the inventory balance after each sale, presenting the data...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for portable game players are as follows: Apr. 1 77 units @ $78 Inventory Sale 54 units Purchase 101 units @ $81 58 units 20 24 30 Sale Sale Purchase 16 units 21 units @ $85 The business maintains a perpetual inventory system, costing by the last-in, first-out method. Determine the cost of merchandise sold for each sale and the inventory balance after each sale, presenting the data in the...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for portable game players are as follows: Apr. 1 Inventory 36 units @ $41 10 Sale 24 units Purchase 46 units @ $43 26 units 20 24 Sale Sale 8 units 30 Purchase 32 units @ $46 The business maintains a perpetual inventory system, costing by the last-in, first-out method. Determine the cost of merchandise sold for each sale and the inventory balance after each sale, presenting the data in...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for portable game players are as follows: Apr. 1 Inventory 49 units @ $52 10 Sale 32 units 15 Purchase 63 units @ $55 20 Sale 36 units 24 Sale 9 units 30 Purchase 24 units @ $58 The business maintains a perpetual inventory system, costing by the last-in, first-out method. Determine the cost of merchandise sold for each sale and the inventory balance after each sale, presenting the data...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for portable game players are as follows: Apr. 1 Inventory 58 units @ $99 10 Sale 45 units 15 Purchase 77 units @ $104 20 Sale 42 units 24 Sale 13 units 30 Purchase 40 units @ $110 he business maintains a perpetual inventory system, costing by the last-in, first-out method. Determine the cost of merchandise sold for each sale and the inventory balance after each sale, presenting the data...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for portable game players are as follows: Aprг. 1 75 units $96 Inventory Sale 51 units 10 100 units @ $101 Purchase 15 Sale 57 units 20 15 units Sale 24 Purchase 32 units @$105 30 The business maintains a perpetual inventory system, costing by the last-in, first-out method Determine the cost of merchandise sold for each sale and the inventory balance after each sale, presenting the data in the...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for portable game players are as follows: Apr. 1 Inventory 64 units @ $44 10 Sale 42 units 15 Purchase 77 units @ $46 20 Sale 42 units 24 Sale 12 units 30 Purchase 27 units @ $48 The business maintains a perpetual inventory system, costing by the last-in, first-out method. Determine the cost of merchandise sold for each sale and the inventory balance after each sale, presenting the data...