The purpose of this article is to provide you with an explanation of what the ADDM report is, and how it works.
What Does ADDM Stand For?
ADDM is an acronym for Additional Demand. It forms part of the reporting function found in the DotActiv software.
Unpacking The ADDM Report
For this report, you can compare your existing shelf plan against a proposed shelf plan. It allows you to calculate the financial impact of any range changes on your business.
If you want to add new products to your range, you would first need to calculate the financial impact on your business. Once you have analysed the impact of the report on your business, only then should you make changes.
You can find this report under the ‘Reporting’ tab in your DotActiv software, called ‘Demand’.
For the ADDM Report to function correctly, you need to ensure that you have clustering set up in the DotActiv Software.
Thereafter, make sure that you have set up Ranging/Assortment Planning. Please read this article on how to set up Range Optimizer.
Further to the above, the following prerequisites are needed:
- Two planograms with facing differences (to measure the financial impact accurately);
- KeyProduct and MDD values must be set on the planograms;
- Category must be set on planograms to identify any cross merchandised products;
- Product description should be set on the planograms;
- Pack Size, Selling Price, and MAC fields must be set in the database;
- First Sale Date field should be set in the database to easily identify new lines;
- MDD values should be set in the database;
- RegularOrOncer and Product Status Fields must be populated in the database;
- Servicing Warehouse (DC) fields can be used to indicate relevant DC’s per market or product;
- DC Stock Quantity field should be set in the database for the DC’s latest period; and
- Goods in Transit Actual Facings and Stock Quantity fields should be set in the database for the latest period.
Using The ADDM Report
After clicking on the ‘Reporting’ tab, select the ‘Demand’ icon under the ‘Advanced’ section in the reporting ribbon.
Please ensure that you have your current and proposed planograms to report on.
Your current planogram would be the data that is currently reflecting in your database or planogram, and your proposed planogram is the changes that you have made in order to make ranging decisions on.
When the ‘Map Planograms For Comparison’ window (seen below) pops up, you can select your current planogram directory as well as your proposed planogram directory.
Please ensure that your planogram names follow the specified naming convention i.e CATEGORY_FORMAT_NOD (BODY CREAMS_CLUSTER A_3.FLP) Otherwise DotActiv is unable to analyse and access the data.
You can select the option to only report on the MDQ (Minimum Display Quantity changes).
When hovering over any (i) icon in DotActiv software, you can read a description of what the feature does.
You also have the option to ‘Include Changes Report’. Selecting this will generate a changes report based on all the changes made on your proposed planogram versus your current planogram.
Clicking ‘OK’, generates your ADDM report.
Please note that the main ADDM report totals use the increase/decrease MDQ. The current stock values are also taken into the calculation of the ADDM / RDDM report totals.
Should the above steps not work for you, please create a support ticket and DotActiv support will assist you in uncovering the issue.