Tracking Construction Productivity: A Few Examples [Free Excel Template]

Determining the profitability of a construction project is straightforward: it’s simply the difference between what a contractor gets paid to complete a project, less what it costs them to do so. When contractors create budgets for their projects, they have to estimate the cost and profit margin for every item of work they must perform. This includes materials, equipment, supplies, overhead expenses and of course – the cost of labor. Given that the vast majority of projects depend heavily on those who physically perform the work, it only makes sense that labor costs on most projects is substantial. It’s not uncommon for labor costs to make up the majority of a project’s total budget. The more efficient and productive the crews onsite work, the more profitable a project is. But how is this productivity calculated? How can construction managers and supervisors know whether or not the workers are meeting the budget? What if some items are going better than estimated, while others are doing worse? This is why tracking construction productivity on a regular basis is so important. Let’s go through a few examples of how to track construction productivity using an Excel template, which you can download for free below!

Formula For Calculating Production Rates In Construction

In a general sense, a production rate refers to the amount of work performed in a given time period. By ‘work performed’, I refer to a quantity of tangible work being completed within one specific work task. More specifically, a production rate represents the quantity of work performed by each worker over a given period of time.

For example, let’s consider a fence project. Suppose two workers are expected to completely paint a fence in one 8-hour shift. The fence is 80-ft long x 7-ft high and must be painted in both sides.

In this case, the total square footage of fence that must be painted is 1,120 square feet (SF), which we get by multiplying 80 x 7 x 2 sides. Given that two workers will be on the job, each worker must paint 560 SF of fence in an 8-hour period.

Production rates are calculated using the following formula:

Production Rate = Quantity of Work / Time to Perform Work

Using this formula, we can determine the budgeted production rate of our fence project:

[ 1,120 SF of Fence ] / [ 2 Workers ] / [ 8 Hours ] = 70 SF Per Hour Per Worker

In order to begin tracking construction productivity, we must use the formula above to understand how much work is actually getting done in an exact-quantity sense.

With production rates now defined, let’s talk about how to actually track productivity onsite. Be sure to download our free construction productivity tracking template below!

In order to access this free template, you must first enter your email in the form above. A button will then be visible upon entry, which will allow you to download this template instantly. Occasionally, some readers are not able to see this form. If an email form is not displaying above this section, please try the following steps:

  1. Clear browser cookies for our site and hit refresh.
  2. Visit this page in an ‘incognito’ window.
  3. Visit this page in another browser type.
  4. Email me at pat@solvepmproblems.com.

Tracking Construction Productivity: Essential Steps

Tracking construction productivity is simple…once it’s set up right, that is. As we’ve all experienced at some point, tracking the production and labor budget for a project can become a huge mess if it’s done improperly. I’m a huge believer in using standard operating procedures (SOP) for tracking project information.

Here are the steps that make up my personal SOP for tracking construction productivity:

  1. Separate project scope into categories: Trade, item of work, section of project, etc.
  2. Break each category into quantifiable subtasks
  3. Determine total quantities of work in each category / subtask
  4. Use your project’s estimate to determine how many hours are budgeted for each subtask
  5. Track the hours spent on subtasks and the quantity that’s completed each day

Let’s go through an example for each of these steps using our free construction tracking template, plus a few additional tips!

1. Separate Project Scope Into Categories

The first step we must take in order to track construction productivity is to separate the project into categories. Every project involves performing a series of tasks – both big and small. While a small project can consist of just a couple tasks, medium and large projects involve performing several types of work, each of which contains several smaller steps within them.

For these types of projects, it’s useful to separate the work by trade i.e. carpentry, labor, roofing, etc. You can also categorize your project by component or section of the structure. Below is an example we’ve created using our productivity tracking template.

2. Break Each Category Into Subtasks

As mentioned above, most tasks on a construction project can be broken into several smaller subtasks. Before we can start tracking construction productivity, this is an absolutely essential step!

Below is an example of how we can separate two big tasks on a project – earthwork and foundation – into all of their subtasks. Note that each item should be able to be quantified in some way – more on that next.

3. Determine Quantities Of Work In Each Category / Subtask

