Inventory Planning

Qty OH Today

Shows in Today’s date column

Qty On PO

by PO Exp date (Customize to include Mfg or other increase types)
(Customize as to what date to report overdue PO’s)

Qty On SO

by SO Exp Date (Customize to include Mfg or other issue types)
(Customize as to what date to report overdue SO’s)

Qty Proj Sales

Historical sales are pushed forward per customized spec's, then multiplied by the [Proj Sales Growth] parameter for the Projected Sales

Proj Outbound

Greater of [Qty On SO] or [Qty Proj Sales]

Proj Net Change

[Qty OH Today] + [Qty On PO] - [Proj Outbound]

Proj Qty OH

RUNNING_SUM of [Proj Net Change]
(Adds across the dates, per row)

Safety Stock

safety stock or Min OH from ERP. Same number in all date columns.
OR suggested: {fixed [Item ID]:([Proj Outbound])}*0.1

Proj Excess/Short

[Proj Qty OH]-[Safety Stock]

Table calculation

Proj Excess/Short Filter

(color filter)

if [Proj Excess/Short]>=0 then 'Excess' else 'Short' END

Demand

(first column)

Per Item, for the total [Qty Proj Sales] within the selected [Exp Dates] range:
>=1000 then 'High'
elseif >=100 then 'Mid'
elseif >=1 then 'Low'
else 'None'

Tech note: [Exp Dates] is a Context filter, which limits the LOD to the selected dates.

Days of Stock

if sum([Qty OH Today]) <= 0 and sum([Qty Proj Sales])>0 then -9999999
elseif sum([Qty Proj Sales]) = 0 then 9999999
else sum([Qty OH Today])/(sum([Qty Proj Sales])/max([No of Days in Period])) end