Operational Review Meeting,

Asian Paints Limited.

Bangalore Peenya Local
(April 2023 TO JUNE 2023)
Life Care Logistic Pvt. Ltd
 ORDER & OCT DATA (1565)

PEAK
Total BM BM not IBB PENDING Credit Vehicle Connectivity / Low Late MODIFIED
Month ORDER Limit not
Orders Achieved Defined Order PROCESSED Orders available issues MON OCT OCT %
THEN Volume Service (C+G)
D

Apr'23 10333 8315 33 133 708 470 230 0 0 345 62

80% 95%
Percentage 80% 0% 1% 7% 5% 2% 0% 0% 3% 1%

May'2
10037 9092 45 100 382 171 0 0 0 96 123
3
91% 97%
Percentage 91% 0% 1% 4% 2% 0% 0% 0% 1% 1%

Jun'23 9044 8251 75 59 247 247 0 85 0 27 31

91% 98%
Percentage 91% 1% 1% 3% 3% 0% 1% 0% 0% 0%
 ORDER & OCT DATA (1649)

PENDING Credit Vehicle PEAK/ MODIFIE

Mont Total Orders BM BM not IBB ORDER Limit not Connectivity MONTH Low Late OCT D OCT %
h Achieved Defined Order PROCESSED Orders available issuse END Volume Service (C+G)

9572 8223 26 219 460 204 164 0 0 143 42

Apr'23

86% 0% 2% 5% 2% 2% 0% 0% 1% 0%
Percentage 86% 97%

May'2 7547 6765 67 45 314 151 0 0 0 75 94

3

90% 1% 1% 4% 2% 0% 0% 0% 1% 1%
Percentage 90% 96%

7995 7323 131 53 186 211 0 50 0 13 14

Jun'23

92% 2% 1% 2% 3% 0% 1% 0% 0% 0%
Percentage 92% 98%
 OCT ACHIEVED 1565 OCT ACHIEVED 1649
98%
97% 97%
97% 98%
95%
91% 91%
80% 92%
90%

86%

Apr'23 May'23 Jun'23 Apr'23 May'23 Jun'23

OCT MODIFIED OCT %(C+G) OCT MODIFIED OCT %(C+G)

1565 1649
Month OCT MODIFIED OCT %(C+G) MODIFIED OCT %
Month OCT
(C+G)
Apr'23 80% 95% Apr'23 86% 97%
May'23 91% 97% May'23 90% 97%
Jun'23 91% 98% Jun'23 92% 98%
 MANPOWER PRODUCTIVITY / DAY (IN VOL)
Total Manpower
Sales Manpower
Month Inward Volume MRV Volume Monthly Month Days Productivity
Volume Attendance
Volume / Day (In Vol)
Apr-23 2912.38 2400 268 5,580 702 26 7.95
May-23 2915.31 2517 331 5,764 729 27 7.91
Jun-23 2823.69 2826 271 5,920 702 26 8.43
8.50 8.43
8.40
8.30
8.20
8.10
8.00 7.95 7.91
7.90
7.80
7.70
7.60
Apr-23 May-23 Jun-23
 Inward Vehicle Report

Total
MONTH Vehicle Unloaded on Detained
%
Reasons for Inward
same day Vehicles Detention volume
Reported

Apr'23 224 224 0 100% Nil 2400

May'23 228 228 0 100% Nil 2517

Jun'23 245 245 0 100% Nil 2826

 MRV Details
Month Apr-23 May-23 Jun-23
Reason Vol % Vol % Vol %
BBND 26030 10% 0 0% 18864 7%
A08-Mtl return - prod/pack/shd
0 0% 0 0% 38 0%
discrepancy
A09-Mtl return - excess material billed 94076 36% 272717 83% 214353 79%

A25-Prices wrongly charged 0 0% 0 0% 0 0%

IBE-Wrong Order Placed by Customer 1020 0% 1104 0% 3200 1%

IBP-Shop Closed 5202 2% 9736 3% 13029 5%
non confirming material 2795 1% 4522 1% 2528 1%
Z14-Awaaz Punching Errors 134706 51% 42280 13% 18739 7%
Old material 4001 0 0% 0 0% 0 0%
Damage material-3001 0 0% 0 0% 40 0%

Grand Total 263828 100% 330358 100% 270790 100%

 MRV invoice level

