The Margin Per 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.
Accessing the Report
The Margin Per Man Hour Report is located in the Expenses and Job Costing section of the Reports tab.
To get there:
→ First, navigate to the Reports section
→ Hover over the Expenses and Job Costing tab
→ Select Margin Per Man Hour Report
Utilizing the Report
To begin using the report to its fullest potential, we recommend utilizing the filters such as: date range, Operations, & sales rep.
The 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). The 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.
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 I would:
*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. To access this, click the Columns button on the top left corner of the table.
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.
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
Next, let's talk about some of the 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.
If you feel this article was unhelpful or did not contain the information you were looking for, please let us know by contacting support (Support@singleops.com)