Budget Variance Analysis — Q4 2024
Total Budget: $2,450,000
Total Actual: $2,687,500
Total Variance: $237,500 over budget
Some departments exceeded budget while others came in under. Marketing had the largest variance. Overall spending was higher than planned.
knownstateai
Same Tools. Better Prompts. Real Results.
Every example below uses standard AI tools your team already has. The difference is how you ask.
Reliability · All Roles
Reducing AI Hallucinations
Reduce AI-generated errors and fabricated data in your work
The generic prompt
"Summarise the key findings from this report."
The structured prompt
"Summarise the key findings from the attached report. Only use information explicitly stated in the document..."
Summarise the key findings from the attached report. Only use information explicitly stated in the document. For each finding, cite the page or section number. If a data point is referenced but the source value is not in the document, state "not available in source." Do not infer, estimate, or generate any statistics not present in the original.
Generic output
- Confident claims with no source references
- Statistics that don't appear in the original
- No way to verify what's real and what's fabricated
Structured output
- Every claim cites a page or section number
- Missing data clearly flagged as "not available"
- Verifiable output you can trust and share
✕ Generic prompt output
The report shows revenue increased by 23.4% year-over-year, with the strongest growth in the APAC region at $4.7M. Customer satisfaction scores improved to 92%, driven primarily by the new onboarding process. The team expanded by 15 employees across three departments.
⚠ These numbers look authoritative but several don't appear anywhere in the source document
⚠ These numbers look authoritative but several don't appear anywhere in the source document
✓ Structured prompt output
Key Findings:
1. Revenue increased by 18.2% YoY [p.4, Financial Summary]
2. APAC revenue: not available in source — report references growth but does not break down by region
3. Customer satisfaction: 89% [p.12, NPS Section]
4. Headcount change: not available in source — no staffing data found in this document
1. Revenue increased by 18.2% YoY [p.4, Financial Summary]
2. APAC revenue: not available in source — report references growth but does not break down by region
3. Customer satisfaction: 89% [p.12, NPS Section]
4. Headcount change: not available in source — no staffing data found in this document
Data & Analysis
Excel Pivot Table & Reporting
The generic prompt
"Create a pivot table."
The structured prompt
"Create a pivot table showing Q4 sales by region and product category..."
Create a pivot table showing Q4 sales by region and product category. Add conditional formatting: green for >10% growth, red for declines. Include a YoY comparison column and summary row with totals.
Generic output
- Basic table, no formatting
- Requires manual cleanup
- Still unclear what to analyse
Structured output
- Fully formatted, ready to present
- Growth trends immediately visible
- No manual formatting needed
✕ Generic prompt output
HomeInsertData
| A | B | C | |
| 1 | Region | Sales | |
| 2 | North | 452000 | |
| 3 | South | 389000 | |
| 4 | East | 512000 | |
| 5 | West | 298000 |
✓ Structured prompt output
HomeInsertData
| A | B | C | D | E | |
| 1 | Region | Hardware | Software | Services | YoY |
| 2 | North | $185K | $142K | $125K | +14% |
| 3 | South | $163K | $98K | $128K | -3% |
| 4 | East | $210K | $178K | $124K | +22% |
| 5 | West | $122K | $96K | $80K | -8% |
| 6 | Total | $680K | $514K | $457K | +8% |
Operations
Meeting Notes & Action Items
The generic prompt
"Summarise this meeting transcript."
The structured prompt
"Review this 45-min meeting transcript. Extract: 1) Decisions made with owner names..."
Review this 45-min meeting transcript. Extract: 1) Decisions made with owner names, 2) Action items with deadlines, 3) Unresolved questions. Format as a table. Flag any conflicting statements.
Generic output
- Generic paragraph summary
- No clear action items
- Still need to re-read transcript
Structured output
- Structured table with accountability
- Clear next steps with owners
- Conflicts highlighted for follow-up
✕ Generic prompt output
The team discussed the Q4 roadmap and upcoming product launch. Several concerns were raised about the timeline. Marketing presented their campaign plan. The engineering team provided an update on current sprint progress. There was some discussion about budget allocation. The meeting ended with a plan to follow up next week.
✓ Structured prompt output
Decisions Made
| Decision | Owner |
|---|---|
| Launch date moved to March 15 | Sarah K. |
| Budget increase approved ($12K) | James L. |
Action Items
| Action | Owner | Due |
|---|---|---|
| Finalise QA test plan | Dev team | Feb 28 |
| Update campaign assets | Marketing | Mar 1 |
| Vendor contract review | James L. | Feb 25 |
⚠ Conflicts Flagged
| Conflict Sarah said launch is "on track" — Dev team flagged 3 open blockers |
Finance
Budget Variance Analysis
The generic prompt
"Analyse the budget variances."
The structured prompt
"Analyse Q4 budget variances. For any line item >5% over or under budget..."
Analyse Q4 budget variances. For any line item >5% over or under budget: 1) Calculate variance amount and %, 2) Identify trend (one-time vs ongoing), 3) Flag items requiring immediate action. Format as table with: Department, Line Item, Variance $, Variance %, Trend, Action Required.
Generic output
- Generic summary of numbers
- No context on why variances occurred
- Still requires manual investigation
Structured output
- Structured table, ready for leadership
- Variances prioritised by impact
- Clear action flags for follow-up
✕ Generic prompt output
HomeInsertData
✓ Structured prompt output
HomeInsertData
| A | B | C | D | E | F | |
| 1 | Dept | Line Item | Var $ | Var % | Trend | Action |
| 2 | Marketing | Digital Ads | +$67.5K | +37.5% | Ongoing | YES |
| 3 | IT | Cloud | +$38.7K | +18.4% | Ongoing | YES |
| 4 | Sales | Travel | +$8.4K | +8.8% | Seasonal | YES |
| 5 | HR | Recruiting | -$12.2K | -8.4% | Lower hire | No |
HR
Performance Review Summary
The generic prompt
"Summarise this employee's performance."
The structured prompt
"Review this employee's performance notes from the past year. Create a summary structured as..."
Review this employee's performance notes from the past year. Create a summary structured as: 1) Key Accomplishments (3-5 specific examples with metrics), 2) Areas for Development (2-3 items with context), 3) Goals Progress (% completion on each stated goal), 4) Recommended Rating (Exceeds/Meets/Below with brief justification). Keep tone professional and constructive.
Generic output
- Vague, generic summary
- No specific accomplishments or metrics
- Requires complete rewrite
Structured output
- Structured with specific examples and metrics
- Clear rating with justification
- Manager reviews and personalises in minutes
✕ Generic prompt output
Sarah has been a good employee this year. She completed her assigned tasks and worked well with the team. There were some areas where she could improve, but overall her performance was satisfactory. She met most of her goals and showed up reliably. Sarah is a valued team member who contributed to department objectives.
✓ Structured prompt output
Key Accomplishments
- Retention rate: 87% → 94% (target: 90%)
- Onboarded 23 enterprise clients (target: 18)
- Built customer health scoring system, adopted team-wide
Areas for Development
- QBR completion: 78% vs 95% target
- Delegation, opportunity to develop team trust
Goals Progress
- Retention 90%: ✅ 104%
- Onboard 18 clients: ✅ 128%
- $2.1M renewals: ✅ 110% ($2.31M)
Executive
Board Presentation Prep
The generic prompt
"Create a board presentation from these documents."
The structured prompt
"Review these 5 docs (Q4 financials, roadmap, market analysis, hiring, risks)..."
Review these 5 docs (Q4 financials, roadmap, market analysis, hiring, risks). Create outline: 1) Executive Summary (3 wins, 2 challenges), 2) Financial Performance (YoY growth, runway, burn), 3) Strategic Priorities (top 3 with rationale), 4) Risk & Mitigation, 5) Ask/Decision. Pull specific data points from sources.
Generic output
- Generic slides with no focus
- Missing critical insights
- Requires complete rebuild
Structured output
- Focused narrative structure
- Data-driven insights extracted
- Clear decision points for the board
✕ Generic prompt output
✓ Structured prompt output
These results come from structured prompting, not better tools.
A 30-minute conversation about where AI fits in your business.
