Budget vs Actual Performance Report
Generated on: {{ now()->format('d M Y, H:i') }} | User: {{ auth()->user()->name }}
@foreach($budgets as $budget) @endforeach
Coding Block / Department Annual Budget Actual Spending Variance Utilization
{{ $budget->codingBlock->code_identifier ?? 'Unassigned' }}
{{ $budget->fiscalYear->year ?? '' }} Fiscal Year
${{ number_format($budget->amount, 2) }} ${{ number_format($budget->actual_spending, 2) }} ${{ number_format($budget->amount - $budget->actual_spending, 2) }} {{ number_format($budget->utilization, 1) }}%
GRAND TOTAL ${{ number_format($budgets->sum('amount'), 2) }} ${{ number_format($budgets->sum('actual_spending'), 2) }} ${{ number_format($budgets->sum('amount') - $budgets->sum('actual_spending'), 2) }} {{ number_format($budgets->sum('amount') > 0 ? ($budgets->sum('actual_spending') / $budgets->sum('amount')) * 100 : 0, 1) }}%
Prepared By
{{ auth()->user()->role }}
Verified By
Accountant General