Now that we’ve outlined the tasks we want to track on our project, we can fill in the actual quantities of work that need to be completed in each step.

The best tip I can provide for quantifying work in order to track it is this: keep it simple.

After tracking construction productivity for many years, I’ve learned this the hard way all too often. Time is of the essence in construction, so it only makes sense to be able to track finish quantities efficiently. Check out the examples below.

4. Determine Hours Budgeted For Each Subtask

Every construction project has some kind of estimate behind it – that is, some itemized breakdown and calculation of how much labor, equipment, materials, supplies and other costs will be needed in order to price the job.

While we must track how much time and work is completed for each task simply to have monitor ourselves, it makes even more sense to track time and quantities against what has been estimated i.e. what’s in the budget. That’s the whole point after all!

As you can see in our example below, we’ve added timeframes (in man-days, ‘MD’) to each of the tasks in our work breakdown.

5. Track Hours Spent & Quantities Completed

Now that we’ve established the quantities of work we must get done and the time we think it’ll take to do it, let’s start actually tracking what’s going on.

As you can see below, the tasks being worked on each day are accounted for by tracking the amount of work that was done and how many man-days, hours, etc. that were spent in the process.

Our construction productivity template automatically totals the information we’ve recorded and calculates the total quantity of work done, time spent completing it and actual production rate for the week (sample below).

This template also calculates the quantity that’s remaining, the time left to complete them (based on the budget) and the production rate required to finish. As you can see, we’ve added red and green conditional formatting to the template in various columns in order to indicate where productivity rates are higher or lower than our estimate.

Simply use this template each week to track your project’s productivity! As you finish a week, you can manually carry over the quantities completed and time spent on each into a new blank template by entering them in the ‘total previous periods’ section. That way, you can track your project’s overall progress to-date, not just for the current week.

You May Also Like:

Tracking Construction Productivity: A Few Additional Tips

I’ve spent a lot of time tracking budgets and labor productivity on construction projects over the years, so I’ve had plenty of opportunities to make mistakes! Given that I’ve learned the hard way so many times, you should get to learn the easy way. Here are a few additional tips for tracking construction productivity.

Don’t Use ‘Hours’ As A Unit of Measurement

It’s always tempting to use ‘hours’ as a unit of measurement in our estimates. “Building that wall should take about 32 man-hours”. While this is an easy calculation and could be correct, how to we track it? If our crew has spent 16 hours building that wall, how to we know for sure that they’re exactly halfway done, ahead or behind? It’s not always possible.

Therefore, it’s best to stick with quantities of physical work that can be measured in order to determine a rate of progress over time.

Track Production Every Day

Projects move fast. In just one week, workers can find themselves significantly ahead or behind schedule when compared to the total budget. If several work days or a couple weeks go by without tracking how much work is getting done, we may be in for a rude awakening when we finally do run the numbers.

For this reason, tracking construction productivity should be done every day!

Avoid Tracking Huge Quantities Or Tiny Components

As we mentioned earlier, the quantities we use to track our projects should be simple and easy to track with a measuring tape or quick count. There’s seldom going to be one person specifically on the project just for the purpose of tracking quantities – it’s likely going to be done by foremen, supervisors and construction managers who have plenty of other work to do.

That said, quantities should be generally simple to track. If our project involves building a stud wall, we certainly don’t want to track productivity by counting screws and nails! That’d take forever. Instead, we can track the stud wall’s progress by linear feet of lumber installed or even by the total linear (or square) footage of actual stud wall installed.

For example, building and installing a 10-ft x 10-ft section of stud wall can be tracked as 10 linear feet (LF) or 100 square feet (SF).

Try Not To Split Hairs…

Just one more time for good measure – I highly recommend keeping tracking simple on your projects. Details are great, but the overall purpose of tracking construction productivity is to have a reasonably-accurate, simple breakdown of how work is going relative to our budget. If there’s a simple way to do that on your project, it’s likely good enough!

INDEX TAGS:

CLICK TO FOLLOW

