Monthly Revenue $(51000$ s$)$

$\backslash$table$[[$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]]$

Using this data, do the foilowing $1)$ compute Centered Mowing Average $($because has a trend...$)2)$ Compute the seasonal ratios; $3)$ Compute seasonal indices for mach cuarter and $4)$ write a paragraph analyzing the resuls in referring back to the conitext of the story in the textbook ie what are your suggestions for the state compliciler of Texas. Thene: $5)$ assuming the sales estimates for Year $5$ ale $$370$ for Qt $1,5395$ for Ot$,2\mathrm{.}5427$ for Qir $3,$ and $$600$ for Otr $4($in simillions$)$ for the respective quarters before adjusting for seasonality, compute a seasconalized or adjusted sales forecast for these quarters.

do the following $11$ compute Lentered Moving Averane $($because has a trend, note: must know for exam$)$ and seasonal ratios $($note each month is a smason ie likn a quatter, 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 foel tree to do as welli.

No Page A: Problem Gmen Below: Use the following data for oasoline salos per quarter for two years:

$\backslash$table$[[$Quarte$,$Yeat $1,$Year $2],[7,150,156],[2,140,148],[3,105,201],[$a$,160,174]]$

$($a$)$ Compute the seasonal indox 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 forecost value for osch quarter in year $3?$