Question

1. Suppose the following data represents total revenues (in $ millions) for a mining   company. Year...

1. Suppose the following data represents total revenues (in $ millions) for a mining   company.

Year

Revenue

4-Year Moving

Average

4 Weighted Moving Average

Weights 4,3,2,1

   Exponential smoothing

         α = 0.6

2010

75

2011

81

2012

74

2013

79

2014

69

2015

92

2016

73

2017

85

2018

90

2019

73

2020

Forecast

        Use 2 decimal places,

  1. Compute the 4-year moving averages and forecast the revenue for 2020. ( 4 marks)
  1. Compute the 4-year weighted moving averages with weighs 4,3,2,1 and forecast the revenue for 2020. ( 4 marks)
  1. Compute the exponentially smoothed values for the data using a smoothing coefficient α = 0.60. Calculate the forecast for 2020. ( 5 marks)

Homework Answers

Know the answer?
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
Similar Questions
Consider the following time series data. Week 1 2 3 4 5 6 Value 19 12...
Consider the following time series data. Week 1 2 3 4 5 6 Value 19 12 16 11 18 13 (b) Develop the three-week moving average forecasts for this time series. (Round your answers to two decimal places.) Week Time Series Value Forecast 1 19 2 12 3 16 4 11 5 18 6 13 Compute MSE. (Round your answer to two decimal places.) MSE =   What is the forecast for week 7? (c) Use α = 0.2 to compute...
Consider the following time series data. Month 1 2 3 4 5 6 7 Value 22...
Consider the following time series data. Month 1 2 3 4 5 6 7 Value 22 11 18 10 17 21 13 A) What type of pattern exists in the data? The data appear to follow a seasonal pattern. The data appear to follow a trend pattern.     The data appear to follow a horizontal pattern. The data appear to follow a cyclical pattern. B) Develop the three-month moving average forecasts for this time series. Month Time Series Value Forecast 1...
Consider the following time series data: Month 1 2 3 4 5 6 7 Value 24...
Consider the following time series data: Month 1 2 3 4 5 6 7 Value 24 13 20 12 19 23 15 Develop a three-month moving average for this time series. Compute MSE and a forecast for month 8. If required, round your answers to two decimal places. Do not round intermediate calculation. MSE: The forecast for month 8: (c) Use α = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for...
1) Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply...
1) Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table . YEAR DEMAND FOR FERTILIZER (1,000S OF BAGS) 1 4 2 6 3 4 4 5 5 10 6 8 7 7 8 9 9 12 10 14 11 15 a) Develop a 3-year moving averages model to forecast sales. b) Develop a 3-year weighted moving averages model in which sales in the most recent year are given...
Consider the following time series data. Week 1 2 3 4 5 6 Value 18 13...
Consider the following time series data. Week 1 2 3 4 5 6 Value 18 13 16 11 17 14 A) What type of pattern exists in the data? (HORIZONTAL OR TREND) B) Develop a three-week moving average for this time series. Compute MSE and a forecast for week 7. If required, round your answers to two decimal places. Week Time Series Value Forecast 1 18 2 13 3 16 4 11 _______ 5 17 _______ 6 14 _______ MSE:...
Consider the following time series data: Month 1 2 3 4 5 6 7 Value 23...
Consider the following time series data: Month 1 2 3 4 5 6 7 Value 23 13 21 13 19 21 17 (a) Create a time series plot. What type of pattern exists in the data? - Select your answer -Positive trend patternHorizontal patternVertical patternNegative trend patternItem 2 (b) Develop a three-month moving average for this time series. Compute MSE and a forecast for month 8. If required, round your answers to two decimal places. Do not round intermediate calculation....
Consider the following time series data. Week 1 2 3 4 5 6 Value 18 13...
Consider the following time series data. Week 1 2 3 4 5 6 Value 18 13 15 13 15 15 (b) Develop a three-week moving average for this time series. Compute MSE and a forecast for week 7. If required, round your answers to two decimal places. (c) Use α = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for week 7. If required, round your answers to two decimal places. (d)...
Consider the following time series data: Month 1 2 3 4 5 6 7 Value 23...
Consider the following time series data: Month 1 2 3 4 5 6 7 Value 23 13 21 13 19 21 17 b) Develop a three-month moving average for this time series. Compute MSE and a forecast for month 8. If required, round your answers to two decimal places. Do not round intermediate calculation. MSE: The forecast for month 8: (c) Use α = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast...
Utility Taxes in Sunnytown, Florida Year Revenues ($) 1 842,387 2 1,665,430 3 1,863,296 4 2,063,103...
Utility Taxes in Sunnytown, Florida Year Revenues ($) 1 842,387 2 1,665,430 3 1,863,296 4 2,063,103 5 2,905,717 6 Use Exponential Smoothing, with α=0.8, to forecast the revenue in Year 6. Use your calculator to forecast.
The following data show the number of issues from Initial Public Offerings (IPOs) from 2006 to...
The following data show the number of issues from Initial Public Offerings (IPOs) from 2006 to 2019 released by the Security Data Company. Use these data to develop forecasts for the year. YEAR 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 NUMBER OF ISSUES 133 169 151 122 120 127 136 151 166 157 157 186 160 190 (a) Calculate three years moving average forecasts for the year 2020. Also evaluate the quality of...