Beginning inventory, purchases, and sales data for prepaid cell phones for May are as follows: Inventory Sales Purchases May 10 May 1 20 Quantity Date Purchased May 1 May 10 May 12 May 14 1,700 units at $22 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. May 20 May 31 0 U May 31 Balances Purchases Purchases Unit Total Cost Cost 0 0 850 units at $24 765 units at $26 Schedule of Cost of Merchandise Sold FIFO Method Prepaid Cell Phones 000 00 May 12 14 Q0000 1.190 units 1.020 units 31 510 units B Cost of Cost of Merchandise Merchandise Merchandise Sold Sold Quantity Unit Cost 11 000 000 Total Cost Im 0 ¹0 000 0 Inventory Quantity Inventory Inventory Unit Cost ¹Q Total Cost Q
Beginning inventory, purchases, and sales data for prepaid cell phones for May are as follows: Inventory Sales Purchases May 10 May 1 20 Quantity Date Purchased May 1 May 10 May 12 May 14 1,700 units at $22 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. May 20 May 31 0 U May 31 Balances Purchases Purchases Unit Total Cost Cost 0 0 850 units at $24 765 units at $26 Schedule of Cost of Merchandise Sold FIFO Method Prepaid Cell Phones 000 00 May 12 14 Q0000 1.190 units 1.020 units 31 510 units B Cost of Cost of Merchandise Merchandise Merchandise Sold Sold Quantity Unit Cost 11 000 000 Total Cost Im 0 ¹0 000 0 Inventory Quantity Inventory Inventory Unit Cost ¹Q Total Cost Q
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Topic Video
Question

Transcribed Image Text:Perpetual Inventory Using FIFO
Beginning
Inventory
May 1
Date
May 1
May 10
May 12
May 14
1,020 units
31
510 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.
May 20
inventory, purchases, and sales data for prepaid cell phones for May are as follows:
Sales
Purchases
May 10
May 31
1,700 units at $22
Quantity
Purchased
0
May 31 Balances
20
850 units at $24
765 units at $26
0 00 00
May 12
00 00 0
14
Schedule of Cost of Merchandise Sold
FIFO Method
Prepaid Cell Phones
Cost of
Cost of
Cost of
Purchases Purchases Merchandise Merchandise Merchandise
Sold
Sold
Sold
Unit
Total
Quantity Unit Cost Total Cost
Cost
Cost
1,190 units
8
8
Inventory Inventory
Total
Cost
Inventory
Quantity
1000000000
00000 000 0
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 2 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


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON

Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education

Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education