D DPC Solutions Web Tools

1. DDPC Solutions Web Tools

2. DPC Solutions Web Tools • All shop data is stored on a secure server which requires a Solutions Web tool login. • The data collected will provide detailed reports based on business council groups, added value member groups, mega dealer groups, OEM franchise lines, etc. and provide comparison reports within each group and to industry KPIs

3. CONNECT TO DPC PORTAL www.performancecoatings.dupont.com

4. Login Page - www.performancecoatings.dupont.com Login in to DPC Portal

5. Portal Path To Solutions Tools Select DPC Solutions Link

6. Secure Login Page Select Management Tools Link Enter Secure Password

7. Select the shop to view Select shop to view Note: Only your shop will be listed or all of your shops if owner of several shops

8. Select the tool to view Select which tool to view

9. Business Analysis Tool

10. Business Analysis Tool • The Business Analysis Tool is designed to allow collision repair shops to input their financial data and key performance indicators into a web based tool that will enable them to compare their shop to others in their group and to industry benchmarks.

11. Business Analysis- Sales Input Enter monthly sales and click update

12. Business Analysis - Cost Input Enter costs and click update

13. Business Analysis - Fixed Expense Input Enter individual expense amounts or enter total fixed expenses into misc. field Enter I

14. Business Analysis - Fixed Expense Input Enter individual expense amounts or enter total semi-fixed expenses into misc. field

15. Business Analysis - Metric Input Enter shop metrics and click update

16. Business Analysis - Report Selection Select which group report to view. Then click generate report.

17. Business Analysis - View Reports Click on Expand All to view all reports.

18. Business Analysis - Quarterly Report Report is shown for each Quarter YTD Projected YTD and Projected YTD Group Average

19. Business Analysis - Quarterly Report Quarterly report continues with costs, total gross profit, expenses, and net profit

20. Business Analysis - Quarterly Report Quarterly report continues with metric data

21. Business Analysis - KPI Report Key KPI Report Report compares user numbers to Group average and to Industry Benchmarks

22. Business Analysis - Sales Reports Percent to Sales Report Average Sales Report

23. UPLOADING FROM PROFITNET

24. Uploading to Solutions Business Analysis Tool Click on BDM Report within the ProfitNet folder

25. Uploading to Solutions Business Analysis Tool Select the month Click on generate Data

26. Uploading to Solutions Business Analysis Tool Enter the extra data needed

27. Uploading to Solutions Business Analysis Tool Click on Transmit

28. Proficient Repair Analysis

29. Proficient Repair Analysis Tool • The Proficient Repair Analysis Tool is designed to allow collision repair shops to perform a self audit on the procedures of their repair process. The customer answers questions as “never, sometimes, or always”. The tool provides best practice recommendations for any question where they have answered “never or sometimes”

30. PROFICIENT REPAIR ANALYSIS TOOL Categories covered

31. PROFICIENT REPAIR ANALYSIS TOOL AUDIT EXAMPLE Score the best practice tasks as “never done, sometimes done, or always done”

32. PROFICIENT REPAIR ANALYSIS TOOL RECOMMENDATION REPORT Questions answered with a “Never or sometimes” will create action items of what to do

33. PROFICIENT REPAIR ANALYSIS TOOL SCORE CARD REPORT View scores from previous audit vs current audit

34. New Tools Available 1/1/06 • New Solutions Web tools now available: • Booth Capacity Analyzer • Booth Energy Calculator • Booth Profitability • Sales Potential • KPI Tracking

35. Booth Capacity Analyzer • Purpose – To determine the maximum sales capacity of a downdraft spray booth • Input – Average monthly data on Sales Dollars, Number Vehicles Delivered, and Labor Rate. Number of Spray Booths, Hours of Operation P/Day, Number of Spray coats of Sealer, Basecoat, and ClearCoat. Number of Minutes to Spray each Coat, Flash Times, Booth Loading and Unloading Time, and Bake Time. • Output – Potential Monthly Sales vs Actual Sales • Value – Determine the impact of changes in product and/or processes • Frequency – Once per quarter

36. $praybooth Energy Calculator • Purpose – To determine the energy costs of operating a spray booth. • Input – Booth Statistics, Unit Fuel Costs, Spray Conditions • Output –Energy Costs per year per booth. • Value – Allows the shop owner to understand the impact of unit fuel costs and spray conditions on the cost of operating a spray booth. • Frequency – Once per quarter

37. Booth Profitability • Purpose – To calculate the gross profit of sales based on booth through put • Input – Number of cars put through, booth operating hours,redos, average RO, Average RO Gross Profit • Output – Annual Gross Profit • Value – determines expected gross profit per booth • Frequency – As needed

38. Sales Potential • Purpose – To calculate the potential sales increase by increasing manpower efficiency • Input – Number of Techs, Man hours, Current & Target Efficiency & Labor Rate • Output – Potential Increase in Sales • Value – Creates a targeted efficiency to achieve the desired sales increase • Frequency – Once per quarter

39. KPI Tracking Tool • Purpose – To track the shop’s sales, costs, gross profit, employee efficiency, and closing ratios in an effort to identify areas for improvement • Input – Monthly Sales and Costs of Labor, Parts, P&M, Sublet. Hours Attended, Hours Sold, Estimates Written, and ROs Closed • Output – Analysis of Gross Profit % , Gross Profit Dollars, Efficiency Ratios, Closing Ratios vs Industry Benchmarks, and Graphic Illustrations • Value – Highlights areas for improvement • Frequency – Once per month

40. THANK YOU