Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

1. Compute MSE, MAD, and MAPE for the following customer satisfaction data: Month Customer Satisfaction Score Forecast 1 88.7 83.3 2 87.7 86.5 3 90.1

1. Compute MSE, MAD, and MAPE for the following customer satisfaction data:

Month Customer Satisfaction Score Forecast
1 88.7 83.3
2 87.7 86.5
3 90.1 88.3
4 93.0 89.1
5 91.2 90.4

Do not round intermediate calculations. Round your answers to three decimal places.

A. MSE______

B. MAD_______

C. MAPE________

2. Cynthia's Design Studios had sales the last four months of $13,700, $15,400, $17,500, and $18,600. 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.

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

B. What is the forecast for the fifth month using = 0.9 in an exponential smoothing model with A4 = 18,600 and F4 = $16,923 to get things started.________

3.Exotic Wines, Inc. wants to use exponential smoothing with = 0.45 to forecast demand in bottles sold. The demand the last four months are 3,221, 3,997, 2,845, and 4,412 bottles. The forecast for bottles was 3,221 bottles for the second month. What is the forecast for the fifth month? Round your answer to the nearest whole number.

_________bottles

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial And Managerial Accounting For MBAs

Authors: Peter D. Easton

6th Edition

1618533592, 9781618533593

Students also viewed these Accounting questions