Question: Enrollment in an online MBA program is rapidly increasing. The figures for the past six terms were: 350, 400, 480, 600, 640, and 700. (0)
Enrollment in an online MBA program is rapidly increasing. The figures for the past six terms were: 350 , 400,480,600,640, and 700 . (i) Using a forecast for the first term of 300 and a demand smoothing parameter of 0.2 , forecast enrollment for the 7interm with the (single) exponential smoothing (SES) method (ii) Using a forecast for the first term of 300 , an initial trend forecast of 50 , and smoothing parameters of 0.2 for the demand smoothing and 0.5 for the trend smoothing, forecast enrollment for the 7interm with the double exponential smoothing (DES) method (iii) Draw graphs of Actual Enrollments, the SES forecasts, and the DES forecasts for terms 1-6 Hint: Refer to the posted spreadsheet for a sample analysis. Submit a single Excel File with each part on a separate tab
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
