MONTHLY SALES REPORT {{$data["month"]}} {{$data["year"]}}
{PAGENO}/{nb}
 
REPORT FOR: {{$data["report_for"]}}
OVERALL SALES
 
NET SALE

{{number_format($data["overall_sales"]->net_sales)}} CTNs
TARGET ACHIEVEMENT NATIONAL CONTRIBUTION
    
    
    
{{number_format($data["overall_sales"]->target)}} Units {{number_format($data["overall_sales"]->achievment , 2)}} % {{number_format($data["overall_sales"]->national_contribution)}}%
GROWTH
GOLW --
GOLM {{number_format($data["overall_sales"]->golm , 2)}}%
GOLY {{number_format($data["overall_sales"]->goly) , 2}}%
KPIs
AVG. BILL VALUE
{{number_format($data["overall_sales"]->avg_bill_value)}} Rs
AVG. SKU/ORDER
{{number_format($data["overall_sales"]->avg_sku_per_order)}}
AVG. DROP SIZE
{{number_format($data["overall_sales"]->drop_size)}}
 PRODUCTIVITY
{{number_format($data["overall_sales"]->productivity_value , 2)}}%
KEY TRENDS
 

  TGT. ACHIVEMENT

 {{number_format($data["overall_sales"]->tgt_achievment->tgt_acheivment , 2)}}%
TTL. TARGET: {{number_format($data["overall_sales"]->tgt_achievment->ttl_target)}}
TGT. TILL DATE: {{number_format($data["overall_sales"]->tgt_achievment->ttl_till_date)}}
ACH. TILL DATE: {{number_format($data["overall_sales"]->tgt_achievment->ach_till_date)}}%
GROSS SALEs: {{number_format($data["overall_sales"]->tgt_achievment->gross_sales)}} CTNs
DAILY RUN RATE: {{number_format($data["overall_sales"]->tgt_achievment->daily_run_rate)}}CTNs
REQUIRED RUN RATE : {{number_format($data["overall_sales"]->tgt_achievment->required_run_rate)}}CTNs
PROJECTED SALES: {{number_format($data["overall_sales"]->tgt_achievment->projected_sales)}}CTNs
PROJECTED ACH%: {{number_format($data["overall_sales"]->tgt_achievment->projected_ach , 2)}}%
@foreach($data["overall_sales"]->town_coverage->category_wise as $town) @endforeach

  TOWN COVERAGE

 {{number_format($data["overall_sales"]->town_coverage->town_coverage , 2)}}%
{{$town->cat_name}} {{$town->sale}}CTNs

  PRODUCTIVITY

 {{number_format($data["overall_sales"]->productivity_value , 2)}}%
TTL. DISTRIBUTORS: {{number_format($data["overall_sales"]->productivity->total_distributors)}}
PROD. DISTRIBUTORS: {{number_format($data["overall_sales"]->productivity->active_distributors)}}
TTL. VISITS: {{number_format($data["overall_sales"]->productivity->total_visits)}}
TTL. ORDERS: {{number_format($data["overall_sales"]->productivity->total_orders)}}
STRIKE RATE: {{number_format($data["overall_sales"]->productivity->strike_rate , 2)}}%
PHONE ORDERS: {{number_format($data["overall_sales"]->productivity->phone_orders)}}
VISIT COMPLIANCE: {{number_format($data["overall_sales"]->productivity->visit_compliance , '2')}}%
NEW DISTRIBUTORS: {{number_format($data["overall_sales"]->productivity->new_distributors)}}
@foreach($data["overall_sales"]->brand_wise->brand_wise as $brand) @endforeach

  TOP BRANDS

 10
{{$brand->brand_name}} {{number_format($brand->total_sale)}} CTNs
SEGMENTS REPORT
 
