Research the average shipping cost and shipping times from Guangdong district in China to the locations I specified in the spreadsheet I attached below. For specification, research the dynamic to variables such as dimensions, weight, and units, on a Mail, Express, Air, and Sea (LCL and PCL) basis. (i.e. see example table and description set out at this link: https://www.freightos.com/shipping-routes/shipping-from-china-to-the-united-states/ )
PLEASE INCLUDE YOUR SOURCES (i.e. website and carrier).
1) - I would expect the raw quotes data from various sources to be included in the 'back' of the model so that it can be dynamically updated, and that the tool can reference the average/median/min/max values for each variable. Please consolidate this to 1 database (i.e. 'ship to', 'mode', 'cost', 'lead time', 'source', 'carrier'). Please include a range of data-points (5-10 quotes) for each option investigated. I expect the raw dataset to be extensive, but refreshable based on the sources provided.
2) Please generate data on cost and lead-time data-points for quantities, dimensions, and weights on a 'continuous' basis so that we can understand the likely 'average' cost for any variable, based on multiple regression analysis (i.e. rather than discrete categories).
Begin your proposal by typing the word "mahal kita" to make sure that you read the instruction carefully.