2025.01.09 Q2 Spending Report Summary — File 25-0023

FY25 Personnel Projected Costs Dept Org Munis Dept Description Personnel Ordinary Maintenance Personnel Expenses to date 12/17 Personnel % Used to Date Projected Surplus and/or Deficit Personnel Notes (Includes non-salary benefits) Requsitions Appropriated Budget 112 City Council $505,000 $89,910 113 City Clerk $44,526 121 Exec Admin $1,111,171 $163,650 122 Exec Somer $511,422 $60,900 123 AIM-CPM $863,848 124 Exec Arts Council $591,676 $274,125 125 Exec Constituent $1,351,074 $147,550 126 Exec OS $830,893 $363,325 127 HHS-COA $543,560 $250,268 128 HHS-SOMER $499,205 $315,500 129 IAM $687,279 $481,100 130 Exec Racial & Social Justice $910,854 $231,800 135 Auditing $1,349,303 $151,015 136 Grant Dev $301,054 $23,950 138 Procurement $679,505 $28,800 141 Board of Assessors $690,094 $274,650 145 Treasurer Collectors $783,274 $333,600 151 Law Department $942,082 $676,925 152 Human Resources $1,678,440 $602,510 155 Information Technology $1,385,858 $4,706,415 157 Communications $1,112,938 $273,943 158 Immigrant Affairs $1,371,031 $325,980 159 Peg Access $313,475 $94,930 161 City Clerk $1,098,752 $274,093 162 Elections $598,360 $175,048 165 Licensing $13,059 181 OSPCD- Planning $1,205,540 $270,980 182 OSPCD- Admin $687,279 $217,800 183 OSPCD- Housing $1,241,015 $258,900 184 Redevelopment Authority $23,076 185 OSPCD- Mobility $763,057 $395,000 $187,479 37.12% $521 $11,082 24.89% $0 $456,215 41.06% $128,553 $226,874 44.36% $22,770 $287,707 33.31% $244,172 $261,668 44.22% $28,083 $491,545 36.38% $292,361 $330,375 39.76% $119,315 $240,025 44.16% $26,583 $211,003 42.27% $44,737 $284,851 41.45% $73,755 $325,319 35.72% $210,167 $593,401 43.98% $71,209 $132,627 44.05% $15,395 $284,784 41.91% $66,124 $289,671 41.98% $66,188 $320,490 40.92% $92,989 $442,783 47.00% -$11,604 $644,873 38.42% $289,482 $521,405 37.62% $262,832 $418,850 37.63% $210,799 $535,271 39.04% $218,140 $129,181 41.21% $35,239 $436,573 39.73% $158,441 $324,232 54.19% -$99,986 $4,845 37.10% $2,624 $409,926 34.00% $322,622 $297,838 43.34% $45,783 $490,876 39.55% $183,744 $8,025 34.78% $5,791 $325,021 42.59% $63,013 Odd projected defecit; usually something that happened in begining of FY that will not happen in Q3 and Q4 Early voting, Heavy during the election season with poll workers wont happen in Q3 and Q4.

Dept Org Munis Dept Description Appropriated Budget 112 City Council 113 City Clerk 121 Exec Admin 122 Exec Somer 123 AIM-CPM 124 Exec Arts Council 125 Exec Constituent 126 Exec OS 127 HHS-COA 128 HHS-SOMER 129 IAM 130 Exec Racial & Social Justice 135 Auditing 136 Grant Dev 138 Procurement 141 Board of Assessors 145 Treasurer Collectors 151 Law Department 152 Human Resources 155 Information Technology 157 Communications 158 Immigrant Affairs 159 Peg Access 161 City Clerk 162 Elections 165 Licensing 181 OSPCD- Planning 182 OSPCD- Admin 183 OSPCD- Housing 184 Redevelopment Authority 185 OSPCD- Mobility Encumbrances Expenses 12/17 Req + Enc + Expenses Projected Surplus and/or Deficit Notes Questions FY25 Ordinary Maintenance Q2 $441 $14,534 $202,454 $58,605 $0 $11,082 $0 $18,475 $57,802 $532,492 $39,154 $2,751 $4,908 $234,533 $50,329 $287,707 $0 $7,733 $171,932 $441,334 -$96,191 $5,563 $31,271 $528,379 $80,197 $66,181 $41,648 $438,204 $273,622 $165,071 -$21,548 $383,548 $296,679 $264k Rent for Council on Ageing (COA) and Scale What is this? $30,304 $36,348 $277,654 $237,213 $4,866 $67,533 $357,249 $335,645 $51,022 $64,355 $440,696 $93,189 $67,703 $55,521 $716,625 $31,431 $2,854 $4,736 $140,218 $13,749 $16,211 $5,633 $306,628 $16,667 $9,674 $66,246 $365,591 $131,965 $155,104 $85,616 $561,209 $149,197 $137k excise bill postage billing $79,823 $256,399 $779,005 $124,680 $210,172 $102,615 $957,660 $381,494 $35k MBTA passes $30k calander scheduling $65k Temp Staffing Services $20k pre-employment drug screening $555,787 $2,059,795 $3,136,987 $269,934 $417k cloud software protection $400k Microsoft Office $350k Cell Coverage $80k Verizon Landline $70k PhotoCopier lease $63,942 $92,976 $575,768 $73,687 $41,392 $77,981 $654,643 $158,022 $23,418 $12,285 $164,884 $68,470 $46,225 $79,738 $562,536 $102,350 $9,200 $75,072 $408,504 $13,355 $0 $4,845 $0 $17,895 $23,764 $451,585 $219,797 $9,847 $141,589 $449,274 -$87,161 $32,150 $26,339 $549,365 $202,170 $0 $8,025 $0 $59,234 $246,530 $630,784 -$135,987

