Capacity Planning & Tracking

Our Team developed a custom tool for a  global manufacturing client to track, analyze and report the production plant capacity plan vs. actual.

Benefits

Automated the excel based data collection, reporting to a self service BI apps with data collection, executive dashboards, reporting and ad-hoc analytics.

Solution:

Provide a dashboard that collects data from various sources and consolidates the data into one central location.

Features:

  • Dashboard – The chart shows total fleet capacity for 2012 including actual till month to date, based on last year, restarts, new lines and improved performance
  • Summary of annual performance goals; Fleet capacity show what is done and what is projected
  • Variance analysis, Report plant downtime and productivity reporting
  • Drill down to product, location, technology and plant level
  • Data verification and validation against database and excel based files
  • On-demand data loads

Technologies:

Microsoft SQL Server 2008, Qlikview, Microsoft EXCEL Files, SAP BW