Prepare a forecast of call volume for July 2015 by applying Exponential Smoothing (with alpha = 0.5) to the prior 18 months of data. prepare your forecast and assume that initial call volume is 24,000. Show your forecast below and attach the completed Excel template. Call Volume Forecast for July 2015 (Exponential Smoothing, alpha=0.5):

Please share step by step instructions:

File No. 2 (Monthly Data for 2014 and 2015) Actual Employee Call Head Year Month Volume Count Notes 2014 Jan 24,015 62, 120 2014 Feb 25,203 62, 152 2014 Mar 23,589 62, 138 2014 Apr 27,454 68,343 Centex corporation acquired 4/1/2014 2014 May 28, 120 68, 120 2014 Jun 28,321 67,987 Dental insurance plan changed effective 7/1/2014 2014 Jul 29,021 67,956 2014 Aug 26,954 65,342 Printer division sold to Arconet Corporation 8/1/2014 2014 Sep 26,456 65,380 2014 Oct 27,120 65,432 Major tax law changes signed into law by U.S. President 2014 Nov 26,954 65,423 2014 Dec 27,321 65,650 Year-end bonuses announced on 12/10/2014 2015 Jan 26,456 65,620 2015 Feb 27,450 65,610 2015 Mar 31,435 75,231 Paxton Enterprises acquired 3/15/2015 2015 Apr 33,124 75,201 2015 May 32,432 74,978 2015 Jun 31,901 75,012 New employee insurance deductions in effect starting 7/1/2015