Perpetual Inventory Using FIFU Beginning inventory, purchases, and sales data for prepaid cell phones for May are as follows: Inventory Purchases Sales May 1 3,800 units at $30 May 10 1,900 units at $32 May 12 2,660 units May 20 1,710 units at $34 May 14 2,280 units May 31 1,140 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.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question
100%
Perpetual Inventory Using FIFO
Beginning inventory, purchases, and sales data for prepaid cell phones for May are as follows:
Inventory
Purchases
Sales
May 1
3,800 units at $30
May 10
1,900 units at $32
May 12
2,660 units
May 20
1,710 units at $34
May 14
2,280 units
May 31
1,140 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.
Transcribed Image Text:Perpetual Inventory Using FIFO Beginning inventory, purchases, and sales data for prepaid cell phones for May are as follows: Inventory Purchases Sales May 1 3,800 units at $30 May 10 1,900 units at $32 May 12 2,660 units May 20 1,710 units at $34 May 14 2,280 units May 31 1,140 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 CelI Phones
Date Purchases
Quantity
Purchases
Purchases
Cost of
Cost of Merchandise
Cost of Merchandise
Unit Cost
Total Cost
d Quantity
Sold Unit Cost
Sold Total Cost
May
May
10
Balances
Check My Work
HO0000 000 00
H00000 000 0
li00000 000 D
O 00 00
O DO 00
0 00 00
Transcribed Image Text:Schedule of Cost of Merchandise Sold FIFO Method Prepaid CelI Phones Date Purchases Quantity Purchases Purchases Cost of Cost of Merchandise Cost of Merchandise Unit Cost Total Cost d Quantity Sold Unit Cost Sold Total Cost May May 10 Balances Check My Work HO0000 000 00 H00000 000 0 li00000 000 D O 00 00 O DO 00 0 00 00
Expert Solution
Step 1
Date Purchase Qty Cost/unit Total Purchase Cost Cost of Merchandise Cost/unit Total Cost Inventory Qty Cost/unit Total Cost
1 May             3800 30 114000
10 May 1900 32 60800      

3800

1900

30

32

11400

60800

12 May       2660 30 79800

1140

1900

30

32

34200

60800

14 May      

1140

1140

30

32

34200

36480

760

32

24320

20 May 1710 34 58140

 

 

 

760

1710

32

34

24320

58140

31 May      

760

380

32

34

24320

12920

1330

34

45220

 

trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 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
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