solution

Compute MSE, MAD, and MAPE for the following customer satisfaction data. Do not round intermediate calculations. Round your answers to three decimal places.

MSE:

MAD:

MAPE:

Month	Customer Satisfaction Score	Forecast
1	88.7	83.6
2	87.7	86.1
3	90.2	88.2
4	93.0	89.5
5	90.5	89.9

2:

Cynthia’s Design Studios had sales the last four months of $13,700, $15,400, $17,000, and $18,650. Sales are related to how many designers Cynthia has on-duty. The sales forecast helps her decide on the proper staffing levels. Round your answers to the nearest whole number.

1. What is the forecast for the fifth month using a two-period moving average?

2. What is the forecast for the fifth month using a = 0.9 in an exponential smoothing model with A₄ = 18,650 and F₄ = $16,983 to get things started.