# Quantitative Methods: Demand for Product ZXT

Recent past demand for product ZXT is given in the following table:

Month Actual Demand
February 20
March 22
April 33
May 35
June 31
July 48
August 41

a) Determine the forecasted demand for May, June, July and August based on a three month moving average.
b) Determine the forecasted demand for May, June, July and August based on a three month weighted moving average with weights w1=.1, w2=.4, and w3=.5, where w3 is the weight for the most recent month of the three months.
c) Determine the forecasted demand for March, April, May, June, July and August based on a simple exponential smoothing with alpha (&#945;) = 0.4.
d) Determine the forecasted demand for March, April, May, June, July and August based on an adjusted exponential smoothing with alpha (&#945;) = .2 and beta (&#946;) = .3.
e) Compute MAD (Mean Absolute Deviation) and MSE (Mean Squared Error) for the results from a), b), c) and d).

Show all work, where appropriate. If using Excel, please include all formulas in cells where calculations are made.

This question has the following supporting file(s):

• MAT540_080209.doc
###### File Viewer (Click To Zoom)

Solution Summary

Step by step solution with calculations is provided in an attached Excel file.

\$2.19
• Plain text
• Cited sources when necessary
• Attached file(s)
• Recent past demand for product ZXT_solution.xls

Sandhya Sharma, MSc

Rating 4.9/5

Active since 2008

BSc, Meerut University
MSc, Meerut University
MSc, AIT

Responses 1996

"Excellent. Well explained."

"Thanks once again"

"Good work once again"

"Excellent Work as usual"

"Thank you again. All working shown making comprehension easy."

Extracted Content from Question Files:

• MAT540_080209.doc

Recent past demand for product ZXT is given in the following table:

Month Actual Demand
February 20
March 22
April 33
May 35
June 31
July 48
August 41

a) Determine the forecasted demand for May, June, July and August based on a three
month moving average.
b) Determine the forecasted demand for May, June, July and August based on a three
month weighted moving average with weights w1=.1, w2=.4, and w3=.5, where w3 is the
weight for the most recent month of the three months.
c) Determine the forecasted demand for March, April, May, June, July and August based
on a simple exponential smoothing with alpha (α) = 0.4.
d) Determine the forecasted demand for March, April, May, June, July and August based
on an adjusted exponential smoothing with alpha (α) = .2 and beta (β) = .3.
e) Compute MAD (Mean Absolute Deviation) and MSE (Mean Squared Error) for the
results from a), b), c) and d).

Show all work, where appropriate. If using Excel, please include all formulas in cells