Job credit. Each job margin is its Service Fusion total (plus $599 for Generator Service (Yearly Plan) and $399 for Generator Service (No Contract), which are billed through the plan) minus its materials and other expenses. That margin is split evenly across every crew-day on the job, where a crew-day is one tech on one visit date.

Labor cost. Real hours from the Gusto time-tracking report: regular hours, plus overtime at 1.5×, plus double time at 2×, times the hourly rate on the pay-rate sheet, times 1.20. That multiplier is what each worked hour really costs on top of the wage, from 12 months of Gusto payroll: employer taxes, company-paid benefits, paid time off, holidays and bonuses. Workers’ comp is treated as overhead, which the daily target covers. Salaried techs (Ivan Murillo) carry 8 regular hours on weekdays.

Net produced for a tech-day is its job credit minus its labor cost. The KPI is $500 per worked day. Totals and averages only count worked days whose payroll is in; days still waiting on payroll show their credit in gray.

Jobs view. Each tech-day labor cost is split evenly across the jobs that tech visited that day, so job profit = its credit minus its share of real labor. Jobs profit − labor on days with no job − labor on hidden jobs = net.

Hide a job when its numbers are wrong or not representative: it adds no credit, but the labor that day still counts. Your hidden list is yours alone and follows your login to every device; everyone who uses this board keeps their own. Edit it any time with Hidden jobs at the top.

Big open jobs ($20,000 or more, not yet invoiced, completed or closed, and under 80% invoiced) would otherwise put their whole margin on the few visits entered so far. Instead they are estimated at a 30% margin: the total × 70% minus materials is the labor the job can afford, about one crew-day per $450 of it, and each crew-day earns the job margin divided by that many crew-days. The profit left over is shown as still to come. The real split takes over once the job is fully invoiced.

Subcontractors paid through job expenses (Jose Guardado) are not crew. Their pay is already in the job expenses, so their visits do not split the job credit and they get no row.

Data. Jobs and visits come from Airtable (the nightly Service Fusion sync). Hours come from the Gusto CSVs in the payroll Drive folder, rates from the pay-rate sheet.