Forecasting using excel

Anonymous
timer Asked: May 1st, 2017

Question description

You'll find attached a questions based on forecasting using excel. Please follow directions in comments of cells as far as what tokens to use also, be sure to check column AA. Based in cost accounting

Our company creates seasonally adjusted revenue forecasts in Excel 2016 based on historical data using Exponenti seasonally adjusted upper- and lower-bounded forecast ranges, based on a confidence level of 95%. Below is our historical data for the past 5 years. Your task is to project the sales for the next 24 months (refer B68: Actual Date 3/30/2012 8/31/2012 9/30/2012 10/31/2012 11/30/2012 12/31/2012 1/31/2013 2/28/2013 3/31/2013 4/30/2013 5/31/2013 6/30/2013 7/31/2013 8/31/2013 9/30/2013 10/31/2013 11/30/2013 12/31/2013 1/31/2014 2/28/2014 3/31/2014 4/30/2014 5/31/2014 6/30/2014 7/31/2014 8/31/2014 9/30/2014 10/31/2014 11/30/2014 12/31/2014 1/31/2015 2/28/2015 Forecast Actual Revenue $188,092 $185,048 $184,673 $193,883 $192,436 $259,491 $219,448 $259,935 $156,250 $163,845 $185,043 $184,855 $213,973 $219,039 $209,709 $204,121 $209,646 $271,955 $265,135 $251,277 $222,354 $203,062 $221,305 $213,072 $219,359 $251,897 $264,753 $277,359 $278,921 $365,250 $312,767 $378,410 Forecast (Revenue) Lower Upper Confidence Confidence Bound Bound (Revenue) (Revenue) 3/31/2015 4/30/2015 5/31/2015 6/30/2015 7/31/2015 8/31/2015 9/30/2015 10/31/2015 11/30/2015 12/31/2015 1/31/2016 2/29/2016 3/31/2016 4/30/2016 5/31/2016 6/30/2016 7/31/2016 8/31/2016 9/30/2016 10/31/2016 11/30/2016 12/31/2016 1/31/2017 2/28/2017 3/31/2017 4/30/2017 5/31/2017 6/30/2017 7/31/2017 8/31/2017 9/30/2017 10/31/2017 11/30/2017 12/31/2017 1/31/2018 2/28/2018 3/31/2018 4/30/2018 5/31/2018 6/30/2018 7/31/2018 8/31/2018 9/30/2018 $260,004 $257,616 $270,294 $274,378 $259,782 $278,153 $264,772 $268,653 $288,692 $458,621 $402,441 $436,671 $306,461 $304,443 $286,289 $259,214 $332,547 $316,751 $325,153 $308,047 $351,217 $491,826 $476,960 $490,294 $311,018 $318,033 $356,158 $328,923 10/31/2018 11/30/2018 12/31/2018 1/31/2019 2/28/2019 3/31/2019 4/30/2019 5/31/2019 rical data using Exponential Smoothing. I would like to also chart the vel of 95%. ext 24 months (refer B68:B90) and prepare a chart of your results. Chart(s) - cha Name ChartType Location ChartWidth ChartHeight Series Name XValues Values PlotOrder Format.Line Format.Fill. Format.Line ChartTitle Caption Font.Name Font.Size Font.Bold ChartLegend Position Font.Name Font.Size Font.Bold Axis - Horizon AxisTitle AxisTickLab Axis - Vertica AxisTitle AxisTickLab ChartAreaCol PlotAreaColo Excel Instructions Chart(s) - charts have many properties, you will set only the following properties. Chart # 1 Name Chart 1 ChartType Location ChartWidth ChartHeight Series Name XValues Values PlotOrder Format.Line/Border.ForeColor Format.Fill.ForeColor Format.Line.Width ChartTitle Caption Font.Name Font.Size Font.Bold ChartLegend Position Font.Name Font.Size Font.Bold Axis - Horizontal AxisTitle AxisTickLabelsFormat Axis - Vertical AxisTitle AxisTickLabelsFormat ChartAreaColor PlotAreaColor Line $G$8 13 6 Series 1 Actual Revenue $B$8:$B$90 $C$8:$C$90 Not this semester Red 79, Green 129, Blue 189 N/A 2.25 Revenue Forecast Calibri 12 True Right of the chart Calibri 8 False No axis title m/d/yyyy;@ No axis title $#,##0 Red 183, Green 222, Blue 232 Red 219, Green 238, Blue 244 Series 2 Forecast (Revenue) Axis labels not set $D$8:$D$90 Not this semester Red 119, Green 147, Blue 60 N/A 2.25 Series 3 Lower Confidence Bound (Revenue) Axis labels not set $E$8:$E$90 Not this semester Red 119, Green 147, Blue 60 N/A 1 Series 4 Upper Confidence Bound (Revenue) Axis labels not set $F$8:$F$90 Not this semester Red 119, Green 147, Blue 60 N/A 1
Studypool has helped 1,244,100 students
flag Report DMCA
Similar Questions
Hot Questions
Related Tags
Study Guides

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors