
Xls based shipping costing tool (mrkt research + data analysis)
- or -
Post a project like this1957
£50(approx. $69)
- Posted:
- Proposals: 9
- Remote
- #2970870
- PRE-FUNDED
- Awarded
MS Excel, SPSS, AMOS, R, STATA, Power BI, Tableau - Data Analyst, research and insights and Creative Writing

441784223598252538109413602540616322627320482568811141284632552
Description
Experience Level: Entry
I am seeking a simple, update-able excel model to estimate shipping costs and shipping times from China (Guangdong) to various North American and Western European Amazon Fulfilment Centres. The model will require:
Research to develop a set of raw data regarding:
a) - the location (postcode/zipcode) of ALL Amazon Fulfilment Centres across North America (i.e. USA, Canada, etc.) and Western Europe (i.e. the UK, France, Spain, Italy, Ireland, Portugal, Scandinavia... all European locations east of AND INCLUDING Germany, Czech Rep, and Croatia).
b) - the average shipping cost and shipping times from Guangdong district in China to these identified fulfilment centres, 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). I expect these figures to be based on example quotes generated from free aggregators such as: https://ship.freightos.com/?utm_source=pardot&utm_medium=email&utm_campaign=202006-onboarding&utm_content=email-1a) -
NB 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 value 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.
NB 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 a multiple regression analysis (i.e. rather than discrete categories).
Then, please develop a dynamic model that generates the average cost per unit of shipping at different unit volumes, unit dimensions, weights, etc, based on the a multiple regression analysis of the raw data (based on minimum, average, median and maximum cost and lead time values for each combination of variables). Please include a front page in which the number (quantity) of units, dimensions (in cubic meters / cms) of units can be input, the unit weight and the final destination fulfilment centre, and the output cost and lead time can be estimated (min, med, avg, max and range).
I hope this makes sense. Beyond the development of raw the raw database, I expect this to be a very simple job for an adept data analyst. As mentioned, please provide in excel format.
Many thanks and looking forward to your response.
Best,
Tom
Research to develop a set of raw data regarding:
a) - the location (postcode/zipcode) of ALL Amazon Fulfilment Centres across North America (i.e. USA, Canada, etc.) and Western Europe (i.e. the UK, France, Spain, Italy, Ireland, Portugal, Scandinavia... all European locations east of AND INCLUDING Germany, Czech Rep, and Croatia).
b) - the average shipping cost and shipping times from Guangdong district in China to these identified fulfilment centres, 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). I expect these figures to be based on example quotes generated from free aggregators such as: https://ship.freightos.com/?utm_source=pardot&utm_medium=email&utm_campaign=202006-onboarding&utm_content=email-1a) -
NB 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 value 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.
NB 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 a multiple regression analysis (i.e. rather than discrete categories).
Then, please develop a dynamic model that generates the average cost per unit of shipping at different unit volumes, unit dimensions, weights, etc, based on the a multiple regression analysis of the raw data (based on minimum, average, median and maximum cost and lead time values for each combination of variables). Please include a front page in which the number (quantity) of units, dimensions (in cubic meters / cms) of units can be input, the unit weight and the final destination fulfilment centre, and the output cost and lead time can be estimated (min, med, avg, max and range).
I hope this makes sense. Beyond the development of raw the raw database, I expect this to be a very simple job for an adept data analyst. As mentioned, please provide in excel format.
Many thanks and looking forward to your response.
Best,
Tom
Tom H.
100% (103)Projects Completed
77
Freelancers worked with
76
Projects awarded
74%
Last project
7 Oct 2024
Canada
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies