Question: Calculate MAPD using excel; please show work + formulas. The manager of the Excom Service Station wants to forecast the demand for unleaded gasoline next

Calculate MAPD using excel; please show work +Calculate MAPD using excel; please show work +Calculate MAPD using excel; please show work +Calculate MAPD using excel; please show work +Calculate MAPD using excel; please show work + formulas.

The manager of the Excom Service Station wants to forecast the demand for unleaded gasoline next month so that the proper number of litres can be ordered from the distributor. The owner has accumulated the following data on demand for unleaded gasoline from sales during the past 10 months: Month Gasoline Demanded (litres) October 800 November 725 December 630 January 500 February 645 March 690 April 730 May 810 June 1,200 July 980 Exponentially Smoothed Forecast (a = 0.30) Month Demand October 800 0 November 725 800 December 630 777.50 January 500 733.25 February 645 663.28 March 690 657.79 April 730 667.45 May 810 686.22 June 1,200 723.35 July 980 866.35 August 900.44 Adjusted Exponentially Smoothed Forecast (a = 0.30, B = 0.20) Month Demand October 800 0 November 725 800 December 630 773.00 January 500 720.80 February 645 639.32 March 690 637.53 April 730 653.18 May 810 678.55 June 1,200 724.65 July 980 895.98 August 930.97 (c) X Your answer is incorrect. Compare the two forecasts using MAPD and indicate which seems to be the most accurate. (Round answers to 1 decimal place, e.g. 52.7%.) Exponentially smoothed MAPD 28.32 % Adjusted forecast MAPD 38.85 % Exponentially smoothed forecast appears to be most accurate

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!