{% extends "base.html" %} {% block body%}

Inventory Analysis Data

{% for sku in inventory %} {% for cur in currency if (cur.id == sku.currency_id) %} {% autoescape false %} {% set sym = cur.symbol %} {% endautoescape %} {% endfor %} {% endfor %}
Calculated Values
SKU Class Safety Stock (qty) Revenue Economic Order (qty) Average Orders (qty) Shortage Units (qty) Excess Stock (qty) Shortage Cost Backlog
{{sku.sku.sku_id}} {{sku.abc_xyz_classification}} {{"{:,.0f}".format(sku.safety_stock)}} {{sym}}{{"{:,.2f}".format(sku.revenue)}} {{sku.economic_order_quantity}} {{"{:,.0f}".format(sku.average_orders)}} {{"{:,.0f}".format(sku.shortages)}} {{"{:,.0f}".format(sku.excess_stock)}} {{sym}}{{"{:,.2f}".format(sku.shortage_cost)}} {{"{:,.0f}".format(sku.backlog)}}
{% endblock %}