Use Excel to answer forecasting questions
Not what you're looking for?
Please see the attachment for 2 questions I need help with.
Problem
Please use the following data in MS Excel to answer the below questions (no need to send Excel file).
Year Product X Share(%)
1 6.5
2 5.6
3 5.3
4 5.3
5 5.3
6 6.2
7 8.3
a) What is the forecast for the 8th year based on a exponential smoothing with alpha = 0.85 (use 6.0 as the first year's forecast)? ________
b) What is the forecast for the 8th year based on a exponential smoothing with alpha = 0.6 (use 6.0 as the first year's forecast)? ________
c) What is the forecast for the 8th year using regression? ________
d) What is the value of MAPE for exponential smoothing method from (other question: alpha = 0.85)? ________
e) What is the value of MAPE for regression? ________
f) Based on MAPE, which method is better?
(a) Exponential Smoothing (from 3a)
(b) Regression
Problem
Please use the following data in MS Excel to answer the below questions (no need to send Excel file).
Month Competitor's
Share of Voice (%)
1 5.4
2 5.8
3 5.3
4 5.7
5 5.3
6 5.0
7 6.4
a) What is the forecast for the 8th month based on a naïve approach? ________
b) What is the forecast for the 8th month based on 4-month simple moving average? ________
c) What is the forecast for the 8th month based on 3-month weighted moving average?
Weights are 0.5 (most recent), 0.35, and 0.15 (most distant): ________
Purchase this Solution
Solution Summary
The expert uses Excel to answer forecasting questions.
Education
- MBA, Indian Institute of Finance
- Bsc, Madras University
Recent Feedback
- "I've posted a similar question for another course. It's post 657940, and it's a practice problem that I'd like to use for the final exam. Your help will be greatly appreciated. "
- "thank you!"
- "Thank you again Jayant. You are super fast. "
- "Thank you Jayant. You are appreciated. "
- "Again, thank you Jayant. You are wonderful. "
Purchase this Solution
Free BrainMass Quizzes
Motivation
This tests some key elements of major motivation theories.
Six Sigma for Process Improvement
A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.
Learning Lean
This quiz will help you understand the basic concepts of Lean.
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.
Situational Leadership
This quiz will help you better understand Situational Leadership and its theories.