Compliance Sub-System

The function of the CRTG Compliance Sub-System within the Choise Head Office System is to analyse information provided by CRTG, along with actual branch sales, in order to report on the level of compliance for branches and specific sections within branches.

Product information is imported from CRTG onto the Choise Head Office database.  This can then be interrogated by the Choise CRTG Sub-System and also through using the normal SQL Query Analyser facilities.

The Choise System holds details of the maximum meterage for each branch/alternative section.  Each product has its own meterage set and this is used, in conjunction with the branch/alternative section meterage, to determine whether the product should be stocked in that branch.

Based on the information imported from CRTG and the product sales information retrieved from the Choise Store Systems at each branch, the CRTG Sub-System can provide a variety of reports:

-         Total products in CRTG range

-         Products sold that are CRTG compliant

-         Compliant products that are not stocked

-         Products sold that are non-compliant

-         Percentage compliant

-         Problem alternative sections (i.e. compliance percentage below the required parameters set on system controls)

These reports can be at company/branch/alternative section level.

CRTG Offers

Offers (i.e. BOGOFs, 3 FOR 2, BASKETS etc.) from CRTG are imported onto the Choise Head Office System, so that these can then be amended as required to export to the relevant branches.

Offer sales information is retrieved overnight from all stores and imported onto the Choise Head Office System.  Offer quantities/values (as well as sales quantities/values) are reported on and/or a csv file produced to provide CRTG with the required offer information.

Compliance Information at Store

The meterage of each alternative section is hosted to store as well as the meterage of each product.  The product enquiry informs the store manager whether a product should or should not be stocked. 

The ASR System will only order products that should be stocked; however, individual products can be included/excluded as required.