The Gross Margin on Fuel data alert reports fuel purchases, by product, where the actual calculated margin exceeds the tolerances defined in the data alert set up. The data alert lets you set a high margin and a low margin. If the calculated margin on a fuel purchase exceeds the high margin or falls below the low margin, then you will receive a data alert. Consider the following example:
You set the tolerances for 93 Octane as follows:
Low Margin: 10
High Margin: 13
With these tolerances, you will receive a data alert when the gross profit margin for the product drops below 10 percent. You will also receive an alert if the maximum margin for the product exceeds 13 percent. The alert will be sent as defined by the schedule you specify in the schedule field.
The system makes the following calculation to determine the gross profit percentage: [(Retail - Cost) / Cost] * 100. Consider the following example: The fuel costs $1.20 per gallon and is sold for $1.28 per gallon. Using the formula, the system calculates the gross profit percentage as 6.67 percent. This percentage falls below the defined low margin of 10 percent so the system will send you an alert.
Note: When you schedule this alert, you must enter low and high margin tolerance amounts that are greater than "0".
See the following Data Alert File Maintenance form:
For step-by-step instructions on creating data alerts, see Data Alert File Maintenance.
