Graphical BOM Processor using Python OOP

The engineering design process consists of 5 stages: Need Assessment, Problem Formulation, Abstraction and Synthesis, Analysis, and Implementation. In the Abstraction and Synthesis phase, it is common and useful to decompose the product into its constituent parts in a hierarchical manner in a table called the Bill of Materials (BOM). A fictitious and unrealistic example of this table can be seen in the figure below and in the "MySampleData.xlsx" file in the repository.

As can be seen in the table above, each component has a level that specifies its hierarchy. For example, the 'body' is at level 1, and 'Front body', 'Back body', and 'Polymer handle' are its first sub-assemblies and are at level 2. The 'Front body' itself has two sub-assemblies called 'Nozzle' and 'Power cable', which are at level 3, and the 'Power cable' itself has one more sub-assembly called 'The end of the cable', which is at level 4. The same can be extracted from the table above for other components.

In addition to the level, each component in the table above has other information such as id, unit, Quantity, and also Labor Cost (LC), Machine Cost (MC), Other Cost (OC), and Purchase Cost (PC). Therefore, to find the cost required for each component, one must use the different costs of itself and its sub-assemblies in the number that exists from them, and reach the desired results of these diagrams. Doing this manually or with the Excel file itself is very time-consuming and inefficient, so here a graphical program is written in Python in an Object-Oriented manner so that these tables can be easily used.

Run the program to open the following window.

In this window, after selecting the desired Excel file and filling in the information above, click on "Confirm". If there is no error in entering the information, the "Confirm" button will change to the "Start" button.

Clicking on this button opens the following window where you can request and receive the desired information from the program.

After selecting the desired component, you can open the second Combobox which will be as follows and will show the desired information by selecting each one.

For example, by selecting "body" and "Children", it shows us the first sub-assemblies of it along with the required number of each one as follows.

Other features can also be added to this program and make it more complete. I would be happy if someone could develop this program. [email protected]

This program was developed as a course project under the supervision of Dr. Mehrdad Kazerooni. I would like to thank my friend Mohammad Zolfaghari for his valuable contributions to this project.