Lab Formula Costing using What If Analysis

Hi,

We have a requirement to use R&D Formula an do What If Analysis.

Example

FG     Qty 5    

RM1    Qty200g            Cost: $5/KG

RM2    Qty300g            Cost: $3/KG

When we rollup, we get the cost for FG =  (200X5)+(300X3) / 1000   =   $1.9        

In addition, Business can add any item dynamically ( which there are no cost stored in Costing Module). They want to add Item dynamically and input cost

FG     Qty 5    

RM1    Qty200g            Cost: $5/KG

RM2    Qty300g            Cost: $3/KG

NEW1  Qty100g           Cost:  $2/KG   ( This cost entered dynamically)

So, they want to rollup the cost  FG=   (200X5)+(300X3)+(100X2) / 1000  = $2.1

I tried to use OPM Simulator to meet this need. But, the calculation logic used is different. So, I am not getting the above cost because the cost is divided by Ingredient ( not by 1000g)