Question: Using the data provided create a Seasonally Adjusted Forecast for the upcoming year. You estimate that the annual profit for the upcoming year will be
Using the data provided create a Seasonally Adjusted Forecast for the upcoming year. You estimate that the annual profit for the upcoming year will be $210,000. Use your answers for the next four questions.
| Month | Year1 | Year2 | Year3 | Year4 |
| January | $11,325 | $15,137 | $10,729 | $11,708 |
| February | $14,615 | $14,808 | $13,261 | $14,196 |
| March | $13,545 | $16,287 | $13,906 | $16,893 |
| April | $15,495 | $16,108 | $18,491 | $17,326 |
| May | $18,452 | $20,366 | $17,106 | $18,130 |
| June | $22,324 | $19,582 | $21,437 | $17,545 |
| July | $23,383 | $22,291 | $20,716 | $23,018 |
| August | $17,460 | $21,953 | $20,125 | $18,786 |
| September | $18,375 | $19,696 | $19,829 | $19,263 |
| October | $15,844 | $13,625 | $14,975 | $16,117 |
| November | $13,715 | $15,805 | $14,503 | $14,435 |
| December | $14,821 | $11,095 | $11,246 | $15,934 |
What is the Seasonal Relative for January?
Format with 2 decimal places; enter a leading zero if needed, i.e .75 should be entered as 0.75.
What is the Seasonal Relative for July?
Format with 2 decimal places; enter a leading zero if needed, i.e .75 should be entered as 0.75.
What is the Seasonally Adjusted forecast for February?
Format as a whole number, no dollar sign.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
