Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The table above is from a monthly WES multiplicative spreadsheet model for Sales of a company selling stationery. The entire time series is from Nov-2010
The table above is from a monthly WES multiplicative spreadsheet model for Sales of a company selling stationery. The entire time series is from Nov-2010 to Nov 2014 although only the last 12 months of the spreadsheet (Dec-13 to Nov-14) are shown in the table above.
From the table, the forecast you would make for Dec-14 would be
Select one:
a. 3233.30
b. 3241.72
c. 3256.86
d. 3615.12 (Correct answer, how do I get this?)
e. Not able to be determined since the smoothing parameters are not provided
\begin{tabular}{|c|c|c|c|c|c|} \hline Dates & Sales & Level & Trend & Seasonal & Forecast \\ \hline Dec-13 & 3413.6 & 3554.62 & 7.14 & 1.11 & 3387.6 \\ \hline Jan-14 & 30226 & 3168. 77 & 16.54 & 0.99 & x \\ \hline Feb-14 & 2884.3 & 3103.42 & 1216 & 0.95 & 2088.95 \\ \hline Mar-14 & 3077.1 & 3106.01 & 10.25 & 1 & 3125.15 \\ \hline Apr-14 & 3104.8 & 3142.38 & 15.47 & 0.96 & 2979.89 \\ \hline May-14 & 3147.5 & 3148.19 & 13.54 & 1.01 & 3196.42 \\ \hline Jun14 & 30B24 & 3162.65 & 13.6 & 0.95 & 3EEB.89 \\ \hline Jul-14 & 3207.6 & 3191.54 & 16.78 & 0.99 & 3129.29 \\ \hline Aug-14 & 316E.6 & 3184.49 & 1201 & 1.02 & 328256 \\ \hline Sep-14 & 3148.9 & 3206.49 & 14.01 & 0.97 & 310.-47 \\ \hline Oct-14 & 3424.2 & 3228.32 & 15.58 & 1.05 & 3383.1 \\ \hline Now-14 & 3233.3 & 3241. & 15.14 & 1 & 3244.19 \\ \hline Dec-14 & & & & & \\ \hline \end{tabular}Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started