The Promax PX solution is based on a Microsoft SQL+ DB and therefore allows data to be easily extracted through Microsoft Office tools like Excel or other third party report writer tools.

Promax is a transaction tool and the standard DB that is used by the tool stores the information in a detailed, date based format. The native DB structure is not conducive to efficient reporting or data interrogation.

To assist in the reporting and data analysis process we also offer the AnalytX cube – which translates the data into an OLAP Cube that allow easier and more flexible reporting.

Additionally, Promax also offers the Analytx module for the reporting and analysis of data. This also includes a series of predefined reports and offers dashboard functionality.

The calculation of statistical models relies on point-of-sale and invoiced sales data. It is not uncommon for this information to be “contaminated” from events such as production disruptions, out of stock and data errors. Promax PX provides tools to edit historical information to cleanse the data and provide more reliable statistical models.

The typical process of new customer set up initially commences within the company’s business system or ERP. The placing of the new customer in the hierarchy and its inclusion in the forecasting and promotional planning processes typically follow the import of the appropriate details in the batch import. If appropriate, manual creation of the account and all its associated details is fully supported through appropriate screens. Promax PX then allows statistical models to be copied from one SKU to another. All Statistical Models within Promax PX are calculated & setup for an individual Account & SKU combination.

Likewise for new products, Promax PX has a number of methods that can be used for New Product Introduction & Product Phase Outs. The Ranging functionality provides a time phased method of defining the Baseline Calculation / Volume by Account and SKU. This allows a forecaster to:

Select from tthe following methods of baseline calculation:

• Average Sales
• Average Scan (EPOS)
• Base Scan (EPOS)
• User Defined
• Statistical
• Increase / Decrease a baseline forecast derived by the above calculation methods by a Percentage
• Import an external baseline.

Setting different baseline calculation methods over the product’s introduction or decline will provide a forecast profile that will match the product. Combining these functions with the ability to copy a statistical model from one Account/SKU to another, New Product Introductions and Product Phase Outs can be dealt with easily.

Promax PX allows GST rates to be set by transactions type. This allows for the two different rates current in Australia and NZ to be handled. There can also be different GST rates at the product level and these are handled as part of the pricing metrics.