Process Modeling: Putting To Print Things That Work

For most firms, knowing what needs to be done to effectively manage a case is something learned through time and experience.  Unfortunately, this valuable information is rarely put to print for others to follow.  The result is constant “reinvention of the wheel”.  For associates, how well you can swim after being thrown in the shark-infested pool determines whether you become partner, career associate or looking for other work.

Likewise, if there is staff turnover, how quickly they are up to speed on your processes will determine how long it takes for productivity to reach or exceed pre-turnover levels.

Modeling your processes provide a concrete method for everyone in the firm to know not only what is expected, but why the expectation is in place and how to go about performing the task(s) in a manner approved by the firm.  This has several benefits, not the least of which is a reduction in the “change curve” time,  improved efficiency and the increased capacity to scale.

There is, of course, a process to building the process model.  The first step is to outline all of the processes in the firm.  This includes administrative processes, practice-related processes, client and matter-related processes, and any other process that pertains to firm business.

Once outlined, those who have the experience must brainstorm and put to print all the years of experience that has taught them to know on instinct what to do as the work-flow meanders from question to question.  Mapping this visually helps to find the gaps and gives you the opportunity to take out redundant tasks which may cause bottlenecks that reduce efficiency.

The example to the left is a mapping of a collections process (click on it to view in full screen).  It started with just picking a point in the process, going through the steps, then reading and re-reading to fill in the gaps and add in the details.

Once you have the process visually mapped, the next step is taking each step and reviewing why it is there.  The “why” helps to confirm that the step is necessary – if you can’t figure out why a step is needed, then it isn’t needed.  The “why” is also for new employees or others who may have to temporarily perform the task later.  One of the complaints I often hear from partners has to do with the lack of “ownership” some in their firm have towards files given to them.  In my opinion, a lack of understanding the entirety of the file is one reason an associate may do subpar work.  Thus, part of the process of taking a file from a partner should include a thorough reading of the file, paying particular note of certain things the partner always looks for to help understand the important issues in the file.  Although this is obvious to those with experience, it may not come as second nature to new associates or staff.  The “why” helps them see it from the partner’s perspective without forcing the partner to lose productive time in having to explain it.

This has more than one benefit.  Although highly unlikely (tic)¹, it may be that the partner’s time tested process may miss out on a detail or two that an enterprising associate or support staff discovers.  In cases such as this, having the “why” helps the associate or support staff understand the purpose and he/she then can propose process enhancement, furthering continuous process improvement².  (This can be encouraged through upward reviews).

After providing the “why”, the next part is the “how”.  Use a step-by-step approach so that others can follow the process in an easy-to-understand manner.  An example approach for a collections process would be:

1. Sort AR for collectible and non-collectible accounts;
2. Distribute to responsible attorneys to determine if any should be held from normal process;
3. Determine age of oldest unpaid  invoice;
4. If older than:
   1. 30 days – go here
   2. 45 days – go here
   3. 60 days – go here
   4. etc
5. etc

After completing this tedious but necessary list, model it visually through a tool like Microsoft’s Visio.  An example output for a part of the above process might look like this:

After review of the processes to ensure they are appropriate and are easy for others to understand, make it easily available for your staff to access.  In today’s connected world, this means access through a web browser.  Your site should be easy to access from within the network and should be easy to navigate.  An example site may look like the below (shown without theme – in practice it may mimic your external website’s design):

Besides the benefits discussed above for modeling your firm’s processes, there are quantifiable reasons as well that can lead directly to the firm’s bottom line.  For example, you can assign an amount of time it should take to perform a certain task.  Having this information available allows you to set baselines for performance reviews (efficiency of employee versus the firm efficiency standard).  It also gives the firm an opportunity to offer different billing options to clients; for example, if a client desires more cost certainty, the firm can offer a flat rate based on how long it takes to perform the tasks in a typical case, taking into consideration the facts and the potential to vary from the norm.  You can then add your margin to this number to provide a fee that is both acceptable to the client and ensures profitability for the firm.

As you can probably note from reading the above, modeling your processes is a tedious and time-consuming process in itself.  However, the benefits of taking the time to map, model and follow your processes shouldn’t be understated.  Not only will it improve the manner in which work is performed, but it can bring measurable benefits to your bottom line.

Of Counsel Consulting can help your firm map, model and price your processes so that you attain maximum benefit for taking the time to further the goal of continuous improvement.  Please feel free to call or email us for more information.

______________________________________
¹ tongue in cheek – Go Back
² The idea of continuous process improvement isn’t new but is laid out nicely in a book written by Tom Pryor called Using Activity Based Management For Continuous Improvement that I recommend. – Go Back

Array Formulas Solve Complex Excel Needs

There are plenty of reporting tools available for law firms.  However, one of the common questions firms have when looking at reporting software is “Can you export to Microsoft Excel?”  Microsoft Excel has become the tool for manipulating financial data.  Therefore, an understanding of some of the more powerful features will help you with the more complex needs, such as (from Microsoft):

• Counting the number of characters in a range of cells.
• Sum numbers that meet certain conditions, such as the lowest values in a range or numbers that fall between an upper and lower boundary.
• Sum every nth value in a range of values.

An array formula “is a formula that works with an array, or series, of data values rather than a single data value.”  In other words, for example, you can set up a formula to show a result based on a range of results from a column.  One way to use this is to measure your AR numbers.  Let’s say that you rank AR priority based on age, amount, and payment history.  You can create a column representing the average age of AR, one for the amount of AR, and one with a credit rating based on past payment history (using a scale of A-F). 

You can then create an array formula in a cell that can produce a result based on your logic for determining AR priority.  If you decide that A list clients with AR between $1,000 and $10,000 with an average age under 200 days should be excluded from your collections process, you can create an array formula that can sum all of the clients that fit these variables.  There are many uses of array formulas that will help you track important metrics.  They can be used to track fee earner capacity, mark-down frequency, and really anything you want to measure that is being tracked by the firm.

There are several websites that help in creating array formulas, but I really like the one set up by Pearson Software Consulting.  Instructions on creating an array formula from the Pearson site:

To enter a formula as an array formula, type the formula in the cell and press the CTRL SHIFT and ENTER keys at the same time rather then just ENTER. You must do this the first time you enter the formula and whenever you edit the formula later. If you do this properly, Excel will display the formula enclosed in curly braces { }. You do not type in the braces — Excel will display them automatically. If you neglect to enter the formula with CTRL SHIFT ENTER, the formula may return a #VALUE error or return an incorrect result.

To learn more about array formulas, visit their site by clicking here.