break-even-calc
Calculate break-even revenue by separating fixed and variable costs.
- License 许可
- MIT
- 最近更新
- 2026-11-09
- Stars
- ★ 0
- Forks
- 0
01 前言 Front Matter
- name
- break-even-calc
- source
- https://github.com/openaccountant/skills
- license
- MIT
- description
- Calculate break-even revenue by separating fixed and variable costs.
- imported_at
- 2026-09-20
- source_path
- business/break-even-calc/SKILL.md
- source_repository
- openaccountant/skills
03 SKILL.md 正文
Break-Even Analysis
Overview
Determine the revenue level at which total revenue equals total costs (zero profit). Separates expenses into fixed costs (rent, salaries, insurance) and variable costs (materials, commissions, shipping) to calculate the break-even point in both dollars and units.
Wilson Tools Used
spending_summary— aggregate expenses by category to classify as fixed or variabletransaction_search— pull revenue data and detailed expense transactions for classification
Workflow
- Ask for the analysis period (recommend at least 3 months for accuracy) and average selling price per unit if applicable.
- Use
spending_summaryto get all expense categories and totals. - Use
transaction_searchto pull total revenue for the period. - Classify each expense category:
- Fixed costs: rent, salaries, insurance, software subscriptions, loan payments — costs that stay the same regardless of sales volume
- Variable costs: materials, shipping, payment processing fees, sales commissions, packaging — costs that scale with sales volume
- Calculate:
- Total Fixed Costs per month
- Variable Cost Ratio = Total Variable Costs / Total Revenue
- Contribution Margin Ratio = 1 - Variable Cost Ratio
- Break-Even Revenue = Fixed Costs / Contribution Margin Ratio
- Break-Even Units = Break-Even Revenue / Price Per Unit (if applicable)
- Present the analysis:
BREAK-EVEN ANALYSIS — [Period]
═══════════════════════════════════════
Monthly Fixed Costs
Rent $2,000
Salaries $8,000
Software $500
Insurance $300
Total Fixed $10,800
Variable Cost Ratio 35%
Contribution Margin 65%
BREAK-EVEN REVENUE $16,615/mo
Break-Even Units 166 units @ $100/unit
Current Revenue $22,000/mo
Margin of Safety 24.5%
═══════════════════════════════════════
- Calculate Margin of Safety = (Current Revenue - Break-Even Revenue) / Current Revenue * 100.
- Show sensitivity: what happens if fixed costs increase 10%, or variable costs rise 5%.
Without Wilson
- Export 3+ months of transactions from your bank as CSV.
- In a spreadsheet, add a "Cost Type" column: mark each expense as "Fixed" or "Variable" (leave income rows blank).
- Monthly Fixed Costs:
=SUMIFS(Amount, CostType, "Fixed") / NumberOfMonths(use absolute values). - Monthly Variable Costs:
=SUMIFS(Amount, CostType, "Variable") / NumberOfMonths. - Monthly Revenue:
=SUMIFS(Amount, Amount, ">0") / NumberOfMonths. - Variable Cost Ratio:
=VariableCosts/Revenue. - Break-Even Revenue:
=FixedCosts/(1-VariableCostRatio). - If you sell units at a known price: Break-Even Units =
=BreakEvenRevenue/PricePerUnit. - For a quick check, use the SBA break-even calculator at sba.gov/business-guide/plan-your-business/calculate-your-startup-costs.
Important Notes
- Some costs are semi-variable (e.g., electricity — base cost is fixed, usage varies). Assign these to whichever category dominates, or split them.
- Break-even assumes a constant product mix. If you sell multiple products at different margins, use a weighted average contribution margin.
- Service businesses often have very low variable costs (mostly labor, which may be fixed). The break-even for a solo consultant is essentially: Fixed Costs / Hourly Rate = Hours needed per month.
- Revisit this analysis quarterly. Fixed costs creep up as you add tools, staff, and space.
04 同仓库更多 Skills
oath
Auditing regulatory compliance (SOC2/PCI-DSS/HIPAA/ISO 27001): maps requirements, checks controls, designs audit trails, implements Policy as Code. Use when compliance auditing is needed.
nexus
Orchestrating multi-specialist task chains and scope-adaptive product delivery: classifies intent, selects and executes the minimum viable chain, aggregates results, and verifies acceptance criteria. For multi-domain tasks, build-first delivery, and product lifecycle execution.
nest
Designing LLM-optimized folder structures: audits and restructures directories for context efficiency, progressive disclosure, and prompt cache performance. Not for general repo structure (Grove).
native
Implementing production iOS/Android/macOS native features (SwiftUI, Compose) and iterating a screen against a reference design. Not for cross-platform RN/Flutter (Port) or web (Artisan).
muse
Defining and managing design tokens, applying token systems to existing codebases, building design system foundations. Use for spacing, color, typography, dark mode, cross-platform output.
morph
Converting document formats (Markdown/Word/Excel/PDF/HTML) and generating reusable conversion scripts. Use for distributable specs, accessibility-compliant PDFs, or Pandoc/LibreOffice pipelines.