Utilisation calculators/app

[usn90]

We have a bonus scheme at work, one of the targets to reach is utilisation each month, is there an app available where I can simply input the data and out comes the percentage?

I appreciate the maths is simple enough ie 6 hours billed out of a 9 hour day is 66.6% however I do multiple jobs a day and most the time this doesn t equate to a full hour billed I.e 52 minutes etc.

Reason being although my manager does occasionally send updates during the year these aren t often enough and I m a little tired of nagging him for them, plus I d like to be able to calculate on the fly during the month, and if I m a little down on my target I can do unpaid overtime to buff my score rather than losing the month

I have tried calculating it manually a few times however it never appears to match up with what my employers come up with.

[p4cks]

I made a Productivity calculator for my place (call centre) which involved a time and motion study to identify how long each task took. Although in your instance, it would be helpful for you if your employer shared how they calculate utilisation so that whatever you make can be reconciled against their calculator, for accuracy.

[simon_harris]

They key really is to know how your company it calculating utilisation, is it billable hours, is it lines of code produced etc

[Juan B]

ChatGPT + Excel may offer a decent solution, even if just in the interim.

[MisanoPayments]

Does your firm use Power BI or some other software to monitor this? Perhaps the relevant team can give you a read-only log in to that, to read your own data?

[Ry.Clarke]

If all you’re doing is tracking billable hours then 20 minutes on excel is all you need.

GPT will also do it for you, but make sure you check it