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?

Find more posts tagged with

Accepted answers

Genevieve P.

Hi @Simon Martinez

Your logic makes sense to me!

For your formula, you won't need the SUM() at the beginning. Instead, you can just enclose the division in parentheses before the multiplication:

=([labor spent to date]@row / NETWORKDAYS([start date]@row, TODAY())) * [duration days]@row

I used @row instead of a row number so you could set this as a Column Formula if needed.

Cheers,

Genevieve

All comments

Genevieve P.

Hi @Simon Martinez

Your logic makes sense to me!

For your formula, you won't need the SUM() at the beginning. Instead, you can just enclose the division in parentheses before the multiplication:

=([labor spent to date]@row / NETWORKDAYS([start date]@row, TODAY())) * [duration days]@row

I used @row instead of a row number so you could set this as a Column Formula if needed.

Cheers,

Genevieve

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.