Collaborate on Sample Bill for Administration with Ease Using airSlate SignNow

Sample bill for Administration

Is there an easy and smart way to deal with bills of materials in a data table format? The answer is absolutely. Hi everyone, I'm Silvia. and today I'll show you how to perform, in just a few clicks, 3 operations with bills of materials in a data table. Bill of materials or BOMS, as they're commonly known, list all the components or materials that make up a finished product. Let's take a bike, which is made up of many components. Well, a bike has two wheels, each wheel has a tyre rim, spokes, and so on. BOMs can be viewed as hierarchies A bike is made up of a road seat, a frame, a chain, and wheels. Wheels in turn are made up of tyres and spokes. To build up a bicycle we also need to know the quantities of each component. For example, a bike has two wheels and each wheel has 36 spokes but a bike has two wheels, not one So to calculate the total quantity of spokes, we need to multiply the 36 spokes by two. It might look easy, but in reality a BOM looks more like this. Our BOM is made up of 73 components, and 3 levels We can analyze BOMs to make the whole manufacturing process more cost effective. For example, by identifying which materials have the greatest impact on product cost. But to analyze BOMs, we need to view these hierarchical structures into flat spreadsheets, which can get pretty confusing. But as we'll see in the video, Rulex has some neat solutions. Let's take a closer look. Here is a typical BOM spreadsheet which lists all the components needed to build the top of the range bicycle. There are five columns, but the most important ones are the Component ID and Parent Component ID. So if the component is spoke the parent component is wheel. The component row 2 is a seat assembly and its parent is 749 which as we can see in row 1 is the finished product as it doesn't have a parent. In row 3 We can see the red frame for our bike whose parent is also the final product, our bicycle. As each row has not only information, on the component itself, but also in its parent component we can use a special function in Rulex, which automatically calculates how many parent levels each component has. So let's create a new column called BOM Level and use a special function in Rulex which automatically calculates how many parent levels each component has. We just need to tell Rulex which attribute is the parent and which is the child. As you can see, for the finished product, the BOM level is 0 because we are already at the highest level of the hierarchy. We can then see all the intermediate levels up to three so the maximum depth of our bill of materials in this example is three. Let's now perform a typical cost analysis operation on our Bill of materials, to understand which components have the greatest impact on the overall cost. We already have the cost, here in the Standard Cost column This cost might be the price at which you are purchasing materials from your supplier, or if it's manufactured in-house, it might be the sum of all the related manufacturing costs. Now the tricky part, here we cannot simply multiply the quantity by the Standard Cost. As this cost and states how many components, we need to build the parent component but not for the whole finished product. To calculate the total quantity, we'll create again a new column called Total Quantity. And again, use the rootDistance function, but this time adding the Quantity attribute as weight and then tell the function to multiply the results by the weight using the prod operator. And there you go. Now we can calculate the total cost in a new column. Here, we only need to multiply the Total Quantity by the Standard Cost. Well, that's great. But if you'd like to take it one step further, we can find out what percentage of the overall cost is spent on each component. So, we can create another column called the Percentage. We can divide the Total Cost for each component by the sum of all component costs, and then change the data type to percentage. And there you go. Now just sort the column in descending order. So, we can now see our final list of critical components. How can this information help us reduce costs, you may ask? Well, it depends on the way these components are procured inside the company. If they're purchased from external suppliers, we should talk to the purchasing department, tell them which components are most critical, and ask them to get a better deal. If they're manufactured in-house We should talk to Production or R&D to find a way to streamline the process and reduce manufacturing costs. Well, that's it for today. Look out for our next Rulex Quick Fix. Visit our website and don't forget to like and subscribe.