Question: 4 0 . Using the data in the table calculate the 3 - month simple moving average forecast for monthly income for next February. The

40. Using the data in the table calculate the 3-month simple moving average forecast for monthly income for next February. The approximate numerical value of the forecast (in units of $K, rounded to two [2] decimal places) is: a. $75.50K b. $75.83K c. $74.95K d. $75.41K e. $75.45K
Monthly income in thousands of dollars ($K) at the Acme Law Firm for the 13-month period from January this year to January next year is listed in the table below. (For parts 39 to 47, download the Excel file "Exam 2 time series data" in the "Exam 2 Excel forecasting file" link in the "Assessments" in the Navigation bar of the Bb course website. Save your completed Excel file containing your calculations for parts 39 to 47 for later uploading to Bb.)
\table[[Month,Income ($K)],[Jan,51.8],[Feb,55.5],[Mar,54.7],[Apr,57.1],[May,50.6],[Jun,68.2],[Jul,66.4],[Aug,59.3],[Sep,67.2],[Oct,69.8],[Nov,77.6],[Dec,74.4],[Jan,75.5]]
 40. Using the data in the table calculate the 3-month simple

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!