@foreach($data['segments'] as $distributor_name=>$distributor_data) @endforeach @foreach($data['segments'] as $distributor) @endforeach @foreach($data['segments'] as $distributor) @endforeach @foreach($data['segments'] as $distributor) @endforeach @foreach($data['segments'] as $distributor) @endforeach @foreach($data['segments'] as $distributor) @endforeach @foreach($data['segments'] as $distributor) @endforeach @foreach($data['segments'] as $distributor) @endforeach @foreach($data['segments'] as $distributor) @endforeach @foreach($data['segments'] as $distributor) @endforeach @foreach($data['segments'] as $distributor) @endforeach @foreach($data['segments'] as $distributor) @endforeach
{{$distributor_name}}
SALE
CONTRIBUTION		 {{ $total_sales[0]->total_sale == 0 || $data['segments'][$distributor_name][0]->ttl_execution == 0 ? 0:number_format((($data['segments'][$distributor_name][0]->ttl_execution / $total_sales[0]->total_sale) * 100) , 2) }}%
TTL. DISTRIBUTORS:{{$distributor[0]->total_distributors}}
ACT. DISTRIBUTORS:{{$distributor[0]->active_distributors ? $distributor[0]->active_distributors : 0}}
TTL. VISITS:{{$distributor[0]->total_visits}}
TTL. ORDERS:{{$distributor[0]->total_orders}}
STRIKE RATE:{{ $distributor[0]->total_distributors != 0 ? number_format(($distributor[0]->total_visits_for_strike_rate/$distributor[0]->total_distributors)* 100 , 2) : 0}}%
PHONE ORDERS:{{$distributor[0]->phone_orders}}
VISIT COMPLIANCE:{{number_format($distributor[0]->visit_compliance , 2)}}%
NEW DISTRIBUTORS:{{$distributor[0]->new_distributors}}
TTL. BOOKING:{{$distributor[0]->ttl_booking ? number_format($distributor[0]->ttl_booking) : 0 }} CTNs
TTL. EXECUTION:{{$distributor[0]->ttl_execution ? number_format($distributor[0]->ttl_execution) : 0}} CTNs
TTL. PENDING SALES:{{$distributor[0]->ttl_pending ? $distributor[0]->ttl_pending : 0}} CTNs
TOWNS ANALYSIS
 
ZONE: {{$data["towns_analysis"]->area_name}}
COVERAGE