“PM PROBLEMS” IS SUPPORTED THROUGH OUR PARTICIPATION IN SEVERAL AFFILIATE PROGRAMS. THIS INCLUDES THE AMAZON SERVICES LLC ASSOCIATES PROGRAM – AS AN AMAZON ASSOCIATE, WE EARN FROM QUALIFYING PURCHASES. WE MAY EARN A COMMISSION WHEN WE PROMOTE OTHER OFFERS FROM CLICKBANK, CJ, ASCEND & AD AGENCIES.  THROUGH THESE PROGRAMS, WE COLLECT FEES WHEN WE LINK TO PRODUCTS, SERVICES AND AFFILIATED WEBSITES. THE PRICE YOU PAY DOES NOT CHANGE IF BOUGHT THROUGH A LINK ON THIS WEBSITE. ALL PRODUCTS AND SERVICES RECOMMENDED WILL BE DIRECTLY RELATED TO THE CONTENT ON WHICH THIS SITE IS BASED. 

THE CONTENT ON THIS WEBSITE ORIGINATES FROM MY OWN PERSONAL KNOWLEDGE, EXPERIENCES AND JUDGEMENT [MY BACKSTORY]. OUR CONTENT IS DESIGNATED TO BE HELPFUL AND INFORMATIVE FOR OUR READERS, BUT IT IS NOT PROFESSIONAL, LEGAL, OR MEDICAL ADVICE! PLEASE SEEK OUT PERSONAL ASSISTANCE & ADVICE FROM A QUALIFIED PROFESSIONAL.

Leave a Reply

Your email address will not be published. Required fields are marked *

Share This Article

Is My Boss Manipulating Me? 12 Signs To Look For

Is My Boss Manipulating Me? Here Are 12 Signs Of A Manipulative Boss

Working in a toxic environment is what I consider a ‘silent killer’. Maybe you can relate to this. The effect settles in over time, not all at once. You start feeling less enthusiasm for your work. You start questioning you own abilities and skill. You take home a little more baggage with you each day. You’re working more to ‘keep up’. You feel worn out, tired, and Monday mornings are your worst enemy. You feel like you’re being drained of your life force one day at a time. Let’s get into the ways bosses manipulate employees, and what to do about them!

Read More »
What Do Building Inspectors Do? 4 Construction Inspector Responsibilities

What Do Building Inspectors Do? 4 Construction Inspector Responsibilities

We all know that buildings and structures are designed to meet certain standards. Whether they’re related to engineering requirements, material placement or building codes, it’s understood that contractors must adhere to strict guidelines when it comes to performing construction duties correctly. While owners and project initiators could simply trust that everything’s being built 100% correctly, the numerous construction disasters that’ve happened over the years prove just how costly – and even deadly – improper construction can be. Sure, there’s pretty much zero risk involved in painting a wall or putting down some new flooring, but projects that involve structural work, utilities, major alterations or public exposure must be monitored closely throughout the process to ensure that all work is being done correctly. That’s where building inspectors come into play. Let’s go through four key construction inspector responsibilities.

Read More »
Buying Materials For Contractors Directly? The Pros & Cons To Consider

Buying Materials For Contractors Directly? The Pros & Cons To Consider

When hiring a contractor, nearly everyone is looking for the same outcome: a successful completion of the work for the best (lowest) price possible. It’s instinctual for our minds to ponder how we can save money on the total cost of construction through whatever means possible. This commonly manifests itself through choosing the “cheapest” contractor right from the start, but there are many other ways that clients and general contractors alike try to save some cash when it comes to hiring contractors. One of these ways involves purchasing the materials directly, rather than leaving it to the contractor that’s being hired. Why? Markup. When we receive a proposal from a contractor, their price typically includes labor, equipment and material costs – all of which are then marked up higher to include the contractors’ overhead and profit margins. Clients can therefore save money by buying materials for contractors directly; if clients or general contractors buy the materials, the contractor (or subcontractor) won’t be able to charge overhead and profit on top of these material costs. This means the client gets to keep that money in exchange for buying the material themselves. That’s a big win…right? Well, that depends. While there are certainly some benefits to buying materials for contractors ourselves, there are also some potential drawbacks. Let’s go through the pros and cons!

Read More »
My Boss Doesnt Have My Back - What Should I Do My 5 Personal Tips

