Grants talk:APG/Proposals/2015-2016 round1/Wikimedia Deutschland e.V./Progress report form
Add topicLatest comment: 8 years ago by Delphine (WMF)
Christof Pins (WMDE) Bericht erhalten ;). report well received. Thanks! Delphine (WMF) (talk) 12:43, 26 July 2016 (UTC)
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.