Homework Help Question & Answers

1.Please use the Hawkins sheet. What is the MFE  , MAE  , MSE  , an...

3-month Moving Avearge forecast Forecast Error Absolute Value of Forecast Error Squared Forecast Error Percentage Error AbsolMonthy Proportion of On Tme Payments 80 82 84 83 83 84 85 84 82 83 84 Exponential Smoothing Forecast (alpha-0.2) Forecast Err

1.Please use the Hawkins sheet.

What is the MFE  , MAE  , MSE  , and MAPE  for a three-month moving average forecast?  Round to two decimal places.

2.Please use the Hawkins sheet.

What is the MFE  , MAE  , MSE  , and MAPE  for the exponential smoothing forecast with alpha = 0.2? Round to two decimal places.

3.Please use the Hawkins sheet.

Based on the MSE values found in Questions 1 & 2, which forecast is best?

------------------------------------------------------------------

Thank you very much!!


Monthy Proportion of On Tme Payments 80 82 84 83 83 84 85 84 82 83 84 Exponential Smoothing Forecast (alpha-0.2) Forecast Error Absolute Value of Forecast E Squared Forecast Error Percentage Error Absolute Value of Percentage Error Total MFE MAE MSE MAPE
0 0
Next > < Previous
ReportAnswer #1
3-month moving average forecast forecast error absolute value of forecast error squared forecast error percentage error absolute value of percentage error
80
82
84
83 82 1 1 1 1.204819277 1.204819277
83 83 0 0 0 0 0
84 83.33333333 0.666666667 0.666666667 0.444444444 0.793650794 0.793650794
85 83.33333333 1.666666667 1.666666667 2.777777778 1.960784314 1.960784314
84 84 0 0 0 0 0
82 84.33333333 -2.33333333 2.333333333 5.444444443 -2.845528455 2.845528455
83 83.66666667 -0.66666667 0.666666667 0.444444445 -0.803212851 0.803212852
84 83 1 1 1 1.19047619 1.19047619
83 83 0 0 0 0 0
83.33333333
sum 1.333333333 7.333333333 11.11111111 1.500989268 8.798471882
MFE = 1.333333333/9 =0.148
MAE = 7.333333333/9 = 0.815
MSE = 11.11111111/9 = 1.235
MAPE = 8.798471882/9 = 0.97761
Exponential smoothing forecast (alpha = 0.2) forecast error the absolute value of forecast error squared forecast error percentage error absolute value of percentage error
80 80
82 80 2 2 4 2.43902439 2.43902439
84 80.4 3.6 3.6 12.96 4.285714286 4.285714286
83 81.12 1.88 1.88 3.5344 2.265060241 2.265060241
83 81.496 1.504 1.504 2.262016 1.812048193 1.812048193
84 81.7968 2.2032 2.2032 4.85409024 2.622857143 2.622857143
85 82.23744 2.76256 2.76256 7.631737754 3.250070588 3.250070588
84 82.789952 1.210048 1.210048 1.464216162 1.440533333 1.440533333
82 83.0319616 -1.0319616 1.0319616 1.064944744 -1.258489756 1.258489756
83 82.82556928 0.17443072 0.17443072 0.030426076 0.210157494 0.210157494
84 82.86045542 1.139544576 1.139544576 1.298561841 1.356600686 1.356600686
83 83.08836434 -0.08836434 0.08836434 0.007808257 -0.106463059 0.10646306
83.07069147
sum 15.35345736 17.59410924 39.10820107 18.31711354 21.04701917
MFE = 15.35345736/11 = 1.3958
MAE = 17.59410924/11 = 1.59946
MSE = 39.10820107/11 = 3.555291
MAPE = 21.04701917/11 = 1.913365

3 - month moving average is best. because of less MSE

