Example: dental hygienist

Key Performance Indicators (KPI) for Parts Managers

2 Webinar Series Key Performance Indicators (KPI) for Parts Managers De mystifying the Financial Statement! Thursday, November 14th, 2013 Presented by Sebastiano Banchitta, CPA and Rob Campbell, Analyst The Mironov Group, LLC CPAs and Automotive Consultants Welcome and Agenda! The Key Performance Measurements in Parts , how to calculate them, what they mean and how to improve them. Financial Performance Inventory Performance _____ _____ _____ Page 2 11 NOV13 10:46 HOT DOG HONDA MOTORS HDH-I. (RGPS) Gross Profit by Source (01 OCT13-31 OCT13) Page No: 1.

2 Webinar Series Key Performance Indicators (KPI) for Parts Managers De‐Mystifying the Financial Statement! Thursday, November 14th, 2013 Presented by

Tags:

  Performance, Part, Indicator, Key performance indicators, For parts, Mystifying

Information

Domain:

Source:

Link to this page:

Please notify us if you found a problem with this document:

Other abuse

Transcription of Key Performance Indicators (KPI) for Parts Managers

1 2 Webinar Series Key Performance Indicators (KPI) for Parts Managers De mystifying the Financial Statement! Thursday, November 14th, 2013 Presented by Sebastiano Banchitta, CPA and Rob Campbell, Analyst The Mironov Group, LLC CPAs and Automotive Consultants Welcome and Agenda! The Key Performance Measurements in Parts , how to calculate them, what they mean and how to improve them. Financial Performance Inventory Performance _____ _____ _____ Page 2 11 NOV13 10:46 HOT DOG HONDA MOTORS HDH-I. (RGPS) Gross Profit by Source (01 OCT13-31 OCT13) Page No: 1.

2 <---------- 31 OCT13 ----------> <------- Period to Date Totals -------->. Total Total Gross Gross Total Total Gross Gross Source Sales Cost Profit Profit% Sales Cost Profit Profit%. ------ ------- ------- ------- ------- ---------- ---------- ---------- ------- 500 N/A 600 5, 9, 3, 601 2, 24, 3, 1, 41, 17, 602 15, 26, 11, 603 6, 13, 6, 604 3, 8, 4, 605 23, 1, 48, 25, 800 15, 18, 3, 900 17, 2, 1, 36, 19, 999 N/A ------ ------- ------- ------- ------- ---------- ---------- ---------- ------- Totals 4, 112, 8, 3, 203, 91, Year to date sales of $1,737,024 with a gross of $733.

3 374 Our Profile averages Honda store CP 42% Express 34% Wty 28% Internal 35% Counter 35% Wholesale Collision 17% Mech 22% Tires 15% GOG 30% _____ _____ _____ Net to Sales $187,742 $1,737,024 = Net to Gross $187,742 $733,374 = _____ _____ _____ Page 3 Cost of sale and variations _____ _____ _____ Matrix and Mark ups Selling Price = Cost (1 Desired Gross Profit) $100 part , 35% gross $100 (1 .35) $100 .65 = $ $ $ = 35% Matrix should intersect with mark up and unit/volume sales _____ _____ _____ Personnel Expenses _____ _____ _____ Page 4 Staffing Levels Gross per departmental employee Gross per counterperson Piece movement _____ _____ _____ Semi Fixed/Operating Expense _____ _____ Getting back to Net Gross Expenses (personnel, semi fixed, fixed) = Net 100% (35% + 33% + 12%) = 20% _____ _____ _____ Page 5 Inventory measurements Gross Turn Ratio of sales to inventory Sales (at cost)

4 For 12 months Inventory Or days supply 365 (days) Turns True Turn Ratio of purchases to inventory ( stocked inventory turns ) Stock Order Purchases (at cost) for 12 months Inventory _____ _____ _____ NS Parts and their impact NS Inventory $ Total Inventory $ NS Parts Sales Efficiency (Month's NS Sales Month's NS Receipts) x 100 _____ _____ _____ Inventory Age Current _____ Technically Obsolete _____ Obsolete _____ _____ _____ _____ Page 6 Level of Service The R&R definition YTD Total Sales (at Cost) YTD Emergency, Orders, Lost(non stock) YTD Total Sales (at Cost) + YTD Lost Sales The ADP definition (Sales Closing Ratio) Sales Closing Ratio = (Net Sales Total Demand) x 100 Total Demand = Net Sales + Lost Sales _____ _____ _____ THANKS FOR LISTENING!

