Category Analysis Report

{{ $categoryName }} - {{ $storeName }}

{{ $dateRange['label'] }}: {{ $dateRange['start'] }} - {{ $dateRange['end'] }} | Generated: {{ $generatedDate }}

Category
{{ $categoryName }}
Store
{{ $storeName }}
Period
{{ $dateRange['label'] }}
Date Range
{{ $dateRange['start'] }} - {{ $dateRange['end'] }}
Category Performance Overview
Total Sales
K{{ number_format($categoryKpis['total_after_tax'], 2) }}
Net revenue
Items Sold
{{ number_format($categoryKpis['items_sold'], 0) }}
Total quantity
Unique Products
{{ number_format($categoryKpis['unique_products'], 0) }}
Product variety
Average Price
K{{ number_format($categoryKpis['average_item_price'], 2) }}
Per item average
Subcategory Performance Summary
@foreach ($subcategoryPerformance as $subcategory) @endforeach
Subcategory Products Items Sold Total Sales Contribution
{{ $subcategory['code'] }} {{ number_format($subcategory['product_count'], 0) }} {{ number_format($subcategory['total_quantity'], 0) }} K{{ number_format($subcategory['total_after_tax'], 2) }} @php $contribution = $subcategory['contribution_percentage']; @endphp {{ number_format($contribution, 1) }}%
@foreach ($subcategoryPerformance as $index => $subcategory) @if ($index > 0 && $index % 2 == 0)
@endif
{{ $subcategory['code'] }} {{ $subcategory['product_count'] }} Products | {{ number_format($subcategory['total_quantity'], 0) }} Items Sold
Total Sales
K{{ number_format($subcategory['total_after_tax'], 2) }}
Category Contribution
{{ number_format($subcategory['contribution_percentage'], 1) }}%
Average per Product
K{{ number_format($subcategory['total_after_tax'] / $subcategory['product_count'], 2) }}
@if ($subcategory['top_product'] || $subcategory['low_product'])
@if ($subcategory['top_product'])
Top Performer
{{ $subcategory['top_product']['commname'] }}
K{{ number_format($subcategory['top_product']['total_after_tax'], 2) }}
@endif @if ($subcategory['low_product'] && $subcategory['low_product']['commid'] !== $subcategory['top_product']['commid'])
Low Performer
{{ $subcategory['low_product']['commname'] }}
K{{ number_format($subcategory['low_product']['total_after_tax'], 2) }}
@endif
@endif
Product Breakdown
@foreach ($subcategory['products'] as $product) @endforeach
Product Code Product Name Quantity Avg Price Total Sales Performance
{{ $product['commid'] }} {{ $product['commname'] }} {{ number_format($product['quantity'], 0) }} K{{ number_format($product['average_price'], 2) }} K{{ number_format($product['total_after_tax'], 2) }} @php $productContribution = $subcategory['total_after_tax'] > 0 ? ($product['total_after_tax'] / $subcategory['total_after_tax']) * 100 : 0; @endphp {{ number_format($productContribution, 1) }}%
@endforeach

Category Analysis Report

{{ $categoryName }} - {{ $storeName }}

Generated on {{ $generatedDate }}