Solution HW Due day is December pm Forecasting Problem Problem Taylor text p Please show manually

Solution HW Due day is December pm Forecasting Problem Problem Taylor text

is December pm Forecasting Problem Problem Taylor text p Please show manually calculation and Excel calculation

Solution HW Due day is December pm Forecasting Problem Problem

Taylor text p Please show manually calculation and Excel calculation

Solution HW Due day is December pm Forecasting

Solution HW Due day

Category: | General |

Words: | 1050 |

Amount: | $12 |

Writer: |

Paper instructions

1
HW#5
Due day is December 1, 2014 11 pm
Forecasting
Problem 1
Problem #5, Taylor text, p.728
Please show manually calculation and Excel calculation. Send Excel and word files with solution.
The chairperson of the department of management at State University wants to forecast the
number of students who will enroll in production and operations management (POM) next
semester, in order to determine how many sections to schedule. The chair has accumulated the
following enrollment data for the 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 through 9.
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.
Decision Analysis
Problem 2
The following payoff table shows profit for a decision analysis problem with two decision
alternatives and three states of nature.
Decision
Alternative
State of Nature (S1, S2, S3)
S1 S2 S3
d1 250 100 25
d2 100 100 75
2
a. Construct a decision tree for this problem.
b. If the decision maker known nothing about the probabilities of the three states of nature,
what is the recommended decision using the 1)optimistic, 2) conservative, and 3)
minimax regret approaches?
Please show your solution with details.
c. Suppose that the probabilities that S1, S2, and S3 will occur are 0.5, 0.4, and 0.1,
respectively. What option should we choose using the expected value approach? Please
show your solution with details.1
HW#5
Due day is December 1, 2014 11 pm
Forecasting
Problem 1
Problem #5, Taylor text, p.728
Please show manually calculation and Excel calculation. Send Excel and word files with
solution.
The chairperson of the department of management at State University wants to forecast the
number of students who will enroll in production and operations management (POM) next
semester, in order to determine how many sections to schedule. The chair has accumulated the
following enrollment data for the 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 through 9.

# Answer

Get Essay Answer

1,200,000+ Questions

Satisfaction guaranteed