Technology roadmap

Topics

1. - Cellular Device SOP

2. - Scheduled Reports Update

3. - SIMs Related Issues

4. - Stolen and damages related Issues

5. - Asset Management System

6. - Project In Pipe lines

Daily, Weekly, Monthly Reports Status

Reports Name Daily Weekly Month Comments

Call Cycly Analyzer(Callage Compliance) ••• ••• Completed will be busted from this week INSHA ALLAH

Instore Routine- Checkedstore ••• ••• Busting only at National Level

Perfect Store Tracker - Compliance ••• ••• Successfully received from CD,ZMM,AMM,FMM at 15th Sept 2014

AMM CheckedStore Summary ••• •••

Busted on 8th Sept 2014 but stopped due to discrepancy reported, we are looking in discrepancy and will set on bust soon INSHA ALLAH

AMM CheckedStore Details ••• •••

FMM CheckedStore Summary ••• •••

FMM CheckedStore Details ••• •••

Start of Day-National ••• Successfully received from CD at 18th Sept 2014 (Today)

Start of Day-Zonal ••• Successfully received from ZMM at 18th Sept 2014 (Today)

Start of Day- Area Manager ••• Successfully received from AMM at 18th Sept 2014 (Today)

Active/Inactive Field Force Details ••• Successfully received from CD,ZMM,AMM,FMM at 18th Sept 2014 (Today)

Accepted Vs Actual Call Compliance ••• Successfully received from CD,ZMM,AMM,FMM at 18th Sept 2014 (Today)

Monthly Accepted Vs Actual Call Compliance ••• Successfully received from CD,ZMM,AMM,FMM at 8th Sept 2014

FM Checklist-Perfect store Checklist-Field Manager (By Category) ••• •••

Change Request Required to Bust these reports.

FM Checklist-Perfect store Checklist-Field Manager (By Element) ••• •••

AM Checklist-Perfect store Checklist-Field Manager (By Category) ••• •••

AM Checklist-Perfect store Checklist-Field Manager (By Element) ••• •••

Image Report ••• Successfully received from CD,ZMM,AMM,FMM at 17th Sept 2014 (Yesterday)

Gap SKU Report (Daily) ••• Successfully received from CD,ZMM,AMM,FMM at 17th Sept 2014 (Yesterday)

Sno. Area Manager Name Merchandizer Mobile Number Status

1 Omer Durani Uzair Ali 0301-8374361 Through Franchise Inactive

2 Omer Durani Sarfarazuddin 0301-8374355 Through Franchise Activated

3 Saad Ullah Durani Muhammad Waqas 0301-8374884 Through Franchise Activated

4 Mudassar Hameed Saqib Hussain 0301-8375059 Through Franchise Activated

5 Sagheer Wasif Ali 0301-8374642 Through Helpline Activated

6 Sagheer Mohsin Ramzan 0301-8374649 Through Helpline Activated

7 Sagheer Ahsan Raza 0301-8374653 Through Helpline Activated

8 Sagheer Shahid Farooq 0301-8375248 Through Helpline Activated

9 Sagheer Shahbaz Umer 0301-8375249 Through Helpline Activated

10 Jehanzaib Qamar Yasir Ahmed 0301-8374771 Dispatched Today Activated

11 Jehanzaib Qamar Rashid Hussain Shah 0301-8374769 Dispatched Today Inactive

12 Jehanzaib Qamar Abdul Kafeel 0301-8374770 Dispatched Today Activated

13 Jehanzaib Qamar Arqam Saeed 0301-8374734 Dispatched Today Activated

14 Jehanzaib Qamar Waseem Bulbul 0301-8374728 Dispatched Today Activated

15 Saad Ullah Durrani Mohsin Ali 0301-8374841 Dispatched Today Activated

16 Saad Ullah Durrani M.Naeem 0301-8374859 Dispatched Today Activated

17 Saad Ullah Durrani Qamar-Ul-Hassan 0301-8374852 Dispatched Today Activated

18 Saad Ullah Durrani IBRAR 0301-8375191 Dispatched Today Activated

19 Muhammad Sagheer Hassan Raza 0301-8374675 Dispatched Today Activated

20 Muhammad Sagheer Abdul Mateen 0301-8374627 Dispatched Today Activated

21 Muhammad Sagheer Haseeb Saleem 0301-8374656 Dispatched Today Activated

22 Salman Munir Sh. Waqas Ahmad 0301-8375287 Ready to Dispatch

23 Salman Munir Sufyan Ahmad 0301-8375097 Ready to Dispatch

24 Zuhair Iqbal Kamran Farooq 0301-8374950 Ready to Dispatch

25 M. Omer Khan Muhammad Gulzar 0301-8375149 Ready to Dispatch

SIMs Issues

