Costing calculations for multiple prices


We are looking at costing calculations for multiple quantities per product using varying prices for the same component

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