Calculation of the stock average in pcs by trx MC44

[Former Member]

Hi,

I would calculate average stock in pcs, if I run MC44 with period of inventory turnover 01.05.2013-11.06.2013 and no restriction radio button selected, I obtain as average stock value 7,738.

By MB51 I can see for a material the following:

TEST 101 5000137977 11.06.2013 1 PC
TEST 201 4900616004 07.05.2013 1- PC
TEST 101 5000137971 07.05.2013 10 PC

Clicking on the "detailed display" button I can see:

Posting date GR GI Stock level
07.05.2013 10,000 1,000 9,000
11.06.2013 11,000 1,000 10,000

Over the net I found the formula of the average stock in pcs that is (initial stock+final stock)/2 but the result is different from the above 7,738

http://help.sap.com/erp2005_ehp_04/helpdata/en/c1/376872449a11d188fe0000e8322f96/frameset.htm

Thanks
Best regards

[Former Member · Accepted solution]

HI,

The value in MC44 is Inventory turnover and not the average inventory.

Can you get the cost of sales and then calculate the inventory turnover for this material manually.

Amit.

[Former Member · Accepted solution]

Hi,

in MC44 I can see "Average stock" clicking on the "Triple line button" with a value in PCS I didn't understand how is this calculated

The library says:

"The value of the average stock is calculated by adding the beginning and ending stock in the period to analyze and dividing by two".

If I do as the library says, the result is different from the value of the "average stock" of MC44

Thanks

Best regards

[JL23 · Accepted solution]

you showed your movements with unit PC

but your are talking about average in PCS

Anything wrong in the discussion, or were the movements posted in an alternative unit, while MC44 is doing the calculations in base unit?

[Former Member · Accepted solution]

Hi,

you can click Detail display button on left hand corner and the select Stock movement option to check the total receipt and issues for material. You can check which data in missing in your MB51 report.

Amit.

[Former Member · Accepted solution]

Hi,

sorry I was talking about PC as unit of measure.

I verified for another material and I calculated the following for may and june 2013;

[initial stock 5/13 (17 PC) + end stock 5/13 (11 PC) + end stock 6/13 (26 PC)]/3= 18 PC

I read this topic: http://scn.sap.com/message/10506994

To be sure of my calculation I also executed report MCBA, MC.B, MC.3 and MC.7 to match my result and I verified that the average stock value is the above (18PC) the inventory turnover is 22/18=1,22

After this I executed report MC44 and I can read the following:

Material        Usage (period)     Inventory turnover
                                             Average stock
           

X                  22 PC                 1,20
                                              18,395  PC
                   

MC44 has in the selection screen the day and not the month as in the other trxs, does it change something in this case in the formula?

That's my problem

Thanks

Regards

[Former Member · Accepted solution]

HI,

Can you please share the data in Detail display screen ( stock movement ) shows for this material  in MC44?

Amit.

[Former Member · Accepted solution]

MB5B for may:

Plnt	Material	Material Description
Quantities	BUn
TEST
Stock on 01.05.2013	17	PC
Total Receipts	15	PC
Total Issues	-21	PC
Stock on 31.05.2013	11	PC

MB5B for june:

Plnt	Material	Material Description
Quantities	BUn
TEST	10
Stock on 01.06.2013		11	PC
Total Receipts		16	PC
Total Issues		-1	PC
Stock on 30.06.2013		26	PC

MC44: Inventory turnover is 1,20, average stock is 18,395, this results differs from MCBA (have a look below):

Material	Short text	Inventory turnover
Usage (period)	Average stock
MRP contr	MRP type	ABC ind.	Matl grp	Matl type	Purch.grp
TEST	Material          1,20
22	18,395		PC
A02	PD	101	ROHE	ELE

MCBA for may and june (calculation):

Anl.ttl.stktrn-value	7,21
Anl.val.stktrn-value	7,21
Annual cns.stockturn	0
Annual ttl.stockturn	7,21
Annual val.stockturn	7,21
Average consumption	1	PC
Avg CoStQty turnover	0
Avg InTurnQty- ValSt	0,02
Avg. RC total stock	50
Avg. ttl usage value	29,25	EUR
Avg. unplanned usage	0	PC
Avg.cnsgt.coverage	0
Avg.cvg.tt.stk-value	50
Avg.cvg.vl.stk-value	50
Avg.trn.tl.stk-value	0,02
Avg.trn.vl.stk-value	0,02
Avg.ttl.stk.turnover	0,02
Avg.val.stk.receipts	4,429	PC
Avg.val.stock cover	50
Avg.vl.stk.iss.value	29,25	EUR
Avg.vl.stk.rec.value	129,53	EUR
Cnsgt stock = zero	0
Cnsgt.stock coverage	0
Cnsgt.stock issues	0	PC
Cnsgt.stock receipts	0	PC
Consignment stock	0	PC
Last Receipt
Last consumption
Last goods issue
Last goods movement
Mean cnsgt issues	0	PC
Mean cnsgt receipts	0	PC
Mean cnsgt stock	0	PC
Mean total stock	18	PC
Mean unpl.cons.value	0	EUR
Mean val.stk.issues	1	PC
Mean val.stock value	526,49	EUR
Mean valuated stock	18	PC
No. of cancellations	0
No. total usage	22
No.cnsgt issues	0
No.cnsgt.receipts	0
No.material mvmts.	29
No.unpl.consumptions	0
No.val. stk receipts	7
No.val.stock issues	22
No.val.stock zero	0
Safety stock	0	PC
Stock lvl at Gds Rec	0	PC
Total consumption	22	PC
Total stock	26	PC
Total stock = zero	0
Total stock coverage	72
Total stock turnover	1,22
Total usage value	643,5	EUR
Ttl.stck.cover-value	72
Ttl.stockturn-value	1,22
Turnover qty; CS	0
Unplanned consumptio	0	EUR
Unplanned usage qty	0	PC
Val. stock issues	22	PC
Val. stock receipts	31	PC
Val.stck.cover-value	72
Val.stk.issues value	643,49	EUR
Val.stock coverage	72
Val.stock rec.value	906,74	EUR
Val.stock turnover	1,22
Val.stockturn-value	1,22
Valuated Stock Value	760,49	EUR
Valuated stock	26	PC
Valuation Class	R200
Value Stck Gds Repct	0	EUR

[Former Member · Accepted solution]

HI,

I tried to work out how average stock fig is calculated in MC 44.

Below is example which I used for calculation in my system

Number of days from 12/07/10 till 21/07/10 = 10

Stock movements from 12 till 21 is as below as shown in stock movement screen in detail display screen

Using above figures find out stock fig on each date i.e if there is no stock movement on particular date then stock value will be that of previous date. So in this case below is stock fig on each date

12	0
13	10,000.00
14	9,960.00
15	9,959.00
16	9,836.00
17	9,836.00
18	9,836.00
19	9,834.00
20	9,834.00
21	9,830.00

Calculate the sum of this stock value which comes out to 88925

Calculate average stock as sum of stock / number of days i.e. 88925/10 = 8892.5 . This is exactly as shown in the report above

now consider the date range is from 13th till 17th so stock figures are

13	10,000.00
14	9,960.00
15	9,959.00
16	9,836.00
17	9,836.00

Sum of this 5 days is 49591

Average stock per day is =49591/5 = 9918.2 .

When report is executed for this 5 days the above figure matches with the report.

So try to carry out similar analysis with your set of data and check whether it matches with above logic.

Amit.