LIFO Perpetual Inventory The beginning inventory at Dunne Co. and data on purchases and sales for a three-month period are as follows: Date   Transaction Number of Units Per Unit Total Apr. 3   Inventory 90   $ 150   $ 13,500   8   Purchase 180   180   32,400   11   Sale 121   500   60,500   30   Sale 76   500   38,000   May 8   Purchase 150   200   30,000   10   Sale 90   500   45,000   19   Sale 45   500   22,500   28   Purchase 150   220   33,000   June 5   Sale 90   525   47,250   16   Sale 120   525   63,000   21   Purchase 270   240   64,800   28   Sale 135   525   70,875     Required: 1. Record the inventory, purchases, and cost of goods sold data in a perpetual inventory record similar to the one illustrated in Exhibit 4 , using the last-in, first-out method. Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Goods Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column. Dunne Co. Schedule of Cost of Goods Sold LIFO Method For the Three Months Ended June 30   Purchases Cost of Goods Sold Inventory Date Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Unit Cost Total 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 30 Balances         $      $  2. Determine the total sales, the total cost of goods sold, and the gross profit from sales for the period. Total sales $  Total cost of goods sold $  Gross profit from sales $  3. Determine the ending inventory cost on June 30. $

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Topic Video
Question

LIFO Perpetual Inventory

The beginning inventory at Dunne Co. and data on purchases and sales for a three-month period are as follows:

Date   Transaction Number
of Units
Per Unit Total
Apr. 3   Inventory 90   $ 150   $ 13,500  
8   Purchase 180   180   32,400  
11   Sale 121   500   60,500  
30   Sale 76   500   38,000  
May 8   Purchase 150   200   30,000  
10   Sale 90   500   45,000  
19   Sale 45   500   22,500  
28   Purchase 150   220   33,000  
June 5   Sale 90   525   47,250  
16   Sale 120   525   63,000  
21   Purchase 270   240   64,800  
28   Sale 135   525   70,875  

 

Required:

1. Record the inventory, purchases, and cost of goods sold data in a perpetual inventory record similar to the one illustrated in Exhibit 4 , using the last-in, first-out method. Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Goods Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column.

Dunne Co.
Schedule of Cost of Goods Sold
LIFO Method
For the Three Months Ended June 30
  Purchases Cost of Goods Sold Inventory
Date Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Unit Cost Total 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 30 Balances            

2. Determine the total sales, the total cost of goods sold, and the gross profit from sales for the period.

Total sales
Total cost of goods sold
Gross profit from sales

3. Determine the ending inventory cost on June 30.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 7 images

Blurred answer
Knowledge Booster
Accounting for Merchandise Inventory
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education