Question: Please show all work including excel formulas. Analyst Joe Turner is trying to decide between using alpha=0.42 or alpha=.15 to prepare Exponential Smoothing forecasts for

Please show all work including excel formulas.

Please show all work including excel formulas.

Analyst Joe Turner is trying to decide between using alpha=0.42 or alpha=.15 to prepare Exponential Smoothing forecasts for the Car business he works at. Assume the Demand is as shown in the table below. Using MAD as the measure of forecast accuracy, make a recommendation with justification on which alpha to use. Assume the forecast for July was 105. You should show all tables that you use in arriving at your recommendation. It is required that you use Excel for this question. Month Demand July 122 August 134 September 150 October 98 November 128 December 140 January 130

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!