Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for prepaid cell phones for May are as follows: Inventory   Purchases   Sales   May 1 3,000 units at $29 May 10 1,500 units at $31 May 12 2,100 units     May 20 1,350 units at $33 May 14 1,800 units         May 31 900 units a.  Assuming that the perpetual inventory system is used, costing by the LIFO method, determine the cost of merchandise sold for each sale and the inventory balance after each sale, presenting the data in the form illustrated in Exhibit 4. Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Merchandise Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column. Schedule of Cost of Merchandise Sold LIFO Method Prepaid Cell Phones Date Quantity Purchased Purchases Unit Cost Purchases Total Cost Quantity Sold Cost of Merchandise Sold Unit Cost Cost of Merchandise Sold Total Cost Inventory Quantity Inventory Unit Cost Inventory Total Cost May 1               $ $ May 10   $ $                                 May 12         $ $                           May 14                   May 20                                       May 31                                       May 31 Balances         $     $

Financial And Managerial Accounting
15th Edition
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:WARREN, Carl S.
Chapter6: Inventories
Section: Chapter Questions
Problem 3E: Perpetual inventory using FIFO Beginning inventory, purchases, and sales data for DVD players are as...
icon
Related questions
icon
Concept explainers
Question

Perpetual Inventory Using LIFO

Beginning inventory, purchases, and sales data for prepaid cell phones for May are as follows:

Inventory   Purchases   Sales  
May 1 3,000 units at $29 May 10 1,500 units at $31 May 12 2,100 units
    May 20 1,350 units at $33 May 14 1,800 units
        May 31 900 units

a.  Assuming that the perpetual inventory system is used, costing by the LIFO method, determine the cost of merchandise sold for each sale and the inventory balance after each sale, presenting the data in the form illustrated in Exhibit 4. Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Merchandise Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column.

Schedule of Cost of Merchandise Sold
LIFO Method
Prepaid Cell Phones
Date Quantity Purchased Purchases Unit Cost Purchases Total Cost Quantity Sold Cost of Merchandise Sold Unit Cost Cost of Merchandise Sold Total Cost Inventory Quantity Inventory Unit Cost Inventory Total Cost
May 1               $ $
May 10   $ $            
                   
May 12         $ $      
                   
May 14                  
May 20                  
                   
May 31                  
                   
May 31 Balances         $     $
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 1 steps

Blurred answer
Knowledge Booster
Completing the Accounting Cycle
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781337272124
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781305088436
Author:
Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning