WEEKLY SALES REPORT {{Carbon::now()->format('F Y')}}
{PAGENO}/{nb}
 
REPORT DATE: {{Carbon::parse($currentWeekStartDate)->format('jS M')}} - {{Carbon::parse($currentWeekEndDate)->format('jS M, Y')}}
OVERALL SALES
 
NET SALE

Rs. {{number_format($dailysale->net_sale_value,2)}}

@if($dailysale->GOLW >= 0) @else @endif {{number_format(abs($dailysale->GOLW),2)}}%
{{-- --}} {{-- --}} {{-- --}}
TOTAL UNITS CARTONSBUNDLES
    
    
--}} {{--
    
--}} {{--
{{number_format($dailysale->ttl_sale_units)}} Units {{number_format($dailysale->ttl_ctns_sale,2)}} CTNs20,000 BNDLs
GROWTH
GOLW {{number_format($dailysale->GOLW)}}%
GOLM {{number_format($dailysale->GOLM)}}%
GOLY {{number_format($dailysale->GOLY)}}%
KPIs
AVG. BILL VALUE
Rs. {{number_format($dailysale->avg_bill_value,2)}}
AVG. SKU/ORDER
{{number_format($dailysale->avg_sku_per_order,2)}}
AVG. DROP SIZE
{{number_format($dailysale->avg_drop_size,2)}}
PRODUCTIVITY
{{number_format($dailybooking->visit_productivity,2)}}%
KEY TRENDS
 

  TGT. ACHIVEMENT

 {{$monthlysale->ttl_target == 0 ? 'NA':number_format($monthlysale->target_achivement,2).'%'}}
TTL. TARGET: {{$monthlysale->ttl_target == 0 ? 'NA':number_format($monthlysale->target_achivement,2)}}
TGT. TILL DATE: {{$monthlysale->ttl_target == 0 ? 'NA':number_format($monthlysale->target_till_date,2)}}
ACH. TILL DATE: {{$monthlysale->ttl_target == 0 ? 'NA':number_format($monthlysale->ach_till_date,2).'%'}}
GROSS SALEs: {{$monthlysale->ttl_target == 0 ? 'NA':'Rs. '.number_format($dailysale->ttl_gross_sale,2)}}
DAILY RUN RATE: {{$monthlysale->ttl_target == 0 ? 'NA':number_format($monthlysale->daily_run_rate,2)}}
REQUIRED RUN RATE: {{$monthlysale->ttl_target == 0 ? 'NA':number_format($monthlysale->required_run_rate,2)}}
PROJECTED SALES: {{$monthlysale->ttl_target == 0 ? 'NA':number_format($monthlysale->projected_sale,2)}}
PROJECTED ACH%: {{$monthlysale->ttl_target == 0 ? 'NA':number_format($monthlysale->projected_achv,2).'%'}}

  EXECUTION

 {{number_format($dailysale->execution,2)}}%
TTL. BOOKING: Rs. {{number_format($dailysale->ttl_booked_value,2)}}
TTL. DISPATCH: Rs. {{number_format($dailysale->ttl_dispatched_value,2)}}
TTL. EXECUTION: Rs. {{number_format($dailysale->ttl_executed_value,2)}}
TTL. CANCELLATION: Rs. {{number_format($dailysale->ttl_cancelled_value,2)}}
TTL. SPOT SALEs: Rs. {{number_format($dailysale->ttl_spot_sale_value,2)}}
TTL. COUNTER SALEs: Rs. {{number_format($dailysale->ttl_counter_sale_value,2)}}
TTL. RETURN: Rs. {{number_format($dailysale->ttl_returned_value,2)}}
TTL. PENDING SALEs: Rs. {{number_format($dailysale->ttl_pending_value,2)}}

  PRODUCTIVITY

 {{number_format($dailybooking->visit_productivity,2)}}%
PLANNED. VISITs: {{number_format($dailybooking->ttl_planned_visits)}}
ACTUAL VISITs: {{number_format($dailybooking->ttl_visits)}}
MISSED VISITs: {{number_format($dailybooking->missed_visits)}}
STRIKE RATE: {{number_format($dailybooking->strike_rate,2)}}%
PRODUCTIVE VISITs: {{number_format($dailybooking->ttl_productive_visits)}}
PHONE ORDERs: {{number_format($dailybooking->phone_order)}}
VISIT COMPLIANCE: {{number_format($dailybooking->visit_compliance,2)}}%
NEW SHOPs: {{number_format($dailybooking->new_shops)}}

 TEAM STRENGTH

 {{number_format($dailybooking->total_srs)}}
ACTIVE SRs: {{number_format($dailybooking->active_srs)}}
ABSENT SRs: {{number_format($dailybooking->absent_srs)}}
AVG. SHIFT HRs: {{$dailybooking->avg_shift_hours}}
AVG. MKT HRs: {{$dailybooking->avg_market_hours}}
AVG. TIME/SHOP MINs: {{$dailybooking->avg_shop_time}}
AVG. SALEs/SR: Rs. {{number_format($dailybooking->avg_sr_sale,2)}}
SEGMENTS REPORT
 
@foreach($channelsales as $channelsale) @endforeach @foreach($channelsales as $channelsale) @endforeach @foreach($channelsales as $channelsale) @endforeach @foreach($channelsales as $channelsale) @endforeach @foreach($channelsales as $channelsale) @endforeach @foreach($channelsales as $channelsale) @endforeach @foreach($channelsales as $channelsale) @endforeach @foreach($channelsales as $channelsale) @endforeach @foreach($channelsales as $channelsale) @endforeach @foreach($channelsales as $channelsale) @endforeach @foreach($channelsales as $channelsale) @endforeach @foreach($channelsales as $channelsale) @endforeach
{{$channelsale->segment_name}}
SALE
CONTRIBUTION		 {{number_format($channelsale->net_sale_value>0 && $dailysale->net_sale_value >0 ? ($channelsale->net_sale_value/$dailysale->net_sale_value)*100:0,2)}}%
PLANNED SHOPS:{{number_format($channelsale->ttl_planned_shops)}}
VISITED SHOPS:{{number_format($channelsale->ttl_visits)}}
PRODUCTIVE SHOPS:{{number_format($channelsale->ttl_productive_visits)}}
STRIKE RATE:{{number_format($channelsale->strike_rate)}}%
PRODUCTIVITY:{{number_format($channelsale->productivity)}}%
TOTAL BOOKING:{{number_format($channelsale->ttl_booked_unit_qty)}} Units
TOTAL DISPATCH:{{number_format($channelsale->ttl_dispatched_unit_qty)}} Units
TOTAL EXECUTION:{{number_format($channelsale->ttl_executed_unit_qty,2)}} Units
TOTAL CANCEL:{{number_format($channelsale->ttl_cancelled_unit_qty)}} Units
TOTAL RETURN:{{number_format($channelsale->ttl_returned_unit_qty)}} Units
TOTAL PENDING:{{number_format($channelsale->ttl_pending_unit_qty)}} Units
WEEKLY SALES EXECUTION
 
REGIONAL ANALYSIS
{{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} @foreach($regionalSales as $key=>$regionalSale) {{-- --}} {{-- --}} {{-- --}} {{-- --}} @endforeach
SN REGION RSM TOTAL BOOKING TOTAL DISPATCH NET EXECUTION SPOT SALES COUNTER SALESNET RETURNNET SALES GOLW%GOLM%GOLY%
VALUE UNITS VALUE UNITS % VALUE UNITS % VALUE UNITS VALUE UNITSVALUEUNITSVALUE UNITS
{{$key+1}} {{$regionalSale->region_name}} {{$regionalSale->rsm}} {{number_format($regionalSale->booked_value,2)}} {{number_format($regionalSale->booked_units)}} {{number_format($regionalSale->dispatched_value,2)}} {{number_format($regionalSale->dispatched_units)}} {{number_format($regionalSale->dispatched_units>0 && $regionalSale->booked_units >0 ? ($regionalSale->dispatched_units/$regionalSale->booked_units)*100:0,2)}}% {{number_format($regionalSale->executed_value,2)}} {{number_format($regionalSale->executed_units)}} {{number_format($regionalSale->executed_units>0 && $regionalSale->booked_units >0 ? ($regionalSale->executed_units/$regionalSale->booked_units)*100:0,2)}}% {{number_format($regionalSale->spot_sale_value,2)}} {{number_format($regionalSale->spot_sale_units)}} {{number_format($regionalSale->counter_sale_value,2)}} {{number_format($regionalSale->counter_sale_units)}}999,999999,999{{number_format($regionalSale->net_sale_value,2)}} {{number_format($regionalSale->net_sale)}} {{number_format(($regionalSale->net_sale_value_last > 0 ? (($regionalSale->net_sale_value - $regionalSale->net_sale_value_last)/$regionalSale->net_sale_value_last)*100 : ($regionalSale->net_sale_value/1)*100),2)}}%68%68%
WEEKLY KPIs ANALYSIS
 
PRODUCTIVITY

{{number_format($dailybooking->visit_productivity,2)}}%
STRIKE RATE
{{number_format($dailybooking->strike_rate,2)}}%
 VISIT COMPLIANCE
{{number_format($dailybooking->visit_compliance,2)}}%
PLANNED. VISITS: {{number_format($dailybooking->ttl_planned_visits)}}
ACTUAL VISITS: {{number_format($dailybooking->ttl_visits)}}
PRODUCTIVE VISITS: {{number_format($dailybooking->ttl_productive_visits)}}
TEAM STRENGTH: {{number_format($dailybooking->total_srs)}}
ACTIVE SRS: {{number_format($dailybooking->active_srs)}}
ABSENT SRS: {{number_format($dailybooking->absent_srs)}}
AVG. SHIFT HRS: {{($dailybooking->avg_shift_hours)}}
AVG. MKT HRS: {{($dailybooking->avg_market_hours)}}
AVG. TIME/SHOP: {{($dailybooking->avg_shop_time)}}
AVG. BILL VALUE: Rs. {{number_format($dailysale->avg_bill_value,2)}}
AVG. SKU/ORDER: {{number_format($dailysale->avg_sku_per_order,2)}}
AVG. DROP SIZE: {{number_format($dailysale->avg_drop_size,2)}}
@foreach($regionalBookings as $key=>$regionalBooking) @endforeach
SN REGION RSM TOTAL SRS ACTIVE SRS ABSENT SRS AVG. SHIFT HRS AVG. MARKET HRS AVG. TIME/ SHOP PLANNED VISITS ACTUAL VISITS PROD. VISITS STRIKE RATE VISIT COMPL. PROD.% AVG. BILL VALUE AVG. SKU/ ORDER AVG. DROP SIZE
{{$key+1}} {{$regionalBooking->region_name}} {{$regionalBooking->rsm}} {{number_format($regionalBooking->total_srs)}} {{number_format($regionalBooking->active_srs)}} {{number_format($regionalBooking->absent_srs)}} {{Carbon::createFromTimestamp(0)->addSeconds($regionalBooking->avg_shift_hours* 3600)->format('H:i')}} {{$regionalBooking->avg_market_hours}} {{$regionalBooking->avg_shop_time}} {{number_format($regionalBooking->ttl_planned_visits)}} {{number_format($regionalBooking->ttl_visits)}} {{number_format($regionalBooking->ttl_productive_visits)}} {{number_format($regionalBooking->strike_rate,2)}}% {{number_format($regionalBooking->visit_compliance,2)}}% {{number_format($regionalBooking->visit_productivity,2)}}% Rs. {{number_format($regionalBooking->visit_productivity,2)}} {{number_format($regionalBooking->avg_sku_per_order,2)}} {{number_format($regionalBooking->avg_drop_size,2)}}
MTD TARGET ANALYSIS
 
TARGET ACHIEVEMENT

{{$monthlysale->ttl_target == 0 ? 'NA':number_format($monthlysale->target_achivement,2).'%'}}
OVERALL TARGET
UNITS: {{$monthlysale->ttl_target == 0 ? 'NA':number_format($monthlysale->ttl_target)}}
GROSS VALUE: {{$monthlysale->ttl_target == 0 ? 'NA':'Rs. '.number_format($monthlysale->ttl_target_value,2)}}
NET SALES
UNITS: {{number_format($dailysale->ttl_sale_units,2)}}
GROSS VALUE: Rs. {{number_format($dailysale->net_sale_value,2)}}
TARGET TILL DATE
UNITS: {{$monthlysale->ttl_target == 0 ? 'NA':number_format($monthlysale->target_till_date)}}
GROSS VALUE: {{$monthlysale->ttl_target == 0 ? 'NA':'Rs. '.number_format($monthlysale->target_till_date_value,2)}}
ACH. TILL DATE {{$monthlysale->ttl_target == 0 ? 'NA':number_format($monthlysale->ach_till_date,2).'%'}}
UNITS: {{$monthlysale->ttl_target == 0 ? 'NA':number_format($monthlysale->target_till_date)}}
GROSS VALUE: {{$monthlysale->ttl_target == 0 ? 'NA':'Rs. '.number_format($monthlysale->target_till_date_value,2)}}
@foreach($regionalTargetSales as $key=>$targetsale) @endforeach
SN REGION RSM TARGET NET SALES OVERALL ACH. % TARGET TILL DATE ACHIVEMENT TILL DATE D.R.R. R.R.R. PROJECTED SALES PROJECTED ACH. %
VALUE UNITS VALUE UNITS
{{$key+1}} {{$targetsale->region_name}} {{$targetsale->rsm}} {{number_format($targetsale->ttl_target_value,2)}} {{number_format($targetsale->ttl_target)}} {{number_format($targetsale->net_sale_value,2)}} {{number_format($targetsale->net_sale)}} {{$targetsale->ttl_target == 0 ? 'NA':number_format($targetsale->target_achivement,2).'%'}} {{$targetsale->ttl_target == 0 ? 'NA':number_format($targetsale->target_till_date)}} {{$targetsale->ttl_target == 0 ? 'NA':number_format($targetsale->ach_till_date).'%'}} {{$targetsale->ttl_target == 0 ? 'NA':number_format($targetsale->daily_run_rate)}} {{$targetsale->ttl_target == 0 ? 'NA':number_format($targetsale->required_run_rate)}} {{$targetsale->ttl_target == 0 ? 'NA':number_format($targetsale->projected_sale)}} {{$targetsale->ttl_target == 0 ? 'NA':number_format($targetsale->projected_achv).'%'}}
TOP 10 COVERED BRANDS
 
REGIONAL REPORT
{{--@dd($brandCoverage,$regionalBookings,$brands)--}} @foreach($brands as $brand) @endforeach @foreach($regionalBookings as $key=>$regionalBooking) @foreach($brands as $brand) @php $coverage = collect($brandCoverage)->where('region_id',$regionalBooking->region_id)->where('brand_id',$brand->brand_id)->first(); @endphp @endforeach @endforeach
SN REGION RSM PLANNED VISITS ACTUAL VISITS{{$brand->brand_name}}
C. OUTLETS COV. % C. OUTLETS COV. % C. OUTLETS COV. % C. OUTLETS COV. % C. OUTLETS COV. %
{{$key+1}} {{$regionalBooking->region_name}} {{$regionalBooking->rsm}} {{number_format($regionalBooking->ttl_planned_visits)}} {{number_format($regionalBooking->ttl_visits)}}{{number_format(@$coverage->covered_outlets)}} {{number_format(@$coverage->covered_outlets > 0 && @$regionalBooking->assigned_outlets > 0 ? ((@$coverage->covered_outlets/@$regionalBooking->assigned_outlets) * 100) : 0,2)}}%
@foreach($divisions as $division) @php $cnt = 1; $divisiondata = collect($productCoverage)->where('division_id',$division->division_id)->all(); @endphp
PRODUCT COVERAGE REPORT
 
DIVISION: {{$division->division}}
TOTAL SKUS
{{number_format(collect($divisiondata)->sum('unique_skus'))}}
BOOKED SKUS
{{number_format(collect($divisiondata)->sum('booked_unique_skus'))}}
TOTAL BOOKING
Rs. {{number_format(collect($divisiondata)->sum('net_sale'))}}
TOTAL BOOKED UNITS
{{number_format(collect($divisiondata)->sum('net_sale_value'))}}
COVERAGE
{{number_format(collect($divisiondata)->sum('covered_outlets') >0 && collect($assignedOutlets)->sum('assigned_outlets') >0 ? (collect($divisiondata)->sum('covered_outlets')/collect($assignedOutlets)->sum('assigned_outlets'))*100:0)}} %
AVG. DROP SIZE
{{number_format(collect($divisiondata)->sum('net_sale') >0 && collect($divisiondata)->sum('total_orders') >0 ? (collect($divisiondata)->sum('net_sale')/collect($divisiondata)->sum('total_orders')):0)}}
SALES CONTRIBUTION
{{number_format(collect($divisiondata)->sum('net_sale') >0 && collect($productCoverage)->sum('net_sale') >0 ? (collect($divisiondata)->sum('net_sale')/collect($productCoverage)->sum('net_sale'))*100:0)}} %
@php $counter=1; $chunks = []; $firstRecords = array_slice($divisiondata, 0, 15); $chunks[] = $firstRecords; $trimmedObjects = array_slice($divisiondata, 15); while (!empty($trimmedObjects)) { $chunk = array_slice($trimmedObjects, 0, 19); $chunks[] = $chunk; $trimmedObjects = array_slice($trimmedObjects, 19); } @endphp @foreach($chunks as $key=>$chunk)
@foreach($chunk as $row) @endforeach
SN SKU PRODUCT NAMEs TOTAL BOOKING BOOKED UNITS COVERAGE AVG. DROP SIZE CONTRIBUTION
{{$counter++}} {{$row->item_sku}} {{$row->item_name}} Rs. {{number_format($row->net_sale_value,2)}} Rs. {{number_format($row->net_sale)}} {{number_format($row->covered_outlets >0 && collect($assignedOutlets)->sum('assigned_outlets') >0 ? ($row->covered_outlets/collect($assignedOutlets)->sum('assigned_outlets'))*100:0)}} % {{number_format($row->net_sale >0 && collect($divisiondata)->sum('total_orders') >0 ? ($row->net_sale/collect($divisiondata)->sum('total_orders')):0)}} {{number_format($row->net_sale >0 && collect($divisiondata)->sum('net_sale') >0 ? ($row->net_sale/collect($divisiondata)->sum('net_sale'))*100:0)}} %
@if($key+1 < collect($chunks)->count()) @endif @endforeach