Question: develop a multiplicative decomposition model for Luiss sales data. Use the model to forecast revenues for year 5 and comment on the validity of the
develop a multiplicative decomposition model for Luiss sales data. Use the model to forecast revenues for year 5 and comment on the validity of the model. Show steps in excel how to complete
| Year | Quarter | Sales ($M) |
| 1 | 1 | 42.9 |
| 2 | 48.5 | |
| 3 | 54.1 | |
| 4 | 74.1 | |
| 2 | 1 | 43.8 |
| 2 | 50.3 | |
| 3 | 57.8 | |
| 4 | 79.8 | |
| 3 | 1 | 49.0 |
| 2 | 54.2 | |
| 3 | 59.3 | |
| 4 | 83.3 | |
| 4 | 1 | 51.3 |
| 2 | 58.2 | |
| 3 | 62.9 | |
| 4 | 88.5 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
