Mathematics Chapter 11 Homework Problem 11-19 Average Error 47000 Absolute Input Data Forecast 

subject Type Homework Help
subject Pages 5
subject Words 181
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
Forecasting Exponential smoothing
Input Data Forecast Error Analysis
Period Actual value Forecast Error
Absolute
error
Squared
error
Absolute
% error
Year 1 480 440.000
Problem 11-19 (a)
Forecasting Exponential smoothing
Input Data Forecast Error Analysis
Period Actual value Forecast Error
Absolute
error
Squared
error
Absolute
% error
Year 1 480 440.000
Problem 11-19 (a)
Forecasting Exponential smoothing
Input Data Forecast Error Analysis
Period Actual value Forecast Error
Absolute
error
Squared
error
Absolute
% error
Year 1 480 440.000
Year 2 525 478.000 47.000 47.000 2209.000 8.95%
Problem 11-19 (a)
Forecasting 3 period moving average
Input Data Forecast Error Analysis
Period Actual Value Forecast Error
Absolute
error
Squared
error
Absolute
% error
Year 1 480
Problem 11-19 (b)
Forecasting Linear trend analysis
Input Data Forecast Error Analysis
Period
Actual value
(or) Y
Period number
(or) X
Forecast Error
Squared
error
Absolute
% error
Year 1 480 1 484.800 -4.800 4.800 23.040 1.00%
Problem 11-19 (c)

Trusted by Thousands of
Students

Here are what students say about us.

Resources
Company
Legal

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