FUEL INVENTORY REPORT

Inventory Report From {{$open_balance['startdate']}} To {{$open_balance['enddate']}}

{{--*/ $in_quantity_total = 0 /*--}} {{--*/ $out_quantity_total = 0 /*--}} {{--*/ $avarage_price = $open_balance['avarage_price'] /*--}} {{--*/ $balance_quantity = $open_balance['open_quantity'] /*--}} @foreach($fuel_inventories as $inventory) {{--*/ $in_quantity_total += $inventory['in_quantity'] /*--}} {{--*/ $out_quantity_total += $inventory['out_quantity'] /*--}} {{--*/ $in_quantity_total += $inventory['in_quantity'] /*--}} {{--*/ $out_quantity_total += $inventory['out_quantity'] /*--}} {{--*/ $balance_quantity += $inventory['in_quantity'] /*--}} {{--*/ $balance_quantity -= $inventory['out_quantity'] /*--}} {{--*/ $avarage_price = $inventory['average_price'] /*--}} @if($inventory['in_price']>0) @endif @endforeach
  Inward Outward Balance
Date Equipment/Vehicle Qnty Price Amount Qnty Price Amount Qnty Price Amount
OPEN BALANCE {{number_format($open_balance['open_quantity'])}} {{number_format($open_balance['avarage_price'])}} {{number_format($open_balance['open_quantity']*$open_balance['avarage_price'])}}
{{ \Carbon\Carbon::parse($inventory['date'])->toFormattedDateString()}} {{ $inventory['registration_number']}} {{number_format($inventory['in_quantity'])}} {{number_format($inventory['in_price'],2)}} {{number_format($inventory['in_amount'],2)}}{{number_format($inventory['out_quantity'])}} {{number_format($inventory['out_price'],2)}} {{number_format($inventory['out_amount'],2)}}{{number_format($balance_quantity)}} {{number_format($inventory['average_price'])}} {{number_format($inventory['average_price']*$balance_quantity)}}
TOTAL INWARD {{number_format($in_quantity_total)}} TOTAL OUTWARD {{number_format($out_quantity_total)}} CLOSED BALANCE {{number_format($balance_quantity)}} {{$avarage_price}} {{number_format($avarage_price*$balance_quantity,2)}}