Purchase Solution

Forecasting and Moving Averages

Not what you're looking for?

Ask Custom Question

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.