KPI Book Sample
KPI Book Sample
KPI Book Sample
The
KPI . . .
Book
Published by:
ISBN: 0-9540259-0-3
Introduction 11
How to use this book 12
Interpreting your Sales Department 19
Typical Sales Department Structure 20
% Value of Stock Over 90 days 21
Adopted Stock 22
Advertising Cost per Unit Sold 23
Annualised Sales 24
Annualised Sales per Salesperson 25
Average Selling Price 26
Cost of Overage Stock (Used Vehicles) 27
Days Supply (New Vehicles) 28
Days Supply (Used Vehicles) 29
Departmental Expenses 30
Departmental Profit % 31
Direct Expenses 32
Direct Profit % 33
Finance Commission per Unit 34
Finance Penetration 35
Gross Profit – New Vehicles 36
Gross Profit - Used Vehicles 37
Lost Opportunity Costs (Used Vehicles) 38
New:Used Retail Ratio 39
Conclusion 223
Most people do not work with KPI every single day and
because of this fact, you need a simple and effective
reminder of their meanings so that you can correctly
interpret your dealership information.
At the top of the page, the first thing that you will see is
the name of the Key Performance Indicator printed in
bold letters.
Example:
(A) Actual Days in Stock = 87
(B) Current Stock Turn = 35 Days
(C) Failed to sell = 2.49 times (A ÷ B)
(D) Average Gross Profit = £1,500
(E) Lost Opportunity Cost = £3,735 (C x D)
Example:
(A) Used Vehicle Gross Profit = £480,000
(B) All Used Vehicle Expenses = £160,000
(C) Used Vehicle Profit = £320,000 (A - B)
(D) Used Vehicle Stock Value = £460,000
(E) Return on Investment = 69.56% (C ÷ D x 100)
Example:
(A) Annualised used vehicle sales = 945
(B) Number of units in used vehicle stock = 90
(C) Annual Stock Turn = 10.5 (A ÷ B)
If you ignore Stock Turn, then all your profits could leak
out of your business just as easily as water leaking from a
colander because with the passing of time, your costs
become larger and your profits become smaller.
Example:
(A) Hours Attended = 320
(B) Hours Worked = 304
(C) Hours Idle = 16 (A - B)
(D) Prime labour Cost = £8.50
(E) Idle Time = £136 (C x D)
Example:
(A) Hours Worked = 957
(B) Hours Attended = 1,040
(C) Utilisation = 92% (A ÷ B x 100)
Attended Hours
Utilisation
This is the invoice value of the parts sold less the cost of
those parts. Generally, this is expressed as a monetary
value and also as a percentage of the total sales value.
Example:
(A) Parts Sales = £695,688
(B) Cost of Sales = £507,852
(C) Parts Gross Profit = £187,836 (A - B)
Example:
(A) Annualised Parts Purchases = £695,688
(B) Parts Stock Value (at cost price) = £115,948
(C) Total Parts Stock Turn (per year) = 6 (A ÷ B)
Special note:
Total Parts Stock Turn is the KPI that is shown on most
reports. When you want to measure how effectively your
parts stock is being utilised then you need to measure
True Parts Stock Turn.
Example:
(A) Hours Sold = 1,083
(B) Hours Worked productively = 958
(C) Productivity = 113% (A ÷ B x 100)
Example:
(A) Hours booked as WIP = 216
(B) No of Productives = 6
(C) Hours Attended in 1 day = 8 (Per Productive)
(D) Work In Progress Days = 4.5 Days (A ÷ B ÷ C)
Current Ratio
Net Profit Before Interest %
Circulation of Funds Employed
Return on Funds Employed %
Circulation of Current Assets
Baseline: 100% +
Example:
(A) Direct Profit from Aftersales = £1,154,223
(B) Company Overheads = £1,452,238
(C) Sales Semi-Fixed Expenses = £189,364
(D) Total Company Overheads = £1,641,602 (B + C)
(E) Overhead Absorption = 70.31% (A ÷ D x 100)
(F) Value of under Absorption = £487,379 (D – A)
Example:
(A) Aftersales Debtors = £120,624
(B) Aftersales daily turnover* = £2,805
(C) Debtor Days = 43 days (A ÷ B)
Note:
In order to calculate the Aftersales Daily Turnover, you
will need to take the annualised Aftersales turnover sold
on credit and divide that figure by 365 to arrive at a daily
sales turnover.
Example:*
(A) Aftersales Turnover On Credit = £1,023,825
(B) Days in 1 year = 365
(C) Aftersales Daily Credit Turnover = £2,805 (A ÷ B)
Example:
(A) Interest-Bearing Borrowings = £4,541,263
(B) Net Worth = £5,342,663
(C) Gearing Ratio = 0.8:1 (A ÷ B)
When Gearing goes over and above 1:1 this is the time
when you may experience increasing pressure from the
bank to repay some of your loans. After all, the bank
does not want to put more money into your business than
you have invested yourself.
Example:
(A) Net Profit Before Interest = £508,327
(B) Funds Employed = £2,420,610
(C) Return On Funds Employed = 21% (A ÷ B x 100)
Email: [email protected]