Cost calculation formulas

Box rate

Remaining estimate:

sum of (box hourly rate) * task workload hours

for each task in a period

Story Points:

sum of (box hourly rate) * Story Points for open tasks in a period * SP conversion ratio * AVG # working hours per day)

1. Box hourly rate

2. Tasks: estimates

3. Tasks: start or end date (at least one within the calculation period).

Team rates

Remaining estimate:

sum of (team hourly rate) * task workload hours in a period

for each task in a period

and for each team

Story Points:

sum of (team hourly rate) * Story Points for open tasks in a period * SP conversion ratio * AVG # working hours per day)

for each team

1. Team hourly rates.

2. Team allocation to box.

3. Tasks: estimates.

4. Tasks: start or end date (at least one within the calculation period).

5. Task - team assignment.

Box rate

Time Spent:

sum of (time spent * hourly rate)

Story Points:

sum of (box team rate) * (Story Points for completed tasks in a period * SP conversion ratio * AVG # of working hours per day)

1. Box hourly rate.

2. Tasks: time spent OR story points estimates.

3. Tasks: start or end date (at least one within the calculation period)

Team rates

Time Spent:

sum of (time spent * hourly rate)

Story Points:

sum of (team rate) * (Story Points for completed tasks in a period * SP conversion ratio * AVG # of working hours per day)

for each team

1. Team hourly rates.

2. Team allocation to box.

3. Tasks: time spent OR story points estimates.

4. tasks: start or end date (at least one within the calculation period)

5. Task-team assignment.