Mohammed Rashad
← 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

The overview: what delivery really cost.
The optimized routes across the Bay Area.
Where the cost comes from.
The CO2 panel.

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%.