Inventory Aging Report

Summary Overview

Total Items: {{ number_format($summary['total_items']) }}

Total Quantity: {{ number_format($summary['total_quantity']) }}

Total Value: ${{ number_format($summary['total_value'], 2) }}

Average Age: {{ $summary['average_age'] }} days

Slow Moving Items: {{ number_format($summary['slow_moving_items']) }}

Slow Moving Value: ${{ number_format($summary['slow_moving_value'], 2) }}

@if(!empty($category_summary))

@foreach($category_summary as $category) @endforeach

Age Category	Item Count	Total Quantity	Total Value	% of Total Value	Visual
{{ $category['category'] }}	{{ number_format($category['item_count']) }}	{{ number_format($category['total_quantity']) }}	${{ number_format($category['total_value'], 2) }}	{{ $category['percentage_of_value'] }}%

@endif @if(!empty($slow_moving_items))

🐌 Slow Moving Items (No movement in 90+ days)

@foreach($slow_moving_items as $item) @endforeach

Product ID	Supplier	Warehouse	Location	Quantity	Available	Unit Price	Total Value	Last Movement	Age (Days)
{{ $item['product_id'] }}	{{ $item['supplier'] }}	{{ $item['warehouse'] }}	{{ $item['location'] }}	{{ number_format($item['quantity']) }}	{{ number_format($item['available_quantity']) }}	${{ number_format($item['unit_price'], 2) }}	${{ number_format($item['total_value'], 2) }}	{{ $item['last_movement_date'] }}	{{ number_format($item['age_in_days']) }}

@endif @if(!empty($aging_details))

📋 Detailed Aging Analysis (Top 500 by Age)

@foreach($aging_details as $item) @endforeach

Product ID	Supplier	Warehouse	Location	Qty	Available	Reserved	Unit Price	Total Value	Last Movement	Age	Category
{{ $item['product_id'] }}	{{ $item['supplier'] }}	{{ $item['warehouse'] }}	{{ $item['location'] }}	{{ number_format($item['quantity']) }}	{{ number_format($item['available_quantity']) }}	{{ number_format($item['reserved_quantity']) }}	${{ number_format($item['unit_price'], 2) }}	${{ number_format($item['total_value'], 2) }}	{{ $item['last_movement_date'] }}	{{ number_format($item['age_in_days']) }}	{{ $item['aging_category'] }}

@else

No aging data available for analysis.

@endif