Question Details

(Solved) Our company creates seasonally adjusted revenue forecasts in Excel 2016 based on historical data using Exponen adjusted upper- and lower-bounded...


Here is my last question in excel. Again, please just use my file and instruction within it and repost the solution. The cells with red indicator have comments with required tokens/ formulas.

Our company creates seasonally adjusted revenue forecasts in Excel 2016 based on historical data using Exponen
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
2/28/2012
7/31/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
3/31/2015
4/30/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
$260,004
$257,616
$270,294 Forecast
(Revenue) Lower
Upper
Confidence Confidence
Bound
Bound
(Revenue) (Revenue) 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
10/31/2018
11/30/2018
12/31/2018
1/31/2019
2/28/2019
3/31/2019 $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 4/30/2019 cal data using Exponential Smoothing. I would like to also chart the seasonally xt 24 months (refer B68:B90) and prepare a chart of your results. 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

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 05, 2019

PRICE: $15

Solution~000200167364.zip (25.37 KB)

Buy this answer for only: $15

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy from our tutoring website www.aceyourhomework.com (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 05, 2019

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN YOUR SET DEADLINE.

Order Now