Expert Answer:IDS355 Illinois Naive Forecasts, Moving Average an

  

Solved by verified expert:All work must be shown on excel and must be solved using excel formulas. The data included in the file also must be in the excel document.
Use
a separate worksheet for each question set and label the worksheets. To rename
a worksheet, right-click the worksheet tab located at the bottom of your
current sheet, and use the rename option. Label the tabs as “Q Set 1”, “Q Set
2”, and “Q Set 3”, respectively. Be sure to label all results clearly.
assignment02_ids355_spring_2019.doc

Unformatted Attachment Preview

Don't use plagiarized sources. Get Your Custom Essay on
Expert Answer:IDS355 Illinois Naive Forecasts, Moving Average an
Just from $10/Page
Order Essay

IDS 355
Spring 2019
Assignment 2
Due Friday 3/08/2019
40 points
Instructions
Deadline
This assignment may be submitted anytime until Friday, March. 8th at 11:59pm. Because solutions will be
posted soon after the deadline, late submissions may not be accepted. If you need an extension for an
assignment, you must ask your TA in advance. In any event, we strongly recommend submitting your
assignment early, in case problems arise with the submission process.
Problem Guidelines
Because using spreadsheet software is a basic business skill, the assignments are intended to give you
practice in structuring problems as well as simply finding the answers. All problems must be solved
using Excel formulas to receive credit. If, for example, you solve a problem on paper and then copy
the results to Excel, you will receive no credit for that problem.
Submission Guidelines
All assignments are to be submitted using the Blackboard site for your lab section. Assignments should
be uploaded using the upload link in the Assignment folder, not the digital dropbox. It is important that all
homework files include the student’s NetID, so they can be easily identified and sorted. The file containing
homework assignment 2 submitted by the student with NetID rbaker2 should be named rbaker2hw2.
For this assignment, please submit one Excel file. Use a separate worksheet for each question set and
label the worksheets. To rename a worksheet, right-click the worksheet tab located at the bottom of your
current sheet, and use the rename option. Label the tabs as “Q Set 1”, “Q Set 2”, and “Q Set 3”,
respectively. Be sure to label all results clearly.
.
Questions
Burlington has tracked daily sales of coats for the three locations below:
Date
Chicago
Seasonal
Relatives for
Chicago Sales
04/01/18
05/01/18
06/01/18
07/01/18
08/01/18
09/01/18
10/01/18
11/01/18
12/01/18
13/01/18
14/01/18
15/01/18
16/01/18
17/01/18
18/01/18
19/01/18
20/01/18
21/01/18
22/01/18
23/01/18
24/01/18
25/01/18
26/01/18
27/01/18
28/01/18
29/01/18
30/01/18
152
195
225
276
475
755
653
187
240
207
311
373
732
975
170
213
240
311
456
798
1111
176
203
288
378
400
0.3
0.4
0.5
0.3
0.7
1.1
1.5
0.5
0.6
0.8
0.9
1.2
1.4
2.2
0.3
0.6
0.9
0.7
1
1.6
1.9
0.5
0.7
0.8
0.9
1.3
California
New
York
507
623
511
640
586
420
645
500
576
540
475
645
657
600
703
657
546
520
546
576
649
534
511
650
699
580
456
650
543
645
570
456
609
480
544
560
476
656
641
564
693
632
546
531
544
585
639
570
544
674
711
594
Question Set 1. Using only the Chicago sales data, generate the following sales forecasts:
1. Naïve forecasts (using the deseasonalized sales data) for January 5th through January 30th. You will
need to adjust the sales data to remove the seasonality effects. (6pts)
2. Four-day moving average forecasts for January 8th through January 30th. (3pts)
3. Twelve-day moving average forecasts for January 16th through January 30th. (3pts)
Note that, for example, you will not be able to make a four-day moving average forecast for January 7th
since four previous sales figures are required.
Question Set 2. Using only the California sales data:
1. Forecast sales for January 7th through January 30th using a three-day weighted moving average. (5pts)
The weights are:
Day
1 day previous
2 days previous
3 days previous
Weight
0.5000
0.3333
0.1667
2. Find the mean absolute deviation of the sales forecasts for January 7th through January 29th. You
should not include the forecast for January 30th since there is no corresponding sales figure for that date.
(3pts)
3. Find the mean squared error of the sales forecasts, again for January 7th through January 29th. (4pts)
4. Create a scatter scatter-chart for the three-day weighted moving average. Label your chart axes
properly. (2 pts)
Question Set 3. Using only the New York sales data:
1. Forecast sales for January 5th through January 30th using exponential smoothing with alpha set to 0.6.
Assume the sales forecast for January 4th was 456. (6pts)
2. Using your forecasts from Q3.1, find the mean absolute deviation of the sales forecasts for January 5th
through January 29th. Again, you should not include the forecast for January 30h since there is no
corresponding sales figure for that date. (4pts)
3. Using your forecasts from Q3.1, find the mean squared error of the sales forecasts for January 5th
through January 29th. (4pts)
Reminder: Check your work to make sure you have only included forecasts and accuracy
measures for the exact date ranges specified. Also, please copy these tables into your excel file
while solving.

Our essay writing service fulfills every request with the highest level of urgency.
attachment

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Order your essay today and save 30% with the discount code ESSAYSHELP