Doing the Math: Consulting vs. Software

PDFPrintE-mail

Consulting companies want to sell consulting services; software companies want to sell software. When software can be used to “replace” services, a consulting firm’s first instinct is usually to utilize its people rather than the software, because that maximizes utilization (and of course high utilization leads to a higher compensation). Sometimes, however, a consulting company and its client (and the software company) all benefit when the consulting company employs a software-centric solution.

At eprentise, we have been working both directly with end-user customers and with consulting partners who are in the process of considering whether to use our FlexField software in bids or on jobs that involve changing charts of accounts in Oracle E-Business Suite. As part of those conversations, we have been able to construct a realistic comparison of costs and benefits that a professional services company and its client are likely to encounter when they decide to change accounting flexfields, a highly complex and specialized task that is the sole functionality of our FlexField software.

A typical flexfield change project involves the following orchestrated sequence of steps that vary only slightly whether the project is accomplished using consulting services alone or consulting in conjunction with software.

  • Setting up a test environment and preparing it for a “change” project, which includes what we call “pre-steps” that resemble a company’s monthly closing cycle.
  • Setting up the new accounting structure in the Oracle Applications.
  • Mapping from the old chart of accounts to the new accounting flexfield. This is usually done on a spreadsheet.
  • The actual changing of the flexfields. “Post-steps” such as rewriting interfaces, reports, and rules that were based on the old chart of accounts and flexfields.
  • Testing and validation in the test instance to ensure the integrity of the result and user acceptance of the changes. At this point, with software, the users can look at the results and see if they are actually what they wanted, and if not, change the mappings and rerun the software with almost no time or effort.
  • Planning for cutover on the production instance.
  • Pre-steps and cutover into the production environment.
  • Post-steps in the production environment (largely a matter of reusing the set of post-steps created from the test environment).

The FlexField software operates primarily to complete the single hardest and most complex step, that of actually changing the flexfields. With minor variations based on the optimization of the environment and the size of the instance, that step takes a few hours and is totally automated. The software also facilitates the mapping, with import tools and templates. Importantly, as already noted, if the resultant output is not exactly what the users want, they can modify the mapping and rerun the actual change with a few mouse clicks and no additional consulting effort.

At this point, we can compare what a consulting firm’s bid might be using consulting only and using software. There is only one stage of the process for which the estimate of consulting resources required will vary significantly – making the actual changes of the values. Based on data gathered from potential clients who have received bids from consultants and based on our own expertise, the step that covers the actual change of accounting flexfields will cost the client approximately $200,000 to change two charts of accounts (in separate sets of books, for example). Add next the following assumptions about the economics of consulting – a billable hour rate of $150/hour, a burdened cost rate (including benefits, taxes, and overhead) for consultants of the requisite skill level of $100/hour, and an 8 hour day, 160-hour month. Finally, use as a comparison a bid that utilizes the FlexField Express software license ($17,990 per flexfield - Note: The price for FlexField has increased since the writing of this article.  You can find up-to-date pricing info here) for changing two accounting flexfields and you get the following:

Doing the Math

It is important to note that the monetary savings to the customer of $50,000 is only one of four distinct benefits of using the software. The others may well be of greater value, they are: (1) reduced time (both substantially reduced time to completion and far quicker cutover); (2) certainty of data integrity and absolutely no errors; and (3) the ability to re-do the change with no additional cost or delay if the resulting chart of accounts is not exactly what the customer wants.

After reviewing the example, it is tempting to ask why end users would not purchase a software license on their own and then contract with a consulting firm only for the services that do not involve the key step of actually changing the flexfields in their system. A few end users will take that path, but there are several reasons why the end users will more often work through a consulting firm. For many of them, they have been told for so long that charts of accounts and accounting flexfields cannot be changed that marketing by the consulting firm may be the mode in which the idea takes root. More fundamentally, the impetus to change accounting flexfields is driven by a business decision to change an outdated or inefficient chart of accounts. The decisional process is focused on the business result rather than the method of achieving it, and for business users that method of implementing a decision of this sort most often takes the form of hiring a trusted consulting firm to bid and then complete the job. Finally, many clients realize early on that they lack some aspect of the technical capability, bandwidth, or project integration skills needed to be successful even if there is a software solution to the most difficult aspect of the project. The business users are the key players in the mapping, and the IT staff will have to get it done. In many firms they do not often work together and in virtually all firms both groups had full time jobs before the project came along.