GAP SKU Summary On or after Sep 15, 2014Faisalabad Islamabad Jhelum Karachi Lahore Lahore Multan Sukkur

Stores GAP SKUs Stores GAP SKUs Stores GAP SKUs Stores GAP SKUs Stores GAP SKUs Stores GAP SKUs Stores GAP SKUs Stores GAP SKUs

Category Name Beverages 235 39 80 38 133 39 481 113 35 27 322 39 64 37

Cooking Aids 254 19 84 19 107 15 417 19 42 14 286 19 62 19

Desserts 219 28 79 28 130 24 350 28 46 23 326 28 61 28

Hair Care 204 87 75 88 129 72 349 93 46 82 348 94 64 78

House Hold Care 284 20 92 20 161 15 481 20 54 15 347 20 66 20

Laundry 243 42 83 42 147 32 382 42 45 30 333 42 63 42

Noodles 282 14 85 14 160 9 413 14 57 9 310 14 63 14

Personal Wash 223 61 84 63 153 50 351 63 44 58 348 63 66 61

Skin Care 240 49 85 58 172 40 415 57 63 53 361 59 68 59

Spreads 308 11 100 11 93 6 461 11 50 6 266 11 57 11

NORTH Sep 16, 2014

Faisalabad Islamabad JhelumStores GAP SKUsStores GAP SKUs Stores GAP SKUs Stores GAP SKUs

Category Name Beverages 212 38 72 38 124 37 408 39

Cooking Aids 232 19 77 19 98 15 407 19

Desserts 196 28 70 28 121 24 387 28

Hair Care 184 87 69 88 120 65 373 98

House Hold Care 257 19 86 19 152 14 495 19

Laundry 220 42 77 42 138 30 435 42

Noodles 256 14 78 14 151 9 485 14

Personal Wash 202 61 78 63 144 46 424 63

Skin Care 216 49 78 58 163 40 457 59

Spreads 275 11 92 11 90 6 457 11

Total 300 323 102 335 207 283 609 347

Pre November 2013

• No use of handheld technology• Paper based record keeping• Difficult to identify trends

Current reality

Current reality

• COMPOSA mobility was introduced

• Users were trained on the use and advantages

Current reality

• Store owners were briefed on the technology

• In-store data gathering was simplified

Current realityo Three projects currently on COMPOSA

• Call cycle accept and reject

– This feeds the start of day report, defines how mkt is working

• In- store routine

– This feeds the In-store routine report and the feet-on-street monitor

– Confirms outlet coverage per day and per week

• Perfect store checklist

– This feeds the perfect store report and planned vs. actual calls report

Feet on street monitor

Start of day report

• Customised reports burst to Zonal AMM and FMM • Achieving in excess of 90 % log in rate , compares very favourably with other markets • POP coverage shows plan for day and also dropped calls• Rejection reasons give insights

• E.g. store permanently closed shows call cycle must be updated• Resource width - effectiveness and effeceincy guidelines

Start of day report

• Report shows 5193 calls planned and 3886 achieved• 66 % versus planned and 88 % versus accepted• Helps define effectiveness of route planning and gaps

Start of day report - detail

• Regional detail in report for follow up/gap closing

Perfect store checklist

• Perfect store reports can be viewed either by perfect store element or by Unilever category

In-store routi ne report

Can be used for appraisals / scorecards for Merchandisers and Field Merchadiser managers

Next Generati on Opportuniti es

Next generati on reporti ng• SLOB’s – Slow and absolute lines

• Here we can use COMPOSA to determine lines that are not selling out from outlet level

• Can support innovation feedback and reduce returns/damages, enhance supply chain

• Grey imports tracker

• COMPOSA can be used to monitor the impact and extent of grey imported products on shelf in the outlets

• Point of sale management

• All point of sale materials can be tracked using COMPOSA. Both the distribution and availability

• Qualitative, practical limitations, correct print runs can be established to cut costs/waste/sustainability

• Short dated stock tracker

• Expiry dates on stock monitored using COMPOSA to ensure relevant action is taken when certain products start to reach the

end of their shelf life. Foods /Ice Cream and short dated lines can be couponed to increase sales.

• Gap SKU reporting

• COMPOSA will be used to keep track of key lines that are out of stock on shelf in the outlet

• Outlet map reporting

• Map based colour robot reports to indicate status of certain KPI’s, PS status and efficient route planning

Outlet map reporti ng

Stores to be colour coded for V Perfect vs N Perfect

Outlet map reporti ngPS

Before

PS After

Stores must be mapped to the KD

Efficient and Ineficient KD’s can be identified

General

Workshop in LahoreMaster data management, Call cycles and COMPOSA

Distributor in KarachiCurrent point of sale material management

Merchandiser meeti ngBriefing the team on COMPOSA enhancements and refresher training