Standards vs Actual Analysis System

Completed
Standards vs Actual Analysis System — variance analysis preview card

Classic industrial-engineering variance analysis as software: engineered standards against actual performance, continuously.

Problem

Standards existed in engineering studies; actuals existed in production records. Comparing them was a manual exercise done occasionally, so drift went unnoticed for months.

Solution

A system that holds engineered standards alongside collected actuals and computes variances by product, line, and period — turning a periodic study into a standing report. Labor cost, productivity, and capacity views are built on the same data.

Impact

Standard-versus-actual drift became visible as it develops, pointing process-improvement effort at the largest verified gaps.

Built with

DjangoPythonMySQLPandas