LARGE SCALE RETAIL

The customer is a leader of the Italian large-scale retail trade who expressed the need to create an IT process that would allow the management of promotional initiatives starting from the definition of the draft of the promotional package up to the definition of the participating stores and the determination of the relative prices on sale. We have analyzed and designed the entire process based on the following phases: - Definition of the items/shops involved in the promotion - Definition of sale/transfer prices - Control and communication of the promotion - Creation of related commercial offers We have therefore created an application that implements the phases described above. PHASE 1: Definition of the items/shops involved in the promotion During the items definition phase, the user is supported to the choice through the commercial information view linked to the items set up: suppliers as reference point purchase prices related EAN code image and flyer layout maximum number of days on promotion PHASE 2: Definition of sale/transfer prices During the definition of sale/transfer prices phase have been realized some automatisms that can simplify the definition of the sale prices: visualization of the lower price of sale in comparison to all the shops involved automatic calculation of the price compared to the margin established automatic calculation of the discount in cash compared to the established price. PHASE 3: Control and communication of the promotion During the check phase, the app allows to: do transversal analysis of items/supplier promotion (Slicing) identify any price conflicting with average category balance During the communication phase the app allows to inform about the promotion: suppliers involved in the established definition of items to promote warehouse office to plan order and to optimize inventories advertising agency to create flyer the franchising shops to access to the promotional initiatives

The Client is an Italian l arge scale retail leader that asked to review the information process utlizing market data as guide to sales positioning. THE SOLUTION We analyzed and redesigned the entire process based on the following phases: 1. Detection, acquisition of competitors' prices and association 2. Create a simulation session 3. Control and validation of the simulation 4. Control of final balances We have therefore created an application that implements the phases described above. PHASE 1. Detection, acquisition of competitors' prices and association Data collection obtained bases on: competitors trackers data acquisition protocol Combining with internal items has been realized: automatically, based on EAN referring to brands; partly automatic for non brands. PHASE 2. Create a simulation session With the aim to create a testing session we worked defining the following elements: algorithm select a competitor reference price priority classes linked to goods categories and single items competitive grid lines. Every line combines a set of competitors, an algorithm select competitors reference price points, a competitive grid.