Accolent ERP includes several KPIs (Key Performance Indicators) that deliver graphical visualization dashboards for important performance metrics. All the data is summarized as of the end-of-business on the prior day and cached to improve performance. The sales & profitability dashboard shows the (1) sales for the MTD compared to the Last MTD, (2) profit for MTD compared to Last MTD, (3) sales and profit by month for the current partial month and the previous 11 full calendar months and (4) profitability by month for the current partial month and the previous 11 full calendar months.
General Definitions
- All KPIs are presented as of end-of-day for the previous business day; this is the date of the dashboard shown in parentheses in the title of the dashboard
- All sales are in dollars (NOT qty) unless specified otherwise
- All profit is calculated based on standard costs (Note: GL posting is based on average costs)
- For graphs, sales and profit are presented in $000s
- All sales values are expressed as the sum of the extended price (i.e., excluding freight, labor and sales tax) in order to be able to be tied back to product sales
- MTD means “month to date” and is measured from the beginning of the current calendar month to the date of the dashboard
- Last MTD means “last month to date” and is measured from the beginning of the previous calendar month to the same day in the previous month as the date of the dashboard
- All graphs showing 12 months show the current partial month and the prior 11 full calendar months
Sales & Profitability KPI
- This is the Sales & Profitability KPI
Dashboard Controls
- The icons at the top right-hand side of all dashboards provide options to refresh the dashboard, to edit the dashboard, and to filter the dashboard
- Do not edit the dashboard unless you are familiar with using the report designer
Element Controls
- Each dashboard consists of several graphical elements combined into a dashboard
- Rolling the mouse over the top right-hand side of any element provides several additional options
- The up/down arrows provide some options to sort the data
- The full screen icon allows the element to be viewed on a full screen
- The search icon provides the data being visualized
- The download icon gives several options to save the element
- The eye icon allows selection of which columns to display in a grid
Graphs
- All graphs have a mouse rollover that shows the actual values (in $000s)
Modifying the Dashboard
- Contact ADS Solutions if you want help modifying the sales dashboard or creating new custom dashboards
- Any standard report can be turned into a dashboard or dashboard element