FIFO Perpetual InventoryThe beginning inventory of merchandise at Dunne Co. and data onpurchases and...FIFO...

Free

90.2K

Verified Solution

Question

Accounting

FIFO Perpetual Inventory

The beginning inventory of merchandise at Dunne Co. and data onpurchases and sales for a three-month period ending June 30 are asfollows:

DateTransactionNumber
of Units
Per UnitTotal
Apr. 3Inventory36$225$8,100
8Purchase7227019,440
11Sale4875036,000
30Sale3075022,500
May 8Purchase6030018,000
10Sale3675027,000
19Sale1875013,500
28Purchase6033019,800
June 5Sale3679028,440
16Sale4879037,920
21Purchase10836038,880
28Sale5479042,660

Required:

1. Record the inventory, purchases, and cost ofmerchandise sold data in a perpetual inventory record similar tothe one illustrated in Exhibit 3, using the first-in, first-outmethod. Under FIFO, if units are in inventory at two differentcosts, enter the units with the LOWER unit cost first in the Costof Merchandise Sold Unit Cost column and in the Inventory Unit Costcolumn.

Dunne Co.
Schedule of Cost of Merchandise Sold
FIFO Method
For the three months ended May 31, 2016
PurchasesCost of Merchandise SoldInventory
DateQuantityUnit CostTotal CostQuantityUnit CostTotal CostQuantityUnit CostTotal Cost
Apr. 3$$
Apr. 8$$
Apr. 11$$
Apr. 30
May 8
May 10
May 19
May 28
June 5
June 16
June 21
June 28
June 30Balances$$

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

Record sale
Record cost

3. Determine the gross profit from sales forthe period.
$

4. Determine the ending inventory cost as ofJune 30.
$

5. Based upon the preceding data, would youexpect the inventory using the last-in, first-out method to behigher or lower?

Check My Work1 more Check My Work uses remaining.

Answer & Explanation Solved by verified expert
3.9 Ratings (582 Votes)

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 36 $225.00 $8,100.00 0 $0.00 $0.00 0 $0.00 $0.00 36 $225.00 $8,100.00
8-Apr 36 $225.00 $8,100.00 72 $270.00 $19,440.00 0 $0.00 $0.00 36 $225.00 $8,100.00
72 $270.00 $19,440.00
11-Apr 36 $225.00 $8,100.00 0 $0.00 $0.00 36 $225.00 $8,100.00 60 $270.00 $16,200.00
72 $270.00 $19,440.00 12 $270.00 $3,240.00
30-Apr 60 $270.00 $16,200.00 0 $0.00 $0.00 30 $270.00 $8,100.00 30 $270.00 $8,100.00
8-May 30 $270.00 $8,100.00 60 $300.00 $18,000.00 0 $0.00 $0.00 30 $270.00 $8,100.00
60 $300.00 $18,000.00
10-May 30 $270.00 $8,100.00 0 $0.00 $0.00 30 $270.00 $8,100.00 54 $300.00 $16,200.00
60 $300.00 $18,000.00 6 $300.00 $1,800.00
19-May 54 $300.00 $16,200.00 0 $0.00 $0.00 18 $300.00 $5,400.00 36 $300.00 $10,800.00
28-May 36 $300.00 $10,800.00 60 $330.00 $19,800.00 0 $0.00 $0.00 36 $300.00 $10,800.00
60 $330.00 $19,800.00
5-Jun 36 $300.00 $10,800.00 0 $0.00 $0.00 36 $300.00 $10,800.00 60 $330.00 $19,800.00
16-Jun 60 $330.00 $19,800.00 0 $0.00 $0.00 48 $330.00 $15,840.00 12 $330.00 $3,960.00
21-Jun 12 $330.00 $3,960.00 108 $360.00 $38,880.00 0 $0.00 $0.00 12 $330.00 $3,960.00
108 $360.00 $38,880.00
28-Jun 12 $330.00 $3,960.00 0 $0.00 $0.00 12 $330.00 $3,960.00 66 $360.00 $23,760.00
108 $360.00 $38,880.00 42 $360.00 $15,120.00
Total 270 $80,460.00 66 $23,760.00

Solution 2:

Computation of Sales
11-Apr 48 $750.00 $36,000.00
30-Apr 30 $750.00 $22,500.00
10-May 36 $750.00 $27,000.00
19-May 18 $750.00 $13,500.00
5-Jun 36 $790.00 $28,440.00
16-Jun 48 $790.00 $37,920.00
28-Jun 54 $790.00 $42,660.00
Total 270 $208,020.00
Journal Entries
Particulars Debit Credit
Accounts Receivables Dr $208,020.00
            To Sale Revenue $208,020.00
(Being sales recorded for the quarter)
Cost of merchandise sold Dr $80,460.00
            To Inventory $80,460.00
(Being inventories sold transferred to cost of merchandise sold account)

Solution 3:

Gross profit from sales = Sales - COGS = $208,020 - $80,460 = $127,560

Solution 4:

Ending inventory cost as of June 30 = $23,760

Solution 5:

As prices are increaseing over the period, therefore inventory using last in first out method to be lower.


Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Transcribed Image Text

In: AccountingFIFO Perpetual InventoryThe beginning inventory of merchandise at Dunne Co. and data onpurchases and...FIFO Perpetual InventoryThe beginning inventory of merchandise at Dunne Co. and data onpurchases and sales for a three-month period ending June 30 are asfollows:DateTransactionNumberof UnitsPer UnitTotalApr. 3Inventory36$225$8,1008Purchase7227019,44011Sale4875036,00030Sale3075022,500May 8Purchase6030018,00010Sale3675027,00019Sale1875013,50028Purchase6033019,800June 5Sale3679028,44016Sale4879037,92021Purchase10836038,88028Sale5479042,660Required:1. Record the inventory, purchases, and cost ofmerchandise sold data in a perpetual inventory record similar tothe one illustrated in Exhibit 3, using the first-in, first-outmethod. Under FIFO, if units are in inventory at two differentcosts, enter the units with the LOWER unit cost first in the Costof Merchandise Sold Unit Cost column and in the Inventory Unit Costcolumn.Dunne Co.Schedule of Cost of Merchandise SoldFIFO MethodFor the three months ended May 31, 2016PurchasesCost of Merchandise SoldInventoryDateQuantityUnit CostTotal CostQuantityUnit CostTotal CostQuantityUnit CostTotal CostApr. 3$$Apr. 8$$Apr. 11$$Apr. 30May 8May 10May 19May 28June 5June 16June 21June 28June 30Balances$$2. Determine the total sales and the total costof merchandise sold for the period. Journalize the entries in thesales and cost of merchandise sold accounts. Assume that all saleswere on account.Record saleRecord cost3. Determine the gross profit from sales forthe period.$4. Determine the ending inventory cost as ofJune 30.$5. Based upon the preceding data, would youexpect the inventory using the last-in, first-out method to behigher or lower?Check My Work1 more Check My Work uses remaining.

Other questions asked by students