ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Update the GREEN data points
2
Field Costs
Considerations
3
Avg Distance To Job (Miles)15
Gas charges
Download to Excel or make a copy in Google Sheets
4
Truck Annual Cost$7,000
Lease, Insurance, Maintenance
5
Tech Annual Cost$100,000
Total cost with tax, insurance, misc.
6
Jobs/month for avg tech100
How many on sites per month
7
Tech time per initial on-site (hr)1.25
Total time a tech spends to show up on site and in travel
8
Sub Total$137
9
10
Back Office Costs
11
Monthly Bookings100
Number of new jobs you show up to
12
Booking and Dispatch Time (min)15
phone time, back and forth, dispatch management
13
Office Staff Hourly Rate$25.00
Total w/ benefits
14
Software and Tools/Month$1,100
Field and online management tools (all software)
15
Sub Total$17.25
16
17
Other Costs
18
Cost Per Lead (google/Angi/etc)$40
Ad-Spend / total inbound leads
19
Intangible value of a bad review$50
What is a good vs bad review worth to you?
20
Sub Total$90
21
22
Total Cost Of Showing up$244
23
24
Potential Savings
25
# of field techs you employ10
26
Bad visits per month (per tech)3Represents 3% Percent Of Jobs
27
Annual Spend On Bad Fit Customers$87,930
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100