Here we collect formulas and examples to help you integrate and represent your production tasks and production resources in your print shop as effectively as possible:
A production task influences the preceding or following production task:
IF(CONTAINS(Immediately preceding production tasks,"Offsetdruck"),1,Total quantity of goods to be processed*(3600/8000))
Here, a time of 1 second is calculated (zero seconds are not allowed) if the preceding production task is “Offsetdruck”. Otherwise, the normal processing time is calculated. You can also use this approach for the basic setup and cleanup times:
If a production resource affects the processing times or quantity, you can use the following formula, for example:
(IF(Machine="Falzmaschine 123",Value for folding machine 123,Alternative value))
If a formula queries the Paper thickness variable, this solution can also use the grammage if no thickness is specified for the print material.
IF(Paper thickness=0,(Grammage/1000),Paper thickness)
To cover several ranges, you can use the RANGESWITCH function. For example:
(RANGESWITCH(Number of stations,1,10,1,11,15,1.5,15,20,2))
In the example above, a factor of 1 is used for 1–10 workstations, a factor of 1.5 for 11–15 workstations and a factor of 2 for 15–20 workstations.
If you need the minimum or maximum value returned as a variable, you can define this with MAX and MIN:
MAX(Paper width,Paper height)*Total quantity of goods to be processed/1000/Laminations per hour*3600
Here, the larger of the Paper width and Paper height variables is used in the calculation.
The advantages of the SWITCH function:
For example, each component can have its own difficulty level, which can be used to influence processing times or costs across components. A SWITCH function is the best choice here:
SWITCH(Technical difficulty level,"sehr einfach", 1, "einfach", 2, "normal", 3, "schwierig", 4, "sehr schwierig", 5, 6)
With “sehr einfach”, you get the value “1”; with “sehr einfach”, you get the value “2”, and so on.
Finishing operations can also be created with a selection menu.
This can be helpful if you want to include additional staff as an option, for example.
It could look like this:
Then simply copy the complete formula from the processing time and put it in the additional costs for in-house production.
Only the following is added to the cost formula:
/ 3600 * Hourly rate of additional staff for manual work in EUR * Number of additional staff * 100
Percentage reductions or increases in time can also be represented using a simple specification of a finishing operation:
*IF(Effort reduction in percent=0,1,(100-Effort reduction in percent)/100)
Or:
*(Effort increase in percent/100+1)
Both formulas can then be appended to existing time formulas.
We recommend the following formula for calculating ink consumption:
IF(Substratcoating,(((Total quantity of goods to be processed*(Paper height*Paper width/1000000)*Number of printed surfaces)*0.15)*1.6), (((Total quantity of goods to be processed*(Paper height*Paper width/1000000)*Number of printed surfaces)*0.15)*1.8))
We check whether the material has a coating. If it does, we calculate the printed square meters and assume a standard area coverage of 15% (*0.15) at a consumption of 1.6g/sqm. For uncoated papers, this example also assumes 15% area coverage, but uses 1.8g/sqm. If a product’s ink consumption differs considerably, you can quickly adjust the values in this formula.