CMA Final · Strategic Cost Management · Business Forecasting Models - Time Series and Regression Analysis
A regression of monthly electricity cost Y (₹ thousand) on machine hours X (thousand) for a plant gives: n = 5, ΣX = 15, ΣY = 40, ΣXY = 130, ΣX² = 55. What is the estimated value of Y when X = 4?
The estimated cost is ₹9 thousand. The slope is (5×130 - 15×40)/(5×55 - 15²) = 50/50 = 1, the intercept is 8 - 3 = 5, so at X = 4 the estimate is 5 + 4 = 9.
- A10Correct
- B11
- C9
- D12
Explanation
b = (nΣXY - ΣXΣY)/(nΣX² - (ΣX)²) = (650 - 600)/(275 - 225) = 50/50 = 1. Mean Y = 8, mean X = 3, so a = 8 - 1×3 = 5. At X = 4, Y = 5 + 4 = 9... recheck: 5 + 1×4 = 9. So the answer is 9.
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
- 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 …
- 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…
- 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 …
- A Pune firm uses a 3-period centred moving average to smooth quarterly sales (in units): Q1 120, Q2 150, Q3 135, Q4 165, Q5 180. What is the…
- 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…
- In a simple regression of cost on activity, the coefficient of correlation r is −0.8. What is the coefficient of determination, and what doe…