The ratios calculated by hand were after one transition only. After repeated transitions, the ratios eventually stabilize to the underlying collective preference.

Hope you're able to find consensus for your family trip!