Difference between revisions of "SAC:Budget"

From OSGeo
Jump to navigation Jump to search
 
(114 intermediate revisions by 5 users not shown)
Line 1: Line 1:
 
Please help fill in the based on this [https://drive.google.com/open?id=0ByfEHeRRT620SnliNDhJT25HTms pdf report] from the treasurer.
 
Please help fill in the based on this [https://drive.google.com/open?id=0ByfEHeRRT620SnliNDhJT25HTms pdf report] from the treasurer.
 
Budget allocations can be found via general budget pages on the wiki.
 
Budget allocations can be found via general budget pages on the wiki.
 +
 +
== 2024 ==
 +
 +
'''''[[OSGeo_Budget_2024]]'''''
 +
{| class="wikitable sortable"
 +
|-
 +
! Item !! Amount(Proposed)[Approved] !! Amount(Spent) !!Notes
 +
|-
 +
| Budget || 51950 [21500] || 0 || Total Requested
 +
|-
 +
| Hosting || 6,500 [0] || 0 ||OSUOSL for hosting services $6500
 +
|-
 +
| Wordpress ACF Pro Plugin || 150[0] || 0 || https://www.advancedcustomfields.com/pro/?utm_source=ACF+PRO (needed for both prod and dev)
 +
|-
 +
|  Limesurvey || 100 [0] || 0 || ComfUpdate payment
 +
|-
 +
| Hardware Supplies || 2,500 [0] || 0 || Emergency reserve for replacing parts as needed (drives, power supplies etc) and new hard drives, but not planned any change
 +
|-
 +
| Donations open source infra projects || 4,000 [0] || 0 || See https://wiki.osgeo.org/wiki/SAC:Budget#Donations_open_source_infra_projects
 +
|-
 +
| Domains || 300 [0] ||0  || Renewals, expect 5 domains (~$15 x 5 years each)
 +
|-
 +
| Sysadmin || 38,400 [0] || 0  || Specific or General support contracts. Can be used in any hours desired and rate/hr, to be approved by SAC PSC. Key items for this year: Upgrade LDAP, Osgeo6, OSGeo7, secure, pretalx, wiki, matrix, mail system, migrate mailing lists to discourse, standardize infra on ansible, update documentation on our system setup
 +
 +
|}
 +
 +
=== Donations open source infra projects ===
 +
{| class="wikitable sortable"
 +
|-
 +
! Item !! Amount(Proposed)[Approved] !! Amount(Spent) !!Notes
 +
|-
 +
|  Pretalx || 500 [0] || 0 ||
 +
|-
 +
|  weblate || 500 [0] || 0 ||
 +
|-
 +
|  Matrix || 500 [0] || 0 ||
 +
|-
 +
|  LiberaChat || 500 [0] || 0 ||
 +
|-
 +
|  Trac || 500 [0] || 0 ||
 +
|-
 +
|  gitea || 500 [0] || 0 ||
 +
|-
 +
|  LXD/Incus (main contributor) || 500 [0] || 0 ||
 +
|-
 +
|  jitsi || 500 [0] || 0 ||
 +
|}
 +
 +
=== SysAmin contracts ===
 +
{| class="wikitable sortable"
 +
|-
 +
! Name !! Hours !! Amount(Proposed)[Approved] !! Amount(Spent) !!Notes
 +
|-
 +
|  Regina || 100  [50] || 12800 [6400] ||  || Upgrades: wiki (major upgrade, our version is EOL), pretalx (major upgrade flip to postgres, new preferred db), osgeo7, osgeo6, ldap (this is a major upgrade since requires db upgrade); Other upgrades as needed; General support
 +
|-
 +
|  Sandro || 100 [50] || 12800 [6400] || || Upgrade mail (major upgrade to be used by mailman and discourse), matrix (newer clients will not be able to use soon without upgrade); ansible standardization; General support
 +
|-
 +
|  Vicky || 100 [50] || 12800 [6400] ||  || Discourse migration and mirroring, website/wordpress, ansible standardization, nginx, General support
 +
|}
 +
 +
== 2023 ==
 +
 +
'''''[[OSGeo_Budget_2023| Submitted to Board]]'''''
 +
{| class="wikitable sortable"
 +
|-
 +
! Item !! Amount(Proposed)[Approved] !! Amount(Spent) !!Notes
 +
|-
 +
| Budget || 32550 [32550] || ? || Total Requested
 +
|-
 +
| Hosting || 6000 [6000] || ? || Donation to OSUOSL for hosting services $6000
 +
|-
 +
| Hardware Supplies || 2,500 [0] || 0 ||Reserve for replacing parts as needed (drives, power supplies etc)
 +
|-
 +
| Cloud Hosting || 1,000 [1000] || 0 || Fund for utilizing 3rd party cloud services
 +
|-
 +
| Donations open source infra projects || 4,000 [4000] || $2582? || Given: Pretalx, weblate, Matrix, LiberaChat, Limesurvey, Trac, gitea, incus/lxd (main contributor), LimeSurvey Comfupdate ($82)
 +
|-
 +
| Domains || 300 [300] || 136  || Renewals, expect 3 domains (~$15 x 5 years each)
 +
|-
 +
| Sysadmin || 18750 [18750] || ~$18592 || 150 hours, ~3x 50 hour  general support contracts  (~6250 USD each)
 +
 +
|}
 +
 +
 +
=== Donations open source infra projects ===
 +
{| class="wikitable sortable"
 +
|-
 +
! Item !! Amount(Proposed)[Approved] !! Amount(Spent) !!Notes
 +
|-
 +
|  Pretalx || 500  || 500 ||
 +
|-
 +
|  weblate || 500  || 500 ||
 +
|-
 +
|  Matrix || 500 || 0 ||
 +
|-
 +
|  LiberaChat || 500  || 500 ||
 +
|-
 +
|  Trac || 500 || ? ||
 +
|-
 +
|  gitea || 500 [0] || ? ||
 +
|-
 +
|  LXD/Incus (main contributor) || 500 [0] || 500 ||
 +
|-
 +
|  jitsi || 500 [0] || ? ||
 +
|-
 +
|  Limesurvey || 82 || 82 ||
 +
|}
 +
 +
== 2022 ==
 +
 +
'''''[[OSGeo_Budget_2022| Submitted to Board]]'''''
 +
{| class="wikitable sortable"
 +
|-
 +
! Item !! Amount(Proposed)[Approved] !! Amount(Spent) !!Notes
 +
|-
 +
| Budget || 32550 [32,550] || 26905.32 || Total Requested
 +
|-
 +
| Hosting || 5000 [5000] || 5000 || Donation to OSUOSL for hosting services $5000
 +
|-
 +
| Hardware Supplies || 2,500 [2,500] || ~$526 || Drives for osgeo8 and osgeo9
 +
|-
 +
| Cloud Hosting || 2,000 [2,000] || 0 || Fund for utilizing 3rd party cloud services
 +
|-
 +
| Donations open source infra projects || 4,000 [4,000] || ~2582 USD || Currently dispensed: Pretalx , Weblate, Limesurvey (78 Euro) for comfort update tool), gitea, LiberaChat , Matrix.  Help keep software we use FOSS in particular projects with very few developers
 +
|-
 +
| Domains || 300 [300] || 22.65 + 377.5 + 22.65 = 422.80 || Renewals, expect 3 domains (~$15 x 5 years each)
 +
|-
 +
| Sysadmin || 18750 [18750] || 5975 + 6200 + 1891 + 1891 + 1580 + 713 + 124 ($18374)  || 150 hours, ~3x 50 hour  general support contracts  (~6250 USD each)
 +
 +
|}
 +
 +
== 2021 ==
 +
 +
'''''[[OSGeo_Budget_2021| Submitted to Board]]''''' - [[http://osgeo-org.1560.x6.nabble.com/SAC-2021-Budget-Vote-td5454922.html vote]]
 +
{| class="wikitable sortable"
 +
|-
 +
! Item !! Amount(Proposed)[Approved] !! Amount(Spent) !!Notes
 +
|-
 +
| Budget || 35100 [30,700] || 0 || Total Requested - New amount is $31600 + (with $3500 carried from 2020 contract - see below)
 +
|-
 +
| Hosting || 4,600 || 0 || Donation to OSUOSL for hosting services $4600
 +
|-
 +
| Hardware Supplies || 1,000 || 0 ||Reserve for replacing parts as needed (drives, power supplies etc)
 +
|-
 +
| Cloud Hosting || 6,000 || 0 || Fund for utilizing 3rd party cloud services as needed includes Travis ($5000) + $1000 set aside for others
 +
|-
 +
| Domains || 300 || 0  || Renewals, expect 3 domains (~$15 x 5 years each), expect a few transfers from Eclipse Foundation.
 +
|-
 +
| Sysadmin || 13200 [8800] || 0 || 120 hours, ~3x 40 hour general support contracts (~4400 USD each)
 +
|-
 +
| Wiki LDAP Completion || $6,500 || $8050 || Contract to complete migration Wiki logins to LDAP, OSGeo single sign on. This amount is the maximum, it could cost less based on actual hours required to complete.
 +
|-
 +
| Wiki LDAP ||  $3,500 || $3,500 || Existing contract commitment from 2020.
 +
|}
 +
 +
 +
* Regina - I think funtoo we should discontinue because we only had limesurvey on there and I have since moved that to osgeo3. We will be using more OSUOSL resources for the osgeo8 and osgeo9 so that $600 saved on funtoo should be allocated to OSUOSL to compensate for the extra rackspace and support we'll need.
 +
* Alex - Wiki LDAP project was split for easier accounting and the need to carry an already contracted amount over. Compromise in terms of total support hours, +20 from 100 hours in light of budget constraints, and the ongoing Wiki LDAP project costs. We only spent 100 hours last year, the remaining being spent on the Wiki LDAP project. On mailing list somewhere between 2-4 contracts was suggested 100-200 hours.
 +
* Jody - isolated prior commitment into a distinct line, board does not hold over budget annually so I wanted to phrase this as a existing contract commitment.
 +
 +
== 2020 ==
 +
 +
{| class="wikitable sortable"
 +
|-
 +
! Item !! Amount(Proposed)[Approved] !! Amount(Spent) !!Notes
 +
|-
 +
| Budget || 28350 || ~12632 || Total Requested
 +
|-
 +
| Hosting || 4,600 || ? || Donation to OSUOSL for hosting services $4000, $500 to funtoo (as monthly payments of $50/mth).
 +
|-
 +
| Hardware Supplies || 1,000 || 742 ||Reserve for replacing parts as needed (drives, power supplies etc)
 +
|-
 +
| Cloud Hosting || 6,000 || ? || Fund for utilizing 3rd party cloud services as needed includes Travis ($5000) + $1000 set aside for others
 +
|-
 +
| Domains || 250 || 390 || Renewals and new ones: postgis.net, gdal.org, proj.org, geotools.org, mapserver.org
 +
|-
 +
| Sysadmin || 16500 || 16500[Contracted, ~$11,500 spent] || 3x 50 hour support contracts (~5500 USD each), 1 for Wiki/LDAP, 2 for general support/upgrade
 +
|}
  
 
== 2019 ==
 
== 2019 ==
 
{| class="wikitable sortable"
 
{| class="wikitable sortable"
 
|-
 
|-
−
! Item !! Amount(Proposed) !! Amount !!Notes
+
! Item !! Amount(Proposed)[Approved] !! Amount(Spent) !!Notes
 
|-
 
|-
−
| Budget || || || Total Requested and Approved
+
| Budget || 23750 || 15351.72 || Total Requested and Approved
 
|-
 
|-
−
| Hosting || 2,000 || || Donation to OSUOSL for hosting services
+
| Hosting || 5,000 || $4000+6*50?/month || Donation to OSUOSL for hosting services $4000, to make up for last year, $1000 to funtoo (as monthly payments of $50).
 
|-
 
|-
−
| Hardware Supplies || 1,000 || ||Reserve for replacing parts as needed (drives, power supplies etc)
+
| Hardware Supplies || 1,000 || 776 ||Reserve for replacing parts as needed (drives, power supplies etc)
 
|-
 
|-
 
| Cloud Hosting || 1,000 || || Fund for utilizing 3rd party cloud services as needed  
 
| Cloud Hosting || 1,000 || || Fund for utilizing 3rd party cloud services as needed  
 
|-
 
|-
−
| Domains || 250 ||  || Renewals and new ones
+
| Domains || 250 || 275.72 (65+56+24.72+65+65) || Renewals and new ones: postgis.net, gdal.org, proj.org, geotools.org, mapserver.org
 
|-
 
|-
−
| Sysadmin || ? || ?x 50 hour support contracts
+
| Sysadmin || 16500? || 10000 || 3x 50 hour support contracts (~5500 USD each), at least 1 for wordpress, 1 for wiki LDAP migration, and 1 for general server support.
 
|}
 
|}
  
Line 23: Line 201:
 
{| class="wikitable sortable"
 
{| class="wikitable sortable"
 
|-
 
|-
−
! Item !! Amount(Proposed) !! Amount !!Notes
+
! Item !! Amount(Proposed)[Approved] !! Amount(Spent) !!Notes
 
|-
 
|-
−
| Budget || 20,250 || 20,000 ||
+
| Budget || 20,250[20,000] || 10201 ||
 
|-
 
|-
−
| Hosting || 2,000 || || Donation to OSUOSL for hosting services
+
| Hosting || 2,000 || 0 || Donation to OSUOSL for hosting services - Was held up waiting for board to add more funds.
 
|-
 
|-
−
| OSGeo7 || 6,000 || ||New machine to replace OSGeo3. Was budgeted last year but not spent/purchased due to logistics.
+
| OSGeo7 || 6,000 || 7,221 ||New machine to replace OSGeo3. Was budgeted last year but not spent/purchased due to logistics.
 
|-
 
|-
−
| Cloud Hosting || 1,000 || ||Fund for utilizing 3rd party cloud services as needed  
+
| Cloud Hosting || 1,000 || Travis?? ||Fund for utilizing 3rd party cloud services as needed  
 
|-
 
|-
−
| Domains || 250 || 140 (Apr19) || Renewals and new ones ($65+$56+$19)
+
| Domains || 250 || 230 || Renewals and new ones (65+56+19+45+45)
 
|-
 
|-
−
| Sysadmin || 11,000 || 2x 50 hour support contracts
+
| Sysadmin || 11,000 || ~2,750 || 2x 50 hour support contracts
 
|}
 
|}
  
Line 186: Line 364:
 
| Domains || ? ||  
 
| Domains || ? ||  
 
|}
 
|}
 +
 +
[[Category:Budget]]
 +
[[Category:Infrastructure]]

Latest revision as of 08:52, 8 March 2024

Please help fill in the based on this pdf report from the treasurer. Budget allocations can be found via general budget pages on the wiki.

2024

OSGeo_Budget_2024

Item Amount(Proposed)[Approved] Amount(Spent) Notes
Budget 51950 [21500] 0 Total Requested
Hosting 6,500 [0] 0 OSUOSL for hosting services $6500
Wordpress ACF Pro Plugin 150[0] 0 https://www.advancedcustomfields.com/pro/?utm_source=ACF+PRO (needed for both prod and dev)
Limesurvey 100 [0] 0 ComfUpdate payment
Hardware Supplies 2,500 [0] 0 Emergency reserve for replacing parts as needed (drives, power supplies etc) and new hard drives, but not planned any change
Donations open source infra projects 4,000 [0] 0 See https://wiki.osgeo.org/wiki/SAC:Budget#Donations_open_source_infra_projects
Domains 300 [0] 0 Renewals, expect 5 domains (~$15 x 5 years each)
Sysadmin 38,400 [0] 0 Specific or General support contracts. Can be used in any hours desired and rate/hr, to be approved by SAC PSC. Key items for this year: Upgrade LDAP, Osgeo6, OSGeo7, secure, pretalx, wiki, matrix, mail system, migrate mailing lists to discourse, standardize infra on ansible, update documentation on our system setup

Donations open source infra projects

Item Amount(Proposed)[Approved] Amount(Spent) Notes
Pretalx 500 [0] 0
weblate 500 [0] 0
Matrix 500 [0] 0
LiberaChat 500 [0] 0
Trac 500 [0] 0
gitea 500 [0] 0
LXD/Incus (main contributor) 500 [0] 0
jitsi 500 [0] 0

SysAmin contracts

Name Hours Amount(Proposed)[Approved] Amount(Spent) Notes
Regina 100 [50] 12800 [6400] Upgrades: wiki (major upgrade, our version is EOL), pretalx (major upgrade flip to postgres, new preferred db), osgeo7, osgeo6, ldap (this is a major upgrade since requires db upgrade); Other upgrades as needed; General support
Sandro 100 [50] 12800 [6400] Upgrade mail (major upgrade to be used by mailman and discourse), matrix (newer clients will not be able to use soon without upgrade); ansible standardization; General support
Vicky 100 [50] 12800 [6400] Discourse migration and mirroring, website/wordpress, ansible standardization, nginx, General support

2023

Submitted to Board

Item Amount(Proposed)[Approved] Amount(Spent) Notes
Budget 32550 [32550] ? Total Requested
Hosting 6000 [6000] ? Donation to OSUOSL for hosting services $6000
Hardware Supplies 2,500 [0] 0 Reserve for replacing parts as needed (drives, power supplies etc)
Cloud Hosting 1,000 [1000] 0 Fund for utilizing 3rd party cloud services
Donations open source infra projects 4,000 [4000] $2582? Given: Pretalx, weblate, Matrix, LiberaChat, Limesurvey, Trac, gitea, incus/lxd (main contributor), LimeSurvey Comfupdate ($82)
Domains 300 [300] 136 Renewals, expect 3 domains (~$15 x 5 years each)
Sysadmin 18750 [18750] ~$18592 150 hours, ~3x 50 hour general support contracts (~6250 USD each)


Donations open source infra projects

Item Amount(Proposed)[Approved] Amount(Spent) Notes
Pretalx 500 500
weblate 500 500
Matrix 500 0
LiberaChat 500 500
Trac 500 ?
gitea 500 [0] ?
LXD/Incus (main contributor) 500 [0] 500
jitsi 500 [0] ?
Limesurvey 82 82

2022

Submitted to Board

Item Amount(Proposed)[Approved] Amount(Spent) Notes
Budget 32550 [32,550] 26905.32 Total Requested
Hosting 5000 [5000] 5000 Donation to OSUOSL for hosting services $5000
Hardware Supplies 2,500 [2,500] ~$526 Drives for osgeo8 and osgeo9
Cloud Hosting 2,000 [2,000] 0 Fund for utilizing 3rd party cloud services
Donations open source infra projects 4,000 [4,000] ~2582 USD Currently dispensed: Pretalx , Weblate, Limesurvey (78 Euro) for comfort update tool), gitea, LiberaChat , Matrix. Help keep software we use FOSS in particular projects with very few developers
Domains 300 [300] 22.65 + 377.5 + 22.65 = 422.80 Renewals, expect 3 domains (~$15 x 5 years each)
Sysadmin 18750 [18750] 5975 + 6200 + 1891 + 1891 + 1580 + 713 + 124 ($18374) 150 hours, ~3x 50 hour general support contracts (~6250 USD each)

