Mathematics Chapter 11 Homework Problem 11-41 Intercept Slope Next period Forecast Error Analysis

subject Type Homework Help
subject Pages 3
subject Words 153
subject Authors Barry Render, Jr. Ralph M. Stair, Nagraj Balakrishnan

Unlock document.

This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
Forecasting Exponential smoothing
Input Data Forecast Error Analysis
Period Actual value Forecast Error
Absolute
error
Squared
error
Absolute
% error
Quarter 1 9027 9027.000
Quarter 2 9092 9027.000 65.000 65.000 4225.000 0.71%
Quarter 3 9194 9092.000 102.000 102.000 10404.000 1.11%
Quarter 4 9367 9194.000 173.000 173.000 29929.000 1.85%
Problem 11-41 (a)
Forecasting Linear trend analysis
Input Data Forecast Error Analysis
Period
Actual value
(or) Y
Period number
(or) X
Forecast Error
Squared
error
Absolute
% error
Quarter 1 9027 1 9055.301 -28.301 28.301 800.973 0.31%
Quarter 2 9092 2 9167.778 -75.778 75.778 5742.296 0.83%
Quarter 3 9194 3 9280.254 -86.254 86.254 7439.824 0.94%
Problem 11-41 (b)
Forecasting 4 period moving average
Input Data Forecast Error Analysis
Period Actual Value Forecast Error
Absolute
error
Squared
error
Absolute
% error
Quarter 1 9027
Quarter 4 9367
Quarter 5 9505 9170.000 335.000 335.000 112225.000 3.52%
Quarter 6 9588 9289.500 298.500 298.500 89102.250 3.11%
Problem 11-41 (c)

Trusted by Thousands of
Students

Here are what students say about us.

Copyright ©2024 All rights reserved. | CoursePaper is not sponsored or endorsed by any college or university.