The chairperson of the department of management at State University wants to forecast the number of students who will enroll in production and operatiosn management (POM) next semester, in order to determine how many sections to schedule. The cahir has accumulated the following enrollment data for teh past eight semesters:
Semester Students enrolled in POM
a. Compute a three-semester moving average forecast for semesters 4 through9
b. Compute the exponentially smoothed forecast (a=.20) for the enrollment data.
c. Compare the two forecasts by using MAD and indicate the more accurate of the two
COULD YOU PLEASE SHOW WORK IN EXCEL...THANK YOU hide problem© BrainMass Inc. brainmass.com September 19, 2018, 3:47 am ad1c9bdddf - https://brainmass.com/math/optimization/forecasting-moving-averages-251145
The solution contains the determination forecast value using moving average and exponential smoothing techniques.