HW5 - Brittany Braud Management 368 Homework 5 June 13,...

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

View Full Document Right Arrow Icon
Brittany Braud Management 368 Homework 5 June 13, 2011 1. Chapter 8, Problem #4: The following data are monthly sales of jeans at a local department store. The buyer would like to forecast sales of jeans for the next month, July. Month Sales January 45 February 30 March 40 April 50 May 55 June 47 a) Forecast sales of jeans for March through June using the Naïve method, a two-period moving average, and exponential smoothing with an σ = 0.2 Answer: Month Sales Naïve Absolute Error January 45 February 30 March 40 30 10 April 50 40 10 May 55 50 5 June 47 55 -8 MAD = Σ | actual – forecast | = 8.25 n Month Sales 2-period moving average Absolute Error January 45 February 30 March 40 (45+30)/2 = 37.5 2.5 April 50 (30+40)/2 = 35 15 May 55 (40+50)/2 = 45 0 June 47 (50+55)/2 = 52.5 5.5 MAD = Σ | actual – forecast | = 8.25 n Month Sales Exponential Smoothing σ = 0.2 Absolute Error January 45 February 30 March 40 (0.2)(30)+(0.8)(30) = 30 10 April 50 (0.2)(40)+(0.8)(30) = 32 18
Background image of page 1

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

View Full DocumentRight Arrow Icon
May 55 (0.2)(50)+(0.8)(32) =
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.

Page1 / 3

HW5 - Brittany Braud Management 368 Homework 5 June 13,...

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