12 Period Merchandise Margin Percent reports are graphical reports that allow you to visually compare merchandise gross margin percent values for up to twelve current/prior periods. Graphs display merchandise margin percent 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 Merchandise Margin Percent graphical reports:
Graphs are based upon the last recorded processed date for each child profit center. Ensure that all shifts for the day are posted and processed before running the Consolidate Sales Data program to build the retail sales data warehouse.
The values on this report may be inaccurate if the processed through date for profit centers falls outside the current GL period.
When you select 12 Period Merchandise Margin Percent reports, the system displays the following ExecuGraph:
The graph contains the following information:
Profit Center
Period Ending Date
Gross Margin Percent
This Year
Last Year
Note: The report uses sales and gross profit dollar values to calculate margin percentage values; however the report does not list the sales and gross profit. If there is no margin percentage data to report for a period and/or year, there is no bar displayed on the graph.
12 Period Merchandise Margin Percent report graphics display the name and number of the profit center represented by the data.
The graph displays period ending dates along the horizontal axis, beneath each date’s corresponding bar on the graph.
The graph displays merchandise gross margin percent along the vertical axis. These values help you evaluate the merchandise margin percentage for the profit center during the specified period and year. Margin percentage values are calculated as follows:
(X / Y) * 100
X = the sum of gross profit values for merchandise sales at the profit center during the specified period and year.
Y = the sum of all merchandise sales at the profit center during the specified period and year.
Values are rounded to two (2) places after the decimal.
The graph displays both positive and negative values. Positive values are displayed above the zero point on the vertical axis. Negative values are displayed below the zero 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 merchandise margin percentage, and red bars represent the previous year’s merchandise margin percentage 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.