DAILY BOOKING REPORT {{date('d F Y',strtotime($date))}}
          {PAGENO}/{nb}
 
REPORT FOR: DANISH PESHIMAM          
{{--page 1 start--}}
OVERVIEW
 
OVERALL BOOKING

Rs. {{shahiNumberFormat(@$overall_booking['overall_total'])}}

@if(@$overall_booking['growth']>0) {{shahiNumberFormat(@$overall_booking['growth'],2)}}% @else {{shahiNumberFormat(@$overall_booking['growth'],2)}}% @endif

TOTAL UNITS CARTONS DOZENS HALF DOZENS
    
    
    
    
{{shahiNumberFormat(@$overall_booking['unit_total'])}} {{shahiNumberFormat(@$overall_booking['CTN'])}} {{shahiNumberFormat(@$overall_booking['Dz'])}} {{shahiNumberFormat(@$overall_booking['HDoz'])}}
RETAIL VISITS
PRODUCTIVITY {{shahiNumberFormat(@$retails_visits['productivity'],2)}}%
PLAN ADHERENCE {{shahiNumberFormat(@$retails_visits['adherence'],2)}}%
PLANNED
{{shahiNumberFormat(@$retails_visits['planned'])}}
VISITED
{{shahiNumberFormat(@$retails_visits['visited'])}}
UN-VISITED
{{shahiNumberFormat(@$retails_visits['unvisited'])}}
PRODUCTIVE
{{shahiNumberFormat(@$retails_visits['productive'])}}

KEY TRENDS
TOTAL SRs {{shahiNumberFormat(@$keyTrends['TOTAL SRs'])}}
ACTIVE SRs {{shahiNumberFormat(@$keyTrends['ACTIVE SRs'])}}
ABSENT SRs {{shahiNumberFormat(@$keyTrends['ABSENT SRs'])}}
AVG. SHIFT HRs @if(@$keyTrends['AVG. SHIFT HRs'] != '') {{date(" H ",strtotime(@$keyTrends['AVG. SHIFT HRs']))}} HRs {{date(" i ",strtotime(@$keyTrends['AVG. SHIFT HRs']))}} MINs @endif
AVG. MARKET HRs @if(@$keyTrends['AVG. MARKET HRs'] != '') {{date(" H ",strtotime(@$keyTrends['AVG. MARKET HRs']))}} HRs {{date(" i ",strtotime(@$keyTrends['AVG. MARKET HRs']))}} MINs @endif
AVG. TIME/Shop @if(@$keyTrends['AVG. TIME/Shop'] != '') {{date(" i ",strtotime(@$keyTrends['AVG. TIME/Shop']))}} MINs {{date(" s ",strtotime(@$keyTrends['AVG. TIME/Shop']))}} SECs @endif
AVG. Order Value Rs. {{shahiNumberFormat(@$keyTrends['AVG. Order Value'])}}
AVG. SKUs/Order {{shahiNumberFormat(@$keyTrends['AVG. SKUs/Order'],2)}}
AVG. Drop Size {{shahiNumberFormat(@$keyTrends['AVG. Drop Size'],2)}}
Deviation {{shahiNumberFormat(@$keyTrends['Deviation'])}} %
@foreach($top_coverage['top_coverage'] as $key=>$row) @endforeach

TOP COVERED BRANDS
{{$key+1}}. {{@$row->name}} UNITS
{{shahiNumberFormat(@$row->tb_qty)}}
 REVENUE
RS. {{shahiNumberFormat(@$row->tb_revenue)}}
 
{{shahiRound(($row->retialer_count/$retails_visits['productive'])*100,2)}}%
@foreach($top_distributors['top_distributors'] as $key=>$row) @endforeach

TOP DISTRIBUTORS
{{@$key+1}}. {{$row->name}}
REGION: {{$row->region_name}}		 UNITS
{{shahiNumberFormat(@$row->tb_qty)}}
 REVENUE
RS. {{shahiNumberFormat(@$row->tb_revenue)}}
 
{{shahiRound(($row->retialer_count/$retails_visits['productive'])*100,2)}}%
@foreach($top_regions['top_regions'] as $key=>$row) @endforeach

TOP REGIONS
{{@$key+1}} {{@$row->name}} UNITS
{{shahiNumberFormat(@$row->tb_qty)}}
 REVENUE
