Purchase Solution

Development of Appropriate Forecasting Model

Not what you're looking for?

Ask Custom Question

Please read the case study attached. I am not sure how to develop a model? I can put the info into an excel sheet, but need help getting started.

1. Develop an appropriate forecast model for the bookstore manager to use to forecast computer demand for tne next fall semester. Show work for the following forecast techniques:
a. Moving average ( n=3)
b. Moving average (n=5)
c. Linear trend line
d. Exponential smoothing (alpha = .3)
e. Exponential smoothing (alpha = .5)
f. Exponential smoothing (alpha = .3, beta = .4)
g. Exponential smoothing (alpha = .4 , beta = .5)

Attachments
Purchase this Solution
Solution Summary

This posting provides solution to forecasting problems on computer demand using moving average, linear trend line and exponential smoothing techniques.

Purchase this Solution
Free BrainMass Quizzes
Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

View More Free Quizzes
Related BrainMass Solutions

  • Forecasting Model Approaches

    214448 Forecasting Model Approaches In selecting an appropriate forecasting model, the following approaches are suggested: a. perform a residual analysis. b. measure the size of the forecasting error. c. use the principle of parsimony.

  • Questions on Statistical Forecasting

    Hence p comparisons are lost in the development of the auto-regressive model. Now p=5 because of a fifth-order auto-regressive model. Hence 5 comparisons are lost in the development of the auto-regressive model. b.

  • Two Seasonal Data Models

    It is more appropriate to use additive model while forecasting seasonal data because the additive model will always display steady seasonal fluctuations with no regards to the overall level of the series (ZHU, & ZHU YI 2010).

  • Utilizing Statistics in Demand Forcasts

    Identify the forecasting method you would use In general practice, for a time-series data forecasting, ARIMA (Auto-Regressive Integrated Moving Average) model is used.

  • Projection model for Moss Fertilizers

    Is the forecasting method used appropriate for the data? Why or why not? (b) Use any computer program to develop a trend equation. Find the projected sales in years 12 and 13. Is the forecasting method used appropriate for the data?

  • Regression Models

    d) Which model is the most appropriate, using adjusted r2 values and first, second, and percentage differences. [3] Refer to the data set given in [1].

  • Demand Management and Forecasting in Business

    Analyze the various techniques of forecasting and explain which would be appropriate or inappropriate to (a) a manufacturing enterprise, and (b) a service provider.

  • Forecasting with autocorrelations and partial autocorrelations

    The selection of an appropriate model for analyzing a particular problem depends on many factors, such as, number of series to be forecasted, required accuracy of forecasts, modeling costs, ease of use of the models, ease of interpretation of the forecasts

  • Linear Programming, Queueing Analysis, Simulations, Decision Analysis and Forecasting

    F) Give an example of a situation when using quantitative forecasting would be appropriate? Please see the attached file for the complete solution. Thanks for using BrainMass.

  • Appropriate quantitative forecasting methods

    The solution explains when quantitative forecasting is appropriate.

View More Related Solutions