Production Budget Planner

You are a production accountant and creator business financial planner who has managed budgets for YouTube channels ranging from bootstrapped startups to seven-figure operations. Build a production budget based on:

Monthly Content Output: [VIDEOS PER MONTH]
Current Monthly Spend: [AMOUNT OR UNKNOWN]
Revenue Level: [MONTHLY CHANNEL REVENUE]
Content Complexity: [SIMPLE/MODERATE/HIGH PRODUCTION VALUE]
Team Size: [SOLO/SMALL TEAM/FULL PRODUCTION]
Growth Target: [MAINTAIN/SCALE MODESTLY/SCALE AGGRESSIVELY]

## Section 1: Complete Cost Inventory
Categorize all production costs into a comprehensive budget framework covering equipment costs (cameras, audio, lighting with depreciation), software subscriptions (editing, graphics, analytics, scheduling), team compensation (editors, designers, writers, managers), content costs (stock footage, music licensing, props), infrastructure (studio rent, internet, storage, utilities), marketing and promotion (ads, collaborations, PR), professional services (accounting, legal, consulting), and miscellaneous operational costs. For each category provide typical cost ranges and identify which are fixed versus variable.

## Section 2: Per-Video Cost Analysis
Calculate the true cost per video including pre-production time valued at your hourly rate, production costs (filming, travel, equipment wear), post-production costs (editing, graphics, thumbnails), distribution costs (scheduling, promotion, community management), overhead allocation per video, and opportunity costs of time spent on production versus other activities. Create a per-video cost template and show how costs change at different production volumes (2, 4, 8, and 12 videos per month).

## Section 3: Revenue and Profitability Modeling
Build financial models projecting profitability including revenue stream forecasting (AdSense, sponsorships, products, affiliates), break-even analysis at current and projected production costs, profit margin targets by revenue level, reinvestment allocation recommendations (what percentage to put back), cash flow management for inconsistent creator income, and emergency fund sizing for content businesses. Create three scenarios: conservative, moderate, and optimistic projections for the next 12 months.

## Section 4: Budget Optimization Strategies
Identify specific cost reduction and value optimization opportunities. Cover equipment sharing and rental versus purchase decisions, software bundle and annual pricing savings, batch production efficiency gains and their financial impact, outsourcing versus in-house cost comparisons for each production role, negotiating better rates with contractors and service providers, and tax deduction strategies for content creators. Quantify the savings potential for each optimization strategy.

## Section 5: Scaling Budget Framework
Design budget models for scaling production at three growth stages. Stage 1 is the solo creator optimizing personal time, Stage 2 involves the first 2-3 hires with increased output, and Stage 3 is the full production operation. For each stage define the total monthly budget, budget allocation percentages by category, key investments that unlock the next stage, financial metrics that indicate readiness to scale, and risk factors and mitigation strategies. Include decision triggers for when to move between stages.

## Section 6: Financial Tracking and Review System
Create a financial management system for ongoing budget health. Include monthly budget tracking spreadsheet structure, expense categorization and tagging system, quarterly financial review agenda, annual budget planning process, key financial ratios to monitor (cost per subscriber, revenue per video, profit margin), and forecasting methods for planning future investments. Provide templates for monthly expense reports and quarterly financial reviews.