Beginner
Monthly variance analysis: budget vs actual with bridges
Automates variance analysis with price/volume/mix and spending bridges where applicable. Produces exec-ready narratives and follow-up questions.
Perform monthly variance analysis for {period}.
Inputs:
- Actuals P&L: {actuals}
- Budget/forecast P&L: {budget}
- Volume metrics (units, users, hours): {volume_metrics}
- FX rates (if relevant): {fx_rates}
- Known events: {known_events}
- Thresholds: {abs_threshold} and {pct_threshold}
Output:
1) Variance table by line item with flags.
2) Bridge analysis for key lines (revenue, COGS, labor, marketing).
3) Narrative explanations for flagged items (2โ4 sentences each).
4) Follow-up questions and owner assignments.
Keep it concise and numbers-first.Related Prompts
Management Accounting & FP&A
IntermediateInventory Valuation: LIFO vs FIFO Impact
Analyzes the effect of inventory cost flow assumptions on COGS and taxes.
GPT-4oGemini 1.5 Pro
0
0
172
Management Accounting & FP&A
AdvancedAllocating Shared Service Costs (Corporate Overhead)
Determines how to charge back HR, IT, and Finance costs to operating business units.
Claude 3.5 Sonnet
0
0
169
Management Accounting & FP&A
IntermediateMargin Bridge (EBITDA Bridge) Narrative
Explains the 'walk' from last year's EBITDA to this year's EBITDA.
GPT-4oClaude 3.5 Sonnet
0
0
160