Use the following information to calculate the value of inventory on hand on Mar 31 and cost of goods sold during March using FIFO perpetual inventory system. 01-Mar 11 16 20 29 Beginning Inventory Purchase Sale Purchase Purchase Sale Sale 50 units @ R15 per unit 130 units @20 per unit 90 units @ 22 per unit 39 units @ R16 per unit 79 units @ R17per unit 120 units @ R21 per unit 61 units @ R22 per unit
Use the following information to calculate the value of inventory on hand on Mar 31 and cost of goods sold during March using FIFO perpetual inventory system. 01-Mar 11 16 20 29 Beginning Inventory Purchase Sale Purchase Purchase Sale Sale 50 units @ R15 per unit 130 units @20 per unit 90 units @ 22 per unit 39 units @ R16 per unit 79 units @ R17per unit 120 units @ R21 per unit 61 units @ R22 per unit
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
![**FIFO Perpetual Inventory System Analysis for March**
**Objective:** Calculate the value of inventory on hand as of March 31 and the cost of goods sold during March using the FIFO (First-In, First-Out) perpetual inventory system.
**Transaction Details:**
| Date | Description | Quantity and Unit Cost |
|--------|---------------------|-------------------------------------------|
| 01-Mar | Beginning Inventory | 50 units @ R15 per unit |
| 05-Mar | Purchase | 130 units @ R20 per unit |
| 09-Mar | Sale | 90 units @ R22 per unit |
| 11-Mar | Purchase | 39 units @ R16 per unit |
| 16-Mar | Purchase | 79 units @ R17 per unit |
| 20-Mar | Sale | 120 units @ R21 per unit |
| 29-Mar | Sale | 61 units @ R22 per unit |
**Explanation:**
1. **Beginning Inventory (01-Mar):**
- 50 units @ R15 per unit
2. **Purchase (05-Mar):**
- 130 units @ R20 per unit
3. **Sales (09-Mar):**
- Sold 90 units at R22 per unit
- According to FIFO, 50 units @ R15 (from beginning inventory) and 40 units @ R20 (from purchase on 05-Mar) are sold.
4. **Purchases (11-Mar):**
- 39 units @ R16 per unit
5. **Purchases (16-Mar):**
- 79 units @ R17 per unit
6. **Sales (20-Mar):**
- Sold 120 units at R21 per unit
- According to FIFO, 90 units @ R20 (remaining from purchase on 05-Mar), and 30 units @ R16 (from purchase on 11-Mar) are sold.
7. **Sales (29-Mar):**
- Sold 61 units at R22 per unit
- According to FIFO, 9 units @ R16 (remaining from purchase on 11-Mar), and 52 units @ R17 (from purchase on 16-Mar) are sold.
**Calculation of Ending Inventory (as of 31-Mar):**
- Units from purchases and remaining:
- 27 units @ R17 (from purchase on 16-Mar)](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fd84f55b1-6045-46a9-9610-9a34a878a241%2F955a2dbc-a5ef-465f-a559-3b45209e3aa7%2Fw6g2jsh.png&w=3840&q=75)
Transcribed Image Text:**FIFO Perpetual Inventory System Analysis for March**
**Objective:** Calculate the value of inventory on hand as of March 31 and the cost of goods sold during March using the FIFO (First-In, First-Out) perpetual inventory system.
**Transaction Details:**
| Date | Description | Quantity and Unit Cost |
|--------|---------------------|-------------------------------------------|
| 01-Mar | Beginning Inventory | 50 units @ R15 per unit |
| 05-Mar | Purchase | 130 units @ R20 per unit |
| 09-Mar | Sale | 90 units @ R22 per unit |
| 11-Mar | Purchase | 39 units @ R16 per unit |
| 16-Mar | Purchase | 79 units @ R17 per unit |
| 20-Mar | Sale | 120 units @ R21 per unit |
| 29-Mar | Sale | 61 units @ R22 per unit |
**Explanation:**
1. **Beginning Inventory (01-Mar):**
- 50 units @ R15 per unit
2. **Purchase (05-Mar):**
- 130 units @ R20 per unit
3. **Sales (09-Mar):**
- Sold 90 units at R22 per unit
- According to FIFO, 50 units @ R15 (from beginning inventory) and 40 units @ R20 (from purchase on 05-Mar) are sold.
4. **Purchases (11-Mar):**
- 39 units @ R16 per unit
5. **Purchases (16-Mar):**
- 79 units @ R17 per unit
6. **Sales (20-Mar):**
- Sold 120 units at R21 per unit
- According to FIFO, 90 units @ R20 (remaining from purchase on 05-Mar), and 30 units @ R16 (from purchase on 11-Mar) are sold.
7. **Sales (29-Mar):**
- Sold 61 units at R22 per unit
- According to FIFO, 9 units @ R16 (remaining from purchase on 11-Mar), and 52 units @ R17 (from purchase on 16-Mar) are sold.
**Calculation of Ending Inventory (as of 31-Mar):**
- Units from purchases and remaining:
- 27 units @ R17 (from purchase on 16-Mar)
Expert Solution
![](/static/compass_v2/shared-icons/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 now
This is a popular solution!
Step by step
Solved in 3 steps
![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