Skip to Content
0
Mar 04, 2015 at 10:38 AM

Potency calculation issue

1728 Views

Hello Gurus,

Have this potency calculation issue,

Our final Product is : xxxxxxx 500 Capsules

As per BOM one of the require material has details as below. Consider below example

Material name Batch number quantity (kg) Assay

Xxxxx xxxxxx1 286.898 99.15%

Xxxxx xxxxxx2 90.000 99.37%

Actual required qty of xxxxx is 344.333 ( with potency 100% i.e. Assay)

Formula

Actual Require Qty = qty * 100 / Assay on Anhydrus basis

Now we have qty of xxxxx with Assay 99.15% and we want 100% potency Material to be used in final product….

So Formula will be

  1. 286.898 * 99.15 / 100 = 284.459 kg (with 100% potency)

Now require qty is 344.333

Available qty 284.459

Shortage of QTY = 344.333 – 284.459 = 59.874

So this shortage of QTY will be calculated from batch number xxxxxx2

Now in Batch no. xxxxxx2 potency of Material is 99.37%

So it will be calculated …..

  1. 59.874 * 100 / 99.37 = 60.254 (this will be our required qty after calculating 100% potency of Batch xxxxxx2 ).

So total qty will be used from both batches will be

  1. 286.898 + 60.254 = 347.152 KG. this is our final output.

Need your help to Map this potency calculation in SAP,Looking forward for your rply.

Thnx in advance.

Regards,

Amit Sharma