pot wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== Balance for EGF 2018 in Pisa ====== 

We had 1476 subscribed to the web site, 1176 showing up at the congress venue, including guests, volunteers, teachers and organisers, and 1021 players in at least one official tournament.  We estimate a total of 1200 people attending the congress, including a small number who did not show up at the desk.

Players in official tournaments were: 796 (open 1w), 650 (weekend), 560 (open 2w), 332 (rapid 1w), 241 (rapid 2w), 50 (women), 45 (senior), 22 (youth), 15 (children).  Players in side tournaments were: 150 (9x9), 120 (13x13), 120 (lightning), 200 (pairgo), from 15 to 60 in other side tournaments.  The maximum-numbered board was 386. 

Further details include the article [[https://eurogofed.org/index.html?id=233|Organising EGC 2018]], [[subscriptions]] by fee band and some web access [[http://pot.potorti.it/go/egc2018/webstat/|statistics]].

===== Final budget =====
^ Description                        ^ Income  ^ Outcome ^
| Subscription fees                  |  104184 |   3000 |
| EGC friends (12S+5G)               |    2250 |    870 |
| Small sponsors minus taxes         |    1490 |    308 |
| Money awards                       |   28350 |  36130 |
| Benefit awards                     |    8812 |  13452 |
| Merchandise                        |   10301 |  10162 |
| Bags and printouts                 |     113 |   8233 |
| Location                           |         |  30909 |
| General congress expenses          |     323 |   9029 |
| Teachers, VIPs, hosts              |    2556 |  14876 |
| Ceremonies, decoration             |     695 |   6651 |
| Professional services              |    1000 |  14117 |
| Volunteers                         |    4430 |  11744 |
| Provision (to be kept for 5 years) |         |   3500 |
| Adjustment                         |         |      9 |
^ Total ^  ~~=sum(range(col(),1,col(),row()-1))~~ ^  ~~=sum(range(col(),1,col(),row()-1))~~ ^
^ Surplus  ^ ^  ~~=sum(range(col()-1,1,col()-1,row()-2)) - sum(range(col(),1,col(),row()-2))~~ ^


==== Subscription fees ====
^ Source ^ Income ^ Contribution ^
^ Total ^  ~~=sum(range(col(),2,col(),99))~~ ^  ~~=sum(range(col(),2,col(),99))~~ ^
| Paypal (including EGC friends)          |   18396 |       |
| Stripe (including EGC friends)          |   34849 |       |
| Bank transfers (including EGC friends)  |   21071 |       |
| Cash           (including EGC friends)  |   30288 |       |
| EGC friends                             |   -2250 |       |
| Top32 subscriptions (32x80 paid by EGF) |    2560 |       |
| FIGG renewals 2018                      |    -730 |       |
| Bonus Point Tournament (paid to EGF)    |         |  3000 |


==== EGC friends ====
^ Item                        ^ Income ^ Costs ^
^ Total ^  ~~=sum(range(col(),2,col(),99))~~ ^  ~~=sum(range(col(),2,col(),99))~~ ^
| 12 Silver (2 complimentary) |   1000 |       |
| 5 Gold                      |   1250 |       |
| T-shirts and fans           |        |   264 |
| T-shirts adaptation (30+30) |        |    60 |
| Basket of local food products |      |   337 |
| Certificates                |        |    34 |
| Trophies                    |        |    85 |
| VIP dinner (paid by EGF)    |        |       |
| Gold friends city tour      |        |    90 |


==== Small sponsors ====
Outcome for invoices is VAT 22%.

^ Sponsor                      ^ Income ^ Outcome ^ Paid ^ Invoice # ^
^ Total ^  ~~=sum(range(col(),2,col(),99))~~ ^  ~~=sum(range(col(),2,col(),99))~~ ^ ^ ^
| Smokin                       |   200 |   36  |      bank |  1   |
| Coradi                       |   100 |   18  |      cash |  3   |
| Argini e margini e Arno vivo |   200 |   36  |      cash |  7   |
| Torre del luppolo            |   100 |   18  |      cash |  4   |
| Daniele Hair                 |   100 |   18  |      bank |  8   |
| Gelateria Gunny              |   100 |   18  |      bank |  5   |
| Vodafone                     |   300 |   54  |      bank |  2   |
| Bar l'Etrusco                |    50 |    9  |      bank |  9   |
| Bar Salvini                  |   100 |   18  |      cash |  10  |
| Fact                         |   150 |   27  |      bank |  6   |
| Excuses for declined sponsorship |   |   54  |    paypal |      |
| Gold friends city tour       |    90 |       |   benefit |      |
| Delayed VAT paykment         |       |    2  |      bank |      |
| Income tax                   |       |    0  | less than 10€ |  |


==== Money awards ====
^ Tournament ~~=label(sp_benefit)~~     ^ Sponsor ^ Prize value ^ Sponsored by ^
^ Total ^  ~~=sum(range(col(),2,col(),99))~~ ^  ~~=sum(range(col(),2,col(),99))~~ ^ ^
| European championship       |   8500 |  11000 | Managed by EGF granting top three prizes |
| Pandanet tournament         |  10000 |  10000 | Entirely managed by Pandanet |
| Open tournament             |   7500 |   7500 | DeepMind grants the top ten prizes |
| Weekend tournament          |   2100 |   2500 | DeepMind grants the top three prizes |
| Rapid tournament            |        |   1250 |
| Team tournament             |        |    900 |
| Rengo tournament            |        |    630 |
| Women's tournament          |    250 |    550 | S&G Schaak & Go het Paard grants the first prize |
| Lightning tournament        |        |    500 |
| 9x9 tournament              |        |    500 |
| 13x13 tournament            |        |    500 |
| End game tournament         |        |    300 |


==== Benefit awards ====
^ Award ~~=label(sp_benefit)~~     ^ Sponsor ^ Prize value ^ ^
^ Total ^  ~~=sum(range(col(),2,col(),99))~~ ^  ~~=sum(range(col(),2,col(),99))~~ ^ ^
| Guo Juan                     |  7700 |  7700 | 308 25€ vouchers for Guo Juan's site |
| Schaak en Go het Paard       |  1032 |  5160 | 344 15€ vouchers for S&G shop |
| Inseong Hwang                |    80 |    80 | 2 40€ vouchers for Yunguseng Dojang school |
| Honey                        |       |   216 | |
| Local food products          |       |   106 | 12 wine + 94 other |
| Limoncello                   |       |    70 | ingredients and bottles |
| Wine senior tournament       |       |   120 | 42 bottles |


==== Merchandise for offer, gift, volunteer bonuses ====
^ Item                           ^ Offers ^ Expenses ^ ^
^ Total ^  ~~=sum(range(col(),2,col(),99))~~ ^  ~~=round(sum(range(col(),2,col(),99)), 0)~~ ^ ^
| T-shirts small logo Oberhof            |   895 |  1902 | 1951 invoice is 226 T-shirts + 2 banners |
| 15 T-shirts Oberhof as volunteer bonuses |     |  -180 | |
| 200 T-Shirts logo                      |       |  1162 | |
| 500 T-Shirts drawing                   |       |  5829 | |
| 300 pens                               |       |   114 | |
| 50 USB keys                            |       |   358 | |
| 100 hats                               |       |   218 | |
| 100 magnets                            |       |    60 | |
| 100 mugs                               |       |   511 | |
| 250 pencil sharpeners                  |       |   100 | |
| 200 fans                               |       |   165 | |
| EGC friends T-shirts and fans          |       |  -264 | |
| T-shirts as volunteer bonuses          |       |  -190 | |
| Offers by members on site              |  9376 |   450 | total income minus consignments |
| Offers by members after site           |    30 |       | |
| Complimentary items for artists        |       |   -73 | |


==== Bags and printouts ====
1400 of each item.

^ Item                         ^ Reimbursement ^ Cost ^
^ Total ^  ~~=sum(range(col(),2,col(),99))~~ ^  ~~=sum(range(col(),2,col(),99))~~ ^
| Badge holder, pencil, pen    |      |   769 |
| Lanyard                      |      |  1202 |
| 3 folded flyers              |      |   389 |
| sponsor flyers               |      |   105 |
| Booklet                      |      |  1279 |
| Bag and name holder          |      |  2273 |
| Canteen                      |      |  2111 |
| Weimer and Teuber flyers     |  113 |   105 |


==== Location ====
^ Service ~~=label(location)~~     ^ Expense ^ ^
^ Total ^  ~~=sum(range(col(),2,col(),99))~~ ^ ^
| Palazzo dei congressi                 |  14311 | PdC location cost                                      |
| Opening 2h at night for Pairgo        |    451 | PdC 2 hours opening August 2 after midnight            |
| Tent structure, furniture             |   7308 | including transport, mounting, anti-noise panels       |
| Chairs and tables Isamu               |   1110 | transport 610 + rent 500 (530 chairs and 63 desks)     |
| Projectors, cabling, Internet, etc.   |   3416 | including main beamer, three small beamers, 50Mb/s DSL |
| Long chaises                          |    270 | 2 volunteers, 2 referees, 2 pros, 4 free area          |
| Metallic plate wall goban             |     30 | magnetic teaching goban                                |
| Hot beverage stands and fresh water   |    209 | 200 + 9, discounted from 1350                          |
| Covers for tables                     |    527 | 455+72                                                 |
| Microphones                           |    400 | for professional lectures                              |
| Banner                                |    708 | PdC 366 structure + 341 banner and setup               |
| Cleaning services bastione            |   1937 | cleaning services (1718) and materials (219)           |
| Lamps for bastione                    |     80 | four floor lamps                                       |
| Van rental for bastione               |    152 | two trips 58 + 94                                      |


==== General congress expenses ====
^ Description ^ Contribution ^ Expense ^ Notes ^
^ Total  ^  ~~=sum(range(col(),2,col(),99))~~ ^  ~~=sum(range(col(),2,col(),99))~~ ^ ^
| Banners and flyers Oberhof           |       |   129 | 80 flyers + 49 banners (1951 invoice - 1902 T-shirts) |
| Goban import and delivery from Korea |       |   285 | |
| Italian SIM for hosts                |       |    30 | |
| Trophies                             |       |  2076 | 2161 - 85 for EGC friends |
| Stationery 1                         |       |    23 | receipts folders |
| Stationery 2                         |       |  1758 | paper, pens, envelopes, scissors, tape, markers, etc. |
| Office items                         |       |   908 | radios, toner, fans, mats, waist bags, multiplugs |
| Children room mat                    |       |   149 | |
| Stationery 3                         |       |   316 | toner, tape, batteries |
| IT material                          |       |   269 | 5 chromecasts 200, 2 USH hubs 30, boiler 40 |
| 2 SD memory cards                    |       |    80 | |
| Excess material as volunteer bonuses |       |  -468 | toner, chaises, lamps, bags, fans, multiplugs, mice, chromecasts |
| 4 PCs rental                         |       |   120 | |
| Copy shop - EGC friends certificates |       |   400 | |
| Pharmacy                             |       |    63 | |
| AGM food                             |       |    76 | 65 pizza + 11.07 Coop |
| Staff T-shirts                       |       |   733 | |
| Soccer fields                        |       |   384 | |
| Movie screening                      |       |   147 | including 8 for Vimeo |
| Hamburg go club rental (56 sets)     |       |   280 | |
| Hamburg shipment (EGF contribution)  |   323 |  1044 | 647 Hamburg + 397 to Hamburg |
| Hamburg sets damage reimbursement    |       |   135 | |
| Veneto club shipment                 |       |    69 | |
| Veneto club batteries                |       |    23 | |


==== Teachers, VIPs, hosts ====
^ Description ^ Contribution ^ Expense ^
^ Total  ^  ~~=sum(range(col(),2,col(),99))~~ ^  ~~=sum(range(col(),2,col(),99))~~ ^
| [[Hotels]] and taxis          |       |  11047 |
| VIP dinner (paid by EGF)      |  2556 |   2556 |
| Chidori reimbursements        |       |    300 |
| Scientific conf. dinner wine  |       |     90 |
| Teacher cockades              |       |    110 |
| Five-a-side soccer            |       |    200 |
| Buffet dinner                 |       |     87 |
| Present for Ayashi            |       |    150 |
| Honey 4 gift packs            |       |     24 |
| Telephone expenses            |       |     80 |
| Small expenses (50+182)       |       |    232 |


==== Ceremonies, decoration ====
^ Description                           ^  Income ^ Outcome ^ ^
^ Total ^  ~~=sum(range(col(),2,col(),99))~~ ^  ~~=sum(range(col(),2,col(),99))~~ ^ ^
| Art gallery                     |   500 |         |
| Dancers reimbursements          |       |     300 |
| Coreography brico expenses      |       |     186 |
| Coreography flags and masks     |       |     220 |
| Coreographer oil reimbursements |       |      45 |
| Blues band                      |       |     300 |
| Blues band dinner               |   195 |     195 | Grant by Parton |
| Van rental                      |       |      55 |
| Pianist trip                    |       |      99 |
| Piano rental                    |       |     366 |
| Dancers dinner                  |       |     166 |
| Dancers flowers                 |       |      42 |
| Dancers honey                   |       |      10 |
| Complimentary items for artists |       |      73 |
| Stage extension NK              |       |     244 |
| SIAE (song copyright)           |       |     922 |
| Opening ceremony refreshments   |       |    3300 |
| Final organisers' dinner        |       |     128 |


==== Professional services and special volunteers ====
^ Service ~~=label(consultancy)~~   ^  Contribution ^ Expense ^
^ Total ^  ~~=sum(range(col(),2,col(),99))~~ ^  ~~=sum(range(col(),2,col(),99))~~ ^
| Video promo                              |       |  1269 |
| ToscanaTV interview                      |       |   200 |
| Accountant                               |       |  1560 |
| Taxes                                    |       |     5 |
| Desk secretary                           |       |  1500 |
| Civil liability insurance                |       |   299 |
| Bank account                             |       |   674 |
| Web hosting                              |       |   418 |
| Domain name                              |       |    28 |
| Software (web and desk operators)        |       |  1500 |
| Printed material designer                |       |   500 |
| Eurogotv                                 |       |  2000 |
| Photographer                             |       |   800 |
| Video operator                           |       |   400 |
| Web content manager                      |       |   800 |
| Full-time desk attendants                |       |   800 |
| Tournament directors                     |       |   700 |
| Teachers                                 |       |   400 |
| Protocolling EC games (EGF contribution) |  1000 |       |
| Unanticipated food bonuses ((Unanticipated food bonuses were collective food expenses in excess of programs.  We mistakenly did not subtract them from money bonuses, so foreign and special volunteers received a food bonus exceeding the [[https://egc2018.it/en/volunteer.html|agreed-upon one]].))           |       |   264 |


==== Volunteers ====
^ Decription ^  Grant ^  Bonus ^ ^
^ Total ^  ~~=sum(range(col(),2,col(),99))~~ ^  ~~=sum(range(col(),2,col(),99))~~ ^ ^
| Benefit bonuses (includes 250€ S&G)       |   462 |  1047 | Grants as benefits paid at value |
| Food bonuses                              |       |   826 | Distributed to national volunteers |
| Unanticipated food bonuses                |       |  1616 | See footnote |
| Money bonuses to foreign volunteers       |       |  2755 | Distributed in 2018 |
| Money bonuses to national volunteers 2018 |       |  349 | Distributed in 2018 |
| Money bonuses to national volunteers 2019 |  3968 |  5151 | Grants as relinquished bonuses |


===== EGF balance =====
All entries of this table are already listed in some subtable of the final budget above, just look for "EGF" to find them.  This table is not part of the balance, it only exists to compute the EGF balance versus congress organisation.

^ Description                           ^  Income ^ Outcome ^
^ Total ^  ~~=sum(range(col(),2,col(),99))~~ ^  ~~=sum(range(col(),2,col(),99))~~ ^
^ reimbursement to EGF ^  ~~=r1c2-r1c1~~ ^ ^
| Protocolling EC games                    |  1000 |        |
| Bonus Point Tournament                   |       |   3000 |
| EC subscription fees 80x32               |  2560 |        |
| EC money awards                          |  8500 |  11000 |
| VIP dinner                               |  2556 |   2556 |
| Hamburg shipment (half of one-way)       |   323 |        |


===== Inventory =====
Various purchased material and usage.  Stationery and office items have same value as cost, merchandise has value greater than cost.

==== Purchase and uses ====
Office consumed value is estimated from the list of purchased items.  Merchandise remaining value is estimated at the average offer rate we got during EGC.

^ Description                           ^  Purchase ^  Use ^ ^
| Office purchases                           |  3503 |       | See //General congress expenses// subtable |
| Office consumed                            |       |   910 | Consumed or damaged |
| Office transferred to next EGC             |       |  1178 | Shipped to EGF for EGC 2019 |
| Office Italian volunteer bonuses 2018      |       |   468 | |
| Office Italian volunteer bonuses 2019      |       |   900 | Approximate |
^ Office remaining value       ^ ^  ~~=c1r1-sum(c2r2:c2r5)~~ ^ FIGG assets ^
| Merchandise value of purchased items       | 18000 |       | See //Merchandise// subtable |
| Merchandise for offer                      |       |  9851 | Given for offer to EGC attendees |
| Merchandise given as gift                  |       |   337 | Given to hosts, EGC friends, and as prizes |
| Merchandise Italian volunteer bonuses 2018 |       |   370 | |
| Merchandise Italian volunteer bonuses 2019 |       |  4300 | Approximate |
^ Merchandise remaining value  ^ ^  ~~=c1r7-sum(c2r8:c2r11)~~ ^ FIGG assets ^


==== Transferred to next EGC ====
^ Description                           ^  Value ^
^ Total ^  ~~=sum(range(col(),2,col(),99))~~ ^
| about 5 coloured paper reams                                 |   35 |
| about 170 new and 100 used AA batteries                      |  125 |
| 10 5cm wide heavy duty scotch tape rolls of various colours  |   60 |
| 14 5cm wide scotch tape for packaging various colours        |   26 |
| about 100 A3 heavy grey paper for children drawings          |   20 |
| about 500 yellow and 1000 medium envelopes                   |   22 |
| 2 scotch tape dispensers and 15 Scotch magic tape rolls      |   50 |
| paper glue sticks and 4 patafix sheets                       |   16 |
| 500 A4 and 500 envelopes                                     |   97 |
| 500 pens                                                     |  250 |
| 96 pencils and 18 rubbers                                    |   26 |
| over 50 coloured markers                                     |   50 |
| 15 sheets of small and about 500 medium adhesive labels      |  100 |
| 6 5cm high folders and 22 plastic folders for documents      |   22 |
| 9 A5 block notes                                             |    7 |
| 12 walkie-talkies plus chargers                              |  200 |
| about 5 staplers and many staples                            |   45 |
| about 10 scissors and about 5 cutters                        |   27 |