Stock maintain by fifo method.

[sumant kumar sahoo]

My question is how to calculate the consumption value of Apr-2016. of Each Grade of Bags. And the closing stock value of Apr 2016, which is opening for the month of May -2016.

 

[bosco_yip]

1] Please refer to attached file.

2] The calculated consumption value located at U19:U26

3] The calculated clossing stock value located at Z19:Z26

Regards

 

[sumant kumar sahoo]

1] Please refer to attached file.

2] The calculated consumption value located at U19:U26

3] The calculated clossing stock value located at Z19:Z26

Regards

Dear Sir,
Please check the cell no U22.(the Consumption Value is Show)
But My Consumption Qty is 70000,
From opening 60312 the value is 971023, and the balance Qty from purchase 9688 the value is 167118.
and the total value is 1138141 but it show in U 22 is 1172641, which is include Qty 2000, of transfer Qty. which is not my Consumption.

 

[sumant kumar sahoo]

Dear Sir,
Please check the cell no U22.(the Consumption Value is Show)
But My Consumption Qty is 70000,
From opening 60312 the value is 971023, and the balance Qty from purchase 9688 the value is 167118.
and the total value is 1138141 but it show in U 22 is 1172641, which is include Qty 2000, of transfer Qty. which is not my Consumption.

My question is how to calculate the consumption value of Apr-2016. of Each Grade of Bags. And the closing stock value of Apr 2016, which is opening for the month of May -2016.

Dear Sir,
Please check the cell no U22.(the Consumption Value is Show)
But My Consumption Qty is 70000,
From opening 60312 the value is 971023, and the balance Qty from purchase 9688 the value is 167118.
and the total value is 1138141 but it show in U 22 is 1172641, which is include Qty 2000, of transfer Qty. which is not my Consumption.

 

[sumant kumar sahoo]

Dear Sir,
A lots of thanks for your reply, i would like ask one think if i pay the entry Tax on consumption qtys amount not including transfor , then how can i get the exact consumption amount . in which coloum.


I hope u get my point.

Thanks
Sumant.

 

[sumant kumar sahoo]

Dear Sir,
please find the attachment , in which i am working in your format , but there is some error. if my opening stock of a certain grade of bags is Qty 60312, and i consume of qty 38350, and 11320 trf , and the amount should be 916948, as per my opening rate. but i did not get the same.

please check the sheet and reply me.