Purchase Solution

Compariosn of forecasting methods

Not what you're looking for?

Ask Custom Question

(See attached file for full problem description)

Your manager is trying to determine what forecasting method to use. Based upon the following historical data, calculate the following forecast and specify what procedure you would utilize.

(see chart in attached file)

a. Calculate the simple three-month moving average for periods 10-12.
b. Calculate the weighted three-month average using weights of 0.50, 0.30, and 0.20 for periods 10-12.
c. Calculate the single exponential smoothing forecast for period 10-12 using an initial forecast (F1) of 61 and Alpha of 0.30.
d. Calculate the exponential smoothing with trend component forecast for periods 10-12 using an initial trend forcast (T9) of 1.8, and exponential smoothing forecast (F9) of 60, and alpha of 0.30 and beta of 0.30.

Attachments
Purchase this Solution
Solution Summary

This posting contais a problem on forecasting which compares various forecasting models and choses the best one among them.

Purchase this Solution
Free BrainMass Quizzes
Learning Lean

This quiz will help you understand the basic concepts of Lean.

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

View More Free Quizzes
Related BrainMass Solutions

  • Quantitative Forecasting Explained

    It also defines in detail the types of quantitative forecasting including an explanation of procedural methods used and assumptions made.

  • discussion on methodology of forecasting

    The discussion tells you what forecasting is and gives a link to a tree of forecasting methods and discusses the four most common forecasting methods.

  • Forecasting Methods used by Modern Corporations

    460873 Forecasting Methods used by Modern Corporations Discuss forecasting methods used in a modern corporation. Include qualitative and quantitative methods commonly used. Forecasting utilizes past data to predict the future.

  • Cyclical VS Seasonal Methods in Forecasting

    547171 Cyclical vs Seasonal Methods in Forecasting Cyclical and seasonal methods in forecasting: Which is more complicated to apply - cyclical or seasonal and why?

  • Forecasting Methodologies

    In project management forecasting refers to the forecasting of discrete events, forecasting of a large group of activities, or the technology used for forecasting. The methodologies include qualitative and quantitative.

  • forecasting

    The average error of two simple average forecasting methods is equal to the average error of the combined forecast.

  • Appropriate quantitative forecasting methods

    TIME SERIES FORECASTING METHODS Time series forecasting methods are based on analysis of historical data (time series: a set of observations measured at successive times or over successive periods).

  • Applications of qualitative sales forecasting methods

    Applications of qualitative sales forecasting methods

  • EBBD forecast

    The results of the different forecasting methods can be compared against one another to determine if there are any methods that produce outlying results.

  • Two Forecasting Approaches

    The two approached to forecasting are qualitative methods and quantitative methods. Quantitative methods are most frequently used when existing data is available surrounding sales of a product or service and that data can be measured.

View More Related Solutions