Perpetual inventory using LIFOBeginning inventory, purchases, and sales data for DVD players are as follows:Nov, 1 Inventory 140 units at $2910 Sale 110 units15 Purchase 150 units at $3020 Sale 120 units24 Sale 35 units30 Purchase 140 units at $34The business maintains a perpetual inventory system, costing by the last-in, first-out method.Determine the cost of goods sold for each sale and the inventory balance after each sale, presenting the data in the form illustrated in Exhibit 4. Un 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.LIFO Method
Q. Perpetual inventory using LIFOBeginning inventory, purchases, and sales data for DVD players are as follows:Nov, 1 Inventory 140 units at $2910 Sale 110 units15 Purchase 150 units at $3020 Sale 120 units24 Sale 35 units30 Purchase 140 units at $34The business maintains a perpetual inventory system, costing by the last-in, first-out method.Determine the cost of goods sold for each sale and the inventory balance after each sale, presenting the data in the form illustrated in Exhibit 4. Un 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.LIFO Method
Initial Inventory Calculation: Begin with the initial inventory on November 1.We have 140 units at $29 each.Total inventory value = 140 units ∗$29/unit = $4060.
First Sale and Cost of Goods Sold: First sale on November 10 of 110 units.Under LIFO, we sell the oldest units first. Since we only have the initial inventory, we sell 110 units at $29 each.Cost of goods sold for this sale = 110 units ∗$29/unit = $3190.Remaining inventory = 140 units - 110 units = 30 units at $29 each.
Purchase on November 15: Purchase on November 15 of 150 units at $30 each.New inventory added = 150 units ∗$30/unit = $4500.Total inventory now consists of 30 units at $29 each and 150 units at $30 each.
Second Sale and Cost of Goods Sold: Second sale on November 20 of 120 units.Under LIFO, we sell the most recently purchased units first. We have 150 units at $30 each, so we sell 120 units from this batch.Cost of goods sold for this sale = 120 units ∗$30/unit = $3600.Remaining inventory now consists of 30 units at $29 each and 30 units at $30 each.
Third Sale and Cost of Goods Sold: Third sale on November 24 of 35 units.Under LIFO, we continue to sell the most recently purchased units first. We have 30 units at $30 each and 30 units at $29 each. We sell all 30 units at $30 each and 5 units at $29 each.Cost of goods sold for this sale = (30 units∗$30/unit)+(5 units∗$29/unit)=$900+$145=$1045.Remaining inventory now consists of 300 units at $29 each.
Purchase on November 30: Purchase on November 30 of 140 units at $34 each.New inventory added = 140 units ∗$34/unit = $4760.Total inventory now consists of 25 units at $29 each and 140 units at $34 each.
Final Inventory Balance Calculation: Calculate the final inventory balance after all sales and purchases.Remaining inventory = 25unitsat$29each + 140unitsat$34each = \$\(725\) + \$\(4760\) = \$\(5485\).