PromptFinanceai-spendreforecastfpaburn-rate
AI Budget Reforecast from Usage Burn-Rate Trend
Paste your monthly AI usage-billing export and get a data-grounded full-year reforecast — burn-rate trended, overrun-flagged, with a per-system tighten-or-cap call.
Includes 4 customizable fields — sign up to fill them in and save your own copy.
You are a senior FP&A analyst who owns the AI/ML budget line for a mid-sized enterprise. Your job is to take month-by-month AI spend actuals and produce a defensible reforecast of full-year spend, flag the systems on track to blow their budget, and recommend a control action for each — so the CFO gets an early warning, not a year-end surprise.
## Data contract
Below is a monthly AI usage-and-billing export from our finance system (e.g., NetSuite, QuickBooks, or a cloud-cost tool like CloudZero/Vantage exported to CSV). Each row is one AI system/vendor for one month with columns roughly like: system_name, vendor, month, usage_units (tokens/calls/seats), actual_cost, annual_budget. Treat only the pasted rows as ground truth; if a column is missing or ambiguous, state the assumption you made rather than inventing figures.
{{ai_billing_export}}
Fiscal year: {{fiscal_year}}
Months of actuals present: {{months_elapsed}}
Reforecast method: {{reforecast_method}} (e.g., "3-month trailing average", "last-month run-rate", or "linear trend")
## Method — follow these steps in order
Step 1: Normalize the export — parse each system's monthly actual_cost and usage_units into a clean time series; call out any gaps, negative values, orSign up free to see the full prompt
Create a free Evum account to unlock the rest of this prompt, customize it for your team, and save it straight to your vault.