My Boss Doesn’t Have My Back: What Should I Do? My 5 Personal Tips

Do you ever feel betrayed by your boss? Does it seem like the two of you are always at odds, or that you simply can’t trust them? Unfortunately, this is something many of us can relate to. While we hope to have positive, productive relationships with our bosses, it’s certainly not a guarantee. Many of us feel like our bosses are only out for themselves – or even worse, working against us. In the land of the modern workplace and corporate culture, it can feel like work is just as much about office politics, individual advancement and covering our butts as it is about actually doing our jobs, and our bosses are no more exempt from this than we are. While our relationships with our bosses may feel worse in our minds than they really are, we may also notice certain patterns of behavior in them over time. Whether it be that our boss rarely offers us support, disagrees with us in front of others, throws us ‘under the bus’ or just plain doesn’t like us, we eventually reach the point where we think “My boss doesn’t have my back! What should I do?”. As someone who’s definitely been there, I’m happy to share with you the techniques I’ve used to mitigate this situation with success. Let’s get into them.

Read More »
Do Construction Managers Have To Travel? Lets Break It Down

Do Construction Managers Have To Travel? Let’s Break It Down

Let’s kick this one off with a bit of history. It’s the year 1848. Location? North America. What were folks up to? The Revolutionary War was over, but the Civil War had not yet begun. While I can’t speak for everyone since I wasn’t there, about 300,000 people decided to pack up their belongs, leave the family homestead and head to California, often on perilous journeys. The reason? The Gold Rush. Although gold had been discovered in California by local residents earlier, 1848-1849 is when the rush truly began to occur. Often referred to as ’49ers, people from all over the world began arriving in California – not only from the eastern parts of America, but also from Mexico, Peru, China, Australia, New Zealand, Europe and more. The prospects of wealth and prosperity – even through word of mouth and letters – was sufficient reason to give up everything, leave home and spend time digging or ‘panning’ for gold in the desert. In short, people wanted money and California was the best place to find it. While things in America are a bit more stable now, the idea of traveling to find prosperity is far from over – actually, that goes for any country of origin. While working from home is pushing things in a new direction, the prospect of traveling to find better opportunities is still relatable for millions of people. This group certainly includes people working in the construction industry, but there are many nuances to consider. If you came here after wondering “do construction managers have to travel?”, fear not – I aim to answer this with as much detail as I can.

Read More »
Writing Skills For Project Managers - These 6 Are Essential For Success

Writing Skills For Project Managers: These 6 Are Essential For Success

When one imagines a Project Manager, they may picture a person meeting with team mates, reviewing reports or giving presentations. While Project Managers do all of these things, there’s one task that nearly every P.M. spends quite a bit of time on, especially these days: writing. Whether it be writing letters or responding to endless emails, a significant portion of a Project Managers’ performance is underpinned by their ability to write. For many Project Managers (myself included), it takes years of time and experience to finely hone their writing skills. While the best way to get better at writing is to simply spend time doing it, there are many easy ways to improve writing abilities too; many of them are more about what not to do than anything else! Let’s talk about 6 essential writing skills for Project Managers that I’ve picked up over the years. Note that some of these tips aren’t necessarily about writing per se, but rather the intent and strategy behind why you should sometimes write a certain way. Let’s go!

Read More »
Tracking Construction Productivity - A Few Examples - Free Excel Template

Tracking Construction Productivity: A Few Examples [Free Excel Template]

Determining the profitability of a construction project is straightforward: it’s simply the difference between what a contractor gets paid to complete a project, less what it costs them to do so. When contractors create budgets for their projects, they have to estimate the cost and profit margin for every item of work they must perform. This includes materials, equipment, supplies, overhead expenses and of course – the cost of labor. Given that the vast majority of projects depend heavily on those who physically perform the work, it only makes sense that labor costs on most projects is substantial. It’s not uncommon for labor costs to make up the majority of a project’s total budget. The more efficient and productive the crews onsite work, the more profitable a project is. But how is this productivity calculated? How can construction managers and supervisors know whether or not the workers are meeting the budget? What if some items are going better than estimated, while others are doing worse? This is why tracking construction productivity on a regular basis is so important. Let’s go through a few examples of how to track construction productivity using an Excel template, which you can download for free below!

