Development of Management Information System for Production Planning in Hot Forging Industry

Maide Sina Nur Demir; Nadide Gizem Gürson Dolar; Hadi Gökçen

Makale detayları

Development of Management Information System for Production Planning in Hot Forging Industry

Yazarlar:

Maide Sina Nur Demir | Nadide Gizem Gürson Dolar | Hadi Gökçen

Yayıncı:

Fırat University

Ana Başlıklar:

Bilgi Sistemleri Geliştirme Metodolojileri ve Uygulamaları

Dergi:

Fırat Üniversitesi Mühendislik Bilimleri Dergisi Vol.37 Issue 2, pp.823-838

Belge Tipi:

Makale

Yayın Tarihi:

9/2025

Belge Dili:

Türkçe

Document ID (Org No.):

2001357253

pISSN:

1308-9072

Anahtar kelimeler:

Özet:

 This study presents the design and implementation of a Management Information System MIS tailored to improve production planning efficiency in the hot forging industry. The developed system integrates core operational functionsincluding order tracking, inventory management, supplier coordination, and machine capacity planningthrough a VBA-based Excel interface, supported by relational database structures and data flow diagrams. The system was implemented in a manufacturing company operating in the hot forging and machining sectors. Its performance was evaluated using three key performance indicators KPIs and benchmarked against the companys existing Enterprise Resource Planning ERP system. The results demonstrate significant improvements, including a reduction in planning time by 60, a 30 decrease in planning-related production delays, and an increase in scheduling accuracy to 94. In addition to operational gains, the system provided enhanced flexibility and responsiveness to dynamic production conditions, contributing to process reliability and organizational agility. These findings align with recent literature emphasizing the role of MIS in driving digital transformation and decision support in industrial environments. Overall, the study offers a practical example of how MIS can serve not only as a planning tool but also as a strategic enabler in manufacturing, particularly in sectors with complex and variable production requirements like hot forging.

 This study presents the design and implementation of a Management Information System MIS tailored to improve production planning efficiency in the hot forging industry. The developed system integrates core operational functionsincluding order tracking, inventory management, supplier coordination, and machine capacity planningthrough a VBA-based Excel interface, supported by relational database structures and data flow diagrams. The system was implemented in a manufacturing company operating in the hot forging and machining sectors. Its performance was evaluated using three key performance indicators KPIs and benchmarked against the companys existing Enterprise Resource Planning ERP system. The results demonstrate significant improvements, including a reduction in planning time by 60, a 30 decrease in planning-related production delays, and an increase in scheduling accuracy to 94. In addition to operational gains, the system provided enhanced flexibility and responsiveness to dynamic production conditions, contributing to process reliability and organizational agility. These findings align with recent literature emphasizing the role of MIS in driving digital transformation and decision support in industrial environments. Overall, the study offers a practical example of how MIS can serve not only as a planning tool but also as a strategic enabler in manufacturing, particularly in sectors with complex and variable production requirements like hot forging.

 This study presents the design and implementation of a Management Information System MIS tailored to improve production planning efficiency in the hot forging industry. The developed system integrates core operational functionsincluding order tracking, inventory management, supplier coordination, and machine capacity planningthrough a VBA-based Excel interface, supported by relational database structures and data flow diagrams. The system was implemented in a manufacturing company operating in the hot forging and machining sectors. Its performance was evaluated using three key performance indicators KPIs and benchmarked against the companys existing Enterprise Resource Planning ERP system. The results demonstrate significant improvements, including a reduction in planning time by 60, a 30 decrease in planning-related production delays, and an increase in scheduling accuracy to 94. In addition to operational gains, the system provided enhanced flexibility and responsiveness to dynamic production conditions, contributing to process reliability and organizational agility. These findings align with recent literature emphasizing the role of MIS in driving digital transformation and decision support in industrial environments. Overall, the study offers a practical example of how MIS can serve not only as a planning tool but also as a strategic enabler in manufacturing, particularly in sectors with complex and variable production requirements like hot forging.

 Bu çalışmada, üretim planlama süreçlerinin etkinliğini artırmak amacıyla yönetim bilişim sistemleri YBS bakış açısıyla bir bilgi sistemi tasarlanmış ve sistemin bir işletmede uygulaması gerçekleştirilmiştir. Geliştirilen YBS tasarımı kapsamında; işletmenin sipariş takibi, stok yönetimi, tedarikçi entegrasyonu ve makine kapasite planlaması gibi işlevleri, VBA tabanlı Excel araçlarıyla entegre edilmiştir. Veri akış diyagramları ve ilişkisel veri tabanı yapıları kullanılarak sistematik bir çözüm oluşturulmuş ve işletmede uygulanmıştır. Oluşturulan yeni üretim programına ilişkin verilerin sonuçları, işletmenin kullanmakta olduğu Kurumsal Kaynak Planlaması ERP üzerindeki veriler aracılığıyla kıyaslanmış ve işletmenin üç ayrı Temel Performans Göstergesi KPI kullanılarak karşılaştırılmıştır. Uygulama sonucunda işletmenin üretim planlama süreçlerinde önemli iyileştirmeler sağlanmış ve operasyonel verimlilik artırılmıştır. YBSnin etkin kullanımı sayesinde süreçler daha sistematik ve kontrollü hale gelmiş, planlama kaynaklı aksaklıklar büyük ölçüde azaltılmıştır. Ayrıca, geliştirilen sistem, değişen üretim koşullarına hızlı uyum sağlayarak süreç yönetimini daha esnek ve etkili bir şekilde desteklemiştir. Sonuç olarak, bu çalışma, YBSnin üretim planlamada nasıl bir destek mekanizması olarak kullanılabileceğini göstermiş ve süreçlerin iyileştirilmesine önemli katkılar sunmuştur.

