Required information Use the following information for the Exercises below. [The following information applies to the questions displayed below.] Laker Company reported the following January purchases and sales data for its only product. Activities Units Acquired at Cost 215 units @ $14.00 = $3,010 Date Units sold at Retail Jan. 1 Beginning inventory Jan. 10 Sales 165 units @ $23.00 160 units @ $13.00 = 2,080 Jan. 20 Purchase Jan. 25 Sales 190 units @ $23.00 Jan. 30 Purchase 330 units @ $12.50 = 4,125 Totals 705 units $9,215 355 units The Company uses a perpetual inventory system. For specific identification, ending inventory consists of 350 units, where 330 are from the January 30 purchase, 5 are from the January 20 purchase, and 15 are from beginning inventory. Exercise 5-3 Perpetual: Inventory costing methods LO P1 Required: 1. Complete the table to determine the cost assigned to ending inventory and cost of goods sold using specific identification. 2. Determine the cost assigned to ending inventory and to cost of goods sold using weighted average. 3. Determine the cost assigned to ending inventory and to cost of goods sold using FIFO.

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
Practice Pack
### Required Information

Use the following information for the exercises below.
*[The following information applies to the questions displayed below.]*
 
Laker Company reported the following January purchases and sales data for its only product:

| Date       | Activities                   | Units Acquired at Cost          | Units Sold at Retail         |
|------------|------------------------------|----------------------------------|------------------------------|
| Jan. 1     | Beginning inventory          | 215 units @ $14.00 = $3,010     |                              |
| Jan. 10    | Sales                        |                                  | 165 units @ $23.00           |
| Jan. 20    | Purchase                     | 160 units @ $13.00 = $2,080     |                              |
| Jan. 25    | Sales                        |                                  | 190 units @ $23.00           |
| Jan. 30    | Purchase                     | 330 units @ $12.50 = $4,125     |                              |
| **Totals** |                              | **705 units = $9,215**          | **355 units**                |

The company uses a perpetual inventory system. For specific identification, ending inventory consists of 350 units, where 330 are from the January 30 purchase, 5 are from the January 20 purchase, and 15 are from the beginning inventory.

### Exercise 5-3 Perpetual: Inventory costing methods LO P1

#### Required:
1. Complete the table to determine the cost assigned to ending inventory and cost of goods sold using specific identification.
2. Determine the cost assigned to ending inventory and to cost of goods sold using weighted average.
3. Determine the cost assigned to ending inventory and to cost of goods sold using FIFO.
4. Determine the cost assigned to ending inventory and to cost of goods sold using LIFO.
Transcribed Image Text:### Required Information Use the following information for the exercises below. *[The following information applies to the questions displayed below.]* Laker Company reported the following January purchases and sales data for its only product: | Date | Activities | Units Acquired at Cost | Units Sold at Retail | |------------|------------------------------|----------------------------------|------------------------------| | Jan. 1 | Beginning inventory | 215 units @ $14.00 = $3,010 | | | Jan. 10 | Sales | | 165 units @ $23.00 | | Jan. 20 | Purchase | 160 units @ $13.00 = $2,080 | | | Jan. 25 | Sales | | 190 units @ $23.00 | | Jan. 30 | Purchase | 330 units @ $12.50 = $4,125 | | | **Totals** | | **705 units = $9,215** | **355 units** | The company uses a perpetual inventory system. For specific identification, ending inventory consists of 350 units, where 330 are from the January 30 purchase, 5 are from the January 20 purchase, and 15 are from the beginning inventory. ### Exercise 5-3 Perpetual: Inventory costing methods LO P1 #### Required: 1. Complete the table to determine the cost assigned to ending inventory and cost of goods sold using specific identification. 2. Determine the cost assigned to ending inventory and to cost of goods sold using weighted average. 3. Determine the cost assigned to ending inventory and to cost of goods sold using FIFO. 4. Determine the cost assigned to ending inventory and to cost of goods sold using LIFO.
### Specific Identification Method for Inventory Cost Calculation

