Nanaimo Trip — Expense Settlement

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

Shared pool 公共费用$1,289.40
Shares 分摊份数8
Per share 每份$161.18
Personal ferry 个人船票$415.72

1. Who counts 人员与份数

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

Group 组Members 成员Shares 份数Note 备注
RyanRyan, Simon, Danny2Ryan = driver 司机,免分摊
Shumina 淑敏Shumina, James, Alan (11)3Alan under 12
May 梅May, Lion (10)2Lion under 12
Maggie 马姐妹Maggie1Senior 长者
Liza 林姐妹Liza0Driver 司机 + senior,免分摊
Total10 people8

2. Shared pool 公共费用(÷ 8)

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

Item 项目Paid by 垫付人Amount 金额
Costco food 食物Maggie 马姐妹603.31
Food 食物Shumina 淑敏76.20
Food 食物Ryan64.05
Gas 加油Liza 林姐妹58.99
Gas 加油Ryan41.39
Whytecliff Park parking ×2 停车Ryan10.76
Sand sculpture 参观沙雕Ryan10.00
Ferry — vehicles ×2, Van↔Nanaimo 车渡Ryan360.45
Ferry — fuel + port fee, Van↔Nanaimo 燃油+港口费Ryan33.55
Ferry — vehicles ×2, Gabriola 车渡Ryan26.90
Ferry — fuel surcharge, Gabriola 燃油附加费Ryan3.80
Total 合计1,289.40
÷ 8 shares 每份161.18

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.
$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 单位。

Family 家庭Fare units 单位Van↔NanaimoGabriolaOther 其他Total 合计
小丹 — Ryan · Simon · Danny6 × 22.053 adults × 2132.3020.85153.15
Shumina 淑敏 · James · Alan (11)5 × 22.052 adults × 2 + child110.2517.40127.65
May 梅 · Lion (10)3 × 22.051 adult × 2 + child66.1510.4576.60
Maggie 馬姐妹 senior1 × 22.05return only 仅回程22.0514.22 crab 蟹证36.27
Liza 林姐妹 senior1 × 22.05return only 仅回程22.0522.05
Total 合计16 units352.8048.7014.22415.72

4. Balance 结算总表

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

Group 组SharesShare cost 分摊 Personal 个人Owed 应付Paid 已垫付Balance 结余
小丹 — Ryan · Simon · Danny2322.35153.15475.50966.62+491.12
Maggie 馬姐妹1161.1836.27197.45603.31+405.87
Liza 林姐妹00.0022.0522.0558.99+36.94
Shumina 淑敏 · James · Alan3483.53127.65611.1876.20−534.98
May 梅 · Lion2322.3576.60398.950.00−398.95
Total81,289.40415.721,705.121,705.120.00

5. Who pays whom 转账方案

From 付款To 收款Amount 金额
Shumina 淑敏Ryan491.12
Shumina 淑敏Maggie 馬姐妹43.86
May 梅Maggie 馬姐妹362.01
May 梅Liza 林姐妹36.94
Total933.93

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. 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 节采用按家庭归并的票价(含港口及燃油费),取代原手写记录中的约数。
  8. Per share is exactly $161.175; rounded to $161.18 in display, exact value used in the balance. 每份精确值 $161.175。