{{ number_format($data["towns_analysis"]->coverage , 2)}}%
TTL. TOWNS
{{$data["towns_analysis"]->ttl_towns}}
 PROD. TOWNS
{{$data["towns_analysis"]->productive_towns}}
TTL. DIST. {{ number_format($data["towns_analysis"]->total_distributors)}}
VISITED DIST. {{ number_format($data["towns_analysis"]->visited_distributors)}}
PROD. DIST. {{ number_format($data["towns_analysis"]->productive_distributors)}}
TTL. TARGET: {{ number_format($data["towns_analysis"]->ttl_target)}}
NET SALES: {{ number_format($data["towns_analysis"]->net_sales)}}
ACHIEVEMENT: {{ number_format($data["towns_analysis"]->achievment , 2)}}%
TTL. POPULATION: {{ number_format($data["towns_analysis"]->total_population)}}
TTL. PIECES: {{ number_format($data["towns_analysis"]->ttl_pieces)}}
P.C. CONSUMPTION: {{ number_format($data["towns_analysis"]->pcc,'2')}}
AVG. BILL VALUE: Rs. {{ number_format($data["towns_analysis"]->avg_bill_value)}}
AVG. SKU/ORDER: {{ number_format($data["towns_analysis"]->avg_sku_per_order)}}
AVG. DROP SIZE: {{ number_format($data["towns_analysis"]->avg_drop_size)}}
@foreach($data["towns_analysis"]->category_wise as $cat_name=>$cat) @foreach($cat["result"] as $sn=>$category) @php($row_count++) @if($row_count % 11 == 0)
SN TOWNS TTL.
DIST.		 VISITED
DIST.		 PROD.
DIST.		 TTL.
TARGET		 NET
SALES		 P.C.C AVG. BILL
VALUE		 AVG.
SKU/ORDER		 AVG.
DROP SIZE		 STRIKE
RATE		 VISIT
COMPL.		 PROD. % GOLM GOLY
{{$cat_name}} TOTAL TOWNS:{{$cat["total_towns"]}}
{{$sn+1}} {{$category->city_name}} {{number_format($category->ttl_distributors)}} {{number_format($category->visited_distributors)}} {{number_format($category->productive_distributors)}} {{number_format($category->ttl_target)}} {{number_format($category->net_sales)}} {{number_format($category->pcc,'2')}} {{number_format($category->avg_bill_value)}} {{number_format($category->avg_sku_per_order)}} {{number_format($category->avg_drop_size)}} {{number_format($category->strike_rate , 2)}}% {{number_format($category->visit_compliance , 2)}}% {{number_format($category->productivity , 2)}}% {{number_format($category->growth_last_month , 2)}}% {{number_format($category->growth_last_year , 2)}}%
@endif @endforeach @php($row_count+1) @if($row_count % 11 == 0)
SN TOWNS TTL.
DIST.		 VISITED
DIST.		 PROD.
DIST.		 TTL.
TARGET		 NET
SALES		 P.C.C AVG. BILL
VALUE		 AVG.
SKU/ORDER		 AVG.
DROP SIZE		 STRIKE
RATE		 VISIT
COMPL.		 PROD. % GOLM GOLY
TOTAL: {{number_format($cat["total"]->ttl_distributors)}} {{number_format($cat["total"]->visited_distributors)}} {{number_format($cat["total"]->productive_distributors)}} {{number_format($cat["total"]->ttl_target)}} {{number_format($cat["total"]->net_sales)}} {{number_format($cat["total"]->pcc,'2')}} {{number_format($cat["total"]->total_orders ?( $cat["total"]->net_sales / $cat["total"]->total_orders) : 0 , '2')}} {{number_format($cat["total"]->total_orders ?( $cat["total"]->total_skus / $cat["total"]->total_orders) : 0 , '2')}} {{number_format($cat["total"]->total_orders ?( $cat["total"]->total_qty / $cat["total"]->total_orders) : 0 , '2')}} {{number_format($cat["total"]->strike_rate)}} {{number_format($cat["total"]->visit_compliance)}} {{number_format($cat["total"]->productivity)}} {{number_format($cat["total"]->net_sales ? (($cat["total"]->net_sales - $cat["total"]->growth_last_month)/$cat["total"]->net_sales) * 100 : 0 , 2)}}% {{number_format($cat["total"]->net_sales && $cat["total"]->growth_last_year && $cat["total"]->growth_last_year !=0 ? (($cat["total"]->net_sales - $cat["total"]->growth_last_year)/$cat["total"]->net_sales) * 100 : 0 , 2)}}%
@endif @endforeach
SN TOWNS TTL.
DIST.		 VISITED
DIST.		 PROD.
DIST.		 TTL.
TARGET		 NET
SALES		 P.C.C AVG. BILL
VALUE		 AVG.
SKU/ORDER		 AVG.
DROP SIZE		 STRIKE
RATE		 VISIT
COMPL.		 PROD. % GOLM GOLY
BRAND SALES ANALYSIS
 
ZONE: {{$data["brand_sales"]->area_name}}
TOTAL SKUS
{{$data["brand_sales"]->total_skus}}
SOLD SKUS
{{$data["brand_sales"]->sold}}
NET SALES
{{number_format($data["brand_sales"]->net_sales)}}CTNs
TARGET
{{number_format($data["brand_sales"]->ttl_target)}}
ACHIEVEMENT
{{number_format($data["brand_sales"]->achievment , 2)}}%
AVG. DROP SIZE
{{number_format($data["brand_sales"]->avg_drop_size)}}
NATIONAL CONT. %
{{number_format($data["brand_sales"]->national_contribution , 2)}}%
@foreach($data["brand_sales"]->brand_results as $key=>$brand) @endforeach
SN BRAND_ID BRAND TTL.SKUs SOLD SKUs TARGET NET SALES ACH. % AVG. DROP SIZE ZONAL COVERAGE CONTRIBUTION GOLM GOLY
{{$key + 1}} {{$brand->id}} {{$brand->brand_name}} {{$brand->ttl_skus}} {{$brand->skus_sold}} {{$brand->target}} {{$brand->net_sales}} {{number_format($brand->ach , 2)}}% {{number_format($brand->avg_drop_size)}} {{number_format($brand->zonal_coverage , 2)}}% {{number_format($brand->contribution,'2')}}% {{number_format($brand->golm,'2')}}% {{number_format($brand->goly),'2'}}%