The “math” adds up. By embedding the software into the consulting services, the consulting firm is able to add value to multiple links in the chain, decreasing the cost to the client, decreasing project time, ensuring an end result that is exactly what the client wants, and increasing profitability. In addition, because of the greatly reduced time, the consultant can now deploy the saved skilled resources to undertake billable work for another client during the same total duration and make additional money.

Add comment


Security code
Refresh

Email Newsletter icon, E-mail Newsletter icon, Email List icon, E-mail List icon Enter your email address to sign up for our Newsletter

Sign up now

captcha
TEChanges - Agility by Design

May Puzzle

David is often referred to as Rainman due to his peculiar ability to effortlessly figure out a certain date's day of the week. He recently displayed this talent when I asked him if there was a conflict with the upcoming Fuzzy Dice Conference and our weekly court-ordered community service. He asked the date of the convention. It was April 20th, 2012.

"Oh, that’s a Friday," he said, effortlessly. "And your sentences have you committed for the next few dozen Wednesdays so you'll be able to go." And of course he was right.

One day a few weeks ago I asked out loud in the office about the date June 5th. And of all people, my brother Tommy piped up and said "Oh, that's a Tuesday."

"That's right," said David.

Well how about Otcober 3rd?

"That's a Wednesday," said Tommy. Then I asked about Christmas Day 2012.

"Oh, that's a Tuesday." David nodded in agreement.

Do we now have two rainmen? Or had Tommy figured something out?

Show solution...

Solution

Here's what was going on. Tommy was using something called anchor dates. And these dates apply to each and every year. April 4th, or 4/4 we’ll call it from now on, June 6th or 6/6, 8/8, 10/10, 12/12, are all the same day of the week, each and every year.

So too are 5/9 and 9/5, May 9th and September 5th. So too are 7/11 and 11/7, and all the above dates are the same day of the week, as is the last day in February, Leap Year or not. And they’re all the same day as January 4th, it would otherwise be January 3rd, but this was a leap year, and that’s changes the anchor day from January 3rd to January 4th.

Tommy also knew that New Year's Day was a Sunday. He was sobered up by then. And he knew it was a Sunday because Christmas was a Sunday in 2011, so New Year's Day is a Sunday, so the Anchor Day for 2012, January 4th, has to be a Wednesday!

So if that's a Wednesday, then 4/4, 6/6, 8/8, 10/10, 12/12, 5/9, 9/5, 7/11, 11/7, and February 29th are all the same day of the week, and they're all Wednesdays. So when I ask for example, about October 3rd, he knew October 10th was a Wednesday, 10/10. So 10/3 must also be a Wednesday. 12/12 is a Wednesday in 2012, so it’s 12/26, which is two weeks later. So 12/25, or Christmas Day, must be a Tuesday.

Success Tips for Oracle Project Management

  • Create a standard for documentation at the beginning of your project, and hold team members accountable for completing documentation requirements as well as keeping them at and above the standards required.
  • Before promulgating user documentation or training, it’s also a good idea to choose a representative from the among the business users base to review materials first.
  • If you are not sure about the resources and budget required, obtain several estimates from people that have experience with the same size and scope of your project.
  • Be explicit, before beginning the project, what internal resources are required for execution. This includes people, infrastructure, hardware, and software.
  • Help the project champion understand the impact your project will have on the organization and how its successful completion will make him or her an internal hero or heroine for supporting it.
  • Break up your project into smaller projects (try for projects that can be completed in 4-6 months, especially early on) to get success and demonstrate momentum.
  • Make sure that your testing includes reports, upstream and downstream interfaces, customizations, enhancements, and workflows.
  • Ensure that comprehensive transition reports and meetings between departing and incoming personnel are completed.
  • Instead of spending time and resources implementing third-party reporting, consider consolidating multiple instances, moving to a global chart of accounts (CoA), and/or standardizing on a consistent calendar.
  • Include governance, risk, and compliance management as part of the project plan.
  • Finally, celebrate the successes. Too many projects focus on defects, failures, or small cost over-runs without looking at the big picture and what was accomplished.

The Analyst Corner

John Van Decker, Research VP of Gartner, states:

"A single chart of accounts allows consistency in financial reporting across the enterprise by standardizing on common metrics and reporting structures, reduces dependencies on a separate financial consolidation system, and significantly reduces the costs incurred with ongoing, complex conversions and translations."