average % of time spent depending on size of team

[eazyb]

Hello,

My question is as follows:

I have created a series of equations to calculate the average % of time spent per day per resource to complete a task. This % is based on a set number of resources (10). I would like to create a calculation that allows me to alter that number of resources in order to see the effect it would have on the % of time spent per day. Said another way, I would like to know what would become the average % of time spent per day if I raised the number of resources working to complete the task from 10 to 15.

Thanks,

 

[Denis]

Unclear. Please supply a COMPLETE example.

Looks like your present average is obtained from x / 10 ; x being the total "performance" by the 10 resourses.
Then you bring in 5 resourses: these would have an average of y / 5 ; y being similar to the x above.
Then combined would be (x + y) / (10 + 5).