12 Period Fuel Margin reports are graphical reports which allow users to visually compare fuel margin values for up to twelve current/prior periods. Graphs display fuel margin values for each period of the current year alongside the values for the corresponding periods from the previous year.
Report graphs are available for both parent and child profit centers.
Note: Please consider the following in regards to 12 Period Fuel Margin graphical reports:
1. Graphs are based upon the last recorded processed date for each child profit center. Users should ensure all shifts for the day are entered before running the Consolidate Sales Data program and building the retail sales data warehouse.
2. This values on this report may be inaccurate if the processed through date for profit centers is not within the current GL period.
When you select 12 Period Fuel Margin reports, the system displays the following:
The graph contains the following information:
· ProfitCenter
· Period Ending Date
· Profit Per Gallon
· This Year
· Last Year
Note: Table MR_SALES is used to retrieve the sales and gross profit dollar values required to calculate margin values. Sales and gross profit values are not displayed. If there is no margin data to report for a period and/or year, there is no bar displayed on the graph.
12 Period Fuel Margin report graphics display the name and number of the profit center represented by the data.
Period ending dates are displayed along the graph’s horizontal axis, beneath each date’s corresponding bar on the graph.
Margin (Profit per Gallon in Dollars) values are displayed along the graph’s vertical axis. These values help you evaluate the fuel margin value at the profit center during the specified period and year. Margin values are calculated as follows:
X / Y
X = the sum of gross profit values for fuel sales at the profit center during the specified period and year.
Y = the sum of all fuel sales at the profit center during the specified period and year.
Values are rounded to four (4) places after the decimal.
The graph displays both positive and negative values. Positive values are displayed above the zero (0) point on the vertical axis. Negative values are displayed below the zero (0) point.
Note: The vertical axis will display up to 48 values (both positive and negative). However, the actual number of values will vary. Only the number of values necessary to include low and high values will be displayed.
Blue bars represent current year fuel margin data. Red bars represent the previous year’s fuel margin data.
If a profit center has child profit centers, you may click anywhere on the parent profit center’s graph to view graphical reports for each child profit center.
Child reports are graphed in the same manner as the parent profit center and are displayed vertically. Use the scroll bar to view all child profit center graphs.
