Thread: Show forecast accuracy of customer schedules as a percentage
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dobson Dave Dobson is offline
external usenet poster
  
Posts: 1
Default Show forecast accuracy of customer schedules as a percentage
A customer forecasts that they will take 20 units next month. At the end of
the month it turns out that they only took 15 units. How accurate was their
forecast? Can this be displayed as a percentage? The values change every
month and there are many different items to analyse.

Also vice versa, 15 units forecast and 20 units taken.

Version 10.0.2614
Reply With QuoteReply With Quote