Margins per Hour (Plan in Hours Only)
Margins Per Hour
The Margins Per Hour report can also be exported to .PDF or .CSV formats. It also can be printed to be shared with other people inside the company.
Filters
Header
Columns Displayed
Fixed Columns: Information that comes from delivery plans and which do not change over time. These columns are painted in gray in the report::
Column | Description | Calculation |
---|---|---|
Customer | The customers that are informed on the related plans | |
Delivery Plan | Delivery Plan description | |
Delivery Plan Value | The plan value defined on the plan creation | |
Planned Hours | Total planned hours defined on the plan creation | |
Planned Hourly Rate | Hourly rates calculated on the plan creation |
|
Variable Columns: Information that represents the current position on the selected date:
Column | Description | Calculation |
---|---|---|
Actual Billable Costs (Hours) | Displays the number of billable hours logged to date |
|
Actual Billable Costs (Money) | Shows how much that billable hours represent in money |
|
Actual Non-Billable Costs (Hours) | Displays the number of non-billable hours logged to date |
|
Actual Non-Billable Costs (Money) | Shows how much that non-billable hours represent in money |
|
Total Hours to Date | Shows the total hours logged to date |
|
Actual Hourly Rate | Displays the current hourly rate based on the actual hours and values |
|
Gross Margin to Date | Shows the gross margin in % for the related row. |
|
IMPORTANT It is always recommended to pay attention to the values that compose the margins and results. In case the report shows negative or zeroed margins, or even when margins are too high, it may indicate some data are missing. In case this happens, please, check if:
- The delivery plan value is correctly informed: this is important to calculate the hourly rate and to compare it with the actual rate to generate the margins. It is possible to fill in this information during the delivery plan creation.
- The work rates table for the team member is filled: the costs for every worklog entered are only calculated in case the work rates are informed. This will also impact the actual hourly rate and gross margin calculations.
- There are worklogs entered for that period: the work rates will be calculated based on the worklogs entered by the team members. Check if there are worklogs entered until the date the report is requested for.
The system will indicate with an asterisk (*) and a tip in the bottom of the screen when the delivery plans are presenting missing data in one or more of the items listed above.