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 . (i) Using

 Enrollment in an online MBA program is rapidly increasing. The figures

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 7 th term 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 7 it term 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

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!