Derek1
23 days agoContributor 2
Time sheets reporting
I need better reporting for my production hours. We are a lawn maintenance company: mowing and basic yard projects. I would like a report that shows our work efficiency:
- total time on each visit. If we have 2 workers on a visit, and the visit took 30 minutes, the report would show a total of 60 minutes on that visit
- total time on visits for the day. Same example, we have a 2-man crew, and they completed 10 visits. Each visit took 30 minutes. So: 30 x 2= 1 hour per visit. 10 visits x 1 hour per visit = 10 "billable hours".
- total time paid per day. Same example: both crew members clocked in at 8:00 and clocked out at 3:30. This is 7.5 hours per worker. 7.5 x 2 workers = 15 labor hours.
- efficiency. Same example: 10 billable hours/15 labor hours = 67% efficiency score (67% of the clocked hours were "billable")
I would use this report to compare our crews, and compare our routes. I would also use it to project how many visits we can realistically schedule in a day. And, I would use it for customer pricing.
I don't see any easy way to create this reporting in Jobber, even though all of the data is available. Thoughts?