Summary
This article will give you a detailed breakdown of how the data for the Customer Gross Profit Report is gathered and calculated.Summary: The Customer Gross Profit Report is used to list the number of hours, billed amounts and cost amounts (including pay, burden and worker's comp) for a customer and can be run in detail or summary for a specific date range.
Information on the report includes Employee Name, Batch or Invoice Date; Week Ending dates (if Show Details is selected); RT, OT & DT Bill Units; Bill Amount; Cost Amount; Gross Profit; Margin or Markup; and Gross Profit per hour.
MARGIN / MARKUP:
The Margin/Markup figure in each subtotal section IS NOT a sum or average of the Margin/Markup for that section of the report, however, it is calculated in the same manner as the amounts in the detail section, only using the subtotals of the Bill and Cost amounts. The Margin/Markup figure is actually calculated for each section since summing or averaging the amounts could provide a skewed weighted average.
MARGIN calculates profit by taking the difference between BILL and COST amount and dividing that by the BILL amount.
MARKUP calculates profit by taking the difference between BILL amount and COST amount and dividing that by the COST amount.
Download this tutorial