6-3

QSO 520 Module Six Assignment Guidelines and Rubric Overview: For this assignment, you will solve problem 10.24 in Introduction to Management Science: A Modeling and Case Studies Approach With Spreadsheets (shown in the prompt below). Use the Module Six Assignment Template document, which contains three tabs with a table and charts already constructed for you. This assignment will give you practice with forecasting, which will be part of your final project. Prompt: Problem 10.24: The choice of the smoothing constants, α and β, has a considerable effect on the accuracy of the forecasts obtained by using exponential smoothing with trend. For each of the following time series, set α = 0.2 and then compare MAD obtained with β = 0.1, 0.2, 0.3, 0.4, and 0.5. Begin with initial estimates of 50 for the average value and 2 for the trend.

A. 52, 55, 55, 58, 59, 63, 64, 66, 67, 72, 73, 74 B. 52, 55, 59, 61, 66, 69, 71, 72, 73, 74, 73, 74 C. 52, 53, 51, 50, 48, 47, 49, 52, 57, 62, 69, 74

Rubric

Guidelines for Submission: Your assignment must be submitted using the Module Six Assignment Template.

Critical Elements Proficient (100%) Needs Improvement (70%) Not Evident (0%) Value

Forecasting Performs correct calculations, resulting in an accurate forecast

Performs incorrect calculations, resulting in an inaccurate forecast

Does not perform calculations 100

Total 100%