Moovila Resource Utilization
Overview
Moovila calls the people who do project work users (resources). Each user has a labor type, and each labor type carries utilization targets. Comparing logged time against those targets, and open task load against capacity, tells a service manager who is stretched and who has room.
All tools used here are read tier. No Moovila tool is admin-gated in
Conduit. hourlyCost and labor type fullyBurdenedCost are internal
cost data; keep them out of anything shared beyond management.
Anti-triggers
- Whether time was billed correctly - use time-reconciliation.
- Project schedule risk - use project-health.
The roster
moovila_users_list, paging to the end. Keepactivetrue.moovila_labor_types_list(one call, whole table). Index byid.- Join each user's
resourceTypeIDto its labor type forname,workTargetBillable,workTargetTaskandworkTargetMeetings.
Users with no resourceTypeID have no target; list them separately
rather than assuming a default.
Do not use moovila_resource_types_list; Moovila has deprecated it in
favor of the labor type tools.
Logged utilization for a period
moovila_time_entries_listwithoutlastChangedDate(or with the period start only if the tenant confirms it does not pre-book time; see api-patterns); page to the end and keep entries whosestartTimeis in the period.- Group by
user.id. SumtotalHoursandbillableHours. - Billable utilization =
billableHours/ available hours. Ask the user for available hours per week (commonly 40); Moovila's API does not expose working calendars. - Compare with
workTargetBillable. Check the scale across the whole labor type table, not one row: if every target is between 0 and 1 treat them as fractions, and if any is above 1 treat them as percentages. If the table only holds 0 and 1, ask the user which scale the tenant uses before comparing.
Forward load
moovila_tasks_list, paging to the end. Keep tasks withisDeletedfalse,percentageCompleteunder 100, and adueDatethat is either already past (overdue work still needs doing) or in the next 2-4 weeks. Count open tasks with nodueDateseparately and say their timing is unknown.- Group by
ownerUser.id. Remaining effort per task isworkEstimatex (1 -percentageComplete/ 100). - Compare remaining effort with each owner's available project hours in the window.
Report shape
Technician Labor type Logged Billable Util Target Open tasks Est. remaining
J. Ruiz Senior Engineer 152.0 128.0 80% 75% 9 46 h
M. Chen Project Coord. 98.0 40.0 25% 50% 3 8 h
Flag anyone more than 10 points under target (capacity) or with remaining effort above their available hours (overloaded).
Gotchas
- Only project time logged in Moovila appears here. Service-desk time in the PSA is invisible, so low Moovila utilization is not proof of idle time. Say so in the report.
- Inactive users can still own open tasks. Report those tasks; they need reassigning.
workEstimateunits follow the tenant's settings (usually hours). Confirm with the user if values look like minutes or days.