How can I calculate cost of delivery per brick of R1.36 where transport cost is R40/km

Hi Friends
Kindly Assist, I want to supply cement stock bricks to customers with a free delivery charge price tag where the cost of transport R40.00 per km is already absorbed in the fixed price of the brick which costs R1,36 excluding transport cost. how do i come up with a fixed sales price which covers the transport cost within a radius of 150km.
weight of the brick is 3kg
packed in a pallet carrying 500 bricks

The cost of 500 bricks is 500 * 1.36, and the weight of 500 bricks is 500 * 3 kg, so the transport cost is 40 times this for a pallet. That means that you just need to add the two together to get the cost inclusive of transport costs.

Is that what you mean? It's a maths question, rather than one specifically about Excel.

Pete

Full cost and selling price workings as below:

How can I calculate cost of delivery per brick.png

Thank you so much this is what was trying but i could not get there . Thank you everyone for being so helpful