Note: exactly like your Excel — Per Pcs Rate = (Price × Ex. Rate) + per pc caring.
On CBM: carring amount = PR CBM × Total CBM. On KG: carring amount = PR KG × Total Weight.
In both, per pc caring = carring amount ÷ Total Qty. On PR PC: enter per pc caring directly.
Cells with the green ring are editable; the rest calculate automatically.