6 7 8 9 10 11 12 13 Date Jan 1 Jan 3 Jan 6 Jan 15 Jan 22 DATA Description Inventory on hand Purchase Sale Purchase Sale Units 5,000 9,000 8,500 13,000 12,000 Per Unit $ LA SA $ $ LA LA LA $ $ 11 13 23 15 23
6 7 8 9 10 11 12 13 Date Jan 1 Jan 3 Jan 6 Jan 15 Jan 22 DATA Description Inventory on hand Purchase Sale Purchase Sale Units 5,000 9,000 8,500 13,000 12,000 Per Unit $ LA SA $ $ LA LA LA $ $ 11 13 23 15 23
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Can you sse the image attached (the data table ) to repare a step by step perpetual inventory record using, FIFO, LIFO, and weighted-average inventory 4 costing methods, and /determine cost of goods sold and ending merchandise inventory for each method. Also show me the formulas and step by step how to do it for each
+make sure to display 2 decimal places for weighted
![6
7
CO
8
9
10
11
12
13
14
Date
Jan 1
Jan 3
Jan 6
Jan 15
Jan 22
DATA
Description
Inventory on hand
Purchase
Sale
Purchase
Sale
Units
5,000
9,000
8,500
13,000
12,000
Per Unit
$
$
$
LA SA
$
$
13
23
15
23
HORTO
T](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F385dd7d1-1a38-4b33-a039-059d65b0c7b0%2F6abb30b8-98bc-4b9d-b382-62d9735e9cc1%2F8015599_processed.jpeg&w=3840&q=75)
Transcribed Image Text:6
7
CO
8
9
10
11
12
13
14
Date
Jan 1
Jan 3
Jan 6
Jan 15
Jan 22
DATA
Description
Inventory on hand
Purchase
Sale
Purchase
Sale
Units
5,000
9,000
8,500
13,000
12,000
Per Unit
$
$
$
LA SA
$
$
13
23
15
23
HORTO
T
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
Step 1: Notes
- Number of units purchased = 9000 + 13000 = 22000
- Number of units sold = 8500 + 12000 = 20500
- Ending inventory (Units) = Beginning inventory + Purchases - sales
= 5000 + 22000 - 20500
= 6500
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 4 images
![Blurred answer](/static/compass_v2/solution-images/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.Recommended textbooks for you
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](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,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](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,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Horngren's Cost Accounting: A Managerial Emphasis…](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
![Intermediate Accounting](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
![Financial and Managerial Accounting](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