Utilization talks about what % of your book is filled up with appointments compared to the scheduled hours. It sums the Service hours that were rendered within the time range, Recovery hours if set for services and any Paid blockout hours and then divides it by the total scheduled hour in the same date range. This is then converted into % by multiplying it with 100
Validate in Zenoti
(Service hours + Recovery hours + Paid block hours)/ (Scheduled hours)
Scheduled Hours - Reports NEW → Employee Reports → Attendance → Select All Schedule Statuses → Export report → Filter for Schedule Status = Working → Sum of Scheduled Hours
Paid Block Hours - Reports NEW → Employee Reports → Attendance → Select All Schedule Statuses → Export report → Sum of BlockOut Hours (Paid)
Service Hours - Reports NEW → Employee Reports → Attendance → Select All Schedule Statuses → Export report → Sum of Serviced Hours
Export the above report, For the above 3 columns, the format of the column is hh:mm. Pick a smaller set and manually copy the data to convert in mins format
Recovery Hours - Reports NEW → Operational Reports → Appointments → Date type = Appointment Date → Appointment Status = Open, Confirmed, Closed, Checked-in → Export report → Set AddOn = No → Sum of Recovery Time
Export the above report, For the above columns, the format of the column is hh:mm. Pick a smaller set and manually copy the data to convert in mins format