{% extends "base.html" %} {% block body%}
{% set classification_AY = "AY" %} {% set classification_AX = "AX" %} {% set classification_AZ = "AZ" %} {% set classification_BX = "BX" %} {% set classification_BY = "BY" %} {% set classification_BZ = "BZ" %} {% set classification_CX = "CX" %} {% set classification_CY = "CY" %} {% set classification_CZ = "CZ" %}

Top Shortages

{% for sku in inventory %} {% if (sku.abc_xyz_classification == classification_AY) and (loop.index == 1) %}
{% endif %} {% if (sku.abc_xyz_classification == classification_AX) and (loop.index == 1) %}
{% endif %} {% if (sku.abc_xyz_classification == classification_AZ) and (loop.index == 1) %}
{% endif %} {% if (sku.abc_xyz_classification == classification_BX) and (loop.index == 1) %}
{% endif %} {% if (sku.abc_xyz_classification == classification_BY) and (loop.index == 1) %}
{% endif %} {% if (sku.abc_xyz_classification == classification_BZ) and (loop.index == 1) %}
{% endif %} {% if (sku.abc_xyz_classification == classification_CX) and (loop.index == 1) %}
{% endif %} {% if (sku.abc_xyz_classification == classification_CY) and (loop.index == 1) %}
{% endif %} {% if (sku.abc_xyz_classification == classification_CZ) and (loop.index == 1) %}
{% endif %} {% endfor %}
{% 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 Reorder Level (qty) Economic Order (qty) Standard Deviation Average Orders (qty) Shortage Units (qty) Excess Stock (qty) (qty) Reorder Quantity Unit Cost
{{sku.sku.sku_id}} {{sku.abc_xyz_classification}} {{"{:,.2f}".format(sku.safety_stock)}} {{sym}}{{"{:,.2f}".format(sku.revenue)}} {{"{:,.0f}".format(sku.reorder_level)}} {{"{:,.0f}".format(sku.economic_order_quantity)}} {{sku.standard_deviation}} {{"{:,.0f}".format(sku.average_orders)}} {{"{:,.0f}".format(sku.shortages)}} {{"{:,.0f}".format(sku.excess_stock)}} {{"{:,.0f}".format(sku.reorder_quantity)}} {{sym}}{{"{:,.2f}".format(sku.unit_cost)}}
{% endblock %}