Determining the # of days formula

TPALJA

Im trying to calculate the number of days for a project based on the budget dollars $14,256.90 with an average of $30.00 per hour per employee for 4 employees (resources) and 8 hours per day

Jennifer Kurtz

I think you'd take the Total Project $$$/ (#employees x Hrs/Day X $$/hr )

So, $14,256.90 / ($30/hr X 4 ees X 8 hrs)

$14,256.90/960 = 15 days (rounded up)

if the employees are working a different number of hours each day, you'd include that in the denominator. (e.g., 2 employees work 4 hours/day, 2 work 8 hrs/day - ((2x4)+(2x8)) x $30/hr

does that help?

Jennifer Kurtz

I think you'd take the Total Project $$$/ (#employees x Hrs/Day X $$/hr )

So, $14,256.90 / ($30/hr X 4 ees X 8 hrs)

$14,256.90/960 = 15 days (rounded up)

if the employees are working a different number of hours each day, you'd include that in the denominator. (e.g., 2 employees work 4 hours/day, 2 work 8 hrs/day - ((2x4)+(2x8)) x $30/hr

does that help?

TPALJA

beautiful thank you!

Jennifer Kurtz

Sure - happy to help!