FY25 Personnel Projected Costs Dept Org Munis Dept Description Personnel Ordinary Maintenance Personnel Expenses to date 12/17 Personnel % Used to Date Projected Surplus and/or Deficit Personnel Notes (Includes non-salary benefits) Requsitions Appropriated Budget 186 OSPCD Economic Dev $977,253 $315,650 187 Inspectional Services $3,572,473 $586,818 190 OSPCD- HOUSING STABILITY PS $947,799 $543,500 191 OSPCD-PSUF PERSONAL SVC $654,645 $323,645 210 Police Department $17,425,674 $609,760 211 Police Department - E911 $1,376,530 220 Fire Department $20,989,251 $940,800 229 Fire Department- Alarm $1,297,947 $2,000 291 Emergency Management $182,174 $105,550 292 Police Animal Control $148,792 $16,750 293 Parking Clerk $3,288,260 $1,114,601 401 Public Works - Admin $1,034,253 $883,227 402 Public Works- Electric $404,416 $400,000 403 Public Works- Engineering $871,825 $453,331 404 Public Works- Snow $1,737,083 405 Public Works- Highway $3,082,446 $1,466,200 406 Public Works- Sanitation $9,230,621 407 Public Works- Building $1,910,170 $11,142,316 408 Public Works- Fleet $653,430 409 Public Works- Grounds $1,557,622 $1,732,745 $316,670 32.40% $295,194 $1,486,838 41.62% $370,052 $371,755 39.22% $147,096 $238,038 36.36% $141,947 $7,791,507 44.71% $643,967 $887,355 64.46% -$534,695 $9,288,024 44.25% $984,275 $600,196 46.24% $5,218 $55,990 30.73% $61,581 $63,169 42.45% $12,737 $1,382,636 42.05% $310,275 $416,231 40.24% $137,756 $159,743 39.50% $60,355 $340,690 39.08% $138,031 0.00% $0 $1,124,527 36.48% $660,387 0.00% $0 $612,399 32.06% $591,157 0.00% $0 $560,847 36.01% $349,643 Whats the difference between 210 and 211 Police E911 -- call takers + dispatchers. Supplimental Approp is paying for defecit. Pending recruit class

