Question

In: Math

Forecast the price index for Q3 2018 using a​ two-period simple moving average. (Round to two...

  1. Forecast the price index for Q3 2018 using a​ two-period simple moving average.

(Round to two decimal places)

  1. Calculate the MAD for the forecast in part a

(Round to two decimal places)

  1. Forecast the price index for Q3 2017 using a​ three-period simple moving average.

(Round to two decimal places)

  1. Calculate the MAD for the forecast in part c.

(Round to two decimal places)

Quarter Price
Q1 2017 186.4
Q2 2017 190.5
Q3 2017 196.2
Q4 2017 196.2
Q1 2018 198.6
Q2 2018 202.7

Solutions

Expert Solution

  1. Forecast the price index for Q3 2018 using a​ two-period simple moving average.

Answer: 200.65

  1. Calculate the MAD for the forecast in part a

Answer: 52.80

  1. Forecast the price index for Q3 2018 using a​ three-period simple moving average.

Answer: 199.17

  1. Calculate the MAD for the forecast in part c.

Answer: 53.58

Formula Ref:

milcah answered 2 years ago
Next > < Previous

Related Solutions

1) Using a 5 period simple moving average, the forecast for period 13 will be:
Question 1 contains the actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods. Round all numerical answers to two...
develop a? three-period moving average forecast for april 2019
A geneticist discovers a new mutation in Drosophila melanogaster that causes the flies to shake and quiver. She calls this mutation spastic (sps) and determines that it is due to an autosomal recessive gene. She wants to determine if the gene encoding spastic is linked to the recessive gene for vestigial wings (vg). She crosses a fly homozygous for spastic and vestigial traits with a fly homozygous for the wild-type traits and then uses the resulting F1 females in a...
Suppose that you are using the? four-period weighted moving average forecasting method to forecast sales and...
Suppose that you are using the? four-period weighted moving average forecasting method to forecast sales and you know that sales will be decreasing every period for the foreseeable future. What of the following would be the best set of weights to use? (listed in order from the most recent period to four periods? ago, respectively)? A.0.00, 0.00,? 0.00, 1.00 B.?0.25, 0.25,? 0.25, 0.25 C.?1.00, 0.00,? 0.00, 0.00 D.0.10, 0.20,? 0.30, 0.40 E. ?0.40, 0.30,? 0.20, 0.10
Suppose that you are using the? four-period weighted moving average forecasting method to forecast sales and...
Suppose that you are using the? four-period weighted moving average forecasting method to forecast sales and you know that sales will be decreasing every period for the foreseeable future. What of the following would be the best set of weights to use? (listed in order from the most recent period to four periods? ago, respectively)? A.0.00, 0.00,? 0.00, 1.00 B.?0.25, 0.25,? 0.25, 0.25 C.?1.00, 0.00,? 0.00, 0.00 D.0.10, 0.20,? 0.30, 0.40 E. ?0.40, 0.30,? 0.20, 0.10
Calculating inflation using a simple price index
Calculating inflation using a simple price indexConsider a fictional price index, the College Student Price Index (CSPI), based on a typical college student’s annual purchases. Suppose the following table shows information on the market basket for the CSPI and the prices of each of the goods in 2017, 2018, and 2019.The cost of each item in the basket and the total cost of the basket are shown for 2017.Perform these same calculations for 2018 and 2019, and enter the results...
The price index from 2016 to 2018 is : 200, 210, 220. Derive a forecast for...
The price index from 2016 to 2018 is : 200, 210, 220. Derive a forecast for 2019 on the basis of adaptive expectations using 0.2, 0.3 and 0.5 as weights in 2016, 2017 and 2018 respectively. The optimal forecast for 2019 is 225 using all available information. What is the expected price index in 2019 based on rational expectations? The actual value in 2019 is 223. Based on this, Paul concluded that the expected value in (b) derived using rational...
Calculating inflation using a simple price index Consider a fictional price index, the College Student Price...
Calculating inflation using a simple price index Consider a fictional price index, the College Student Price Index (CSPI), based on a typical college student’s annual purchases. Suppose the following table shows information on the market basket for the CSPI and the prices of each of the goods in 2014, 2015, and 2016. The cost of each item in the basket and the total cost of the basket are shown for 2014. Perform these same calculations for 2015 and 2016, and...
1. Calculating inflation using a simple price index Consider a fictional price index, the College...
1. Calculating inflation using a simple price indexConsider a fictional price index, the College Student Price Index (CSPI), based on a typical college student’s annual purchases. Suppose the following table shows information on the market basket for the CSPI and the prices of each of the goods in 2014, 2015, and 2016.The cost of each item in the basket and the total cost of the basket are shown for 2014.Perform these same calculations for 2015 and 2016, and enter the...
1. Calculating inflation using a simple price index Consider a fictional price index, the College Student...
1. Calculating inflation using a simple price index Consider a fictional price index, the College Student Price Index (CSPI), based on a typical college student’s annual purchases. Suppose the following table shows information on the market basket for the CSPI and the prices of each of the goods in 2017, 2018, and 2019. The cost of each item in the basket and the total cost of the basket are shown for 2017. Perform these same calculations for 2018 and 2019,...
1. Calculating inflation using a simple price index Consider a fictional price index, the College Student...
Calculating inflation using a simple price indexConsider a fictional price index, the College Student Price Index (CSPI), based on a typical college student's annual purchases. Suppose the following table shows information on the market basket for the CSPI and the prices of each of the goods in 2017, 2018, and 2019.The cost of each item in the basket and the total cost of the basket are shown for 2017.Perform these same calculations for 2018 and 2019, and enter the results...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT