User:Cotton/Sandbox

Attention ! User:FraCici is authorized to edit in this page because we're co-working on the Wikimedia Conference financial report, thanks. --Cotton (talk) 19:48, 30 May 2013 (UTC)

Expenses

Number	Category	Item description	Unit	Number of units	Actual cost per unit	Actual total	Budgeted total	Currency	Notes
1	Welcome Event	Welcome cocktail/dinner at Frida's Club				1.200	5.000	Euro	Approx 80 attendants
2	Party	Social Dinner at Carlberg's Pizzeria				2.266	12.100	Euro	Approx 90 attendants
3	Venue + catering + WiFi	First deposit Grand Visconti Palace Hotel				18.240		Euro
4	Venue + catering + WiFi	Second deposit Grand Visconti Palace Hotel				25.040		Euro
5	Venue + catering + WiFi	Closing Balance Grand Visconti Palace Hotel				11.304,60		Euro
	Venue + catering + WiFi	Total expenditure Grand Visconti Palace Hotel				54.584,60	67.744,20	Euro
6	Stationery, Computer rental, Electronics & other	Badges' laminator rolls	1 roll	2	14,46	28,92		Euro
7	Stationery, Computer rental, Electronics & other	Lanyards badge holders	100 pieces box	2	47,85	95,70		Euro
8	Stationery, Computer rental, Electronics & other	Badges' printing				18,55		Euro
9	Stationery, Computer rental, Electronics & other	Badges and city maps' printing + Fax to Russia with Visa documents	1 page	729		72,10		Euro	One receipt from the same stationery shop.
10	Stationery, Computer rental, Electronics & other	General Computer&Electronic material				377,12		Euro
11	Stationery, Computer rental, Electronics & other	Blocks and Folders	100 pieces box	3		260.54		Euro
12	Stationery, Computer rental, Electronics & other	Badges and schedule tables' printing	1 page	1022		84.06		Euro
13	Stationery, Computer rental, Electronics & other	City maps' printing	1 page	100		23		Euro	50 copies: €0,40 per unit - 50 copies: €0,06 per unit
14	Stationery, Computer rental, Electronics & other	Computer & Electronic material				30,98		Euro
15	Stationery, Computer rental, Electronics & other	Highway toll		1		1,60		Euro	From WMI office (Monza) to the venue (Milan) to transport stationery material for the conference
16	Stationery, Computer rental, Electronics & other	Team building activity material (with facilitators)				11,85		Euro	"Save the egg" social game
17	Stationery, Computer rental, Electronics & other	Team building activity material (with facilitators)				60.58		Euro	"Save the egg" social game
18	Stationery, Computer rental, Electronics & other	State of the chapter's posters				18,55		Euro
19	Stationery, Computer rental, Electronics & other	Pegs for state of the chapter's posters				1,99		Euro
20	Stationery, Computer rental, Electronics & other	Copies	1 page	10	0.40	4		Euro
21	Stationery, Computer rental, Electronics & other	Digital photo printing for state of the chapter posters				25		Euro
22	Stationery, Computer rental, Electronics & other	State of the Chapter posters	1 poster	4	1,20	4,80		Euro
23	Stationery, Computer rental, Electronics & other	Digital photo printing for state of the chapter posters				10		Euro
24	Stationery, Computer rental, Electronics & other	Digital photo printing for state of the chapter posters				5		Euro
25	Stationery, Computer rental, Electronics & other	Parking Ticket on party night	1 ticket	1		9,50		Euro	Entry 8.20 PM - Exit 11.31 PM
26	Stationery, Computer rental, Electronics & other	Taxi to Linate Airport (round trip)	1 receipt	2		41,80		Euro	Due to a strike two delegates had their flight cancelled and the project manager had to go to Linate to book a new flight.
27	Stationery, Computer rental, Electronics & other	Pony Express to send documents for Visas	1 package	2		91,47		Euro	One package to Philippines - One package to Bangladesh
28	Stationery, Computer rental, Electronics & other	Pony Express to send documents for Visas + WMF Grant Agreement signed	1 package	20		371,81		Euro
29	Stationery, Computer rental, Electronics & other	3 notebooks and 2 printers rental				399,30		Euro	Taxes included
	Stationery, Computer rental, Electronics & other	Total Expenditure stationery and others				2.048,22	600	Euro
