5.Discuss the advantages and disadvantages of the moving average, weighted moving average, and regression analysis methods of forecasting sales. Which method(s) provides the best sales forecast for the next year

Respuesta :

eyukwe

Answer:

SIMPLE MOVING AVERAGE (ADVANTAGE)

It is easy to use and understand

It can be used to create a smooth line and a visible trend

SIMPLE MOVING AVERAGE (DISADVANTAGE)

It is not suitable for complex or ambiguous data

it is vulnerable to seasonal error

REGRESSION ANALYSIS (ADVANTAGE)

It is simple to use and easily applied in solving problems

REGRESSION ANALYSIS  (DISADVANTAGE)

It is limited to the linear relationship, as it is unable to provide accurate result for more than one variable

WEIGHTED SIMPLE MOVING AVERAGE (ADVANTAGE)

It uses exponential method to validate the effect of past data, which makes it a more accurate in measurements.

WEIGHTED SIMPLE MOVING AVERAGE (DISADVANTAGE)

It sometimes difficult to use the weighted simple moving average to project trends.

LINEAR MULTIPLE REGRESSION ANALYSIS (ADVANTAGE)

It shows relationship between independent and dependent variable.

It is easy to use for decision making and solving problems

LINEAR MULTIPLE REGRESSION ANALYSIS  (DISADVANTAGE)

It is time consuming and complex to use.

LINEAR MULTIPLE REGRESSION ANALYSIS is best for sales forecast, as it is easy to use for decision making and solving business problems

Explanation:

SIMPLE MOVING AVERAGE (ADVANTAGE)

It is easy to use and understand

It can be used to create a smooth line and a visible trend

SIMPLE MOVING AVERAGE (DISADVANTAGE)

It is not suitable for complex or ambiguous data

it is vulnerable to seasonal error

REGRESSION ANALYSIS (ADVANTAGE)

It is simple to use and easily applied in solving problems

REGRESSION ANALYSIS  (DISADVANTAGE)

It is limited to the linear relationship, as it is unable to provide accurate result for more than one variable

WEIGHTED SIMPLE MOVING AVERAGE (ADVANTAGE)

It uses exponential method to validate the effect of past data, which makes it a more accurate in measurements.

WEIGHTED SIMPLE MOVING AVERAGE (DISADVANTAGE)

It sometimes difficult to use the weighted simple moving average to project trends.

LINEAR MULTIPLE REGRESSION ANALYSIS (ADVANTAGE)

It shows relationship between independent and dependent variable.

It is easy to use for decision making and solving problems

LINEAR MULTIPLE REGRESSION ANALYSIS  (DISADVANTAGE)

It is time consuming and complex to use.

LINEAR MULTIPLE REGRESSION ANALYSIS is best for sales forecast, as it is easy to use for decision making and solving business problems