Monthly Order Booking Summary

@foreach($allBuyers as $buyer) @endforeach
@foreach($reportData as $monthData) @foreach($monthData['buyers'] as $buyerData) @endforeach @endforeach
Buyer Number of Orders Order Qty Sewing Balance Avg. SMV Produced Min Production Balance Booking% Avg. Unit Price Total Value Avg. CM/Pcs Total CM Shipped Qty Shipment Balance Excess/Short Qty Shipped Value Value Balance Excess/Short Value
{{ $monthData['month'] }}
{{ $buyerData['buyer'] }} {{ $buyerData['number_of_orders'] }} {{ number_format($buyerData['order_qty']) }} {{ number_format($buyerData['sewing_balance']) }} {{ number_format($buyerData['avg_smv'], 2) }} {{ number_format($buyerData['produced_min']) }} {{ number_format($buyerData['production_balance']) }} {{ number_format($buyerData['booking_percentage'], 1) }}% ${{ number_format($buyerData['avg_unit_price'], 2) }} ${{ number_format($buyerData['total_value']) }} ${{ number_format($buyerData['avg_cm_pcs'], 2) }} ${{ number_format($buyerData['total_cm']) }} {{ number_format($buyerData['shipped_qty']) }} {{ number_format($buyerData['shipment_balance']) }} {{ number_format($buyerData['excess_short_qty']) }} ${{ number_format($buyerData['shipped_value']) }} ${{ number_format($buyerData['value_balance']) }} ${{ number_format($buyerData['excess_short_value']) }}
Total {{ $monthData['month'] }} {{ number_format($monthData['monthTotals']['number_of_orders']) }} {{ number_format($monthData['monthTotals']['order_qty']) }} {{ number_format($monthData['monthTotals']['sewing_balance']) }} {{ number_format($monthData['monthTotals']['avg_smv'], 2) }} {{ number_format($monthData['monthTotals']['produced_min']) }} {{ number_format($monthData['monthTotals']['production_balance']) }} {{ number_format($monthData['monthTotals']['booking_percentage'], 1) }}% ${{ number_format($monthData['monthTotals']['avg_unit_price'], 2) }} ${{ number_format($monthData['monthTotals']['total_value']) }} ${{ number_format($monthData['monthTotals']['avg_cm_pcs'], 2) }} ${{ number_format($monthData['monthTotals']['total_cm']) }} {{ number_format($monthData['monthTotals']['shipped_qty']) }} {{ number_format($monthData['monthTotals']['shipment_balance']) }} {{ number_format($monthData['monthTotals']['excess_short_qty']) }} ${{ number_format($monthData['monthTotals']['shipped_value']) }} ${{ number_format($monthData['monthTotals']['value_balance']) }} ${{ number_format($monthData['monthTotals']['excess_short_value']) }}
Grand Total {{ number_format($grandTotals['number_of_orders']) }} {{ number_format($grandTotals['order_qty']) }} {{ number_format($grandTotals['sewing_balance']) }} {{ number_format($grandTotals['avg_smv'], 2) }} {{ number_format($grandTotals['produced_min']) }} {{ number_format($grandTotals['production_balance']) }} {{ number_format($grandTotals['booking_percentage'], 1) }}% ${{ number_format($grandTotals['avg_unit_price'], 2) }} ${{ number_format($grandTotals['total_value']) }} ${{ number_format($grandTotals['avg_cm_pcs'], 2) }} ${{ number_format($grandTotals['total_cm']) }} {{ number_format($grandTotals['shipped_qty']) }} {{ number_format($grandTotals['shipment_balance']) }} {{ number_format($grandTotals['excess_short_qty']) }} ${{ number_format($grandTotals['shipped_value']) }} ${{ number_format($grandTotals['value_balance']) }} ${{ number_format($grandTotals['excess_short_value']) }}