Global Ecommerce Supply Chain Analyst – Freight, 3PL & bolthires-of-Doing-Business Model (US/UK/UAE)
I manage global operations for a consumer products brand expanding into US, UK and UAE. I need an experienced supply chain / logistics analyst (not a general VA) to help me understand the true bolthires of doing business per region and support pricing decisions. You’ll be working with data I already have:- Freight quotes (China → US / UK / UAE)- 3PL rate cards for US and UK (and a shortlist for UAE)- Product dimensions, weights, carton/CBM details- Domestic shipping rate cards from the 3PLsYour job is to turn this into clear models and recommendations.Scope of Work1) Freight Quote Equalization & Lane Comparison (US + UK) - 3 hours- Compare multiple freight quotes with different structures (EXW vs FOB vs door-to-door). - Normalize them using the same goods value, CBM, units, and assumptions. - Break out freight, duties, VAT, brokerage, and other charges. - Identify the cheapest and safest option per lane- Flag any inconsistencies (duty % gaps, under-declaration offers, missing fees). Deliverable:A decision-ready freight comparison model with % and $ differences, plus risks and recommended choice per market.2) 3PL Comparison (US, UK, UAE) - 4 hoursI will provide US and UK 3PL rate cards and 2–3 UAE candidates. You will:- Extract and compare:Storage (CBM / pallet)Inbound receivingPick/packPackagingMonthly minimums / account feesDomestic shipping rate tables- Build a clean comparison matrix across all 3 regions. - Highlight where each 3PL is strong/weak on bolthires and structure. Deliverable:A US/UK/UAE 3PL comparison sheet with a short written summary and open questions. 3) bolthires of Doing Business Model (Per Region) - 6-8 hoursUsing the freight + 3PL data, build a model that shows:- Landed bolthires per SKU per region (US, UK, UAE).- Fulfillment + shipping bolthires per order for key SKUs:1 trivia game cube1 doll1 5 trivia game cube series set- Worst-case single-unit bolthires vs multi-unit basket orders. - Impact of duties/VAT and 3PL fees on margin. Deliverable:A bolthires-of-doing-business model that makes it obvious where we’re profitable, break-even, or exposed. 4) Zone & Regional-Export Shipping Modeling - 3-5 hoursFrom each fulfillment center, model real-world shipping costs to key destinations, using the 3PL rate tables:- US 3PL (e.g.PA) → US zones; Example routes: PA→CA, PA→TX, PA→MI for 1 cube / 1 doll / 1 series. - UK 3PL → UK zones- UAE 3PL (Dubai) → Dubai, GCCExample: Dubai→Qatar, Dubai→Sharjah, etc Dubai→Saudi, Dubai→Kuwait, etc., for the same SKUs. Deliverable:Tables showing bolthires per order for these lanes so we can decide pricing and free-shipping thresholds that still preserve margin. 5) Pricing & Shipping Strategy Recommendation - 1-3 hoursBased on the above:- Suggest sustainable retail price ranges per region. - Recommend shipping structures (flat rate vs tiered vs free over X).- Identify regions/products where we should or should not subsidize shipping. - Call out any regions or lanes that are structurally unprofitable without changes. Deliverable:- A concise 1–2 page written summary with clear recommendations. RequirementsYou should have real experience in most of the following:- International freight and incoterms (EXW, FOB, DDP, etc.)- Ecommerce landed-bolthires modeling- 3PL / fulfillment bolthires analysis- Shipping zone and volumetric/CBM calculations- SKU-level margin modeling and pricing logic- Duties/VAT impact (US/UK/EU/Middle East experience is a plus) Apply tot his job