Maxim deliver across the UK on a preferred delivery day schedule. After recent growth, we would like to understand the current delivery pattern of our customers to geographical areas and key consignees. The aim is to identify and quantify opportunities for consolidation where deliveries are being requested to the same location or consignees multiple times a week by Maxim’s clients.
Ø Extract and manipulate data from the Transport Management System into a workable format.
Ø Sanitize delivery names, towns and postcodes for accurate data analysis and combine multiple order lines.
Ø Establish variation in delivery day at a geographical level (i.e. North West, North East)
Ø Establish variation in delivery day at consignee level (i.e. Maxim clients requesting deliveries on different days to other clients)
Ø Show delivery hotspots by day preferably in a mapping format for visual analysis
Ø Stratify full load consignment vs less than full load consignments
Ø Identify targets for consolidation by geographical area and consignee
Ø Quantify examples of potential savings based on less deliveries, miles and cost to serve
Ø Strong data analysis skills
Ø Excellent use of Excel and Microsoft programs
Ø A good understanding of basic geography and locations across the UK