2021

Submitted to Board - [vote]

Item Amount(Proposed)[Approved] Amount(Spent) Notes
Budget 35100 [30,700] 0 Total Requested - New amount is $31600 + (with $3500 carried from 2020 contract - see below)
Hosting 4,600 0 Donation to OSUOSL for hosting services $4600
Hardware Supplies 1,000 0 Reserve for replacing parts as needed (drives, power supplies etc)
Cloud Hosting 6,000 0 Fund for utilizing 3rd party cloud services as needed includes Travis ($5000) + $1000 set aside for others
Domains 300 0 Renewals, expect 3 domains (~$15 x 5 years each), expect a few transfers from Eclipse Foundation.
Sysadmin 13200 [8800] 0 120 hours, ~3x 40 hour general support contracts (~4400 USD each)
Wiki LDAP Completion $6,500 $8050 Contract to complete migration Wiki logins to LDAP, OSGeo single sign on. This amount is the maximum, it could cost less based on actual hours required to complete.
Wiki LDAP $3,500 $3,500 Existing contract commitment from 2020.


  • Regina - I think funtoo we should discontinue because we only had limesurvey on there and I have since moved that to osgeo3. We will be using more OSUOSL resources for the osgeo8 and osgeo9 so that $600 saved on funtoo should be allocated to OSUOSL to compensate for the extra rackspace and support we'll need.
  • Alex - Wiki LDAP project was split for easier accounting and the need to carry an already contracted amount over. Compromise in terms of total support hours, +20 from 100 hours in light of budget constraints, and the ongoing Wiki LDAP project costs. We only spent 100 hours last year, the remaining being spent on the Wiki LDAP project. On mailing list somewhere between 2-4 contracts was suggested 100-200 hours.
  • Jody - isolated prior commitment into a distinct line, board does not hold over budget annually so I wanted to phrase this as a existing contract commitment.

