Jobs Table - Work In Progress Report
Contents
Navigation
Work In Progress Report
Export
Navigation
- Navigate to the Jobs Table view from the left side navigation menu
- Click the Views menu in the upper left above the table
- Select "See Work In Progress"
Work In Progress Report
Current Hours Budget - The total number of hours available in the initial labor hours budget.
Projected Hours At Completion - The total number of hours including subsequent change orders.
Actual Hours to Date - The actual number of hours scheduled to the job. This usually flows from the source system if there is an active integration.
Hours Used to Date - The amount of hours that have been scheduled in RIVET since the start date of the job. If an active integration is in place and this number is being ingested from a source system, the difference between the Hours Used To Date in RIVET and the Actual Hours to Date from your source system will indicate the hours scheduled in RIVET since the last time your integration ran.
Labor Hours Scheduled - How many total hours have been scheduled to this job from the start date until the end date.
Scheduled to Projected Ratio - How many total hours have been scheduled to this job/the amount of hours in the Projected Hours at Completion column
Scheduled to Forecast Ratio - The amount of hours scheduled/the amount of hours forecasted on the job. Example: 1000 scheduled/2000 forecasted = 50%
Labor Hours Forecasted - The total number of hours Forecasted on the job from the start date until the end date.
Labor Budget - The amount of dollars available to spend on labor.
Target Blended Rate - Total Labor Budget/Current Hours Budget
Today's Blended Rate - The sum of every workers labor rate on the job this day/Number of workers on the job
Actual Labor CTD - Actual Labor Cost To Date calculated by adding each workers labor rate for every hour they've worked on the job thus far. Or ingested from a source system through an integration.
Materials Budget - Total dollar amount available to spend on materials. Ingested from an integration or entered manually.
Actual Materials CTD - How many dollars have been spent on materials thus far. Entered manually or ingested from an integration.
Total Contract - Dollar amount awarded for this job
Estimated % Complete - Entered manually, usually by the Project Manager(s) associated with the job. Or may be ingested through an integration.
Amount Earned - Dollar amount of income collected from this job
Bulled to Date - Dollar amount billed for this job
Bulling Over/Under - Billed to Date/Total Contract = X/Estimated % Completed.
Example: Billed to Date 500,000
/ Total Contract 1,000,000
__________________________
.5
Estimated % Completed = 50%
.5/50% = $ 0
Export
- Select the WIP Report from the Views drop down on the Jobs Table
- Click Export on the right side above the table
- Choose whether to print the report or download as a CSV