Calculate Coil

This quantity valuation offers you the material quantity calculation for coils, so that this rather complex calculation needn't be calculated and documented outside FACTON.

Alternatively, you can conduct an initial simple calculation if not all details of the quantity calculation are available and you can only enter the quantity.

Use the checkbox for this:

  • Detailed Quantity Calculation

    • For an initial, simple material quantity calculation

  • Detailed Quantity Calculation (default)

    • For the detailed material quantity calculation

 

The price per kg is determined using value rules based on dimensions

Further Information on material pricing, see Value rules at a material

 

The following example shows the detailed use of a material quantity calculation:

 

Step 1: Create Should Cost Calculation

Further Information > Create Should Cost Calculation

 

Step 2: Insert a Material (Mass)

By selecting the Calculate Coil quantity valuation and a corresponding geometric shape at the material, a more extended calculation logic becomes available.

Note

You can insert the material

The latter is shown in the following, because it illustrates the inputs required for calculation.

 

Insert a Local Material (Mass)

  1. Select the should cost calculation in the Structure view.
  2. In the ribbon, click on Edit > Insert > Insert New Local Material (Mass).

    A local material is added under the should cost calculation.

  3. In the Details view > Calculation view scheme (combobox), select the following quantity valuation:

 

Input for Strip-Coil Materials using "Length Calculation"

Define the following properties for the material in the Details view > Calculation view scheme (combobox):

    Valuation *Calculate Costs
    Quantity Valuation Calculate Coil
    Detailed Quantity Calculation
    Geometric Shape Strip
     
    Density 7.85 g / cm³
       
    Strip Width (w) 350.00 mm
    Strip Thickness (t) 0.50 mm
       
    Gross Weight Base Enter Gross Weight
    Gross Weight 0.50 kg
       
    Calculation Method Length Calculation
    Length of Finished Material 50.00 mm
    Nesting Quantity 1.00
       
    Price Source Standard
    Price per Unit 23.00 EUR / kg
    Refund per Unit 15.00 EUR / kg

    Based on the input, the following values are calculated:

    • Cross-Sectional Area
    • Volume
    • Weight per Length
    • Profile Length (l)
    • Total Number of Blanks
    • Output
    • Gross Quantity
    • Relevant Quantity

     

Input for Wire-Coil Materials using "Length Calculation"

Define the following properties for the material in the Details view > Calculation view scheme (combobox):

    Valuation *Calculate Costs
    Quantity Valuation Calculate Coil
    Detailed Quantity Calculation
    Geometric Shape Wire
     
    Density 7.85 g / cm³
       
    Wire Diameter (w) 5.00 mm
       
    Gross Weight 60.00 kg
       
    Calculation Method Length Calculation
    Length of Finished Material 50.00 mm
       
    Price Source Standard
    Price per Unit 23.00 EUR / kg
    Refund per Unit 15.00 EUR / kg

    Based on the input, the following values are calculated:

    • Cross-Sectional Area
    • Volume
    • Weight per Length
    • Profile Length (l)
    • Total Number of Blanks
    • Output
    • Gross Quantity
    • Relevant Quantity

 

Extend Material Calculation

The following checkboxes enable you to activate or deactivate further details of the material calculation.

 

 

 

 

Gross Weight Base

For strip-coil materials, you can use the following selection to calculate the gross weight:

  • Enter Gross Weight (default)

    • The value for the gross weight is entered directly here:

      • Gross Weight

  • Calculate Gross Weight

    • The gross weight is calculated using the following values:

      • Inner Diameter

      • Outer Diameter

 

Calculation Method

For the material quantity calculation for coils, you can also choose between the two calculation methods "Length Calculation" and "Material Utilization" available for strip and wire.

 

 

Input for Strip-Coil Materials using "Material Utilization"

Define the following properties for the material in the Details view > Calculation view scheme (combobox):

    Valuation *Calculate Costs
    Quantity Valuation Calculate Coil
    Detailed Quantity Calculation
    Geometric Shape Strip
     
    Density 7.85 g / cm³
       
    Strip Width (w) 350.00 mm
    Strip Thickness (t) 0.50 mm
       
    Gross Weight Base Enter Gross Weight
    Gross Weight 0.50 kg
       
    Calculation Method Material Utilization
    Output 5.00
    Material Utilization 80.00 %
     

     

    Markup Rate on Net Quantity

    20.00 %

       
    Price Source Standard
    Price per Unit 23.00 EUR / kg
    Refund per Unit 15.00 EUR / kg

    Based on the input, the following values are calculated:

    • Cross-Sectional Area
    • Volume
    • Weight per Length
    • Profile Length (l)
    • Length of Finished Material
    • Gross Quantity
    • Net Quantity
    • Markup Rate on Net Quantity
    • Markup on Net Quantity
    • Relevant Quantity

Input for Wire-Coil Materials using "Material Utilization"

Define the following properties for the material in the Details view > Calculation view scheme (combobox):

    Valuation *Calculate Costs
    Quantity Valuation Calculate Coil
    Detailed Quantity Calculation
    Geometric Shape Wire
     
    Density 7.85 g / cm³
       
    Wire Diameter (w) 5.00 mm
       
    Gross Weight 60.00 kg
       
    Calculation Method Material Utilization
    Output 5.00
    Material Utilization 70.00 %
       
    Markup Rate on Net Quantity 30.00 %
       
    Price Source Standard
    Price per Unit 23.00 EUR / kg
    Refund per Unit 15.00 EUR / kg

    Based on the input, the following values are calculated:

    • Cross-Sectional Area
    • Volume
    • Weight per Length
    • Profile Length (l)
    • Length of Finished Material
    • Gross Quantity
    • Net Quantity
    • Markup Rate on Net Quantity
    • Markup on Net Quantity
    • Relevant Quantity

 

After all inputs, the following costs are calculated and displayed as rounded figures in the Details view > Calculation view scheme (combobox):

Direct Material Cost incl. Inbound Logistics

 

An overview of the material costs can be found in the Details view > Cost Summary view scheme (combobox).

Details view > Cost Summary view scheme (combobox) in the Details view

The cost summary offers an overview on the cost breakdown and composition of the relevant material costs.

Example
Direct Material Cost Raw Material 13.75 EUR / pc
Inbound Logistics Cost 2.20 EUR / pc
Direct Material Cost incl. Inbound Logistics 15.95 EUR / pc
Material Overhead Cost 0.63 EUR / pc
Material Refund -2.25 EUR / pc
Material Cost 14.33 EUR / pc