Purchase Solution

Identifying the Best Projection Method

Not what you're looking for?

Ask Custom Question

1. Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. Develop a three-year moving average to forecast sales. Then estimate demand again with a weighted moving average in which sales in the most recent year are given a weight of 2 and sales in the other two years are each given the weight of 1. Which method do you think is best?

2. Develop a trend line for the demand of fertilizer in above problem.

3. Three different forecasts were developed for the demand for fertilizer. (3 year moving average, weighted moving average, and a trend line. Which would you use? Explain

Attachments
Purchase this Solution
Solution Summary

This solution gives a step-by-step instruction on how to apply forecasting models to project a given data. The based projection method was identified based on appropriate statistical measures.

Solution Preview

Trend Line Projection
Year Actual value X Forecast Error
1 4 0 3.5 0.5
2 6 1 3.542 2.458
3 4 2 3.584 0.416
4 5 3 3.626 1.374
5 ...

Purchase this Solution
Free BrainMass Quizzes
Production and cost theory

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

Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

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.

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

View More Free Quizzes
Related BrainMass Solutions

  • Forecasting Monthly Sales on a Month by Month Basis

    The result is the monthly forecast for each month for year 7, using both trend projection and the seasonal method.

  • Forecasting- moving average, exponential smoothing, trend

    Which value of alpha provides the best forecast? d. A trend line projection e. Which method of forecasting would you recommend to the manager? Why?

  • Three period and Five period Moving Forecast

    Note: We can compute and decide using the Mean Absolute Deviation (MAD). The projection yielding the smallest MAD is the best projection method.

  • Exponential smoothing, moving average, trend projection, MAD

    use trend projection method to forecast demand in years 1-6. d. with MAD as the criterion, which of the four forecasting methods is best Please see attached file Uses moving average, trend projection, exponential smoothing for making forecasts.

  • 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?

  • How to gauge validity of business forecasts

    Second, Smith must look at the forecasting models used. Judging the accuracy of the forecast using only one forecasting method will be misleading.

  • Supply Chain Management and Forecasting

    Quantitative Tools Trend projection: The time projection method uses time series of data, believing that the past data will be the same in the future to take the decision.

  • baselines and earned value analysis

    Tools like baselines and earned value analysis help us in comparing the actual progress with the planned progress and help in identifying any deviations, errors or mistakes from the planned scope, schedule and cost, thereby helping us to keep the project

  • Projecting your data using simple stat files

    Hence, in this computation, the exponential method is the best. This solution shows the various methods of projecting data and using statistical toll to decide the best projection method.

View More Related Solutions