ICAEW BIP · Chapter 8 · Question 6 of 10
Sales for four consecutive months were 120, 135, 141, 150 units. What is the three-month moving average centred on the third month?
Test yourself: pick an answer
Reveal answer & explanation
Correct answer: C) 142
Explanation
The three-month moving average centred on month 3 uses months 2, 3 and 4: (135 + 141 + 150) / 3 = 426 / 3 = 142. The average of months 1 to 3 (132) would be centred on month 2.
More Forecasting techniques and flexible budgets MCQs
- Q8Which of the following is a limitation of using time series analysis to forecast future sales?
- Q9A company's budgeted costs for 10,000 units are based on: variable costs £7.40 per unit; fixed costs £52,000; semi-variable costs of…
- Q10A company budgeted to sell 10,000 units at £30 each, with variable costs of £18 per unit and fixed costs of £90,000. Actual sales were…
- Q1A retailer uses its historical sales data, together with weather forecasts and local event data, in a statistical model to estimate next…
- Q2A company forecasts quarterly sales using an additive time series model. The trend is given by T = 2,400 + 35t, where t is the quarter…
