Name of Work	{{ $row->ProjectName }}
Authority	A. T. No. B - 1 / 36 for 2022-23.
Agency	M/s. Mana Electric & engineering services, Badlapur
Date of Work Order	18.10.2022

EXCESS - SAVING STATEMENT

@php $total_excess = 0; $total_saving = 0; $tender_work_portion_amount = 0; $exec_work_portion_amount = 0; $tender_amount = 0; $execution_amount = 0; @endphp @if (!empty($excess_saving)) @foreach ($excess_saving as $k => $r) @php $tender_amount += $r['AmountAsPerTender']; $execution_amount += $r['AmountAsPerExecution']; $saving = 0; $excess = 0; if ($r['IsTaxable'] == 'yes') { $tender_work_portion_amount += $r['AmountAsPerTender']; $exec_work_portion_amount += $r['AmountAsPerExecution']; } if ($r['AmountAsPerTender'] > $r['AmountAsPerExecution']) { $saving = $r['AmountAsPerTender'] - $r['AmountAsPerExecution']; } else { $excess = $r['AmountAsPerExecution'] - $r['AmountAsPerTender']; } $total_excess += $excess; $total_saving += $saving; $amt_val = ($r['AmountAsPerExecution'] - $r['AmountAsPerTender']); $excess_saving = ($amt_val / $r['AmountAsPerTender']) * 100; @endphp @endforeach @endif

Item Particulars	Qty as per Tender			Unit	Qty as per Actual executed (upto 2nd and final bill)		Excess	Saving	Remark
	Quantity	Rate	Amount		Quantity	Amount
Item No {{ $r['ExcessSequenceNo'] }}: {{ $r['ItemOfWork'] }}		{{ $r['RateAsPerTender'] }}	{{ $r['QtyAsPerExecution'] * $r['RateAsPerTender'] }}	{{ $r['Unit'] }}	{{ $r['QtyAsPerExecution'] }}	{{ $r['AmountAsPerExecution'] }}	{{ number_format($excess, 2) }}	{{ number_format($saving, 2) }}	{{ old('reason.' . $k, $r['Reason']) }}
		Total	{{ $tender_amount }}			{{ $execution_amount }}
						Net Saving Rs.	{{ number_format($total_excess, 2) }}