Explore BrainMass

Explore BrainMass

    Use Excel to answer forecasting questions

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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): ________

    © BrainMass Inc. brainmass.com June 4, 2020, 4:17 am ad1c9bdddf
    https://brainmass.com/business/business-management/use-excel-answer-forecasting-questions-553607

    Attachments

    Solution Summary

    The expert uses Excel to answer forecasting questions.

    $2.19

    ADVERTISEMENT