Streamlining Inventory for Different Lighting Categories in One Centralized System – How Cen-tralizing Inventory Data Improved Cross-Department Coordination and Reduced Stockouts

Authors: Kishan Patel

DOI: https://doi.org/10.37082/IJIRMPS.v13.i6.232866

Short DOI: https://doi.org/hbf8zc

Country: United States

Full-text Research PDF File:   View   |   Download

Abstract: Lighting suppliers in the hospitality sector manage dozens of product categories—from LED bulbs and panel lights to wall packs, can lights, exit signs, vanity lights, and parking-lot fixtures. When inventory for these categories is scattered across spreadsheets, warehouse notebooks, and ad hoc updates, organ-izations face chronic delays, inaccuracies, and stockouts that directly impact motel projects. This paper describes how USA LEDs transitioned from fragmented category-wise tracking to a centralized inven-tory system covering all lighting categories in one place. The study outlines the architecture, data flows, process changes, and cross-department communication improvements, along with measurable reduc-tions in stockouts and deadstock. Results show that centralization improved forecasting accuracy, strengthened alignment between sales, purchasing, warehouse, and management, and reduced stock discrepancies by roughly 18–26% across major categories.

Keywords: Inventory management, hospitality lighting, data centralization, supply chain coordination, forecasting, stockout reduction, motel projects.

Paper Id: 232866

Published On: 2025-11-29

Published In: Volume 13, Issue 6, November-December 2025

Share this