Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 | ||||||||||||||
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
Contemporary Logistics
Authors: Paul R. Murphy, Michael Knemeyer
11th edition
132953463, 2900132953466, 978-0132953467
