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.
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.
Unformatted Attachment Preview
Due Friday 3/08/2019
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.
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.
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.
Burlington has tracked daily sales of coats for the three locations below:
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:
1 day previous
2 days previous
3 days previous
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.
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
Our essay writing service fulfills every request with the highest level of urgency.
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.
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
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
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
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
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