#### Instruction:
Complete this table to determine the cost assigned to ending inventory and cost of goods sold using specific identification. (Round cost per unit to 2 decimal places).

#### Table: Inventory Cost Calculation

**Specific Identification:**

| Purchase Date | Activity             | Units | Available for Sale | Cost of Goods Sold | Ending Inventory          |
| --------------|----------------------|-------|---------------------|--------------------|---------------------------|
|               |                      |       | Units | Unit Cost | Units Sold | Unit Cost | COGS | Units | Cost Per Unit | Inventory Cost |
| Jan. 1        | Beginning Inventory  | 215   |       |           |            |           |      |       |               |                |
| Jan. 20       | Purchase             | 160   |       |           |            |           |      |       |               |                |
| Jan. 30       | Purchase             | 330   |       |           |            |           |      |       |               |                |
|               |                      | **705**|      |           |            |           |      |       |               |                |

##### Notes:
- **Units Sold:** Number of units sold from each purchase batch.
- **Unit Cost:** Cost per unit for each batch (to be filled out based on actual data).
- **COGS (Cost of Goods Sold):** Total cost for the units sold.
- **Ending Inventory Units:** Number of units remaining in inventory.
- **Cost Per Unit:** Cost per unit of remaining inventory (to be calculated as per specific identification).
- **Ending Inventory Cost:** Total cost of inventory remaining.

Remember to fill out all the columns with the appropriate data and calculations, ensuring that any created data is consistent with specific identification and inventory cost principles.

**Graph/Diagram Explanation:**
- No specific graphs or diagrams are present in this image. The table is structured to facilitate calculation of inventory costs and must be completed accurately by following the given instructions.

**Interactive Component:**
- Users may be required to interact with this resource by filling in the required data in the provided tabs (Required 1, Required 2, etc.) as part of their learning and understanding of inventory management using the specific identification method.
Transcribed Image Text:### Specific Identification Method for Inventory Cost Calculation #### Instruction: Complete this table to determine the cost assigned to ending inventory and cost of goods sold using specific identification. (Round cost per unit to 2 decimal places). #### Table: Inventory Cost Calculation **Specific Identification:** | Purchase Date | Activity | Units | Available for Sale | Cost of Goods Sold | Ending Inventory | | --------------|----------------------|-------|---------------------|--------------------|---------------------------| | | | | Units | Unit Cost | Units Sold | Unit Cost | COGS | Units | Cost Per Unit | Inventory Cost | | Jan. 1 | Beginning Inventory | 215 | | | | | | | | | | Jan. 20 | Purchase | 160 | | | | | | | | | | Jan. 30 | Purchase | 330 | | | | | | | | | | | | **705**| | | | | | | | | ##### Notes: - **Units Sold:** Number of units sold from each purchase batch. - **Unit Cost:** Cost per unit for each batch (to be filled out based on actual data). - **COGS (Cost of Goods Sold):** Total cost for the units sold. - **Ending Inventory Units:** Number of units remaining in inventory. - **Cost Per Unit:** Cost per unit of remaining inventory (to be calculated as per specific identification). - **Ending Inventory Cost:** Total cost of inventory remaining. Remember to fill out all the columns with the appropriate data and calculations, ensuring that any created data is consistent with specific identification and inventory cost principles. **Graph/Diagram Explanation:** - No specific graphs or diagrams are present in this image. The table is structured to facilitate calculation of inventory costs and must be completed accurately by following the given instructions. **Interactive Component:** - Users may be required to interact with this resource by filling in the required data in the provided tabs (Required 1, Required 2, etc.) as part of their learning and understanding of inventory management using the specific identification method.
Expert Solution
trending now

Trending now

This is a popular solution!

video

Learn your way

Includes step-by-step video

steps

Step by step

Solved in 4 steps with 6 images

Blurred answer
Knowledge Booster
Accounting for Merchandise Inventory
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