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. (1)

Enrollment in an online MBA program is rapidly
Enrollment in an online MBA program is rapidly increasing. The figures for the past six terms were: 350, 400, 480, 600, 640, and 700. (1) Using a forecast for the first term of 300 and a demand smoothing parameter of 0.2, forecast enrollment for the 7" term with the (single) exponential smoothing (ES) method (11 ) 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"term with the double exponential smoothing (DES) method (iii) Draw graphs of Actual Enrollments, the ES 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 ES, DES, and Graphs on separate tabs

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!