Nanaimo Trip — Expense Settlement

纳奈莫之行 费用结算 · July 2026 · 10 people / 10人 · Housing 房费已单独结清，不计入此表

1. Who counts 人员与份数

Two drivers are exempt from the shared pool. 两位司机免分摊公共费用。

2. Shared pool 公共费用（÷ 8）

Food, gas, parking, vehicle ferry fares and fuel surcharges. 食物、油费、停车、车辆渡轮费及燃油附加费。

Excluded — Experience Card reload $130 (Ryan). This is stored value loaded onto Ryan's BC Ferries Experience Card, not a trip cost. The card's discount is already baked into the ferry fares listed above and in §3, and the unused balance stays on Ryan's card ($169.45 per receipt). Counting it again would charge the group twice.

Corrected vs. the handwritten note. The note listed 车两台 $360.45 + 燃油港口 $33.55 (Nanaimo) and 车两台 $26.90 (Gabriola). Verified against the BC Ferries receipts and booking confirmation: the Nanaimo vehicle fare is 4 × $89.00 = $356.00, and the passenger fuel surcharge was double-counted (see §3 and the notes below). The Gabriola vehicle fare is 2 × ($27.55 − $9.60 UH savings) = $35.90 — the note's "$26.90" is the remaining stored-value balance printed on the second Gabriola receipt, copied off the wrong line. 原记录经票据核对后已更正：Nanaimo 车费 $356.00，乘客燃油费重复计算已剔除；Gabriola 记录的 $26.90 实为储值卡余额，车费应为 $35.90。
$130 储值卡充值不计入公共。这是 Ryan 的 BC Ferries Experience Card 充值，折扣已体现在上述船票金额中， 余额仍留在卡内，若再分摊等于重复计费。

3. Personal ferry fares 个人船票（不分摊）

All passenger fares are personal — all prepaid by Ryan on the BC Ferries bookings. 所有乘客船票归个人，均由 Ryan 统一垫付。
Van↔Nanaimo is billed in fare units of $22.05 = one adult, one crossing ($21.00 fare + $1.05 port fee & fuel surcharge). An adult = 2 units (both ways); a child under 12 = 1 unit; the two seniors travel free outbound and pay 1 unit on the return. 温↔Nanaimo 按每单位 $22.05（成人单程 21.00 + 燃油附加费 1.05）计：成人 2 单位，12岁以下儿童 1 单位， 长者去程免费、回程 1 单位。
The $1.05 is the fuel surcharge, not a port fee — the booking confirmation prices two adults at $44.10 = 2 × $22.05 fuel-inclusive. It is therefore excluded from the shared pool in §2, which now carries only the vehicles' fuel surcharge ($4.45 each) plus the port fees. $1.05 为燃油附加费（非港口费），已含在个人票价内，故公共部分只计车辆燃油费与港口费，避免重复。

4. Balance 结算总表

Owed = shares × 160.79 + personal ferry. Balance = paid − owed. 正数为应收，负数为应付。

5. Who pays whom 转账方案

Assumptions 计算说明

1. Housing 房费 (梅 $1,000 / 淑敏 $200) is excluded — already settled separately. 已单独结清，不计入。
2. ÷ 8: 10 people minus the 2 drivers (Ryan, Liza). Children count as full shares. 10人减2位司机，儿童按全份计。
3. All passenger ferry fares are personal, so the two seniors' reduced fares stay with them. Vehicle fares, fuel and port surcharges are shared. 乘客船票归个人，车辆渡轮费与燃油港口费为公共。
4. Experience Card $130 is NOT shared. It is a stored-value reload on Ryan's BC Ferries Experience Card, which is what gives the discounted island fares. Those discounted fares are already the amounts listed in §2 and §3, and the unused balance remains on Ryan's card — so the reload stays entirely with Ryan. 储值卡充值 $130 不分摊：折扣已反映在船票金额中，余额留在 Ryan 卡内，归 Ryan 自己。
5. Ryan fronted all ferry bookings (vehicles + every passenger fare + crab licence), parking and the sand sculpture tickets. 所有渡轮、停车、沙雕费用由 Ryan 垫付。
6. Ryan / Simon / Danny's passenger fares are included ($153.15). The BC Ferries receipts show 6 adults + 2 children + 2 seniors on both routes — all 10 people, drivers included — so drivers pay their own passenger fare; the driver exemption applies only to the shared pool. Ryan fronted these fares too, so both his owed and his paid rise by the same amount. 司机免的是公共分摊，船票仍需自付；此项由 Ryan 垫付，应付与已垫付同增。
7. The crab/fishing licence ($14.22) is excluded from this analysis entirely — handled separately outside the settlement. 钓蟹证 $14.22 不纳入此表，另行处理。
8. Section 3 uses the family-grouped fare figures ($22.05/unit), which fold in port fees and fuel surcharge and supersede the rounded per-person numbers in the original handwritten note (e.g. 淑敏 "107"). 第 3 节采用按家庭归并的票价（含港口及燃油费），取代原手写记录中的约数。
9. Per share is exactly $160.7875; rounded to $160.79 in display, exact value used in the balance. 每份精确值 $160.7875。

Ferry reconciliation 渡轮对账

Fuel surcharge rates derived from the receipts and confirmed by the booking confirmation. 燃油附加费费率由票据推导，并经订单确认页核实。

Every printed total reproduces exactly: 149.85 (veh + 2A + 1C + 2 senior free) · 194.95 (veh + 4A + 1C) · 194.95 (veh + 2A + 1C + 2 senior paying) — Van↔Nanaimo, 4 sailings, grand total $734.70. Personal units collect $352.80, leaving $381.90 public (vehicles 356.00 + vehicle fuel 17.80 + port fees 8.20). The note had $394.00, i.e. $12.10 over — $4.45 of vehicle fuel folded into the vehicle line, plus $7.65 of passenger fuel surcharge charged twice. Gabriola: 51.45 + 36.95 = $88.40 = personal 48.70 + fuel 3.80 + vehicles 35.90 ✓, no repeat there.

Outstanding: the return sailing for the 4-adult vehicle is not among the receipts; it is taken as $194.95, matching its outbound leg and the confirmed 2026/07/31 booking. 四人车的回程票据缺失，按 $194.95 计。