Formula List Summary Per Customer compares formula costs and selling values for customer-linked formulas. It shows the customer and formula alongside commodity cost, labor, overhead, total cost, sale price, rebate and margin.
Use the optional customer selection to focus the report. The margin column is an amount calculated from sale price less total cost and rebate; it is not a percentage.
Report Setup
Choose a customer to restrict the result, or leave the optional customer filter unselected to include all matching customers.
Run the report and compare each formula’s cost components, sale price and rebate.
Use the formula link to inspect the linked Formula List report where available.
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 List Summary Per Customer — fictional example data.Click to enlarge, or save this image.
The report contains:
Customer and formula — Identifies the customer and the latest type-1 formula linked through the product/customer mapping.
Cost and margin — Commodity cost combines packaging and ingredients after loss. Labor and overhead contribute to total cost; margin then subtracts that total and the rebate from the sale price.
Production assumptions — Run Time (Mins) and the stored loss value accompany each formula’s cost figures.
Links To
The following report links are available in the JasperReports web viewer:
Formula — The formula field links to the Formula List report using the selected formula ID. The source contains two formula-linked fields.
These destinations depend on the reports installed on your server. Links inside the example images are not interactive.
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.
