Automated system for machine tool capacity and utilization

An automated system based on Symphony spreadsheet software has been developed to monitor machine tool utilization and capacity in a small- to medium-sized machine shop. This application compiles reports on annual machine tool requirements and use from production routing data for a shop producing over 100 different small machined parts with batch sizes ranging from 100 to 1000 parts and up to 25,000 parts per year. The operational routings for approximately 30 parts are currently stored in the system. Levels of utilization are analyzed, which aids in determining the need for addition equipment or multiple workshifts, and thereby helps balance the workload and product flow. Valuable information was compiled in a special report for layout of a new shop facility. Group technology cell arrangements of equipment were analyzed for capacity and utilization. Many Symphony spreadsheet and data base management features were used to produce this program. The final system incorporated menu systems for users unfamiliar with this spreadsheet software.