The Formula Report lists formula definitions, their steps and their calculated costs for a selected formula range. Each formula shows its description, version, default size, minimum and maximum products, and last editor.
Use the display options to include submix details and optional-step costs, or hide cost and tolerance columns. The example shows a fictional finished product and its component blend.
Report Setup
Select the first and last formula in the range. This example uses DEMO-CAP-060 for both selections.
Choose whether to show submixes and include primary optional steps in the totals.
Choose whether to exclude costs or tolerances, then run the report.
Example input controls, reconstructed from the report parameters. Installed labels, choices and defaults may differ.Click the image to enlarge.
Sample Report
The example below uses fictional records populated into the report’s Jasper layout. Demonstration labels have been added; the content and number of pages depend on your data and selected options.
Formula Report — fictional example data.Click to enlarge, or save this image.
The report contains:
Formula details — Code, description, version, editor, default size, and minimum and maximum product quantities.
Formula steps — Step type, commodity code and description, target quantity and unit of measure, with optional steps identified.
Costs and tolerances — Step unit cost, step cost, formula total and cost per unit, plus lower and upper tolerances when enabled.
Submix details — Nested formula groups appear when Show Submix is selected.
Links To
This report does not include links to other reports.
Was this page helpful?
YesNo
Manage Cookie Settings
We want to make your experience on our website as personalized and enjoyable as possible. To do this, we use cookies – these are tiny bits of data that help us understand how you use our site and tailor it to your preferences.
Rest assured, we value your privacy and are committed to keeping your data safe. By clicking "Continue with recommended settings," you're giving us permission to use cookies. Of course, you're in control – feel free to adjust your cookie settings anytime in our Privacy Preferences.
Functional
Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional
Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.