Perpetual Inventory Using FIFO Beginning inventory, purchases, and sales data for prepaid cell phones for May are as follows: Inventory   Purchases   Sales   May 1 1,550 units at $44 May 10 720 units at $45 May 12 1,200 units            20 1,200 units at $48        14 830 units                31 1,000 units Assume that the business maintains a perpetual inventory system, costing by the first-in, first-out 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 3. 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. Schedule of Cost of Merchandise Sold FIFO Method Prepaid Cell Phones Date Quantity Purchased Purchases Unit Cost Purchases Total Cost Cost of Merchandise Sold Quantity 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         $     $

Cornerstones of Financial Accounting
4th Edition
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Jay Rich, Jeff Jones
Chapter6: Cost Of Goods Sold And Inventory
Section: Chapter Questions
Problem 67APSA: Inventory Costing Methods Andersons Department Store has the following data for inventory,...
icon
Related questions
Topic Video
Question

Perpetual Inventory Using FIFO

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

Inventory   Purchases   Sales  
May 1 1,550 units at $44 May 10 720 units at $45 May 12 1,200 units
           20 1,200 units at $48        14 830 units
               31 1,000 units

Assume that the business maintains a perpetual inventory system, costing by the first-in, first-out 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 3. 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.

Schedule of Cost of Merchandise Sold
FIFO Method
Prepaid Cell Phones




Date



Quantity
Purchased


Purchases
Unit
Cost


Purchases
Total
Cost
Cost of
Merchandise
Sold
Quantity
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 2 steps with 1 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
  • SEE MORE QUESTIONS
Recommended textbooks for you
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:
9781337272124
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781305088436
Author:
Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Financial Accounting: The Impact on Decision Make…
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College