Read More »

6 Project Management Lessons From Enron & Their Historic Collapse

I just finished watching “The Smartest Guys In The Room”. It’s a documentary about Enron, the once-revolutionary Texas energy trading company that famously collapsed in 2001. From the early 90’s right up to their downfall, Enron was a darling of Wall Street, ranking #7 on the Fortune 500 in the same year that news of its’ massive accounting fraud and unethical business practices swept the world. In the summer of 2000, Enron’s stock hit an all-time high of over $90 per share. In late 2001, Enron filed for Chapter 11 bankruptcy and is still known as one of the largest corporate scandals in American history. Not only was Enron a business titan on Wall Street, but they were also well-known on ‘Main Street’ too. Enron’s collapse led to nearly 30,000 lost jobs, thousands of evaporated retirement accounts and countless investors left with worthless stock. Enron was once a (mostly) legitimate energy company before it essentially became an energy stock market in the 90s. What the heck happened? The Enron story is complex yet simple at the same time, unpinned by human ego, greed, deceit and pride. As for the specifics of what happened, we’ll get into those too. Let’s discuss six project management lessons from Enron and their demise that came to me after watching the film.

Read More »
6 Things I Learned While Working For A Failing Company

6 Things I Learned While Working For A Failing Company

Not all companies are meant to last unfortunately. Whether it be due to poor management, changing times, a rise in competition or even economic recession, many businesses end up closing their doors as the years go on. While some of these closures are sudden, other companies take several years before they’re completely shut down. As you probably know already, the daily experience employees have at a failing company is not always great – the atmosphere can range from unmotivated to extremely stressful and everything in between. This experience can also apply to your department or specific branch closing too, even if the company as a whole is not going out of business. If this is your experience, I can relate. The last two years at my previous company were spent seeing the ‘tidal wave’ coming in slow motion; most of us knew our division – once one of the largest in the company – would be shut down eventually given our overall performance, but no one knew exactly when. Here are six things I learned while working for a failing company that’ll hopefully be helpful!

Read More »
Is Project Management Competitive? The Answer Is Complicated

Is Project Management Competitive? The Answer Is Complicated

Many students and young professionals aspire to become a Project Manager at some point in their careers. Some of us desire the title and decision-making authority that being a P.M. provides, while others long to overcome challenges and deliver projects successfully. Of course, many of us want the higher salary and other financial perks that Project Managers often enjoy. Whatever your reason for wanting to become a P.M., it’s likely that other people out there also want to become a Project Manager for similar reasons. How many others are looking to become P.M.s? Is project management competitive? If you’re thinking about becoming a Project Manager and are looking for some stats, then read on!

Read More »
For Project Managers Becoming Entrepreneurs - 5 Tips From Experience

For Project Managers Becoming Entrepreneurs: 5 Tips From Experience

As we all know, project management is an exciting and dynamic field. There are plenty of ways we can challenge ourselves and continue to grow year after year. These are the aspects of project management that most of us love. As we gain experience, we learn a wide variety of skills in leadership, budgeting, scheduling, organization and more. If we can manage a decent-sized project, how much harder can it be to work for ourselves? After working as a Project Manager for awhile, you may begin to crave a challenge beyond what your typical position or company may offer. Perhaps you want to create a business from the ground up. Maybe you crave the ability to make your own schedule, or no longer answer to a boss. For many different reasons, there’s a growing percentage of working professionals who decide not to pursue their current career path anymore, and instead pursue the road less traveled…the path of the entrepreneur. Cue the dramatic music. There’s plenty of reasons why being ‘your own boss’ is great, but there are plenty of reasons one shouldn’t just dive in without preparation, either. I know because I’ve done it! At least to a certain extent. While I was prepared in some ways, there are several things I wish I understood much earlier – that’s what this article is about. For the project managers becoming entrepreneurs out there, let’s go over 5 tips based on my own experience, plus a little detail as to why I became an entrepreneur after thirteen years in construction management.

Read More »