Man Hour Report

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: mceclip0.png  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:
      1. Set the Date Range from 1/1/2020 - 6/30/2020
      2. Select 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.

mceclip0.png

 

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)

 

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Article is closed for comments.