ACCA Applied Knowledge · Management Accounting · Analytical techniques in budgeting and forecasting
A company's raw material price index was 120 in Year 1 (base Year 0 = 100) and 150 in Year 2. Material cost in Year 1 was $48,000. Assuming the same quantity is purchased in Year 2, what is the expected material cost in Year 2?
The expected cost is $60,000. Rebase the Year 1 cost by multiplying by the ratio of the new index to the old index, 150/120, which gives 48,000 x 1.25. Applying 150/100 would wrongly treat the Year 1 cost as base-year cost.
- A$60,000Correct
- B$57,600
- C$40,000
- D$72,000
Explanation
Cost in Year 2 = 48,000 x 150/120 = $60,000. Using 150/100 gives $72,000, which wrongly applies the index to the Year 1 cost as if it were base-year cost. Using 120/150 inverts the ratio and gives $38,400-type errors.
Did you get it right without looking?
One question tells you little. A timed set on Analytical techniques in budgeting and forecasting shows your real accuracy, how long you take and where you lose marks.
More Analytical techniques in budgeting and forecasting questions
- In a multiplicative model with four quarters, the seasonal indices for Quarters 1 to 3 are 0.80, 1.20 and 1.10. Actual sales in Quarter 4 we…
- Analysis of a company's monthly overhead cost against production volume gives a coefficient of determination of 0.49, with a positive regres…
- Monthly sales of a product were 40, 46 and 52 units in January, February and March. What is the three-month moving average, which is placed …
- In which situation is learning curve theory MOST likely to be applicable?
- Which of the following changes would leave the correlation coefficient between two variables x and y unchanged?
- Using an additive model, the average seasonal variations calculated for three quarters are Q1 +40, Q2 -15 and Q3 -60. What should the season…