A company reports the following beginning inventory and two purchases for the month of January. On January 26, the company sells 290 units. Ending inventory at January 31 totals 130 units. Units Unit Cost Beginning inventory on January 1 Purchase on January 9 Purchase on January 25 260 $ 2.40 60 2.60 100 2.74 Required: Assume the perpetual inventory system is used. Determine the costs assigned to ending inventory when costs are assigned based on LIFO

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question

Please help determine the images attached

 

### Inventory Cost Analysis: LIFO Method

A company reports the following beginning inventory and two purchases for the month of January. On January 26, the company sells 290 units. Ending inventory at January 31 totals 130 units.

| Inventory Type                     | Units | Unit Cost |
|------------------------------------|-------|-----------|
| Beginning inventory on January 1   | 260   | $2.40     |
| Purchase on January 9              | 60    | $2.60     |
| Purchase on January 25             | 100   | $2.74     |

**Required:**
Assume the perpetual inventory system is used. Determine the costs assigned to ending inventory when costs are assigned based on LIFO (Last-In, First-Out).

### Detailed Explanation of Inventory Cost Allocations

By using the LIFO method, the most recently acquired units are considered to be sold first. Here's how to break down the computation:

1. **Calculate Units Sold:**
    - Total units sold = 290 units

2. **Cost Layers (based on LIFO):**
    - Last purchase: 100 units at $2.74 each
    - Next recent purchase: 60 units at $2.60 each

3. **Units and Cost Breakdown:**
    - Units sold from last purchase: 100 units at $2.74 = $274.00
    - Including next recent purchase: 60 units at $2.60 = $156.00
    - Remaining needed from beginning inventory: 130 units at $2.40 = $312.00

    Total cost of units sold:
    \[
    100 \times 2.74 + 60 \times 2.60 + 130 \times 2.40 = \$742.00
    \]

4. **Remaining Inventory (ending inventory):**
    - From beginning inventory: 130 units remain
    
    Total cost of ending inventory:
    \[
    130 \times 2.40 = \$312.00
    \]

In summary, the total costs assigned to the ending inventory using LIFO for this period are $312.00.
Transcribed Image Text:### Inventory Cost Analysis: LIFO Method A company reports the following beginning inventory and two purchases for the month of January. On January 26, the company sells 290 units. Ending inventory at January 31 totals 130 units. | Inventory Type | Units | Unit Cost | |------------------------------------|-------|-----------| | Beginning inventory on January 1 | 260 | $2.40 | | Purchase on January 9 | 60 | $2.60 | | Purchase on January 25 | 100 | $2.74 | **Required:** Assume the perpetual inventory system is used. Determine the costs assigned to ending inventory when costs are assigned based on LIFO (Last-In, First-Out). ### Detailed Explanation of Inventory Cost Allocations By using the LIFO method, the most recently acquired units are considered to be sold first. Here's how to break down the computation: 1. **Calculate Units Sold:** - Total units sold = 290 units 2. **Cost Layers (based on LIFO):** - Last purchase: 100 units at $2.74 each - Next recent purchase: 60 units at $2.60 each 3. **Units and Cost Breakdown:** - Units sold from last purchase: 100 units at $2.74 = $274.00 - Including next recent purchase: 60 units at $2.60 = $156.00 - Remaining needed from beginning inventory: 130 units at $2.40 = $312.00 Total cost of units sold: \[ 100 \times 2.74 + 60 \times 2.60 + 130 \times 2.40 = \$742.00 \] 4. **Remaining Inventory (ending inventory):** - From beginning inventory: 130 units remain Total cost of ending inventory: \[ 130 \times 2.40 = \$312.00 \] In summary, the total costs assigned to the ending inventory using LIFO for this period are $312.00.
### Perpetual LIFO Inventory Method

This table is designed to track inventory using the Perpetual LIFO (Last-In, First-Out) method. Here's a breakdown of the table along with details on how to use each section:

#### Table Sections Explained:

1. **Date**: This column records the date of transactions, such as purchases and sales of goods.

2. **Goods Purchased**:
    - **# of units**: Number of units purchased on the given date.
    - **Cost per unit**: Cost per unit of the goods purchased.

3. **Cost of Goods Sold**:
    - **# of units sold**: Number of units sold on the given date.
    - **Cost per unit**: Cost per unit of the goods sold.
    - **Cost of Goods Sold**: Total cost of the goods sold, calculated as the number of units sold multiplied by the cost per unit.

4. **Inventory Balance**:
    - **# of units**: Number of units remaining in inventory after purchases and sales on the given date.
    - **Cost per unit**: Cost per unit of the remaining inventory.
    - **Inventory Balance**: Total value of the remaining inventory, calculated as the number of units remaining multiplied by the cost per unit.

#### Transactions Recorded:

1. **January 1**:
    - No transactions recorded on this date.

2. **January 9**:
    - Goods Purchased: Details of units and cost per unit need to be filled in.

3. **January 25**:
    - Transactions details for this date are not recorded.

4. **January 26**:
    - Transactions details for this date are not recorded.

#### Totals:
- The bottom row is designated for the totals of Cost of Goods Sold and Inventory Balance. These fields need to be calculated and filled in based on the data from the transactions above.

### Instructions for Use:

1. **Record Purchases**: Fill in the columns under “Goods Purchased” for any purchases made on the respective dates.
2. **Record Sales**: Fill in the columns under “Cost of Goods Sold” for any sales made on the respective dates.
3. **Update Inventory Balance**: After recording each purchase and sale, update the “Inventory Balance” columns to reflect the new quantities and costs.

Ensure that the perpetual LIFO method is applied, meaning the most recently purchased inventory items are sold first when recording cost of goods
Transcribed Image Text:### Perpetual LIFO Inventory Method This table is designed to track inventory using the Perpetual LIFO (Last-In, First-Out) method. Here's a breakdown of the table along with details on how to use each section: #### Table Sections Explained: 1. **Date**: This column records the date of transactions, such as purchases and sales of goods. 2. **Goods Purchased**: - **# of units**: Number of units purchased on the given date. - **Cost per unit**: Cost per unit of the goods purchased. 3. **Cost of Goods Sold**: - **# of units sold**: Number of units sold on the given date. - **Cost per unit**: Cost per unit of the goods sold. - **Cost of Goods Sold**: Total cost of the goods sold, calculated as the number of units sold multiplied by the cost per unit. 4. **Inventory Balance**: - **# of units**: Number of units remaining in inventory after purchases and sales on the given date. - **Cost per unit**: Cost per unit of the remaining inventory. - **Inventory Balance**: Total value of the remaining inventory, calculated as the number of units remaining multiplied by the cost per unit. #### Transactions Recorded: 1. **January 1**: - No transactions recorded on this date. 2. **January 9**: - Goods Purchased: Details of units and cost per unit need to be filled in. 3. **January 25**: - Transactions details for this date are not recorded. 4. **January 26**: - Transactions details for this date are not recorded. #### Totals: - The bottom row is designated for the totals of Cost of Goods Sold and Inventory Balance. These fields need to be calculated and filled in based on the data from the transactions above. ### Instructions for Use: 1. **Record Purchases**: Fill in the columns under “Goods Purchased” for any purchases made on the respective dates. 2. **Record Sales**: Fill in the columns under “Cost of Goods Sold” for any sales made on the respective dates. 3. **Update Inventory Balance**: After recording each purchase and sale, update the “Inventory Balance” columns to reflect the new quantities and costs. Ensure that the perpetual LIFO method is applied, meaning the most recently purchased inventory items are sold first when recording cost of goods
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
Completing the Accounting Cycle
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
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