Chapter 4 Homework Solutions (Excel)

Chapter 4 Homework Solutions (Excel) - Problem 4-2 YEAR...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Problem 4-2 YEAR 1 2 3 4 5 6 7 8 9 10 11 DEMAND 7 9 5 9 13 8 12 13 9 11 7 part a No noticeable trends, cycles, or variations in the data. part b 3- year Moving Average Equation: (4-1) from Text Sum of demand for previous 3 periods/3 Example: Year 4 = (7+9+5)/3 = 7 YEAR 1 2 3 4 5 6 7 8 9 10 11 12 7 7.6666667 9 10 11 11 11.333333 11 9 part c 3- Year Weighted Moving Average Equation: (4-2) from Text, page 110 YEAR 1 2 3 4 5 6 7 8 9 10 11 12 DEMAND 7 9 5 9 13 8 12 13 9 11 7 6.4 7.8 11 9.6 10.9 12.2 10.5 10.6 8.4 DEMAND - Moving Average DEMAND - Weighted Moving Average 1 2 3 4 5 6 7 8 9 10 11 0 5 10 15 20 DEMAND vs. TIME DEMAND DEMAND - Moving Averag DEMAND - Weighted Moving Average YEAR DEMAND
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Problem 4-3 YEAR 1 7 6 2 9 6.4 3 5 7.44 4 9 6.46 5 13 7.48 6 8 9.69 7 12 9.01 8 13 10.21 9 9 11.32 10 11 10.39 11 7 10.64 Equation (4-4) from text Smoothing Constant: 0.4 Forecast for year 1: 6 ACTUAL DEMAND Exponentially Smoothed Forecast 1 2 3 4 5 6 7 8 9 10 11 0 2 4 6 8 10 12 14 Demand vs. Time ACTUAL DEMAND Exponentially Smoothed Forecast
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/06/2011 for the course ECON 101 taught by Professor Smith during the Spring '11 term at University of Arkansas – Fort Smith.

Page1 / 6

Chapter 4 Homework Solutions (Excel) - Problem 4-2 YEAR...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online