GCs & GRs Formula Guide
| Value | Inputs | Formula |
| # of Weeks | ▪ Start Date ▪ Finish Date |
(Finish - Start) / 7 |
| Man Weeks | # of weeks * Allocation | |
| Gas Total | ▪ Gas/week ▪ Man weeks |
Gas/week * Man weeks |
| IT Total | ▪ IT/week ▪ Man weeks |
IT/week * Man weeks |
| Phone Total | ▪ Phone/week ▪ Man weeks |
Phone/week * Man weeks |
| Labor Total | ▪ Salary ▪ Car Allowance (Auto) ▪ Multiplier |
( (Salary+Auto) / 52 * (1+multiplier) ) * Compounding Raise |
| Total Annual | ▪ Salary ▪ Car allowance (auto) ▪ Multiplier ▪ Gas/week, IT/week, iPhone/week ▪ Compounding Raise (assume 100% allocated) |
((((IT+Gas+Phone)* # of weeks) + ((Salary+Auto)/52) * (1+multiplier) * Compounding Raise) / # of weeks) * 52 |
| Grand Total | ▪ Gas/week ▪ Man weeks |
Gas + IT + Phone + Labor |
| Rate | Total annual / Vacation hours (PTO) | |
| Compounding Raise | ▪ Start Date ▪ Finish Date ▪ Allocation (this is always 100% when used in the total annual calc.) ▪ Raise ▪ Current date |
Step 1: Calculate the current raise. If start date < current date then current raise = 0. Step 2: Determine the number of fiscal year changes (Fiscal Year Count) between start date & finish date. Step 3: Determine the number of weeks & average Allocation % within each fiscal year bucket. |
References
Raise Escalation Logic (Compounding Raise)
Raises are an annual percentage-based markup of a staff member’s base compensation (salary & annual car allowance). For each position, we apply this raise escalation logic for every fiscal year between GCs & GRs document creation date & said position’s end date. See formula below:
Fiscal Year Count
The number of fiscal years passed during a staff’s duration on a job. A fiscal year starts January 1st, ends December 31st.
Weeks
Staff duration.
Allocation
The percentage of time a staff member is allocated to a particular project.
Raise
The user input Preconstruction Raise or Construction Raise percentage.
- Preconstruction Raise: Applies to all staff members in the preconstruction phase with the "Estimating” type designation.
- Construction Raise: Applies to all others.
Current Raise (Raise Current)
The initial raise value derived from the amount of fiscal year changes between the GCs & GRs Document Creation Date and the Staff Start Date:
Total Annual
The total annual burden off a staff member assuming 100% allocation.
Labor Total
The staff labor total.
Grand Total
The total burden of a staff member.
Rate
The hourly rate of a staff member.
PTO (Vacation Hours)
The total amount of billable hours within a fiscal year.
Default Values:
- PTO Reimbursable = 2080 hours
- 8 wks PTO Non Reimbursable (4 wks Vacation) = 1760 hours
- 6 wks PTO Non Reimbursable (3 wks Vacation) = 1840 hours
GR Labor Rate Total Calculations
- Regular Time (used to calculate RT Hours) = total bodies working full-time
- Overtime & Double-time (used to calculate OT Hours) = decimal indicating the amount of overtime worked relative to regular time (i.e. 1 body works 2 OT hours a week > 4/40 = 0.1)
- Week Hours (constant) = 40 hrs
- Day Hours (constant) = 8 hrs
- RT Hours = Week or Day Hours * Regular Time (i.e. 2 laborers)
- OT Hours = Week or Day Hours * Overtime (i.e. 0.1)
- DT Hours = Week or Day Hours * Double-time
- Total = RT Hours * Regular Rate (i.e. $60) + OT Hours * OT Rate + DT Hours * DT Rate
Note: Week denominations apply to the GR Labor tab & Day denominations apply to the Labor Gantt tab.
Operator Cheat Sheet
+ (Add)
- Calculates the sum of two values
- (Subtract)
- Calculates the difference of two values
/ (Divide)
- Divide its values
x or * (Multiply)
- Multiply its values
() (Open Parenthesis and Closed Parenthesis)
- Specifies that the expressions within the open parenthesis and close parenthesis are evaluated first. All other expressions are evaluated using standard operator precedence.
If you have any questions, feel free to contact our support team and we'll be happy to help!