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
170
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
167
Management Accounting & FP&A
BeginnerKPI tree: link strategy to drivers and metrics
Creates a KPI tree that connects strategic objectives to operational drivers and metrics with definitions. Useful for leadership alignment and dashboard design.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
153