User Tools

Site Tools


egc2018:subscriptions

This is an old revision of the document!


Subscriptions

The first section has three tables where number of subscribers and income are noted. Income is nominal, based only on the relative fee. Real income is different, because of discounts, refunds and errors. The second section has one balance table per subscription fee band (numbered 1 to 9) where all offsets from the nominal income is listed.

Fees for few days

Regular days are all days except the 4-5 August weekend

  1. One regular day: 25€, on site 35€, no reductions
  2. Two or three regular days: same fee as weekend
  3. Four or five regular days: midway between we and 1w+we fees
  4. One weekend day: same fee as weekend; can be summed to above fees

Subscription fees, number and nominal income

Full and reduced registration quotes span three columns: whole congress (full), one week plus weekend (1w+we), weekend only (we). Free registration quotes span four columns: under 13 (u13), organisers (org), complimentary (cmp), accompanying person (acc), top 32 (top)

Fees € Full price Age 13-18 Free
full 1w+we we full 1w+we we u13 org cmp acc top
2016-07-20 - 2016-12-31 80 50 60 40 0 0 0 0 80
2017-01-01 - 2017-04-30 110 70 30 80 55 20 0 0 0 0 80
2017-05-01 - End of EGC 130 80 35 100 65 25 0 0 0 0 80
End of EGC - 2017-12-31 150 95 40 115 75 25 0 0 0 0 80
2018-01-01 - 2018-03-31 170 105 45 130 85 30 0 0 0 0 80
2018-04-01 - 2018-05-31 185 115 50 140 90 30 0 0 0 0 80
2018-06-01 - 2018-06-30 200 125 55 150 100 35 0 0 0 0 80
2018-07-01 - 2018-07-22 215 135 60 160 105 40 0 0 0 0 80
On site (online only) 230 145 65 170 115 45 0 0 0 0 80
Number of subscriptions Full price Age 13-18 Free Total Cumtot
full 1w+we we full 1w+we we u13 org cmp acc top
2016-07-20 - 2016-12-31 45 9 2 5 1 1 1
2017-01-01 - 2017-04-30 18 3 2 3 4 1
2017-05-01 - End of EGC 148 65 1 10 11 14 1 1
End of EGC - 2017-12-31 70 34 5 6 1 8
2018-01-01 - 2018-03-31 55 50 6 13 4 20 29 4
2018-04-01 - 2018-05-31 45 75 16 5 9 40 20 54
2018-06-01 - 2018-06-30 13 18 6 1 2 6 12 27 2 14
2018-07-01 - 2018-07-22 8 8 5 1 2 5 1 2 3
On site (online only) 10 13 8 1 3 2 1
Totals
Nominal income € Full price Age 13-18 Free Total Cumtot
full 1w+we we full 1w+we we u13 org cmp acc top
2016-07-20 - 2016-12-31 3600 450 120 0 0 0 0
2017-01-01 - 2017-04-30 1980 210 60 240 0 0
2017-05-01 - End of EGC 19260 5200 35 1000 715 0
End of EGC - 2017-12-31 10500 3230 200 690 75 0
2018-01-01 - 2018-03-31 9350 5250 270 1690 340
2018-04-01 - 2018-05-31 8325 8625 800 700 810
2018-06-01 - 2018-06-30 2600 2250 330 150 200
2018-07-01 - 2018-07-22 1720 1080 300 160 210
On site (online only) 2300 1885 490 115
Totals

Balance sheets per fee band

