Page 180 #5-35 Using this data, do the following (do not answer book questions, use my folliowing questions) 1) compute Centered Moving Average (because has a trend.... note: must know 2) Compute the seasonal ratios; 3) Compute seasonal indices for each quarter, and 4) write a paragraph analyzing the results in referring back to the context of the story in the textbook ie what are your suggestions for the state comptroller of Texas. Then::: 5) assuming the sales estimates for Year 5 are $370 for Qtr 1, $395 for Qtr 2, $427 for Qtr 3, and $600 for Qtr 4 (in &millions) for the respective quarters before adjusting for seasonality, compute a seasonalized or adjusted sales forecast for these quarters.

5-35 A major source of revenue in Texas is a state sales tax on certain types of goods and services. Data are compiled, and the state comptroller uses them to project future revenues for the state budget. One particular category of goods is classified as Retail Trade. Four years of quarterly data (in $1,000,000s) for one particular area of southeast Texas follow: QUARTER YEAR YEAR YEAR YEAR 1 2 3 4 1 218 225 234 250 N 247 254 265 283 3 243 255 264 289 4 292 299 327 356