By NEAS - 8/1/2018 9:40:07 PM
FA Module 8 Inventory weighted average practice exam questions
(The attached PDF file has better formatting.)
A firm buys inventory in Country W and resells it to customers in Country Z.
● At year-end 20X0, the firm has 179 units of inventory costing 7.30 apiece.
● In 20X1, the firm buys 495 units at 10.10 apiece and sells 431 units for 17.30 apiece.
● In 20X2, the firm buys 585 units at 12.60 apiece and sells 544 units for 18.60 apiece.
The firm uses the weighted average inventory method.
Question 8.1: Inventory units at year-end 20X1
What are the units of inventory at year-end 20X1?
Answer 8.1: 179 + 495 – 431 = 243
(units of inventory at year-end 20X1 = units held at year-end 20X0 + units bought in 20X1 – units sold in 20X1)
Question 8.2: Inventory at year-end 20X1
What is the inventory at year-end 20X1?
Answer 8.2: 243 × (179 × 7.30 + 495 × 10.10) / (179 + 495) = 2,273.60
(inventory at year-end 20X1 = inventory units × weighted average cost)
Question 8.3: Inventory units at year-end 20X1
What are the units of inventory at year-end 20X1?
Answer 8.3: 243 + 585 – 544 = 284
(units of inventory at year-end 20X1 = units held at year-end 20X1 + units bought in 20X2 – units sold in 20X2)
Question 8.4: Inventory at year-end 20X2
What is the inventory at year-end 20X2?
Answer 8.4: 284 × (2,273.60 + 585 × 12.60) / (243 + 585) = 3,308.05
(inventory at year-end 20X2 = inventory units × weighted average cost)
Question 8.5: Cost of goods sold in 20X1
What is the cost of goods sold in 20X1?
Answer 8.5: 179 × 7.30 + 495 × 10.10 – 2,273.60 = 4,032.60
(cost of goods sold in 20X1 = units on hand at year-end 20X0 × cost per unit + units bought in 20X1 × cost per unit in 20X1 – inventory at year-end 20X1)
Question 8.6: Cost of goods sold in 20X2
What is the cost of goods sold in 20X2?
Answer 8.6: 2,273.60 + 585 × 12.60 – 3,308.05 = 6,336.55
(cost of goods sold in 20X2 = inventory at year-end 20X1 + units bought in 20X2 × cost per unit in 20X2 – inventory at year-end 20X2)
Question 8.7: Inventory turnover in 20X1
What is the inventory turnover in 20X1?
Answer 8.7: 4,032.60 / ( (1,306.70 + 2,273.60) / 2) = 2.253
(inventory turnover = cost of goods sold / average inventory)
Question 8.8: Inventory turnover in 20X2
What is the inventory turnover in 20X2?
Answer 8.8: 6,336.55 / ( (2,273.60 + 3,308.05) / 2) = 2.270
(inventory turnover = cost of goods sold / average inventory)
Question 8.9: Gross profit margin in 20X1
What is the gross profit margin in 20X1?
Answer 8.9: 1 – 4,032.60 / (431 × 17.30) = 45.92%
(gross profit margin = 1 – cost of goods sold / net revenue)
Question 8.10: Gross profit margin in 20X2
What is the gross profit margin in 20X2?
Answer 8.10: 1 – 6,336.55 / (544 × 18.60) = 37.38%
(gross profit margin = 1 – cost of goods sold / net revenue)
|
|