Stock Aging cost calculation

Tue, 14 Feb 2012 13:27:52 GMT

To whom can help me,

I am trying to calculate a cost for stock that ages dynamically depending on the period selected. I have attached an example qv file to work with.

I know what I want to do, just not quite sure how to do it in QV. Here is the data and an example of how it should be calculated:

if period 201112 is selected then the calculation is as follows:

Quantity on hand is 118

So it start latest first i.e. 53*1206.28=63932.84

then 2*39.82=79.64

then 4*19.91=79.64

then 20*13.05=261

then 10*12.50=125

then 10*12.05=120.50 (Although the quantity is 90, the remainder is 10, therefore that is the final outstanding qty for the calc)

total cost is 64598.62

If period 201112 is selected then the same calc must be perfomed dynamically which normally yields a different result(as you select older periods the cost changes.

The report n the QV file has a report where the current cost of 118*700 = 82600

So the difference between the current cost and aged cost is 82600-64598.62=18001.38

I hope i have explained the situation clearly enough to help me.

Many Thanks

Gary

topic Stock Aging cost calculation in QlikView

Stock Aging cost calculation