Inventory Analyst

The Inventory Analyst is responsible for monitoring, analyzing, and reconciling all inventory and floorplan financing activity for the Retail Division of a manufactured housing company. This role ensures accurate tracking of homes across retail lots, timely floorplan payments, and alignment between operational activity, financing partners, and accounting records. The position plays a critical role in financial visibility, inventory control, and cash flow management by supporting the FP&A function with detailed reporting, forecasting, and variance analysis related to inventory and floorplan utilization. This is a highly analytical role that requires strong attention to detail, an understanding of dealership-style floor planning, and the ability to partner effectively with retail operations, accounting, lenders, and executive leadership. Key Responsibilities: Floorplan Financing Management Track and monitor all floorplan credit lines across retail locations, including home acquisitions, curtailments, and payoffs Ensure all inventory is properly floor planned upon arrival and reconciled to lender statements and internal systems. Maintain working relationships with floorplan lenders and assist with resolving discrepancies or documentation requests. Monitor aging inventory and support the FP&A Director in managing interest expense projections and cash flow timing. Track and report curtailment schedules, interest charges, and upcoming payment obligations. Inventory Tracking & Reconciliation Maintain accurate home inventory records, ensuring alignment between retail lot records, factory shipment records, accounting, and lender data. Perform inventory reconciliations monthly and investigate discrepancies promptly. Support physical inventory audits and verify serial numbers, home conditions, and retail lot placement. Partner with Operations Managers and GMs to ensure inventory status (available, pending sale, in transit, damaged, etc.) is updated regularly. Reporting & Analysis Prepare recurring inventory, floorplan, and aged-unit reports for FP&A and executive leadership. Assist in forecasting inventory levels, floorplan usage, and interest expense for budgeting and planning cycles. Provide insights on inventory turns, aged inventory risk, and home allocation trends across retail stores. Analyze inventory-related KPIs and present findings to the FP&A Director for strategic planning. Cross-Functional Coordination Work closely with Accounting to ensure proper recording of floorplan entries, interest expense, flooring dates, and cost of goods sold (COGS). Collaborate with retail locations to ensure timely report submission and accurate recordkeeping. Partner with the Director of FP&A to improve inventory visibility, dashboard reporting, and system data integrity. Process Improvement & Controls Support enhancements to inventory tracking procedures, floor planning controls, and reconciliation processes. Assist with system upgrades or process redesigns to improve accuracy and efficiency in inventory management. Ensure compliance with internal audit requirements and SOX controls (if applicable). Qualifications & Skills Bachelors degree in Finance (preferred), or Accounting, Business Analytics, or related field. 13 years of experience in inventory control, demand planning, data analysis, FP&A, accounting, or dealership/retail operations. Strong analytical and problem-solving skills with high attention to detail. Proficiency in Excel (VLOOKUP, pivot tables, functions) and comfort working with large datasets. Ability to learn and work within enterprise systems (ERP, POS, or inventory management tools). Strong communication skills and ability to partner with both financial and nonfinancial teams. Preferred: Experience with floorplan financing (automotive, powersports, RV, marine, or manufactured housing). Experience in a publicly traded company. Familiarity with Microsoft Dynamics NAV, or other ERP systems. Knowledge of inventory accounting concepts, COGS, freight, and capitalization