Andrew Waldschmidt

Andrew Waldschmidt

Global Supply Chain Planner at ESCO Corporation · Borden Dairy

Portland, Oregon, TX

In My Own Words

Supply Chain professional with nearly 9 years of experience in Logistics, Inventory Planning/ Optimization, Supply Planning, and Demand Planning relocating to Portland, Oregon in early 2020. Seeking a Supply Chain Planning role in which I can utilize and build upon my extensive planning experience to improve processes, remove inefficiencies, drive results, and improve profitability.

Work Experience

Manager, PFR Supply

Borden Dairy

2019 – Present

Borden is an exceptional company whose brand sits at the heart of American food with its continued focus on health and nutrition. The fresh fluid dairy processor generates $1.25 billion in revenue and employs 3,000 team-members. Borden is headquartered in Dallas, Texas and operates 13 facilities in the Midwest, South, and Southeast. • Supply and Demand Planning Manager for items Purchased for Resale (PFR) and produced by Co-Manufacturers (Co-Man). Co-Man suppliers produce Borden branded products where Borden does not have the capability or lacks capacity. • Responsible for resolving Supply Chain issues as well as anticipating and maintaining adequate inventory levels at all plant and branch locations in a highly competitive market. • Centralized Co-Man Supply Planning for all 12 Borden plants in order to reduce inefficiencies and waste and to better coordinate with Co-Man production schedules. • Collaborate with Co-Man production teams to ensure that Borden order timing and order quantities align with Co-Man production schedules in order to maximize shelf life at delivery. • Partnered with Co-Man Manager to understand Co-Man supplier's production process and negotiate an added 4 days (+13%) of guaranteed shelf life at delivery helping to reduce waste and improve customer service. • Develop and review monthly forecast with Co-Man suppliers ensure packaging availability and identify and prevent potential capacity shortages. • Developed Profit and Loss report for PFR and Co-Man SKUs to track profitability and guide cost savings opportunities. • Implemented two transportation cost savings initiatives projected to save the company over $200K annually with more potential projects on the horizon. • Coordinate with Sales, Marketing, Distribution, and Co-Man Suppliers on phase in/ out of packaging and finished goods to ensure seamless transition to prevent service delays. • Utilize advanced Excel skills to support S&OP team with ad-hoc data analysis, reporting, and model building. Example: Capacity Planning and Labor Planning models. • Developed performance metrics (KPI's) related to Supply, Demand, and Inventory Planning and presented 2020 goals to the Executive Vice President. • Identified and resolved Accounts Payable issue with two key suppliers preventing severe supply issues. • Supported Anaplan implementation team in designing requirements and user acceptance testing.

Demand Planner

Lennox International

2019 – 2019

Highly profitable $3.2 billion public manufacturer of complex climate control systems for commercial and household heating, ventilation, air conditioning, and refrigeration markets.

• Demand Planner for key Lennox Commercial product lines consisting of approximately 1,400 SKUs generating $185M in revenue annually. • Responsible for life cycle planning activities for Supply Chain team including phase in/ phase out management in SAP and IBP. • Developed production labor hour forecast tool designed to help the factory plan labor requirements for the balance of the year in a highly seasonal environment. This tool is now being used in the monthly factory planning meeting to help coordinate production rates, overtime, and labor allocation to specific product lines to prevent stockouts and increased lead times. • Developed SKU level days of supply (DOS) forecast to help the Inventory Planning team predict where potential stockout issues could arise, help Supply Planners with production scheduling when capacity constraints exist, and to track the performance of the new IBP Supply Planning system to ensure we are building the right SKUs when needed. • Initiated monthly collaboration meeting with Product Management, Sales Operations, Marketing, and Demand Planning team to discuss national market trends, sales programs, and new product launches to feed back into the demand plan. • Participate in monthly collaboration meetings with Inventory Planning team and individual sales districts to review sales and inventory stocking strategies and local market trends to fine tune region/SKU level forecast.

Inventory Optimization Analyst III

Lennox International

2016 – 2019

