Actual vs Budgeted Hours by Project

TheActual vs Budgeted Hours by Project report is a project-level report containing calculated fields using percent complete, Time and Work data. This report can be useful in understanding the amount of time that has been put into - and the amount of time that may remain - in any given project. With this information, you can better plan projects or remediate issues in projects that are currently in progress.

The columns/fields available on the report (from left to right) are:

• WORKSPACE
• STATUS
• % COMPLETE (Data in this field is calculated at project level from entries on tasks)
• CATEGORY (Project Category)
• RESPONSIBLE (Project Responsible)
• START DATE
• END DATE
• BUDGET HRS* – Budget Hours – (Totaled from entries at task level, and often identified as "Work")
• ACTUAL HRS* – Actual Hours – (Totaled from time tracking entries entered at task level)
• % ACT VS BGT – % Actual vs Budget – (ACTUAL HRS divided by BUDGET HRS)
• REM BUDGET* – Remaining Budget – (BUDGET HRS minus ACTUAL HRS)
• REM WORK* – Remaining Work – (% incomplete (1 - % COMPLETE) multiplied by BUDGET HRS)
• VARIANCE* (REM BUDGET minus REM WORK)
• PROJ HOURS* – Projected Hours – (ACTUAL HRS plus REM WORK)
• % VARIANCE (PROJ HOURS divided by BUDGET HRS)

*These columns values are displayed with an "h" for hours or "m" for minutes.

Here's a sample of what the calculations taking place can look like for a given project:

Clicking a column heading will sort the report table's rows by that column. You can export to an Excel file or print this report using the buttons near the top:

...and you can click the gear icon near the top of the page to hide (or show) particular columns. Columns not displayed will still have their data used in the calculations occurring in other columns. In the box that appears, use the checkboxes to check or uncheck the columns you'd like displayed, then click Save: