Design And Implementation Of A Bill Of Materials Processing System
(A Case Study Of Emenite Nig ltd, Enugu))
A Bill of Materials Processing System serves as a comprehensive framework for managing and organizing the various components essential for manufacturing a product. This sophisticated system plays a crucial role in the intricate landscape of production, ensuring seamless coordination and meticulous documentation of raw materials, sub-assemblies, and final products. It facilitates efficient tracking of inventory levels, streamlining procurement processes, and optimizing resource utilization. The system’s capacity to integrate diverse datasets and synchronize information across different stages of production enhances transparency and accuracy. By fostering real-time collaboration among different departments, this system significantly contributes to enhancing operational efficiency, reducing errors, and ultimately contributing to the overall success of manufacturing processes.
With the trend of technology growth in the world of today, virtually every facet of human work has been affected; even the remotest of it all, and the production circle cannot be left out. This study was carried out to verify all the manual processes involved in bill-of-material processing system and to seek a way of automating the system for effective operations.
Since there is continuous moves towards technological advances that enhanced productivity of labour and free human beings of tasks done more economically by machines. Computer and its applications have become indispensable and vital tools in economic, industrial and social development of the advanced countries of the world. Nigeria as a developing country cannot afford to lag too far behind in this kind of revolution. Therefore there is every need to know in every discipline the areas, which attracts computerization and why they need it.
In this project, the software engineering principles were applied in the analysis, coding and testing of the software developed for the Bill-of-material processing. Serious attention was also give to the design of the user interface.
In the development of the software, visual basic programming language was used de to its support for all the features desired. A brief user’s guide is also provided. The end result is a software that is very effective and efficient in meeting it objectives and at the same time user friendly.
Title page
Certification
Dedication
Acknowledgement
Abstract
Table of contents
CHAPTER ONE
INTRODUCTION 1
1.1 Background of the study 1
1.2 State of the problem 2
1.3 Purpose of the study 3
1.4 Aims and objectives 3
1.5 Scope of study 5
1.6 Limitations of study 5
1.7 Assumptions 6
1.8 Definition of terms 7
CHAPTER TWO
LITERATURE REVIEW 8
CHAPTER THREE
3.1 Description and analysis of existing system 15
3.2 Fact finding method used 17
3.3 Organization structure 19
3.4 Objectives of Existing system 21
3.5 Input, Process and Output Analysis 22
3.6 Information Flow Diagrams 26
3.7 Problems of the Existing System 27
3.8 Justification of the New System 28
CHAPTER FOUR
4.1 Design of the New System 30
4.2 Input Specification and design 30
4.3 Output specification and design 32
4.4 File Design 34
4.5 Procedure chart 36
4.6 System flow chart 38
4.7 System requirements 40
CHAPTER FIVE
5.1 Implementation 42
5.2 Program Design 45
5.3 Program Flowchart 48
5.4 Pseudo code 54
5.5 Source Program: Test Run 59
CHAPTER SIX
Documentation 60
CHAPTER SEVEN
7.1 Recommendation 62
7.2 Conclusion 64
Bibliography 65
INTRODUCTION
1.1 BACKGROUND OF THE STUDY
The use of traditional approach in problems solving has really left some loopholes in life and this has encourage the introduction of computers in various fields of work including production in terms of keeping of bill of materials in production and most recently reordering of sales.
The Bill-of-material processing system has been in existence in many organizations though in a traditional approach. Introducing the computer system will greatly improve materials requirement planning in the following aspects.
(a) Reliability
(b) Validity
(c) Accuracy
(d) Appropriate storage of data
(e) Timeliness
The above factors are due to the fact that the computer possesses some great features, and advantages over traditional approach.
1.2 STATEMENT OF THE PROBLEMS
No doubt that the use of traditional system has created a lot of problems in production of roofing sheets at EMENITE. The quantity and amount of materials and sub-assembly needed to produce a product cannot be traceable because of glaring disadvantages stated below.
Poor information storage method: The use of office files and file cabinets is not a good form of information storage.
Insecurity of data because it is prone to vandalization and unauthroised accessibility
Duplication of data in various departments because of the nature of work needed
It takes a long time in accessing records in the manual system (filing system) due to the nature of the job. It is not always good for materials to finish unnoticed, so the re-ordering of materials are not made as and when due.
The introduction of the computer system will help eliminate these problems to an extent.
1.3 PURPOSE OF THE STUDY
This project is generally towards eradication of all the deformities and curb hookups of the manual method of bill-of-materials processing, thus developing a new system to handle the jobs involved in the processing of Bill-of-material electronically.
1.4 AIMS AND OBJECTIVES
In an organization whether manufacturing or not manufacturing where the competitors and the objectives of the organization are at the top of the scale of preference especially the meeting of the standard in the market, there is always a focus on the organizational goal which might not be the goals of the sub-system to avoid sub-optimality, working towards a divisional or individual benefits.
The aims of this work include the following;
(1) To work towards the elimination of ineffective modes of operation; it centers on the user having a good atmosphere for work thereby minimizing stress.
(2) The objective from the initiator of the proposal is generally towards combating al the aims and the problems being discovered on the existing system, which are listed under problem of study.
(3) Safeguarding of information through effective monitoring of access is the filing system (database).
(4) Knowing when materials are almost out of stock, in order to make an order so as not to show the production pace of the labourers.
1.5 SCOPE OF STUDY
The scope of this project work covers all the areas of bill-of-materials processing systems, which include the cost of individual material responsible for production, the stock control or inventory areas, and every other necessary areas. The storage of records, which have different fields that could be expanded a little to form files. These file five rooms for editing, updating and retrieval of information when needed. Some of these fields are item description, quality, total requirement, re-ordering point, labour cost, overhead cost, profit, lower cost, etc.
This project is focused on the entire information recorded on Bill-of-material processing for EMENITE NIGERIA LIMITED, EMENE, ENUGU STATE.
1.6 LIMITATIONS
The constraints that were highly against this study are as follows:
(1) Time Lag: the fact that the duration of the project work was little; the researcher would only cover little scope. The time for the researcher to combine academic works and project writing is also another limiting factor.
(2) Financial constraints: The researcher’s low financial backbone really affected the project writing. This stopped the researcher from traveling wide to industrialized areas like Lagos so as to meet with bigger companies instead of EMENITE.
1.7 ASSUMPTIONS
Sequel to insufficient information, the following assumptions were made:
The recording of Bills-of-materials has not been made
Hardware for the installation of the program or software is procured already
The people to use the systems are in the industry already.
1.8 DEFINITION OF TERMS
(1) Traditional Approach: The system of use of files, file jackets and file cabinets in the storage of records i.e. the manual way of storage of information.
(2) Record: Facts of a particular material and any other thing used in production.
(3) Field: An item of data within a record. It is made up of a number f character.
(4) Hardware: The physical component of a computer system e.g. keyboard.
(5) Software: The program in the hardware of the computer that instructs the system on steps to take in executing a giving task.
(6) File organization: The process or the way of arranging and maintaining files that are used for keeping of records.
(7) Flowchart: This is a diagrammatical representation of procedures taken in executing a given task.
SHARE PROJECT MATERIALS ON:
Design And Implementation Of A Bill Of Materials Processing System:
A Bill of Materials (BOM) processing system is a critical component of many manufacturing and production processes. It helps organizations manage and track the materials, components, and sub-assemblies required to build a final product. Designing and implementing an effective BOM processing system involves several steps and considerations. Here’s a high-level guide to get you started:
1. Define Requirements:
Gather detailed requirements from all stakeholders, including production teams, procurement, engineering, and management.
Determine the scope of the BOM system, including the types of products it will support and the level of complexity required.
2. Select a Technology Stack:
Choose the technology stack that suits your organization’s needs. This may include a combination of hardware and software components.
Common choices include databases (e.g., SQL or NoSQL), programming languages (e.g., Python, Java), and web frameworks (e.g., Django, Ruby on Rails).
3. Database Design:
Design a robust database schema to store BOM data. This schema should accommodate different levels of product hierarchies, versioning, and revisions.
Define tables for products, components, suppliers, bills of materials, and any other relevant entities.
4. User Interface (UI) Design:
Create an intuitive and user-friendly interface for users to interact with the system.
Ensure that the UI supports tasks such as creating, editing, and viewing BOMs, as well as generating reports.
5. BOM Creation and Management:
Implement functionality to create and manage BOMs, including adding, removing, or updating components.
Consider incorporating features for version control, so users can track changes to Bill of Materials over time.
6. Integration with Other Systems:
Integrate the Bill of Material system with other systems like Enterprise Resource Planning (ERP), Inventory Management, and Manufacturing Execution Systems (MES) for seamless data flow.
Use APIs or middleware to facilitate data exchange between systems.
7. Security:
Implement robust security measures to protect sensitive Bill of Material data.
Enforce access controls, authentication, and encryption to safeguard information.
8. Reporting and Analytics:
Provide tools for generating reports and performing analytics on BOM data. This can help identify cost-saving opportunities and optimize production processes.
9. Testing and Quality Assurance:
Conduct thorough testing to ensure the system works as expected and is free of bugs.
Consider user acceptance testing (UAT) with actual stakeholders to gather feedback and make improvements.
10. Training and Documentation:
– Develop user manuals and documentation for system administrators and end-users.
– Provide training to ensure that users can effectively use the system.
11. Deployment:
– Deploy the BOM processing system in a production environment, whether on-premises or in the cloud.
– Monitor system performance and address any issues that arise.
12. Ongoing Maintenance and Support:
– Establish a maintenance plan to address updates, patches, and ongoing support.
– Continuously gather feedback from users and make enhancements as needed.
13. Scalability and Future-Proofing:
– Design the system with scalability in mind to accommodate future growth and changes in business needs.
– Stay updated with technology trends to ensure the system remains relevant and efficient.
14. Compliance and Regulations:
– Ensure the system complies with industry regulations and standards relevant to your business.
Remember that the specific implementation details will depend on your organization’s unique requirements and constraints. In some cases, it may be beneficial to work with a software development team or consult with experts in BOM management to ensure the system meets your needs effectively.