Use the following information for the Exercises 3-7 below. (Algo) [The following information applies to the questions displayed below.] Laker Company reported the following January purchases and sales data for its only product. The Company uses a periodic inventory system. For specific identification, ending inventory consists of 232 units, where 180 are from the January 30 purchase, 5 are from the January 20 purchase, and 47 are from beginning inventory. Date Activities January 1 Beginning inventory January 10 Sales Purchase Sales Purchase Totals January 20 January 25 January 30 Units 156 units e Acquired at Cost $ 6.00 = 76 units e 180 units e 412 units $ 5.00 $ 4.50 = $ 936 380 810 $ 2,126 Units sold at Retail 84 units @ 96 units e 180 units $ 15.00 $ 15.00

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
Can do the FIFO AND THE LIFO and also the weighted average for January 1 January 10 January 20 January 25 January 30 thank you
### Perpetual FIFO Inventory System

#### Goods Purchased, Cost of Goods Sold, and Inventory Balance

This table utilizes the Perpetual First-In, First-Out (FIFO) method, which is an inventory valuation method where goods purchased first are sold first.

| Date | Goods Purchased | Cost of Goods Sold | Inventory Balance |
|------|-----------------|--------------------|-------------------|
|      | # of units | Cost per unit | # of units sold | Cost per unit | Cost of Goods Sold | # of units | Cost per unit | Inventory Balance |
|------|-----------|-------------|---------------|----------------|-------------------|-----------|--------------|----------------|
| January 1 | | | | | | 156 | $6.00 | $936.00 |
|------|-----------|-------------|---------------|----------------|-------------------|-----------|--------------|----------------|
| January 10 | | | 84 | $6.00 | $504.00 | 96 | $6.00 | $576.00 |
|------|-----------|-------------|---------------|----------------|-------------------|-----------|--------------|----------------|
| January 20 | 76 | $5.00 | | | | 96 | $6.00 | $576.00 |
| | | | | | | 76 | $5.00 | $380.00 |
|------|-----------|-------------|---------------|----------------|-------------------|-----------|--------------|----------------|
| January 25 | | | | $6.00 | $0.00 | 0 | $6.00 | |
| | | | | $5.00 | $0.00 | 96 | $5.00 | $480.00 |
|------|-----------|-------------|---------------|----------------|-------------------|-----------|--------------|----------------|
| January 30 | 180 | $4.50 | | | | 0 | $6.00 | |
| | | | | | | 96 | $5.00 | $480.00 |
| | | | | | | 96 | $4.50 | $432.00 |
|------|-----------|-------------|---------------|----------------|-------------------|-----------|--------------|----------------|
| Totals | | | | | $504.00 | | | $912.00 |
|------|-----------|-------------|---------------|----------------|-------------------|-----------|--------------|----------------|

#### Explanation
Transcribed Image Text:### Perpetual FIFO Inventory System #### Goods Purchased, Cost of Goods Sold, and Inventory Balance This table utilizes the Perpetual First-In, First-Out (FIFO) method, which is an inventory valuation method where goods purchased first are sold first. | Date | Goods Purchased | Cost of Goods Sold | Inventory Balance | |------|-----------------|--------------------|-------------------| | | # of units | Cost per unit | # of units sold | Cost per unit | Cost of Goods Sold | # of units | Cost per unit | Inventory Balance | |------|-----------|-------------|---------------|----------------|-------------------|-----------|--------------|----------------| | January 1 | | | | | | 156 | $6.00 | $936.00 | |------|-----------|-------------|---------------|----------------|-------------------|-----------|--------------|----------------| | January 10 | | | 84 | $6.00 | $504.00 | 96 | $6.00 | $576.00 | |------|-----------|-------------|---------------|----------------|-------------------|-----------|--------------|----------------| | January 20 | 76 | $5.00 | | | | 96 | $6.00 | $576.00 | | | | | | | | 76 | $5.00 | $380.00 | |------|-----------|-------------|---------------|----------------|-------------------|-----------|--------------|----------------| | January 25 | | | | $6.00 | $0.00 | 0 | $6.00 | | | | | | | $5.00 | $0.00 | 96 | $5.00 | $480.00 | |------|-----------|-------------|---------------|----------------|-------------------|-----------|--------------|----------------| | January 30 | 180 | $4.50 | | | | 0 | $6.00 | | | | | | | | | 96 | $5.00 | $480.00 | | | | | | | | 96 | $4.50 | $432.00 | |------|-----------|-------------|---------------|----------------|-------------------|-----------|--------------|----------------| | Totals | | | | | $504.00 | | | $912.00 | |------|-----------|-------------|---------------|----------------|-------------------|-----------|--------------|----------------| #### Explanation
### Using the Information for the Exercises 3-7

