What exactly is the intention of the Calculator type in my bill-of-materials?

Written by Pieter Hamans on . Posted in Exact Online

dimblog-000

In the bill-of-materials of Exact for Manufacturing you will find a field Calculator type. By default its value is “Materials per piece”. Other available values are “Fixed” and “Pieces per material”. What is meant with these values, and why are there other values (like “Pieces per bar”) that are disabled? With the Calculator type we can support nearly every material calculation requirement. We will introduce you to the possibilities.

In the bill-of-materials (Maintenance | Materials, in the bill-of-materials version and in the shop order, or Quotation | Materials, in the quotation) we find a field Calculator type. By default it shows “Materials per piece”:

dimension-001

(Click to enlarge)

 

Application to all materials

For materials that have no shape defined in the item card (that is the default for all items!), the available calculator types are limited to “Materials per piece”, “Pieces per material”, and “Fixed”:

dimension-002

(Click to enlarge)

 

Materials per piece: The above example is for a bill-of-materials for a carton of shampoo. The unit of the product is carton, and there are 20 bottles in a carton. The quantity 20 we should fill in the field Quantity required.

 

dimension-003

(Click to enlarge)

 

Pieces per material: The above example is for a bill-of-materials for a carton of shampoo. For every 24 cartons we need a pallet. First we change the Calculator type into Pieces per material, and then we fill 24 in the field Quantity required. Provided that the material is Not divisible (item card), Exact for Manufacturing will round up the requirement of the shop order. For an order of 25 cartons, two pallets are required.

 

dimension-004

(Click to enlarge)

 

Fixed: The above example is for a bill-of-materials for a carton of shampoo. For each shop order we need two face masks. First we change the Calculator type to Fixed, and then we fill 2 in the field Quantity required.

 

Application to materials with a shape (dimensional items)

When we want to use the additional properties of the calculator we have two options. We can click the calculator icon in the material line, and choose one of the Shape characteristics, or we can default a Shape characteristic on the item card. Some of the terms of the Shape characteristics on the item card deviate from the terms in the bill-of-materials, but there is a 1-1 correspondence:

 

dimension-005

(Click to enlarge)

 

In this blog we show the most common applications of “Weight per piece”, “Pieces per bar”, and “Pieces per sheet”.

 

dimension-006

(Click to enlarge)

dimension-007

(Click to enlarge)

 

Weight per piece: This Calculator type is indispensable when we are using a material of which the stock unit is larger than the unit we want to use in the bill-of-materials. The above example is for a bill-of-materials for a carton of (bear odour) shampoo. We keep stock of bear odour in kg, but for every carton we only need 1.5 gram. We click on the calculator, choose the Calculator type “Weight per piece”. We set the Measurement unit to gram and fill the Weight at the Piece characteristics with 1.5 (gram). When we close the window, we see that the Quantity required is 1.5. This is not the quantity in stock units, but the quantity gram of the calculator.

 

dimension-008

(click to enlarge)

dimension-009

(Click to enlarge)

 

Pieces per bar: This calculator type is useful for materials that are bar shaped like profiles and tubes. The purpose of the calculator is to determine the number of pieces that can be made out of a single (trade length) bar. The above example is for a welded construction element. We require 1,800 mm IPE profile per construction element. The trade length of the bar is 6,000 mm. The calculator shows that we can make 3 pieces out of a bar. Of course we wonder what to do with the 600 mm that is left. If we check “Whole bars”, we round up the requirement for bars and include all the rest material in the cost of the product. Nothing prevents us to take the rest material back into inventory (See: Managing sawing rests). If we do not check “Whole bars” (and the material is Divisible on the item card), we will automatically return the rest material into inventory.

 

dimension-010

(Click to enlarge)

dimension-011

(Click to enlarge)

 

Pieces per sheet: This calculator type is useful for materials that are sheet shaped like plywood, metal foil and paper. The purpose of the calculator is to determine the number of pieces that can be made out of a single sheet. The above example is for a welded construction element. We require 660 x 440 mm pieces per construction element. The dimension of the sheet is 2,000 x 1,000 mm. The calculator shows that we can make 6 pieces out of a sheet. Notice that the calculator also shows how many kg of material is required. If we would set the stock unit of the material to kg, we may define the cost price per kg on the item card. This could be useful for purchasing.

 

More information with Pieter Hamans, pieter.hamans@exact.com

Categories

Archive per month