Skip to Content
0
Former Member
Apr 10, 2014 at 11:16 AM

How to distribute Total expences based on production?

19 Views

Hello experts,

I need to "allocate" costs to individual products based on individual production quantities.

Production Quantity

Apr - 13 May - 13 June -13

Product 1 1000 2000 3000

Product 2 2000 100 1500

Product 3 3000 1000 1000

All Products 6000 3100 5500

cost1 /All products 50000 40000 60000

I am struck at allcating these costs to individual products. How to achieve this in BPC 10.0 NW? My template has "Product" in context selection. I have all the cost values at total of all products in BI. Guide me.

My Template looks as below

Context selections: Product

Apr - 13 May-13 June 13

Actual Actual Actual

Production costs

cost1

cost2

Thanking you in advance

Praveen