Production Data Collection and Analysis
Client Type:
Manufacturing Facility
Primary Reason for Initial Consultation
Executive and strategic analysis of production information was consistently held up by fragmented and inaccurate data.
Situation
Plant production numbers were managed through a combination of Microsoft Excel files, Microsoft Word documents, hand written notes, and email correspondence.
Supervisors were responsible for their own collection of data which was resulting in varied formats and frequently required clarification when assembling summaries
Reports were inconsistent in format and reliability
Solution
Based on some conversation, example reports and data files, we proposed and developed a secured internal web application. Functionality was divided into three user roles; data entry, reporting, and administrative.
Data Entry Role
- Provides a simple form with appropriate selection lists, validated numerical fields, and text based fields
- Forces users to enter information consistently
Reporting Role
- Provides push button access to numerous reports, charts, and data analysis functionality using real-time information.
- Reports are consistently formatted independent of the person retrieving the report.
- Appropriate data filters are provided to focus on more specific information when necessary.
Administrative Role
- Allows the user to maintain selection list data
- Provides an ability to edit data if necessary
- Add or remove users and assign user roles
Results
Data entry needs are focused and completely defined with an estimated
86 hours/month savings
Reports are now be accessed instantly at the push of a button with an estimated
41 hour / month savings
Return on Investment* |
||
1 Year Savings |
$102,108 |
|
3 Year Savings |
$306,324 |
|
5 Year Savings |
$510,540 |
|
*Yearly Savings = 127 hour/month * 12 month * $67/hour = $102,108 / year |
||
Free Gap Analysis
Schedule a complimentary automation analysis of your facility, office, or department. This $397 value includes:- Initial Phone Consultation
- Written Assessment
- Post Assessment Consultation
- Newsletter Subscription
"John designed and developed an impressive web based application that gave us a centralized location for data entry and scheduling adjustments" |
|||
 |
|
||
"...this application provided a simple powerful report generator that created complex scheduling matrices at the push of a button" |
|||
|
|
||
"The projects he undertook were significant, both in scope and success. The projects impacted virtually every department in the company; Operations, Sales, Engineering, and Human Resources" |
|||
 |
|
||
"It is clear that John has the knowledge, experience, and expertise to understand problems not just from a technical point of view, but also from a business and manufacturing perspective." |
|||
|
|
||
"These applications allowed us to create a multitude of reports and charts at the click of a button for our facility’s own use as well as required reports for our corporate office." |
|||
|
|||
"John is personable, forward thinking and the results he produced were always welcomed by me and my staff." |
|||
|
|||
"...this multi-user application made things noticeably easier and provided fast accurate reports required for quality audits as well as OSHA and State requirements." |
|||
 |
|
||
"This complete process, from initial discussion to final product, was handled with an obvious understanding of our needs and obvious respect for our time." |
|||
|
|
||