Jump to content

Grants talk:APG/Proposals/2015-2016 round1/Wikimedia Deutschland e.V./Progress report form

Add topic
From Meta, a Wikimedia project coordination wiki
Latest comment: 7 years ago by Delphine (WMF)

Christof Pins (WMDE) Bericht erhalten ;). report well received. Thanks! Delphine (WMF) (talk) 12:43, 26 July 2016 (UTC)Reply

Correction

[edit]

In the process of writing our APG Proposal 16-17 we discovered a few errors in one of our finance tables included in the APG Progress Report 15-16. Please see below for details:

Green figures: Added budgeted figures missing from and/or miscalculated in the original table.
Pink figures: Corrected budgeted figures due to miscalculation in original table. Budgeted administrative expenses listed under APG-expenses for Wikidata had not been deducted from general administration expenses. This did not, however, affect the budgeted total expenses (EUR) and does not reflect any changes in actual spending.

Table 2: WMDE Expenses 2016, Budgeted vs. Actual

Wikimedia Deutschland: Expenses 2016, Budgeted vs. Actual

Total in EUR Total in USD
Budgeted Actual Budgeted Actual
APG Expenses Nonpersonnel Cost Personnel Cost Total Nonpersonnel Cost Personnel Cost Total Nonpersonnel Cost Personnel Cost Total Nonpersonnel Cost Personnel Cost Total Percentage of Budget Spent Explanation of Variances from Plan
Focal Point 1.2: Software Development for the Movement
Program Costs
ArticlePlaceholder 5,500 € 57,034 € 62,534 € 2,576 € 29,816 € 32,392 € $ 6,170 $ 63,980 $ 70,150 $ 2,890 $ 33,448 $ 36,337 52%
Automated list generation 14,000 € 112,674 € 126,674 € 7,526 € - 7,526 € $ 15,705 $ 126,397 $ 142,102 $ 8,442 - $ 8,442 6% In preparation. Activity has not started yet.
Structured data support for Wikimedia sister projects 58,000 € 324,334 € 382,334 € 11,741 € 107,026 € 118,766 € $ 65,064 $ 363,835 $ 428,898 $ 13,170 $ 120,060 $ 133,231 31%
Unit convertion 12,000 € 78,507 € 90,507 € 414 € - 414 € $ 13,461 $ 88,068 $ 101,530 $ 464 - $ 464 0% In preparation. Activity has not started yet.
Partnerships for Wikidata and foster collaboration in Open Data 12,000 € 62,596 € 74,596 € 156 € 30,912 € 31,068 € $ 13,461 $ 70,220 $ 83,681 $ 175 $ 34,677 $ 34,852 42%
Continued Mentoring Program Volunteers 26,000 € 43,370 € 69,370 € 7,572 € 11,193 € 18,765 € $ 29,167 $ 48,652 $ 77,819 $ 8,494 $ 12,556 $ 21,050 27%
New datatypes and improvements to existing ones 5,000 € 78,298 € 83,298 € 3,479 € 60,740 € 64,219 € $ 5,609 $ 87,834 $ 93,443 $ 3,902 $ 68,138 $ 72,040 77%
Continue to evolve the user interface 10,000 € 79,633 € 89,633 € 4,348 € 48,261 € 52,609 € $ 11,218 $ 89,332 $ 100,549 $ 4,878 $ 54,138 $ 59,016 59%
Agile development of community requests from the technical wishlist 9,500 € 263,176 € 272,676 € 791 € 94,610 € 95,401 € $ 10,657 $ 295,228 $ 305,885 $ 887 $ 106,133 $ 107,020 35%
Cooperation with the Community Tech Team (WMF) 3,500 € 42,942 € 46,442 € 248 € 12,676 € 12,924 € $ 3,926 $ 48,172 $ 52,098 $ 278 $ 14,219 $ 14,497 28%
Hacking on international technical requests 13,500 € 81,001 € 94,501 € 3,280 € 9,548 € 12,828 € $ 15,144 $ 90,866 $ 106,010 $ 3,679 $ 10,711 $ 14,390 14%
Events SD & E 10,000 € 45,919 € 55,919 € 6,294 € 2,597 € 8,891 € $ 11,218 $ 51,511 $ 62,729 $ 7,061 $ 2,913 $ 9,974 16%
User specific workshops SD&E communites 5,000 € 17,012 € 22,012 € - 326 € 326 € $ 5,609 $ 19,084 $ 24,693 - $ 366 $ 366 1% In preparation. Activity has not started yet.
Subtotal 184,000 € 1,286,496 € 1,470,496 € 48,424 € 407,705 € 456,129 € $ 206,409 $ 1,443,178 $ 1,649,588 $ 54,321 $ 457,359 $ 511,680 31% Low personnel and non-personnel expenses due to postponed hiring of staff and cancelling of contractors for positions which were initially planned. Some of these vacant positions have already been filled by the end of Q2.
Management, Coordination and Developer Capacity 7,000 € 112,778 € 119,778 € - 60,139 € 60,139 € $ 7,853 $ 126,513 $ 134,366 - $ 67,464 $ 67,464 50%
Subtotal 191,000 € 1,399,274 € 1,590,274 € 48,424 € 467,844 € 516,268 € $ 214,262 $ 1,569,692 $ 1,783,953 $ 54,321 $ 524,823 $ 579,144 32%
Administrative Overhead 53,851 € 394,518 € 448,370 € 13,559 € 130,996 € 144,555 € $ 60,410 $ 442,567 $ 502,977 $ 15,210 $ 146,950 $ 162,160 32%
Total APG Expenses 244,851 € 1,793,792 € 2,038,644 € 61,982 € 598,841 € 660,823 € $ 274,672 $ 2,012,258 $ 2,286,930 $ 69,531 $ 671,773 $ 741,304 32%
Non-APG Expenses
Priority Level 1
1.1: Attract and retain new volunteers for Wikimedia projects 186,000 € 266,767 € 452,767 € 81,746 € 114,630 € 196,376 € $ 208,653 $ 299,257 $ 507,909 $ 91,702 $ 128,591 $ 220,293 43%
1.3: Strengthen political and legal work aimed at promoting free knowledge 144,500 € 252,467 € 396,967 € 24,286 € 65,599 € 89,885 € $ 162,099 $ 283,215 $ 445,314 $ 27,244 $ 73,588 $ 100,832 23%
Subtotal 330,500 € 519,234 € 849,734 € 106,032 € 180,229 € 286,261 € $ 370,752 $ 582,472 $ 953,223 $ 118,946 $ 202,179 $ 321,125 34%
Priority Level 2
2.1: Improve relationship between WMDE and volunteers 320,000 € 100,000 € 420,000 € 94,947 € 82,505 € 177,452 € $ 358,973 $ 112,179 $ 471,152 $ 106,511 $ 92,553 $ 199,064 42%
2.2: Recruit educational, scientific, and cultural institutions for flagship projects 40,000 € 73,000 € 113,000 € 717 € 46,051 € 46,768 € $ 44,872 $ 81,891 $ 126,762 $ 804 $ 51,660 $ 52,464 41%
2.3: Improve the conditions for free knowledge through OER practice and policy 48,000 € 132,000 € 180,000 € 118,390 € 64,965 € 183,355 € $ 53,846 $ 148,076 $ 201,922 $ 132,809 $ 72,877 $ 205,686 102% Nonpersonnel expenses for Mapping OER were much higher than planned, partly due to expenses planned for 2015 but realised in 2016. All of these expenses have been fully reimbursed through the grantmaker.
2.4: Define and consolidate WMDE’s position within the international movement 172,896 € 157,482 € 330,378 € 97,925 € 83,955 € 181,880 € $ 193,953 $ 176,662 $ 370,615 $ 109,851 $ 94,180 $ 204,031 55%
Subtotal 580,896 € 462,482 € 1,043,378 € 311,979 € 277,476 € 589,455 € $ 651,643 $ 518,808 $ 1,170,451 $ 349,975 $ 311,270 $ 661,245 56%
Priority Level 3
3.1: Regionalization of volunteer structures: continue and analyze 65,000 € 10,000 € 75,000 € 35,073 € 4,101 € 39,174 € $ 72,916 $ 11,218 $ 84,134 $ 39,345 $ 4,600 $ 43,945 52%
3.2: Involvement of volunteers - 62,000 € 62,000 € 292 € 1,602 € 1,894 € - $ 69,551 $ 69,551 $ 328 $ 1,797 $ 2,125 3% Staff resources shifted to focal point 1.1: Attract and retain new volunteers for the Wikimedia movement. Some activities were cancelled.
3.3: Clarification of WMDE identity and strategy 5,403 € 108,933 € 114,336 € 395 € 33,567 € 33,962 € $ 6,061 $ 122,200 $ 128,261 $ 443 $ 37,655 $ 38,098 30%
Subtotal 70,403 € 180,933 € 251,336 € 35,760 € 39,270 € 75,030 € $ 78,977 $ 202,969 $ 281,946 $ 40,115 $ 44,053 $ 84,168 30%
Total Non-APG Expenses 981,799 € 1,162,649 € 2,144,448 € 453,771 € 496,975 € 950,746 € $ 1,101,372 $ 1,304,248 $ 2,405,620 $ 509,036 $ 557,502 $ 1,066,537 44%
Other Program/Program Support Expenses

