Is it possible to distribute the costs from cost center to another cost centers on the basis of material (qty ) issues on cost centers?
Below is the example:
1. Consumable consumed during GRN into Cost center CC1 ( rs. 100,000, qty 100 )
2. Consumable material qty issued to another cost centers CC2 ( 10 qty ) & CC3 ( 20qty ) , no accounting document generated due to non valuated material category
Now the business requirement is to distribute the costs ( rs.100,000 ) from CC1 to CC2 & CC3 on the proportion of quantaties issued i.e. CC1 cost 100,000*30/100 = 30,000 should be distributed to CC2 ( 10,000 ) and CC3 ( 20,000 ).