30	Local transport expenses	Carnet ATM 10 tube/bus travels each	1 carnet	136	13,80	1,876.80	3.450	Euro	Bought 160
31	Facilitators	Restaneo facilitator's fee				750		Euro	taxes included
32	Facilitators	Ramazzotti facilitator's fee				750		Euro	taxes included
33	Facilitators	Facilitators' accommodation Bio City Hotel	1 double room x night	3	158	474		Euro	taxes included
34	Facilitators	Restaneo facilitator's travel expenses				25,5		Euro	Bus tickets
35	Facilitators	Ramazzotti facilitator's travel expenses	Train tickets	2 tickets	128,5	257		Euro	Rome - Milan & back
	Facilitators	Total facilitators expenditure				2.256,5	10.000	Euro
36	Lodging Expenses Volunteers and Delegates (scholarship)	Monastery Hostel tourist tax	1 room	49 rooms		74		Euro
37	Lodging Expenses Volunteers and Delegates (scholarship)	Monastery Hostel deposit				880		Euro
38	Lodging Expenses Volunteers and Delegates (scholarship)	Monastery Hostel Full Payment				2.202		Euro
39	Lodging Expenses Volunteers and Delegates (scholarship)	Hotel Monopole				4.399		Euro
40	Lodging Expenses Volunteers and Delegates (scholarship)	Hotel Romana Residence				4.952		Euro
41	Lodging Expenses Volunteers and Delegates (scholarship)	Hotel Romana Residence Tourist Tax				200		Euro
42	Lodging Expenses Volunteers and Delegates (scholarship)	Ostello Bello				2.242		Euro
	Lodging Expenses Volunteers and Delegates (scholarship)	Total expenditure for lodging volunteers and scholarships				14.949	12.000	Euro
43	Volunteer travel expenses	Volunteer n.1 travel refund	1 train ticket	2		37		Euro	Trip Bologna-Milan and back
44	Volunteer travel expenses	Volunteer n.2 travel refund				77,20		Euro	Trip Padova-Milan and back + taxi to Padova train station
45	Volunteer travel expenses	Volunteer n.3 vehicle refund				129,60		Euro	Trip Concorezzo-Milan (venue) and back for 5 days [1] - Italian government-approved rate for reimbursing mileage http://servizi.aci.it/CKInternet/SelezioneModello
46	Volunteer travel expenses	Volunteer n.4 travel refund				63,20		Euro	Trip Trento-Milan and back + tube tickets
47	Volunteer travel expenses	Volunteer n.5 travel refund				51		Euro	Trip Bologna-Milan and back + tube tickets
48	Volunteer travel expenses	Volunteer n.6 travel refund				8,40		Euro	Train and tube
49	Volunteer travel expenses	Volunteer n.7 travel refund				36,75		Euro	Train Pass Arluno-Milan (April 17-23) + Trip Milan-Pisa
50	Volunteer travel expenses	Volunteer n.8 travel refund				55,50		Euro	Trip Reggio Emilia-Milan + Trip Milan-Bologna
96	Volunteer travel expenses	Volunteer n.9 travel refund				145,26		Euro	Trip Arcore-Milan (venue) and back for 5 days [2] - Italian government-approved rate for reimbursing mileage http://servizi.aci.it/CKInternet/SelezioneModello + highway toll
	Volunteer travel expenses	Total Expenditure volunteers' travels				603.91	2.000	Euro
