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

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

{{ $title }}

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

{{-- 0 --}} {{-- 1 --}} {{-- 2 --}} {{-- 3 --}} @for ($i = 0; $i < 4; $i++) @endfor @foreach ($data as $d) {{-- NO OF NEW BILLED Cx --}} {{-- PRICE PER CUM --}} {{-- TR WATER SALES --}} {{-- LINE LOSS --}} @endforeach {{-- total_billed_cs --}} {{-- total_price_per_cum --}} {{-- total_water_sales --}} {{-- total_line_loss --}}
TARGET MONTH BILLED ACCOUNTAVG PRICE / CuMWATER REVENUESNRW
PROJECTED ACTUAL DIFFERENCE
{{ $d->count . ' Mo @ ' . $d->bill_month . '-' . $d->bill_year }}{{ 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['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['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['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) }}
TOTALS{{ 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_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_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_line_loss'], 2) }} {{ number_format($actuals['total_line_loss'], 2) }} {{ number_format($actuals['total_line_loss'] - $targets['total_line_loss'], 2) }}