Explore BrainMass
Share

Explore BrainMass

    Management Science: Forecasting

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

    6. The manager of the Petroco Service station wants to forecast the demand for unleaded gasoline next month so that the proper number of gallons can be ordered from the distributor. The owner has accumulated the following data on demand for unleaded gasoline from sales during the past 10 months:

    Month Gasoline Demand (gal)
    October 800
    November 725
    December 630
    January 500
    February 645
    March 690
    April 730
    May 810
    June 1,200
    July 980

    a. Compute an exponentially smoothed forecast, using on a value of .30.
    b. Compute an adjusted exponentially smoothed forecast (with a =.30 and B =.20).
    c. Compare the two forecast by using MAPD and indicate which seems to be more accurate.

    5. The chairperson of the department of Management of State University wants to forecast the number of students who will enroll in production and operations management (POM) next semester, in order to determine how many sections to schedule. The chair has accumulated the following enrollment data for the past eight semesters:

    Semester No. of students enrolled in POM
    1 400
    2 450
    3 350
    4 420
    5 500
    6 575
    7 490
    8 650

    a. Compute the three-semester moving average forecast for semesters 4 through 9.
    b. Compute the exponentially smoothed forecast (alpha = .20) for the enrollment data.
    c. Compare the two forecasts by using MAD and indicate the more accurate of the two.

    7. The victory plus mutual fund of growth stocks has had the following average monthly price for the past 10 months:

    Month Fund Price
    1 62.7
    2 63.9
    3 68.0
    4 66.4
    5 67.2
    6 65.8
    7 68.2
    8 69.3
    9 67.2
    10 70.1

    Compute the exponentially smoothed forecast with alpha=.40, the adjusted exponential smoothing forecast with alpha=.40 and beta=.30, and the linear trend line forecast. Compare the accuracy of the three forecasts, using cumulative error and MAD, and indicate which forecast appears to be most accurate.

    1. The saki motorcycle dealer in Minneapolis wants to make an accurate forecast of demand for the Saki Super TXII motorcycle during the next month. Because the manufacturer is in Japan, it is difficult to send motorcycles back or reorder if the proper number is not ordered a month ahead. From sales records, the dealer has accumulated the following data for the past year:

    Month Motorcyle Sales
    January 9
    February 7
    March 10
    April 8
    May 7
    June 12
    July 10
    August 11
    September 12
    October 10
    November 14
    December 16

    a) Compute a 3-month moving average forecast of demand for April through January of the next year
    b) Compute a 5-month moving average forecast for June through January
    c) Compare the two forecasts computed in (a) and (b) using MAD. Which one should the dealer use for January of the next year?

    © BrainMass Inc. brainmass.com October 10, 2019, 5:37 am ad1c9bdddf
    https://brainmass.com/math/optimization/management-science-forecasting-511468

    Solution Summary

    A step by step explanation of exponentially smoothed, adjusted exponentially smoothed, linear trend line, and moving average forecasts, using real examples. Also different forecasts are compared using Mean Absolute Deviation (MAD) and Mean Absolute Percentage Deviation (MAPD).

    $2.19