Can someone tell me what the error is in my cost of merchandise sold schedule, i

Question

Can someone tell me what the error is in my cost of merchandise sold schedule, it keeps telling me something is wrong in my schedule but I am not sure what I have done wrong! This is all the information given.

Perpetual Inventory Using FIFO Beginning inventory, purchases, and sales data for portable DVD players are as follows: Apr. 1 10 15 20 24 30 Inventory Sale Purchase Sale Sale Purchase 69 units @ $89 53 units 34 units $93 22 units 11 units 37 units @ $97 The business maintains a perpetual inventory system, costing by the first-in, first-out method Determine the cost of the merchandise sold for each sale and the inventory balance after each sale, presenting the data in the form illustrated in Exhibit 3 a. Under FIFO, if units are in inventory at two different costs, enter the units with the LOWER unit cost first in the Cost of Merchandise Sold Unit Cost column and in the Inventory Unit Cost column

Explanation / Answer

FIFO Purchases UNITS SOLD Closing Stock QTY RATE Amt QTY RATE Amt QTY RATE Amt 01-Apr 69 $     89.00 $    6,141.00 69 $     89.00 $ 6,141.00 10-Apr 53 $     89.00 $ 4,717.00 16 $     89.00 $ 1,424.00 15-Apr 34 $     93.00 $    3,162.00 16 $     89.00 $ 1,424.00 34 $     93.00 $ 3,162.00 20-Apr 16 $     89.00 $ 1,424.00 28 $     93.00 $ 2,604.00 6 $     93.00 $     558.00 24-Apr 11 $     93.00 $ 1,023.00 17 $     93.00 $ 1,581.00 30-Apr 37 $     97.00 $    3,589.00 0 $            -   $               -   17 $     93.00 $ 1,581.00 37 $     97.00 $ 3,589.00 1325 $ 12,892.00 1035 $ 7,722.00 $ 5,170.00 LIFO Purchases UNITS SOLD Closing Stock QTY RATE Amt QTY RATE Amt QTY RATE Amt 01-Apr 69 $     89.00 $    6,141.00 69 $     89.00 $ 6,141.00 10-Apr 53 $     89.00 $ 4,717.00 16 $     89.00 $ 1,424.00 15-Apr 34 $     93.00 $    3,162.00 16 $     89.00 $ 1,424.00 34 $     93.00 $ 3,162.00 20-Apr 16 $     89.00 $ 1,424.00 22 $     93.00 $ 2,046.00 12 $     93.00 $ 1,116.00 24-Apr 11 $     93.00 $ 1,023.00 16 $     89.00 $ 1,424.00 1 $     93.00 $        93.00 30-Apr 37 $     97.00 $    3,589.00 0 $            -   $               -   16 $     89.00 $ 1,424.00 1 $     93.00 $        93.00 37 $     97.00 $ 3,589.00 1325 $ 12,892.00 1035 $ 7,786.00 $ 5,106.00 Closing Inventory as per FIFO $5,170 Closing Inventory as per LIFO $5,106 The closing inventory as prr FIFO is higher than inventor as per LIFO

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.