![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Question
thumb_up100%
Can’t figure out how to do the lifo
![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](https://content.bartleby.com/qna-images/question/80f920af-346e-4ea0-9b9d-9315737cd92e/58e64cd1-fbc7-4111-ad33-eb5f6ca5985c/ej45s9_thumbnail.jpeg)
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
![Check Mark](/static/check-mark.png)
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 nowThis is a popular solution!
Step by stepSolved in 2 steps with 2 images
![Blurred answer](/static/blurred-answer.jpg)
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.Similar questions
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
![Text book image](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
![Text book image](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
![Text book image](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
![Text book image](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education