2020

Item Amount(Proposed)[Approved] Amount(Spent) Notes
Budget 28350 ~12632 Total Requested
Hosting 4,600 ? Donation to OSUOSL for hosting services $4000, $500 to funtoo (as monthly payments of $50/mth).
Hardware Supplies 1,000 742 Reserve for replacing parts as needed (drives, power supplies etc)
Cloud Hosting 6,000 ? Fund for utilizing 3rd party cloud services as needed includes Travis ($5000) + $1000 set aside for others
Domains 250 390 Renewals and new ones: postgis.net, gdal.org, proj.org, geotools.org, mapserver.org
Sysadmin 16500 16500[Contracted, ~$11,500 spent] 3x 50 hour support contracts (~5500 USD each), 1 for Wiki/LDAP, 2 for general support/upgrade

2019

Item Amount(Proposed)[Approved] Amount(Spent) Notes
Budget 23750 15351.72 Total Requested and Approved
Hosting 5,000 $4000+6*50?/month Donation to OSUOSL for hosting services $4000, to make up for last year, $1000 to funtoo (as monthly payments of $50).
Hardware Supplies 1,000 776 Reserve for replacing parts as needed (drives, power supplies etc)
Cloud Hosting 1,000 Fund for utilizing 3rd party cloud services as needed
Domains 250 275.72 (65+56+24.72+65+65) Renewals and new ones: postgis.net, gdal.org, proj.org, geotools.org, mapserver.org
Sysadmin 16500? 10000 3x 50 hour support contracts (~5500 USD each), at least 1 for wordpress, 1 for wiki LDAP migration, and 1 for general server support.