51	Travel scolarships	Plane ticket WM-BD 1°	1 return ticket	1	1.175,89	1.175,89		Euro	Dhaka - Milan & back
52	Travel scolarships	Plane ticket WM-SK 1°	1 return ticket	1	165,16	165,16		Euro	Wien - Milan & back
53	Travel scolarships	Plane ticket WM-PT 1°	1 return ticket	1	156,15	156,15		Euro	Porto - Milan & back
54	Travel scolarships	Plane ticket WM-PH 1°& 2°	1 return ticket	2	940,32	1.880,64		Euro	Manila - Milan & back
55	Travel scolarships	Plane ticket WM-VE 1°	1 return ticket	1	446,55	446,55		Euro	Tel Aviv - Milan & back
56	Travel scolarships	Plane ticket WM-MK 1°	1 return ticket	1	409,18	409,18		Euro	Skopje - Milan & back
57	Travel scolarships	Plane ticket WM-CA 1°	1 return ticket	1	771	771		Euro	Montreal - Milan & back
58	Travel scolarships	Plane ticket WM-IN 1° I	1 ticket	1	614,90	614,90		Euro	Milan - Mumbai
59	Travel scolarships	Plane ticket WM-IN 1° II	1 ticket	1	128,06	128,06		Euro	London - Milan
60	Travel scolarships	Plane ticket WM-IN 1° III	1 ticket	1	708,05	708,05		Euro	Mumbai - London
61	Travel scolarships	Plane ticket WM-NEPAL	1 return ticket	1	749,39	749,39		Euro	Katmandu - Milan & back
62	Travel scolarships	Plane ticket WM-ZA 1°	1 return ticket	1	815,50	815,50		Euro	Johannesburg - Milan & back
63	Travel scolarships	Plane ticket WM-DE	1 return ticket	1	157,73	157,73		Euro	Berlin - Milan & back
64	Travel scolarships	Plane ticket WM-IN 2°	1 return ticket	1	779,73	779,73		Euro	Mumbai - Milan & back
65	Travel scolarships	Plane ticket WM-ZA 2°	1 return ticket	1	807,48	807,48		Euro	Johannesburg - Milan & back
66	Travel scolarships	Plane ticket WM-FI 1°	1 return ticket	1	199,78	199,78		Euro	Helsinki - Milan & back
67	Travel scolarships	Plane ticket WM-UA 1°	1 return ticket	1	214,01	214,01		Euro	Kiev - Milan & back
68	Travel scolarships	Plane ticket WM-UA 2°	1 return ticket	1	214,01	214,01		Euro	Kiev - Milan & back
69	Travel scolarships	Plane ticket WM-BD 2°	1 return ticket	1	1.234,89	1.234,89		Euro	Dhaka - Milan & back
70	Travel scolarships	Insurance WM-ZA				35		Euro	Personal travel insurance
71	Travel scolarships	Travel expenses WM-IN	1 receipt	1	90	90		Euro	Cab to Malpensa airport. Due to a strike two delegates had their flight cancelled and WM-IT booked a new flight leaving early in the morning when there's no public transportation
72	Travel scolarships	Travel expenses WM-NEPAL				80		Euro	Visa Fee and bus to/from the airport in Milan
73	Travel scolarships	Travel expenses WIKI PROJECT MED 1°				238,19		Euro	Train Jena-Berlin/train Juelich-Milan/plane Milan-Berlin/public transportation
74	Travel scolarships	Travel expenses WM-ES	1 plane ticket	1 ticket		119,98		Euro	Plane Madrid-Milan and way back
75	Travel scolarships	Travel expenses WM-PT	1 plane ticket	1 ticket		140		Euro	Plane Copenaghen-Milan and way back. (Payment currency Danish kroner: 1.037,56).
76	Travel scolarships	Travel expenses WM-SK				93		Euro	Bus Brno-Milan / Plane Bergamo-Bratislava
77	Travel scolarships	Travel expenses WM-HK 1°				760		Euro	Flight to Europe (Hong Kong-Amsterdam/Amsterdam-London/Amsterdam-Hong Kong)
78	Travel scolarships	Travel expenses WM-HK 2°				760		Euro	Flight to Europe (Hong Kong-Amsterdam/Amsterdam-London/Amsterdam-Hong Kong)
79	Travel scolarships	Travel expenses WM-CZ	1 plane ticket	1 ticket		87		Euro	Plane Prague-Milan and way back (Payment currency Rep Ceca Krone: CZK 2286)
80	Travel scolarships	Travel expenses WM-AM 1°				467		Euro	Plane Yerevan-Milan and way back / Visa Fee
81	Travel scolarships	Travel expenses WM-AM 2°				524,31		Euro	Plane Yerevan-Rome-Yerevan / train Rome-Milan / Visa Fee
82	Travel scolarships	Travel expenses WM-ID				266,61		Euro	Plane ticket Amsterdam-Milan (way around) / Train ticket The Hague-Schphol (way around)
83	Travel scolarships	Travel expenses WM-NL				217,67		Euro	Plane ticket Amsterdam-Milan (way around) / Train ticket Den Haag-Schphol (way around)
84	Travel scolarships	Travel expenses WM-US-NYC				898,59		Euro	Plane ticket New york-Milan (way around) / Accomodation in hostel (private room - 6 nights - €27.5 per night). (Payment currency US-dollars).
85	Travel scolarships	Travel expenses WIKI PROJECT MED 2°	1 Flight ticket	1		926,47		Euro	Plane ticket Atlanta-Milan round trip. (Payment currency US-dollars).
86	Travel scolarships	Travel expenses WM-CAT	1 Flight ticket	2		73,10		Euro	Plane ticket Barcelona-Milan / Milan-Barcelona
87	Travel scolarships	Travel expenses WM-US-DC	1 Flight ticket	1		945,31		Euro	Plane ticket Washington DC-Milan (round trip). (Payment currency US-dollars: $1.236).
88	Travel scolarships	Travel expenses WM-TW	1 Flight ticket	1		1.485,65		Euro	Plane ticket Taipei-Milan (round trip). (Payment currency NTD: 44.285).
89	Travel scolarships	Travel expenses WM-CL 1°	1 Flight ticket	2		1.410,29		Euro	Plane ticket Santiago-London (round trip) / Plane London-Rome(Payment currency US-dollars: 1.845,68).
90	Travel scolarships	Travel expenses WM-CL 2°	1 Flight ticket	1		1.549,83		Euro	Plane ticket Santiago-Milan(round trip). (Payment currency US-dollars: 2.028,29).
91	Travel scolarships	Travel expenses WM-FI	1 Flight ticket	1		274,80		Euro	Plane ticket Helsinki-Milan(round trip).
92	Travel scolarships	Travel expenses WM-PH	1 Flight ticket	1		1.245,84		Euro	Plane ticket Manila-Milan(round trip).
93	Travel scolarships	Travel expenses WM-DK				429,24		Euro	Train Copenhaghen-Basel / Train Basel-Milan / Plane Milan-Copenhaghen. (Payment currency Danish kroner: 3.002,35).
94	Travel scolarships	Travel expenses WM-HU				68		Euro	Plane Budapest-Milan (round trip). (Payment currency HUF: 29.480)
	Travel scolarships	Total expenditure Travel scholarships	1 travel scholarship	41		24,813.90	20.000,00	Euro	The budgeted amount was calculated on 25 travel scholarships.
