{% extends "budgets/base.html" %}
{% load bf %}
{% block title %}Variance drill-down{% endblock %}
{% block content %}
<p class="crumbs"><a href="{% url 'variance' %}?cycle={{ cycle.pk }}&version={{ version.pk }}&month={{ month_idx }}">Variance report</a> / {{ dept.name }}</p>
<h1>{{ account.code }} {{ account.name }} <span class="muted">- {{ dept.name }}</span></h1>
<div class="stats">
<div class="stat"><span>{{ month_label }} variance</span><b>{{ row.month.amount|money }}</b>{{ row.month.favorable|fu }}<i class="muted">{{ row.month.pct|pct }}</i></div>
<div class="stat"><span>YTD variance</span><b>{{ row.ytd.amount|money }}</b>{{ row.ytd.favorable|fu }}<i class="muted">{{ row.ytd.pct|pct }}</i></div>
<div class="stat"><span>FY budget</span><b>{{ row.fy_budget|money }}</b></div>
<div class="stat"><span>FY forecast</span><b>{{ row.fy_forecast|money }}</b></div>
</div>
<table class="data"><thead><tr><th></th>{% for m in months %}<th class="num">{{ m.label }}</th>{% endfor %}</tr></thead><tbody>
<tr><th>Budget</th>{% for m in months %}<td class="num">{{ m.budget|money }}</td>{% endfor %}</tr>
<tr><th>Actual</th>{% for m in months %}<td class="num">{{ m.actual|money }}</td>{% endfor %}</tr>
<tr><th>Variance</th>{% for m in months %}<td class="num">{% if m.var %}{{ m.var.amount|money }} {{ m.var.favorable|fu }}{% endif %}</td>{% endfor %}</tr>
<tr><th>Forecast</th>{% for m in months %}<td class="num">{{ m.forecast|money }}</td>{% endfor %}</tr>
</tbody></table>
{% if row.pv_month or row.pv_ytd %}
<h2>Price / volume decomposition</h2>
<p class="muted">Price = (actual price - budget price) x actual volume. Volume = (actual volume - budget volume) x budget price. Drivers: <code>{{ account.volume_driver }}</code> x <code>{{ account.price_driver }}</code>.</p>
<table class="data narrow"><thead><tr><th></th><th class="num">Price</th><th class="num">Volume</th><th class="num">Other</th><th class="num">Total</th></tr></thead><tbody>
{% if row.pv_month %}<tr><th>{{ month_label }}</th><td class="num">{{ row.pv_month.price|money }}</td><td class="num">{{ row.pv_month.volume|money }}</td><td class="num">{{ row.pv_month.other|money }}</td><td class="num">{{ row.pv_month.total|money }}</td></tr>{% endif %}
{% if row.pv_ytd %}<tr><th>Year to date</th><td class="num">{{ row.pv_ytd.price|money }}</td><td class="num">{{ row.pv_ytd.volume|money }}</td><td class="num">{{ row.pv_ytd.other|money }}</td><td class="num">{{ row.pv_ytd.total|money }}</td></tr>{% endif %}
</tbody></table>
{% endif %}
<h2>Commentary for {{ month_label }}</h2>
{% if row.needs_comment and not row.comment %}<div class="flash error">This variance exceeds the materiality threshold and needs an explanation from the owner.</div>{% endif %}
{% if can_comment %}
<form method="post" action="{% url 'variance_comment' %}" class="card">{% csrf_token %}
<input type="hidden" name="cycle" value="{{ cycle.pk }}"><input type="hidden" name="department" value="{{ dept.pk }}"><input type="hidden" name="account" value="{{ account.pk }}"><input type="hidden" name="month" value="{{ month_idx }}">
<input type="hidden" name="next" value="{{ request.get_full_path }}">
<textarea name="text" rows="3" placeholder="Explain the variance">{{ row.comment.text }}</textarea><button class="primary">Save commentary</button></form>
{% endif %}
<ul class="timeline">{% for c in comments %}<li><b>{{ c.author.username }}</b> on month {{ c.month|add:1 }}: {{ c.text }}</li>{% empty %}<li class="muted">No commentary yet.</li>{% endfor %}</ul>
{% endblock %}