Know the answer?
Add Answer of:
1.Please use the Hawkins sheet. What is the MFE  , MAE  , MSE  , an...
Your Answer: Your Name: What's your source?
Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Monthy Proportion of On Tme Payments 80 82 84 83 83 84 85 84 82 83...

    Monthy Proportion of On Tme Payments 80 82 84 83 83 84 85 84 82 83 84 83 Calculate the following for a 3-month moving average forecast; round each to 2 decimal places: a. MFE b. MAE c. MSE d. MAPE

  • Please use the following data: Monthy Proportion of On Tme Payments 80 82 84 83 83...

    Please use the following data: Monthy Proportion of On Tme Payments 80 82 84 83 83 84 85 84 82 83 84 83 a. Calculate the following for a 3-month moving average forecast; round each to 2 decimal places: b. Calculate the following for an exponential smoothing forecast with alpha = 0.2; round each to 2 decimal places: c: Based on the MSE values that you calculated in Questions 1 & 2, what is the difference in the MSE for...

  • PLEASE ONLY ANSWER IF YOU CAN DO WHAT IS BLANK, I DON'T NEED HELP WITH WHAT...

    PLEASE ONLY ANSWER IF YOU CAN DO WHAT IS BLANK, I DON'T NEED HELP WITH WHAT IS FILLED OUT ALREADY. THANK YOU! Problem 15-03 (Algorithmic) Consider the following time series data. Week 1 2 3 4 5 6 Value 1914 16 10 17 15 Using the naive method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy: a. Mean absolute error (MAE) b. Mean squared error (MSE) c. Mean absolute percentage error...

  • Consider the following time series data. Week 1 2 3 4 5 6 Value 20 13...

    Consider the following time series data. Week 1 2 3 4 5 6 Value 20 13 15 11 17 14 Using the naïve method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy: a. Mean absolute error (MAE) b. Mean squared error (MSE) c. Mean absolute percentage error (MAPE) Round your answers to two decimal places. MAE = MSE = MAPE = Using the average of all the historical data as a...

  • Please help Consider the following time series data. 3 4 5 6 Week 12 18 14...

    Please help Consider the following time series data. 3 4 5 6 Week 12 18 14 Value 17 1018 15 Using the average of all the historical data as a forecast for the next period, compute the following measures of forecast accuracy. (Round your answers to two decimal places.) (a) mean absolute error MAE - (b) mean squared error MSE - (c) mean absolute percentage error MAPE 96 (d) What is the forecast for week 7?

  • Please help. I'm stuck. DATA: Gassins These data show the number of palons of gasoline sold...

    Please help. I'm stuck. DATA: Gassins These data show the number of palons of gasoline sold by a gasoline distributor in Bennington, Vermont, over Week Sales (1.000s of gallons) 1 17 21 N 3 19 4 22 5 18 6 16 2 20 8 18 9 22 10 20 11 15 12 22 Show the exponential smoothing forecasts using a=0.1. (Round your answers to two decimal places.) Time Series Value Forecast Week 1 17 2. 21 19 23 5 18...

  • please reply fast for a thumbs up ?? Question 12 (1 point) The Simple Exponential Smoothing...

    please reply fast for a thumbs up ?? Question 12 (1 point) The Simple Exponential Smoothing (SES) forecast with an alpha of 25 for period is: (round to 2 decimal places) Absolute Absolute Percent Squared Error Error Error 1 Naive X(Period) Y(Sales) Forecast Error 16 2 10 3 22 4 10 5 15 6 12 7 Your Answer: Answer Question 13 (1 point) In the table below, what is the contribution margin per unit for product 1? Product 1 Price/Unit...

  • please reply fast for a thumbs up At what quantity is selling either of the products...

    please reply fast for a thumbs up At what quantity is selling either of the products equally profitable (point of indifference i.e. crossover point)? Price/Unit Variable Cost/unit Fixed Cost Product 1 Product 2 68 18 39,000 50 29 20,750 (Answer rounded to 0 decimal points, use standard rounding procedure) Your Answer: Answer Question 12 (1 point) The Simple Exponential Smoothing (SES) forecast with an alpha of.25 for period 4 is: (round to 2 decimal places) Absolute Absolute Percent Squared Error...

  • Question 30 (1 point) In the table below, what is the contribution margin per unit for...

    Question 30 (1 point) In the table below, what is the contribution margin per unit for product 1? Product 1 Price/Unit Variable Cost/ Unit Fixed Cost Product 2 83 40 33,600 55 30 35000 Your Answer: Answer Question 31 (1 point) A restaurant sells pizza at a rate of $13.13/slice. Expenses for the restaurant include raw material for pizza at $4.83 per slice, $188.40 as monthly rental and $56.00 monthly as insurance. How many slices should the restaurant sell in...

  • Please answer each question and highlight each answer or the table. Starbucks has a Isrge, global supply chain tha...

    Please answer each question and highlight each answer or the table. Starbucks has a Isrge, global supply chain that must eficienty supply over 17,000 stores. Although the stores might appesr to be very similse, they are actualy very difierent. Depending on the locaion of the store, its size, and the prolile of the oustomers served, Starbucks management oonfigures the store offerings to take maimum advantage of the space available and customer preferenoes. Starbucks' actual distribution system is much more complex,...

Free Homework App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.