Forecast cashflow month over month based on historical trends by service
FOCUS Versions
v1.3
v1.4
Context
Finance needs to perform month over month forecasting of cashflow by extrapolating from historical cash costs. Having this data enables Finance to create cashflow cost models.
FOCUS SQL Query
SELECT
MONTH(BillingPeriodStart),
ServiceProviderName,
ServiceCategory,
ServiceName,
SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE BillingPeriodStart >= ? AND BillingPeriodEnd < ?
GROUP BY
MONTH(BillingPeriodStart),
ServiceProviderName,
ServiceCategory,
ServiceName