Field Service by the Numbers: Work Orders, Travel vs On-Site Time, Jobs per Technician-Day, First-Time Fix, Repeat Visits, Van Stock, Appointment Windows, Response Targets & a Dashboard
Run the numbers of a fictional heating service company in 20 hands-on labs – work-order logs, travel and on-site time, jobs per technician-day, first-time fix, repeat visits, van stock, appointment windows, response targets, zone travel, seasonal capacity, cost per visit, contracts and a service dashboard – with every cell checked as you go.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
In 20 hands-on labs you run the numbers of a fictional heating service company with 18 vans in three regions. You turn work-order logs into on-site minutes and first-time-fix rates, split a paid technician-day into travel, on-site, admin and waiting time and calculate jobs per day and weekly capacity. You flag repeat visits within 30 days, decide which parts go on the van, check appointment windows and response targets on a working-hours clock, plan a day, compare zone allocations, size seasonal capacity, price visits and contracts, cost wasted trips and finish with a region-level service dashboard.
Why learn with Tabellab
- Practise in a real spreadsheetEvery lab runs in your browser and checks your cells instantly.
- Verifiable certificatePass the final exam and get a certificate with a public verification code.
- Try before you buyLesson 1 is free, with no sign-up or card needed.
- Who is behind TabellabBuilt by Babala Software in Füllinsdorf, Switzerland. Questions? hello@tabellab.com · Imprint
Lessons
- A Week of Work Orders: First-Time Fix & TravelFree
- The Work-Order Log: Jobs per Region & Weekday Locked
- Anatomy of a Technician-Day: Where the Hours Go Locked
- Jobs per Technician-Day & Weekly Capacity Locked
- First-Time Fix by Job Type, Region & Revisit Reason Locked
- Repeat Visits Within 30 Days Locked
- Van Stock: What to Carry and What It Buys Locked
- Appointment Windows: AM/PM vs 2-Hour Slots Locked
- Response Targets on a Working-Hours Clock Locked
- Planning One Day: Start, End and Overtime Locked
- Travel Zones: Home-Zone vs Any-Zone Allocation Locked
- Seasonal Demand: Technicians Needed per Month Locked
- Capacity vs Demand: Gaps and Subcontractor Days Locked
- Cost per Visit: Labour, Van, Parts vs Price Locked
- Service Contracts: Fee vs Expected Visit Cost Locked
- Wasted Trips: Cancellations, No Access & a Reminder Rule Locked
- Second Visits for Parts: How Long Customers Wait Locked
- Region Comparison: KPIs vs Targets in One Index Locked
- One More Van vs Overtime vs Subcontractor Locked
- Final Project: The Service Dashboard Locked
Learner reviews
Be the first to review this course.