Competitive Edge: Your Accounting System

The Toronto Globe and Mail ran a story about Analytics, saying that a company's statistics can be a powerful tool in the right hands. Harvey Schachter, the Globe's "Monday Manager" quoted from Competing On Analytics, a Harvard Business School book by Davenport and Harris, which highlights the need to have the right data and the right management support in order to reap the rewards of good analysis.

How well I know that story. Every time I implement Microsoft Dynamics (Great Plains or Navision), I offer the client the ability to integrate operational data in the accounting system, but I am rarely taken up on the offer. One glowing exception was a felt manufacturer where the President had a one page report of key performance indicators that he used to run his business. It was quite a challenge to make the new system fit the summary cash, balance sheet, income statement and statistics (with a separate column for each subsidiary) onto one page, but it was worth it!

Try this: picture your company as a sports franchise competing in the major leagues. What statistics would help you manage the team? Think in terms of:

• Output: How much do you really earn per unit, after all discounts?
  
• Input: How much waste is there, and at what stage does it occur?
  
• Human Resources: How many hours go into your product or service? How high or low is your utilization?
• Equipment: How long do your machines sit idle?

Often managers feel they know the answers to this type of question already. As the Production Manager of a tool and die shop said to me, "You're not going to replace me with a computer!" when I implemented a job tracking program for the General Manager. But that same manager was really surprised at how busy his plant turned out to be. He had been considering whether to replace his older drill presses with computer aided equipment, but he ended up keeping both the old and the new equipment when he saw the report of his order backlog.

Even if you have an older accounting system, you would be amazed at the quality of report that can be obtained from standard microcomputer software such as Crystal Reports or even Excel, when they have detailed financial and operational data to work with.