Dept Org Munis Dept Description Appropriated Budget Encumbrances Expenses 12/17 Req + Enc + Expenses Projected Surplus and/or Deficit Notes Questions FY25 Ordinary Maintenance Q2 186 OSPCD Economic Dev 187 Inspectional Services 190 OSPCD- HOUSING STABILITY PS 191 OSPCD-PSUF PERSONAL SVC 210 Police Department 211 Police Department - E911 220 Fire Department 229 Fire Department- Alarm 291 Emergency Management 292 Police Animal Control 293 Parking Clerk 401 Public Works - Admin 402 Public Works- Electric 403 Public Works- Engineering 404 Public Works- Snow 405 Public Works- Highway 406 Public Works- Sanitation 407 Public Works- Building 408 Public Works- Fleet 409 Public Works- Grounds $143,450 $64,537 $524,658 $176,646 $75k ARTISAN'S ASYLUM INC What is Artisan? $236,931 $207,426 $1,931,195 $140,055 $174k food safety, regulations, inspections $150k rodent exterminations $296,902 $232,524 $901,181 $42,680 $260k Somerville Housing Coallition $45k Housing Search & Stabiltiy $71,393 $308,110 $617,541 -$339,976 $85k Somerville Tree Inventory $45k Somerville Young Tree Training $186,262 $209,429 $8,187,198 $158,682 $56k East Substation Lease $30 West Substation Lease $30k Vehicle Rentals $28k public safety equipment $0 $887,355 $0 $103,095 $173,944 $9,565,063 $566,152 $263k Assemby Sq Rental $0 $600,196 $2,000 $36,973 $2,188 $95,151 $100,837 $5,694 $4,182 $73,045 $7,742 $418,077 $586,385 $2,387,098 -$148,382 $297 Modexo Permit Transactions $100k credit card transation fees $211,662 $345,791 $973,684 $138,446 $150k Jail Diversion Program $200k diesel fuel $31,884 $108,505 $300,132 $166,296 $129,218 $261,209 $731,117 -$109,273 $300k Pavement Markings $80k West Broadway Design Services $75k Pedestrian Button upgrades $2,538,559 $140,924 $2,679,483 $1,433,553 Snow Contracts -- dependent on winter snow storms $534,588 $361,995 $2,021,110 $686,519 $230k removal street sweeping debris $320k street sweeping services $2,140,720 $3,505,133 $5,645,853 $1,681,103 $1.5m MSW Hauling $960k Waste Collections $250k Tipping Fee $1.07m Recycling processing $200k big belly $100k HHW weekends $100k recycling totters THIS COMMODITY CODE IS TO BE U $6,334,097 $3,419,869 $10,366,365 $3,776,445 $3m HVAC Maintenance $2.3m Electric Citywide Expenses $600k Natural Gas Expenses $178k Interior Building Maint. $143k Elevator R&M $100k fence install & maintenance $100k fire alarm $125k plumbing Invoice processing + seasonal activity $257,457 $253,225 $510,682 $108,021 Auto parts & on-call repairs $648,667 $405,014 $1,614,528 $860,407 $150k tree prunning $400k R&M - REC FACIL/PARKS/PLAYGRND

FY25 Personnel Projected Costs Dept Org Munis Dept Description Personnel Ordinary Maintenance Personnel Expenses to date 12/17 Personnel % Used to Date Projected Surplus and/or Deficit Personnel Notes (Includes non-salary benefits) Requsitions Appropriated Budget 411 Public Works- Schools $2,939,701 $1,400,000 512 Board of Health $2,520,927 $888,448 543 Veterans Affairs $287,168 $604,750 610 Public Library $2,655,293 $848,152 630 Recreation- Youth Program $1,813,909 $539,470 No Chartfield Reqs $1,157,780 39.38% $446,022 $967,233 38.37% $437,657 $126,861 44.18% $13,929 $1,150,207 43.32% $177,925 $786,668 43.37% $119,548 $1,390,146 $94,626,228 $48,001,514 $39,810,176 42.07% $8,759,898 Personnel Projected Surplus $6,569,924 City Total Budget $142,627,742 07/01/2024 12/17/2024 Expense $55,738,019 Weeks Completed 24.14285714 Proj Rem $46,056,153 Weeks Remaining 27.85714286 Surplus $22,455,289 Personnel Projected Surplus 9.26% 6.94% Percent surplus 15.74% $ Remaining Proj $46,056,153

Dept Org Munis Dept Description Appropriated Budget Encumbrances Expenses 12/17 Req + Enc + Expenses Projected Surplus and/or Deficit Notes Questions FY25 Ordinary Maintenance Q2 411 Public Works- Schools 512 Board of Health 543 Veterans Affairs 610 Public Library 630 Recreation- Youth Program No Chartfield Reqs $900,000 $628,842 $2,686,622 $45,571 $900k on-call cleaning services $476,556 $181,964 $1,625,753 $496,525 $422k Teen Empowerment Youth Develop Reserved funds under review $5,574 $76,056 $208,492 $440,936 $217,509 $411,195 $1,778,911 -$37,499 $140k e-books subscription Subscription fee + ussage drives actual costs $55,474 $157,777 $999,919 $199,642 Req cannot pull from expense codes during excel pull $17,733,780 $15,927,843 $73,471,799 $13,695,390 OM Projected Surplus $13,695,390 % Surplus 28.53%