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.
The following example shows the 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.
- Click on Edit ► Insert ► Insert New Local Material (Mass).
A local material is added under the should cost calculation.
- In the Details ► Calculation view schema (combobox) select the Calculate Coil quantity valuation.
For materials with Calculate Coil quantity valuation, the following geometric shapes are available:
| Geometric Shape | Image | Required Input |
|---|---|---|
| Strip |
|
Input for Strip-Coil Materials |
| Wire |
|
Input for Wire-Coil Materials |
Input for Strip-Coil Materials
Define the following properties for the material in the Details ►Calculation view schema (combobox):
- Cross Sectional Area
- Volume
- Weight per Length
- Profile Length (l)
| Valuation | *Calculate Costs |
| Quantity Valuation | Calculate Coil |
| 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 | <empty> |
| 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:
Calculate Gross Weight
Using the Gross Weight Base combobox of Coil-Strip materials, you can decide whether to directly enter the gross weight value (»Enter Gross Weight« selection), or whether to have this value calculated by values of other properties. If you want to have it calculated (»Calculate Gross Weight« selection), you can enter values for inner and outer diameter resulting in the gross weight value.
Selecting none of the two options (i. e. leaving the combobox empty) will disable the gross weight property and thus it will not be included in the calculation.
Define the following properties for the material in the Details ►Calculation view schema (combobox):
- Cross Sectional Area
- Volume
- Weight per Length
- Profile Length (l)
| Valuation | *Calculate Costs |
| Quantity Valuation | Calculate Coil |
| Geometric Shape | Wire |
|
|
|
| Density | 7.85 g / cm³ |
| Wire Diameter (w) | 5.00 mm |
| Gross Weight | 60.00 kg |
| 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:
Extend Material Calculation
The following checkboxes enable you to activate or deactivate further details of the material calculation.
»Consider Length Allowance« checkbox
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
»Detailed Length Calculation« checkbox
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
Calculation Methods
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 »Length Calculation«
Define the following properties for the material in the Details ►Calculation view schema (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 |
| 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 |
140.00 mm |
| Nesting Quantity | 1.0 |
| 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:
Input for Wire-Coil Materials using »Length Calculation«
Define the following properties for the material in the Details ►Calculation view schema (combobox):
- Cross Sectional Area
- Volume
- Weight per Length
- Profile Length (l)
- Output
- Gross Quantity
- Relevant Quantity
| Valuation | *Calculate Costs |
| Quantity Valuation | Calculate Coil |
| 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 | 140.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:
Input for Strip-Coil Materials using »Material Utilization«
Define the following properties for the material in the Details ►Calculation view schema (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 |
| 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:
Input for Wire-Coil Materials using »Material Utilization«
Define the following properties for the material in the Details ►Calculation view schema (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 |
| 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: