Business Intelligence Commons^™

A Forecasting Framework For Distribution Center Capacity Utilization: An Applied Industry Study, Jordan J. Shortt

Data Science Undergraduate Honors Theses

This project develops and evaluates a predictive modeling framework for forecasting distribution center capacity utilization at Company Y, with monthly forecast horizons up to one year. Motivated by the operational challenges of seasonal demand volatility, promotional cycles, and the absence of a formally defined capacity metric, the study first constructs a historical capacity utilization measure from raw warehouse management system data — reconciling item volumes, location dimensions, and utilization factors across all DCs — which serves as the target variable for all modeling work. Four models are developed and evaluated against a naïve seasonal baseline: SARIMA, LightGBM, LSTM, and a …

Developing Tracking Compliance Standards For Inbound Freight: A Data-Driven Industry Application At O’Reilly Automotive, Jackson Endacott

Data Science Undergraduate Honors Theses

Visibility of inbound freight is critical for managing operational efficiency, yet many organizations lack standardized compliance metrics for third-party carriers to uphold, preventing them from utilizing tracking data to make data-driven decisions. During a summer internship with the Transportation Department at O’Reilly Automotive, data inconsistencies were addressed in the Transportation Management System (TMS), and that data was utilized to create tracking compliance standards for third-party carriers. Data populated from various sources within O’Reilly’s TMS was cleaned, validated, and utilized to create a Tracking Scorecard that evaluates message transmission rates, timeliness, and errors. This tool provides actionable insights to improve tracking …

Escaping The Promotion Trap: A Machine Learning Framework For Brand Equity Preservation In Beverage Cpg, Lucas P. Jones

Data Science Undergraduate Honors Theses

When companies acquire beverage brands, they typically value them based on total sales revenue. This traditional approach treats all sales equally over time, whether they are driven by genuine consumer demand or temporary discounts. This is important because while promotions can boost short-term sales, they tend to erode brand value over long periods of time. The measurement problem extends to acquisitions, where buyers lack the tools to distinguish real consumer demand from artificial promotional inflation.

This thesis develops a framework to separate genuine baseline demand from promotional dependence using Nielsen scanner data covering 189 beverage brands across 188,304 weekly observations …

Shortage To Surge - Studying The Post-Covid-19 Guitar Retail Market, Jed H. Kim

Data Science Undergraduate Honors Theses

The COVID-19 pandemic was one of the most catalyzing events of the 21st century, leading to supply chain disruptions, lifestyle changes, and a massive shift towards digital technologies. During the COVID-19 lockdown, many people had more free time, and over 16 million individuals learned to play guitar in the first 2 years of the pandemic. According to a study by Fender, 62% of these new guitar learners cited the pandemic as their primary reason for learning the instrument. However, pandemic policies and supply chain disruptions meant that many guitar retailers were unable to satisfy demand, and backorders accumulated. After the …

Spatiotemporal Negative Inventory Outlier Decomposition For Supply Chain Applications In Consumer-Packaged Goods (Cpg), Hayden Mcdonald

Data Science Undergraduate Honors Theses

Coca-Cola is a popular soft drink brand with sales occurring in every Walmart store across the world, which generates large quantities of data and requires a robust supply chain system. However, the company does not currently have a sophisticated, automated, and/or prescriptive system for detecting where, when, and why inventory outages occur and applying preventative measures to avoid loss of revenue from the absence of inventory on store shelves. This thesis proposes and applies a novel, prescriptive system for this purpose. An inventory outage can be seen as a ‘negative’ statistical outlier in a time series of inventory for an …