Home / Expert Answers / Accounting / monthly-revenue-51000-s-table-month-2011-2012-2013-january-438-444-450-february-420-425-438-pa698

(Solved): Monthly Revenue ( 51000 s) \table[[Month,2011,2012,2013],[January,438,444,450],[February,420,425,438 ...



Monthly Revenue ( 51000 s) \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.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: \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 ?



We have an Answer from Expert

View Expert Answer

Expert Answer


We have an Answer from Expert

Buy This Answer $5

Place Order

We Provide Services Across The Globe