[sap-log-mm] How does SAP calculate the average stock in t-code MC44?

Posted by Sap Land Wednesday, 6 July 2011 11:29

Posted by MikeKriley
on Jul 6 at 2:33 PM

Below is the scenario for the results of running MC44 for each day of the month from 06/01/2011 to 06/30/2011 for 1 mat'l. For example the period of inventory turnover 06/01/2011 to 06/18/2011 gave the results TURNOVER: 15.82 AVERAGE STOCK: 4.236

From 06/01 to 06/12 my stock for this mat'l was 0 kgs. On 6/13 I had a goods receipt (GR) of 68.040 kgs. SAP calculated the Average Stock as 68.040/13days = 5.234. That I understand. However I have no idea how SAP calculated each day after that.

On 6/14 and 6/17 I had goods issues (GI) of 66.000 & 1.000 respectively. My inv. on 06/01/2011 was 0 kgs and my closing inv on 06/30 was 1.040 kgs.

I realize inventory turnover is not really relevant on such a short time frame but I wanted to understand how it's calculating.

AVG
6/1/2011 STOCK
TO TURNOVER KG KG
6/1 99,999.00 0.000
6/2 99,999.00 0.000
6/3 99,999.00 0.000
6/4 99,999.00 0.000
6/5 99,999.00 0.000
6/6 99,999.00 0.000
6/7 99,999.00 0.000
6/8 99,999.00 0.000
6/9 99,999.00 0.000
6/10 99,999.00 0.000
6/11 99,999.00 0.000
6/12 99,999.00 0.000
6/13 12.80 5.234 GR 68.040
6/14 13.38 5.006 GI 66.000
6/15 13.94 4.808
6/16 14.46 4.635
6/17 15.14 4.424 GI 1.000
6/18 15.82 4.236
6/19 16.47 4.067
6/20 17.11 3.916
6/21 17.73 3.779
6/22 18.33 3.655
6/23 18.92 3.541
6/24 19.49 3.437
6/25 20.05 3.341
6/26 20.60 3.252
6/27 21.14 3.170
6/28 21.65 3.094
6/29 22.16 3.024
6/30 22.66 2.957

__.____._