95	Staff and Project Manager	Total expenditure Project Manager				16,693.61	13.000,00	Euro

Refunds from self paying organizations

Number	Category	Item description	Unit	Number of units	Actual cost per unit	Actual total	Budgeted total	Currency	Notes
97	Lodging refund from delegates	Accomodation VIKIDIA (WM-FR) - 1 delegate (3 nights – hostel dorm)	1 night	3 nights	30	90		Euro	Ostello Bello
98	Lodging refund from delegates	Accomodation WIKIMEDIA ARMENIA - 1 delegate (6 nights – single room)	1 night	6 nights	60	360		Euro	Hotel Monopole
99	Lodging refund from delegates	Accomodation WIKIMEDIA ÖSTERREICH - 2 delegates (6 nights total – single rooms)	1 night	6 nights	93	558		Euro	Hotel Romana Residence
100	Lodging refund from delegates	Accomodation WIKIMEDIA CANADA - 1 delegate (3 nights – hostel dorm)	1 night	3 nights	30 / 28	86		Euro	Ostello Bello
101	Lodging refund from delegates	Accomodation WIKIMEDIA POLSKA - 3 delegates (6 nights each – triple room)	1 night	6 nights	99	594		Euro	Hotel Monopole
102	Lodging refund from delegates	Accomodation WIKIMEDIA SERBIA - 3 delegates (5 nights each – hostel dorm)	1 night	5 nights	30	450		Euro	Ostello Bello
103	Lodging refund from delegates	Accomodation WIKIMEDIA RUSSIA 1° - 1 delegate (2 nights - hostel dorm)	1 night	2 nights	21	42		Euro	Monastery Hostel
104	Lodging refund from delegates	Accomodation WIKIMEDIA RUSSIA 2° - 1 delegate (2 nights – hostel dorm)	1 night	2 nights	25	50		Euro	Monastery Hostel
105	Lodging refund from delegates	Accomodation WIKIMEDIA UK - 2 delegates (4 nights – double room)	1 night	4 nights	71	284		Euro	Hotel Monopole
106	Lodging refund from delegates	Accomodation WIKIMEDIA SVERIGE 1° - 1 delegate (5 nights – single room)	1 night	5 nights	93	465		Euro	Hotel Romana Residence
107	Lodging refund from delegates	Accomodation WIKIMEDIA SVERIGE 2° - 1 delegate (3 nights – single room)	1 night	3 nights	63	189		Euro	Hotel Monopole
108	Lodging refund from delegates	Accomodation WIKIMEDIA SVERIGE 3° - 1 delegate (4 nights – single room)	1 night	4 nights	63	252		Euro	Hotel Monopole
109	Lodging refund from delegates	Accomodation WIKIMEDIA UK 1°- 1 delegate (3 nights – single room)	1 night	3 nights	93	279		Euro	Hotel Romana Residence
110	Lodging refund from delegates	Accomodation WIKIMEDIA UK 2°- 1 delegate (4 nights – single room)	1 night	4 nights	93	372		Euro	Hotel Romana Residence
111	Lodging refund from delegates	Accomodation WIKIMEDIA UK 3°- 1 delegate (4 nights – single room)	1 night	4 nights	93	372		Euro	Hotel Romana Residence
112	Lodging refund from delegates	Accomodation WIKIMEDIA ARGENTINA - 2 delegate (4 nights double room + 1 night 1 delegate single room)	1 night	5 nights	71 double room / 63 single room	347		Euro	Hotel Monopole
113	Lodging refund from delegates	Accomodation WIKIMEDIA ÖSTERREICH - 1 delegate (4 nights - single room)	1 night	4 nights	93	372		Euro	Hotel Romana Residence
114	Lodging refund from delegates	Accomodation WIKIMEDIA EESTI- 2 delegate (5 nights each - single rooms)	1 night	5 nights	63	630		Euro	Hotel Monopole
115	Lodging refund from delegates	Accomodation WIKIMEDIA NEDERLAND- 3 delegate (4 nights each - single rooms)	1 night	4 nights	93	1.116		Euro	Hotel Romana Residence
116	Lodging refund from delegates	Accomodation WIKIMEDIA HUNGARY- 1 delegate (3 nights - single rooms)	1 night	3 nights	63	189		Euro	Hotel Monopole
117	Lodging refund from delegates	Accomodation WIKIMEDIA FRANCE- 2 delegate (4 and 5 nights - single room)	1 night	4 nights / 5 nights	129	1.161		Euro	Hotel Romana Residence
118	Travel refund from delegates	WIKIMEDIA UK - refund half flight - 1 delegate WIKIMEDIA IN	1 flight	1 flight	708,05	708,05		Euro	One way ticket Mumbai - London
	Total refunds					8.966,05		Euro

