Tip of the Week #33 – Custom formulas with Additional Quantity Calculation
Senior Consultant Jörg Hüner is back with a tip for print estimators everywhere.
PrintVis provides a Formula Generator which makes it easy to build custom formulas for any needed calculations not already present in our standard system.
If for example we want to determine prices for additional quantities, some settings and rules are required so that PrintVis knows the base for the additional quantity calculations.
What is an additional quantity price?
With an additional quantity price customers are able to calculate the cost for quantities not requested in the quote.
Let’s say the total price for 10,000 brochures is 2500 USD (0.25 each) and the additional price per 1000 is 150 USD. The additional quantity price includes no makeready or prepress cost, which is already covered with the price for the first 10,000, so further production will reduce the price per piece.
This means if customers increase the quantity to 12,500, using the prices of the quote above they can easily calculate the price by themselves:
12,500 brochures = USD 2.500 + 2.5 x USD 150 = USD 2.875 (0.23 each).
How setup a formula for an additional quantity?
PrintVis standard formulas already calculate the additional quantity.
For custom-made formulas you have to follow these rules:
- Use the Add. Quantity Calculation option: Vary single link
- The formula that is the base for the additional quantity must be the first parameter
- This formula is not allowed to be interlaced – no other customized formulas should be combined with this formula, as this might result in a longer and more complex formula. Creating a custom formula for each step and combining them in the final step will not work for formulas meant to calculate additional quantities.
This formula is right and will give the expected result:
- Use the Add. Quantity Calculation option “Vary single link”
- The formula that is the base for the additional quantity is the first parameter
- This formula is not interlaced and only combines standard formulas and constant values.
This formula is wrong and will not give the expected result:
The result is wrong because:
- “Vary single link” is not selected in the Add. Quantity Calculation field
- The formula that is the base for the additional quantity (Ongoing finishing = Standard Formula 425) is not the first parameter
- This formula is interlaced and is not confined to standard formulas and constant values.
Thank you Jörg!