The beginning inventory at Dunne Co. and data on purchases and sales for a three

Question

The beginning inventory at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows Number Date Transaction of Units Per Unit Total Apr. 3 Inventory $225 270 750 750 300 $13,500 32,400 60,000 37,500 30,000 45,000 22,500 8 Purchase 120 11 Sale 30 Sale May 8 Purchase 10 Sale 19 Sale 50 100 28 Purchase 330 60 80 180 90 June 5 Sale 16 Sale 21 Purchase 28 Sale 64,800 71,100 Required: 1. Record the inventory, purchases, and cost of merchandise sold data in a perpetual inventory record similar to the one illustrated in Exhibit 3, using the first-in, first-out method. Under FIFO, if units Sold Unit Cost column and in the Inventory Unit Cost column are in inventory at two different costs, enter the units with the LOWER unit cost first in the Cost of Goods

Explanation / Answer

Solution:

Computation of ending inventory COGS under FIFO Date Beginning Inventory Purchase Cost of Goods Sold Ending Inventory Qty Rate Amount Qty Rate Amount Qty Rate Amount Qty Rate Amount 3-Apr 60 $225.00 $13,500.00 0 $0.00 $0.00 0 $0.00 $0.00 60 $225.00 $13,500.00 8-Apr 60 $225.00 $13,500.00 120 $270.00 $32,400.00 0 $0.00 $0.00 60 $225.00 $13,500.00 120 $270.00 $32,400.00 11-Apr 60 $225.00 $13,500.00 0 $0.00 $0.00 60 $225.00 $13,500.00 100 $270.00 $27,000.00 120 $270.00 $32,400.00 20 $270.00 $5,400.00 30-Apr 100 $270.00 $27,000.00 0 $0.00 $0.00 50 $270.00 $13,500.00 50 $270.00 $13,500.00 8-May 50 $270.00 $13,500.00 100 $300.00 $30,000.00 0 $0.00 $0.00 50 $270.00 $13,500.00 100 $300.00 $30,000.00 10-May 50 $270.00 $13,500.00 0 $0.00 $0.00 50 $270.00 $13,500.00 90 $300.00 $27,000.00 100 $300.00 $30,000.00 10 $300.00 $3,000.00 19-May 90 $300.00 $27,000.00 0 $0.00 $0.00 30 $300.00 $9,000.00 60 $300.00 $18,000.00 28-May 60 $300.00 $18,000.00 100 $330.00 $33,000.00 0 $0.00 $0.00 60 $300.00 $18,000.00 100 $330.00 $33,000.00 5-Jun 60 $300.00 $18,000.00 0 $0.00 $0.00 60 $300.00 $18,000.00 100 $330.00 $33,000.00 100 $330.00 $33,000.00 16-Jun 100 $330.00 $33,000.00 0 $0.00 $0.00 80 $330.00 $26,400.00 20 $330.00 $6,600.00 21-Jun 20 $330.00 $6,600.00 180 $360.00 $64,800.00 0 $0.00 $0.00 20 $330.00 $6,600.00 180 $360.00 $64,800.00 28-Jun 20 $330.00 $6,600.00 0 $0.00 $0.00 20 $330.00 $6,600.00 110 $360.00 $39,600.00 180 $360.00 $64,800.00 70 $360.00 $25,200.00 Total $134,100.00 $39,600.00

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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