Using the weighted average method, complete the steps below to calculate the ending inventory units, inventory account balance, and cost of goods sold account balance at the end of the period. Date Activity Units Purchase Price (per unit) Sale Price (per unit) 1-Feb Beginning Inventory 100 $ 45 15-Feb Purchase 700 $ 52 9-Apr Sale 1 600 $ 90 29-May Purchase 500 $ 56 10-Jul Sale 2 600 $ 90 10-Sep Purchase 400 $ 58 15-Oct Sale 3 400 $ 90 5-Nov Purchase 900 $ 62 18-Dec Sale 4 200 $ 90 1. Compute the Cost of Goods Sold and ending inventory (units and value) after Sale 1. Cost of Goods Sold (units) Total COGS after Sale 1 Inventory Remaining (units) Total Inventory Balance after Sale 1 Weighted average: Totals: 2. Compute the Cost of Goods Sold and ending inventory (units and value) after Sale 2. Cost of Goods Sold (units) Total COGS after Sale 2 Inventory Remaining (units) Total Balance after Sale 2 Weighted average: Totals: 3. Compute the Cost of Goods Sold and ending inventory (units and value) after Sale 3. Cost of Goods Sold (units) Total COGS after Sale 3 Inventory Remaining (units) Total Balance after Sale 3 Weighted average: Totals: 4. Compute the Cost of Goods Sold and ending inventory (units and value) after Sale 4. Cost of Goods Sold (units) Total COGS after Sale 4 Inventory Remaining (units) Total Balance after Sale 4 Weighted average: Totals: 5. Calculate the values below Ending inventory units: Ending inventory account balance: Cost of Goods Sold account balance:
Using the weighted average method, complete the steps below to calculate the ending inventory units, inventory account balance, and cost of goods sold account balance at the end of the period. Date Activity Units Purchase Price (per unit) Sale Price (per unit) 1-Feb Beginning Inventory 100 $ 45 15-Feb Purchase 700 $ 52 9-Apr Sale 1 600 $ 90 29-May Purchase 500 $ 56 10-Jul Sale 2 600 $ 90 10-Sep Purchase 400 $ 58 15-Oct Sale 3 400 $ 90 5-Nov Purchase 900 $ 62 18-Dec Sale 4 200 $ 90 1. Compute the Cost of Goods Sold and ending inventory (units and value) after Sale 1. Cost of Goods Sold (units) Total COGS after Sale 1 Inventory Remaining (units) Total Inventory Balance after Sale 1 Weighted average: Totals: 2. Compute the Cost of Goods Sold and ending inventory (units and value) after Sale 2. Cost of Goods Sold (units) Total COGS after Sale 2 Inventory Remaining (units) Total Balance after Sale 2 Weighted average: Totals: 3. Compute the Cost of Goods Sold and ending inventory (units and value) after Sale 3. Cost of Goods Sold (units) Total COGS after Sale 3 Inventory Remaining (units) Total Balance after Sale 3 Weighted average: Totals: 4. Compute the Cost of Goods Sold and ending inventory (units and value) after Sale 4. Cost of Goods Sold (units) Total COGS after Sale 4 Inventory Remaining (units) Total Balance after Sale 4 Weighted average: Totals: 5. Calculate the values below Ending inventory units: Ending inventory account balance: Cost of Goods Sold account balance:
Cornerstones of Financial Accounting
4th Edition
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Jay Rich, Jeff Jones
Chapter6: Cost Of Goods Sold And Inventory
Section: Chapter Questions
Problem 24CE: Inventory Costing: Average Cost Refer to the information for Filimonov Inc. and assume that the...
Related questions
Question
Using the weighted average method, complete the steps below to calculate the ending inventory units, inventory account balance, and cost of goods sold account balance at the end of the
period.
Date Activity Units Purchase Price (per unit) Sale Price (per unit)
1-Feb Beginning Inventory 100 $ 45
15-Feb Purchase 700 $ 52
9-Apr Sale 1 600 $ 90
29-May Purchase 500 $ 56
10-Jul Sale 2 600 $ 90
10-Sep Purchase 400 $ 58
15-Oct Sale 3 400 $ 90
5-Nov Purchase 900 $ 62
18-Dec Sale 4 200 $ 90
1. Compute the Cost of Goods Sold and ending inventory (units and value) after Sale 1.
Cost of Goods Sold (units) Total COGS after Sale 1 Inventory Remaining (units) Total Inventory Balance after Sale 1
Weighted average:
Totals:
2. Compute the Cost of Goods Sold and ending inventory (units and value) after Sale 2.
Cost of Goods Sold (units) Total COGS after Sale 2 Inventory Remaining (units) Total Balance after Sale 2
Weighted average:
Totals:
3. Compute the Cost of Goods Sold and ending inventory (units and value) after Sale 3.
Cost of Goods Sold (units) Total COGS after Sale 3 Inventory Remaining (units) Total Balance after Sale 3
Weighted average:
Totals:
4. Compute the Cost of Goods Sold and ending inventory (units and value) after Sale 4.
Cost of Goods Sold (units) Total COGS after Sale 4 Inventory Remaining (units) Total Balance after Sale 4
Weighted average:
Totals:
5. Calculate the values below
Ending inventory units:
Ending inventory account balance:
Cost of Goods Sold account balance:
period.
Date Activity Units Purchase Price (per unit) Sale Price (per unit)
1-Feb Beginning Inventory 100 $ 45
15-Feb Purchase 700 $ 52
9-Apr Sale 1 600 $ 90
29-May Purchase 500 $ 56
10-Jul Sale 2 600 $ 90
10-Sep Purchase 400 $ 58
15-Oct Sale 3 400 $ 90
5-Nov Purchase 900 $ 62
18-Dec Sale 4 200 $ 90
1. Compute the Cost of Goods Sold and ending inventory (units and value) after Sale 1.
Cost of Goods Sold (units) Total COGS after Sale 1 Inventory Remaining (units) Total Inventory Balance after Sale 1
Weighted average:
Totals:
2. Compute the Cost of Goods Sold and ending inventory (units and value) after Sale 2.
Cost of Goods Sold (units) Total COGS after Sale 2 Inventory Remaining (units) Total Balance after Sale 2
Weighted average:
Totals:
3. Compute the Cost of Goods Sold and ending inventory (units and value) after Sale 3.
Cost of Goods Sold (units) Total COGS after Sale 3 Inventory Remaining (units) Total Balance after Sale 3
Weighted average:
Totals:
4. Compute the Cost of Goods Sold and ending inventory (units and value) after Sale 4.
Cost of Goods Sold (units) Total COGS after Sale 4 Inventory Remaining (units) Total Balance after Sale 4
Weighted average:
Totals:
5. Calculate the values below
Ending inventory units:
Ending inventory account balance:
Cost of Goods Sold account balance:
Expert Solution
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
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
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Financial Accounting
Accounting
ISBN:
9781337272124
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Financial Accounting
Accounting
ISBN:
9781305088436
Author:
Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:
Cengage Learning