Question

In: Accounting

Given the following data, what is the weighted-average cost of ending inventory rounded to the nearest...

Given the following data, what is the weighted-average cost of ending inventory rounded to the nearest whole dollar? (Do not round in the process of your calculations, only round your final answer.)

Sales revenue 100 units at $15 per unit

Beginning inventory 40 units at $9 per unit

Purchases 80 units at $10 per unit

Solutions

Expert Solution

Weighted Average cost of ending inventory (20) units is $ 193.

Explanation :-

While using the weighted average cost method, we divide the cost of goods available for sale by the number of units available for sale, which yields the weighted-average cost per unit. In this calculation, the cost of goods available for sale is the sum of beginning inventory and net purchases. This weighted average figure is then used to assign a cost to both ending inventory and the COGS.

Calculation :-

Weighted Average Cost = Cost of goods available for sale / number of units available for sale

where,

Cost of goods available for sale = Value of beginning inventory + Value of net purchase

= (40 units * $9 per unit) + (80 units * $ 10 per unit)

= 360 + 800

=1160

Number of units available for sale = Units of beginning inventory + No. of units purchased

= 40 units + 80 units

= 120 units

Weighted Average Cost = 1160/120

= 9.66667

Value of Cost of Goods Sold = Units sold * Weighted average cost

= 100 units * 9.66667

= 966.667

Value of ending inventory = Closing inventory * Weighted average cost

= (120-100) units * 9.66667

= 20 units * 9.66667

= 193.33 or 193

ekkarill92 answered 2 years ago
Next > < Previous

Related Solutions

