LABOR EFFORT PROJECTION
I need help figuring out how to calculate how much labor cost for a particular task will be at the end date based on -
- column 1 - start date
- column 2 - end date
- column 3 - current labor spent
Initially I'm thinking I need to take the current labor spent to date and divide between today and start date. then multiply by overall duration?
The idea is to be able to figure out if the labor will be more than the budget at the end date
Does this look right?
Help Article Resources
Check out the Formula Handbook template!