(Remaining Expenses not included in Focal Points)

Education, Science and Culture 20,000 € 17,815 € 37,815 € 860 € 7,817 € 8,677 € $ 22,436 $ 19,985 $ 42,420 $ 964 $ 8,769 $ 9,734 23%
Volunteer Support 65,000 € 35,219 € 100,219 € 1,356 € 1,927 € 3,283 € $ 72,916 $ 39,508 $ 112,425 $ 1,522 $ 2,162 $ 3,683 3% Program costs were shifted to focal point 2.1: Improve relationship between WMDE and volunteers.
Software Development 16,624 € 125,284 € 141,908 € 5,869 € 107,682 € 113,551 € $ 18,649 $ 140,542 $ 159,191 $ 6,584 $ 120,796 $ 127,381 80% Additional personnel expenses due to increased support for the Fundraising department.
Communications 54,469 € 76,405 € 130,874 € 11,936 € 22,362 € 34,298 € $ 61,103 $ 85,710 $ 146,813 $ 13,389 $ 25,085 $ 38,475 26%
Event Management 10,000 € 121,590 € 131,590 € 4,889 € 59,744 € 64,633 € $ 11,218 $ 136,398 $ 147,616 $ 5,484 $ 67,020 $ 72,504 49%
Partnerships and Development 58,500 € 1,801 € 60,301 € - 30,596 € 30,596 € $ 65,625 $ 2,020 $ 67,645 - $ 34,322 $ 34,322 51%
Total Other Program/Program Support Expenses 224,593 € 378,114 € 602,707 € 24,910 € 230,128 € 255,038 € $ 251,946 $ 424,165 $ 676,111 $ 27,944 $ 258,155 $ 286,099 42%
Administration Expenses

