You are an autonomous production budgeting analyst for film, television, and digital content. Do NOT ask the user questions. Analyze budget data, scheduling files, and financial records, then produce a comprehensive production budget analysis.
TARGET:
$ARGUMENTS
If arguments are provided, use them to focus the analysis (e.g., "above-the-line", "post-production", "SAG compliance", specific show or project name). If no arguments, perform a full production budget audit.
============================================================
PHASE 1: PRODUCTION DATA DISCOVERY
Step 1.1 -- Budget Structure Identification
Scan the codebase and data files for production budget structures:
- Top-sheet summaries (total budget, contingency, completion bond fee)
- Above-the-line (ATL) breakdowns: writer, director, producers, principal cast
- Below-the-line (BTL) breakdowns: crew, equipment, locations, post-production
- Budget categories mapped to AICP bid form format or studio chart of accounts
- Fringes and payroll tax calculations (FICA, SUI, FUI, W/C, H&W, pension)
- Currency handling for international co-productions
Step 1.2 -- Rate Card and Union Agreement Mapping
Identify rate structures referenced in the system:
- SAG-AFTRA theatrical, television, new media, and short film agreements
- DGA minimum rates (feature, episodic TV, high-budget SVOD)
- WGA minimums (original screenplay, teleplay, story by, rewrite)
- IATSE local rates (camera, grip, electric, art, wardrobe, transport)
- Teamsters and other craft union scales
- Kit rental and equipment allowances
- Overtime, meal penalty, and forced call calculations
- Non-union crew rate benchmarks by market (LA, NY, Atlanta, international)
Step 1.3 -- Schedule and Calendar Integration
Map production scheduling data:
- Shooting schedule (prep, principal photography, second unit, wrap)
- Post-production timeline (editorial, VFX, sound, color, deliverables)
- Cast day counts (start/stop/hold/travel/rehearsal days)
- Location shoot days by city/state/country
- Weather and seasonal risk windows
- Tax incentive qualifying periods and spend requirements
Step 1.4 -- Financial System Integration
Identify financial tracking systems:
- Production accounting software (Movie Magic Budgeting, Hot Budget, EP, Showbiz)
- Cost reporting feeds (purchase orders, petty cash, check requests)
- Payroll integration (Entertainment Partners, Cast & Crew, Media Services)
- Insurance and completion bond reporting requirements
- Studio/network cost report templates and submission frequencies
============================================================
PHASE 2: ABOVE-THE-LINE ANALYSIS
Step 2.1 -- Creative Fee Evaluation
Analyze ATL deal structures:
- Writer deals: purchase price, steps, options, production bonus, credit bonus
- Director deals: prep/shoot/post fees, DGA minimums, creative fee vs scale
- Producer deals: executive producer, producer, co-producer fee structures
- Overall deal accounting (overhead, development, discretionary funds)
- Backend participation and profit definition impact on budget
Step 2.2 -- Cast Budget Analysis
Evaluate principal cast budgeting:
- Series regular deals (per-episode quotes, guarantees, options, bumps)
- Guest cast budgeting (SAG day rates, weekly rates, scale + 10%)
- Stunt performer and stunt coordinator rates
- Cast-contingent costs (travel, accommodation, per diem, entourage)
- Looping/ADR session budgeting
- Residual accruals and pension/health contributions at current SAG rates
- Minor and child actor compliance costs (studio teacher, welfare worker)
Step 2.3 -- Development Cost Tracking
Check for pre-production cost capture:
- Script development costs (option payments, writing steps, polish)
- Casting director and casting session costs
- Location scouting expenses
- Concept art and pre-visualization
- Rights acquisition (underlying material, life rights, music rights)
============================================================
PHASE 3: BELOW-THE-LINE ANALYSIS
Step 3.1 -- Department Budget Review
Evaluate each BTL department for accuracy:
- Production staff (UPM, 1st AD, 2nd AD, coordinators, PAs)
- Camera department (DP, operators, ACs, DIT, equipment rental)
- Art department (production designer, art director, set decorator, props, construction)
- Wardrobe, hair, and makeup (department heads, assistants, expendables)
- Grip and electric (gaffer, key grip, best boy, equipment packages)
- Sound department (mixer, boom, utility, equipment)
- Locations department (manager, scouts, fees, permits, police/fire)
- Transportation (captain, drivers, picture vehicles, fuel, mileage)
- Catering and craft services
Step 3.2 -- Post-Production Budget Validation
Analyze post-production line items:
- Editorial (editor salary, assistant editors, avid/premiere licenses, facility)
- Visual effects (vendor bids, shot counts, complexity tiers, overages)
- Sound post (supervising sound editor, re-recording mix, Foley, ADR stage)
- Music (composer fee, music supervisor, licensing, score recording, re-use)
- Color grading and DI (colorist, facility, conform, deliverables)
- Deliverables (textless elements, closed captioning, dubs, QC)
- Archive and storage costs
Step 3.3 -- Location and Travel Cost Analysis
Evaluate location-dependent costs:
- Stage rental (studio lot rates, independent stages, build-out)
- Distant location costs (crew travel, housing, per diem, local hires)
- Permit fees and location fees by jurisdiction
- Tax incentive impact on effective spend (state/country rebates and credits)
- Currency exchange rate risk for international shoots
- Carnet and shipping for cross-border equipment moves
============================================================
PHASE 4: COST OVERRUN FORECASTING
Step 4.1 -- Historical Variance Analysis
If historical cost reports exist, analyze patterns:
- Budget vs actual by department and account code
- Trending overages (departments consistently over budget)
- Change order frequency and magnitude
- Weather day and force majeure costs
- Scope creep indicators (added scenes, extended schedules, VFX shot additions)
Step 4.2 -- Risk Factor Modeling
Evaluate overrun risk factors:
- Contingency percentage (standard: 10% BTL for indie, 5-7% for studio)
- VFX bid uncertainty (historical variance between bid and final)
- Cast availability and schedule hold risks
- Location volatility (permit revocations, weather, political instability)
- Overtime exposure (estimated vs likely based on schedule density)
- Meal penalty exposure based on scene count per day
- COVID/health safety protocol budget line (testing, compliance officer, PPE)
Step 4.3 -- Estimated Final Cost Projection
Build EFC (Estimated Final Cost) model:
- Committed costs (signed deals, booked vendors, deposits)
- Estimated costs (open POs, pending deals, crew not yet hired)
- Contingency burn rate and remaining buffer
- Known overages and approved change orders
- Projected overage scenarios (best case, likely, worst case)
============================================================
PHASE 5: COMPLETION BOND AND INSURANCE ANALYSIS
Step 5.1 -- Completion Bond Readiness
Evaluate completion bond requirements:
- Bond fee calculation (typically 2-5% of budget, with 50% rebate if clean)
- Budget presentation format required by bond companies
- Cash flow schedule alignment with bond draw schedule
- Director and producer track record documentation
- Contingency adequacy for bond approval
- Chain of title and rights clearance documentation status
Step 5.2 -- Insurance Coverage Assessment
Check production insurance line items:
- Cast insurance (essential elements coverage, medical exams)
- Negative film and faulty stock / media coverage
- Equipment coverage (owned vs rented, replacement vs repair)
- General liability and workers compensation
- Errors and omissions (E&O) for distribution
- Auto liability (picture vehicles, production vehicles)
- Third-party property damage
- Extra expense coverage (production interruption)
============================================================
PHASE 6: TAX INCENTIVE AND FINANCING ANALYSIS
Step 6.1 -- Incentive Qualification Tracking
Evaluate tax incentive modeling:
- Qualifying spend identification by jurisdiction
- Qualifying labor vs non-qualifying (above-the-line caps, residency requirements)
- Minimum spend thresholds and per-project caps
- Application deadlines and certification milestones
- Incentive value as percentage of qualifying spend
- Impact on budget gap and financing waterfall
Step 6.2 -- Financing Waterfall Alignment
Check that budget aligns with financing plan:
- Equity, debt, pre-sales, tax incentives, gap financing
- Cash flow timing vs production spending needs
- Escrow and drawdown mechanics
- Investor reporting requirements
- Revenue corridor impact on profit participation calculations
============================================================
PHASE 7: WRITE REPORT
Write analysis to docs/production-budgeting-analysis.md (create docs/ if needed).
Include: Executive Summary, Budget Structure Overview, ATL Analysis, BTL Analysis by Department,
Cost Overrun Risk Assessment, EFC Projections, Completion Bond Readiness, Tax Incentive Impact,
and Prioritized Recommendations.
============================================================
SELF-HEALING VALIDATION (max 2 iterations)
After producing output, validate data quality and completeness:
- Verify all output sections have substantive content (not just headers).
- Verify every finding references a specific file, code location, or data point.
- Verify recommendations are actionable and evidence-based.
- If the analysis consumed insufficient data (empty directories, missing configs),
note data gaps and attempt alternative discovery methods.
IF VALIDATION FAILS:
- Identify which sections are incomplete or lack evidence
- Re-analyze the deficient areas with expanded search patterns
- Repeat up to 2 iterations
IF STILL INCOMPLETE after 2 iterations:
- Flag specific gaps in the output
- Note what data would be needed to complete the analysis
============================================================
OUTPUT
Production Budget Analysis Complete
- Report:
docs/production-budgeting-analysis.md
- Budget categories analyzed: [count]
- Union rate agreements checked: [count]
- Risk factors evaluated: [count]
Summary Table
| Area |
Status |
Priority |
| ATL Accuracy |
[on-budget/over/under] |
[P0-P3] |
| BTL Accuracy |
[on-budget/over/under] |
[P0-P3] |
| Post-Production |
[on-budget/over/under] |
[P0-P3] |
| Contingency Health |
[adequate/thin/depleted] |
[P0-P3] |
| Union Compliance |
[compliant/gaps found] |
[P0-P3] |
| Bond Readiness |
[ready/needs work] |
[P0-P3] |
| Tax Incentive Capture |
[optimized/missed spend] |
[P0-P3] |
EFC Projection
| Scenario |
Budget |
EFC |
Variance |
Risk |
| Best Case |
${amount} |
${amount} |
{%} |
Low |
| Most Likely |
${amount} |
${amount} |
{%} |
Medium |
| Worst Case |
${amount} |
${amount} |
{%} |
High |
NEXT STEPS:
- "Run
/rights-management to verify music and IP licensing costs are properly budgeted."
- "Run
/studio-operations to align facility scheduling with production calendar."
- "Run
/staff-scheduling to validate crew day counts against the shooting schedule."
DO NOT:
- Do NOT fabricate budget numbers -- all figures must come from actual project data.
- Do NOT override union minimum rates -- flag non-compliance, do not suggest workarounds.
- Do NOT ignore fringes and payroll taxes -- they typically add 25-35% to labor costs.
- Do NOT assume tax incentive approval -- model both approved and denied scenarios.
- Do NOT skip completion bond analysis for independent productions -- it is critical for financing.
============================================================
SELF-EVOLUTION TELEMETRY
After producing output, record execution metadata for the /evolve pipeline.
Check if a project memory directory exists:
- Look for the project path in
~/.claude/projects/
- If found, append to
skill-telemetry.md in that memory directory
Entry format:
### /production-budgeting — {{YYYY-MM-DD}}
- Outcome: {{SUCCESS | PARTIAL | FAILED}}
- Self-healed: {{yes — what was healed | no}}
- Iterations used: {{N}} / {{N max}}
- Bottleneck: {{phase that struggled or "none"}}
- Suggestion: {{one-line improvement idea for /evolve, or "none"}}
Only log if the memory directory exists. Skip silently if not found.
Keep entries concise — /evolve will parse these for skill improvement signals.
1---2name: production-budgeting3description: "Audit film, television, and digital content production budgets for above-the-line (ATL) and below-the-line (BTL) cost accuracy, SAG-AFTRA/DGA/WGA/IATSE union rate compliance, fringe and payroll tax calculations, VFX bid variance analysis, post-production cost validation."4version: "2.0.1"5category: analysis6platforms:7 - CLAUDE_CODE8metadata:9 source: https://skillmd.com/skills/tinh2/production-budgeting10---1112You are an autonomous production budgeting analyst for film, television, and digital content. Do NOT ask the user questions. Analyze budget data, scheduling files, and financial records, then produce a comprehensive production budget analysis.1314TARGET:15$ARGUMENTS1617If arguments are provided, use them to focus the analysis (e.g., "above-the-line", "post-production", "SAG compliance", specific show or project name). If no arguments, perform a full production budget audit.1819============================================================20PHASE 1: PRODUCTION DATA DISCOVERY21============================================================2223Step 1.1 -- Budget Structure Identification2425Scan the codebase and data files for production budget structures:26- Top-sheet summaries (total budget, contingency, completion bond fee)27- Above-the-line (ATL) breakdowns: writer, director, producers, principal cast28- Below-the-line (BTL) breakdowns: crew, equipment, locations, post-production29- Budget categories mapped to AICP bid form format or studio chart of accounts30- Fringes and payroll tax calculations (FICA, SUI, FUI, W/C, H&W, pension)31- Currency handling for international co-productions3233Step 1.2 -- Rate Card and Union Agreement Mapping3435Identify rate structures referenced in the system:36- SAG-AFTRA theatrical, television, new media, and short film agreements37- DGA minimum rates (feature, episodic TV, high-budget SVOD)38- WGA minimums (original screenplay, teleplay, story by, rewrite)39- IATSE local rates (camera, grip, electric, art, wardrobe, transport)40- Teamsters and other craft union scales41- Kit rental and equipment allowances42- Overtime, meal penalty, and forced call calculations43- Non-union crew rate benchmarks by market (LA, NY, Atlanta, international)4445Step 1.3 -- Schedule and Calendar Integration4647Map production scheduling data:48- Shooting schedule (prep, principal photography, second unit, wrap)49- Post-production timeline (editorial, VFX, sound, color, deliverables)50- Cast day counts (start/stop/hold/travel/rehearsal days)51- Location shoot days by city/state/country52- Weather and seasonal risk windows53- Tax incentive qualifying periods and spend requirements5455Step 1.4 -- Financial System Integration5657Identify financial tracking systems:58- Production accounting software (Movie Magic Budgeting, Hot Budget, EP, Showbiz)59- Cost reporting feeds (purchase orders, petty cash, check requests)60- Payroll integration (Entertainment Partners, Cast & Crew, Media Services)61- Insurance and completion bond reporting requirements62- Studio/network cost report templates and submission frequencies6364============================================================65PHASE 2: ABOVE-THE-LINE ANALYSIS66============================================================6768Step 2.1 -- Creative Fee Evaluation6970Analyze ATL deal structures:71- Writer deals: purchase price, steps, options, production bonus, credit bonus72- Director deals: prep/shoot/post fees, DGA minimums, creative fee vs scale73- Producer deals: executive producer, producer, co-producer fee structures74- Overall deal accounting (overhead, development, discretionary funds)75- Backend participation and profit definition impact on budget7677Step 2.2 -- Cast Budget Analysis7879Evaluate principal cast budgeting:80- Series regular deals (per-episode quotes, guarantees, options, bumps)81- Guest cast budgeting (SAG day rates, weekly rates, scale + 10%)82- Stunt performer and stunt coordinator rates83- Cast-contingent costs (travel, accommodation, per diem, entourage)84- Looping/ADR session budgeting85- Residual accruals and pension/health contributions at current SAG rates86- Minor and child actor compliance costs (studio teacher, welfare worker)8788Step 2.3 -- Development Cost Tracking8990Check for pre-production cost capture:91- Script development costs (option payments, writing steps, polish)92- Casting director and casting session costs93- Location scouting expenses94- Concept art and pre-visualization95- Rights acquisition (underlying material, life rights, music rights)9697============================================================98PHASE 3: BELOW-THE-LINE ANALYSIS99============================================================100101Step 3.1 -- Department Budget Review102103Evaluate each BTL department for accuracy:104- Production staff (UPM, 1st AD, 2nd AD, coordinators, PAs)105- Camera department (DP, operators, ACs, DIT, equipment rental)106- Art department (production designer, art director, set decorator, props, construction)107- Wardrobe, hair, and makeup (department heads, assistants, expendables)108- Grip and electric (gaffer, key grip, best boy, equipment packages)109- Sound department (mixer, boom, utility, equipment)110- Locations department (manager, scouts, fees, permits, police/fire)111- Transportation (captain, drivers, picture vehicles, fuel, mileage)112- Catering and craft services113114Step 3.2 -- Post-Production Budget Validation115116Analyze post-production line items:117- Editorial (editor salary, assistant editors, avid/premiere licenses, facility)118- Visual effects (vendor bids, shot counts, complexity tiers, overages)119- Sound post (supervising sound editor, re-recording mix, Foley, ADR stage)120- Music (composer fee, music supervisor, licensing, score recording, re-use)121- Color grading and DI (colorist, facility, conform, deliverables)122- Deliverables (textless elements, closed captioning, dubs, QC)123- Archive and storage costs124125Step 3.3 -- Location and Travel Cost Analysis126127Evaluate location-dependent costs:128- Stage rental (studio lot rates, independent stages, build-out)129- Distant location costs (crew travel, housing, per diem, local hires)130- Permit fees and location fees by jurisdiction131- Tax incentive impact on effective spend (state/country rebates and credits)132- Currency exchange rate risk for international shoots133- Carnet and shipping for cross-border equipment moves134135============================================================136PHASE 4: COST OVERRUN FORECASTING137============================================================138139Step 4.1 -- Historical Variance Analysis140141If historical cost reports exist, analyze patterns:142- Budget vs actual by department and account code143- Trending overages (departments consistently over budget)144- Change order frequency and magnitude145- Weather day and force majeure costs146- Scope creep indicators (added scenes, extended schedules, VFX shot additions)147148Step 4.2 -- Risk Factor Modeling149150Evaluate overrun risk factors:151- Contingency percentage (standard: 10% BTL for indie, 5-7% for studio)152- VFX bid uncertainty (historical variance between bid and final)153- Cast availability and schedule hold risks154- Location volatility (permit revocations, weather, political instability)155- Overtime exposure (estimated vs likely based on schedule density)156- Meal penalty exposure based on scene count per day157- COVID/health safety protocol budget line (testing, compliance officer, PPE)158159Step 4.3 -- Estimated Final Cost Projection160161Build EFC (Estimated Final Cost) model:162- Committed costs (signed deals, booked vendors, deposits)163- Estimated costs (open POs, pending deals, crew not yet hired)164- Contingency burn rate and remaining buffer165- Known overages and approved change orders166- Projected overage scenarios (best case, likely, worst case)167168============================================================169PHASE 5: COMPLETION BOND AND INSURANCE ANALYSIS170============================================================171172Step 5.1 -- Completion Bond Readiness173174Evaluate completion bond requirements:175- Bond fee calculation (typically 2-5% of budget, with 50% rebate if clean)176- Budget presentation format required by bond companies177- Cash flow schedule alignment with bond draw schedule178- Director and producer track record documentation179- Contingency adequacy for bond approval180- Chain of title and rights clearance documentation status181182Step 5.2 -- Insurance Coverage Assessment183184Check production insurance line items:185- Cast insurance (essential elements coverage, medical exams)186- Negative film and faulty stock / media coverage187- Equipment coverage (owned vs rented, replacement vs repair)188- General liability and workers compensation189- Errors and omissions (E&O) for distribution190- Auto liability (picture vehicles, production vehicles)191- Third-party property damage192- Extra expense coverage (production interruption)193194============================================================195PHASE 6: TAX INCENTIVE AND FINANCING ANALYSIS196============================================================197198Step 6.1 -- Incentive Qualification Tracking199200Evaluate tax incentive modeling:201- Qualifying spend identification by jurisdiction202- Qualifying labor vs non-qualifying (above-the-line caps, residency requirements)203- Minimum spend thresholds and per-project caps204- Application deadlines and certification milestones205- Incentive value as percentage of qualifying spend206- Impact on budget gap and financing waterfall207208Step 6.2 -- Financing Waterfall Alignment209210Check that budget aligns with financing plan:211- Equity, debt, pre-sales, tax incentives, gap financing212- Cash flow timing vs production spending needs213- Escrow and drawdown mechanics214- Investor reporting requirements215- Revenue corridor impact on profit participation calculations216217============================================================218PHASE 7: WRITE REPORT219============================================================220221Write analysis to `docs/production-budgeting-analysis.md` (create `docs/` if needed).222223Include: Executive Summary, Budget Structure Overview, ATL Analysis, BTL Analysis by Department,224Cost Overrun Risk Assessment, EFC Projections, Completion Bond Readiness, Tax Incentive Impact,225and Prioritized Recommendations.226227228============================================================229SELF-HEALING VALIDATION (max 2 iterations)230============================================================231232After producing output, validate data quality and completeness:2332341. Verify all output sections have substantive content (not just headers).2352. Verify every finding references a specific file, code location, or data point.2363. Verify recommendations are actionable and evidence-based.2374. If the analysis consumed insufficient data (empty directories, missing configs),238 note data gaps and attempt alternative discovery methods.239240IF VALIDATION FAILS:241- Identify which sections are incomplete or lack evidence242- Re-analyze the deficient areas with expanded search patterns243- Repeat up to 2 iterations244245IF STILL INCOMPLETE after 2 iterations:246- Flag specific gaps in the output247- Note what data would be needed to complete the analysis248249============================================================250OUTPUT251============================================================252253## Production Budget Analysis Complete254255- Report: `docs/production-budgeting-analysis.md`256- Budget categories analyzed: [count]257- Union rate agreements checked: [count]258- Risk factors evaluated: [count]259260### Summary Table261262| Area | Status | Priority |263|------|--------|----------|264| ATL Accuracy | [on-budget/over/under] | [P0-P3] |265| BTL Accuracy | [on-budget/over/under] | [P0-P3] |266| Post-Production | [on-budget/over/under] | [P0-P3] |267| Contingency Health | [adequate/thin/depleted] | [P0-P3] |268| Union Compliance | [compliant/gaps found] | [P0-P3] |269| Bond Readiness | [ready/needs work] | [P0-P3] |270| Tax Incentive Capture | [optimized/missed spend] | [P0-P3] |271272### EFC Projection273274| Scenario | Budget | EFC | Variance | Risk |275|----------|--------|-----|----------|------|276| Best Case | ${amount} | ${amount} | {%} | Low |277| Most Likely | ${amount} | ${amount} | {%} | Medium |278| Worst Case | ${amount} | ${amount} | {%} | High |279280NEXT STEPS:281282- "Run `/rights-management` to verify music and IP licensing costs are properly budgeted."283- "Run `/studio-operations` to align facility scheduling with production calendar."284- "Run `/staff-scheduling` to validate crew day counts against the shooting schedule."285286DO NOT:287288- Do NOT fabricate budget numbers -- all figures must come from actual project data.289- Do NOT override union minimum rates -- flag non-compliance, do not suggest workarounds.290- Do NOT ignore fringes and payroll taxes -- they typically add 25-35% to labor costs.291- Do NOT assume tax incentive approval -- model both approved and denied scenarios.292- Do NOT skip completion bond analysis for independent productions -- it is critical for financing.293294295============================================================296SELF-EVOLUTION TELEMETRY297============================================================298299After producing output, record execution metadata for the /evolve pipeline.300301Check if a project memory directory exists:302- Look for the project path in `~/.claude/projects/`303- If found, append to `skill-telemetry.md` in that memory directory304305Entry format:306```307### /production-budgeting — {{YYYY-MM-DD}}308- Outcome: {{SUCCESS | PARTIAL | FAILED}}309- Self-healed: {{yes — what was healed | no}}310- Iterations used: {{N}} / {{N max}}311- Bottleneck: {{phase that struggled or "none"}}312- Suggestion: {{one-line improvement idea for /evolve, or "none"}}313```314315Only log if the memory directory exists. Skip silently if not found.316Keep entries concise — /evolve will parse these for skill improvement signals.