Performance Management Tools Help

Axalta Performance Management Tools serves two purposes:

  1. Database and Analyze Paint & Material KPI Metrics for all Axalta customers. 
  2. Database and Analyze Shop Financial Statements & Managerial Ratios for Axalta Business Councils and other Strategic Accounts.

The system has two parts:

  1. Manage Data – upload via CSV or directly add or edit in a web form.
  2. Analyze Data – evaluate data for groups of shops, MSO overall and per location.

Data for P & M comes from multiple sources:

  1. Gallons of Primer, Base and Clear can be entered directly from an end of month feed from Axalta’s ColorNet 2.0 (if connected to the internet).
  2. Liquid and Allied Purchases can be entered by the Axalta Distributor / Jobber assigned to the account (a link to the jobber form is available in the “Manage Data” section for the P & M Analyzer).
  3. Collision Sales, Paint Labor Sales, Paint Labor Hours, RO’s Closed, P & M Sales and all the shop profile information are provided by the shop (a link to the shop form is available in the “Manage Data” section for the P & M Analyzer).

Data for the Performance Analyzer has three sources:

  1. Data can be entered or edited in a web form per month per location.  This can be time consuming and possibly lead to re-keying errors.
  2. Data can be entered into the Axalta Translation Filter.  These filters are set up one time and then monthly data can be saved as the month you are entering, pasted into the values cells.  Assuming no new chart of accounts have been added and you include data for zero value cells in your output.  You merely verify and then save the file.  After saving in a dedicated directly, you go into the Axalta Performance Management Tool and upload the file per month for a year.  This entire process takes 3 minutes if the translation is the same.
  3. Axalta is working to have the data in the translation filter extracted directly from the management system for uploading directly to the Axalta PMT Tool.

TIP:  At the beginning of a fiscal year, consider adopting the Axalta standard chart of accounts.  This makes the translation process much easier.

Downloads