Straight into the service manual page
WrenchQuarry
More

Job margins: 3 ways to summarize closed jobs

WrenchQuarry Editorial Team · Published · 12 min read · How these guides are written

For one job-margin figure from a month of closed jobs, use the median, reported with the job count. Most owners of a small service firm can tell you roughly which jobs make money. The bathroom remodels are fine. The emergency calls are a mess. The crew that finishes early seems to come out ahead. That sense is useful, but it is hard to act on and hard to compare from one month to the next. What you want is one job-margin figure for a month of closed jobs, a number you can write on the office whiteboard, track over time, and talk about with your crew leads.

The catch is that a month of closed jobs gives you a list of margins, not one margin. Each job has its own result, and you need a method to reduce that list to a single figure. Three methods are common: the average, the median, and the mode. All three are easy to calculate in a spreadsheet, and they can give different answers from the same data.

Key takeaways

  • Define margin once as job gross profit divided by job revenue, and keep that definition every month.
  • Settle the closed-job rule, cancelled jobs, and missing costs before you calculate.
  • Report the median as your headline figure, with the job count next to it.
  • Show total gross profit divided by total revenue beside the median.
  • Recalculate earlier months if you ever change the definition.

Start with one clear definition of margin

Decide what margin means in your shop before you summarize anything. The accounting definition is a good starting point. AccountingCoach defines it this way: "Gross margin or gross profit is defined as net sales minus the cost of goods sold." Its example shows that margin is a share of the selling price, not a share of cost: "The gross margin ratio is 20%, which is the gross profit or gross margin of $2 divided by the selling price of $10."

A service firm does not sell goods off a shelf, so you need to translate "cost of goods sold" into direct job cost. Direct job cost is the money you can tie to one specific job. It is different from overhead, such as office rent or the insurance on a work van, which you pay whether or not any particular job closes. For each closed job, you need four values:

  • Job revenue, meaning what the job earned after any credits or refunds you issued for it.
  • Direct job cost, meaning the costs you can tie to that job, such as materials, subcontractor charges, and the crew hours you assigned to it.
  • Job gross profit, meaning job revenue minus direct job cost.
  • Job margin, meaning job gross profit divided by job revenue, shown as a percentage.

Your firm may draw these lines differently. Some owners leave out vehicle costs, and others spread them across jobs. Either can work. What matters is that you draw the lines the same way every month. A margin figure only helps you compare months if the definition stays put, and if you change it, the earlier months need to be recalculated before you compare them.

Keep margin and markup apart, because they are not interchangeable. Many price books are built on markup, which is a percentage added on top of cost. Margin is a percentage of the price you charge. The same AccountingCoach page shows the difference with one product: "Therefore, the $2 markup divided by the product's cost of $8 results in a markup that is 25% of cost." That same $2 is a 25% markup on cost but only a 20% margin on the $10 price. If your estimating software or price book uses markup, convert it before the number goes into your margin column.

Build the list of closed jobs

A summary is only as good as the list under it. Pull every job that closed in the month into one table (a job cost sheet works well for this), with one row for each job and columns for job ID, revenue, direct cost, and margin. Your sources are usually the invoices you issued, the supplier bills you paid or received, and the labor records from your scheduling or timesheet system. If those sources do not agree, find out why before you calculate anything.

Before you run any numbers, settle three questions and write the answers down:

  • What counts as closed? Pick one trigger, such as the date the work was finished or the date the final invoice went out, and use it every month. Mixing triggers can put the same job in two months, or in none at all.
  • What happens to cancelled jobs? A job with no revenue and no cost has no margin at all. Leave it off the list and note that you did.
  • Is every cost posted? Late supplier bills are common. A job whose materials have not been entered yet will look more profitable than it is, and it will pull your figure up for the wrong reason.

Blank cells and zero cells behave differently, and that affects the average. Microsoft's documentation for Excel's AVERAGE function says: "If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included." In practice, a blank margin for a job that is still in progress will be skipped, while a margin of exactly zero counts as a real result. Leave the cell empty for open jobs. Enter zero only for a job that truly broke even.

Do not drop jobs because they came out poorly. A warranty callback, or a job you did at cost to keep a good customer, is part of the month's work. If you remove it, the summary flatters the firm, and the figure stops telling you what happened. If you want to study those jobs separately, put them in their own group and report that group next to the main figure.

Once the list is clean, sort it by margin from lowest to highest.

The average

The average is the most familiar summary. Add up the margins and divide by how many there are. Microsoft's example uses a short list: "For example, the average of 2, 3, 3, 5, 7, and 10 is 30 divided by 6, which is 5." Treat those six values as six job margins in percent for the sake of the example. The arithmetic is the same for real jobs. Add the margins for every job in the month and divide by the number of jobs.

The average uses every job, so no job disappears from the result. That is its strength. Its weakness is that one unusual job pulls it hard in either direction. A single large loss or a single unusually good job can change the story a lot.

Now consider the total. Instead of averaging the margins, you can add up all the gross profit in the month and divide by all the revenue. That gives the share of billed dollars the firm actually kept. The simple average asks what a typical job looks like when every job gets one vote. The total asks how much of each billed dollar the firm kept. In the simple average, a small callback has the same vote as a large remodel. In the total, each job counts in proportion to its size. For pricing and for planning cash, the total is often the more useful number, because it matches the money you actually billed and kept.

The average is still useful. It is easy to explain, it reacts to every job, and it works well when the jobs are similar in size. If your firm does mostly one type of work at roughly the same price, the simple average and the total will often land close together. When they do not, the gap itself tells you something worth investigating, such as a few large jobs running very differently from the rest.

