1 Overview
══════════
After last team meeting, where an additional 300K ZAR (about USD20k)
was allocated to bursaries, I promised to take a second look at
accomodation costs, to see if the 700K ZAR I previously calculated was
a gross overestimate. My revised calculations are around 670K ZAR,
which given the number of estimates here, is pretty close.
2 Notes
═══════
• Approval rate is based on last year for accomodation and food, but
more of an educated-guess/goal for travel. Last year the approval
rate was higher, but the size of the requests was smaller.
• The unit cost for travel approvals is the median of requests for
this year.
• Unit costs for food and acommodation are ZAR300 (each) per
day/night.
• Average request during debconf is 8.3 nights; this may be because
people were just generous filling in dates.
• Average request during DebCamp is 7 nights; this is considering July
1 as an arrival day. Moving that just moves costs from DebConf to
DebCamp.
• the complicated bit is the assumption about people who request both
travel sponsorship and accomodation, and report that they will be
unable to attend debconf without the travel sponsorship.
• The "Need" column records the fraction of applicants in a given
category who reported this highest level of financial need.
• Those applicants who cannot attend without travel funding are
approved at the same rate for accomodation as for travel, while
the remaining applicants are approved at historical rates. The
formula for column 5 (the number of approved people) is thus
$5 = @2$3*$4*$2+(1-$4)*$3*$2
3 Numbers
═════════
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
Requests Approve Need approved unit Subtotal (ZAR)
────────────────────────────────────────────────────────────────────────────────
Travel 103 .45 0.54 46. 15000 690000.
────────────────────────────────────────────────────────────────────────────────
Camp Accom w. travel 42 0.8 0.37 28. 2100 58800.
Camp Accom only 20 0.8 0 16. 2100 33600.
Camp Food w. travel 40 0.8 0.37 27. 2100 56700.
Camp Food only 19 0.8 0 15. 2100 31500.
────────────────────────────────────────────────────────────────────────────────
Camp Food + Accom 43. 180600.
────────────────────────────────────────────────────────────────────────────────
Conf Accom w. travel 92 0.85 0.37 65. 2500 162500.
Conf Accom only 42 0.85 0 36. 2500 90000.
Conf Food w. travel 85 0.85 0.37 60. 2500 150000.
Conf Food only 41 0.85 0 35. 2500 87500.
────────────────────────────────────────────────────────────────────────────────
Conf Food + Accom 98.0 490000.
────────────────────────────────────────────────────────────────────────────────
Food + Accom 670600.
────────────────────────────────────────────────────────────────────────────────
Total 1360600.
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
Attachment:
signature.asc
Description: PGP signature