Draw a chart and show the linear trend and its equation

Assignment Help Operation Management

Reference no: EM131729223

The monthly sales data of Murphy Brothers Furniture from Year 2009 to Year 2014 are provided in the file “Assignment 2 Template.xlsx”. Using the sales data, develop forecasting models for the period from Jan 2010 to Jan 2015, based on the following sub-questions. For questions from (2) to (6), show the accuracy measures: Mean Forecast Error (MFE), Mean Absolute Deviation (MAD), Mean Absolute Percentage Error (MAPE), and Tracking Signal (TS).

(1) Draw a chart and show the linear trend and its equation.

(2) Develop the naïve forecast model (last period) using the single previous sales amount.

(3) Perform the 3-month simple moving average.

(4) Perform the 3-month weighted moving average using the weights 0.5, 0.3, and 0.2 respectively in more recent order.

(5) Perform the exponential smoothing using alpha value 0.3. (Set the forecast sales for Jan 2010 as the sales amount of the previous month (Dec 2009)).

(6) Show forecast values for each month using the linear trend (regression): Use the given table for the forecast.

(7) After showing forecast value for each month using the linear trend model, calculate the seasonal index for Jan, and generate the new forecast value for Jan 2015. (Create the trendline forecast from Jan 2009 to Dec 2014 to calculate the seasonal index for January.)

Reference no: EM131729223

Questions Cloud

Prepare an essay of the bridge’ transition model : Prepare an essay of the Bridges’ Transition Model.

When leadership or management is most appropriate : What indications are there as to when leadership or management is most appropriate?

Summarize the four decision making styles : Summarize the four decision making styles.

Utilize two of porter four competitive strategies : Summarize how a company would utilize two of Porter's four competitive strategies.

Draw a chart and show the linear trend and its equation : Draw a chart and show the linear trend and its equation. Show forecast values for each month using the linear trend (regression).

What are at least four reasons why smart goals motivate : What are SMART goals? What are at least four reasons why SMART goals motivate?

Dominance of other two companies in the global marketplace : what strategies could you use to impact the dominance of other two companies in the global marketplace? Why?

Discuss the behavioural implications of planning : Discuss the behavioural implications of planning and control when a company's management employs:

What is the process of consensus and biased language : What is the process of consensus? What is biased language? Give one example of a gender biased language.

User Account

All Pages