Inventory Weekly Report

This weekly Inventory Weekly Report provides a comprehensive overview of stock levels, sales trends, and inventory forecasting across three fulfillment centers: ONT8, CALI, and TWAY. It tracks beginning and ending inventory, 7-day sales performance, and calculates inventory in terms of boxes with a 100-box limit per location. Forecasted demand for the next 28 days is computed based on recent sales, and Days of Stock (DOS) highlights items falling below the 120-day threshold, flagging them in red for priority replenishment. The report also includes “On Order” quantities to support proactive inventory planning and prevent stockouts.