Module 2: Linear Regression and Simple Exponential Smoothing (SES) Forecasting

 
Module 2: Linear Regression and Simple Exponential Smoothing (SES) Forecasting
Scenario: You are a consultant for the Diligent  Consulting Group (DCG). You have completed the first assignment,  developing and testing a forecasting method that uses Linear Regression  (LR) techniques (Module 2 Case). However, the consulting manager at DCG  wants to try a different forecasting method as well. Now you decide to  try Single Exponential Smoothing (SES) to forecast sales.
Using this Excel template: Data chart for BUS520 SLP 2, do the following:
Calculate the MAPE for Year 2 Linear Regression forecast (use the first spreadsheet tab labeled “Year 2 Forecast – MAPE”).
Calculate forecasted sales for Year 2 using SES (use the second spreadsheet tab labeled “SES – MAPE”). Use 0.15 and 0.90 alphas.
Compare the MAPE calculated for the LR forecast (#1 above) with the MAPEs calculated using SES.
Then write a report to your boss in which you discuss the results  obtained above. Using calculated MAPE values, make a recommendation  concerning which method appears to be more accurate for the Year 2 data:  SES or Linear Regression.
SLP Assignment Expectations
Analysis
Conduct accurate and complete SES analysis in Excel. You may also check the following link for your reference: https://support.office.com/en-US/article/data-analysis-7e71735c-c471-47e1-84ef-a8c23dc3098b
Written Report
·        Length requirements: 2  pages minimum (not including Cover and Reference pages). NOTE: You must submit 2  pages of written discussion and analysis. This means that you should avoid use of tables and charts as “space fillers.”
·        Provide a brief introduction to/background of the problem.
·        Complete a written analysis that supports your Excel  analysis, discussing the assumptions, rationale, and logic used to  complete your SES forecast.
·        Give complete, meaningful, and accurate recommendation(s)  relating to whether LR or SES is more accurate in predicting sales.
·        Write clearly, simply, and logically. Use double-spaced, black Verdana or Times Roman font in 12 pt. type size.
·        Have an introduction at the beginning to introduce the topics and use keywords as headings to organize the report.
·        Avoid redundancy and general statements such as “All organizations exist to make a profit.” Make every sentence count.
·        Paraphrase the facts using your own words and ideas,  employing quotes sparingly. Quotes, if absolutely necessary, should  rarely exceed five words.
·        Upload both your written report and Excel file to the SLP 2 Dropbox .

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with MyhomeworkGeeks
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Business and administrative studies
Excellent work ,always done early
Customer 452773, February 21st, 2023
Management
Love this writer!!! Great work
Customer 452597, April 5th, 2021
BUSINESSADMINECO535
excellent work
Customer 452773, October 6th, 2023
Business and administrative studies
excellent job!
Customer 452773, May 25th, 2023
Managerial Accounting & Legal Aspects of Business ACC/543
excellent work
Customer 452773, February 7th, 2024
Psychology
Thank you!
Customer 452545, February 6th, 2021
Business and administrative studies
excellent job! got an A, thank you
Customer 452773, May 24th, 2023
Human Resources Management (HRM)
excellent, great job
Customer 452773, June 19th, 2023
FIN571
excellent work
Customer 452773, March 1st, 2024
English 101
great summery in terms of the time given. it lacks a bit of clarity but otherwise perfect.
Customer 452747, June 9th, 2021
Criminal Justice
The paper was not accused of plagiarism and was written very well. I will let you know the grade once it is graded. Thank you
Customer 452671, April 26th, 2021
Business and administrative studies
excellent work
Customer 452773, March 12th, 2023
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat
Close

Sometimes it is hard to do all the work on your own

Let us help you get a good grade on your paper. Get professional help and free up your time for more important courses. Let us handle your;

  • Dissertations and Thesis
  • Essays
  • All Assignments

  • Research papers
  • Terms Papers
  • Online Classes
Live ChatWhatsApp