Advanced International Journal for Research

E-ISSN: 3048-7641     Impact Factor: 9.11

A Widely Indexed Open Access Peer Reviewed Multidisciplinary Bi-monthly Scholarly International Journal

Call for Paper Volume 7, Issue 4 (July-August 2026) Submit your research before last 3 days of August to publish your research paper in the issue of July-August.

Factory-to-Customer Shipping Route Efficiency Analysis for Nassau Candy Distributor: A Data-Driven Logistics Intelligence Study

Author(s) Ms. Geetha S
Country India
Abstract Nassau Candy Distributor ships confectionery products from 5 regional factories to customers across the United States and Canada. Although the organisation maintains detailed order and shipment records, logistics decisions have historically been made without route-level efficiency intelligence, leaving questions about which factory-to-customer lanes are reliable, which experience frequent delays, and where geographic bottlenecks exist largely unanswered. This study undertakes an exploratory data analysis of 10,194 orders spanning January 2024 to December 2025, covering 5 factories, 4 customer regions, and 15 products across 3 product divisions. Shipping Lead Time is computed as the interval between order date and ship date, and an Efficiency Score, a Delay Rate, and a Route Volume metric are derived for each factory-region lane. Findings indicate that the network records a mean lead time of 5.22 days and an overall delay rate of 23.2% against a 7-day threshold, with Standard Class shipping responsible for the substantial majority of delay incidents despite carrying 60% of total order volume. Route-level analysis identifies Sugar Shack's connection to the Gulf region as the network's least efficient lane, while geographic analysis reveals that proximity to a factory does not reliably predict shipping speed. A Streamlit-based interactive dashboard was developed to operationalise these findings for ongoing monitoring, supporting filtering by date range, region, ship mode, and lead-time threshold. The study concludes with 5 data-supported recommendations addressing ship-mode allocation, factory-specific performance gaps, routing inefficiency, congestion hotspots, and network resilience.
Keywords Logistics Analytics, Shipping Lead Time, Route Efficiency, Supply Chain Optimisation, Exploratory Data Analysis, Geographic Bottleneck Analysis, Streamlit Dashboard, Nassau Candy Distributor, Confectionery Distribution, Data Analytics
Field Computer > Data / Information
Published In Volume 7, Issue 4, July-August 2026
Published On 2026-07-13

Share this