@section('page-title', 'Claims Frequency Report')

Claims Frequency Report

IPEC — Claims volume and frequency analysis

← Regulatory Reports
Export CSV

Total Claims

{{ number_format($summary['total_claims']) }}

Active Members

{{ number_format($summary['total_members']) }}

Members With Claims

{{ number_format($summary['members_with_claims']) }}

Frequency/Member

{{ $summary['frequency_per_member'] }}

Utilization Rate

{{ $summary['utilization_rate'] }}%

Claims by Type

@if($byType->count() > 0)
@foreach($byType as $row) @endforeach
Type Count Total Billed Total Awarded
{{ ucfirst($row->claim_type) }} {{ number_format($row->count) }} ${{ number_format($row->total_billed / 100, 2) }} ${{ number_format($row->total_awarded / 100, 2) }}
@else

No data available.

@endif

Claims by Status

@if($byStatus->count() > 0) @php $totalStatus = $byStatus->sum('count'); @endphp
@foreach($byStatus as $row)
{{ ucfirst(str_replace('_', ' ', $row->status)) }} {{ number_format($row->count) }} ({{ $totalStatus > 0 ? round(($row->count / $totalStatus) * 100, 1) : 0 }}%)
@endforeach
@else

No data available.

@endif

Monthly Claims Frequency

@if($monthlyFrequency->count() > 0)
@foreach($monthlyFrequency as $row) @endforeach
Month Claims Count Total Billed Total Awarded Award Rate
{{ $row->month }} {{ number_format($row->count) }} ${{ number_format($row->total_billed / 100, 2) }} ${{ number_format($row->total_awarded / 100, 2) }} {{ $row->total_billed > 0 ? round(($row->total_awarded / $row->total_billed) * 100, 1) : 0 }}%
@else

No data available for the selected period.

@endif