Question: Please show me the Excel work and formulas: Show + Month Forecast Actual January 2021 February 2021 March 2021 April 2021 May 2021 June 2021

Please show me the Excel work and formulas:

Please show me the Excel work and formulas: ShowShow

+ Month Forecast Actual January 2021 February 2021 March 2021 April 2021 May 2021 June 2021 July 2021 August 2021 September 2021 October 2021 November 2021 December 2021 3,500 3,500 4,000 4,500 5,000 5,500 6,000 5,500 5,000 4,500 4,000 5,000 2,900 3,200 3,700 4,500 5,400 6,000 6,200 5,400 4,600 4,000 4,000 5,200 Other possibly relevant information from the company: Product is produced two months in advance of sales. 1. The last month of actual demand (Dec 2021) was recently received. The V.P. of Sales and Marketing receives an end of the year $20K Bonus if his forecast accuracy for the year is within + or -10%. Compute his forecast error for the year deriving a number for the MAD and the MAPE. Will the V.P. be receiving a Bonus this year

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!