When you pour paint into a can, errors can happen. Pouring excess paint than the desired amount can result in wasting paint, not a good consequence for the Bodyshop. 

Paint Excess Report in MIXIT provides information about excess paint as a result of overpour (pouring outside the tolerance of recommended MIXIT amount) and recalculations (when MIXIT prompts to adjust the formula). Recalculations can result in higher adjusted amounts of paint. These excess pouring activities could be avoided with training and being more attentive. 

Access the report via Reports ==> Paint Excess.

Filters

You can filter the report using - 

• Painter - select the Painter whose mixes will be available in the report 
• Mix State - select the mix states you want in the report. E.g. you can exclude cancelled mixes if you are not interested in them. 
• Mix Type - select the required product categories 
• Date range - select the from and to dates using the calendar or use the slider below to adjust the dates. 

Charts 

Number of mixes over time 

This chart displays all the mixes over time. Right-click on the chart and select Drill down or Drill up options to change it - Daily, Monthly, or Yearly views. 

Number of overpours 

This chart displays the total number of overpours grouped per Painter. 

Number of recalculations

This chart displays the total number of recalculations grouped per Painter.

Average mix amount

This is the average mix amount per Painter. This helps you put things in perspective, the excess paint for a small desired amount could be perceived differently than for a large amount. 

Report FAQ

How fresh is the data in the Paint Excess report? 

It is not expected that the users will need very recent data while evaluating the report. Keeping this in mind, the data is refreshed every day. Any mix done today will take a day to reflect in the report. 

Can I print the report?

This report is an interactive dashboard, all the data in the report changes based on your interactions. It is not possible to print the report. 

I find a chart interesting, what options do I have to work with it? 

Click on the chart and you will see more options on the top of the chart. A chart is any one visual within the report. 

Below is an explanation of the symbols. 

Upward arrow (⬆) - This can be used to drill up the data. Similarly, downward arrow can be used to drill down the data. 

Use the Focus Mode to look at the report in more detail.

Export data options lets you export the data in the given chart. Select the right format for export, either excel (.xlsx) or comma-separated values (.csv) format.