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

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

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


{{-- 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 --}} @foreach ($presentBills as $b) @endforeach
Remarks BillCount (Avg) TotalBillAmt (Avg) TotalCuM (Avg) AvgBillAmt AvgCuMTARGET ACTUAL DIFFTARGET ACTUAL DIFFTARGET ACTUAL DIFFTARGET ACTUAL DIFFTARGET ACTUAL DIFFTARGET ACTUAL DIFFTARGET ACTUAL DIFFTARGET ACTUAL DIFFTARGET ACTUAL DIFF
{{ $b->bill_year }}-{{ $b->bill_month < 10 ? '0'.$b->bill_month : $b->bill_month }} {{ number_format($b->total_bills) }} {{ number_format($b->total_bill_amount, 2,".",",") }} {{ number_format($b->total_cum) }} {{ number_format($b->avg_bill_amount, 2,".",",") }} {{ number_format($b->avg_total_cum) }}
Total Recent Bills {{ number_format($presentBills->sum('total_bills')) }} ({{ number_format($presentBills->average('total_bills')) }}) {{ number_format($presentBills->sum('total_bill_amount'), 2,".",",") }} ({{ number_format($presentBills->average('total_bill_amount'), 2,".",",") }}) {{ number_format($presentBills->sum('total_cum')) }} ({{ number_format($presentBills->average('total_cum'), 0,".",",") }}) {{ number_format($presentBills->average('avg_bill_amount'), 2,".",",") }} {{ number_format($presentBills->average('avg_total_cum')) }}
Previous Bills ({{ $previousHeader->count('id') }} Mo/s) @ {{ $energized_at }} {{ number_format($previousBills[0]->avg_bills) }} {{ $previousBills[0]->total_bill_amount }} {{ $previousBills[0]->total_cum }} {{ $previousBills[0]->avg_bill_amount }} {{ $previousBills[0]->avg_total_cum }}