Question a (3 focuses):

Applying Exponential Smoothing to the (monthly) data from the previous 18 months, you can predict the volume of calls in July 2021. To create your forecast, make use of the appropriate Excel template from the Hillier text. Either assume a call volume of 16,000 at the beginning or argue for a different starting point. Pick no less than two unique alpha qualities for your model. Model, do these decisions change your gauges?

Show your figure underneath and connect the finished Succeed layout. Your spreadsheet must display your formulas, not hard-coded numbers.

Question b (3 focuses):

Apply Direct Relapse to anticipate call volume from headcount utilizing the proper Succeed format. Utilize 53,000 as your July 2021 headcount input or a basic time-series strategy to project July 2021. Show your figure beneath and append the finished Succeed layout. Show your formulas, not the numbers you've hard-coded.

Question c (1 point):

Work out the Mean outright deviation worth of the Dramatic Smoothing model (Question a) and the Typical Outright Assessment Mistake of the Straight Relapse model (Question b). Explain how these two values differ from one another. For what reason does one strategy outflank the other?

Question d (1 point):

What is your best estimate for July 2021? Justify and explain the methods that were used in this analysis. Take into account your responses to Questions A, b, and c as well as all of the aforementioned factors. You might introduce an extra model. Provide an explanation and justification for the method by which you arrived at your forecast value below.

Question e (2 focuses):

Give your proposals to Stacy on the best way to alter determining processes and work on their exactness.