Hey Boss, I'm your woman for this job. I have experience in shipping and logisitcs from my foreign trade job. We most often used LCL shipping (both ocean and air) and so I have lots of experience at calculating these costs.
I can create all the functions for you, so you will only need to enter the a few details specific to each shipment. Such as carton size, and number of items per carton, and total order qty. Then all the prices will be automatically calculted just for you.
It will be so easy for you to know the prices you need to pay. We can have different forms for the different pallet sizes too. This will give you the right linear footage, and weight.