Skip to main content
DD-CFP-002 Mizan Group: How Good Is the Treasury's Forecast? — Cash Flow Planning Get the data →
DD-CFP-002-Q037 Hard Time series

When the forecast stops being useful

Group "Customer receipts" (all three companies added per version and week), versions dated in 2025: work out the MAPE at every WeekNumber 1-13. What is the first WeekNumber whose MAPE is above 5%?
Expected
One whole number · Line chart of MAPE by WeekNumber
Tables
FactForecast, FactBankTransactions, DimCategory · columns
  • FactForecast
  • FactBankTransactions
  • DimCategory
  • VersionID
  • VersionDate
  • WeekNumber
  • WeekStart
  • ForecastLine
  • Amount
  • TransactionDate
  • EntityCode
  • Category

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

A free account takes a minute. Your draft is kept while you sign in. Need help? Message us

Create a free account Sign in