Forecasting and Moving Averages
Not what you're looking for?
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
1 400
2 450
3 350
4 420
5 500
6 575
7 490
8 650
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
Purchase this Solution
Solution Summary
The solution contains the determination forecast value using moving average and exponential smoothing techniques.
Purchase this Solution
Free BrainMass Quizzes
Solving quadratic inequalities
This quiz test you on how well you are familiar with solving quadratic inequalities.
Geometry - Real Life Application Problems
Understanding of how geometry applies to in real-world contexts
Exponential Expressions
In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.
Probability Quiz
Some questions on probability
Know Your Linear Equations
Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.