Business financial model file
Auto Repair Shop Financial Model
Use official US wage data and a transparent two-bay scenario to assess opening cash, monthly costs, capacity and repair-shop KPIs.
Use US benchmarks for the question they can answer
Employee pay is a useful starting point for a staffing budget. It is not the labor rate charged to a customer: that rate must also support unbilled time, premises, equipment and the rest of the business. Historical industry receipts provide scale context, not proof of demand for a new shop.
| Measure and population | Source period | Value |
|---|---|---|
| National median hourly employee wage, automotive service technicians and mechanics | May 2025, BLS | $24.34/hour |
| Median annual employee wage in automotive mechanical and electrical repair and maintenance | May 2025, BLS | $49,630/year |
| General Automotive Repair receipts per reporting establishment, arithmetic mean | 2022 Economic Census, NAICS 811111 | About $844,225/year, derived |
The BLS occupation profile reports the pay figures. They are employee wages, not a fully loaded employer budget or a local hiring quote. The Census industry table reports 84,104 General Automotive Repair establishments and $71,002,726 thousand of receipts. Dividing receipts by establishments gives the mean above. It is not a median, profit margin or 2026 forecast; the covered employer establishments differ in size, service mix and location.
Build an opening budget from actual cash uses
The following is an original planning illustration for a leased, two-bay general mechanical repair shop, not a national startup-cost range or a set of supplier quotes. Replace each amount with a location-specific lease, installed-equipment quote or service agreement. The case excludes buying real estate and adding collision/paint, specialist calibration or high-voltage battery facilities.
| Cash use | Assumed amount | What to verify |
|---|---|---|
| Refundable lease/security deposit | 9,000 | Two months of the assumed rent; a cash asset, not monthly rent expense |
| Premises preparation, electrical work, air and ventilation | 28,000 | Contractor scope and landlord approval |
| Two delivered and installed lifts | 30,000 | $15,000 each in this case, not an equipment-market benchmark |
| Tools, diagnostics and compressed-air equipment | 22,000 | Selected vehicle/service coverage |
| IT and initial software setup | 2,500 | Opening setup; subscriptions are budgeted separately |
| Opening parts and consumables stock | 12,000 | Stock mix, replenishment and supplier terms |
| Permits and professional setup | 3,500 | Actual jurisdiction and operating scope |
| Waste storage, spill supplies and safety setup | 2,500 | Site-specific requirements and collection arrangements |
| Pre-opening payroll and training | 6,000 | Work before the operating month starts |
| Pre-opening insurance coverage | 2,500 | Pre-opening period, separate from the monthly operating cover below |
| Signage and opening promotion | 3,500 | Actual purchase/payment dates |
| Allowance for uncommitted works | 7,500 | An original allowance; revise after quotes |
| Selected pre-opening uses | 129,000 | Sum of the items above |
| Operating cash reserve | 77,850 | Three times the assumed $25,950 monthly fixed cash budget |
| Selected opening cash allowance | 206,850 | Pre-opening uses plus the separate reserve |
Assumed equipment and works amounts are cash budgets; replace them with quotes showing freight, installation and applicable purchase taxes. The three-month reserve is a chosen scenario policy, not a required or universally sufficient buffer. Add financing payments, a larger collection gap or services outside this scope when they apply. The SBA planning guidance supports separating initial costs from recurring commitments and testing when cash is needed.
Waste handling is a real operating cost category. EPA guidance for businesses handling used oil addresses labeled storage and separation from contaminating wastes, and warns that state rules may be stricter. Obtain the actual storage and collection specification before accepting the $2,500 setup and monthly service allowance; those figures do not establish compliance.
Separate monthly commitments from costs per repair order
Assume a 20-day month, two technicians paid for 160 hours each at $32/hour, and a paid adviser/manager role with $4,000 gross monthly wages. Add an original 25% employer-cost allowance to both wage budgets. That allowance is a planning input to replace with actual payroll taxes, benefits and insurance; it is not a statutory US rate. The manager budget is not an owner-distribution forecast.
| Commitment | Assumed monthly cash |
|---|---|
| Two technicians: $10,240 wages plus $2,560 employer allowance | 12,800 |
| Adviser/manager: $4,000 wages plus $1,000 employer allowance | 5,000 |
| Rent and common charges | 4,500 |
| Operating insurance | 900 |
| Utilities | 600 |
| Software and technical data | 350 |
| Waste services | 250 |
| Equipment maintenance | 400 |
| Marketing | 600 |
| Accounting and administration | 400 |
| Other recurring fees | 150 |
| Total fixed monthly cash | 25,950 |
For one assumed comparable repair order, net sales are $600: $300 of labor and $300 of parts, excluding sales tax and after any discounts. Separately assume 2.5 billed labor hours per order (225 billed hours at 90 orders); these priced hours are distinct from productive technician time and do not establish actual clock-hours or efficiency. Parts cost $220, sublet work $25 and consumables $15. Assume every sale incurs a 3% card fee, or $18. The $278 variable total leaves $322 contribution per order before the monthly payroll and premises budget. Rostered technician wages are not deducted a second time per order. Overtime, flat-rate compensation or another hire requires a different cost model.
Check the job schedule before accepting the sales target
Reserve 20% of the technicians' 320 paid hours for non-job time, leaving 256 productive hours. At 2.5 productive hours per comparable order, labor permits 102 complete orders. Separately, reserve 15% of the two bays' 320 nominal hours, leaving 272 usable bay-hours. At 2.8 bay-hours per order, the bay ceiling is 97 complete orders. The practical aggregate ceiling is therefore 97, before checking daily sequencing, skills, parts and actual demand.
The planned 90 orders use 225 productive technician hours and 252 bay-hours. At the assumed mix, they produce $54,000 net sales and $3,030 after variable costs and the fixed cash budget. This is a selected operating result before finance, income tax, replacement capital and changes in working capital, not take-home income. The illustrative cash case assumes same-month customer collection and payment, with parts purchases replacing consumption so opening stock is maintained.
Test whole-order break-even and demand risk
Divide $25,950 fixed monthly cash by $322 contribution: 80.59 orders. Since a partial order cannot pay the bills in this example, the minimum is 81 completed and collected orders, or $48,600 of sales at the fixed mix. Eighty orders still leave a $190 shortfall. The 81-order threshold uses 83.5% of the 97-order aggregate capacity; capacity headroom alone does not prove those bookings will arrive.
| Completed orders | Net sales, $ | Result after the selected operating costs, $ |
|---|---|---|
| 70 | 42,000 | −3,410 |
| 81 | 48,600 | 132 |
| 90 planned | 54,000 | 3,030 |
| 97 aggregate capacity | 58,200 | 5,284 |
A slower start also consumes cash. At 45, 65 and 90 orders in the first three months, the same assumptions produce operating movements of −$11,460, −$5,020 and +$3,030. The $77,850 opening reserve would fall to $61,370 after month two and finish month three at $64,400. This is an original ramp illustration with aligned receipts/payments, not a demand forecast or a guarantee that the reserve is adequate. A supplier deposit, delayed fleet account or weekly payroll date needs its own cash calendar.
Track KPIs with consistent denominators
| KPI and definition | Case value or evidence needed |
|---|---|
| Average repair-order value: net labor and parts sales ÷ completed invoiced orders, same period | $54,000 ÷ 90 = $600; exclude sales tax and remove voids consistently |
| Effective labor rate: net labor sales ÷ billed labor hours | $27,000 ÷ 225 = $120/hour; this is not technician pay |
| Parts gross margin: (parts sales − parts purchase cost) ÷ parts sales | ($300 − $220) ÷ $300 = 26.7%; this is a margin, not markup |
| Planned productive utilization: productive technician hours ÷ all paid technician hours | 225 ÷ 320 = 70.3%; unbilled work must not disappear from the denominator |
| Planned bay load: occupied job bay-hours ÷ usable bay-hours after the stated reserve | 252 ÷ 272 = 92.6%; bay-hours and technician hours are different resources |
| Technician efficiency: billed labor hours ÷ actual productive clock-hours | Requires actual job clocks; ticket count alone cannot establish it |
| Shop-caused rework: original completed orders with validated rework within 30 days ÷ orders in that original cohort | Track the original cohort and allow its observation window to finish; no target is inferred here |
Review these measures together. More billed hours with rising rework may create another unpaid job; higher repair-order value with slow collections can still tighten cash. Compare the business with its own service mix and local evidence before treating any ratio as a target.
Use the financial model with the operating evidence
The selected product remains the seller's Vehicle Repair Shop Financial Model. Its official description identifies editable acquisition spend and CAC, service allocation, customer lifetimes, billable hours, hourly prices, role-level payroll and dated capital spending, with profit and loss, monthly/annual cash forecasts, break-even and dashboard outputs. These are merchant-advertised capabilities, not delivered-file tests.
The US evidence and two-bay calculations on this page are separate planning analysis. They do not establish built-in US payroll-tax handling, the actual workbook's scheduling controls or tested software compatibility. Reconcile supplier quotes, payroll terms, job cards and collection dates before entering your own assumptions. The supporting auto repair capacity guide addresses a separate incremental lift-investment decision; its figures are not this whole-shop startup case.
Planning guide