Logistics Assistant
Warren Transport
Warren Transport
To further my business analytics experience, I joined Warren Transport as a Logistics Assistant in May 2026.
Identify effective lanes via Loadlink and negotiate rates with customers.
Assess local fuel prices and communicate findings with drivers.
Organize truck and trailer expenses.
This was one of the bigger projects I took on with my team at Warren Transport. Before this calculator, there was an outdated spreadsheet with minimal locations that required additional calculations. This often resulted in calculation errors for less-than-truckload freight negotiations.
I wanted to create a system that had all possible locations in Canada. I also wanted to create a per-skid rate per region. I created this calculator on Microsoft Excel in two weeks, and the main negotiator has used it since.
I created a Driver Monthly Report Card that is dependent on a number of variables that summarize a driver's performance. Parameters have been set and formulas created in tandem with them.
Cleaned raw data from Quickbooks
Created formulas in Microsoft Excel spreadsheet to pull data and organize expenses monthly.
Made the spreadsheet easily understood by applying conditional formatting and designing the tables.