Answer the following questions using the data from the Excel file average bonus. xlsx from Problem 16.43.
From Problem

a. Using exponential smoothing with α = 0.5, forecast the average cash bonus for a financial investment employee in New York City in 2013.
b. Calculate the MAD for the forecast in part a.
c. Using exponential smoothing with trend adjustment, α = 0.5 and β = 0.5, forecast the average cash bonus for a financial investment employee in New York City in 2013.
d. Calculate the MAD for the forecast in part c.
e. Which forecast do you have most confidence in?

Transcribed Image Text:

Year 2005 2006 2007 2008 Average Bonus ($000) 149.8 1914 Year 2009 2010 2011 2012 Average Bonus ($000) 140.6 139.0 100.9 121.9