Question: A company records reported below indicate monthly sales data for XYZ Company. Use the below mentioned techniques to help the administration: Month Sales (units) October
- A company records reported below indicate monthly sales data for XYZ Company. Use the below mentioned techniques to help the administration:
| Month | Sales (units) |
| October | 9 |
| November | 11 |
| December | 13 |
| January | 13 |
| February | 14 |
| March | 14 |
| April | 15 |
| May | 16 |
| June | 18 |
| July | 20 |
- Compute and explain the 2-month moving average.
- Calculate exponential smoothing with smoothing constant 0.4 and forecast value 12 for the first period. Briefly explain.
- Use RMSE model and decide which technique (simple moving average or exponential smoothing) is better? Briefly explain.
- Plot the monthly data, moving averages and exponential smoothing estimates on a line graph. Briefly explain the pattern.
PLZZZZZ FULLY ANSWER THIS.
DON'T USE EXCEL.
BE MORE CLEAR, IN TOHER WORDS SHOW HOW EACH NUMBER CAME FROM. WRITE ALL FORMULAS NEEDED AND BE MORE CLEAR ABOUT THAT.
I WILL UPVOTE IF WHEN I GET THE ANSWER IN LESS THAN 7 HOURS, THAT'S A PROMISE.
THAT'S AN ASSIGNMENT THAT I HAVE TO SUBMIT SOON. SO PLZ WRITE EVERY SINGLE DETAIL, WITH EXPLANATION .
I REPEAT DONT USE EXCEL, OTHERWISE I WILL DOWNVOTE.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
