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
Filters
To begin using the report to its fullest potential, we recommend utilizing the filters such as: Date Range, Operations, & Sales Rep.
| Date Range | Date Range allows you to select a timeframe of your choosing *based on the invoice date. |
| Operations | Operations allow you to analyze margin per man hour by designated business operation (or Quickbooks classification). |
| Sales Rep | Sales Rep filter allows you to drill down into the report by sales rep. |
- 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 you wanted to look at the Margin Per Man Hour on my Residential Installation Operation for the first half of the year:
- Set the Date Range from 1/1/2020 - 6/30/2020
- Select Operation
- Example: For instance, if you wanted to look at the Margin Per Man Hour on my Residential Installation Operation for the first half of the year:
- Once you've set those parameters, you can get a grasp of your sales numbers, COGS, expenses, margins, and your margins per man hour.
Columns
Click Columns and select one or multiple column types. To add and remove columns, the columns in blue will display in the report.
Rearrange Columns by clicking and holding the column header, move to the left or right and drop. Sort rows by clicking the up & down sort arrows icon, click once to sort from low to high, and again to sort from high to low.
| 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) |
Comments
Article is closed for comments.