Question: Heading Title You have just started your internship with the Bellevue University. Bellevue accepts new students into its program year-round on a tri-semester schedule (Fall,

Heading Title You have just started your

Heading Title You have just started your internship with the Bellevue University. Bellevue accepts new students into its program year-round on a tri-semester schedule (Fall, Spring, and Summer). Forecasting enrollments helps the University ensure it has proper resources to accommodate the student body. You have been given this task by your immediate supervisor, Mr. Tom Jones to improve Bellevue's forecasting method. Bellevue currently is using exponential smoothing method with a =0.3 to forecast the future enrollments. Mr. Jones asked you to come up with a different forecasting model and recommend the best model to the University for use. He has provided the following data (see below). The data shows the number of students who enrolled each semester. The deadline for the project is 2/23/2022, you must submit it on your course Blackboard. With this in mind, you need to provide a written report which includes appropriate graphs, Excel worksheets for two models, your justification for your choice of models and the selection of the better model with the forecast of the next 3 periods (Summer, Fall, and Spring). Year Semester Students 2011 Fall 207 2012 Spring 50 2012 Summer 29 2012 Fall 307 2011 Spring 169 2011 Summer 77 2011 Fall 390 2019 Spring 215 2019 Summer 158 2019 Fall 474 2020 Spring 281 2020 Summer 199 2020 Fall 575 2021 Spring 305 2021 Summer 189 2021 Fall 641 2022 Spring 297 2022 Summer 2022 Fall 2023 Spring BE English (United States)

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!