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 $ $
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,...
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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
Knowledge Booster
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.Recommended textbooks for you
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Financial Accounting
Accounting
ISBN:
9781337272124
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Financial Accounting
Accounting
ISBN:
9781337272124
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Financial Accounting
Accounting
ISBN:
9781305088436
Author:
Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:
Cengage Learning
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
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College