{% extends "core/base.html" %}{% load fmt %}
{% block title %}{{ snap.name }}{% endblock %}
{% block content %}
<p class="crumb"><a href="{% url 'snapshots' %}">&larr; All snapshots</a></p>
<h1>{{ snap.name }}</h1>
<p class="sub">Forecast of {{ snap.as_of|date:"j M Y" }} vs actual cash movements through {{ through|date:"j M Y" }} &middot; {{ report.weeks|length }} complete week(s) compared</p>
{% if not report.weeks %}<div class="alert warn">No forecast week has fully elapsed yet, so there is nothing to compare.</div>{% else %}
<div class="kpis">
  <div class="kpi"><span>Receipts MAPE (customer x week)</span><strong>{{ report.overall_mape|pct }}</strong></div>
  <div class="kpi"><span>Closing cash variance, last week</span><strong class="{% if total_variance < 0 %}neg{% endif %}">{{ total_variance|inr }}</strong></div>
</div>
<section class="card"><h2>Weekly variance</h2><div class="scroll"><table class="t"><thead><tr><th>Week</th><th class="r">Receipts fcst</th><th class="r">Receipts actual</th><th class="r">Disb. fcst</th><th class="r">Disb. actual</th><th class="r">Closing fcst</th><th class="r">Closing actual</th><th class="r">Closing var.</th><th class="r">MAPE</th></tr></thead><tbody>
{% for w in report.weeks %}<tr><td>{{ w.index|add:1 }} <small>{{ w.start|date:"j M" }}</small></td><td class="r">{{ w.forecast_receipts|inr }}</td><td class="r">{{ w.actual_receipts|inr }}</td><td class="r">{{ w.forecast_disbursements|inr }}</td><td class="r">{{ w.actual_disbursements|inr }}</td><td class="r">{{ w.forecast_closing|inr }}</td><td class="r">{{ w.actual_closing|inr }}</td><td class="r">{{ w.closing_variance|inr }}</td><td class="r">{{ w.mape|pct }}</td></tr>{% endfor %}</tbody></table></div></section>
<div class="cols">
<section class="card"><h2>Forecast accuracy by customer</h2><table class="t"><thead><tr><th>Customer</th><th class="r">Forecast</th><th class="r">Actual</th><th class="r">Variance</th><th class="r">MAPE</th></tr></thead><tbody>
{% for l in by_customer %}<tr><td>{{ l.label }}</td><td class="r">{{ l.forecast|inr }}</td><td class="r">{{ l.actual|inr }}</td><td class="r {% if l.variance < 0 %}neg{% endif %}">{{ l.variance|inr }}</td><td class="r">{{ l.mape|pct }}</td></tr>{% endfor %}</tbody></table></section>
<section class="card"><h2>Disbursements by category</h2><table class="t"><thead><tr><th>Category</th><th class="r">Forecast</th><th class="r">Actual</th><th class="r">Variance</th></tr></thead><tbody>
{% for l in disb_lines %}<tr><td>{{ l.label }}</td><td class="r">{{ l.forecast|inr }}</td><td class="r">{{ l.actual|inr }}</td><td class="r {% if l.variance > 0 %}neg{% endif %}">{{ l.variance|inr }}</td></tr>{% endfor %}</tbody></table>
<h3>Largest receipt variances</h3><table class="t"><tbody>{% for l in receipt_lines %}<tr><td>{{ l.label }}</td><td class="r {% if l.variance < 0 %}neg{% endif %}">{{ l.variance|inr }}</td></tr>{% endfor %}</tbody></table></section>
</div>{% endif %}
{% endblock %}