Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please provide the formula to calculate the followings in excel 1) Nave Forecast % Change COGS 2) Smoothing Forecast % Change COGS 3) Regression Model
Please provide the formula to calculate the followings in excel
1) Nave Forecast % Change COGS
2) Smoothing Forecast % Change COGS
3) Regression Model Forecast
4) Nave Forecast Error
5) Smoothing Forecast Error
6) Regression Model Error
Year Revenue COGS 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2,759.0 3,753.0 4,649.0 5,937.0 8,671.0 11,936.0 15,262.0 19,747.0 22,956.0 25,296.0 28,365.0 32,187.0 36,835.0 39,788.0 44,282.0 51,122.0 60,420.0 58,437.0 62,484.0 69,943.0 73,723.0 77,849.0 86,833.0 93,580.0 91,154.0 96,571.0 110,360.0 125,843.0 143,015.0 176,251.0 467.0 633.0 763.0 877.0 1.188.0 2,170.0 2,460.0 2,814.0 3.002.0 3,455.0 5,699.0 6,059.0 6,596.0 6,031.0 7,650.0 10,693.0 11,598.0 12,155.0 12,395.0 15.577.0 17,530.0 20,385.0 27,078.0 33,038.0 32,780.0 34,261.0 38,353.0 42,910.0 46,078.0 54,876.0 % Change Revenue % Change COGS Lagged % Change Naive Forecast Smoothing Forecas Regression Model Naive Forecast Smoothing Forecast Regression COGS % Change COGS % Change COGS Forecast Error Error 49.70% 29.01% Model Error 43.27% 36.03% 35.55% 29.01% 23.87% 20.54% 35.55% 27.70% 14.94% 20.54% 46.05% 35.46% 14.94% 37.65% 82.66% 35.46% 27.87% 13.36% 82.66% 29.39% 14.39% 13.36% 16.25% 6.68% 14.39% 10.19% 15.09% 6.68% 12.13% 64.95% 15.09% 13.47% 6.32% 64.95% 14.44% 8.86% 6.32% 8.02% -8.57% 8.86% 11.29% 26.84% -8.57% 15.45% 39.78% 26.84% 18.19% 8.46% 39.78% -3.28% 4.80% 8.46% 6.93% 1.97% 4.80% 11.94% 25.67% 1.97% 5.40% 12.54% 25.67% 5.60% 16.29% 12.54% 11.54% 32.83% 16.29% 7.77% 22.01% 32.83% -2.59% -0.78% 22.01% 5.94% 4.52% -0.78% 14.28% 11.94% 4.52% 14.03% 11.88% 11.94% 13.65% 7.38% 11.88% 23.24% 19.09% 7.38% Year Revenue COGS 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2,759.0 3,753.0 4,649.0 5,937.0 8,671.0 11,936.0 15,262.0 19,747.0 22,956.0 25,296.0 28,365.0 32,187.0 36,835.0 39,788.0 44,282.0 51,122.0 60,420.0 58,437.0 62,484.0 69,943.0 73,723.0 77,849.0 86,833.0 93,580.0 91,154.0 96,571.0 110,360.0 125,843.0 143,015.0 176,251.0 467.0 633.0 763.0 877.0 1.188.0 2,170.0 2,460.0 2,814.0 3.002.0 3,455.0 5,699.0 6,059.0 6,596.0 6,031.0 7,650.0 10,693.0 11,598.0 12,155.0 12,395.0 15.577.0 17,530.0 20,385.0 27,078.0 33,038.0 32,780.0 34,261.0 38,353.0 42,910.0 46,078.0 54,876.0 % Change Revenue % Change COGS Lagged % Change Naive Forecast Smoothing Forecas Regression Model Naive Forecast Smoothing Forecast Regression COGS % Change COGS % Change COGS Forecast Error Error 49.70% 29.01% Model Error 43.27% 36.03% 35.55% 29.01% 23.87% 20.54% 35.55% 27.70% 14.94% 20.54% 46.05% 35.46% 14.94% 37.65% 82.66% 35.46% 27.87% 13.36% 82.66% 29.39% 14.39% 13.36% 16.25% 6.68% 14.39% 10.19% 15.09% 6.68% 12.13% 64.95% 15.09% 13.47% 6.32% 64.95% 14.44% 8.86% 6.32% 8.02% -8.57% 8.86% 11.29% 26.84% -8.57% 15.45% 39.78% 26.84% 18.19% 8.46% 39.78% -3.28% 4.80% 8.46% 6.93% 1.97% 4.80% 11.94% 25.67% 1.97% 5.40% 12.54% 25.67% 5.60% 16.29% 12.54% 11.54% 32.83% 16.29% 7.77% 22.01% 32.83% -2.59% -0.78% 22.01% 5.94% 4.52% -0.78% 14.28% 11.94% 4.52% 14.03% 11.88% 11.94% 13.65% 7.38% 11.88% 23.24% 19.09% 7.38%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