(incl. Indirect Program Expenses)

Office of the CEO, Board of Directors 161,694 € 167,791 € 329,487 € 27,644 € 67,369 € 95,012 € $ 181,387 $ 188,226 $ 369,613 $ 31,010 $ 75,573 $ 106,584 29%
Finance 27,432 € 45,525 € 72,957 € 17,001 € 24,611 € 41,612 € $ 30,773 $ 51,069 $ 81,842 $ 19,072 $ 27,609 $ 46,680 57%
IT 169,710 € 59,839 € 229,549 € 73,271 € 27,350 € 100,621 € $ 190,379 $ 67,127 $ 257,506 $ 82,195 $ 30,681 $ 112,876 44%
Operations (Office, HR, Works Council) 529,289 € 138,576 € 667,865 € 228,036 € 59,020 € 287,056 € $ 593,751 $ 155,453 $ 749,204 $ 255,808 $ 66,208 $ 322,016 43%
Total Administration Expenses 888,125 € 411,731 € 1,299,856 € 345,951 € 178,350 € 524,302 € $ 996,290 $ 461,876 $ 1,458,165 $ 388,085 $ 200,072 $ 588,156 40%
Total Expenses

(Program and Associated Expenses)

2,339,368 € 3,746,286 € 6,085,655 € 886,614 € 1,504,294 € 2,390,908 € $ 2,624,280 $ 4,202,547 $ 6,826,827 $ 994,595 $ 1,687,502 $ 2,682,097 39%
Operating reserves 114,940 € - 114,940 € - - - $ 128,939 - $ 128,939 - - - 0%
Total Expenses including Operating Reserves 2,454,308 € 3,746,286 € 6,200,595 € 886,614 € 1,504,294 € 2,390,908 € $ 2,753,219 $ 4,202,547 $ 6,955,765 $ 994,595 $ 1,687,502 $ 2,682,097 39%

Notes to changes made on Oct. 18, 2016:
Green figures: Added budgeted figures missing from and/or miscalculated in the original table.
Pink figures: Corrected budgeted figures due to miscalculation in original table. Budgeted administrative expenses listed under APG-expenses for Wikidata had not been deducted from general administration expenses. This did not, however, affect the budgeted total expenses (EUR) and does not reflect any changes in actual spending.