Question

Question 1 Part A The following table shows the best forecast for a time series representing...

Question 1 Part A

The following table shows the best forecast for a time series representing the number of people (in thousands) who have two or more jobs in the United States

Date Jobs Forecast
May 2013 6,487 6,788
June 2013 6,284 6,523
July 2013 6,253 6,279
August 2013 6,840 6,336

Calculate the MAD (mean absolute deviation) forecasting accuracy measurement. Take all calculations to three decimal places.

Part B

Based on the actual and forecasted returns shown below, calculate the mean absolute deviation (MAD)

Month Monthly Return Forecast (%)
July 2.20 1.95
August 2.25 2.21
September 1.8 2.35
October 1.4 2.15
November 1.1 1.6
December 1.9 1.2

0.249

1.531

0.507

None of these.

2.344

Part C

To calculate an exponential smoothing forecast of demand, what values are required?

alpha, last forecast, last actual value

alpha, last forecast, number of periods

last forecast, number of periods, averaging period

alpha, last forecast

alpha, number of periods, last actual demand

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Part a:

Mean absolute deviation =

Part b:

Mean absolute deviation =

The answer is none of the above

Part c:

Alpha, last forecast and last actual value

The formula for exponential smoothing forecast is

Yt+1 = Yt + alpha (At-Yt)

where, Yt is the forecasted value of the previous period, alpha is the correction term and At is the actual value of the previous period.

Add a comment
Know the answer?
Add Answer to:
Question 1 Part A The following table shows the best forecast for a time series representing...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

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
  • Complete PART (b) ONLY. Please use answer from Part (a). Please complete this using EXCEL; SHow...

    Complete PART (b) ONLY. Please use answer from Part (a). Please complete this using EXCEL; SHow the steps/ excel calculations. Month Actual Demand 1 62 2 65 3 67 4 68 5 71 6 73 7 76 8 78 9 78 10 80 11 84 12 85 part (a) MY answer to Part (a): Part (b) (b) Now calculate all the measures of forecasting accuracy listed below for the single exponential smoothing forecast completed in part (a) -i) MAPE (Mean...

  • Please help with questions 7 - 10. PART IV Planning and Controling Operations and Supply Chains...

    Please help with questions 7 - 10. PART IV Planning and Controling Operations and Supply Chains 290 period 1 was 250. Plot the results. Which model appears to work better? Why? 10. After graduating from college, you and your friends start selling birdhouses made from recycled plast has caught on, as shown by the following sales figures For problems 4 through 6, use the following time series data: The idea DEMAND MONTH January 2012 February March April May June 119...

  • The following table shows the actual demand observed over the last 4​ years

    The following table shows the actual demand observed over the last 4 years:                                                                                                                                       ...

  • The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 27...

    The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 27 2 29 3 33 4 41 5 44 6 43 7 44 8 46 9 47 10 41 a. Calculate the single exponential smoothing forecast for these data using an α of 0.30 and an initial forecast (F1) of 27. (Round your intermediate calculations and answers to 2 decimal places.) Month Exponential Smoothing 1 27 2 27 3 27.6 4 29.22 5 32.75 6...

  • Please solve for the standard deviation step by step. Calculating Forecast Error Measures The following table...

    Please solve for the standard deviation step by step. Calculating Forecast Error Measures The following table shows the actual sales of upholstered chairs for a furniture manufacturer and the forecasts made for each of the last 8 months. Calculate CFE, MSE, a, MAD, and MAPE for this product Month, Demand, D Forecast Error E Error, Squared, E Absolute Error, Absolute Percent Error, (END(100) 200 225 -25 625 25 12.5% 2 240 220 20 400 20 8.3 3 300 285 15...

  • The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 33...

    The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 33 2 29 3 32 4 33 5 35 6 32 7 35 8 42 9 44 10 45 a. Calculate the single exponential smoothing forecast for these data using an α of 0.10 and an initial forecast (F1) of 33. (Round your answers to 2 decimal places.) b. Calculate the exponential smoothing with trend forecast for these data using an α of 0.10, a...

  • The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 34...

    The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 34 2 37 3 38 4 37 5 40 6 37 7 42 8 44 9 41 10 42 a. Calculate the single exponential smoothing forecast for these data using an ? of 0.20 and an initial forecast (F1) of 34. (Round your intermediate calculations and answers to 2 decimal places.) Month Exponential Smoothing 1 2 3 4 5 6 7 8 9 10 b....

  • The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 36...

    The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 36 2 38 3 40 4 41 5 43 6 42 7 43 8 45 9 46 10 48 a. Calculate the single exponential smoothing forecast for these data using an α of 0.30 and an initial forecast (F1) of 36. (Round your intermediate calculations and answers to 2 decimal places.) b. Calculate the exponential smoothing with trend forecast for these data using an α...

  • Examples 1,2,3 1. Beyond Tea Inc. wants to forecast sales of its menthol green tea. The...

    Examples 1,2,3 1. Beyond Tea Inc. wants to forecast sales of its menthol green tea. The company is considering either using a simple mean or a three-period moving average to forecast monthly sales. Given sales data for the past 10 months use both forecasting methods to forecast periods 7 to 10 and then evaluate each. Which method should they use? Use the selected method to make a forecast for month 11. (Show all calculations .... Please read Examples1, 2, 3...

  • Masters Level work....all work must be shown. FORECASTING Forecasting ASSIgnment 1. Given the following data, use...

    Masters Level work....all work must be shown. FORECASTING Forecasting ASSIgnment 1. Given the following data, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note, the first quarter is January, February, and March; the second quarter is April, May, and June; the third quarter is July, August, September, and the 4° quarter is October, November, and December ul ct 50 This year 235 245 255 295 305 295 Answer (Please show your work...

ADVERTISEMENT
Free Homework Help 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.
ADVERTISEMENT
ADVERTISEMENT