Hi,
We are looking at costing calculations for multiple quantities per product using varying prices for the same component
Eg:
Component A costs 10/- per piece
Component A costs 8/- per piece if bought in a dozen
My manufacturing costing calculations should take the BOM price of 1 no (10/-) while buying a single component and also it should also take BOM price of 12 nos. (8/-) while buying in multiple quantities
Output required
1 component price 10x1=10/-
24 component price 8x24=192/-
While the components are brought in higher quantities the prices vary which impacts our manufacturing cost eg 100 nos,500 nos,1000nos etc