ID 83369965 © Vaeenma | Dreamstime.com
Dreamstime Xl 83369965 62e15af122369

Measuring and Improving Underbillings

Aug. 10, 2022
A way to maximize your profits

Many of us live by and believe in the motto, “cash is king,” meaning that an overall positive cash flow will keep your business healthy and successful. Without positive cash flow, banks and other financial institutions may not allow you to continue to function.

Cash flow is often measured via a cash conversion cycle. A long cash conversion cycle (CCC) means you’re funding jobs and even payroll from your pocket. A shorter cash conversion cycle reduces that issue and leaves cash available in the business for use as needed, including demonstrating business profits. Recognizing and improving under billings is key to improving your company’s cash flow. The best way to do this is not via accounting, which is often looking backward, it’s in the field — assessing where you are today and looking forward to what’s remaining.

What’s your CCC?

A graphic of the CCC is shown in Fig. 1. To explain the movement in the graphic, follow the circled numbers:

  1. You receive the material that you’ve ordered (this could be at the job site or in your warehouse or prefabrication shop).
  2. You pay for the material.
  3. You install or use the material
  4. You bill for the material
  5. You get paid for the material installed

The time between when you pay for materials and when you’re paid for installation of those materials is defined as the CCC. The longer this cycle, the longer you and your company are paying for this job. The knobs that are available to turn to reduce the CCC are your underbillings and your accounts receivables.

How are you billing and how does that impact underbillings?

Before we talk about how to improve underbillings, it’s likely best to think through how billing is done and how you choose what to bill. Are you using the Cost-to-Cost method or the Observed Percent Complete method? It’s important, as the project manager/person doing the billing, that you bill based on the one that is higher. This will keep your cash flow higher. If you’re using the Cost Accounting Method when the Observed Percent Complete is higher than the costs, Fig. 2 demonstrates that you may be leaving money on the table

without recognizing it. An example is a $1-million dollar contract. The most obvious/known underbilling would be the difference between the $500,000 that you’ve billed and the $620,000 in cost you’ve spent. This is traditional accounting underbilling. This tracks costs spent to dollars billed. This is available by looking back into your accounting system. What you may be missing is: How complete is the work? Do not forget that with the Observed Percent Complete method through ASTM E2691, you can get paid for the pre-job and non-installation activities if you can track them and show how they contribute to fulfilling performance.

ASTM E2691 is the standard for construction productivity that uses Job Productivity Management (JPM). This begins at the job planning stage of the project and uses a work breakdown structure (WBS). Tracking against this WBS using the independent variable of work completed, the electrician can report the Observed Percent Complete for each task and recover revenue (including profits) for the actual percent completed on the job. The amount of true underbillings, per Fig. 2 on page 13, would be $250,000 instead of $120,000. It’s key to note that while accounting underbilling would show zero if you’ve billed $620,000, you are actually at $130,000 underbilled if you used the Observed Complete Method. Billing for this work is critical to your company’s success.

Linking the costs of underbilling and accounts receivable (A/R)

Using an example of dollars involved in the CCC, let’s see what the true cost of money is for your company. The Table on explains the work a company must do to cover for the underbillings and aged A/R.

  1. The amount tied up in A/R older than 60 days plus the underbillings in the company — you can modify this to your value.
  2. Opportunity cost: When money is not received, not only do you not have the actual money, but you also don’t have the use of the money. The stock market’s typical 30-year average return is 12% per year, so every month you do not have those funds, you’re losing market gains (or paying interest on lines of credit).
  3. Revenues required: Insert your gross profit number here. You must make additional money to pay for the money that is tied up in your CCC.
  4. It’s likely your estimating hit ratio is not 100%. The industry average is 10%. So, you have to bid 10 times the work to get a job that will give you the revenue to cover the money in your CCC.

What’s the lesson to be learned here? It’s critical that you reduce underbillings and collect on your A/R so that you do not have to tie up estimators and profits to cover this.

Make a plan to maximize your profits by measuring and improving your underbillings

The key to this equation is shown in Fig. 3. You must minimize or eliminate underbillings. Your accounting team must track company profits based on FASBs ASC606 for Revenue Recognition. If you are not billing for either Cost-to-Cost or Observed Percent Completion on the job, your company will show a loss. You must truly know your Observed Percent Complete by using ASTM E2691 Standard for Job Productivity Management on your jobs. Do this by walking the job and comparing the work breakdown structure that defined the work. Track this with a job productivity management tool. Bill based on that percent complete and then be sure to collect that money.

Jennifer Daneshgari is vice president of financial services at MCA, Inc., Grand Blanc, Mich. She can be reached at [email protected]. Dr. Perry Daneshgari is president and CEO of MCA, Inc., Grand Blanc, Mich. He can be reached at [email protected].

About the Author

Jennifer Daneshgari

Jennifer Daneshgari is the vice president of financial services at MCA, Inc. She can be reached at [email protected].

Voice your opinion!

To join the conversation, and become an exclusive member of EC&M, create an account today!

Sponsored Recommendations

Latest from Business Management

