Docs navigation

On this page

Forecast cashflow month over month based on historical trends by service

This query uses the Provider column. Provider is deprecated in v1.3 and will be removed in v1.4.

FOCUS Versions

v1.0 v1.1 v1.2

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),
  ProviderName,
  ServiceCategory,
  ServiceName,
  SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE BillingPeriodStart >= ? AND BillingPeriodEnd < ?
GROUP BY
  MONTH(BillingPeriodStart),
  ProviderName,
  ServiceCategory,
  ServiceName

FOCUS Datasets

Cost and Usage Billing Period Invoice Detail

FOCUS Columns

Provider Name Billing Period Start Service Category Service Name Billed Cost Billing Period End

Forecasting Budgeting

Finance

Forecast Accuracy Rate (Spend) This metric compares forecasted vs. actual cloud spend over a specific period (e.g., day, month, quarter). Forecast Accuracy Rate (Usage) Compares forecasted vs. actual cloud usage (vCPUs, Memory, etc) over a specific period (e.g., day, month, quarter). Forecast Drift Rate Evaluate how cloud infrastructure forecasts change over time due to various factors. Percentage Variance of Budgeted vs. Forecasted CSP Cloud Spend Measures the difference between budgeted costs and the forecasted costs for using CSP cloud services. Percentage Variance of Budgeted vs. Actual CSP Cloud Spend Measure the variance or difference between estimated or budgeted costs for using public cloud services & the actual costs incurred. CSP Cloud Budget Burn Rate The rate at which an organization is consuming or spending its allocated budget for cloud services from a CSP.

Previous Forecast amortized costs month over month based on historical trends Next Get historical usage and rates to enable cost forecasting