2018

Item Amount(Proposed)[Approved] Amount(Spent) Notes
Budget 20,250[20,000] 10201
Hosting 2,000 0 Donation to OSUOSL for hosting services - Was held up waiting for board to add more funds.
OSGeo7 6,000 7,221 New machine to replace OSGeo3. Was budgeted last year but not spent/purchased due to logistics.
Cloud Hosting 1,000 Travis?? Fund for utilizing 3rd party cloud services as needed
Domains 250 230 Renewals and new ones (65+56+19+45+45)
Sysadmin 11,000 ~2,750 2x 50 hour support contracts

2017

Item Amount Notes
Budget 15,000 (+$3000 for new website if needed)
WebSite Hosting Transfer -384.03 GetInteractive
Cloud Hosting -100.00 34.95 Euro/month, estimated cost 2.5 months.
Sysadmin -5533.05 strk, 5000 EUR (USD approximate)

2016

Item Amount Notes
Budget 12,800
SSL Certs -744.51 3 yr.
Domains -195.97
Sysadmin -5200 strk, 5000 EUR (USD approximate)

2015

Item Amount Notes
Budget 8,700.00
OSGeo6 -5,580.82
Domains -214.00
CodeHaus Move Contract -800.00


2014

Item Amount Notes
Budget 12054
Hard Drive & PSU Replacement -245.06 3 yr.
PEER1 Hosting -1,903.73


2013

Item Amount Notes
Budget 12054
Backup Server -2,403.00
PEER 1 Hosting -1,204.51
OSUOSL Hosting (Donation) -3150.00

2012

Item Amount Notes
Budget 12600
PEER 1 Hosting -7,820.15

2011

Item Amount Notes
Budget ?
SSL Certs -1,499 5 yr. OV
PEER 1 Hosting -6,993.68

2010

Item Amount Notes
Budget 9900
OSGeo 3/4 -15,239.69
Domains -440.00
Peer Directed Projects Center / Freenode -77.00 Anyone remember what this was for?
PEER 1 Hosting -13,851.98
Perflect / PSD2HTML -533.00 Anyone remember what this was for?

2009

Item Amount Notes
Budget ?
SSL Certs ? 3 yr.
Domains ?


2008

Item Amount Notes
Budget ?
SSL Certs ? 3 yr.
Domains ?


2007

Item Amount Notes
Budget ?
SSL Certs ? 3 yr.
Domains ?
Retrieved from "http://wiki.osgeo.org/w/index.php?title=SAC:Budget&oldid=131681"