We are trying to apportion the elapsed time in a workflow (HD or CRM) to the departments that do the work. I am having a devil of a time tying to make it work in a BAQ… assuming a BAQ is the right way to go. It may not be.
Assume the following (very basic)
Task A started and ended on Day 1 and was performed by Dept 1
Task B started and ended on Day 1 and was performed by Dept 1
Task C started on Day 1 and ended on Day 2 and was performed by Dept 2
Task D started on Day 2 and ended on Day 6 and was performed by Dept 3
Task E started on Day 6 and ended on Day 10 and was performed by Dept 1
So, the total days on which work was done is 10.
However if I add up the days by Dept, I get (and yes, I know I am double-counting)
Dept 1: A + B + E = 1 + 1 + 5 = 7
Dept 2: C = 2
Dept 3: D = 5
Total = 14
How do I handle a day that is split between multiple departments?
I would like to see:
Day 1: 3 tasks, so each gets .33 of a day
Day 2: 2 tasks, so each gets .50
Days 3-5: 1 task
Day 6: 2 tasks, so each gets .50
Days 7-10: 1 task
This should result in
Dept 1: A + B + E = .33 + .33 + .5 + 4 = 5.16
Dept 2: C = .33 + .5 = .83
Dept 3: D = .5 + 3 +.5 = 4
Now the total would be 5.16 + .83 + 4 = 9.99 (close enough)
Any ideas on how to tackle this? I
Thanks.