RS. {{shahiNumberFormat(@$row->tb_revenue)}}
 
{{shahiRound(($row->retialer_count/$retails_visits['productive'])*100,2)}}%
{{--page 1 end--}} {{--page 2 start--}}
SEGMENT REPORT
 
GENERAL TRADE
SALE
CONTRIBUTION		 65%
WHOLE SALE
SALE
CONTRIBUTION		 20%
WHOLE LMT
SALE
CONTRIBUTION		 10%
IMT
SALE
CONTRIBUTION		 2.5%
HORECA
SALE
CONTRIBUTION		 2.5%
PLANNED SHOPS 4,098 4,098 4,098 4,098 4,098
VISITED SHOPS 4,098 4,098 4,098 4,098 4,098
PRODUCTIVE SHOPS 4,098 4,098 4,098 4,098 4,098
STRIKE RATE 70% 54% 52% 50% 30%
PRODUCTIVITY 70% 54% 52% 50% 30%
TOTAL BOOKING Rs. 10,234,098 Rs. 10,234,098 Rs. 10,234,098 Rs. 10,234,098 Rs. 10,234,098
AVG. ORDER VALUE Rs. 4,098 Rs. 4,098 Rs. 4,098 Rs. 4,098 Rs. 4,098
AVG. SKU/ORDER 2.5 2.5 2.5 2.5 2.5
AVG. DROP SIZE 2.5 2.5 2.5 2.5 2.5
AVG. TIME/SHOP 02 MINs 55 SECs 02 MINs 55 SECs 02 MINs 55 SECs 02 MINs 55 SECs 02 MINs 55 SECs
NEW OUTLETS 20 20 20 20 20
{{--page 2 end--}} {{--page 3 start--}}
TOP 10 COVERED BRANDS
 
DISTRIBUTION REPORT
SN DISTRIBUTORS ASM/TSM PLANNED VISITS ACTUAL VISITS BRAND 1 BRAND 2 BRAND 3 BRAND 4 BRAND 5
C. OUTLETS COV. % C. OUTLETS COV. % C. OUTLETS COV. % C. OUTLETS COV. % C. OUTLETS COV. %
1 Madni Traders Utba Aziz 2,000 1,900 999,999 68% 999,999 68% 999,999 68% 999,999 68% 999,999 68%
1 Madni Traders Utba Aziz 2,000 1,900 999,999 68% 999,999 68% 999,999 68% 999,999 68% 999,999 68%
1 Madni Traders Utba Aziz 2,000 1,900 999,999 68% 999,999 68% 999,999 68% 999,999 68% 999,999 68%
1 Madni Traders Utba Aziz 2,000 1,900 999,999 68% 999,999 68% 999,999 68% 999,999 68% 999,999 68%
1 Madni Traders Utba Aziz 2,000 1,900 999,999 68% 999,999 68% 999,999 68% 999,999 68% 999,999 68%
SN DISTRIBUTORS ASM/TSM PLANNED VISITS ACTUAL VISITS BRAND 6 BRAND 7 BRAND 8 BRAND 9 BRAND 10
C. OUTLETS COV. % C. OUTLETS COV. % C. OUTLETS COV. % C. OUTLETS COV. % C. OUTLETS COV. %
1 Madni Traders Utba Aziz 2,000 1,900 999,999 68% 999,999 68% 999,999 68% 999,999 68% 999,999 68%
1 Madni Traders Utba Aziz 2,000 1,900 999,999 68% 999,999 68% 999,999 68% 999,999 68% 999,999 68%
1 Madni Traders Utba Aziz 2,000 1,900 999,999 68% 999,999 68% 999,999 68% 999,999 68% 999,999 68%
1 Madni Traders Utba Aziz 2,000 1,900 999,999 68% 999,999 68% 999,999 68% 999,999 68% 999,999 68%
1 Madni Traders Utba Aziz 2,000 1,900 999,999 68% 999,999 68% 999,999 68% 999,999 68% 999,999 68%
{{--page 3 end--}} {{--page 4 start--}}
REGIONAL REPORT
 
REGION LAHORE

OVERALL
BOOKING

Rs. 1,100,000
32%
Total Units
90,400
 Cartons
70,400 CTNs
 Bundles
20,000 BNDLs

RETAIL
VISITS

