{{ strtoupper(session('company_name')) }}

{{ strtoupper(session('branch_name')) }}

{{ $title }}

Energization Date: {{ date('M d, Y', strtotime($energized_at)) }}

{{--
--}} {{-- --}} {{-- 0 --}} {{-- 1 --}} {{-- 2 --}} {{-- 3 --}} {{-- 4 --}} {{-- 5 --}} {{-- 6 --}} {{-- 7 --}} {{-- 8 --}} {{-- 9 --}} {{-- 10 --}} @for ($i = 0; $i < 11; $i++) {{-- @if ($i == 4 || $i == 6) @else @endif --}} @endfor @foreach ($data as $d) {{-- MONTH --}} {{-- --}} {{-- NO OF NEW CONNECTED Cx --}} {{-- NO OF NEW BILLED Cx --}} {{-- PROJECTED MONTHLY CONS OF NEW Cx --}} {{-- --}} {{-- TOTAL WATER CONS OF NEW BILLED Cx --}} {{-- TOTAL WATER PROD --}} {{-- --}} {{-- PRICE PER CUM --}} {{-- LINE LOSS --}} {{-- TR WATER SALES --}} {{-- TR SERVICES --}} {{-- TR MATERIALS --}} {{-- GROSS --}} @endforeach {{-- total_connected_cs --}} {{-- total_billed_cs --}} {{-- total_cum --}} {{-- total_cons_billed --}} {{-- total_water_prod --}} {{-- --}} {{-- total_price_per_cum --}} {{-- total_line_loss --}} {{-- total_water_sales --}} {{-- total_services --}} {{-- total_materials --}} {{-- total --}}
PROJECTED {{ number_format($targets['total_connected_cs']) }} {{ number_format($targets['total_billed_cs']) }} {{ number_format($targets['total_cum'], 2) }} {{ number_format($targets['total_cons_billed'], 2) }} {{ number_format($targets['total_water_prod'], 2) }} {{ number_format($targets['total_price_per_cum'], 2) }} {{ number_format($targets['total_line_loss'], 2) }} {{ number_format($targets['total_water_sales'], 2) }} {{ number_format($targets['total_services'], 2) }} {{ number_format($targets['total_materials'], 2) }}
ACTUAL {{ number_format($actuals['total_connected_cs']) }} {{ number_format($actuals['total_billed_cs']) }} {{ number_format($actuals['total_cum'], 2) }} {{ number_format($actuals['total_cons_billed'], 2) }} {{ number_format($actuals['total_water_prod'], 2) }} {{ number_format($actuals['total_price_per_cum'], 2) }} {{ number_format($actuals['total_line_loss'], 2) }} {{ number_format($actuals['total_water_sales'], 2) }} {{ number_format($actuals['total_services'], 2) }} {{ number_format($actuals['total_materials'], 2) }}
VARIANCE {{ number_format($actuals['total_connected_cs'] - $targets['total_connected_cs']) }} {{ number_format($actuals['total_billed_cs'] - $targets['total_billed_cs']) }} {{ number_format($actuals['total_cum'] - $targets['total_cum'], 2) }} {{ number_format($actuals['total_cons_billed'] - $targets['total_cons_billed'], 2) }} {{ number_format($actuals['total_water_prod'] - $targets['total_water_prod'], 2) }} {{ number_format($actuals['total_price_per_cum'] - $targets['total_price_per_cum'], 2) }} {{ number_format($actuals['total_line_loss'] - $targets['total_line_loss'], 2) }} {{ number_format($actuals['total_water_sales'] - $targets['total_water_sales'], 2) }} {{ number_format($actuals['total_services'] - $targets['total_services'], 2) }} {{ number_format($actuals['total_materials'] - $targets['total_materials'], 2) }}
TARGET MONTH NO OF NEW CONNECTED CUSTOMERSNO OF NEW BILLED CUSTOMERSPROJECTED MONTHLY CONS OF NEW CUSTOMERSTOTAL WATER CONS OF NEW BILLED CUSTOMERS (CuM)TOTAL WATER PRODUCTION (CuM)PRICE PER CuMLINE LOSS (%)REVENUE FROM WATER SALESREVENUE FROM PLUMBING SERVICESREVENUE FROM PLUMBING MATERIALSGROSS REVENUE
PROJECTED ACTUAL DIFFERENCEPROJECTED ACTUAL DIFFERENCETARGET ACTUAL DIFFERENCE
{{ $d->bill_month . '-' . $d->bill_year . ' (' . $d->count . ' Month)' }}{{ $d->count . ' Mo @ ' . $d->bill_month . '-' . $d->bill_year }}{{ number_format(isset($d->target['connected_cs']) ? $d->target['connected_cs'] : '') }} {{ number_format($d->actual['cs']) }} {{ number_format(isset($d->target['connected_cs']) ? $d->actual['cs'] - $d->target['connected_cs'] : $d->actual['cs'] * -1) }}{{ number_format(isset($d->target['billed_cs']) ? $d->target['billed_cs'] : '') }} {{ number_format($d->actual['billed_cs']) }} {{ number_format(isset($d->target['billed_cs']) ? $d->actual['billed_cs'] - $d->target['billed_cs'] : $d->actual['billed_cs'] * -1) }}{{ number_format(isset($d->target['monthly_cons_cs']) ? $d->target['monthly_cons_cs'] : '', 2) }} {{ number_format($d->actual['avg_cum'], 2) }} {{ number_format(isset($d->target['monthly_cons_cs']) ? $d->actual['avg_cum'] - $d->target['monthly_cons_cs'] : $d->actual['avg_cum'] * -1, 2) }}{{ number_format(isset($d->target['total_cons_billed_cs']) ? $d->target['total_cons_billed_cs'] : '', 2) }} {{ number_format($d->actual['total_cum'], 2) }} {{ number_format(isset($d->target['total_cons_billed_cs']) ? $d->actual['total_cum'] - $d->target['total_cons_billed_cs'] : $d->actual['total_cum'] * -1, 2) }}{{ number_format(isset($d->target['total_water_prod']) ? $d->target['total_water_prod'] : '', 2) }}{{ $d->actual['total_prod'] ? number_format($d->actual['total_prod'], 2) : '' }}{{ number_format($d->actual['total_cum'] / (1 - ($d->actual['line_loss'] / 100)), 2) }} {{ number_format(isset($d->target['total_water_prod']) ? $d->actual['total_prod'] - $d->target['total_water_prod'] : $d->actual['total_prod'] * -1, 2) }}{{ number_format(isset($d->target['price_per_cum']) ? $d->target['price_per_cum'] : '', 2) }} {{ number_format($d->actual['price_per_cum'], 2) }} {{ number_format(isset($d->target['price_per_cum']) ? $d->actual['price_per_cum'] - $d->target['price_per_cum'] : $d->actual['price_per_cum'] * -1, 2) }}{{ number_format(isset($d->target['line_loss']) ? $d->target['line_loss'] : '', 2) }} {{ $d->actual['line_loss'] ? number_format($d->actual['line_loss'], 2) : '' }} {{ number_format(isset($d->target['line_loss']) ? $d->actual['line_loss'] - $d->target['line_loss'] : $d->actual['line_loss'] * -1, 2) }}{{ number_format(isset($d->target['tr_water_sales']) ? $d->target['tr_water_sales'] : '', 2) }} {{ number_format($d->actual['total_sales'], 2) }} {{ number_format(isset($d->target['tr_water_sales']) ? $d->actual['total_sales'] - $d->target['tr_water_sales'] : $d->actual['total_sales'] * -1, 2) }}{{ number_format(isset($d->target['tr_services']) ? $d->target['tr_services'] : '', 2) }} {{ number_format($d->actual['total_services'], 2) }} {{ number_format(isset($d->target['tr_services']) ? $d->actual['total_services'] - $d->target['tr_services'] : $d->actual['total_services'] * -1, 2) }}{{ number_format(isset($d->target['tr_materials']) ? $d->target['tr_materials'] : '', 2) }} {{ number_format($d->actual['total_materials'], 2) }} {{ number_format(isset($d->target['tr_materials']) ? $d->actual['total_materials'] - $d->target['tr_materials'] : $d->actual['total_materials'] * -1, 2) }}{{ number_format(isset($d->target['total']) ? $d->target['total'] : '', 2) }} {{ number_format($d->actual['total'], 2) }} {{ number_format(isset($d->target['total']) ? $d->actual['total'] - $d->target['total'] : $d->actual['total'] * -1, 2) }}
TOTALS{{ number_format($targets['total_connected_cs']) }} {{ number_format($actuals['total_connected_cs']) }} {{ number_format($actuals['total_connected_cs'] - $targets['total_connected_cs']) }}{{ number_format($targets['total_billed_cs']) }} {{ number_format($actuals['total_billed_cs']) }} {{ number_format($actuals['total_billed_cs'] - $targets['total_billed_cs']) }}{{ number_format($targets['total_cum'], 2) }} {{ number_format($actuals['total_cum'], 2) }} {{ number_format($actuals['total_cum'] - $targets['total_cum'], 2) }}{{ number_format($targets['total_cons_billed'], 2) }} {{ number_format($actuals['total_cons_billed'], 2) }} {{ number_format($actuals['total_cons_billed'] - $targets['total_cons_billed'], 2) }}{{ number_format($targets['total_water_prod'], 2) }}{{ number_format($actuals['total_water_prod'], 2) }}{{ number_format($actuals['total_cons_billed'] / (1 - ($actuals['total_line_loss'] / 100)), 2) }} {{ number_format($actuals['total_water_prod'] - $targets['total_water_prod'], 2) }}{{ number_format($targets['total_price_per_cum'], 2) }} {{ number_format($actuals['total_price_per_cum'], 2) }} {{ number_format($actuals['total_price_per_cum'] - $targets['total_price_per_cum'], 2) }}{{ number_format($targets['total_line_loss'], 2) }} {{ number_format($actuals['total_line_loss'], 2) }} {{ number_format($actuals['total_line_loss'] - $targets['total_line_loss'], 2) }}{{ number_format($targets['total_water_sales'], 2) }} {{ number_format($actuals['total_water_sales'], 2) }} {{ number_format($actuals['total_water_sales'] - $targets['total_water_sales'], 2) }}{{ number_format($targets['total_services'], 2) }} {{ number_format($actuals['total_services'], 2) }} {{ number_format($actuals['total_services'] - $targets['total_services'], 2) }}{{ number_format($targets['total_materials'], 2) }} {{ number_format($actuals['total_materials'], 2) }} {{ number_format($actuals['total_materials'] - $targets['total_materials'], 2) }}{{ number_format($targets['gross_target'], 2) }} {{ number_format($actuals['gross_actual'], 2) }} {{ number_format($actuals['gross_actual'] - $targets['gross_target'], 2) }}