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

Free

60.1K

Verified Solution

Question

Accounting

LIFO 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. 3Inventory84$375$31,500
8Purchase16845075,600
11Sale1131,250141,250
30Sale711,25088,750
May 8Purchase14050070,000
10Sale841,250105,000
19Sale421,25052,500
28Purchase14055077,000
June 5Sale841,315110,460
16Sale1121,315147,280
21Purchase252600151,200
28Sale1261,315165,690

Required:

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

Dunne Co.
Schedule of Cost of Merchandise Sold
LIFO Method
For the three months ended June 30
PurchasesCost of MerchandiseSoldInventory
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, the total cost ofmerchandise sold, and the gross profit from sales for theperiod.

Total sales$
Total cost of merchandise sold$
Gross profit from sales$

3. Determine the ending inventory cost on June30.
$

Answer & Explanation Solved by verified expert
3.6 Ratings (412 Votes)

Solution 1:

Computation of ending inventory COGS under LIFO
Date Beginning Inventory Purchase Cost of Goods Sold Ending Inventory
Qty Rate Amount Qty Rate Amount Qty Rate Amount Qty Rate Amount
3-Apr 84 $375.00 $31,500.00 0 $0.00 $0.00 0 $0.00 $0.00 84 $375.00 $31,500.00
8-Apr 84 $375.00 $31,500.00 168 $450.00 $75,600.00 0 $0.00 $0.00 84 $375.00 $31,500.00
168 $450.00 $75,600.00
11-Apr 84 $375.00 $31,500.00 0 $0.00 $0.00 113 $450.00 $50,850.00 84 $375.00 $31,500.00
168 $450.00 $75,600.00 55 $450.00 $24,750.00
30-Apr 84 $375.00 $31,500.00 0 $0.00 $0.00 55 $450.00 $24,750.00 68 $375.00 $25,500.00
55 $450.00 $24,750.00 16 $375.00 $6,000.00
8-May 68 $375.00 $25,500.00 140 $500.00 $70,000.00 0 $0.00 $0.00 68 $375.00 $25,500.00
140 $500.00 $70,000.00
10-May 68 $375.00 $25,500.00 0 $0.00 $0.00 84 $500.00 $42,000.00 68 $375.00 $25,500.00
140 $500.00 $70,000.00 56 $500.00 $28,000.00
19-May 68 $375.00 $25,500.00 0 $0.00 $0.00 42 $500.00 $21,000.00 68 $375.00 $25,500.00
56 $500.00 $28,000.00 14 $500.00 $7,000.00
28-May 68 $375.00 $25,500.00 140 $550.00 $77,000.00 0 $0.00 $0.00 68 $375.00 $25,500.00
14 $500.00 $7,000.00 14 $500.00 $7,000.00
140 $550.00 $77,000.00
5-Jun 68 $375.00 $25,500.00 0 $0.00 $0.00 84 $550.00 $46,200.00 68 $375.00 $25,500.00
14 $500.00 $7,000.00 14 $500.00 $7,000.00
140 $550.00 $77,000.00 56 $550.00 $30,800.00
16-Jun 68 $375.00 $25,500.00 0 $0.00 $0.00 56 $550.00 $30,800.00 26 $375.00 $9,750.00
14 $500.00 $7,000.00 14 $500.00 $7,000.00
56 $550.00 $30,800.00 42 $375.00 $15,750.00
21-Jun 26 $375.00 $9,750.00 252 $600.00 $151,200.00 0 $0.00 $0.00 26 $375.00 $9,750.00
252 $600.00 $151,200.00
28-Jun 26 $375.00 $9,750.00 0 $0.00 $0.00 126 $600.00 $75,600.00 26 $375.00 $9,750.00
252 $600.00 $151,200.00 126 $600.00 $75,600.00
Total 632 $319,950.00 152 $85,350.00

Solution 2:

Computation of Sales
11-Apr 113 $1,250.00 $141,250.00
30-Apr 71 $1,250.00 $88,750.00
10-May 84 $1,250.00 $105,000.00
19-May 42 $1,250.00 $52,500.00
5-Jun 84 $1,315.00 $110,460.00
16-Jun 112 $1,315.00 $147,280.00
28-Jun 126 $1,315.00 $165,690.00
Total 632 $810,930.00

Total cost of merchandise sold = $319,950

Gross profit from sales = $810,930 - $319,950 = $490,980

Solution 3:

Ending inventory cost on june 30 = $85,350


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: AccountingLIFO Perpetual InventoryThe beginning inventory of merchandise at Dunne Co. and data onpurchases and...LIFO 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. 3Inventory84$375$31,5008Purchase16845075,60011Sale1131,250141,25030Sale711,25088,750May 8Purchase14050070,00010Sale841,250105,00019Sale421,25052,50028Purchase14055077,000June 5Sale841,315110,46016Sale1121,315147,28021Purchase252600151,20028Sale1261,315165,690Required:1. Record the inventory, purchases, and cost ofmerchandise sold data in a perpetual inventory record similar tothe one illustrated in Exhibit 4, using the last-in, first-outmethod. Under LIFO, if units are in inventory at two differentcosts, enter the units with the HIGHER unit cost first in the Costof Merchandise Sold Unit Cost column and LOWER unit cost first inthe Inventory Unit Cost column.Dunne Co.Schedule of Cost of Merchandise SoldLIFO MethodFor the three months ended June 30PurchasesCost of MerchandiseSoldInventoryDateQuantityUnit 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, the total cost ofmerchandise sold, and the gross profit from sales for theperiod.Total sales$Total cost of merchandise sold$Gross profit from sales$3. Determine the ending inventory cost on June30.$

Other questions asked by students