Calculate the cost of goods sold and ending inventory using weighted average. (Round the weighted average...
Calculate the cost of goods sold and ending inventory using weighted average. (Round the weighted average cost per unit to 2 decimal places, e.g. 5.25 and final answers to 0 decimal places, e.g. 5,250.) Purchases Cost of Goods Sold Balance Date Units Cost Total Units Cost Total Units Cost Total Units Total Cost WA Cost Per unit Apr-01 Beginning Inventory 26 $11 $286 26 $11 $286 Apr-15 52 $13 $676 $ $ 26 $286 52 $676 $ $ Apr-20 29...
1. Calculate the unit cost and the cost of ending inventory under absorption costing. (Round unit cost to the nearest cent and cost of ending inventory to the nearest dollar.)
1. Calculate the unit cost and the cost of ending inventory under absorption costing. (Round unit cost to the nearest cent and cost of ending inventory to the nearest dollar.)Under the absorption costing method, the unit cost is $4.23The cost of ending inventory is $52882. Calculate the unit cost and the cost of ending inventory under variable costing. (Round unit cost to the nearest cent and cost of ending inventory to the nearest dollar.)Under the variable costing method, the unit...
Given the following information, calculate the effective borrowing cost (rounded to the nearest tenth of a percent).
Given the following information, calculate the effective borrowing cost (rounded to the nearest tenth of a percent). Loan amount: $166,950, Term: 30 years, Interest rate: 8 %, Monthly Payment: $1,225.00, Discount points: 2, Other Closing Expenses: $3,611. A. 7.7% B. 8.2% C. 8.5% D. 9.1%
Weighted Average Cost Method with Perpetual Inventory The beginning inventory at Midnight Supplies and data on...
Weighted Average Cost Method with Perpetual Inventory The beginning inventory at Midnight Supplies and data on purchases and sales for a three-month period ending March 31, are as follows: Date Transaction Number of Units Per Unit Total Jan. 1 Inventory 7,500 $75.00 $562,500 10 Purchase 22,500 85.00 1,912,500 28 Sale 11,250 150.00 1,687,500 30 Sale 3,750 150.00 562,500 Feb. 5 Sale 1,500 150.00 225,000 10 Purchase 54,000 87.50 4,725,000 16 Sale 27,000 160.00 4,320,000 28 Sale 25,500 160.00 4,080,000 Mar....
Weighted Average Cost Method with Perpetual Inventory The beginning inventory at Midnight Supplies and data on...
Weighted Average Cost Method with Perpetual Inventory The beginning inventory at Midnight Supplies and data on purchases and sales for a three-month period ending March 31, are as follows: Date Transaction Number of Units Per Unit Total Jan. 1 Inventory 7,500 $75.00 $562,500 10 Purchase 22,500 85.00 1,912,500 28 Sale 11,250 150.00 1,687,500 30 Sale 3,750 150.00 562,500 Feb. 5 Sale 1,500 150.00 225,000 10 Purchase 54,000 87.50 4,725,000 16 Sale 27,000 160.00 4,320,000 28 Sale 25,500 160.00 4,080,000 Mar....
Weighted Average Cost Method with Perpetual Inventory The beginning inventory for Midnight Supplies and data on...
Weighted Average Cost Method with Perpetual Inventory The beginning inventory for Midnight Supplies and data on purchases and sales for a three-month period are as follows: Date Transaction Number of Units Per Unit Total Jan. 1 Inventory 7,100 $80.00 $568,000 10 Purchase 21,300 90.00 1,917,000 28 Sale 10,650 160.00 1,704,000 30 Sale 3,550 160.00 568,000 Feb. 5 Sale 1,420 160.00 227,200 10 Purchase 51,120 92.50 4,728,600 16 Sale 25,560 170.00 4,345,200 28 Sale 24,140 170.00 4,103,800 Mar. 5 Purchase 42,600...
Weighted Average Cost Method with Perpetual Inventory The beginning inventory at Midnight Supplies and data on...
Weighted Average Cost Method with Perpetual Inventory The beginning inventory at Midnight Supplies and data on purchases and sales for a three-month period ending March 31, are as follows: Date Transaction Number of Units Per Unit Total Jan. 1 Inventory 7,500 $75.00 $562,500 10 Purchase 22,500 85.00 1,912,500 28 Sale 11,250 150.00 1,687,500 30 Sale 3,750 150.00 562,500 Feb. 5 Sale 1,500 150.00 225,000 10 Purchase 54,000 87.50 4,725,000 16 Sale 27,000 160.00 4,320,000 28 Sale 25,500 160.00 4,080,000 Mar....
Weighted Average Cost Method >with Perpetual Inventory The beginning inventory for Dunne Co. and data on...
Weighted Average Cost Method >with Perpetual Inventory The beginning inventory for Dunne Co. and data on purchases and sales for a three-month period are as follows: Date Transaction Number of Units Per Unit Total Apr. 3 Inventory 25 $1,200 $30,000 8 Purchase 75 1,240 93,000 11 Sale 40 2,000 80,000 30 Sale 30 2,000 60,000 May 8 Purchase 60 1,260 75,600 10 Sale 50 2,000 100,000 19 Sale 20 2,000 40,000 28 Purchase 80 1,260 100,800 June 5 Sale 40...
Weighted Average Cost Method with Perpetual Inventory The beginning inventory at Midnight Supplies and data on...
Weighted Average Cost Method with Perpetual Inventory The beginning inventory at Midnight Supplies and data on purchases and sales for a three-month period ending March 31, are as follows: Date Transaction Number of Units Per Unit Total Jan. 1 Inventory 7,500 $75.00 $562,500 10 Purchase 22,500 85.00 1,912,500 28 Sale 11,250 150.00 1,687,500 30 Sale 3,750 150.00 562,500 Feb. 5 Sale 1,500 150.00 225,000 10 Purchase 54,000 87.50 4,725,000 16 Sale 27,000 160.00 4,320,000 28 Sale 25,500 160.00 4,080,000 Mar....
Weighted Average Cost Method with Perpetual Inventory The beginning inventory for Midnight Supplies and data on...
Weighted Average Cost Method with Perpetual Inventory The beginning inventory for Midnight Supplies and data on purchases and sales for a three-month period are as follows: Date Transaction Number of Units Per Unit Total Jan. 1 Inventory 7,500 $75.00 $562,500 10 Purchase 22,500 85.00 1,912,500 28 Sale 11,250 150.00 1,687,500 30 Sale 3,750 150.00 562,500 Feb. 5 Sale 1,500 150.00 225,000 10 Purchase 54,000 87.50 4,725,000 16 Sale 27,000 160.00 4,320,000 28 Sale 25,500 160.00 4,080,000 Mar. 5 Purchase 45,000...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT