Hello All Freelancers.
I need someone who can create a simple database system for calculating which freight forwarder is cheapest for shipping a given shipment.
I want the system to work like this:
I enter the shipments dimensions lxwxh (in cm) and weight into a form and the system should then give me the cheapest price for that shipment according to data from a database with all the entered freight forwarders prices for a given weight.
The system should also be able to calculate the largest factor of either raw weight or dimensional weight (volumetric weight) and use the largest factor to calculate prices.
Not all my freight forwarders use the same formular to calculate dimensional weight, so the system should also be able to use diffrent formulars when calculating dimensional weight.
In the database I should be able to add prices from multiple freight forwarders for each weight class (in kg).
1Kg - Price1 - Price2 - Price3 -Price4
2Kg - Price1 - Price2 - Price3 - Price4
If the weight of the entered shipment is 2kg, the system should then chose the cheapest of the 4 prices entered in the system and show me which carrier is cheapest.
Im not sure if it sounds too complicated?
Feel free to ask me questions before you place your bid.