TABLE 5.13 Monthly Revenue ($1,000s) MONTH 2011 2012 2013 January 438 444 450 February 420 425...

Transcribed Image Text:

TABLE 5.13 Monthly Revenue ($1,000s) MONTH 2011 2012 2013 January 438 444 450 February 420 425 438 March 414 423 434 April 318 331 338 May 306 318 331 June 240 245 254 July 240 255 264 August 216 223 231 September 198 210 224 October 225 233 243 November 270 278 289 December 315 322 335 Page 183 Using Table 5.13 from the case study section, do the following 1) compute Centered Moving Average (because has a trend.... note: must know for exam) and seasonal ratios (note: each month is a season ie like a quarter, so 12 seasons); 2) Compute seasonal indices for each month, and 3) write a paragraph analyzing the results in the case story context (again, if you need more hand/paper practice to prepare for the exam, feel free to do as well). No Page #: Problem Given Below: Use the following data for gasoline sales per quarter for two years: Quarter Year 1 Year 2 1 150 156 2 140 148 3 185 201 4 160 174 (a) Compute the seasonal index for each quarter (using the overall average.... because there is no trend.... note: must know for exam). (b) Suppose we expect year 3 to have annual demand of 800. What is the forecast value for each quarter in year 3? (see example page 165- 166) TABLE 5.13 Monthly Revenue ($1,000s) MONTH 2011 2012 2013 January 438 444 450 February 420 425 438 March 414 423 434 April 318 331 338 May 306 318 331 June 240 245 254 July 240 255 264 August 216 223 231 September 198 210 224 October 225 233 243 November 270 278 289 December 315 322 335 Page 183 Using Table 5.13 from the case study section, do the following 1) compute Centered Moving Average (because has a trend.... note: must know for exam) and seasonal ratios (note: each month is a season ie like a quarter, so 12 seasons); 2) Compute seasonal indices for each month, and 3) write a paragraph analyzing the results in the case story context (again, if you need more hand/paper practice to prepare for the exam, feel free to do as well). No Page #: Problem Given Below: Use the following data for gasoline sales per quarter for two years: Quarter Year 1 Year 2 1 150 156 2 140 148 3 185 201 4 160 174 (a) Compute the seasonal index for each quarter (using the overall average.... because there is no trend.... note: must know for exam). (b) Suppose we expect year 3 to have annual demand of 800. What is the forecast value for each quarter in year 3? (see example page 165- 166)