Sales says it ships today, but my ERP’s ATP shows a 19-day lead time unless I pay 2x for air from Ohio; anyone else juggle “yes” with a spreadsheet screaming no at 5:02 p.m. on a Friday? I’m testing a hold-and-bundle rule to cut freight by 18% without slipping service levels — what’s your funniest workaround that saved money?
I added a 15-minute ‘cool-down’ before last pickup where the cart auto-checks a bundle threshold and, if air is >1.7x ground, it holds to the next truck and pings the rep with a canned ETA so my spreadsheet stops screaming. Caveat: trauma/recall SKUs bypass with a ‘med-necessity’ code so service isn’t dinged. Are you measuring that 18% against total freight or only parcel?
Quick example: we added a ‘reality check’ pop-up in CRM that, when ATP > 10 days or air >1.6x ground, suggests an alternate DC or SKU swap and shows the freight delta in dollars — a price tag on ‘ships today’ — and it trimmed expedites about 14%.
We put a ‘5:02 p.m. Friday’ gate in CPQ that blocks the ‘ships today’ toggle unless the rep logs a reason code and sees the air vs ground delta; default is bundle to the next truck and CCs @salesops so nobody gets surprised. , it’s saved us about 14% on freight and cut the ‘why is ATP 19 days?’ calls because the customer gets the exact ETA in the quote. Only caveat: we whitelist startup cases to bypass it — would your hold-and-bundle still hit 18% if you auto-split smalls now and push the heavy SKUs to Monday ground?
I keep https://www.spreadthesign.com pinned and my rule is “two taps or less” to sanity‑check a term between patient rooms. Caveat: hospital Wi‑Fi can be a diva, so I screenshot specialty signs ahead of time and use offline notes to avoid turning an MRI explanation into charades. Focus mode plus a silent vibration timer keeps alerts from hijacking the flow.
Swear by a $12 Bluetooth presenter mapped to global mute so I can voice without hunting for Zoom — Keyboard Maestro on Mac, AutoHotkey on Windows (Teams can be flaky). I also link Focus mode to any calendar event containing “appt” so Do Not Disturb kicks in 5 minutes early, which saved me twice since last week’s apps roundup. For staying current without a rabbit hole, RID’s CEU listings are a quick skim: https://rid.org/continuing-education/.
I added a tiny ‘lane clock’ to quotes — if ATP says 19 days, it shows “bundle window: 36h left” and auto-prices ground; choosing rush just recalculates margin and shows the commission change in-line. Freight dropped about 18% and Friday fire drills tapered off; the badge reads ‘cheap, fast, in stock — pick two.’ Curious if you vary the bundle window by region or SKU weight class.
I flag anything after 5:00 p.m. Friday as next‑business‑day in the CRM, so “ships today” only shows if ATP and carrier cutoffs both say yes; otherwise the quote auto‑switches to pooled ground and pings a manager if someone tries to pay 2x air from Ohio. Caveat: I still override for genuine stat cases.
But i set up a ‘drop-ship fallback’ that, when ATP says 19 days from Ohio, checks two authorized distributors within 200 miles and auto-swaps to their stock at ground, keeping ‘ships today’ without 2x air. It cut freight 17% on Fridays after 5:02 p.m., but we only allow it if lot/UDI and IFU match and the rep clicks a quick compliance box. Would that play nice with your hold-and-bundle, or do you need corporate to bless distributor links first?