5 ! You can reach me at anytime Page 7 15 OCT2013 10:34:13 CAMPBELL CADILLAS OF NEW JERSEY CCN-I. 302 SEP013 Month End SEP 2013 MONTHLY SUMMARY REPORT Page 1. Grand Total NBR OF Parts PERCENT Parts PIECES PERCENT Parts COST PERCENT. ------------ ------- ------------ ------- -------------- ------- Inventory Balance 21,275 13,044 255, Active Parts 1,604 7,188 124, NS Parts 17,337 1,913 43, MO Parts 1 15 AP Parts 1,938 3,541 78, DP Parts 167 387 9, SP Parts DEL Parts 228 Parts With No Cost 72 25 Parts With Negative On-Hand 19 145 -1, Core/Exchange 82 120 10, Memos On File 2,045.

6 Parts Added 657 95 3, Active Parts 8 13 NS Parts 649 82 2, MO Parts AP Parts DP Parts SP Parts Parts & Memos Deleted 149. Inventory Movement - Sales 0 to 3 Months 4,667 7,661 120, 4 to 6 Months 2,143 1,046 24, 7 to 12 Months 3,442 1,342 34, Over 12 Months 8,543 2,502 63, New Parts No Sales 2,480 493 12, Inventory Movement - Receipts 0 to 3 Months 4,649 6,879 122, 4 to 6 Months 2,226 1,274 34, 7 to 12 Months 3,560 1,948 35, Over 12 Months 8,478 2,868 62, New Parts No Receipts 2,362 75 Outstanding Orders 61 1,166 7, Stockorders 41 1,138 5, Supplemental Orders Customer Orders 12 15 1.

7 Backorders 10 13 Stockorder Backorders 2 5 Supplemntl Backorders Customer Backorders 8 8 Outstanding Forced Orders 15 OCT2013 10:34:13 CAMPBELL CADILLACS OF NEW JERSEY CCN-I. 30 SEP2013 Month End SEP 2013 MONTHLY SUMMARY REPORT Page 2. Grand Total NBR OF Parts PERCENT Parts PIECES PERCENT Parts COST PERCENT TRANS COUNT. ------------ ------- ------------ ------- -------------- ------- ----------- Gross Sales 1,865 7,571 198, 4,422. Regular 1,691 6,862 176, 4,031. No History Drop Ship Wholesale 226 703 21, 385. Wholesale No History Wholesale Drop Ship Warranty 6 6 6.

8 Warranty No History Warranty Drop Ship Lost Sales 75 122 7, 77. Return Sales 356 887 28, 432. Regular 308 700 25, 371. No History Defective Wholesale 49 187 3, 61. Wholesale No History Wholesale Defective Warranty Warranty No History Warranty Defective Receipts 1,565 7,068 181, 2,076. Stockorders 398 1,322 28, 584. Supplemental Orders Customer Orders 847 1,236 76, 883. Emergency Purchases 37 54 2, 38. Other Receipts 475 4,456 73, 571. Overages Net Adjustments 151 420 -9, 170. Plus 21 36 1, 30. Minus 130 384 -11, 140.

9 Factory Returns Net Appreciation 11 107 36. Positive 1 51 10. Negative 10 56 26. Parts Updated With Cost 2 2. Parts With Comments 345. Misc & Sublet Items Gross Sales Lost Sales Return Sales 1 1. Parts Not On File, But Sold Gross Sales 3 4. Lost Sales Return Sales 2 2. 15 OCT2013 10:34:13 CAMPBELL CADILLACS OF NEW JERSEY CCN-I. 30 JSEP2013 Month End SEP2013 ANNUAL ACTIVITY & BENCHMARK TREND REPORT Page 1. Grand Total YEAR-TO-DATE YEAR-TO-DATE LAST 12 MONTHS LAST 12 MONTHS. SEPTEMBER 2013 TOTAL AVERAGE TOTAL AVERAGE.

10 -------------- -------------- -------------- -------------- -------------- Number of Parts 21,275 120,086 20,014 221,481 18,457. Parts Pieces 13,044 79,009 13,168 144,637 12,053. Parts Cost 255, 1,505, 250, 3,033, 252, Parts With Negative OH -1, -9, -1, -22, -1, Core/Exchange 10, 67, 11, 148, 12, Gross Sales 198, 1,221, 203, 2,504, 208, Net Sales 169, 1,037, 172, 2,066, 172, Lost Sales 7, 63, 10, 120, 10, Outstanding Orders 7, 83, 13, 171, 14, Total Receipts 181, 1,118, 186, 2,251, 187, Customer Orders 76, 460, 76, 894, 74, Emergency Purchases 2, 5, 10, Net Adjustments -9, -87, -14, -207, -17, Net Appreciation 1, NS Parts Number of Parts 17,337 100,326 16,721 182,260 15,188.


Related search queries