#### [The following information applies to the questions displayed below]

Laker Company reported the following January purchases and sales data for its only product. The Company uses a periodic inventory system. For specific identification, ending inventory consists of 232 units, where 180 are from the January 30 purchase, 5 are from the January 20 purchase, and 47 are from beginning inventory.

| Date            | Activities           | Units Acquired at Cost         | Units sold at Retail              |
|-----------------|----------------------|---------------------------------|----------------------------------|
| January 1       | Beginning inventory  | 156 units @ $6.00 = $936       |                                  |
| January 10      | Sales                |                                 | 84 units @ $15.00                |
| January 20      | Purchase             | 76 units @ $5.00 = $380        |                                  |
| January 25      | Sales                |                                 | 96 units @ $15.00                |
| January 30      | Purchase             | 180 units @ $4.50 = $810       |                                  |
| **Totals**      |                      | **412 units** = **$2,126**     | **180 units**                    |

### Explanation of Table

#### Table Breakdown

1. **Beginning Inventory:** 
    - On January 1st, Laker Company started with 156 units in inventory, each costing $6.00, totaling $936.

2. **Sales (Jan 10):**
    - On January 10th, 84 units were sold at $15.00 each.

3. **Purchase (Jan 20):**
    - On January 20th, the company purchased an additional 76 units at $5.00 each, totaling $380.

4. **Sales (Jan 25):**
    - On January 25th, 96 units were sold at $15.00 each.

5. **Purchase (Jan 30):**
    - On January 30th, the company purchased 180 units at $4.50 each, totaling $810.

6. **Total:**
    - By the end of January, the total units acquired were 412 units costing a total of $2,126.
    - A total of 180 units were sold throughout January.

### Notes for Exercises:

- Ending inventory is composed of units from various dates:
Transcribed Image Text:### Using the Information for the Exercises 3-7 #### [The following information applies to the questions displayed below] Laker Company reported the following January purchases and sales data for its only product. The Company uses a periodic inventory system. For specific identification, ending inventory consists of 232 units, where 180 are from the January 30 purchase, 5 are from the January 20 purchase, and 47 are from beginning inventory. | Date | Activities | Units Acquired at Cost | Units sold at Retail | |-----------------|----------------------|---------------------------------|----------------------------------| | January 1 | Beginning inventory | 156 units @ $6.00 = $936 | | | January 10 | Sales | | 84 units @ $15.00 | | January 20 | Purchase | 76 units @ $5.00 = $380 | | | January 25 | Sales | | 96 units @ $15.00 | | January 30 | Purchase | 180 units @ $4.50 = $810 | | | **Totals** | | **412 units** = **$2,126** | **180 units** | ### Explanation of Table #### Table Breakdown 1. **Beginning Inventory:** - On January 1st, Laker Company started with 156 units in inventory, each costing $6.00, totaling $936. 2. **Sales (Jan 10):** - On January 10th, 84 units were sold at $15.00 each. 3. **Purchase (Jan 20):** - On January 20th, the company purchased an additional 76 units at $5.00 each, totaling $380. 4. **Sales (Jan 25):** - On January 25th, 96 units were sold at $15.00 each. 5. **Purchase (Jan 30):** - On January 30th, the company purchased 180 units at $4.50 each, totaling $810. 6. **Total:** - By the end of January, the total units acquired were 412 units costing a total of $2,126. - A total of 180 units were sold throughout January. ### Notes for Exercises: - Ending inventory is composed of units from various dates:
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Financial Reporting in Hyperinflationary Economies
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
  • SEE MORE 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