← The Vault
RH Furniture: what delivery really costs
Spring 2026 · Hult, MSBA
RH charged a flat $299 to deliver and set up furniture in your home. We wanted to know what each of those deliveries actually cost.
What we made
What we built
A route planner in Python, using Google OR-Tools, that loads trucks without going over their limits, keeps to each customer's delivery window, and splits orders too big for one stop. The orders come from an Excel file in SharePoint, and the results feed a Power BI dashboard.
The live test
Change an order in SharePoint, hit Refresh in Power BI, and the planner runs again from start to finish.
What we found
Each delivery really cost about $761.97 against the $299 fee, so we recommended raising it to between $350 and $400. The optimized plan needed 12 truck runs instead of 20, which cut cost 12.65% and CO2 31.33%.