Final balance

Number	Category	Item description	Unit	Number of units	Actual cost per unit	Actual total	Budgeted total	Currency	Notes
1	Welcome Event	Welcome cocktail/dinner at Frida's Club				1.200	5.000	Euro	Approx 80 attendants
2	Party	Social Dinner at Carlberg's Pizzeria				2.266	12.100	Euro	Approx 90 attendants
	Venue + catering + WiFi	Total expenditure Grand Visconti Palace Hotel				54.584,60	67.744,20	Euro
	Stationery, Computer rental, Electronics & other	Total Expenditure stationery and others				2.048,22	600	Euro
30	Local transport expenses	Carnet ATM 10 tube/bus travels each	1 carnet	136	13,80	1,876.80	3.450	Euro	Bought 160
	Facilitators	Total facilitators expenditure				2.256,5	10.000	Euro
	Lodging Expenses Volunteers and Delegates (scholarship)	Total expenditure for lodging volunteers and scholarships				14.949	12.000	Euro
	Travel scolarships	Total expenditure Travel scholarships	1 travel scholarship	41		24,813.90	20.000,00	Euro	The budgeted amount was calculated on 25 travel scholarships.
95	Staff and Project Manager	Total expenditure Project Manager				16,693.61	13.000,00	Euro
	Global Project Expenses					121.292.54		Euro
	Final Project Expenses					112.326,49	146.394,20	Euro	Global expenses less Refunds

• Global project expenses : € 121.292,54
• Refunds: € 8.966,05

• Final project expenses (Global expenses - Refunds) : € 112.326,49

• WMIT contribution: € 15.000
• WMF Grant: € 90.000
• WMDE contribution: € 30.000

• Grant + WMDE contribution used € 97.326,49

• Soldi avanzati € 22.673,51