General question about resource planning task on FM
I've used FM to put together a task management tool which sits on a calendar. Tasks are assigned to staff and the number of hours the task is expected to take is entered, along with a deadline date.
Alongside this, each member of staff has a 'weekly hours resource', let's say 40 hours per week. This means they can have 40 hours worth of task assigned to them in a week.
What I'm trying to do next may not even be a Filemaker question, but if anybody has done similar I'd love to hear from you.
I want to be able to measure on a calendar month basis how successful a staff member has been at completing tasks to deadline.
The big question I'm wondering at the moment is 'If a task takes 5 days, but the final 3 days are in a different month to the first 2, which month is best to record the success levels in?' I also want to be able to see the percentage of overall staff resource available in a month, but again this begs the question, do we use the start date of a task, the end date or if the task spans two months, split it somehow???
As I say, perhaps not technically an FM question, but I'm wondering if anyone else has covered this?
Which answer makes the most sense to the people using the database to manage this information?