Problem:  Owner advised employee production in two key departments was too low and wanted a scorecard Managers could use with employee to address.

Solution:  Created Reports that provided numerous statistics summarized by employee, department, and or Product levels.  Converted Productive percentage and percentage of Standards into an equivalent A thru F ranking.

Results:   Based on the reports, Managers placed under-performing employees on Performance Improvement Plans (PIPs).  Over the course of 90 Days, some employees were terminated, others improved from C to A thru coaching.

Tools Used:  Excel Power Pivot.  Created ODBC links to automatically refresh Time Clock data fields in the Data Model.  Associated Tables in the Data Model with Standards provided by the Owner.  Documented instructions and exception reports in the model enabling Managers to run the report daily, scrub the data and review final reports for action with employees.  Published monthly comparative results with the monthly financial statements demonstrating to the Owner progress made and remaining action plans.