• Managed $97M of finished goods inventory across 12 regional distribution centers, one national distribution center, Commercial factory, and local stores. Approximately 6,500 SKUs comprised of 7 active product lines and their accessories. • Reduced excess and obsolete/aged inventory by approximately 75% through strategic planning, sales incentive programs, and liquidation when necessary. • Negotiated pricing and terms of liquidation sales by partnering with Lennox Finance and Legal teams. • Subject matter expert for Inventory Planning and Optimization team on SAP - IBP Supply Planning implementation project. • Establish ABC/ XYZ classification to define optimal safety days of supply which drives safety stock levels in the new IBP planning system. • Collaborated with Demand Planning team to create a process which fed sales team feedback back into the forecast to drive stocking target levels at regional distribution centers and the Supply Plan closing the loop between Demand, Inventory, and Supply Planning teams. (IBP Project) • Utilize advanced excel skills to perform data analysis and develop standardized reporting and tools for organization. • Worked with factory and distribution centers to maximize warehouse utilization through inventory optimization and redistribution. Developed inventory turnover metric and Qlik app to assist in this task. • Excess and obsolete inventory management and planning including financial reporting, forecasting, reducing current E&O levels, and developing plans to prevent additional E&O. • Enhanced existing E&O report to assist in the accrual process and highlight potential risk categories that were previously overlooked. Developed Qlik app to present my findings and suggested actions to Supply Chain and Finance leadership which initiated projects aimed at mitigating those risks. • Developed strategic inventory policies and procedures for Inventory Planning team (three Inventory Planners) to follow/ execute. • Report E&O and blocked stock accruals to finance on a quarterly basis. • Calculated optimal days of supply to drive stocking targets at distribution centers and factory and to help reduce total inventory levels and demand on factory. • Developed and executed phase in/ phase out management and lifecycle planning policies to address engineering and government regulation changes. • Managed the finished goods SKU list for stocked roof top units - approximately 600 SKUs. This requires working with Sales, Marketing, and the factory to develop optimal configurations for stocked product. • Worked with BI team to develop inventory metrics to track company goals utilizing Qlik and excel to create dashboards.

Logistics Analyst II

Lennox International

2014 – 2016

• Responsible for inventory planning for the Commercial Business Unit. • Worked closely with the sales team to develop inventory stocking targets at regional and local distribution centers. Analyzed historical sales data to help forecast regional demand. • Developed new metrics and reporting to help track regional sales and inventory trends including stockout, uncovered sales order, and % to target. • Responsible for all Commercial inventory adjustments at regional and local distribution centers including scrap transactions and discrepancy resolution. • Worked with accounting, finance, and auditors to develop reports that assist management estimate and mitigate the risk associated with excess/ obsolete inventory (E&O Report). • Worked with supply and demand planning teams to manage product phase in/ out in response to government regulation and engineering changes. • Collaborate with sales team on new initiatives to ensure that goals were aligned and that all teams had the necessary knowledge and resources to accomplish goals. • Developed new tools and reports to support Commercial Logistics team initiatives. • Trained and mentored new Logistics Analyst and multiple interns. • Resolved daily customer issues related to distribution and inventory.

Logistics Analyst I

Lennox International

2012 – 2014

• Distribution, inventory management, and data management. • Perform corporate distribution/ inventory management tasks. • Analyze and set Safety Stocks. • Load planning and scheduling. • Material management. • Assist with the phase in and phase out of material numbers. • Assisted in the sizing analysis of local and regional distribution centers. • Responsible for updating/ running inventory turnover reports, cost center expenses by location, and blocked stock report.

Logistics Intern

Lennox International

2011 – 2012

• Assist Logistics Analysts in daily activities • Deploy product to regional distribution centers • Shadow various departments to understand how Logistics and Supply Chain Planning impact other teams

TOOLS • Anaplan • Cognos • SAP ECC, APO, IBP, and Ariba • QlikView & QlikSense, • MS Office (Word, Excel (advanced), PowerPoint, Project, OneNote) • MaxLoad

Training & Certifications • APICS CPIM Certification (Completed Dec 2018) • APICS Professional Membership • Lean / Six Sigma Training • Qlik Sense Training

Education

Bachelor of Science

University of North Texas

2012

Bachelor of Science