1st fee band balance nominal fee income
Fees income Actual Unbalance
Totals
2016-08-02 800.00 cash from Pot in St.Petersburg
2016-08-07 500.00 cash from Alessandro in St.Petersburg
2016-08-07 630.00 cash from Maurizio in St.Petersburg
2016-08-07 1370.00 cash from Carlo in St.Petersburg → Maurizio
2016-08-07 520.00 cash from Papini in St.Petersburg → Maurizio
2016-07-10 330.00 -25.00 cash from Maurizio in St.Petersburg (95$+290$-fee)
2016-08-10 50.00 subscription in extremis from Maurizio in St.Petersburg
2016-08-16 -160.00 refund to Maurizio for Marz family
-105.00 unexplained: maybe missing or misplaced fees
2nd fee band balance nominal fee income
Fees income Actual Unbalance
Totals
2017-04-30 2118.00 +3.00 Wire transfers + wrong collection fees (18-15 to be refunded)
2017-07-31 +15.00 2 excess wire transfer fees to refund
2017-04-30 390.00 Paypal
2018-03-20 +110.00 Paypal refund to Andrea Mori, volunteer
-110.00 unexplained: probably 1 missing full fee
3rd fee band balance nominal fee income
Fees income Actual Unbalance
Totals
2017-07-31 16665.00 Cash from Oberhof +895 (t-shirts) = 17560 (actual)
2017-07-31 -595.00 Ucraine discounts
2017-07-31 -55.00 Cash lost in Oberhof
2017-07-31 -80.00 Alessandro flyers
2017-07-31 1990.01 +24.01 Wire transfer +10(t-shirt)=2000.01(actual) + w.c.f. (70.01-46 t.b.r)
2017-07-31 +46.00 2 excess wire transfer fee to refund
2017-07-31 2605.55 -4.45 Paypal + wrong collection fees
2017-07-31 4315.88 +0.88 Stripe + wrong collection fees
-50.00 unexplained: maybe missing or misplaced fees
4th fee band balance nominal fee income
Fees income Actual Unbalance
Totals
2017-12-31 4321.00 +36.00 Wire transfer + wrong collection fees (51-15 to be refunded)
2017-12-31 +15.00 1 excess wire transfer fee to refund
2017-12-31 -15.00 A player paid 80+55=135 rather than 150
2017-12-31 3098.03 -1.97 Paypal + wrong collection fees
2017-12-31 7232.09 -17.91 Stripe + wrong collection fees
2017-12-31 -15.00 Lars Kristensen discount (150-135)
-45.00 unexplained: maybe missing or misplaced fees
5th fee band balance nominal fee income
Fees income Actual Unbalance
Totals
2018-03-31 3290.00 +25.00 Wire transfer + wrong collection fees (28-16 to be refunded)
2018-03-31 +16.00 2 excess wire transfer fees to refund
2018-04-10 20.00 cash from Isamu for Ikuyo Katagiri
2018-04-10 -25.00 Ikuyo Katagiri discount (45-20)
2018-03-31 5079.06 +4.06 Paypal + wrong collection fees
2018-03-31 8099.73 -15.27 Stripe + wrong collection fees
-76.00 unexplained: maybe missing or misplaced fees
6th fee band balance nominal fee income
Fees income Actual Unbalance
Totals
2018-05-31 7395.00 +6.00 Wire transfer + wrong collection fees
2018-04-09 -740.00 Club Hayashi discounts (1535-795)
2018-05-30 +44.00 reimbursement for visa invitation courier
2018-05-31 -70.00 Discounted fees ID 1375 e ID 1377
2018-05-31 2896.31 -3.69 Paypal + wrong collection fees
2018-05-31 7801.98 -13.02 Stripe + wrong collection fees
-00.00 unexplained: maybe missing or misplaced fees
7th fee band balance nominal fee income
Fees income Actual Unbalance
Totals
2018-06-30 0000.00 +00.00 Wire transfer + wrong collection fees
2018-06-07 -75.00 Discounted fee ID 1428
2018-06-30 0000.00 +00.00 Paypal + wrong collection fees
2018-06-30 0000.00 +00.00 Stripe + wrong collection fees
-00.00 unexplained: maybe missing or misplaced fees
egc2018/subscriptions.1535330121.txt.gz · Last modified: 2018-08-27 00:35 by pot