Makale detayları

Development of Management Information System for Production Planning in Hot Forging Industry

Yazarlar:

Maide Sina Nur Demir | Nadide Gizem Gürson Dolar | Hadi Gökçen

Yayıncı:

Fırat University

Ana Başlıklar:

Bilgi Sistemleri Geliştirme Metodolojileri ve Uygulamaları

Dergi:

Fırat Üniversitesi Mühendislik Bilimleri Dergisi Vol.37 Issue 2, pp.823-838

Belge Tipi:

Makale

Yayın Tarihi:

9/2025

Belge Dili:

Türkçe

Document ID (Org No.):

2001357253

pISSN:

1308-9072

Planning

management information systems (MIS)

hot forging

data flow diagrams

process optimizationÜretim planlama

yönetim bilişim sistemleri (YBS)

sıcak dövme

veri akış diyagramları

süreç optimizasyonu

Sayı

Makale detayları

Yazarlar: Maide Sina Nur Demir | Nadide Gizem Gürson Dolar | Hadi Gökçen

Yayıncı: Fırat University

Ana Başlıklar: Bilgi Sistemleri Geliştirme Metodolojileri ve Uygulamaları

Dergi: Fırat Üniversitesi Mühendislik Bilimleri Dergisi Vol.37 Issue 2, pp.823-838

Belge Tipi: Makale

Yayın Tarihi: 9/2025

Belge Dili: Türkçe

Document ID (Org No.): 2001357253

pISSN: 1308-9072

Sayı

Yazarlar:

Maide Sina Nur Demir | Nadide Gizem Gürson Dolar | Hadi Gökçen

Yayıncı:

Fırat University

Ana Başlıklar:

Bilgi Sistemleri Geliştirme Metodolojileri ve Uygulamaları

Dergi:

Fırat Üniversitesi Mühendislik Bilimleri Dergisi Vol.37 Issue 2, pp.823-838

Belge Tipi:

Makale

Yayın Tarihi:

9/2025

Belge Dili:

Türkçe

Document ID (Org No.):

2001357253

pISSN:

1308-9072