Question

In: Accounting

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

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 72 $225 $16,200
8 Purchase 144 270 38,880
11 Sale 96 750 72,000
30 Sale 60 750 45,000
May 8 Purchase 120 300 36,000
10 Sale 72 750 54,000
19 Sale 36 750 27,000
28 Purchase 120 330 39,600
June 5 Sale 72 790 56,880
16 Sale 96 790 75,840
21 Purchase 216 360 77,760
28 Sale 108 790 85,320

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 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.

2. Determine the total sales and the total cost of merchandise sold for the period. Journalize the entries in the sales and cost of merchandise sold accounts. Assume that all sales were on account.

Solutions

Expert Solution

Solution 1:

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 72 $225.00 $16,200.00 0 $0.00 $0.00 0 $0.00 $0.00 72 $225.00 $16,200.00
8-Apr 72 $225.00 $16,200.00 144 $270.00 $38,880.00 0 $0.00 $0.00 72 $225.00 $16,200.00
144 $270.00 $38,880.00
11-Apr 72 $225.00 $16,200.00 0 $0.00 $0.00 72 $225.00 $16,200.00 120 $270.00 $32,400.00
144 $270.00 $38,880.00 24 $270.00 $6,480.00
30-Apr 120 $270.00 $32,400.00 0 $0.00 $0.00 60 $270.00 $16,200.00 60 $270.00 $16,200.00
8-May 60 $270.00 $16,200.00 120 $300.00 $36,000.00 0 $0.00 $0.00 60 $270.00 $16,200.00
120 $300.00 $36,000.00
10-May 60 $270.00 $16,200.00 0 $0.00 $0.00 60 $270.00 $16,200.00 108 $300.00 $32,400.00
120 $300.00 $36,000.00 12 $300.00 $3,600.00
19-May 108 $300.00 $32,400.00 0 $0.00 $0.00 36 $300.00 $10,800.00 72 $300.00 $21,600.00
28-May 72 $300.00 $21,600.00 120 $330.00 $39,600.00 0 $0.00 $0.00 72 $300.00 $21,600.00
120 $330.00 $39,600.00
5-Jun 72 $300.00 $21,600.00 0 $0.00 $0.00 72 $300.00 $21,600.00 120 $330.00 $39,600.00
120 $330.00 $39,600.00
16-Jun 120 $330.00 $39,600.00 0 $0.00 $0.00 96 $330.00 $31,680.00 24 $330.00 $7,920.00
21-Jun 24 $330.00 $7,920.00 216 $360.00 $77,760.00 0 $0.00 $0.00 24 $330.00 $7,920.00
216 $360.00 $77,760.00
28-Jun 24 $330.00 $7,920.00 0 $0.00 $0.00 24 $330.00 $7,920.00 132 $360.00 $47,520.00
216 $360.00 $77,760.00 84 $360.00 $30,240.00
Total $160,920.00 $47,520.00

Solution 2:

Computation of Sales
Date Sales Qty Selling Price Sale Value
11-Apr 96 $750.00 $72,000.00
30-Apr 60 $750.00 $45,000.00
10-May 72 $750.00 $54,000.00
19-May 36 $750.00 $27,000.00
5-Jun 72 $790.00 $56,880.00
16-Jun 96 $790.00 $75,840.00
28-Jun 108 $790.00 $85,320.00
Total 540 $416,040.00

Total cost of merchandise sold = $160,920

Journal Entries - Dunne Co.
Particulars Debit Credit
Accounts Receivables Dr $416,040.00
            To Sale Revenue $416,040.00
(Being sales recorded for the quarter)
Cost of merchandise sold Dr $160,920.00
            To Inventory $160,920.00
(Being inventories sold transferred to cost of merchandise sold account)

Related Solutions

The beginning inventory of merchandise at Dunne Co. and data on purchases and sales for a...
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 $375 $31,500 8 Purchase 168 450 75,600 11 Sale 113 1,250 141,250 30 Sale 71 1,250 88,750 May 8 Purchase 140 500 70,000 10 Sale 84 1,250 105,000 19 Sale 42 1,250 52,500 28 Purchase 140 550 77,000 June 5 Sale 84 1,315 110,460...
The beginning inventory of merchandise at Dunne Co. and data on purchases and sales for a...
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 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...
The beginning inventory of merchandise at Dunne Co. and data on purchases and sales for a...
The beginning inventory of merchandise at Dunne Co. and data on purchases and sales for a three-month period ending June 30, 2016, 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...
FIFO Perpetual Inventory The beginning inventory of merchandise at Dunne Co. and data on purchases and...
FIFO 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 60 $300 $18,000 8 Purchase 120 360 43,200 11 Sale 80 1,000 80,000 30 Sale 50 1,000 50,000 May 8 Purchase 100 400 40,000 10 Sale 60 1,000 60,000 19 Sale 30 1,000 30,000 28 Purchase 100 440 44,000 June 5 Sale...
LIFO Perpetual Inventory The beginning inventory of merchandise at Dunne Co. and data on purchases and...
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 48 $600 $28,800 8 Purchase 96 720 69,120 11 Sale 64 2,000 128,000 30 Sale 40 2,000 80,000 May 8 Purchase 80 800 64,000 10 Sale 48 2,000 96,000 19 Sale 24 2,000 48,000 28 Purchase 80 880 70,400 June 5 Sale...
FIFO Perpetual Inventory The beginning inventory of merchandise at Dunne Co. and data on purchases and...
FIFO 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 48 $525 $25,200 8 Purchase 96 630 60,480 11 Sale 64 1,750 112,000 30 Sale 40 1,750 70,000 May 8 Purchase 80 700 56,000 10 Sale 48 1,750 84,000 19 Sale 24 1,750 42,000 28 Purchase 80 770 61,600 June 5 Sale...
LIFO Perpetual Inventory The beginning inventory of merchandise at Dunne Co. and data on purchases and...
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 42 $525 $22,050 8 Purchase 84 630 52,920 11 Sale 56 1,750 98,000 30 Sale 35 1,750 61,250 May 8 Purchase 70 700 49,000 10 Sale 42 1,750 73,500 19 Sale 21 1,750 36,750 28 Purchase 70 770 53,900 June 5 Sale...
LIFO Perpetual Inventory The beginning inventory of merchandise at Dunne Co. and data on purchases and...
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,    $225,    $18,900 8    Purchase 168, 270, 45,360 11 Sale 113,    750, 84,750 30 Sale 71,    750,    53,250 May 8    Purchase 140,    300,    42,000 10 Sale    84,...
FIFO Perpetual Inventory The beginning inventory of merchandise at Dunne Co. and data on purchases and...
FIFO 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 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...
FIFO perpetual inventory The beginning inventory of merchandise at Dunne Co. and data on purchases and...
FIFO perpetual inventory The beginning inventory of merchandise at Dunne Co. and data on purchases and sales for a three-month period ending June 30, 2016, 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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT