Demand and Inventory Planner

COMPANY OVERVIEW HexArmor® is a leader in developing some of the most advanced PPE solutions for your eyes, hands, arms, and body. At HexArmor®, we believe safety is not a luxury – it’s a necessity. Since day one, we have worked hand-in-hand with our customers to design innovative, high performance PPE that helps ensure workers return home in the same condition they arrived. Our mission is to provide the protection that makes this possible, for every worker, everywhere. SUMMARY We are seeking an enthusiastic and motivated Supply Chain Demand and Inventory Planner to join our team. The Supply Chain Demand and Inventory Planner is responsible for a dedicated set of suppliers and items — balancing inventory service levels and inventory turns to maximize fulfillment and minimize delays using analysis from Excel, SAP Business One, Tableau, and Blue Ridge. The right candidate would develop the ability to analyze forecast trends with sales opportunities to apply to future item performance. The Supply Chain Demand and Inventory Planner would work closely with Category Management, Product Management, and Logistics Specialists as well as the Warehouse and Production teams daily. JOB RESPONSIBILITIES Own the demand forecast for an assigned portfolio of suppliers and SKUs, using sales history, opportunity data, and market signal to drive monthly buy plan Communicate daily with multiple suppliers for PO placement, on-time deliveries, forecasting, and capacity Build and present daily, weekly, and monthly Excel reporting that drives purchasing and financial reviews. o XLOOKUP/Index Matching o Pivot tables o Generating IF statements/formulas Develop understanding of HexArmor product and product lifecycle to apply sound judgement when presented with purchasing decisions Lead as needed on any necessary reporting or Supply Chain related tasks Daily operating in SAP & Blue Ridge MRP for inventory management and related functions Monthly product specific opportunity review with sales management to understand new business Generate various reports using sales data and opportunity data to create functional forecasts Collaborate with sales, category managers, and distribution to communicate inventory outlook and build scenario plans for potential net new business. Research and incorporate business intelligence that increases forecast accuracy Develop inventory strategies on new and existing products across product lifecycle Oversee the planning of inventory service levels to meet demand Review all demand for finished goods orders and production requirements and coordinate appropriate actions to supply customers in a timely manner Reformatting of exports and importing into existing spreadsheets Analyze and provide feedback to appropriate departments on material status for fulfilling customer demand Prepare and maintain relevant reports pertaining to the demand planning process Develop, improve, monitor reporting…