PRODUCTIVITY
99%
STRIKE RATE
99%
PLANNED
8,659
 VISITED
6,214
UN-VISITED
999,999
PRODUCTIVE
4,299
TOTAL SRs
11
ACTIVE SRs
10
ABSENT SRs
1
AVG. SHIFT HRs
05:45
AVG. MARKET HRs
03:05
AVG. TIME/SHOP
03:45
AVG. ORDER VALUE
Rs. 10,555,555
AVG. SKUs/ORDER
4.5
AVG. DROP SIZE
6.19 Units

DISTRIBUTION
REPORT
SN DISTRIBUTOR TOTAL SRs ACTIVE SRs SHIFT HRs MARKET HRs AVG. TIME/ SHOP PLANNED VISITS ACTUAL VISITS PRODUCTIVE OUTLETS PRODUCTIVITY BOOKING UNITS AVG. BILL VALUE AVG. SKU/ ORDER AVG. DROP VALUE
1 ABC Trader 27 27 08:29 03:49 2:58 877 599 610 68% Rs. 99,000,000 9,240 Rs. 1,255 3.1 2.5
1 ABC Trader 27 27 08:29 03:49 2:58 877 599 610 68% Rs. 99,000,000 9,240 Rs. 1,255 3.1 2.5
1 ABC Trader 27 27 08:29 03:49 2:58 877 599 610 68% Rs. 99,000,000 9,240 Rs. 1,255 3.1 2.5
1 ABC Trader 27 27 08:29 03:49 2:58 877 599 610 68% Rs. 99,000,000 9,240 Rs. 1,255 3.1 2.5
1 ABC Trader 27 27 08:29 03:49 2:58 877 599 610 68% Rs. 99,000,000 9,240 Rs. 1,255 3.1 2.5
{{--page 4 end--}} {{--page 5 start--}}
PRODUCT COVERAGE REPORT
 
DIVISION RANGE A
TOTAL SKUS
32
BOOKED SKUS
15
TOTAL BOOKING
Rs. 99,000,000
TOTAL BOOKED UNITS
25,764
COVERAGE
78%
SALES CONTRIBUTION
46%
AVG. DROP SIZE
15.15
SN SKU PRODUCT NAMEs TOTAL BOOKING BOOKED UNITS COVERAGE AVG. DROP SIZE CONTRIBUTION
1 254 Fry O Sweet & Sour Rs10 (12X6) Rs. 99,000,000 4741 78% 15.15 52.45%
1 254 Fry O Sweet & Sour Rs10 (12X6) Rs. 99,000,000 4741 78% 15.15 52.45%
1 254 Fry O Sweet & Sour Rs10 (12X6) Rs. 99,000,000 4741 78% 15.15 52.45%
1 254 Fry O Sweet & Sour Rs10 (12X6) Rs. 99,000,000 4741 78% 15.15 52.45%
1 254 Fry O Sweet & Sour Rs10 (12X6) Rs. 99,000,000 4741 78% 15.15 52.45%
1 254 Fry O Sweet & Sour Rs10 (12X6) Rs. 99,000,000 4741 78% 15.15 52.45%
1 254 Fry O Sweet & Sour Rs10 (12X6) Rs. 99,000,000 4741 78% 15.15 52.45%
1 254 Fry O Sweet & Sour Rs10 (12X6) Rs. 99,000,000 4741 78% 15.15 52.45%
1 254 Fry O Sweet & Sour Rs10 (12X6) Rs. 99,000,000 4741 78% 15.15 52.45%
1 254 Fry O Sweet & Sour Rs10 (12X6) Rs. 99,000,000 4741 78% 15.15 52.45%
1 254 Fry O Sweet & Sour Rs10 (12X6) Rs. 99,000,000 4741 78% 15.15 52.45%
1 254 Fry O Sweet & Sour Rs10 (12X6) Rs. 99,000,000 4741 78% 15.15 52.45%
1 254 Fry O Sweet & Sour Rs10 (12X6) Rs. 99,000,000 4741 78% 15.15 52.45%
1 254 Fry O Sweet & Sour Rs10 (12X6) Rs. 99,000,000 4741 78% 15.15 52.45%
1 254 Fry O Sweet & Sour Rs10 (12X6) Rs. 99,000,000 4741 78% 15.15 52.45%
{{--page 5 end--}}