Get a unique, high-quality and non-plagiarized paper from us today at the most affordable price
Email us : premieredtutorials@gmail.com

BUS520-CASE4

 

RISK: EXPONENTIAL SMOOTHING FORECASTING AND VALUE OF INFORMATION
Assignment Overview
Scenario: You are still a consultant for the Excellent Consulting Group. You have completed the first assignment, developing and testing a forecasting method based on linear regression (Case 3). However, your consulting manager at ECG wants to go the next step and investigate another forecasting method. It is important to do a thorough job for the client, and you have the expertise to analyze different forecasting methods. You have decided to look at the sales data for client’s lottery app as a single data set and use a time series analysis, namely SES, single exponential smoothing.

Case Assignment
Using Excel, use the forecasted sales from Case 3 to compute the MAPE, by doing the following:

Calculate the MAPE for the first 12 months (assume the forecast for Month 1 – or January – is equal to January’s actual sales). Use 0.15 and 0.90 alphas.
Using the forecasted sales for Feb – April (taken from the Case 3 Linear Regression exercise), compute the MAPE by comparing actual sales for each month, or Y(t) to forecasted sales, or F(t). Compare this 3-month MAPE to the two MAPE values you calculated in your SES analysis above. Use the following table:
Month
Sales, Y(t)
Sales F(t)
Y(t) – F(t)
PE
APE
February
?
?
?
?
?
March
?
?
?
?
?
April
?
?
?
?
?

?
?
?

ME
MPE
MAPE

Then write a report to your boss that briefly describes the results that you obtained. Using MAPE values, make a recommendation on which method appears to be more accurate — SES or Linear Regression.

Data: Use the data that you previously have generated from your analyses in Case 3.
Assignment Expectations
Analysis

Accurate and complete SES analysis in Excel.
Written Report

Length requirements = 4–5 pages minimum (not including Cover and Reference pages)
Provide a brief introduction/ background of the problem.
Complete and accurate Excel analysis.
Written analysis that supports Excel analysis, and provides thorough discussion of assumptions, rationale, and logic used.
Complete, meaningful, and accurate recommendation(s).

 
Place your order now for a similar paper and have exceptional work written by our team of experts to guarantee you A Results

Why Choose US

6+ years experience on custom writing
80% Return Client
Urgent 2 Hrs Delivery
Your Privacy Guaranteed
Unlimited Free Revisions

How to Place an Order 

Send the assignment details such as the instructions, due date/deadline, number of pages and college level to the customer support agent online on live chat,  fill in the assignment details at place an order or send the information to our email address premieredtutorials@gmail.com and a customer support agent will respond to you immediately. 

Once you place your order, we choose for you the best and competent writer for your assignment based on each writer’s competence in handling a subject. 

When the homework is completed, we have a quality assurance team that proofreads the assignment to ensure it meets the required rubric instructions from your professor.

After thorough review of your assignment, we send the paper to the client. In case you need any changes at this point, you can let us know so that we can handle it for you at no extra charge. 

Homework Help Website

Why we should write your Paper 

  1. Money Return guarantee
  2. 0% Plagiarism Rate
  3. Guaranteed Privacy
  4. Written from scratch by highly qualified writers 
  5. Communication at Any Time (24/7)
  6. Flexible Pricing and Great Discount Programs
  7. Timely Deliveries
  8. Free Amendments
Looking for a similar assignment and in urgent need for help? Place your order and have excellent work written by our team of professionals to ensure you acquire the best grades.

  We are here to assist you.

 

Statistics about Us

130 New Projects
235 Projects in Progress
315 Inquiries
420 Repeat clients

© 2021 Premiered Tutorials
All rights reserved. We provide online custom written papers, such as term papers, research papers, thesis papers, essays, dissertations and other custom writing services.

All papers inclusive of research material are strictly intended to be used for research and study purposes only. Premiered Tutorials does not support or condone plagiarism in any form. These custom papers should be used with proper reference.

Place an Order
error: Content is protected !!