007- A09-Mtl
Billed A08-Mtl return return - A25-Prices IBE-Wrong non Z14- Old Damage
Month -
but not prod/pack/shd excess Order
wrongly Placed IBP-Shop confirming Awaaz material material- Total
despatc discrepancy material charged Customer by Closed material Punching 4001 3001
hed billed Errors

No of
inv 7 0 491 0 2 41 15 522 0 0 1078
Apr'23
Volume 26030 0 94076 0 1020 5202 2795 134706 0 0 263828
No of
inv 0 0 687 0 2 47 28 214 0 0 978
May'23
Volume 0 0 272717 0 1104 9736 4522 42280 0 0 330358
No of
inv 11 2 422 0 1 28 26 178 0 1 669
Jun'23
Volume 18864 38 214353 0 3200 13029 2528 18739 0 40 270790
 ICM FSM & shade card
details

ICMs FSMs (Regular) Shade Card (FSM)(7001)

Month Doc No's volume Month Doc No's Volume Month No's FSM Volume

Apr'23 3 48 Apr'23 18 81.116 Apr'23 503 6904

May'23 1 2 May'23 8 60.2 May'23 572 39937

Jun'23 0 0 Jun'23 20 136.6 Jun'23 512 6721

Grand Total 4 50 Grand Total 46 278 Grand Total 1587 53563

 Highest Dispatches in Single Day

Month Qty in Kl (Vol) Date

Apr'23 160 13-04-2023

May'23 198.9 05-05-2023

Jun'23 319.0 30-06-2023

Grand Total 678

 Barcoding Dashboard Report

Month Inward Outward

APRIL’23 92% 75%

May’23 91% 84%

June’23 96% 87%

 RST

MONTH No of SKU's Counted Reason for not counted

APRIL’23 120 Due to continues billing

May’23 711 Due to continues billing

June’23 504 Due to continues billing

 WMS DATA

Average WMS % Average WMS %

Month

(Bin Coverage) (Volume Coverage)

APRIL’23 89% 82%

May’23 91% 85%

June’23 91% 85%

 Source of Damages

Volume (3001 TO 5101)

MONTH (101,653,311)

APRIL’23 4

MAY’23 12

JUNE’23 3.8
 Route wise oct
Route April May June
ABBIGERE 91% 92% 91%
BASAVESHWARANAGAR 92% 93% 92%
BUDIGERE 93% 94% 93%
DODDABALLAPUR 93% 87% 93%
HEGDENAGAR 92% 87% 92%
HESARAGATTA 88% 93% 88%
JC_NAGAR 96% 95% 96%
KAMAKSHIPALYA 85% 85% 85%
KUDUR 89% 83% 89%
MAGADI 91% 93% 91%
NANDINI_LAYOUT 86% 89% 86%
Rajajinagar 91% 87% 91%
SHAMPUR 95% 94% 95%
SHESHADRIPURAM 95% 93% 95%
Thyamagondu 89% 85% 89%
VIJAYAPUR 90% 87% 90%
 Safety Training & Other Activities

 Safety Mock Drill conducted Monthly.

 Daily Safety Check-List Updation.

 100% Segregation of Location stock with Proper Demarcation.

 Dispatches of Gift Items/Shade Cards are fully streamlined.

 Day wise Tracking of OCT

 Weekly discussion with CFA team on OCT Lost cases and barcode
scanning.

 Weekly discussion with transporter

 ACHIVEMENTS

 Zero vehicle detention from April’22 TO June’23.

 OCT & ICT improved daily basis.
 Stacking materials arrangements on daily basis.
 Barcode devices percentage improved on daily basis.
 On Time Dispatch Delivery for the Main Dealers.
 Supporting for direct billing service entry closer.
 Daily basis ZOFR updated in system
 Support Required

 Sunday Working need to cancel; due to very less billing and dispatches are
Happening.
 Please exchange the Barcode devices since we’re using these devices from
the start (5+ years old); because of barcode not reading/scanning correctly.
 New RO Water purifier is required in terms of everyone’s health safety.
 Wifi/Camera/Lan network control boxes need to be changed (not properly
assembled).
 Old cameras link not working since 3+ months.
 Need to hire 1 employee for ESS Maintenance.
 Warehouse UPS device not working properly.
 2 Landlines connection are not in working condition; need to resolve.
 Required vacuum cleaner for frequent dust maintenance of Printers & PC’s.
Thank
You!
Life Care Logistic Pvt. Ltd