DATA Units Per Unit Description Inventory on hand Purchase Date Jan 1 1,000 2$ 4 Jan 3 3,000 2$ Jan 6 Sale 2,750 10 Jan 15 Purchase 5,000 6 Jan 22 Sale 4,500 10 8,000 2$ 45,000
DATA Units Per Unit Description Inventory on hand Purchase Date Jan 1 1,000 2$ 4 Jan 3 3,000 2$ Jan 6 Sale 2,750 10 Jan 15 Purchase 5,000 6 Jan 22 Sale 4,500 10 8,000 2$ 45,000
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
100%
Can’t figure out how to do the lifo
Transcribed Image Text:K
F
G
H.
D
A
Requirement
Prepare a perpetual inventory record using, FIFO, LIFO, and weighted-average inventory costing methods,
and determine cost of goods sold and ending merchandise inventory. Use cell references from Data Table
for quantities and unit cost. Use Excel formulas for total costs and total quantities. Format weighted
average unit cost and total cost to display two decimal places.
1 Inventory Flow Assumptions
2
DATA
4
Date
Description
Units
Per Unit
Jan 1
Inventory on hand
1,000
4
6.
Jan 3
Purchase
3,000
5.
7
Jan 6
Sale
2,750
10
9
Jan 15
Purchase
5,000
24
6
10
Jan 22
Sale
4,500
10
$4
38,500.00
1,750
10,500.00
35
8,000
45.000
7,250
36
37
38
LIFO
Purchases
COGS
Inventory on Hand
39
Date
Quantity
Unit cost
Total Cost
Quantity
Unit cost
Total Cost
Quantity
Unit cost
Total Cost
40
41
Jan 1
42
43
44
Jan 3
45
46
47
48
Jan 6
49
50
51
52
Jan 15
53
54
55
56
57
Jan 22
58
59
60
61
62
should be 8,250
63
64
65
Weighted-Average
66
Purchases
COGS
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 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