Can you afford to lose $30,000 to $60,000? That's how much is at stake if you don't measure business performance right. Here's some advice.
Producing a complete analytical financial statement may sound as desirable as having root canal, but it can be invaluable for a business when it’s fighting to defeat the rot and decay that can set in through years of accounting neglect.
Many shops need management to pay more attention to monitoring their business on a regular basis.
One of the best ways is through a full analytical financial statement.
Facts speak for themselves. But if you can’t measure it, you can’t manage it. Operating a modern shop today by just looking at the bank balance and sales compared to same month last year is not only archaic and inefficient, it’s a recipe for potential financial disaster.
Our own studies of actual repair business results shows that if a shop producing $400,000 to $450,000 in sales per year does not understand how to measure its performance accurately, it will lose from $30,000 to $60,000 in net income (net profit) per year.
Uncovering or recovering that amount of real money would be enough to attract the attention of anyone with a business. It might even make the prospect of completing a financial statement an attractive proposition.
The real value of a financial statement only becomes evident after it has been applied for a specific length of time.
For instance, a shop suffering from financial duress should produce a statement for at least 24 consecutive months.
This allows management to see the trends and see where profit is generated, or inotherwords, the major money-making sources for the operation.
All shops should produce at least a quarterly operating statement to ensure the operation is fully and accurately measured so that issues can be discussed intelligently.
Measuring a business once a year is inadequate because it’s too late to embrace opportunities. They have already past.
Basic elements of an Analytical Financial Statement are:
Total revenue in predetermined categories for the month (or quarter) and year-to-date
Gross Profit return measurement for each revenue category for the month (or quarter) and year-to-date
Expense categories for the month (quarter) and year-to-date
Net profit for the month (quarter) and year-to-date
Balance sheet compared to the previous accounting period (month or quarter).
Revenue Categories
The basic revenue categories that are measured today include, oil, tires, batteries, aftermarket parts, dealer parts, maintenance/mechanical labour and diagnostic labour.
Some shops will break this down even further such as customizing work into menu pricing categories such as alignments, exhaust etc.
Before one gets too complicated and confused, it is recommended to start with the seven initial categories mentioned.
By understanding the source of revenue for the shop, it becomes easier to measure performance against industry statistics.
It also allows you to determine what type of customer/client base you are serving.
For example, when measuring parts sales, if the shop sells 90% aftermarket parts and 10% dealer parts, traditionally it means the shop is repairing and working on older vehicles.
Conversely, if the shop is averaging 75% aftermarket parts, and 25% dealer parts, then clearly, the shop is working on more newer vehicles.
Each scenario has a different impact on the type of equipment and staff skills that are necessary to meet the demands of customers and achieve client satisfaction.
As the sales mix changes over the course of two to three years, either way, one can judge quite accurately the future demands of the shop in terms of staff training and equipment acquisitions.
Gross Profit Measurement
Gross profit return is critical to net profit performance. But once again, one must understand where the profit comes from.
The following guidelines work well to ensure one is on the way to a healthy bottom line.
The gross profit return for oil should be a minimum of 50%, however 60% to 65% is achievable through good management.
Here are other important gross profit guidelines:
Tires — 10 to 25% gross profit
Batteries — 35% gross profit
Aftermarket parts — as high as 50%
Dealer — Range from 18%to 25%
Maintenance/mechanical labour should average 90% gross profit and higher when technician wages are eliminated from the cost of labour and only sublet costs inserted into the labour cost
Diagnostic labour would show a 100% return.
Ensure that your gross profit percentage for oil, tires, batteries and parts is calculated using the correct accounting formula for cost of goods sold; which means you must insert the correct inventory numbers.
Cost of goods sold is calculated by taking the opening inventory plus purchases and subtracting the closing inventory. Dollar sales less dollar cost of goods sold equals dollar gross profit.
Dollar gross profit divided by dollar sales equal the gross profit percentage achieved.
When a shop only uses the purchase made, they are wrong in their calculations. Don’t be mislead or mislead yourself, use the correct accounting formulas. Shops should target to produce $1.20 in total labour revenue (maintenance and diagnostic combined) to $1.00 in total parts sales (aftermarket and dealer parts combined).
A shop should also work toward achieving a minimum of 10% (but preferably 20%) of its total labour revenue as diagnostic labour which is charged out at a higher tier rate.
When these guidelines are achieved and measured in this fashion, the shop will average 65% to 70% gross profit return from total sales in the service bays.
Expense Categories
It is important to take the time to customize the operating expenses of the shop to your needs and requirements.
What expenses should be measured and are important to you?
One way of setting up the entire wage expense is to break it out into technician wages, service advisor wages, administration wages, management wages and shop burden (benefits) such as CPP, EI, Workers compensation, group insurance etc.
One criteria for measurement is to produce $1.20 in total labour revenue to $1.00 in expense on all wages (including management’s) and benefits.
The balance of the shop expenses should be monitored and managed always with goal of answering the real question of whether the expenses are controllable, non-controllable or common sense expenses in relation to what the shop is trying to achieve in customer/client service and satisfaction.
I believe you will find, after a detailed analysis, that many of the operating expenses fall into the common sense category, which can be surprising. Ultimately, costs should always be viewed in terms of what the shop is trying to achieve in customer/client satisfaction.
Net Profit
Net profit seems to be an elusive figure to calculate for many shops. To get a true measure of net profit, management wage, or draw, has to be factored in. The objective should be to net 10% of the shops’ sales, before taxes, but after management wages or drawings.
When this is achieved, the capital is usually in decent supply to keep the shop well equipped not only with top equipment but also with top quality staff.
Balance Sheet
A complete and full balance sheet compared to the previous accounting period allows the management to see where the profit dollars were spent throughout the shop.
Some profit may be tied up in accounts receivable, inventory or equipment. Maybe some net profit was spent to reduce debt load or accounts payable.
Wherever it went, it is important to see how management is handling the profits made in the shop. It can only be accomplished with a full comparative balance sheet.
Accurate and complete information about the business means better management decisions and actions toward the business. Management decisions are always made with more confidence and conviction when the financial information is accurate.
Take the time to measure your business completely and accurately. It may shock you where net profit dollars can be found in your current business and with your current customer/client base.
Establish a more structured approach to managing your business.
Th
e biggest obstacle you face in achieving accurate financial figures for your business is often in changing the way you do things. Commit yourself to changing your management system tradition if your business performance results leave something to be desired. SSGM
SAMPLE OPERATING STATEMENT | |||||
THIS MONTH | |||||
SALES | COST | GROSS PROFIT | |||
$ | %-SL | $ | $ | %-GP | |
OIL | 3,251.60 | 3.1 | 1,186.83 | 2,064.77 | 63.5 |
TIRES | 11,670.70 | 11.0 | 9,663.34 | 2,007.36 | 17.2 |
BATTERIES | 2,038.72 | 2.0 | 1,374.09 | 664.63 | 32.6 |
AFTERMARKET | 32,054.31 | 30.3 | 20,098.05 | 11,956.26 | 37.3 |
DEALER PARTS | 14,000.73 | 13.2 | 11,368.59 | 2,632.14 | 18.8 |
LABOUR(MAINT) | 34,094.64 | 32.1 | 2,161.52 | 31,933.12 | 93.7 |
LABOUR(DIAG) | 8,626.72 | 8.1 | 0.00 | 8,626.72 | 100.0 |
OTHER | 394.00 | 0.2 | 275.80 | 118.20 | 30.0 |
TOTALS | 106,131.42 | 100.0 | 46,128.22 | 60,003.20 | 56.6 |
FINANCIAL STATEMENT | |||||
ASSETS | THIS MONTH | LAST MONTH | VARIANCE | ||
$ | $ | $ | |||
BANK-GENERAL | 50,664.55 | 44,868.56 | 5,795.99 | ||
BANK-SAVINGS | 0.00 | 0.00 | 0.00 | ||
CREDIT CARDS | 0.00 | 0.00 | 0.00 | ||
INVENTORY | 63,167.35 | 57,936.38 | 5,230.97 | ||
ACCOUNTS REC. | 27,195.01 | 23,601.16 | 3,593.85 | ||
PREPAID EXPENSES | 3,233.47 | 4,413.40 | -1,179.93 | ||
CORP. TAX INSTALL | 2,620.69 | 2,406.69 | 214.00 | ||
SECURITY DEPOSIT | 600.00 | 600.00 | 0.00 | ||
EQUIPMENT (8) | 188,042.33 | 190,043.93 | -2,001.60 | ||
VEHICLES (10) | 25,540.83 | 26,689.97 | -1,149.14 | ||
COMPUTER (10) | 3,348.00 | 3,348.00 | 0.00 | ||
SOFTWARE (12) | 1,393.20 | 1,393.20 | 0.00 | ||
GOODWILL | 6,463.22 | 6,463.22 | 0.00 | ||
TOTAL ASSETS | 372,268.65 | 361,764.51 | 10,504.14 | ||
LIABILITIES | |||||
SALES TAX | -7,830.72 | -4,639.08 | -3,191.64 | ||
PAYROLL TAX | -12,445.79 | -9,110.35 | -3,335.44 | ||
G.S.T. PAYABLE | -12,003.10 | -8,542.01 | -3,461.09 | ||
CORPORATE TAXES | 0.00 | 0.00 | 0.00 | ||
ACCRUED EXPENSES | 0.00 | 0.00 | 0.00 | ||
TRADE CREDITORS | -42,576.47 | -47,584.19 | 5,007.72 | ||
BANK LOAN | 0.00 | 0.00 | 0.00 | ||
SHARE ISSUED | -7,921.00 | -7,921.00 | 0.00 | ||
TOTAL LIABILITY | -82,777.08 | -77,796.63 | -4,980.45 | ||
NET WORTH | 289,491.57 | 283,967.88 | 5,523.69 | ||
MONTH | YTD. | ||||
NET WORTH CHANGE | 5,523.69 | 17,195.59 |
Fiscal Year-end: FEBRUARY | ||||||
YEAR-TO-DATE | ||||||
SALES | COST | GROSS PROFIT | ||||
$ | %-SL | $ | $ | %-GP | ||
OIL | 20,396.80 | 2.4 | 8,913.40 | 11,483.40 | 56.3 | |
TIRES | 83,414.80 | 9.8 | 74,072.34 | 9,342.46 | 11.2 | |
BATTERIES | 12,752.09 | 1.5 | 8,314.36 | 4,437.73 | 34.8 | |
AFTERMARKET | 260,605.93 | 30.7 | 166,787.79 | 93,818.14 | 36.0 | |
DEALER | 86,405.96 | 10.2 | 68,174.30 | 18,231.66 | 21.1 | |
LABOUR(MAINT) | 350,292.72 | 41.3 | 19,165.02 | 331,127.70 | 94.5 | |
LABOUR(DIAG) | 31,573.36 | 3.7 | 0.00 | 31,573.36 | 100.0 | |
OTHER | 3,143.36 | 0.4 | 2,134.34 | 1,009.02 | 32.1 | |
TOTALS | 848,585.02 | 100.0 | 347,561.55 | 501,023.47 | 59.1 | |
EXPENSE STATEMENT | ||||||
EXPENDITURES | THIS MONTH | YEAR-TO-DATE | ||||
$ | %-GP | %-SL | $ | %-GP | %-SL | |
TECHNICIAN WAGES | 22,090.00 | 36.9 | 20.9 | 171,641.60 | 34.3 | 20.3 |
SERVICE ADVISORS | 2,600.00 | 4.4 | 2.5 | 23,400.00 | 4.7 | 2.8 |
MANAGEMENT WAGES | 3,775.00 | 6.3 | 3.6 | 39,100.51 | 7.9 | 4.7 |
ADMIN. WAGES | 2,100.00 | 3.5 | 2.0 | 6,300.00 | 1.3 | 0.8 |
BURDEN | 1,129.64 | 1.9 | 1.1 | 15,930.81 | 3.2 | 1.9 |
WORKERS COMP. | 618.12 | 1.1 | 0.6 | 5,196.12 | 1.1 | 0.7 |
TRAINING | 0.00 | 0.0 | 0.0 | 1,530.00 | 0.4 | 0.2 |
LOAN INTEREST | 0.00 | 0.0 | 0.0 | 3,823.10 | 0.8 | 0.5 |
BANK CHARGES | 343.49 | 0.6 | 0.4 | 1,961.84 | 0.4 | 0.3 |
CASH SHORT (OVER) | 137.40 | 0.3 | 0.2 | 510.73 | 0.2 | 0.1 |
MAINT. & REPAIR | 49.59 | 0.1 | 0.1 | 6,408.87 | 1.3 | 0.8 |
RENT | 8,700.00 | 14.5 | 8.2 | 78,300.00 | 15.7 | 9.3 |
SUPPLIES/TOOLS | 1,198.34 | 2.0 | 1.2 | 17,418.19 | 3.5 | 2.1 |
VEH ICLE OPERATION | 1,610.53 | 2.7 | 1.6 | 16,635.48 | 3.4 | 2.0 |
EQUIP. LEASE/RENT | 558.32 | 1.0 | 0.6 | 5,024.88 | 1.1 | 0.6 |
DISC. & REFUNDS | 75.00 | 0.2 | 0.1 | 158.00 | 0.1 | 0.1 |
CRED. CARD DISC. | 2,679.25 | 4.5 | 2.6 | 20,041.99 | 4.1 | 2.4 |
LAUNDRY & UNIF. | 206.10 | 0.4 | 0.2 | 2,626.16 | 0.6 | 0.4 |
FREIGHT & DEL. | 0.00 | 0.0 | 0.0 | 0.00 | 0.0 | 0.0 |
BAD DEBTS | 50.00 | 0.1 | 0.1 | 122.39 | 0.1 | 0.1 |
BUSINESS PROMO. | 549.59 | 1.0 | 0.6 | 1,965.42 | 0.4 | 0.3 |
ADVERTISING | 364.54 | 0.7 | 0.4 | 6,626.16 | 1.4 | 0.8 |
INSURANCE | 686.98 | 1.2 | 0.7 | 13,878.49 | 2.8 | 1.7 |
LICENSES & TAXES | 1,854.85 | 3.1 | 1.8 | 16,686.32 | 3.4 | 2.0 |
ACCT. & LEGAL | 530.47 | 0.9 | 0.5 | 5,817.74 | 1.2 | 0.7 |
UTILITIES | 1,198.34 | 2.0 | 1.2 | 10,357.44 | 2.1 | 1.3 |
DEPRECIATION | 1,373.96 | 2.3 | 1.3 | 12,365.64 | 2.5 | 1.5 |
TOTAL EXPENSES | 54,479.51 | 90.7 | 51.4 | 483,827.88 | 96.5 | 57.1 |
NET PROFIT ***** | 5,523.69 | 9.3 | 5.3 | 17,195.59 | 3.5 | 2.1 |
DIVIDENDS PAID | 0.00 | 0.00 | ||||
CORP. TAX PAID | 0.00 | 0.00 | ||||
ADJ.TO NET WORTH | 5,523.69 | 17,195.59 |
Have your say: