Question: I only need part F. Please show your work, because I have no idea how to do these without being given the actual demand for

I only need part F. Please show your work,

I only need part F. Please show your work, because I have no idea how to do these without being given the actual demand for those years.

A community college is planning to use the exponential smoothing method to forecast freshman applications for the fall semester of each year. Past 5-year data on the actual number of applications received during 2011-2015 are given in Table. [30 points] Year 2011 2012 2013 2014 2015 Data on Freshman Application Number of Applications 4650 5200 6000 5700 6200 (a) Beginning with an initial forecast of 5000 for 2011 and a = 0.2, determine the forecasts for the years 2012, 2013, 2014, and 2015. (b) Calculate MAD and Bias for the 5-year period 2011-2015. (c) Calculate the tracking signals for the 5 years. (d) Determine the forecasts for the years 2016, 2017, and 2018. (e) Suppose the community college wants to try the following forecasting methods as well: 3-month moving average Averaging method Simple Linear Trend (f) Determine the forecasts for the years 2016, 2017, and 2018. Based on MAD with the following forecasting methods: 3-month moving average Averaging method Simple Linear Trend A community college is planning to use the exponential smoothing method to forecast freshman applications for the fall semester of each year. Past 5-year data on the actual number of applications received during 2011-2015 are given in Table. [30 points] Year 2011 2012 2013 2014 2015 Data on Freshman Application Number of Applications 4650 5200 6000 5700 6200 (a) Beginning with an initial forecast of 5000 for 2011 and a = 0.2, determine the forecasts for the years 2012, 2013, 2014, and 2015. (b) Calculate MAD and Bias for the 5-year period 2011-2015. (c) Calculate the tracking signals for the 5 years. (d) Determine the forecasts for the years 2016, 2017, and 2018. (e) Suppose the community college wants to try the following forecasting methods as well: 3-month moving average Averaging method Simple Linear Trend (f) Determine the forecasts for the years 2016, 2017, and 2018. Based on MAD with the following forecasting methods: 3-month moving average Averaging method Simple Linear Trend

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!