Man Hour Report

Introduction

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.

 

Table of Contents

I. Man Hour Report Navigation

II. Margin Per Man Hours Report Features

- Filters

- Columns

- Values & Descriptions

 

 

I. Man Hour Report Navigation

Navigate to:

          mceclip0.png  Reports >
                   Expenses and Job Costing >
                  Man Hour Report

 

 

II. 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 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 

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

 

mceclip0.png

 

 

Columns

The data included in the Margin Per Man Hour Report can be controlled by selecting which Columns to display.

Set-Up:

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.

 

Screen_Recording_2020-08-27_at_03.21.37_PM.gif

*This gif was made to show column customization. It is not from the actual Margin/man hour report

 

Values

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)

 

 

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

Comments

0 comments

Article is closed for comments.