custom requirements

I need the plugin to calculate shipping based on truck 100% loads.
the rules are:

1. each city i can deliver my products has a maximum freight cost
i’ll provide that table to you

2. no matter what, based on the customer’s location “city”, the minimum freight is 10% of that city’s maximum freight.

on the product section we need to add the following parameters:

a. units per package
b. Maximum packages that make a 100% truck load

then the shipping is calculated based on this parameters and rules.

rule number 1. no multiple cities shipping on the same order
rule number 2 minimum freight per city is 10% of the city’s total freight
parameters:

if the volume of the truck is between 10 and 50% the formula to calculate the shipping value is : city’s maximum freight value times the percentage result

if the volume of the truck is between 50 and 100% the formula to calculate the shipping value is : (100% – the percentage result) times city’s maximum freight value

if volume is over 100% of the truck’s volume shipping is free
that plugin must be integrated with a plugin called “Departamentos y Ciudades de Colombia para Woocommerce” that contains all the mayor cities and states in colombia. and has to be able to be an option as other factories have different shipping formats (not really sure if this is even possible)

so there are to things
1. shipping options add-on. and
2. adding column to the products main table.

if integration is not possible then it should be an option on the Shipping Settings on whoocommerce
Any questions ? Suggestions?

The page I need help with: [log in to see the link]