In the typical facility, the plant manager has X amount of discretionary spending power that can be directed toward a single purchase. At each level of management down, discretionary spending is stepped down into smaller amounts. Anything beyond a given manager’s limit must be appealed to the next level up. For example, the Plant Engineer can’t quite swing a purchase of $5200 but the Plant Manager can approve it. This informal arrangement reduces corporate overhead and improves operational efficiency. It does not address whether the spending decisions would make financial sense to the Chief Financial Officer, but the cap at each level keeps any mistakes to a reasonably acceptable loss or misallocation of resources. Beyond the Plant Manager’s limit, there is usually a formal process for getting spending approval. It typically involves filling out a Capital Request (or similarly named form). In well-run companies, the form is very structured. It mostly wants some basic information that will give the reviewer(s) the ability to justify not just the purchase but also the cost of acquiring the capital to do so. Because the funds will typically be borrowed by the corporation, the cost of capital must be balanced against the return on investment. There will be at least one person crunching the numbers to make what is called “the business case” for the proposed spending. Making the business case is something you should do, in some way or another, when considering spending within your approved limits. If the spending is above your approved limits, then the manager above you will need a bit beefier of a business case. The business case must take into account the value obtained versus the money spent. Consider the purchase of a thermographic camera. If you intend to purchase a mid-range camera but nobody at your facility is trained and certified in its use, the purchase is probably a waste of money. You’d be better off getting an entry-level camera and then arranging for a path toward certification if you intend to have that ability in-house and it makes operational and financial sense to do so. And generally, it makes sense to have a person or two with Level I certification so they really understand how to get the most out of a camera system that’s beyond the basic level. On the other hand, if you were a manager at an electrical testing firm with several Level III Thermographers you would be wasting your thermographers if you decided to “save money” by equipping them with only basic or even intermediate camera systems. Your firm needs to be able to troubleshoot problems when that important client calls in a panic. Your thermographers need the tools to do that job, and “cost-saving” on camera systems won’t cut it. Presumably, your clients are smart enough to already have basic camera systems; they just don’t have the expertise to use advanced systems. Sometimes a different logic applies to other types of test equipment. In the typical plant, maintenance electricians need sophisticated DMMs. If they lack the training to use the features that are needed for most effectively keeping equipment running, simply choosing a less capable DMM they already know how to use is not the answer. They need the appropriate DMM along with the training on how to use those features correctly. So far, we haven’t looked at the need to crunch any numbers to make the business case. What we have done is think about the match between the purchase, the problem that needs to be solved, and the ability of the user to solve the problem using that purchase. This sounds like a common sense approach that everyone would naturally take, but people often lose sight of the reason for the purchase in the first place. The tendency is to either go all out on something they can’t use or don’t need, or to “save money” by shortchanging the end users with something that doesn’t allow them to do what they need to do. What about those numbers? When you do a purchase request, a bean counter is going to try to determine the cash flows involved (typically in monthly periods). If you write something like, “The payback period is three years,” they don’t find that helpful. Lenders care that a loan can be serviced, and cash flow is the critical factor in calculating whether it can. Thus, beancounters don’t use payback to determine whether they can afford to borrow. They use the Internal Rate of Return (IRR) or Modified Internal Rate of Return (MIRR). Formulas for both IRR and MIRR have been in spreadsheet programs for over two decades, but before that they were determined using a Business Math Calculator (about $150 in 1990). And before that, they were laboriously calculated by hand. The cash flows that are charted will be either additional revenue generated or losses prevented. To help the person who figuratively wears the green eye shade, tie the use of the test equipment to a revenue stream. A major appliance plant in Tennessee has several production lines that collectively produce $1,560,000 per hour of revenue. Thus each minute of unplanned downtime is quite costly. If the plant electrical engineer there wanted to upgrade test equipment in a way that exceeds the Plant Manager’s spending authority, he needs to help the green eye shade guy do the math. He can cite short case histories from the past two years and briefly explain how having X capability (present in the new equipment, absent in the existing equipment) would have saved Y minutes of downtime (which the green eye shade guy will calculate out in terms of revenue and cash flow). The green eye shade guy also needs to know whether each case history is a one-off that will never recur or if it’s representative of what to expect in the future. You can settle this question with a brief explanation. For example, “The responding technician did not have a [name of test equipment]. Consequently, he had to arrive at the same conclusion by other means to the tune of 24 minutes of downtime he would not have incurred if he’d had a [name of test equipment]. This problem occurred once on Line 2 and twice on Line 4.” Now the green eye shade guy can simply add up the downtime, monetize it, and create the cash flow analysis. And it’s really good for something like a power monitor. For example, “In this particular case the plant did not have a monitoring system capable of detecting short-term bursts of power, which we call transient spikes, and alerting us. Transients happen with no notice, and usually without being detected. The motor shop forensic report shows the main motor failed due to winding insulation failure caused by transients. With a power monitor detecting and reporting those transients, we would have been able to intervene before outright failure, on a scheduled basis. That would have reduced downtime by 57 minutes twice last year alone.” Making the business case for your smaller purchases means simply thinking about what you are trying to accomplish and then making sure you are spending the funds correctly to achieve that goal. But as you go up the food chain, you need to make the picture more clear. And when you appeal to corporate for approval, you need to provide reasonably accurate downtime savings numbers that can be converted by them to revenue loss prevention in specific dollar amounts.
Man staring at wall with hand-drawn question marks and money bags on it
Courtesy of Weifield Group
Weifield Group

Sponsored