Sustainability consulting business-calculate the forecast

Assignment Help Operation Management

Reference no: EM131473590

Joey is managing a sustainability consulting business. She would like to predict what revenues will be for October 2016. She has monthly data for the past 12 months.

Please complete the following:

• Calculate the forecast for October 2016 (and all earlier months as appropriate) using a 4-period moving average.

• Calculate the forecast for October 2016 (and all earlier months as appropriate) using a 3-period weighted moving average where the most recent weight is 0.5 and 2nd most recent is 0.4.

• Calculate the forecast for October 2016 (and all earlier months as appropriate) using exponential smoothing. Pick the alpha that gives the BEST forecast (with respect to MAD), out to 1 decimal place only, please. Initialize the forecast by having November 2015’s forecast = October 2015’s actual revenues.

• Calculate the forecast for October 2016 (and all earlier months as appropriate) using the simple naïve method. (1 point) • Calculate MAD for each of these 4 forecasts.

• On a separate page, create one Excel chart that shows: Revenues from October 2015 onward AND all 4 forecasts for October 2016 and earlier months as appropriate.

Month-Yr Revenue (in 1,000s)

Oct-15 $80

Nov-15 $85

Dec-15 $95

Jan-16 $90

Feb-16 $85

Mar-16 $90

Apr-16 $70

May-16 $80

Jun-16 $85

Jul-16 $85

Aug-16 $90

Sept. 16 $80

Reference no: EM131473590

Questions Cloud

Initial cash flow of the butterfly spread strategy : What is the initial cash flow of the butterfly spread strategy? If it's a cash inflow, enter a positive number.

Describe role windows firewall plays in protecting computer : Describe the role Windows Firewall plays in protecting computer from threats. Research and list some salient features of each of following versions of Window 10

Major behavior schools of management theories : Three major behavior schools of management theories

What is the maturity risk premium : What is the maturity risk premium for the 2-year security?

Sustainability consulting business-calculate the forecast : Joey is managing a sustainability consulting business. She would like to predict what revenues will be for October 2016.Calculate the forecast for October 2016

Interest loan with monthly payments : What is the effective interest rate if the loan is an add-on interest loan with 12 monthly payments?

Do you have some examples from your own life : Do you have some examples from your own life or workplace when risk planning was not done? What were the consequences? Can you reduce risk to zero?

Has ntc engaged in false advertising : Novell, Inc., produces its NetWare networking software in two forms: original and upgrade. The upgrade version is substantially identical to the original.

What is the lanham act explain : Tommy Larsen, a Danish citizen, produces aesthetically pleasing functional objects, such as furniture. Larsen designed a compact disc holder called the "CD 25".

User Account

All Pages