Downloadable spreadsheet providing logistics managers with practical examples on how to use the SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF and AVERAGEIFS excel functions Also see my other downloadable spreadsheet 5 Excel Functions That Every Logistics Manager should Know
Tools - Free
3PL Monthly KPI Report Template
FREE Microsoft Excel ™ spreadsheet template that can be used as the starting point for developing an advanced Monthly 3PL KPI Report and Dashboard.
Sample Logistics Service Provider Evaluation Tool
A PDF sample of the Logistics Service Provider Evaluation Tool The Logistics Service Provider Evaluation Tool is an excel spreadsheet tool that use a series of questions to calculate a relative score based on both COST and other evaluation criteria such as RELIABILITY, RESPONSIVENESS, RELATIONSHIPS and GUT FEEL to determine which logistics service provider that is not […]
Excel Functions That Every Logistics Manager Should Know
Downloadable spreadsheet with working samples of excel formula that every logistics manager should know Includes VLOOKUP TRIM CONCATENATE NETWORKDAYS WEEK BEGINNING DATE
3PL Meetings and Activity Planner
Microsoft Excel spreadsheet that can be used to plan out 3PL meetings and activities relating to the effective management of logistics service provider relationships Also includes bonus full year calendars that can be automatically updated each year by simply changing the year in the header of the calendar