การพัฒนากระบวนการจัดการและการติดตามวัตถุดิบสำหรับผลิตภัณฑ์ที่มีการเปลี่ยนแปลงโครงแบบในบริษัทอุปกรณ์ไฟฟ้าในเครื่องบินพาณิชย์

Abstract

The main goal of this research is to create a new tool and process that will allow for tracking and early notification of new material usage under configuration change at the Commercial Aircraft Electrical Inserts Company. Moreover, and as an additional goal this research looks into new ways of decreasing process of raw material trackimg in order to configuration changed product regarding data update in Enterprise Resource Planning (ERP), Engineering Database and Frist Article Inspection Report (FAIR) databases. A new program was developed by Microsoft Excel that allows to calculate production plan for new part configuration deployment and use Microsoft Visual Basic to design a user interface. The new tool presents two main functions. The first function as an overall material dashboard. Secondly, the tool provides a status of material by item number. After implementation of this new tool the raw material status can be successfully managed and tracked, with a decrease of overall activities 55%, Non Value Added (NVA) was decreased 9 processes, decresed 14% compared to current process. The new developed tool is able to present to the user, the new material production plan in a quick and convenient fashion as well as being able to track inventory status updates for related materials. Through its connection to several data bases the tool is able to provide information on: Purchased Order status, Production status, and status of First Article Inspection reports. By providing this information, the absence of FAIR is mitigated as the tool will alert when implementing new material configuration changes and by notifying the team in advance.