Introduction

The KNPL Variance Project Dashboard has been developed as a strategic initiative to strengthen operational accuracy, transparency, and efficiency within Kansai Nerolac Private Limited (KNPL). The dashboard provides a consolidated view of input–output variances across tanks located in the New Solvent Yard, Old Solvent Yard, and Resin Yard.

In total, the solution monitors 12 tanks, enabling precise validation of stock positions and reconciliation of material flows. The core objectives are:

  • Accuracy in Opening Stock – Ensuring each tank begins daily operations with the correct stock balance.
  • Input–Output Reconciliation – Validating that the output from each tank is fully accounted for as inputs across receiving tanks, thereby ensuring consistency and eliminating discrepancies.

Through this initiative, KNPL reinforces its commitment to data-driven governance, process integrity, and operational excellence across critical production yards.

Scope

The scope of the Variance Project Dashboard covers:

  • Monitoring of 12 tanks across three operational yards: New Solvent Yard, Old Solvent Yard, and Resin Yard.
  • Daily opening stock validation for all tanks.
  • Continuous tracking of input and output flows, ensuring precise reconciliation.
  • Identification and reporting of deviations or variances for corrective action.
  • Providing stakeholders with a centralized, real-time view of stock movements and variances.
Objectives

The primary objectives of the dashboard are to:

  1. Enhance Accuracy – Minimize manual errors by automating stock validation and reconciliation processes.
  2. Improve Transparency – Offer a clear and consolidated view of material flows across all operational yards.
  3. Enable Proactive Decision-Making – Provide timely variance insights to enable quick corrective actions.
  4. Strengthen Compliance – Support adherence to internal control measures and best practices in stock management.
  5. Optimize Resources – Drive efficiency by reducing discrepancies and improving utilization of raw materials.