Forecasted Inventory Volume/Demand - How?

[Anonymous]

Hello --

I'm a little confused how I would go about this.

I have a somewhat interesting request to develop a chart in Qlik that will represent expected on-hand inventory volumes for future months. Basically by analyzing the puts/takes but predicting the puts based on when the amount on-hand reaches a threshold. Ideally they'd like to be able to manipulate the various fields to see how it affects the graph.

They'd like to do this  by capturing forward looking demand for inventory, comparing this to our leadtime for the purchased inventory item. The material required would be replenished within the necessary leadtime.

The graph would show the expected ups/downs of the material demand

The data I have to work with looks something like this:

Forecast Data:

Item #	Qty Required	Date Required
1234	500	8/1/2015
1234	500	8/15/2015
1234	500	8/30/2015
1234	500	9/5/2015
1234	500	9/30/2015

Inventory Item Master:

Item #	Leadtime	Min Order Qty
1234	10	1000

The expected graph they're hoping to get is something that looks like this:

[Anonymous]

Serhan --

This is very helpful. Thank you.

However, the "replenishment" amount needs to be dynamically calculated. I think I am closing to devising how to do this within the chart, but I am a little hung up.

Here's my current expression within the chart.

ITEM_QTY_ONHAND - RangeSum(Above(Sum(QTY_REQ), 0, NoOfRows(TOTAL)))

This gives me the rolling "depletion" of stock - which ultimately continues to drive into a negative value. Now, I need to say when that expression is less than the "minimum required on-hand", add the minimum order qty to that value to get the upswing - that is what I am struggling with.

[Anonymous]

Here's the data to help explain what I'm seeing.

[Anonymous]

The "Test" field is my attempt to replenish when the running total dips below the min inventory level - however this is flawed because it will continue to drive negative as the running total of depletion keeps declining. I essentially need to add this back to itself - but I can't figure out how to do that.

[Anonymous]

Hello Joe,

My advice is that, if possible, do not try to replenish auto; just point out the levels to be taken action, replenished. Because you may get lost at front-end easily. Instead, try to get the min levels to the background and make the user play with them with a what-if scenario as I tried to do.

That's all I can offer I guess

BR

Serhan