Can you forecast sales for the years 2010-2022? Pease show works through excel Year Annual Sales (Units
Fantastic news! We've Found the answer you've been seeking!
Question:
Can you forecast sales for the years 2010-2022? Pease show works through excel
| Year | Annual Sales (Units Sold) |
| 2010 | 3,000,000 |
| 2011 | 10,000,000 |
| 2012 | 25,000,000 |
| 2013 | 34,000,000 |
| 2014 | 39,000,000 |
| 2015 | 45,000,000 |
| 2016 | 51,000,000 |
| NLS Values | ||||||||||||||
| m | Year | t | b=p+q | a=q/p | 1-e(-bt) | 1+a*e-bt | F(t) | F(t)-F(t-1) | m*(F(t)-F(t-1)) | Actual Sales | MSE | |||
| p | 0 | |||||||||||||
| q | 2010 | 1 | 0.000 | #DIV/0! | 0 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||
| 2011 | 2 | 0.000 | #DIV/0! | 0 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |||||
| 2012 | 3 | 0.000 | #DIV/0! | 0 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |||||
| 2013 | 4 | 0.000 | #DIV/0! | 0 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |||||
| 2014 | 5 | 0.000 | #DIV/0! | 0 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |||||
| 2015 | 6 | 0.000 | #DIV/0! | 0 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |||||
| 2016 | 7 | 0.000 | #DIV/0! | 0 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |||||
| 2017 | 8 | 0.000 | #DIV/0! | 0 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |||||
| 2018 | 9 | 0.000 | #DIV/0! | 0 | #DIV/0! | Please | #DIV/0! | #DIV/0! | #DIV/0! | |||||
| 2019 | 10 | 0.000 | #DIV/0! | 0 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||||
| 2020 | 11 | 0.000 | #DIV/0! | 0 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||||
| 2021 | 12 | 0.000 | #DIV/0! | 0 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||||
| 2022 | 13 | 0.000 | #DIV/0! | 0 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||||
| SSE | #DIV/0! | |||||||||||||
| Description of What the sheet Does | MSE | #DIV/0! | ||||||||||||
| This excel sheet is set up to estimate p, q, m by minimizing SSE (NLS approach) | ||||||||||||||
| Average value of p acrossd 400 + product categories is reported to be 0.03, and for q is 0.38 | ||||||||||||||
| Please set constraint on p and q to be >= 0.00001 (don't set it to zero) to use it with GRG-Non-Linear | ||||||||||||||
Expert Answer:
Posted Date:
