Transcript ipro 312 presentation final - Omega

Information Systems
Analysis &
Applications for
Small Manufacturing
IPRO 312
December 3, 2004
Fall 2004 IRPO Day
Illinois Institute of Technology
In Cooperation with
William Maur
Buhrke Industries
Illinois Institute of Technology
Project Overview
Tool Repair Request
System
Barcode Scanner
System
 Problem
 Objective and Reasoning
 Proposed Solutions
 Research Methodology
 Buhrke’s Feedback
 Access/Web Solution
 Obstacles Encountered
 Overview of Application
 Next Step
 Critical Obstacles
 Summary of Findings
 Next Step
Tool Repair Request
System
IPRO 312
Problem Detail
 400+ tools at Buhrke
 Company is growing
 No current reporting
system
 Production department unaware of tool availability
Benefits of tracking:
 Ability to run history
reports
 Based off of history, preventative maintenance can
be done to reduce tool
downtime
 Alert system
 Notify tool room when specific actions need to be
taken
Proposed Solutions
 SQL database with VB front end
application
 Would require SQL server license/training
 VB license for development/troubleshooting
 Access database with VB front end
 Complete Access application like current
Buhrke database
 Could use either Access with VB runtime or
custom VB front end
 Access database with Web front end
 Platform Independent, only an HTML browser
needed for clients
 Access based like current database
Buhrke’s Feedback
 SQL Solution
 No current SQL license, prefer Access
 Not many users expected at first
 Access/VB Solution
 No VB license available if Buhrke wanted to
change code
 Versions of Access differ from PC to PC
 Access/Web Solution
 Security might be an issue, only certain users
should be able to access, currently no centralized security at Buhrke
Solution – Access/Web
 Access with Web front end
 Platform independency
 Current IT staff knowledgeable with
Access and HTML
 Security issue: controlled with NTFS
permissions on web server
Obstacles Encountered
 Current Buhrke database only runs in
Access 95
 Buhrke’s business software, Vantage,
has too much overhead for integration/
difficult to integrate
 No current complete process in place
Application Design
Access DB ODBC Connection
IIS 5.0/6.0
Application Screens
Tool Info
Tool Listing
Tool Info
Application Screens
Request/Repair Forms
Request Form
Repair Form
Application Screens
Alerts
Next Steps





Add Scheduler front end
E-Mail notifications
Reporting
Lookup by Tool Number/Part Number
Form validation
Bar Code Scanner
System
IPRO 312
Objective
 Automate the receiving system
for raw materials at Buhrke
Industries.
 Usage of bar code scanner for…
 More efficient receiving
 Time saving
Why?
 Current receiving
process is done
manually.
 Slower process
 Slower Material
availability
update
 Harder
traceability of
materials
Tasks
 Extensive research on
various RF (Radio
Frequency) and Batch
scanners
 Present scanners that
are best suited for
receiving process
 Creation of Material
Tag and traceability
for future reference
Research Methodology
 Understanding
manufacturing process
from receiving to
shipping
 Research on company’s
database software
(Vantage)
 Generation of Move
Tags
Critical Obstacles
 Changing project definition
 Incompatibility of Vantage 5.1
with barcode scanners (data
transfer)
 Long distance between IIT
campus and Buhrke Industries
(limited visits to the company)
Summary
 Barcode Module would add
barcode capabilities to Vantage
5.1
 Batch scanners best suited for
company’s need were presented
 Move Tag created from Vantage
Next Step
 Research on Bar Code
Module
 Implement and test
the system using
Vantage
More Information
 To learn more about this project,
please visit our IPRO 312 website
at:
http://www.iit.edu/~ipro312f04
Acknowledgment
 Faculty Advisor:
Will Maurer
 IPRO Team:
 Tool Repair Team:
Mark Sami (Team Leader)
James Savaiano
Milena Tzakova
Michael Wyrick
Gueorgui Moutaftchiev
*Special
 Bar Code Scanner Team:
Erica Fierro (Team Leader)
Jose Contreras
Nasir Mahmoud
Seung Kwon (Mike) Choi
Baltazar Zamudio
Imran Sajwani
Thanks to: Tom Sikorski (plant manager) and Victor
Rodriguez (Technician). Also the tech support staff at
Vantage for their cooperation. All our guests today for being
here.