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 Textbook Managerial Decision Modeling with Spreadsheets 3rd Edition
subject Authors Barry Render, Jr. Ralph M. Stair, Nagraj Balakrishnan
search this document

Unlock document.

This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
page-pf1
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)
page-pf2
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)
page-pf3
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.

Resources
Company
Legal

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