Minimum production inventory level reached

johngouws — Wed, 03 Apr 2019 12:24:34 GMT

Hi.

I have been asked to predict when the minimum stock level should be reached. Known numbers are: At the end on each day the level is measured for each Product. That gives us the Date and cur_level. We know what the average volume of each product's use is per day - daily_avg and we have a minimum level required value - low_level. In the attached spreadsheet I have 2 'theo??' fields. These are only there for my testing and they are not normally loaded into the app. My first crack to create the theo_date (date(Date+(floor(sum((cur_level-low_level)/daily_avg)))) ) went quite well, if we operated 7 days a week.

What I have been trying to achieve is to incorporate networkdays() into the expression, but only Saturdays, and I have not got this right. Alternatively I don't know if this would be any easier is to exclude any Sundays?

The attached spreadsheet has some simple working on what I am trying to achieve.

I greatly appreciate any help with this.

topic Minimum production inventory level reached in QlikView

Minimum production inventory level reached