CMA Final · Strategic Cost Management · Business Forecasting Models - Time Series and Regression Analysis
A Pune firm uses a 3-period centred moving average to estimate trend. Monthly sales (Rs lakh) for Jan to May are 40, 46, 43, 52, 49. What is the trend value for April?
The April trend value is 48.0 lakh, because a centred three-period moving average for April averages March, April and May sales: (43+52+49)/3 = 48. The value 47 belongs to March.
- A47.0Correct
- B46.0
- C48.0
- D44.0
Explanation
The centred 3-period average for April uses March, April and May: (43+52+49)/3 = 144/3 = 48. Wait, April is centred on March, April, May, so the value is 48.0. Using Feb-Apr (46+43+52)/3 = 47 is the trend for March, not April.
Did you get it right without looking?
One question tells you little. A timed set on Business Forecasting Models - Time Series and Regression Analysis shows your real accuracy, how long you take and where you lose marks.
More Business Forecasting Models - Time Series and Regression Analysis questions
- Exponential smoothing with alpha = 0.4 is used by a Chennai retailer. The forecast for May was 500 units and actual May sales were 560 units…
- For five periods, a Chennai firm finds ΣX = 15, ΣY = 60, ΣXY = 205 and ΣX² = 55, where X is the period number. Using least squares, what is …
- For five periods, a Chennai firm finds ΣX = 15, ΣY = 60, ΣXY = 205 and ΣX² = 55, where X is the period number. Using least squares, what is …
- A Pune retailer fits a linear trend to quarterly sales (in Rs lakh) using coded time t, where t = 0 at the middle of the series. The fitted …
- In a seasonal analysis using the multiplicative model, a Kolkata firm's deseasonalised sales trend for next quarter is Rs 8,00,000 and the s…
- A Jaipur firm finds that, for quarterly sales, the seasonal indices (average = 100) are Q1 90, Q2 110, Q3 120 and Q4 80. The deseasonalised …