The Man Hour Report provides users with a visit-level breakdown of, not only profit metrics, but many other financial performance metrics as well. This report compiles all visits within the parameters of the filters (which will be covered later) and breaks them down by invoice date, visit and client information, along with financial metrics such as Cost of Goods Sold (COGS cost), Expenses, Gross margin, Total labor hours, and margin per hour.
Navigate to: Reports > Expenses and Job Costing > Man Hour Report
Margin Per Man Hour Report Features
To begin using the report to its fullest potential, we recommend utilizing the filters such as: Date Range, Operations, & Sales Rep.
- Date Range allows you to select a timeframe of your choosing *based on the invoice date.
- Operations allow you to analyze margin per man hour by designated business operation (or Quickbooks classification).
- Sales Rep filter allows you to drill down into the report by sales rep.
*Note: These filters can be used one at a time or not at all. Filtering by both operation and sales rep will give you more precise information.
*If there is not an Invoice Date available on the visit, the data will use the Approved Date.
Example: For instance, if I wanted to look at the Margin Per Man Hour on my Residential Installation Operation for the first half of the year:
*The Residential Installation Operation is specific to the demo account used for this article
- Set the Date Range from 1/1/2020 - 6/30/2020
- Select my Operation
Once you've set those parameters, you can get a grasp of your sales numbers, COGS, expenses, margins, and your margins per man hour"
The data included in the Margin Per Man Hour Report can be controlled by selecting which Columns to display.
1. Click the Columns button on the top left corner of the table.
2. Select the desired columns to include or remove by clicking the name of the data field, and your selections will update on the Report table. Column order can be adjusted by dragging and dropping column headers, as seen in the gif below.
*Note: Data can also be sorted by clicking on Column headers. Click once to sort from Low-to-High, and again to sort from High-to-Low.
*This gif was made to show column customization. It is not from the actual Margin/man hour report
Columns and the values. (We're going to skip over, Visit Name, Operation, Invoice Date, Assignee, and Client since all of those values are somewhat self-explanatory).
Below, you can find the definitions of the columns that aren't as clear cut.
- Approved at: This is the date that the visit was moved to the approved stage in the SingleOps workflow
- REF # This is the reference number for the visit (or Visit number)
- COGS COST: This is the cost of the goods that you've sold to your customer. (To find out how your COGS formula is currently calculated, as an admin user: navigate to Account Settings > Scroll to the COGS Formula tab)
- Expense: any expenses associated to the visits will appear in this column
- Gross Margin: This is calculated by subtracting COGS and Expenses from Sales .
Expressed algebraically: (Sales - [COGS + Expenses]) = Profit
- Total Hours Calculated by dividing Profit $ by Sales
Expressed algebraically: ([Profit / Sales] x 100) = Profit %
- Margin/Hour: The margin/hour is calculated as the gross margin divided by the number of hours, this shows the margin generated per labor hour, including non-labor margins.
- Revenue Per Man Hour: A key performance indicator (KPI) that shows you how much money that job brings in for each billable hour of labor. (Total job cost / Total hours logged = Revenue Per Man Hour)
- Example: If a job costs $100,000 and you billed for 5,000 hours, your revenue per man hour was $20. ($100,000 / 5,000 hrs =$20/hr)