Conducted a detailed analysis of Lowe's paint department performance to optimize inventory management, resulting in a $191,797.20 reduction in overall costs and a $12.90 decrease in cost per unit while ensuring alignment with forecasted demand of 14,868 units. Leveraged historical sales data and a linear programming model to enhance operational efficiency and strategically adapt to fluctuating market conditions.