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 4. Cost of Goods Sold (units) Total COGS after Sale 4 Inventory Remaining (units) Total Balance after Sale 4 Weighted average: Totals: 2. 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 4.
Cost of Goods Sold (units) Total COGS after Sale 4 Inventory Remaining (units) Total Balance after Sale 4
Weighted average:
Totals:
2. Calculate the values below
Ending inventory units:
Ending inventory account balance:
Cost of Goods Sold account balance:
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