The median

The median is the middle value. Sort the margins from lowest to highest and take the one in the middle. With an odd count, the middle value is a single job. With an even count, the median is the average of the two middle values. Microsoft's example: "For example, the median of 2, 3, 3, 5, 7, and 10 is 4." The middle two values there are 3 and 5, and their average is 4.

The median ignores how far out the extreme values sit, as long as they stay on their side of the middle. In the same six-value list, the 10 gets no more weight than its place at the top of the list. If that largest value were far larger, the average would climb sharply, but the median would not move at all. For a firm where one bad job can sink a whole month, that stability is valuable.

The trade-off is that the median does not reflect job size either. A small job and a large job each count as one value. With a short list, the median can move when one job shifts from one side of the middle to the other. For that reason, always report the job count next to the median. A median from six jobs deserves less trust than one from a much longer list, and readers should be able to see which one they are looking at.

Look at the sorted list once by eye, so an odd entry, such as a missing cost or a duplicate row, does not go unnoticed.

The mode

The mode is the value that appears most often. Microsoft's example: "For example, the mode of 2, 3, 3, 5, 7, and 10 is 3." Here 3 appears twice, and every other value appears once, so 3 is the mode.

For job margins, the mode is the weakest of the three. Margins calculated from real invoices rarely repeat exactly. Two jobs landing on precisely the same percentage is less likely than you might expect, so a long list of jobs may have no repeated value at all. When the mode does appear, it may come from two jobs that happened to land on the same figure, which tells you very little about the month as a whole. Change one job's margin and the mode can disappear or jump to a different value, while the median would barely shift.

The mode does have a better use, though it is a different kind of summary. Group your margins into bands, such as low, middle, and high, and count the jobs in each band. The band with the most jobs shows where most of your work landed. That describes the shape of the month rather than producing a single figure, and it can be a good companion to the median when you want to see whether the jobs cluster tightly or spread out.

Illustrative example: five closed jobs

Suppose a month has five closed jobs with margins of 5%, 10%, 20%, 25%, and 30%. The simple average is 18%. The median, the middle value, is 20%. No margin repeats, so the mode does not describe this month. Report the median as 20% across 5 jobs, and show the total gross profit divided by total revenue beside it.

What one figure can and cannot tell you

A single job-margin figure is a summary, and every summary throws something away. The median tells you about the middle job. The average tells you about the blend of all jobs, weighted equally. None of them tells you why a job came out the way it did. For that, you need to read the rows underneath.

Use the figure as a starting point for questions. If the median dropped this month, which jobs sat near the middle, and what changed about them? If the total fell while the median held steady, which large jobs drove the change?

Be careful with the time window too. One month is a small sample for a small firm. A few large jobs can swing the total a long way. Comparing this month with last month is reasonable, but comparing it with a single unusual month from last year may not be. If you can, track the figure over several months so that one unusual month does not drive your decisions. For checks on comparing these figures, see comparing job-cost figures across periods.

Which one to use

If you need one job-margin figure from a month of closed jobs, use the median. It resists the one bad job that a simple average lets dominate, it does not require anyone to understand the mode, and it is easy to explain to a crew lead who wants to know what a typical job earns.

Report it with two companions:

  • The job count, so readers know how much weight the figure can bear.
  • Total gross profit divided by total revenue, so readers know what share of the billed dollars the firm kept.

If the median and the total are far apart, look at the largest jobs and the weakest ones. A gap like that often points to a few big jobs that ran well, or a few large jobs that ran poorly. Either way, the rows underneath will show you where to look.

Use the simple average when you want every job to count equally, such as when comparing two crews that take on similar work.

Whatever you choose, keep the method the same from month to month. A change in method looks like a change in performance, even when nothing has changed in the field. If you alter the definition of margin or the closed-job rule, recalculate the prior months with the new rule before you compare anything.

Mistakes to avoid

Most bad job-margin figures come from a handful of predictable errors. Check for each one before you publish a figure.

  • Averaging monthly averages. If you average several monthly average margins together, a month with a handful of jobs counts as much as a month with many more. Go back to the job list and summarize all the jobs together.
  • Treating open jobs as zero. A zero is a result, and it says the job broke even. An unfinished job has no result yet. Leave it blank until the job closes.
  • Rounding too early. Calculate with full precision and round only the final figure. Rounding each job's margin before averaging can shift the result, especially with a short list.

A monthly routine

  • Write down the closed-job rule and the direct-cost definition, and keep the note with your spreadsheet.
  • Pull the month's closed jobs into one table, with one row for each job.
  • Check for missing costs, duplicate rows, and cancelled jobs, and fix or note each one.
  • Calculate the margin for each job, leaving open jobs blank.
  • Calculate the median, the simple average, and total gross profit divided by total revenue.
  • Record the median with the job count and the total figure, and save the job list alongside the summary so anyone can check the numbers later.

Add a short note each month about anything unusual, such as a large job that closed late, a supplier price change, or a crew that was short-handed.

Repeat the same steps next month. After several months, the trend will tell you more than any single figure, and the median will give you a steady number to watch while you decide what to change.

Your next step

Today, pull last month's closed jobs into one table, with one row for each job, and write the job count at the top before you calculate anything.

Frequently asked questions

Should I report the average or the median?

Report the median, because one unusually bad job does not dominate it, and show the job count beside it.

What is the difference between margin and markup?

Margin is a percentage of the price you charge, while markup is a percentage added on top of cost.

What should I show next to the median?

Show the job count and total gross profit divided by total revenue, so readers know how much weight the figure can bear and what share of billed dollars the firm kept.

Sources

More field guides