Planning And Analytics Manager
CurrentKEY SKILLS AND SIGNIFICANT HIGHLIGHTS1. Continuous Improvement - Warehouse Optimization/Design Capacity/Demand Planning: “WorkSmart” Excel Warehouse Optimization Management toolDesigned and built, a VBA based warehouse optimization management tool within Excel Led implementation of the new tool to 16 warehouses throughout the UK. Facilitated workshops with senior warehouse managers to configure the tool according to individual warehouse constraints and bespoke… Show more KEY SKILLS AND SIGNIFICANT HIGHLIGHTS1. Continuous Improvement - Warehouse Optimization/Design Capacity/Demand Planning: “WorkSmart” Excel Warehouse Optimization Management toolDesigned and built, a VBA based warehouse optimization management tool within Excel Led implementation of the new tool to 16 warehouses throughout the UK. Facilitated workshops with senior warehouse managers to configure the tool according to individual warehouse constraints and bespoke requirements. Summary of tools functionality:- Calculates optimal position and space requirements for all SKU’s based on internal warehouse configuration using warehouse slotting techniques.- Calculates replenishment and picking cost for all SKU’s in its current warehouse position vs its ideal Warehouse position. - Calculates a manpower plan for the current and ideal scenarios, highlighting how the warehouse is performing.- Suggests most beneficial SKU warehouse moves in order to reduce costs and improve performance.Key achievements• Increased efficiency in warehouses attributed to this tool equated to a 5 FTE saving across the UK. • Product Swapping – Identified SKU’s where warehouse locations could to be swapped reducing the time required to make warehouse moves by 50% Show less