{% extends "inventory/base.html" %}{% load humanize_tags %}
{% block title %}Health{% endblock %}
{% block content %}
<h1>Inventory health</h1>
<div class="kpis">
<div class="kpi"><span>Inventory value</span><b>{{ h.total_value|money }}</b></div>
<div class="kpi"><span>COGS (12 mo)</span><b>{{ h.annual_cogs|money }}</b></div>
<div class="kpi"><span>Turnover</span><b>{{ h.turnover|num:1 }}x</b></div>
<div class="kpi"><span>Days of inventory</span><b>{{ h.days_of_inventory|num:0 }}</b></div>
<div class="kpi"><span>Excess (&gt; {{ policy.excess_months|floatformat:"-1" }} mo cover)</span><b>{{ h.excess_value|money }}</b></div></div>
<div class="grid2">
<section class="card"><h2>Aging by days since last issue</h2>
<table class="data compact"><thead><tr><th>Bucket</th><th class="r">SKUs</th><th class="r">Value at risk</th></tr></thead>
<tbody>{% for label, n, v in h.aging %}<tr><td>{{ label }}</td><td class="r">{{ n }}</td><td class="r">{{ v|money }}</td></tr>{% endfor %}</tbody></table></section>
<section class="card"><h2>Near-expiry stock <small>FEFO: issue earliest expiry first</small></h2>
<table class="data compact"><thead><tr><th>SKU</th><th>Received</th><th class="r">Qty</th><th>Expiry</th><th>Status</th></tr></thead>
<tbody>{% for e in h.expiry %}<tr><td><a href="{% url 'item' e.item.sku %}">{{ e.item.sku }}</a></td><td>{{ e.layer.date }}</td><td class="r">{{ e.layer.qty_left|qty }}</td><td>{{ e.layer.expiry }} ({{ e.days }}d)</td><td><span class="status {% if e.status == 'expired' %}danger{% else %}warn{% endif %}">{{ e.status }}{% if e.status != 'expired' %} - issue first{% endif %}</span></td></tr>{% empty %}<tr><td colspan="5" class="muted">None.</td></tr>{% endfor %}</tbody></table></section></div>
<section class="card"><h2>Non-moving stock <small>no issue for 180+ days</small></h2>
<table class="data compact"><thead><tr><th>SKU</th><th>Name</th><th class="r">Qty</th><th class="r">Value</th><th class="r">Days since issue</th><th>Bucket</th><th class="r">NRV</th></tr></thead>
<tbody>{% for r in h.dead %}<tr><td><a href="{% url 'item' r.item.sku %}">{{ r.item.sku }}</a></td><td>{{ r.item.name }}</td><td class="r">{{ r.qty|qty }}</td><td class="r">{{ r.value|money }}</td><td class="r">{{ r.days|default:"never" }}</td><td>{{ r.bucket }}</td><td class="r">{{ r.item.nrv|default_if_none:"" }}</td></tr>{% empty %}<tr><td colspan="7" class="muted">None.</td></tr>{% endfor %}</tbody></table></section>
<section class="card"><h2>Excess stock <small>top 25 by value</small></h2>
<table class="data compact"><thead><tr><th>SKU</th><th>Name</th><th class="r">On hand</th><th class="r">Monthly demand</th><th class="r">Months cover</th><th class="r">Excess qty</th><th class="r">Excess value</th></tr></thead>
<tbody>{% for r in h.excess|slice:":25" %}<tr><td><a href="{% url 'item' r.item.sku %}">{{ r.item.sku }}</a></td><td>{{ r.item.name }}</td><td class="r">{{ r.qty|qty }}</td><td class="r">{{ r.monthly|num:1 }}</td><td class="r">{{ r.cover|num:1 }}</td><td class="r">{{ r.excess_qty|num:0 }}</td><td class="r">{{ r.excess_value|money }}</td></tr>{% empty %}<tr><td colspan="7" class="muted">None.</td></tr>{% endfor %}</tbody></table></section>
<section class="card"><h2>Stockout days, last 12 months <small>top 25</small></h2>
<table class="data compact"><thead><tr><th>SKU</th><th>Name</th><th>ABC</th><th class="r">Days at zero stock</th></tr></thead>
<tbody>{% for r in h.stockouts|slice:":25" %}<tr><td><a href="{% url 'item' r.item.sku %}">{{ r.item.sku }}</a></td><td>{{ r.item.name }}</td><td>{{ r.abc }}</td><td class="r">{{ r.days }}</td></tr>{% empty %}<tr><td colspan="4" class="muted">None.</td></tr>{% endfor %}</tbody></table></section>
{% endblock %}