Sjogren Industries relied on manual scheduling to run overnight for two multitasking Computer Numerical Control (CNC) machines: the Okuma Multus and the Matsuura H-Plus 300. The goal of this project is to create a system that will automatically determine the optimal jobs to run overnight for each machine and display them in a way that is simple to understand. To accomplish this, our team utilized Microsoft Access and Microsoft Excel to create tools which sort customer order data, run optimization models, and display results in a manner consistent with Sjogren’s current operations. Our team successfully implemented these tools into Sjogren’s database, which generated schedules for running unattended jobs. Over a six-week pilot period, these tools achieved an approximate 44% increase in unattended hours compared to the previous year, and increased machine utilization over weekends as high as 100%. For future improvement projects, we recommend that Sjogren review its existing database system and data included within.

• This report represents the work of one or more WPI undergraduate students submitted to the faculty as evidence of completion of a degree requirement. WPI routinely publishes these reports on its website without editorial or peer review.

Creator

• Sniezek, Henry
• McGonigle, Conor
• Varela, Christian

Publisher

• Worcester Polytechnic Institute

Identifier

• 119128
• E-project-032224-100314

Palabra Clave

• CNC Machining
• AI
• Continuous Improvement
• Scheduling
• Optimization
• Manufacturing

Advisor

• Konrad, Renata

Year

• 2024

Sponsor

• Sjogren Industries

Date created

• 2024-03-22

Resource type

• Major Qualifying Project

Major

• Industrial Engineering

Source

• E-project-032224-100314

Rights statement

• In Copyright