Inventory Valuation Report

Generated on {{ $report_date }}
Total Value
${{ number_format($summary['total_value'], 2) }}
Total Quantity
{{ number_format($summary['total_quantity']) }}
Total Products
{{ number_format($summary['total_products']) }}
Avg Value/Unit
${{ number_format($summary['average_value_per_unit'] ?? 0, 2) }}
@foreach($warehouses as $warehouse)
{{ $warehouse['warehouse'] }} {{ $warehouse['product_count'] }} products | {{ number_format($warehouse['total_quantity']) }} units | ${{ number_format($warehouse['total_value'], 2) }}
@foreach($warehouse['products'] as $product) @endforeach
Product ID Supplier P/N Supplier Location Quantity Available Reserved Unit Price Total Value
{{ $product['product_id'] }} {{ $product['supplier_part_number'] }} {{ $product['supplier'] ?? '-' }} {{ $product['location'] }} {{ number_format($product['quantity']) }} {{ number_format($product['available_quantity']) }} {{ number_format($product['reserved_quantity']) }} ${{ number_format($product['unit_price'], 2) }} ${{ number_format($product['total_value'], 2) }}
Warehouse Total {{ number_format($warehouse['total_quantity']) }} ${{ number_format($warehouse['total_value'], 2) }}
@endforeach
Grand Total: ${{ number_format($summary['total_value'], 2) }}
@if(!empty($top_products))

Top 10 Products by Value

@foreach($top_products as $product) @endforeach
Product ID Supplier Quantity Total Value % of Total
{{ $product['product_id'] }} {{ $product['supplier'] ?? '-' }} {{ number_format($product['quantity']) }} ${{ number_format($product['value'], 2) }} {{ $summary['total_value'] > 0 ? number_format(($product['value'] / $summary['total_value']) * 100, 1) : '0.0' }}%
@endif