Mathematics Chapter 11 Homework Problem 11-42 Centered Seasonal value (Y) period (X) average

subject Type Homework Help
subject Pages 2
subject Words 104
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 Multiplicative decomposition
4 seasons
Input Data Seasonal Index Computation Forecast Error analysis
Period
Actual
value (Y)
Time
period (X)
Centered
average
Seasonal
ratio
Seasonal
index
Unseason
alized
value
Unseason
alized
Forecast
Seasonali
zed
Forecast
Error
Absolute
error
Squared
error
Absolute
% error
Quarter 1 9027 1 1.001 9014.982 9051.176 9063.242 -36.242 36.242 1313.488 0.40%
Quarter 2 9092 2 1.001 9085.075 9163.686 9170.671 -78.671 78.671 6189.106 0.87%
Quarter 3 9194 3 9229.750 0.996 0.998 9216.624 9276.197 9253.426 -59.426 59.426 3531.507 0.65%
Quarter 4 9367 4 9351.500 1.002 1.002 9348.932 9388.708 9406.853 -39.853 39.853 1588.238 0.43%
Seasonal Ratios
Season 1 Season 2 Season 3 Season 4
1.000 1.005 1.000 1.001
1.001 1.000
Average 1.001 1.001 0.998 1.002
Forecasts for future periods
Period
Unseason
alized
forecast
Seasonal
index
Seasonaliz
ed
forecast
Problem 11-42

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.