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.
You can insert the material
-
as master data via using queries
-
Insert your own material locally
or
The latter is shown in the following, because it illustrates the inputs required for calculation.
Insert a Local Material (Mass)
- Select the should cost calculation in the Structure view.
- In the ribbon, click on Edit > Insert >
Insert New Local Material (Mass).
A local material is added under the should cost calculation.
-
In the Details view > Calculation
view scheme (combobox), select the following quantity valuation:
-
Calculate Coil
For materials with Calculate Coil quantity valuation, the following geometric shapes are available:
-
Input for Strip-Coil Materials using "Length Calculation"
Define the following properties for the material in the Details view > Calculation view scheme (combobox):
- Cross-Sectional Area
- Volume
- Weight per Length
- Profile Length (l)
- Total Number of Blanks
- Output
- Gross Quantity
- Relevant Quantity
| 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 |
|
| Refund per Unit |
|
Based on the input, the following values are calculated:
Input for Wire-Coil Materials using "Length Calculation"
Define the following properties for the material in the Details view > Calculation view scheme (combobox):
- Cross-Sectional Area
- Volume
- Weight per Length
- Profile Length (l)
- Total Number of Blanks
- Output
- Gross Quantity
- Relevant Quantity
| 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 |
|
| Refund per Unit |
|
Based on the input, the following values are calculated:
Extend Material Calculation
The following checkboxes enable you to activate or deactivate further details of the material calculation.
The activated checkbox enables you to take length allowances of the material into account.
Length Allowance
View and enter the cutting width of the material.
Direct input is possible.
Length of Finished Material incl. Length Allowance
The activated checkbox enables you to take a detailed length calculation of the material into account.
Cutting Width (cw)
View and enter the cutting width of the material.
Direct input is possible.
Profile Remaining Length (ls + le)
View and enter the remaining length of the material's profile.
Direct input is possible.
- "Consider Markup" checkbox
- "Consider Recycling" checkbox
- "Consider Inbound Logistics Costs" checkbox
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):
- 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
| 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 |
|
| Refund per Unit |
|
Based on the input, the following values are calculated:
Input for Wire-Coil Materials using "Material Utilization"
Define the following properties for the material in the Details view > Calculation view scheme (combobox):
- 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
| 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 |
|
| Refund per Unit |
|
Based on the input, the following values are calculated:
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.
| 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 |