YTD General Fund Appropriations Report — File 24-0210

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 1 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0111251 CITY COUNCIL PERSONAL SERVCS 0111251 511000 SALARIES 0 0 0 .00 .00 .00 .0% 0111251 511002 SALARIES - MONTH 445,000 0 445,000 259,583.10 .00 185,416.90 58.3% 0111251 512000 SALARIES & WAGES 60,000 0 60,000 .00 .00 60,000.00 .0% 0111251 515006 HOLIDAYS NON-UNI 0 0 0 .00 .00 .00 .0% 0111251 519999 RESERVED FOR REV 0 0 0 .00 .00 .00 .0% TOTAL CITY COUNCIL PERSONAL SERVCS 505,000 0 505,000 259,583.10 .00 245,416.90 51.4% 0111252 CITY COUNCIL ORDINARY MAINT 0111252 524034 MAINT CONTRACT-O 0 0 0 .00 .00 .00 .0% 0111252 530000 PROFESSIONAL & T 0 0 0 .00 .00 .00 .0% 0111252 530010 LEGAL SERVICES 50,000 0 50,000 .00 .00 50,000.00 .0% 0111252 530011 ADVERTISING 0 0 0 .00 .00 .00 .0% 0111252 530023 STAFF DEVELOPMEN 0 0 0 .00 .00 .00 .0% 0111252 534003 POSTAGE 0 0 0 .00 .00 .00 .0% 0111252 542000 OFFICE SUPPLIES 500 0 500 .00 .00 500.00 .0% 0111252 542001 PRINTING & STATI 750 0 750 123.00 .00 627.00 16.4% 0111252 542005 OFFICE EQUIPMENT 0 0 0 .00 .00 .00 .0% 0111252 542008 BOOKS & BOOKBIND 0 0 0 .00 .00 .00 .0% 0111252 549000 FOOD SUPPLIES & 3,160 0 3,160 91.81 242.15 2,826.04 10.6% 0111252 558011 FLOWERS & FLAGS 0 0 0 .00 .00 .00 .0% 0111252 571001 IN STATE CONFERE 1,000 0 1,000 .00 .00 1,000.00 .0% 0111252 573000 DUES AND MEMBERS 0 0 0 .00 .00 .00 .0% 0111252 578021 DIRECT EXPENSE-B 34,500 0 34,500 20,125.00 .00 14,375.00 58.3% TOTAL CITY COUNCIL ORDINARY MAINT 89,910 0 89,910 20,339.81 242.15 69,328.04 22.9% 0111351 CLRK OF COMM PERSONAL SERVICES 0111351 511002 SALARIES - MONTH 69,764 0 69,764 22,344.71 .00 47,419.29 32.0% 0111351 515006 HOLIDAYS NON-UNI 0 0 0 .00 .00 .00 .0% 0111351 519999 RESERVED FOR REV 0 0 0 .00 .00 .00 .0% TOTAL CLRK OF COMM PERSONAL SERVICES 69,764 0 69,764 22,344.71 .00 47,419.29 32.0% 0111352 CLRK OF COMM ORDINARY MAINT 0111352 542000 OFFICE SUPPLIES 0 0 0 .00 .00 .00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 2 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0111352 542001 PRINTING & STATI 0 0 0 .00 .00 .00 .0% 0111352 549000 FOOD SUPPLIES & 0 0 0 .00 .00 .00 .0% TOTAL CLRK OF COMM ORDINARY MAINT 0 0 0 .00 .00 .00 .0% 0112151 EXEC ADMIN PERSONAL SERVICES 0112151 511000 SALARIES 973,101 -35,000 938,101 480,245.73 .00 457,855.27 51.2% 0112151 512000 SALARIES & WAGES 0 0 0 .00 .00 .00 .0% 0112151 515006 HOLIDAYS NON-UNI 6,350 0 6,350 5,120.72 .00 1,229.28 80.6% 0112151 519013 OTHER LUMP SUM P 0 0 0 .00 .00 .00 .0% 0112151 519030 COVID19 PERSONAL 0 0 0 .00 .00 .00 .0% 0112151 519999 RESERVED FOR REV 0 0 0 .00 .00 .00 .0% TOTAL EXEC ADMIN PERSONAL SERVICES 979,451 -35,000 944,451 485,366.45 .00 459,084.55 51.4% 0112152 EXEC ADMIN ORDINARY MAINT 0112152 524033 R&M - SOFTWARE 0 0 0 .00 .00 .00 .0% 0112152 524034 MAINT CONTRACT-O 2,500 0 2,500 971.90 1,528.10 .00 100.0% 0112152 527001 RENTAL - BUILDIN 0 0 0 .00 .00 .00 .0% 0112152 527015 RENTALS EQUIPMEN 0 0 0 .00 .00 .00 .0% 0112152 527019 RENTAL-WATER COO 150 0 150 42.40 107.60 .00 100.0% 0112152 530000 PROFESSIONL & TE 110,000 0 110,000 .00 .00 110,000.00 .0% 0112152 534003 POSTAGE 0 0 0 .00 .00 .00 .0% 0112152 534015 FEE 0 0 0 .00 .00 .00 .0% 0112152 538005 PHOTOGRAPHY 0 0 0 .00 .00 .00 .0% 0112152 542000 OFFICE SUPPLIES 3,000 0 3,000 469.40 2,530.60 .00 100.0% 0112152 542001 PRINTING & STATI 3,000 0 3,000 92.63 .00 2,907.37 3.1% 0112152 542002 PHOTOCOPYING 0 0 0 .00 .00 .00 .0% 0112152 542006 OFFICE FURNITURE 0 0 0 .00 .00 .00 .0% 0112152 549000 FOOD SUPPLIES & 5,000 0 5,000 1,379.23 198.12 3,422.65 31.5% 0112152 558000 OTHER SUPPLIES 2,000 0 2,000 1,891.98 108.02 .00 100.0% 0112152 558004 MAGAZINES,NEWS,S 1,000 0 1,000 .00 .00 1,000.00 .0% 0112152 558011 FLOWERS & FLAGS 500 0 500 .00 .00 500.00 .0% 0112152 558012 BADGES, EMBLEMS, 7,000 -1,000 6,000 .00 .00 6,000.00 .0% 0112152 571000 IN STATE TRAVEL 0 0 0 .00 .00 .00 .0% 0112152 571001 IN STATE CONFERE 500 1,000 1,500 605.29 .29 894.42 40.4% 0112152 572000 OUT OF STATE TRA 3,000 0 3,000 .00 .00 3,000.00 .0% 0112152 572001 OUT OF STATE CON 2,000 0 2,000 375.00 .00 1,625.00 18.8%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 3 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0112152 573000 DUES AND MEMBERS 48,700 0 48,700 6,602.00 2,500.00 39,598.00 18.7% 0112152 578037 COVID 19 OM EXP 0 0 0 .00 .00 .00 .0% TOTAL EXEC ADMIN ORDINARY MAINT 188,350 0 188,350 12,429.83 6,972.73 168,947.44 10.3% 0112160 EXEC ADMIN SPECIAL ITEMS 0112160 512002 SUMMER YOUTH EMP 470,000 0 470,000 259,452.85 4,550.00 205,997.15 56.2% 0112160 530000 PROFESSIONAL & T 0 0 0 .00 .00 .00 .0% 0112160 558022 OFFICIAL CELEBRA 35,000 35,000 70,000 19,803.03 33,426.90 16,770.07 76.0% 0112160 578018 CHARTER REFORM S 20,000 0 20,000 .00 .00 20,000.00 .0% 0112160 578019 FINANCIAL MANAGE 0 0 0 .00 .00 .00 .0% 0112160 578022 FIRE EVALUATION 0 0 0 .00 .00 .00 .0% 0112160 578037 COVID 19 OM EXP 0 0 0 .00 .00 .00 .0% TOTAL EXEC ADMIN SPECIAL ITEMS 525,000 35,000 560,000 279,255.88 37,976.90 242,767.22 56.6% 0112251 EXEC-SOMER PERSONAL SERVICES 0112251 511000 SALARIES 488,637 0 488,637 271,125.61 .00 217,511.39 55.5% 0112251 511001 SALARIES - PROFE 0 0 0 .00 .00 .00 .0% 0112251 512000 SALARIES & WAGES 40,000 25,000 65,000 5,700.00 .00 59,300.00 8.8% 0112251 515006 HOLIDAYS NON-UNI 3,912 0 3,912 2,804.74 .00 1,107.26 71.7% 0112251 519013 OTHER LUMP SUM P 0 0 0 .00 .00 .00 .0% 0112251 519030 COVID19 PERSONAL 0 0 0 .00 .00 .00 .0% 0112251 519105 STIPENDS-OTHER 0 0 0 .00 .00 .00 .0% 0112251 519999 RESERVED FOR REV 0 0 0 .00 .00 .00 .0% TOTAL EXEC-SOMER PERSONAL SERVICES 532,549 25,000 557,549 279,630.35 .00 277,918.65 50.2% 0112252 EXEC-SOMER ORDINARY MAINT 0112252 524034 R&M - SERVICE CO 0 0 0 .00 .00 .00 .0% 0112252 527001 RENTAL - BUILDIN 0 0 0 .00 .00 .00 .0% 0112252 527019 RENTAL-WATER COO 200 0 200 .00 200.00 .00 100.0% 0112252 530000 PROFESSIONL & TE 10,000 -10,000 0 .00 .00 .00 .0% 0112252 530008 EMPLOYEE TRAININ 4,750 -2,000 2,750 .00 .00 2,750.00 .0% 0112252 530011 ADVERTISING 0 0 0 .00 .00 .00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 4 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0112252 530028 SOFTWARE SERVICE 5,000 -5,000 0 .00 .00 .00 .0% 0112252 542000 OFFICE SUPPLIES 600 0 600 259.67 340.33 .00 100.0% 0112252 542001 STATIONERY 3,000 -3,000 0 .00 .00 .00 .0% 0112252 542004 COMPUTER SUPPLIE 0 0 0 .00 .00 .00 .0% 0112252 542005 OFFICE EQUIPMENT 0 0 0 .00 .00 .00 .0% 0112252 542006 OFFICE FURNITURE 28,000 0 28,000 .00 .00 28,000.00 .0% 0112252 549000 FOOD SUPPLIES & 0 0 0 .00 .00 .00 .0% 0112252 571000 IN STATE TRAVEL 0 0 0 .00 .00 .00 .0% 0112252 571001 IN STATE CONFERE 5,000 -5,000 0 .00 .00 .00 .0% 0112252 572000 OUT OF STATE TRA 0 0 0 .00 .00 .00 .0% 0112252 572001 OUT OF STATE CON 0 0 0 .00 .00 .00 .0% 0112252 573000 DUES AND MEMBERS 250 0 250 50.00 .00 200.00 20.0% 0112252 578014 NEIGHBORHOOD IMP 0 0 0 .00 .00 .00 .0% 0112252 578015 AWARDS 0 0 0 .00 .00 .00 .0% 0112252 585017 SOFTWARE 0 0 0 .00 .00 .00 .0% TOTAL EXEC-SOMER ORDINARY MAINT 56,800 -25,000 31,800 309.67 540.33 30,950.00 2.7% 0112351 IAM-CPM PERSONAL SERVICES 0112351 511000 SALARIES 890,445 0 890,445 394,012.92 .00 496,432.08 44.2% 0112351 515006 HOLIDAYS NON-UNI 6,406 0 6,406 4,828.46 .00 1,577.54 75.4% 0112351 519013 OTHER LUMP SUM P 0 0 0 .00 .00 .00 .0% 0112351 519104 SALARY STIPEND 0 0 0 .00 .00 .00 .0% 0112351 519999 RESERVED FOR REV 0 0 0 .00 .00 .00 .0% TOTAL IAM-CPM PERSONAL SERVICES 896,851 0 896,851 398,841.38 .00 498,009.62 44.5% 0112352 IAM-CPM ORDINARY MAINTENANCE 0112352 524001 R&M - BUILDINGS 0 0 0 .00 .00 .00 .0% 0112352 524020 R&M - EXTERIOR B 0 0 0 .00 .00 .00 .0% 0112352 527019 RENTAL-WATER COO 0 0 0 .00 .00 .00 .0% 0112352 530000 PROFESSIONL & TE 0 0 0 .00 .00 .00 .0% 0112352 530006 ENGINEER'G/ARCHI 0 0 0 .00 .00 .00 .0% 0112352 530008 EMPLOYEE TRAININ 0 0 0 .00 .00 .00 .0% 0112352 530028 SOFTWARE SERVICE 0 0 0 .00 .00 .00 .0% 0112352 534003 POSTAGE 0 0 0 .00 .00 .00 .0% 0112352 534015 FEE 0 0 0 .00 .00 .00 .0% 0112352 538008 MOVING SERVICES 0 0 0 .00 .00 .00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 5 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0112352 542000 OFFICE SUPPLIES 0 0 0 .00 .00 .00 .0% 0112352 542001 PRINTING & STATI 0 0 0 .00 .00 .00 .0% 0112352 542005 OFFICE EQUIPMENT 0 0 0 .00 .00 .00 .0% 0112352 542006 OFFICE FURNITURE 0 0 0 .00 .00 .00 .0% 0112352 542007 COMPUTER EQUIPME 0 0 0 .00 .00 .00 .0% 0112352 549000 FOOD SUPPLIES & 0 0 0 .00 .00 .00 .0% 0112352 553001 SIGNS AND CONES 0 0 0 .00 .00 .00 .0% 0112352 558006 UNIFORMS 0 0 0 .00 .00 .00 .0% 0112352 571000 IN STATE TRAVEL 0 0 0 .00 .00 .00 .0% 0112352 571001 IN STATE CONFERE 0 0 0 .00 .00 .00 .0% 0112352 572000 OUT OF STATE TRA 0 0 0 .00 .00 .00 .0% 0112352 572001 OUT OF STATE CON 0 0 0 .00 .00 .00 .0% 0112352 573000 DUES AND MEMBERS 0 0 0 .00 .00 .00 .0% 0112352 578007 REIMB OF LICENSE 0 0 0 .00 .00 .00 .0% TOTAL IAM-CPM ORDINARY MAINTENANCE 0 0 0 .00 .00 .00 .0% 0112358 IAM-CPM CAPITAL OUTLAY 0112358 530000 PROFESSIONAL & T 90,000 0 90,000 .00 .00 90,000.00 .0% 0112358 530006 ENGINEER'G/ARCHI 1,251,000 0 1,251,000 138,978.45 220,046.00 891,975.55 28.7% 0112358 530007 WHS FEASIBILITY 0 0 0 .00 .00 .00 .0% 0112358 530028 SOFTWARE SERVICE 0 0 0 .00 .00 .00 .0% 0112358 534015 FEE 0 0 0 .00 .00 .00 .0% 0112358 582002 BUILDING RECONST 0 0 0 .00 .00 .00 .0% 0112358 582003 BUILDING IMPROVE 20,000 0 20,000 5,675.00 4,300.00 10,025.00 49.9% 0112358 584003 FENCES 0 0 0 .00 .00 .00 .0% 0112358 585701 LIGHTING CONSERV 0 0 0 .00 .00 .00 .0% TOTAL IAM-CPM CAPITAL OUTLAY 1,361,000 0 1,361,000 144,653.45 224,346.00 992,000.55 27.1% 0112451 EXEC-ARTS CNCL PERSONAL SERVCS 0112451 511000 SALARIES 565,545 0 565,545 288,863.38 .00 276,681.62 51.1% 0112451 513000 OVERTIME 3,000 0 3,000 1,739.61 .00 1,260.39 58.0% 0112451 515006 HOLIDAYS NON-UNI 4,051 0 4,051 2,770.86 .00 1,280.14 68.4% 0112451 530000 PROFESSIONAL & T 0 0 0 .00 .00 .00 .0% TOTAL EXEC-ARTS CNCL PERSONAL SERVCS 572,596 0 572,596 293,373.85 .00 279,222.15 51.2% 0112452 EXEC-ARTS CNCL ORDINARY MAINT 0112452 530000 PROFESSIONL & TE 233,125 0 233,125 101,282.00 23,683.00 108,160.00 53.6%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 6 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0112452 530018 POLICE DETAIL 0 0 0 .00 .00 .00 .0% 0112452 534008 WEB SITE COSTS 0 0 0 .00 .00 .00 .0% 0112452 542000 OFFICE SUPPLIES 1,000 0 1,000 374.14 625.86 .00 100.0% 0112452 542005 OFFICE EQUIPMENT 0 0 0 .00 .00 .00 .0% 0112452 585001 VEHICLES 0 0 0 .00 .00 .00 .0% TOTAL EXEC-ARTS CNCL ORDINARY MAINT 234,125 0 234,125 101,656.14 24,308.86 108,160.00 53.8% 0112551 EXEC-CONSTITUENT PERSONAL SVC 0112551 511000 SALARIES 1,086,956 0 1,086,956 559,900.84 .00 527,055.16 51.5% 0112551 512000 SALARIES & WAGES 73,805 0 73,805 18,035.08 .00 55,769.92 24.4% 0112551 513000 OVERTIME 25,000 0 25,000 18,397.28 .00 6,602.72 73.6% 0112551 514004 SHIFT DIFFERENTI 0 0 0 .00 .00 .00 .0% 0112551 514006 LONGEVITY 2,050 0 2,050 1,025.00 .00 1,025.00 50.0% 0112551 515004 HOLIDAYS 0 0 0 .00 .00 .00 .0% 0112551 515006 HOLIDAYS NON-UNI 7,418 0 7,418 5,561.66 .00 1,856.34 75.0% 0112551 515011 HOLIDAYS - S.M.E 756 0 756 193.49 .00 562.51 25.6% 0112551 515012 PERFECT ATTENDAN 0 0 0 .00 .00 .00 .0% 0112551 519004 UNIFORM ALLOWANC 671 0 671 350.00 .00 321.00 52.2% 0112551 519013 OTHER LUMP SUM P 0 0 0 .00 .00 .00 .0% 0112551 519030 COVID19 PERSONAL 0 0 0 .00 .00 .00 .0% TOTAL EXEC-CONSTITUENT PERSONAL SVC 1,196,656 0 1,196,656 603,463.35 .00 593,192.65 50.4% 0112552 EXEC-CONSTITUENT ORDINARY MAIN 0112552 524034 R&M - SERVICE CO 250 0 250 .00 .00 250.00 .0% 0112552 527019 RENTAL-WATER COO 300 0 300 80.28 219.72 .00 100.0% 0112552 530000 PROFESSIONL & TE 100,000 0 100,000 32,088.99 7,911.01 60,000.00 40.0% 0112552 530008 EMPLOYEE TRAININ 8,000 0 8,000 .00 .00 8,000.00 .0% 0112552 534003 POSTAGE 0 0 0 .00 .00 .00 .0% 0112552 534006 EXPRESS/FREIGHT 0 0 0 .00 .00 .00 .0% 0112552 542000 OFFICE SUPPLIES 7,000 0 7,000 5,092.23 79.43 1,828.34 73.9% 0112552 542001 PRINTING & STATI 1,700 0 1,700 274.89 325.11 1,100.00 35.3% 0112552 542006 OFFICE FURNITURE 8,000 0 8,000 .00 .00 8,000.00 .0% 0112552 542007 COMPUTER EQUIPME 0 0 0 .00 .00 .00 .0% 0112552 572000 OUT OF STATE TRA 0 0 0 .00 .00 .00 .0% TOTAL EXEC-CONSTITUENT ORDINARY MAIN 125,250 0 125,250 37,536.39 8,535.27 79,178.34 36.8% 0112651 EXEC-OS ENV PERSONAL SERVICES

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 7 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0112651 511000 SALARIES 653,022 32,000 685,022 289,435.05 .00 395,586.95 42.3% 0112651 512000 SALARIES & WAGES 5,000 0 5,000 .00 .00 5,000.00 .0% 0112651 513000 OVERTIME 4,000 0 4,000 .00 .00 4,000.00 .0% 0112651 515006 HOLIDAYS NON-UNI 5,230 0 5,230 3,239.00 .00 1,991.00 61.9% 0112651 519999 RESERVED FOR REV 0 0 0 .00 .00 .00 .0% TOTAL EXEC-OS ENV PERSONAL SERVICES 667,252 32,000 699,252 292,674.05 .00 406,577.95 41.9% 0112652 EXEC-OS ENV ORDINARY MAINT 0112652 521001 ELECTRICITY 0 0 0 .00 .00 .00 .0% 0112652 530000 PROFESSIONL & TE 459,864 0 459,864 113,472.10 167,108.22 179,283.68 61.0% 0112652 530008 EMPLOYEE TRAININ 6,610 0 6,610 .00 .00 6,610.00 .0% 0112652 530011 ADVERTISING 30,500 0 30,500 2,030.50 6,250.59 22,218.91 27.2% 0112652 530029 CUSTODIAL DETAIL 0 0 0 .00 .00 .00 .0% 0112652 534003 POSTAGE 300 0 300 .00 .00 300.00 .0% 0112652 542000 OFFICE SUPPLIES 250 0 250 .00 .00 250.00 .0% 0112652 542001 PRINTING & STATI 35,000 -1,500 33,500 1,860.00 1,200.00 30,440.00 9.1% 0112652 542004 COMPUTER SUPPLIE 0 0 0 .00 .00 .00 .0% 0112652 542005 OFFICE EQUIPMENT 0 0 0 .00 .00 .00 .0% 0112652 542006 OFFICE FURNITURE 0 0 0 .00 .00 .00 .0% 0112652 542007 COMPUTER EQUIPME 0 0 0 .00 .00 .00 .0% 0112652 542012 OTH EQUIPMENT NO 24,000 0 24,000 .00 .00 24,000.00 .0% 0112652 549000 FOOD SUPPLIES & 6,000 1,500 7,500 2,440.00 3,207.95 1,852.05 75.3% 0112652 553001 SIGNS AND CONES 300 0 300 .00 .00 300.00 .0% 0112652 558002 ONLINE SUBSCRIPT 1,100 0 1,100 .00 900.00 200.00 81.8% 0112652 558004 MAGAZINES,NEWS,S 0 0 0 .00 .00 .00 .0% 0112652 558006 UNIFORMS 200 0 200 .00 .00 200.00 .0% 0112652 571000 IN STATE TRAVEL 0 0 0 .00 .00 .00 .0% 0112652 571001 IN STATE CONFERE 825 0 825 .00 .00 825.00 .0% 0112652 572000 OUT OF STATE TRA 8,500 0 8,500 900.00 1,100.00 6,500.00 23.5% 0112652 573000 DUES AND MEMBERS 3,450 0 3,450 2,959.00 .00 491.00 85.8% 0112652 585000 EQUIPMENT 0 0 0 .00 .00 .00 .0% TOTAL EXEC-OS ENV ORDINARY MAINT 576,899 0 576,899 123,661.60 179,766.76 273,470.64 52.6% 0112751 HHS-COA PERSONAL SERVICES 0112751 511000 SALARIES 520,988 0 520,988 270,544.90 .00 250,443.10 51.9%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 8 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0112751 513000 OVERTIME 0 0 0 .00 .00 .00 .0% 0112751 514006 LONGEVITY 600 0 600 250.00 .00 350.00 41.7% 0112751 515006 HOLIDAYS NON-UNI 2,362 0 2,362 2,256.26 .00 105.74 95.5% 0112751 515011 HOLIDAYS - S.M.E 1,144 0 1,144 558.40 .00 585.60 48.8% 0112751 515012 PERFECT ATTENDAN 0 0 0 1,000.00 .00 -1,000.00 100.0% 0112751 519013 OTHER LUMP SUM P 0 0 0 .00 .00 .00 .0% 0112751 519030 COVID19 PERSONAL 0 0 0 .00 .00 .00 .0% 0112751 519999 RESERVED FOR REV 0 0 0 .00 .00 .00 .0% TOTAL HHS-COA PERSONAL SERVICES 525,094 0 525,094 274,609.56 .00 250,484.44 52.3% 0112752 HHS-COA ORDINARY MAINTENANCE 0112752 524000 REPAIRS AND MAIN 0 0 0 .00 .00 .00 .0% 0112752 524034 MAINT CONTRACT-O 1,950 0 1,950 1,730.93 219.07 .00 100.0% 0112752 527001 RENTAL - BUILDIN 78,877 0 78,877 -31,261.34 100,905.82 9,232.52 88.3% 0112752 527014 RENTAL - TABLES 0 0 0 .00 .00 .00 .0% 0112752 527019 RENTAL-WATER COO 200 0 200 .00 200.00 .00 100.0% 0112752 530000 PROFESSIONL & TE 3,000 29,780 32,780 14,350.00 17,980.00 450.00 98.6% 0112752 530018 POLICE DETAIL 0 907 907 907.00 .00 .00 100.0% 0112752 534003 POSTAGE 5,334 0 5,334 .00 .00 5,334.00 .0% 0112752 542000 OFFICE SUPPLIES 1,480 0 1,480 932.12 .00 547.88 63.0% 0112752 542001 PRINTING & STATI 7,280 0 7,280 7,045.00 .00 235.00 96.8% 0112752 549000 FOOD SUPPLIES & 6,000 -907 5,093 3,691.78 .00 1,401.22 72.5% 0112752 558018 PROGRAM SUPPLIES 2,000 0 2,000 1,110.87 .00 889.13 55.5% 0112752 571000 IN STATE TRAVEL 500 0 500 .00 .00 500.00 .0% TOTAL HHS-COA ORDINARY MAINTENANCE 106,621 29,780 136,401 -1,493.64 119,304.89 18,589.75 86.4% 0112851 HHS-SOMER PROM PERSONAL SVCS 0112851 511000 SALARIES 457,249 0 457,249 225,590.90 .00 231,658.10 49.3% 0112851 513000 OVERTIME 0 0 0 .00 .00 .00 .0% 0112851 515006 HOLIDAYS NON-UNI 3,461 0 3,461 2,342.64 .00 1,118.36 67.7% TOTAL HHS-SOMER PROM PERSONAL SVCS 460,710 0 460,710 227,933.54 .00 232,776.46 49.5% 0112852 HHS-SOMER PROM ORDINARY MAIN 0112852 524034 R&M - SERVICE CO 0 0 0 .00 .00 .00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 9 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0112852 527019 RENTAL-WATER COO 0 0 0 .00 .00 .00 .0% 0112852 530000 PROFESSIONAL & T 260,000 0 260,000 27,180.00 84,400.00 148,420.00 42.9% 0112852 530029 CUSTODIAL DETAIL 0 0 0 .00 .00 .00 .0% 0112852 542000 OFFICE SUPPLIES 100 0 100 .00 .00 100.00 .0% 0112852 542001 PRINTING & STATI 0 4,000 4,000 420.00 .00 3,580.00 10.5% 0112852 542006 OFFICE FURNITURE 0 3,965 3,965 .00 3,965.00 .00 100.0% 0112852 542008 BOOKS & BOOKBIND 0 0 0 .00 .00 .00 .0% 0112852 549000 FOOD SUPPLIES & 20,000 -7,965 12,035 646.21 2,713.79 8,675.00 27.9% 0112852 558018 PROGRAM SUPPLIES 25,000 0 25,000 3,400.00 580.00 21,020.00 15.9% 0112852 571001 IN STATE CONFERE 350 0 350 .00 .00 350.00 .0% 0112852 573000 DUES AND MEMBERS 0 0 0 .00 .00 .00 .0% TOTAL HHS-SOMER PROM ORDINARY MAIN 305,450 0 305,450 31,646.21 91,658.79 182,145.00 40.4% 0112951 IAM PERSONAL SERVICE 0112951 511000 SALARIES 574,643 -5,925 568,718 291,950.53 .00 276,767.05 51.3% 0112951 513000 OVERTIME 0 0 0 .00 .00 .00 .0% 0112951 513001 TRAINING-OVERTIM 0 0 0 .00 .00 .00 .0% 0112951 514006 LONGEVITY 600 0 600 300.00 .00 300.00 50.0% 0112951 515006 HOLIDAYS NON-UNI 4,128 0 4,128 2,927.81 .00 1,200.19 70.9% 0112951 515011 HOLIDAYS - S.M.E 476 0 476 233.12 .00 242.88 49.0% 0112951 519004 UNIFORM ALLOWANC 350 0 350 350.00 .00 .00 100.0% TOTAL IAM PERSONAL SERVICE 580,197 -5,925 574,272 295,761.46 .00 278,510.12 51.5% 0112952 IAM ORDIN MAINT 0112952 516100 FIRE DETAIL - CI 0 0 0 .00 .00 .00 .0% 0112952 524020 R&M - EXTERIOR B 0 0 0 .00 .00 .00 .0% 0112952 524036 CABLING NON CAPI 0 0 0 .00 .00 .00 .0% 0112952 527006 LEASE - PHOTOCPI 1,500 0 1,500 499.80 508.80 491.40 67.2% 0112952 527019 RENTAL-WATER COO 400 0 400 260.60 139.40 .00 100.0% 0112952 527021 RENTAL OF LAND S 0 0 0 .00 .00 .00 .0% 0112952 530000 PROFESSIONAL & T 350,000 0 350,000 .00 150,100.00 199,900.00 42.9% 0112952 530008 EMPLOYEE TRAININ 9,000 0 9,000 701.60 150.00 8,148.40 9.5% 0112952 530018 POLICE DETAIL 1,000 0 1,000 .00 .00 1,000.00 .0% 0112952 530028 SOFTWARE SERVICE 50,000 -5,000 45,000 6,163.04 12,893.92 25,943.04 42.3% 0112952 534015 FEE 5,000 0 5,000 4,912.00 .00 88.00 98.2% 0112952 538008 MOVING SERVICES 0 0 0 .00 .00 .00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 10 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0112952 542000 OFFICE SUPPLIES 3,500 0 3,500 2,267.85 834.15 398.00 88.6% 0112952 542001 PRINTING & STATI 2,000 5,000 7,000 2,998.75 .00 4,001.25 42.8% 0112952 542005 OFFICE EQUIPMENT 2,000 0 2,000 .00 .00 2,000.00 .0% 0112952 542006 OFFICE FURNITURE 10,000 0 10,000 .00 .00 10,000.00 .0% 0112952 542007 COMPUTER EQUIPME 3,000 0 3,000 .00 .00 3,000.00 .0% 0112952 543007 PAINT 0 0 0 .00 .00 .00 .0% 0112952 543011 HARDWARE & SMALL 500 0 500 .00 .00 500.00 .0% 0112952 549000 FOOD SUPPLIES & 0 0 0 .00 .00 .00 .0% 0112952 553001 SIGNS AND CONES 2,500 0 2,500 .00 .00 2,500.00 .0% 0112952 558006 UNIFORMS 3,000 0 3,000 1,226.60 .00 1,773.40 40.9% 0112952 571000 IN STATE TRAVEL 200 0 200 .00 .00 200.00 .0% 0112952 571001 IN STATE CONFERE 5,675 0 5,675 616.21 2,020.00 3,038.79 46.5% 0112952 572000 OUT OF STATE TRA 2,000 0 2,000 323.37 400.00 1,276.63 36.2% 0112952 572001 OUT OF STATE CON 2,000 0 2,000 .00 315.00 1,685.00 15.8% 0112952 573000 DUES AND MEMBERS 8,000 0 8,000 5,664.00 100.00 2,236.00 72.1% 0112952 578007 REIMB OF LICENSE 2,000 0 2,000 -200.00 485.00 1,715.00 14.3% TOTAL IAM ORDIN MAINT 463,275 0 463,275 25,433.82 167,946.27 269,894.91 41.7% 0113051 EXEC-RACIAL&SOCIAL JUST PS 0113051 511000 SALARIES 863,076 0 863,076 442,185.04 .00 420,890.96 51.2% 0113051 512000 SALARIES & WAGES 30,000 0 30,000 1,432.94 .00 28,567.06 4.8% 0113051 515006 HOLIDAYS NON-UNI 6,616 0 6,616 4,550.55 .00 2,065.45 68.8% TOTAL EXEC-RACIAL&SOCIAL JUST PS 899,692 0 899,692 448,168.53 .00 451,523.47 49.8% 0113052 EXEC-RACIAL&SOCIAL JUST OM 0113052 524034 R&M - SERVICE CO 0 1,200 1,200 .00 .00 1,200.00 .0% 0113052 527001 RENTAL - BUILDIN 5,000 0 5,000 .00 .00 5,000.00 .0% 0113052 530000 PROFESSIONAL & T 200,000 -7,200 192,800 67,551.04 55,408.00 69,840.96 63.8% 0113052 530008 EMPLOYEE TRAININ 8,000 0 8,000 179.00 .00 7,821.00 2.2% 0113052 530028 SOFTWARE SERVICE 10,000 2,000 12,000 5,167.03 1,201.97 5,631.00 53.1% 0113052 530029 CUSTODIAL DETAIL 0 0 0 .00 .00 .00 .0% 0113052 530200 TRANSLATION SERV 80,000 0 80,000 4,916.63 5,082.37 70,001.00 12.5% 0113052 534003 POSTAGE 23,000 0 23,000 .00 .00 23,000.00 .0% 0113052 542000 OFFICE SUPPLIES 4,000 0 4,000 243.23 756.77 3,000.00 25.0% 0113052 542006 OFFICE FURNITURE 5,000 0 5,000 .00 .00 5,000.00 .0% 0113052 542007 COMPUTER EQUIPME 5,000 0 5,000 .00 .00 5,000.00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 11 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0113052 549000 FOOD SUPPLIES & 5,000 4,000 9,000 871.53 3,319.17 4,809.30 46.6% 0113052 558018 PROGRAM SUPPLIES 20,500 0 20,500 130.87 3.78 20,365.35 .7% 0113052 571000 IN STATE TRAVEL 1,000 0 1,000 .00 .00 1,000.00 .0% 0113052 572000 OUT OF STATE TRA 5,000 0 5,000 .00 .00 5,000.00 .0% 0113052 572001 OUT OF STATE CON 2,000 0 2,000 .00 .00 2,000.00 .0% TOTAL EXEC-RACIAL&SOCIAL JUST OM 373,500 0 373,500 79,059.33 65,772.06 228,668.61 38.8% 0113551 AUDITING PERSONAL SERVICES 0113551 511000 SALARIES 1,278,572 -500 1,278,072 629,165.73 .00 648,906.27 49.2% 0113551 511001 SALARIES - PROFE 0 0 0 .00 .00 .00 .0% 0113551 511300 WAGES 0 0 0 .00 .00 .00 .0% 0113551 512000 SALARIES & WAGES 6,000 0 6,000 .00 .00 6,000.00 .0% 0113551 513000 OVERTIME 7,890 0 7,890 1,802.29 .00 6,087.71 22.8% 0113551 514006 LONGEVITY 5,950 0 5,950 2,975.00 .00 2,975.00 50.0% 0113551 514008 OUT OF GRADE 0 0 0 .00 .00 .00 .0% 0113551 515006 HOLIDAYS NON-UNI 6,564 0 6,564 4,077.05 .00 2,486.95 62.1% 0113551 515011 HOLIDAYS - S.M.E 3,676 0 3,676 1,554.52 .00 2,121.48 42.3% 0113551 515012 PERFECT ATTENDAN 0 500 500 500.00 .00 .00 100.0% 0113551 519004 UNIFORM ALLOWANC 1,750 0 1,750 1,400.00 .00 350.00 80.0% 0113551 519013 OTHER LUMP SUM P 0 0 0 .00 .00 .00 .0% 0113551 519999 RESERVED FOR REV 0 0 0 .00 .00 .00 .0% TOTAL AUDITING PERSONAL SERVICES 1,310,402 0 1,310,402 641,474.59 .00 668,927.41 49.0% 0113552 AUDITING ORDINARY MAINTENANCE 0113552 524007 REPAIRS OFFICE E 0 0 0 .00 .00 .00 .0% 0113552 524034 MAINT CONTRACT-O 1,100 0 1,100 701.95 358.05 40.00 96.4% 0113552 527015 RENTALS EQUIPMEN 0 0 0 .00 .00 .00 .0% 0113552 527019 RENTAL-WATER COO 350 0 350 235.84 114.16 .00 100.0% 0113552 530000 PROFESSIONL & TE 7,000 0 7,000 .00 .00 7,000.00 .0% 0113552 530008 EMPLOYEE TRAININ 8,200 0 8,200 7,206.10 515.50 478.40 94.2% 0113552 530009 ACCOUNTING AND A 90,775 0 90,775 50,000.00 14,110.00 26,665.00 70.6% 0113552 530011 ADVERTISING 3,000 0 3,000 .00 .00 3,000.00 .0% 0113552 530022 APPRAISALS 0 0 0 .00 .00 .00 .0% 0113552 530028 SOFTWARE SERVICE 0 0 0 .00 .00 .00 .0% 0113552 534003 POSTAGE 15,000 -325 14,675 7,087.40 .00 7,587.60 48.3% 0113552 534006 EXPRESS/FREIGHT 0 0 0 .00 .00 .00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 12 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0113552 534015 FEE 575 0 575 .00 .00 575.00 .0% 0113552 542000 OFFICE SUPPLIES 5,500 0 5,500 1,151.42 823.58 3,525.00 35.9% 0113552 542001 PRINTING & STATI 17,600 -500 17,100 10,852.54 .00 6,247.46 63.5% 0113552 542005 OFFICE EQUIPMENT 0 0 0 .00 .00 .00 .0% 0113552 542006 OFFICE FURNITURE 0 0 0 .00 .00 .00 .0% 0113552 542008 BOOKS & BOOKBIND 300 0 300 .00 .00 300.00 .0% 0113552 542012 OTH EQUIPMENT NO 0 825 825 448.00 377.00 .00 100.0% 0113552 549000 FOOD SUPPLIES & 5,000 -2,000 3,000 1,100.00 150.00 1,750.00 41.7% 0113552 558004 MAGAZINES,NEWS,S 0 0 0 .00 .00 .00 .0% 0113552 558013 DEPARTMENTAL REP 5,000 0 5,000 .00 .00 5,000.00 .0% 0113552 558019 PROMOTIONAL MATE 0 2,000 2,000 1,794.00 .00 206.00 89.7% 0113552 571000 IN STATE TRAVEL 900 0 900 .00 .00 900.00 .0% 0113552 571001 IN STATE CONFERE 600 0 600 .00 240.00 360.00 40.0% 0113552 572000 OUT OF STATE TRA 0 0 0 .00 .00 .00 .0% 0113552 572001 OUT OF STATE CON 0 0 0 .00 .00 .00 .0% 0113552 573000 DUES AND MEMBERS 1,802 0 1,802 400.00 1,251.50 150.50 91.6% TOTAL AUDITING ORDINARY MAINTENANCE 162,702 0 162,702 80,977.25 17,939.79 63,784.96 60.8% 0113651 GRANTS DEV PERSONAL SERVICES 0113651 511000 SALARIES 288,210 0 288,210 160,731.62 .00 127,478.38 55.8% 0113651 515006 HOLIDAYS NON-UNI 2,308 0 2,308 1,662.73 .00 645.27 72.0% 0113651 519104 SALARY STIPEND 0 0 0 .00 .00 .00 .0% TOTAL GRANTS DEV PERSONAL SERVICES 290,518 0 290,518 162,394.35 .00 128,123.65 55.9% 0113652 GRANTS DEV ORDINARY MAINT 0113652 524007 REPAIRS OFFICE E 0 0 0 .00 .00 .00 .0% 0113652 530000 PROFESSIONL & TE 1,000 0 1,000 .00 .00 1,000.00 .0% 0113652 530008 EMPLOYEE TRAININ 4,000 0 4,000 714.39 .00 3,285.61 17.9% 0113652 530011 ADVERTISING 0 0 0 .00 .00 .00 .0% 0113652 542000 OFFICE SUPPLIES 750 0 750 .00 .00 750.00 .0% 0113652 542001 PRINTING & STATI 0 0 0 .00 .00 .00 .0% 0113652 542004 COMPUTER SUPPLIE 0 0 0 .00 .00 .00 .0% 0113652 542005 OFFICE EQUIPMENT 0 0 0 .00 .00 .00 .0% 0113652 542006 OFFICE FURNITURE 2,000 0 2,000 .00 .00 2,000.00 .0% 0113652 542007 COMPUTER EQUIPME 0 0 0 .00 .00 .00 .0% 0113652 558004 MAGAZINES,NEWS,S 3,000 0 3,000 516.00 .00 2,484.00 17.2%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 13 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0113652 571000 IN STATE TRAVEL 500 0 500 .00 .00 500.00 .0% 0113652 571001 IN STATE CONFERE 1,000 0 1,000 .00 720.00 280.00 72.0% 0113652 572000 OUT OF STATE TRA 4,000 0 4,000 .00 .00 4,000.00 .0% 0113652 572001 OUT OF STATE CON 4,000 0 4,000 .00 1,938.00 2,062.00 48.5% 0113652 573000 DUES AND MEMBERS 1,500 0 1,500 324.00 .00 1,176.00 21.6% TOTAL GRANTS DEV ORDINARY MAINT 21,750 0 21,750 1,554.39 2,658.00 17,537.61 19.4% 0113851 PROCUREMENT&CONTR SRVC PS 0113851 511000 SALARIES 651,588 0 651,588 351,478.61 .00 300,109.39 53.9% 0113851 512000 SALARIES & WAGES 0 0 0 .00 .00 .00 .0% 0113851 513000 OVERTIME 1,000 0 1,000 90.07 .00 909.93 9.0% 0113851 514006 LONGEVITY 1,000 0 1,000 250.00 .00 750.00 25.0% 0113851 514008 OUT OF GRADE 0 0 0 .00 .00 .00 .0% 0113851 515006 HOLIDAYS NON-UNI 4,256 0 4,256 3,101.88 .00 1,154.12 72.9% 0113851 515011 HOLIDAYS - S.M.E 659 0 659 435.20 .00 223.80 66.0% 0113851 515012 PERFECT ATTENDAN 0 0 0 .00 .00 .00 .0% 0113851 519004 UNIFORM ALLOWANC 700 0 700 700.00 .00 .00 100.0% 0113851 519005 SICK LEAVE BUYBA 0 0 0 .00 .00 .00 .0% 0113851 519013 OTHER LUMP SUM P 0 0 0 .00 .00 .00 .0% 0113851 519999 RESERVED FOR REV 0 0 0 .00 .00 .00 .0% TOTAL PROCUREMENT&CONTR SRVC PS 659,203 0 659,203 356,055.76 .00 303,147.24 54.0% 0113852 PROCUREMENT&CONTRCT SRVC OM 0113852 524007 REPAIRS OFFICE E 100 -80 20 .00 .00 20.00 .0% 0113852 524034 MAINT CONTRACT-O 990 0 990 629.28 70.72 290.00 70.7% 0113852 527015 RENTALS EQUIPMEN 0 0 0 .00 .00 .00 .0% 0113852 527019 RENTAL-WATER COO 350 0 350 232.44 117.56 .00 100.0% 0113852 530008 EMPLOYEE TRAININ 400 -160 240 240.00 .00 .00 100.0% 0113852 530011 ADVERTISING 8,500 -275 8,225 2,578.50 5,421.50 225.00 97.3% 0113852 530024 TUITION 4,500 0 4,500 2,824.49 1,675.51 .00 100.0% 0113852 530028 SOFTWARE SERVICE 500 -100 400 .00 .00 400.00 .0% 0113852 534003 POSTAGE 0 0 0 .00 .00 .00 .0% 0113852 542000 OFFICE SUPPLIES 9,800 -100 9,700 3,315.55 5,084.45 1,300.00 86.6% 0113852 542001 PRINTING & STATI 100 90 190 190.00 .00 .00 100.0% 0113852 542006 OFFICE FURNITURE 900 -400 500 .00 .00 500.00 .0% 0113852 542007 COMPUTER EQUIPME 0 0 0 .00 .00 .00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 14 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0113852 542008 BOOKS & BOOKBIND 0 0 0 .00 .00 .00 .0% 0113852 549000 FOOD SUPPLIES & 0 0 0 .00 .00 .00 .0% 0113852 558004 MAGAZINES,NEWS,S 150 0 150 128.50 21.50 .00 100.0% 0113852 571000 IN STATE TRAVEL 350 510 860 378.99 .00 481.01 44.1% 0113852 571001 IN STATE CONFERE 0 240 240 .00 .00 240.00 .0% 0113852 573000 DUES AND MEMBERS 1,075 275 1,350 1,350.00 .00 .00 100.0% TOTAL PROCUREMENT&CONTRCT SRVC OM 27,715 0 27,715 11,867.75 12,391.24 3,456.01 87.5% 0113951 FINANCE IC PERSONAL SERVICES 0113951 511000 SALARIES 0 0 0 .00 .00 .00 .0% 0113951 515006 HOLIDAYS NON-UNI 0 0 0 .00 .00 .00 .0% TOTAL FINANCE IC PERSONAL SERVICES 0 0 0 .00 .00 .00 .0% 0114151 BD OF ASSESSORS PERSONAL SVC 0114151 511000 SALARIES 643,216 0 643,216 322,953.62 .00 320,262.38 50.2% 0114151 511002 SALARIES - MONTH 19,308 0 19,308 11,262.86 .00 8,045.14 58.3% 0114151 512000 SALARIES & WAGES 0 0 0 .00 .00 .00 .0% 0114151 513000 OVERTIME 0 0 0 .00 .00 .00 .0% 0114151 514006 LONGEVITY 500 0 500 250.00 .00 250.00 50.0% 0114151 515006 HOLIDAYS NON-UNI 3,928 0 3,928 2,829.10 .00 1,098.90 72.0% 0114151 515011 HOLIDAYS - S.M.E 1,226 0 1,226 425.21 .00 800.79 34.7% 0114151 515012 PERFECT ATTENDAN 0 0 0 .00 .00 .00 .0% 0114151 519004 UNIFORM ALLOWANC 1,050 0 1,050 350.00 .00 700.00 33.3% 0114151 519013 OTHER LUMP SUM P 0 0 0 .00 .00 .00 .0% 0114151 519999 RESERVED FOR REV 0 0 0 .00 .00 .00 .0% TOTAL BD OF ASSESSORS PERSONAL SVC 669,228 0 669,228 338,070.79 .00 331,157.21 50.5% 0114152 BD OF ASSESSORS ORDINARY MAINT 0114152 524007 REPAIRS OFFICE E 500 0 500 .00 .00 500.00 .0% 0114152 524015 REPAIRS COMPUTER 0 0 0 .00 .00 .00 .0% 0114152 524033 R&M - SOFTWARE 0 0 0 .00 .00 .00 .0% 0114152 524034 MAINT CONTRACT-O 700 0 700 438.06 .00 261.94 62.6%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 15 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0114152 527019 RENTAL-WATER COO 500 0 500 195.70 304.30 .00 100.0% 0114152 530000 PROFESSIONL & TE 56,500 0 56,500 20,900.00 .00 35,600.00 37.0% 0114152 530010 LEGAL SERVICES 40,000 0 40,000 23,275.00 .00 16,725.00 58.2% 0114152 530011 ADVERTISING 500 0 500 .00 .00 500.00 .0% 0114152 530016 PROPERTY DATA SE 65,000 0 65,000 39,883.00 18,927.00 6,190.00 90.5% 0114152 530022 APPRAISALS 30,000 0 30,000 10,122.00 17,500.00 2,378.00 92.1% 0114152 530024 TUITION 6,800 0 6,800 1,895.00 .00 4,905.00 27.9% 0114152 530033 PERSONAL PROPERT 20,000 0 20,000 .00 .00 20,000.00 .0% 0114152 534003 POSTAGE 7,500 0 7,500 5,411.52 .00 2,088.48 72.2% 0114152 542000 OFFICE SUPPLIES 4,000 0 4,000 649.67 .00 3,350.33 16.2% 0114152 542001 PRINTING & STATI 1,500 0 1,500 1,201.00 .00 299.00 80.1% 0114152 542006 OFFICE FURNITURE 0 0 0 .00 .00 .00 .0% 0114152 542007 COMPUTER EQUIPME 1,000 0 1,000 .00 .00 1,000.00 .0% 0114152 542008 BOOKS & BOOKBIND 500 0 500 .00 .00 500.00 .0% 0114152 558002 ONLINE SUBSCRIPT 2,600 0 2,600 1,000.00 1,600.00 .00 100.0% 0114152 558004 MAGAZINES,NEWS,S 1,200 0 1,200 1,064.15 .00 135.85 88.7% 0114152 558006 UNIFORMS 500 0 500 449.34 .00 50.66 89.9% 0114152 571000 IN STATE TRAVEL 1,000 0 1,000 424.08 .00 575.92 42.4% 0114152 571001 IN STATE CONFERE 800 0 800 50.00 .00 750.00 6.3% 0114152 572001 OUT OF STATE CON 0 0 0 .00 .00 .00 .0% 0114152 573000 DUES AND MEMBERS 950 0 950 450.00 .00 500.00 47.4% 0114152 578010 RECORDINGS 900 0 900 .00 .00 900.00 .0% TOTAL BD OF ASSESSORS ORDINARY MAINT 242,950 0 242,950 107,408.52 38,331.30 97,210.18 60.0% 0114551 TREAS/COLL PERSONAL SERVICES 0114551 511000 SALARIES 745,782 -300 745,482 402,103.22 .00 343,378.78 53.9% 0114551 512000 SALARIES & WAGES 2,000 0 2,000 .00 .00 2,000.00 .0% 0114551 513000 OVERTIME 5,500 0 5,500 2,343.11 .00 3,156.89 42.6% 0114551 514006 LONGEVITY 2,700 0 2,700 1,100.00 .00 1,600.00 40.7% 0114551 514008 OUT OF GRADE 1,000 0 1,000 376.84 .00 623.16 37.7% 0114551 515006 HOLIDAYS NON-UNI 3,302 0 3,302 2,387.24 .00 914.76 72.3% 0114551 515011 HOLIDAYS - S.M.E 2,672 0 2,672 1,275.04 .00 1,396.96 47.7% 0114551 515012 PERFECT ATTENDAN 0 300 300 300.00 .00 .00 100.0% 0114551 519004 UNIFORM ALLOWANC 1,750 0 1,750 1,750.00 .00 .00 100.0% 0114551 519013 OTHER LUMP SUM P 0 0 0 .00 .00 .00 .0% 0114551 519999 RESERVED FOR REV 0 0 0 .00 .00 .00 .0% TOTAL TREAS/COLL PERSONAL SERVICES 764,706 0 764,706 411,635.45 .00 353,070.55 53.8% 0114552 TREAS/COLL ORDINARY MAINT 0114552 524007 REPAIRS OFFICE E 2,000 0 2,000 303.08 796.92 900.00 55.0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 16 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0114552 524036 CABLING NON CAPI 0 0 0 .00 .00 .00 .0% 0114552 527019 RENTAL-WATER COO 300 100 400 200.08 199.92 .00 100.0% 0114552 530000 PROFESSIONL & TE 142,350 -3,100 139,250 12,696.00 3,000.00 123,554.00 11.3% 0114552 530008 EMPLOYEE TRAININ 2,175 3,000 5,175 1,977.59 3,197.41 .00 100.0% 0114552 530011 ADVERTISING 4,000 0 4,000 3,052.50 947.50 .00 100.0% 0114552 530012 DATA PROCESSING/ 10,000 0 10,000 2,173.41 6,826.59 1,000.00 90.0% 0114552 530026 BANK CHARGES 75,000 0 75,000 191.88 .00 74,808.12 .3% 0114552 530028 SOFTWARE 0 0 0 .00 .00 .00 .0% 0114552 534003 POSTAGE 120,000 0 120,000 19,079.33 100,007.07 913.60 99.2% 0114552 534015 FEE 15,000 0 15,000 3,143.50 11,856.50 .00 100.0% 0114552 542000 OFFICE SUPPLIES 7,000 0 7,000 1,561.00 4,662.95 776.05 88.9% 0114552 542001 PRINTING & STATI 11,000 0 11,000 6,479.87 .00 4,520.13 58.9% 0114552 542005 OFFICE EQUIPMENT 1,000 0 1,000 .00 .00 1,000.00 .0% 0114552 542006 OFFICE FURNITURE 0 0 0 .00 .00 .00 .0% 0114552 542007 COMPUTER EQUIPME 0 0 0 .00 .00 .00 .0% 0114552 558004 MAGAZINES,NEWS,S 200 1,000 1,200 .00 .00 1,200.00 .0% 0114552 558006 UNIFORMS 0 0 0 .00 .00 .00 .0% 0114552 571000 IN STATE TRAVEL 3,000 0 3,000 1,455.20 544.80 1,000.00 66.7% 0114552 571001 IN STATE CONFERE 2,000 0 2,000 971.94 100.00 928.06 53.6% 0114552 573000 DUES AND MEMBERS 420 1,000 1,420 800.00 .00 620.00 56.3% 0114552 574000 INSURANCE PREMIU 3,000 0 3,000 2,600.00 .00 400.00 86.7% 0114552 574001 BUILDING INSURAN 0 0 0 .00 .00 .00 .0% 0114552 578010 RECORDINGS 9,000 -1,000 8,000 1,155.00 2,845.00 4,000.00 50.0% 0114552 578011 CERT OF NOTES & 0 0 0 .00 .00 .00 .0% 0114552 578012 LAND COURT PROCE 12,000 -1,000 11,000 .00 .00 11,000.00 .0% 0114552 585019 CABLING 0 0 0 .00 .00 .00 .0% TOTAL TREAS/COLL ORDINARY MAINT 419,445 0 419,445 57,840.38 134,984.66 226,619.96 46.0% 0114559 TREAS/COLL DEBT SERVICE 0114559 530027 BOND ISSUANCE CO 0 0 0 .00 .00 .00 .0% TOTAL TREAS/COLL DEBT SERVICE 0 0 0 .00 .00 .00 .0% 0115151 LAW PERSONAL SERVICES 0115151 511000 SALARIES 897,043 0 897,043 478,400.59 .00 418,642.41 53.3% 0115151 511002 SALARIES - MONTH 11,704 0 11,704 6,826.82 .00 4,877.18 58.3% 0115151 512000 SALARIES & WAGES 25,000 0 25,000 13,678.44 .00 11,321.56 54.7%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 17 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0115151 514006 LONGEVITY 0 0 0 .00 .00 .00 .0% 0115151 515006 HOLIDAYS NON-UNI 7,184 0 7,184 4,736.13 .00 2,447.87 65.9% 0115151 515011 HOLIDAYS - S.M.E 0 0 0 .00 .00 .00 .0% 0115151 515012 PERFECT ATTENDAN 0 0 0 .00 .00 .00 .0% 0115151 519013 OTHER LUMP SUM P 0 0 0 .00 .00 .00 .0% 0115151 519999 RESERVED FOR REV 0 0 0 .00 .00 .00 .0% TOTAL LAW PERSONAL SERVICES 940,931 0 940,931 503,641.98 .00 437,289.02 53.5% 0115152 LAW ORDINARY MAINTENANCE 0115152 524007 REPAIRS OFFICE E 0 0 0 .00 .00 .00 .0% 0115152 524034 R&M - SERVICE CO 700 0 700 510.78 189.22 .00 100.0% 0115152 527019 RENTAL-WATER COO 300 0 300 109.73 90.27 100.00 66.7% 0115152 530000 PROFESSIONL & TE 15,000 0 15,000 50.30 .00 14,949.70 .3% 0115152 530010 LEGAL SERVICES 550,000 0 550,000 215,318.80 39,361.76 295,319.44 46.3% 0115152 530024 TUITION 0 0 0 .00 .00 .00 .0% 0115152 534003 POSTAGE 100 0 100 77.55 .00 22.45 77.6% 0115152 538005 PHOTOGRAPHY 0 0 0 .00 .00 .00 .0% 0115152 542000 OFFICE SUPPLIES 2,000 0 2,000 266.72 133.28 1,600.00 20.0% 0115152 542001 PRINTING & STATI 400 0 400 274.95 .00 125.05 68.7% 0115152 542002 PHOTOCOPYING 50 0 50 .00 .00 50.00 .0% 0115152 542004 COMPUTER SUPPLIE 0 0 0 .00 .00 .00 .0% 0115152 542005 OFFICE EQUIPMENT 250 0 250 .00 .00 250.00 .0% 0115152 542006 OFFICE FURNITURE 7,500 0 7,500 1,100.00 .00 6,400.00 14.7% 0115152 542008 BOOKS & BOOKBIND 5,375 0 5,375 1,492.90 475.00 3,407.10 36.6% 0115152 558002 ONLINE SUBSCRIPT 12,000 0 12,000 7,295.00 1,755.00 2,950.00 75.4% 0115152 558004 MAGAZINES,NEWS,S 500 0 500 449.00 .00 51.00 89.8% 0115152 571000 IN STATE TRAVEL 1,500 0 1,500 .00 .00 1,500.00 .0% 0115152 571001 IN STATE CONFERE 750 0 750 245.00 .00 505.00 32.7% 0115152 573000 DUES AND MEMBERS 4,000 0 4,000 1,658.96 252.83 2,088.21 47.8% 0115152 576000 JUDGEMENTS/SETTL 0 0 0 .00 .00 .00 .0% 0115152 578010 RECORDINGS 1,500 0 1,500 259.82 .00 1,240.18 17.3% TOTAL LAW ORDINARY MAINTENANCE 601,925 0 601,925 229,109.51 42,257.36 330,558.13 45.1% 0115251 HUMAN RESOURCES 0115251 511000 SALARIES 1,467,047 0 1,467,047 761,931.39 .00 705,115.61 51.9% 0115251 511002 SALARIES - MONTH 0 0 0 .00 .00 .00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 18 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0115251 512000 SALARIES & WAGES 165,458 0 165,458 98,790.94 .00 66,667.06 59.7% 0115251 513000 OVERTIME 4,300 0 4,300 .00 .00 4,300.00 .0% 0115251 514006 LONGEVITY 0 0 0 .00 .00 .00 .0% 0115251 515006 HOLIDAYS NON-UNI 11,818 0 11,818 7,750.04 .00 4,067.96 65.6% 0115251 515011 HOLIDAYS - S.M.E 142 0 142 .00 .00 142.00 .0% 0115251 515012 PERFECT ATTENDAN 0 0 0 .00 .00 .00 .0% 0115251 519004 UNIFORM ALLOWANC 350 0 350 .00 .00 350.00 .0% 0115251 519013 OTHER LUMP SUM P 0 0 0 .00 .00 .00 .0% 0115251 519016 ED INCENTIVES SM 0 0 0 .00 .00 .00 .0% 0115251 519999 RESERVED FOR REV 0 0 0 .00 .00 .00 .0% TOTAL HUMAN RESOURCES 1,649,115 0 1,649,115 868,472.37 .00 780,642.63 52.7% 0115252 HUMAN RESOURCE ORDINARY MAINT 0115252 515001 GYM REIMBURSEMEN 4,000 0 4,000 .00 .00 4,000.00 .0% 0115252 524007 R&M - OFFICE EQU 0 0 0 .00 .00 .00 .0% 0115252 524027 R&M - FLOOR COVE 0 0 0 .00 .00 .00 .0% 0115252 524034 MAINT CONTRACT-O 2,000 1,900 3,900 1,188.06 2,188.74 523.20 86.6% 0115252 527019 RENTAL-WATER COO 300 0 300 162.06 137.94 .00 100.0% 0115252 530000 PROFESSIONL & TE 376,000 -3,836 372,164 101,534.68 57,294.13 213,335.25 42.7% 0115252 530008 EMPLOYEE TRAININ 55,000 0 55,000 3,633.00 380.00 50,987.00 7.3% 0115252 530011 ADVERTISING 50,000 -398 49,602 9,361.42 12,451.00 27,789.70 44.0% 0115252 530017 ARBITRATION SERV 75,000 0 75,000 12,415.08 12,084.92 50,500.00 32.7% 0115252 530024 TUITION 0 0 0 .00 .00 .00 .0% 0115252 534003 POSTAGE 100 0 100 .00 .00 100.00 .0% 0115252 538012 WELLNESS PROGRAM 6,000 0 6,000 395.75 904.25 4,700.00 21.7% 0115252 542000 OFFICE SUPPLIES 3,000 0 3,000 1,174.92 1,531.10 293.98 90.2% 0115252 542001 PRINTING & STATI 6,000 0 6,000 1,253.00 .00 4,747.00 20.9% 0115252 542004 COMPUTER SUPPLIE 0 0 0 .00 .00 .00 .0% 0115252 542006 OFFICE FURNITURE 0 0 0 .00 .00 .00 .0% 0115252 542007 COMPUTER EQUIPME 0 0 0 .00 .00 .00 .0% 0115252 549000 FOOD SUPPLIES & 200 1,936 2,136 2,135.94 .00 .00 100.0% 0115252 558004 MAGAZINES & PUBL 1,200 0 1,200 .00 .00 1,200.00 .0% 0115252 558006 UNIFORMS 0 398 398 397.88 .00 .00 100.0% 0115252 571000 IN STATE TRAVEL 0 0 0 .00 .00 .00 .0% 0115252 571001 IN STATE CONFERE 15,000 0 15,000 .00 .00 15,000.00 .0% 0115252 572000 OUT OF STATE TRA 5,000 0 5,000 .00 .00 5,000.00 .0% 0115252 572001 OUT OF STATE CON 10,000 0 10,000 .00 .00 10,000.00 .0% 0115252 573000 DUES AND MEMBERS 3,500 0 3,500 569.00 593.00 2,338.00 33.2% 0115252 578008 REIMB/ALLOWANCES 210 0 210 35.00 .00 175.00 16.7% 0115252 578014 NEIGHBORHOOD IMP 0 0 0 .00 .00 .00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 19 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0115252 578015 AWARDS 0 0 0 .00 .00 .00 .0% TOTAL HUMAN RESOURCE ORDINARY MAINT 612,510 0 612,510 134,255.79 87,565.08 390,689.13 36.2% 0115260 HUMAN RESOURCE SPECIAL ITEMS 0115260 519016 ED INCENTIVES SM 7,500 0 7,500 .00 .00 7,500.00 .0% 0115260 519017 EDUCATIONAL INCE 35,000 0 35,000 .00 .00 35,000.00 .0% 0115260 519018 ED INCENTIVE - F 10,000 0 10,000 .00 .00 10,000.00 .0% 0115260 519019 ED INCENTIVE - E 3,500 0 3,500 .00 .00 3,500.00 .0% 0115260 519020 SMEA EMPLOY FLUE 18,000 0 18,000 .00 .00 18,000.00 .0% 0115260 519024 NON-UNION EDUCAT 100,000 0 100,000 15,808.36 .00 84,191.64 15.8% 0115260 519028 EDUCATION INCENT 75,000 0 75,000 13,312.56 .00 61,687.44 17.8% 0115260 519029 FIRE FLUENCY BON 4,500 0 4,500 .00 .00 4,500.00 .0% 0115260 538014 MBTA PASS 500,000 0 500,000 40,761.95 359,238.05 100,000.00 80.0% 0115260 571150 SMEA B TRAINING/ 0 0 0 .00 .00 .00 .0% TOTAL HUMAN RESOURCE SPECIAL ITEMS 753,500 0 753,500 69,882.87 359,238.05 324,379.08 57.0% 0115551 INFO TECH PERSONAL SERVICES 0115551 511000 SALARIES 1,257,726 -2,250 1,255,476 615,852.75 .00 639,623.25 49.1% 0115551 512000 SALARIES & WAGES 0 0 0 .00 .00 .00 .0% 0115551 513000 OVERTIME 7,000 0 7,000 3,141.51 .00 3,858.49 44.9% 0115551 514006 LONGEVITY 3,950 0 3,950 1,875.00 .00 2,075.00 47.5% 0115551 514008 OUT OF GRADE 0 0 0 .00 .00 .00 .0% 0115551 515006 HOLIDAYS NON-UNI 6,850 0 6,850 4,086.28 .00 2,763.72 59.7% 0115551 515011 HOLIDAYS - S.M.E 2,614 0 2,614 1,544.61 .00 1,069.39 59.1% 0115551 515012 PERFECT ATTENDAN 0 1,900 1,900 1,900.00 .00 .00 100.0% 0115551 519004 UNIFORM ALLOWANC 350 350 700 700.00 .00 .00 100.0% 0115551 519013 OTHER LUMP SUM P 0 0 0 .00 .00 .00 .0% 0115551 519015 AUTO ALLOWANCE 0 0 0 .00 .00 .00 .0% 0115551 519999 RESERVED FOR REV 0 0 0 .00 .00 .00 .0% TOTAL INFO TECH PERSONAL SERVICES 1,278,490 0 1,278,490 629,100.15 .00 649,389.85 49.2% 0115552 INFO TECH ORDINARY MAINTENANCE 0115552 524007 REPAIRS OFFICE E 0 0 0 .00 .00 .00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 20 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0115552 524015 REPAIRS COMPUTER 89,850 0 89,850 5,644.04 121.16 84,084.80 6.4% 0115552 524033 MAINT SOFTWARE 2,657,514 0 2,657,514 1,679,835.89 31,776.85 945,901.26 64.4% 0115552 524034 R&M - SERVICE CO 300 0 300 .00 .00 300.00 .0% 0115552 524036 CABLING NON CAPI 1,443 0 1,443 .00 .00 1,443.00 .0% 0115552 527006 LEASE - PHOTOCPI 70,000 0 70,000 32,356.94 33,643.06 4,000.00 94.3% 0115552 527018 POSTAGE MACHINE 0 0 0 .00 .00 .00 .0% 0115552 527019 RENTAL-WATER COO 300 0 300 59.36 90.64 150.00 50.0% 0115552 530000 PROFESSIONL & TE 103,700 0 103,700 40,267.01 22,500.00 40,932.99 60.5% 0115552 530008 EMPLOYEE TRAININ 25,000 0 25,000 3,505.50 .00 21,494.50 14.0% 0115552 530011 ADVERTISING 0 0 0 .00 .00 .00 .0% 0115552 530028 SOFTWARE 0 0 0 .00 .00 .00 .0% 0115552 530032 E-RATE 0 0 0 .00 .00 .00 .0% 0115552 534001 PHONE MAINTENANC 400 0 400 .00 .00 400.00 .0% 0115552 534002 CELLUAR & PAGING 528,000 0 528,000 259,094.41 258,745.59 10,160.00 98.1% 0115552 534003 POSTAGE 200 0 200 .00 .00 200.00 .0% 0115552 534007 PSTN-USAGE 172,600 0 172,600 69,056.93 64,425.30 39,117.77 77.3% 0115552 534008 WEB SITE COSTS 36,200 0 36,200 33,000.00 .00 3,200.00 91.2% 0115552 534009 INTERNET MAINTEN 62,580 0 62,580 37,723.28 24,776.72 80.00 99.9% 0115552 542000 OFFICE SUPPLIES 1,000 0 1,000 178.08 530.30 291.62 70.8% 0115552 542001 PRINTING & STATI 0 0 0 .00 .00 .00 .0% 0115552 542004 COMPUTER SUPPLIE 10,000 0 10,000 .00 6,000.00 4,000.00 60.0% 0115552 542006 OFFICE FURNITURE 0 0 0 .00 .00 .00 .0% 0115552 542007 COMPUTER EQUIPME 348,800 0 348,800 3,516.41 11,208.75 334,074.84 4.2% 0115552 542010 CELLULAR DEVICES 17,800 0 17,800 10,089.02 7,710.98 .00 100.0% 0115552 542011 PHOTOCOPIER NOT 0 0 0 .00 .00 .00 .0% 0115552 558006 UNIFORMS 0 0 0 .00 .00 .00 .0% 0115552 571000 IN STATE TRAVEL 13,200 0 13,200 .00 .00 13,200.00 .0% 0115552 571001 IN STATE CONFERE 4,000 0 4,000 .00 .00 4,000.00 .0% 0115552 572000 OUT OF STATE TRA 0 0 0 .00 .00 .00 .0% 0115552 572001 OUT OF STATE CON 0 0 0 .00 .00 .00 .0% 0115552 573000 DUES AND MEMBERS 1,900 0 1,900 .00 .00 1,900.00 .0% 0115552 578037 COVID 19 OM EXP 0 0 0 .00 .00 .00 .0% 0115552 585019 CABLEING 40,000 0 40,000 9,870.00 1,670.00 28,460.00 28.9% TOTAL INFO TECH ORDINARY MAINTENANCE 4,184,787 0 4,184,787 2,184,196.87 463,199.35 1,537,390.78 63.3% 0115558 INFORMATION TECHNOLOGY-CAPITAL 0115558 585002 EQUIPMENT-COMMUN 0 0 0 .00 .00 .00 .0% 0115558 585014 COMPUTER EQUIPME 0 0 0 .00 .00 .00 .0% TOTAL INFORMATION TECHNOLOGY-CAPITAL 0 0 0 .00 .00 .00 .0% 0115560 INFORMATION TECHNOLOGY SPECIAL

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 21 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0115560 578037 COVID 19 OM EXP 0 0 0 .00 .00 .00 .0% TOTAL INFORMATION TECHNOLOGY SPECIAL 0 0 0 .00 .00 .00 .0% 0115751 COMMUNICATIONS PERSONAL SVC 0115751 511000 SALARIES 1,033,303 0 1,033,303 485,551.58 .00 547,751.42 47.0% 0115751 512000 SALARIES & WAGES 0 0 0 .00 .00 .00 .0% 0115751 513000 OVERTIME 1,368 0 1,368 197.80 .00 1,170.20 14.5% 0115751 514006 LONGEVITY 0 0 0 .00 .00 .00 .0% 0115751 515006 HOLIDAYS NON-UNI 7,848 0 7,848 4,536.37 .00 3,311.63 57.8% 0115751 515011 HOLIDAYS - S.M.E 432 0 432 206.06 .00 225.94 47.7% 0115751 515012 PERFECT ATTENDAN 0 0 0 .00 .00 .00 .0% 0115751 519004 UNIFORM ALLOWANC 350 0 350 350.00 .00 .00 100.0% 0115751 519013 OTHER LUMP SUM P 0 0 0 .00 .00 .00 .0% 0115751 519030 COVID19 PERSONAL 0 0 0 .00 .00 .00 .0% 0115751 527019 RENTAL-WATER COO 0 0 0 .00 .00 .00 .0% TOTAL COMMUNICATIONS PERSONAL SVC 1,043,301 0 1,043,301 490,841.81 .00 552,459.19 47.0% 0115752 COMMUNICATIONS ORDINARY MAINT 0115752 524006 REPAIRS-COMMUN. 500 0 500 .00 .00 500.00 .0% 0115752 524034 MAINT CONTRACT-O 1,250 0 1,250 967.45 .00 282.55 77.4% 0115752 527001 RENTAL - BUILDIN 0 0 0 .00 .00 .00 .0% 0115752 527015 RENTALS EQUIPMEN 0 0 0 .00 .00 .00 .0% 0115752 530000 PROFESSIONL & TE 137,150 -6,000 131,150 50,185.87 35,138.83 45,825.30 65.1% 0115752 530008 EMPLOYEE TRAININ 2,500 0 2,500 .00 .00 2,500.00 .0% 0115752 530011 ADVERTISING 0 0 0 .00 .00 .00 .0% 0115752 530018 POLICE DETAIL 0 0 0 .00 .00 .00 .0% 0115752 530020 FIRE DETAIL 0 0 0 .00 .00 .00 .0% 0115752 530028 SOFTWARE SERVICE 18,500 0 18,500 3,657.69 1,585.11 13,257.20 28.3% 0115752 530029 CUSTODIAL DETAIL 700 0 700 .00 .00 700.00 .0% 0115752 534003 POSTAGE 19,800 0 19,800 6,657.15 .00 13,142.85 33.6% 0115752 534006 EXPRESS/FREIGHT 0 0 0 .00 .00 .00 .0% 0115752 534010 BAPERN LINE RENT 0 0 0 .00 .00 .00 .0% 0115752 534016 AUTOMATED CALL S 25,000 -2,000 23,000 .00 22,926.07 73.93 99.7% 0115752 540000 SUPPLIES 3,500 0 3,500 1,685.24 .00 1,814.76 48.1% 0115752 542000 OFFICE SUPPLIES 1,100 3,000 4,100 3,505.07 157.63 437.30 89.3%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 22 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0115752 542001 PRINTING & STATI 42,400 0 42,400 10,991.98 2,011.11 29,396.91 30.7% 0115752 542006 OFFICE FURNITURE 2,500 0 2,500 .00 .00 2,500.00 .0% 0115752 542007 COMPUTER EQUIPME 0 0 0 .00 .00 .00 .0% 0115752 549000 FOOD SUPPLIES & 0 0 0 .00 .00 .00 .0% 0115752 553001 SIGNS AND CONES 0 0 0 .00 .00 .00 .0% 0115752 558002 ONLINE SUBSCRIPT 16,055 0 16,055 7,352.52 3,309.14 5,393.34 66.4% 0115752 558004 MAGAZINES/SUBSCR 1,355 0 1,355 400.26 954.74 .00 100.0% 0115752 571000 IN STATE TRAVEL 0 0 0 .00 .00 .00 .0% 0115752 572000 OUT OF STATE TRA 0 0 0 .00 .00 .00 .0% 0115752 573000 DUES AND MEMBERS 0 0 0 .00 .00 .00 .0% 0115752 578010 RECORDINGS 0 0 0 .00 .00 .00 .0% 0115752 578014 NEIGHBORHOOD IMP 3,200 5,000 8,200 4,680.65 1,691.46 1,827.89 77.7% 0115752 578037 COVID 19 OM EXP 0 0 0 .00 .00 .00 .0% TOTAL COMMUNICATIONS ORDINARY MAINT 275,510 0 275,510 90,083.88 67,774.09 117,652.03 57.3% 0115760 COMMUNICATION SPECIAL ITEM 0115760 578037 COVID 19 OM EXP 0 0 0 .00 .00 .00 .0% TOTAL COMMUNICATION SPECIAL ITEM 0 0 0 .00 .00 .00 .0% 0115851 OFFICE OF IMMIGRANT AFFAIR PS 0115851 511000 SALARIES 1,067,893 0 1,067,893 545,959.40 .00 521,933.60 51.1% 0115851 512000 SALARIES & WAGES 145,635 0 145,635 7,312.00 .00 138,323.00 5.0% 0115851 515006 HOLIDAYS NON-UNI 8,912 0 8,912 5,348.68 .00 3,563.32 60.0% TOTAL OFFICE OF IMMIGRANT AFFAIR PS 1,222,440 0 1,222,440 558,620.08 .00 663,819.92 45.7% 0115852 OFFICE OF IMMIGRANT AFFAIR OM 0115852 527019 RENTAL-WATER COO 0 0 0 .00 .00 .00 .0% 0115852 530000 PROFESSIONAL & T 142,064 -1,200 140,864 55,486.03 798.40 84,579.57 40.0% 0115852 530008 EMPLOYEE TRAININ 10,000 0 10,000 798.00 .00 9,202.00 8.0% 0115852 530028 SOFTWARE SERVICE 25,000 0 25,000 .00 .00 25,000.00 .0% 0115852 530029 CUSTODIAL DETAIL 0 420 420 420.00 .00 .00 100.0% 0115852 530200 TRANSLATION SERV 15,000 0 15,000 250.00 .00 14,750.00 1.7%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 23 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0115852 542000 OFFICE SUPPLIES 3,000 0 3,000 67.17 617.83 2,315.00 22.8% 0115852 542001 PRINTING & STATI 8,500 0 8,500 2,980.00 .00 5,520.00 35.1% 0115852 542006 OFFICE FURNITURE 1,500 0 1,500 399.98 1,100.02 .00 100.0% 0115852 571000 IN STATE TRAVEL 300 0 300 117.54 .00 182.46 39.2% 0115852 572000 OUT OF STATE TRA 0 1,200 1,200 861.89 338.11 .00 100.0% 0115852 573000 DUES AND MEMBERS 1,380 0 1,380 .00 561.00 819.00 40.7% 0115852 578014 NEIGHBORHOOD IMP 15,000 -420 14,580 1,776.83 2,231.62 10,571.55 27.5% TOTAL OFFICE OF IMMIGRANT AFFAIR OM 221,744 0 221,744 63,157.44 5,646.98 152,939.58 31.0% 0115951 PEG ACCESS PERSONAL SERVICES 0115951 511000 SALARIES 236,035 8,150 244,185 131,470.64 .00 112,714.36 53.8% 0115951 512000 SALARIES & WAGES 53,663 -509 53,154 14,972.68 .00 38,181.32 28.2% 0115951 515006 HOLIDAYS NON-UNI 900 509 1,409 1,408.61 .00 .39 100.0% TOTAL PEG ACCESS PERSONAL SERVICES 290,598 8,150 298,748 147,851.93 .00 150,896.07 49.5% 0115952 PEG ACCESS ORDINARY MAINTENANC 0115952 524012 R&M - AUDIO/VISU 24,950 0 24,950 9,043.70 10,668.50 5,237.80 79.0% 0115952 527015 RENTALS EQUIPMEN 2,500 0 2,500 .00 .00 2,500.00 .0% 0115952 527019 RENTAL-WATER COO 120 250 370 123.18 96.82 150.00 59.5% 0115952 530000 PROFESSIONAL & T 25,000 -3,250 21,750 189.30 18,074.64 3,486.06 84.0% 0115952 530008 EMPLOYEE TRAININ 2,500 0 2,500 .00 .00 2,500.00 .0% 0115952 530010 LEGAL SERVICES 7,500 3,000 10,500 7,505.03 100.00 2,894.97 72.4% 0115952 530011 ADVERTISING 600 0 600 .00 .00 600.00 .0% 0115952 530028 SOFTWARE SERVICE 6,500 0 6,500 106.24 .00 6,393.76 1.6% 0115952 530029 CUSTODIAL DETAIL 1,000 0 1,000 .00 .00 1,000.00 .0% 0115952 534003 POSTAGE 150 0 150 .00 .00 150.00 .0% 0115952 534006 EXPRESS/FREIGHT 300 0 300 .00 .00 300.00 .0% 0115952 534011 LICENSING FEES 3,800 0 3,800 .00 .00 3,800.00 .0% 0115952 542000 OFFICE SUPPLIES 1,000 0 1,000 346.50 153.50 500.00 50.0% 0115952 542001 PRINTING & STATI 2,900 0 2,900 .00 .00 2,900.00 .0% 0115952 542006 OFFICE FURNITURE 1,000 0 1,000 .00 .00 1,000.00 .0% 0115952 542007 COMPUTER EQUIPME 2,000 0 2,000 .00 .00 2,000.00 .0% 0115952 551010 AUDIO VISUAL SUP 6,843 0 6,843 2,998.02 3,552.15 292.83 95.7% 0115952 571000 IN STATE TRAVEL 300 0 300 .00 .00 300.00 .0% 0115952 573000 DUES AND MEMBERS 800 0 800 .00 .00 800.00 .0% TOTAL PEG ACCESS ORDINARY MAINTENANC 89,763 0 89,763 20,311.97 32,645.61 36,805.42 59.0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 24 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0116151 CITY CLERK PERSONAL SERVICES 0116151 511000 SALARIES 897,246 -13,746 883,500 474,065.94 .00 409,433.80 53.7% 0116151 512000 SALARIES & WAGES 30,000 0 30,000 15,860.69 .00 14,139.31 52.9% 0116151 512002 SUMMER YOUTH EMP 0 0 0 .00 .00 .00 .0% 0116151 513000 OVERTIME 2,854 0 2,854 41.71 .00 2,812.29 1.5% 0116151 514006 LONGEVITY 5,200 0 5,200 3,350.00 .00 1,850.00 64.4% 0116151 515006 HOLIDAYS NON-UNI 4,462 0 4,462 2,980.02 .00 1,481.98 66.8% 0116151 515011 HOLIDAYS - S.M.E 2,730 0 2,730 1,053.98 .00 1,676.02 38.6% 0116151 515012 PERFECT ATTENDAN 0 0 0 .00 .00 .00 .0% 0116151 519004 UNIFORM ALLOWANC 2,100 0 2,100 2,100.00 .00 .00 100.0% 0116151 519005 SICK LEAVE BUYBA 0 13,746 13,746 13,746.26 .00 .00 100.0% 0116151 519013 OTHER LUMP SUM P 0 0 0 .00 .00 .00 .0% 0116151 519999 RESERVED FOR REV 0 0 0 .00 .00 .00 .0% TOTAL CITY CLERK PERSONAL SERVICES 944,592 0 944,592 513,198.60 .00 431,393.40 54.3% 0116152 CITY CLERK ORDINARY MAINT 0116152 524007 REPAIRS OFFICE E 1,600 0 1,600 410.00 340.00 850.00 46.9% 0116152 524033 R&M - SOFTWARE 93,650 0 93,650 20,637.32 22,699.67 50,313.01 46.3% 0116152 524034 R&M - SERVICE CO 3,400 0 3,400 1,018.81 1,481.19 900.00 73.5% 0116152 527006 LEASE - PHOTOCPI 0 0 0 .00 .00 .00 .0% 0116152 527013 RENTAL - STORAGE 28,068 0 28,068 11,603.02 6,396.98 10,068.00 64.1% 0116152 527018 POSTAGE MACHINE 9,320 0 9,320 4,540.02 4,559.98 220.00 97.6% 0116152 527019 RENTAL-WATER COO 400 0 400 199.28 200.72 .00 100.0% 0116152 530000 PROFESSIONL & TE 0 0 0 .00 .00 .00 .0% 0116152 530008 EMPLOYEE TRAININ 6,365 0 6,365 165.00 .00 6,200.00 2.6% 0116152 530011 ADVERTISING 2,550 0 2,550 216.00 1,364.00 970.00 62.0% 0116152 534003 POSTAGE 75,000 -960 74,040 30,000.00 .00 44,040.00 40.5% 0116152 542000 OFFICE SUPPLIES 10,500 0 10,500 1,186.01 4,703.14 4,610.85 56.1% 0116152 542001 PRINTING & STATI 3,550 0 3,550 755.00 20.00 2,775.00 21.8% 0116152 542005 OFFICE EQUIPMENT 3,500 0 3,500 566.20 735.78 2,198.02 37.2% 0116152 542006 OFFICE FURNITURE 30,000 960 30,960 .00 30,960.00 .00 100.0% 0116152 542007 COMPUTER EQUIPME 0 0 0 .00 .00 .00 .0% 0116152 542008 BOOKS & BOOKBIND 2,650 0 2,650 239.80 2,000.00 410.20 84.5% 0116152 549000 FOOD SUPPLIES & 0 0 0 .00 .00 .00 .0% 0116152 558004 MAGAZINES/SUBSCR 0 0 0 .00 .00 .00 .0% 0116152 558012 BADGES,EMBLEMS,T 4,500 0 4,500 .00 .00 4,500.00 .0% 0116152 571001 IN STATE CONFERE 950 0 950 .00 .00 950.00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 25 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0116152 572001 OUT OF STATE CON 4,300 0 4,300 .00 .00 4,300.00 .0% 0116152 573000 DUES AND MEMBERS 1,900 0 1,900 897.00 285.00 718.00 62.2% 0116152 574000 INSURANCE PREMIU 1,700 0 1,700 238.00 .00 1,462.00 14.0% 0116152 578001 CREDIT CARD CONV 3,000 0 3,000 1,233.98 1,766.02 .00 100.0% TOTAL CITY CLERK ORDINARY MAINT 286,903 0 286,903 73,905.44 77,512.48 135,485.08 52.8% 0116158 CITY CLERK CAPITAL 0116158 585010 OFFICE EQUIPMENT 0 0 0 .00 .00 .00 .0% TOTAL CITY CLERK CAPITAL 0 0 0 .00 .00 .00 .0% 0116160 CITY CLERK SPECIAL ITEMS 0116160 558020 GRANT MATCH 0 0 0 .00 .00 .00 .0% TOTAL CITY CLERK SPECIAL ITEMS 0 0 0 .00 .00 .00 .0% 0116251 ELECTIONS PERSONAL SERVICES 0116251 511000 SALARIES 369,060 0 369,060 198,033.84 .00 171,026.16 53.7% 0116251 511002 SALARIES - MONTH 11,125 0 11,125 4,452.00 .00 6,673.00 40.0% 0116251 512000 SALARIES & WAGES 206,227 -600 205,627 57,147.59 .00 148,479.41 27.8% 0116251 513000 OVERTIME 15,569 0 15,569 6,087.68 .00 9,481.32 39.1% 0116251 514006 LONGEVITY 1,700 0 1,700 850.00 .00 850.00 50.0% 0116251 515006 HOLIDAYS NON-UNI 864 0 864 621.93 .00 242.07 72.0% 0116251 515011 HOLIDAYS - S.M.E 2,094 0 2,094 1,016.03 .00 1,077.97 48.5% 0116251 515012 PERFECT ATTENDAN 0 600 600 600.00 .00 .00 100.0% 0116251 519004 UNIFORM ALLOWANC 1,400 0 1,400 350.00 .00 1,050.00 25.0% 0116251 519013 OTHER LUMP SUM P 0 0 0 .00 .00 .00 .0% 0116251 519999 RESERVED FOR REV 0 0 0 .00 .00 .00 .0% TOTAL ELECTIONS PERSONAL SERVICES 608,039 0 608,039 269,159.07 .00 338,879.93 44.3% 0116252 ELECTIONS ORDINARY MAINTENANCE 0116252 524013 REPAIRS-TOOLS & 0 0 0 .00 .00 .00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 26 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0116252 524034 MAINT CONTRACT-O 2,560 0 2,560 1,531.09 871.24 157.67 93.8% 0116252 527001 RENTALS-BUILDING 3,780 0 3,780 1,620.00 .00 2,160.00 42.9% 0116252 527016 RENTALS - VEHICL 0 0 0 .00 .00 .00 .0% 0116252 527019 RENTAL-WATER COO 500 0 500 80.28 419.72 .00 100.0% 0116252 530000 PROFESSIONL & TE 36,655 0 36,655 570.00 15,000.00 21,085.00 42.5% 0116252 530011 ADVERTISING 6,500 -800 5,700 1,228.98 612.50 3,858.52 32.3% 0116252 530020 FIRE DETAIL 0 0 0 .00 .00 .00 .0% 0116252 534003 POSTAGE 46,000 0 46,000 40,050.73 149.27 5,800.00 87.4% 0116252 542000 OFFICE SUPPLIES 8,000 0 8,000 2,695.98 2,465.73 2,838.29 64.5% 0116252 542001 PRINTING & STATI 38,800 0 38,800 4,268.44 .00 34,531.56 11.0% 0116252 542005 OFFICE EQUIPMENT 1,500 0 1,500 127.76 .00 1,372.24 8.5% 0116252 542006 OFFICE FURNITURE 0 0 0 .00 .00 .00 .0% 0116252 542008 BOOKS & BOOKBIND 500 0 500 .00 .00 500.00 .0% 0116252 542012 OTH EQUIPMENT NO 0 0 0 .00 .00 .00 .0% 0116252 549000 FOOD SUPPLIES & 2,750 0 2,750 1,400.44 .00 1,349.56 50.9% 0116252 558006 UNIFORMS 0 0 0 .00 .00 .00 .0% 0116252 571000 IN STATE TRAVEL 0 1,565 1,565 1,490.42 .00 74.58 95.2% 0116252 571001 IN STATE CONFERE 1,500 -765 735 735.00 .00 .00 100.0% 0116252 573000 DUES AND MEMBERS 200 0 200 .00 .00 200.00 .0% 0116252 578016 CENSUS 34,075 0 34,075 7,666.48 .00 26,408.52 22.5% 0116252 578017 SPECIAL ELECTION 0 0 0 .00 .00 .00 .0% TOTAL ELECTIONS ORDINARY MAINTENANCE 183,320 0 183,320 63,465.60 19,518.46 100,335.94 45.3% 0116258 ELECTIONS CAPITAL OUTLAY 0116258 585000 EQUIPMENT 0 0 0 .00 .00 .00 .0% TOTAL ELECTIONS CAPITAL OUTLAY 0 0 0 .00 .00 .00 .0% 0116551 LICENSING COMM PERSONAL SERV 0116551 511002 SALARIES - MONTH 11,628 0 11,628 6,783.00 .00 4,845.00 58.3% 0116551 515006 HOLIDAYS NON-UNI 0 0 0 .00 .00 .00 .0% TOTAL LICENSING COMM PERSONAL SERV 11,628 0 11,628 6,783.00 .00 4,845.00 58.3% 0117651 BOARD OF APPEALS PERSONAL SVC 0117651 511000 SALARIES 0 0 0 .00 .00 .00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 27 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0117651 511002 SALARIES - MONTH 0 0 0 .00 .00 .00 .0% 0117651 515006 HOLIDAYS NON-UNI 0 0 0 .00 .00 .00 .0% TOTAL BOARD OF APPEALS PERSONAL SVC 0 0 0 .00 .00 .00 .0% 0117652 BOARD OF APPEALS ORDINARY MAIN 0117652 534003 POSTAGE 0 0 0 .00 .00 .00 .0% 0117652 542000 OFFICE SUPPLIES 0 0 0 .00 .00 .00 .0% 0117652 542001 PRINTING & STATI 0 0 0 .00 .00 .00 .0% 0117652 571001 IN STATE CONFERE 0 0 0 .00 .00 .00 .0% TOTAL BOARD OF APPEALS ORDINARY MAIN 0 0 0 .00 .00 .00 .0% 0118151 OSPCD-PLANNING PERSONAL SVC 0118151 511000 SALARIES 1,054,178 0 1,054,178 572,139.76 .00 482,038.24 54.3% 0118151 511002 SALARIES - MONTH 78,923 0 78,923 44,796.23 .00 34,126.77 56.8% 0118151 512000 SALARIES & WAGES 40,000 0 40,000 14,092.26 .00 25,907.74 35.2% 0118151 514006 LONGEVITY 0 0 0 .00 .00 .00 .0% 0118151 515006 HOLIDAYS NON-UNI 8,278 0 8,278 6,220.29 .00 2,057.71 75.1% 0118151 515011 HOLIDAYS - S.M.E 0 0 0 .00 .00 .00 .0% 0118151 519004 UNIFORM ALLOWANC 0 0 0 .00 .00 .00 .0% 0118151 519015 AUTO ALLOWANCE 0 0 0 .00 .00 .00 .0% 0118151 519999 RESERVED FOR REV 0 0 0 .00 .00 .00 .0% TOTAL OSPCD-PLANNING PERSONAL SVC 1,181,379 0 1,181,379 637,248.54 .00 544,130.46 53.9% 0118152 OSPCD-PLANNING ORDINARY MAINT 0118152 524007 R&M - OFFICE EQU 0 0 0 .00 .00 .00 .0% 0118152 524034 R&M - SERVICE CO 0 0 0 .00 .00 .00 .0% 0118152 527000 RENTALS 0 0 0 .00 .00 .00 .0% 0118152 527001 RENTAL - BUILDIN 500 0 500 .00 .00 500.00 .0% 0118152 527014 RENTAL - TABLES 100 0 100 .00 .00 100.00 .0% 0118152 530000 PROFESSIONL & TE 235,000 -802 234,198 15,120.00 92,700.00 126,377.66 46.0% 0118152 530011 ADVERTISING 3,000 0 3,000 .00 .00 3,000.00 .0% 0118152 530028 SOFTWARE 63,000 0 63,000 .00 14,020.94 48,979.06 22.3%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 28 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0118152 530029 CUSTODIAL DETAIL 0 0 0 .00 .00 .00 .0% 0118152 534003 POSTAGE 100 0 100 .00 .00 100.00 .0% 0118152 534005 PRINTING 0 0 0 .00 .00 .00 .0% 0118152 538010 ADMINISTRATION C 0 0 0 .00 .00 .00 .0% 0118152 540000 SUPPLIES 250 0 250 .00 .00 250.00 .0% 0118152 542000 OFFICE SUPPLIES 0 0 0 .00 .00 .00 .0% 0118152 542001 PRINTING & STATI 2,680 0 2,680 .00 .00 2,680.00 .0% 0118152 542004 COMPUTER SUPPLIE 0 0 0 .00 .00 .00 .0% 0118152 542005 OFFICE EQUIPMENT 0 0 0 .00 .00 .00 .0% 0118152 542006 OFFICE FURNITURE 0 0 0 .00 .00 .00 .0% 0118152 542007 COMPUTER EQUIPME 0 0 0 .00 .00 .00 .0% 0118152 542008 BOOKS & BOOKBIND 0 261 261 261.34 .00 .00 100.0% 0118152 542012 OTH EQUIPMENT NO 0 0 0 .00 .00 .00 .0% 0118152 549000 FOOD SUPPLIES & 100 0 100 .00 90.11 9.89 90.1% 0118152 553001 SIGNS AND CONES 0 0 0 .00 .00 .00 .0% 0118152 558002 ONLINE SUBSCRIPT 7,300 0 7,300 1,900.00 2,300.00 3,100.00 57.5% 0118152 558004 MAGAZINES & PUBL 0 0 0 .00 .00 .00 .0% 0118152 558006 UNIFORMS 0 0 0 .00 .00 .00 .0% 0118152 558011 FLOWERS & FLAGS 0 0 0 .00 .00 .00 .0% 0118152 558019 PROMOTIONAL MATE 0 0 0 .00 .00 .00 .0% 0118152 571000 IN STATE TRAVEL 0 0 0 .00 .00 .00 .0% 0118152 571001 IN STATE CONFERE 0 0 0 .00 .00 .00 .0% 0118152 572000 OUT OF STATE TRA 0 0 0 .00 .00 .00 .0% 0118152 572001 OUT OF STATE CON 0 0 0 .00 .00 .00 .0% 0118152 573000 DUES AND MEMBERS 1,500 541 2,041 1,545.00 .00 496.00 75.7% 0118152 578010 RECORDINGS 150 0 150 .00 .00 150.00 .0% TOTAL OSPCD-PLANNING ORDINARY MAINT 313,680 0 313,680 18,826.34 109,111.05 185,742.61 40.8% 0118251 OSPCD-ADMIN PERSONAL SERVICES 0118251 511000 SALARIES 660,416 0 660,416 311,171.43 .00 349,244.57 47.1% 0118251 512000 SALARIES & WAGES 9,600 0 9,600 3,403.12 .00 6,196.88 35.4% 0118251 515006 HOLIDAYS NON-UNI 4,004 0 4,004 4,989.64 .00 -985.64 124.6% 0118251 519013 OTHER LUMP SUM P 0 0 0 .00 .00 .00 .0% 0118251 519015 AUTO ALLOWANCE 0 0 0 .00 .00 .00 .0% 0118251 519999 RESERVED FOR REV 0 0 0 .00 .00 .00 .0% TOTAL OSPCD-ADMIN PERSONAL SERVICES 674,020 0 674,020 319,564.19 .00 354,455.81 47.4% 0118252 OSPCD-ADMIN ORDINARY MAINT 0118252 524007 R&M - OFFICE EQU 0 0 0 .00 .00 .00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 29 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0118252 524034 MAINT CONTRACT-O 12,500 0 12,500 4,741.30 7,000.00 758.70 93.9% 0118252 527000 RENTALS 0 0 0 .00 .00 .00 .0% 0118252 527001 RENTAL - BUILDIN 0 2,888 2,888 2,887.50 .00 .00 100.0% 0118252 527006 LEASE-PHOTOCPIER 0 0 0 .00 .00 .00 .0% 0118252 530000 PROFESSIONL & TE 15,000 -3,215 11,785 .00 .00 11,784.58 .0% 0118252 530010 LEGAL SERVICES 0 0 0 .00 .00 .00 .0% 0118252 530011 ADVERTISING 500 0 500 .00 .00 500.00 .0% 0118252 530018 POLICE DETAIL 0 0 0 .00 .00 .00 .0% 0118252 530023 STAFF DEVELOPMEN 12,500 0 12,500 2,547.04 447.96 9,505.00 24.0% 0118252 530028 SOFTWARE SERVICE 15,000 -200 14,800 .00 .00 14,800.00 .0% 0118252 534003 POSTAGE 250 0 250 .00 80.39 169.61 32.2% 0118252 534015 FEE 0 0 0 .00 .00 .00 .0% 0118252 538010 ADMINISTRATION C 750 0 750 .00 .00 750.00 .0% 0118252 542000 OFFICE SUPPLIES 8,500 0 8,500 4,672.21 2,351.21 1,476.58 82.6% 0118252 542001 PRINTING & STATI 0 0 0 .00 .00 .00 .0% 0118252 542006 OFFICE FURNITURE 15,000 0 15,000 .00 .00 15,000.00 .0% 0118252 542007 COMPUTER EQUIPME 10,000 0 10,000 .00 .00 10,000.00 .0% 0118252 542012 OTH EQUIPMENT NO 0 0 0 .00 .00 .00 .0% 0118252 549000 FOOD SUPPLIES & 100 328 428 261.35 .00 166.57 61.1% 0118252 553001 SIGNS AND CONES 0 0 0 .00 .00 .00 .0% 0118252 558002 ONLINE SUBSCRIPT 0 200 200 119.99 .00 80.01 60.0% 0118252 558004 MAGAZINES,NEWS,S 0 0 0 .00 .00 .00 .0% 0118252 571000 IN STATE TRAVEL 2,500 0 2,500 .00 .00 2,500.00 .0% 0118252 571001 IN STATE CONFERE 4,000 0 4,000 .00 .00 4,000.00 .0% 0118252 572000 OUT OF STATE TRA 15,000 0 15,000 3,368.23 2,125.16 9,506.61 36.6% 0118252 572001 OUT OF STATE CON 12,500 0 12,500 1,943.00 .00 10,557.00 15.5% 0118252 573000 DUES AND MEMBERS 7,400 0 7,400 100.00 .00 7,300.00 1.4% 0118252 578010 RECORDINGS 500 0 500 .00 .00 500.00 .0% 0118252 578015 AWARDS 0 0 0 .00 .00 .00 .0% 0118252 578037 COVID 19 OM EXP 0 0 0 .00 .00 .00 .0% TOTAL OSPCD-ADMIN ORDINARY MAINT 132,000 0 132,000 20,640.62 12,004.72 99,354.66 24.7% 0118258 OSPCD-ADMIN CAPITAL OUTLAY 0118258 581001 LAND ACQUISITION 0 0 0 .00 .00 .00 .0% 0118258 584001 PARK RECONSTRUCT 0 0 0 .00 .00 .00 .0% TOTAL OSPCD-ADMIN CAPITAL OUTLAY 0 0 0 .00 .00 .00 .0% 0118260 OSPCD ADMINISTRATION SPECIAL 0118260 578037 COVID 19 OM EXP 0 0 0 .00 .00 .00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 30 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED TOTAL OSPCD ADMINISTRATION SPECIAL 0 0 0 .00 .00 .00 .0% 0118351 OSPCD-HOUSING PERSONAL SVC 0118351 511000 SALARIES 1,190,891 -74,000 1,116,891 497,692.16 .00 619,198.84 44.6% 0118351 511002 SALARIES - MONTH 19,260 0 19,260 9,933.00 .00 9,327.00 51.6% 0118351 512000 SALARIES & WAGES 9,600 42,000 51,600 55,517.54 .00 -3,917.54 107.6% 0118351 515006 HOLIDAYS NON-UNI 9,652 0 9,652 5,276.69 .00 4,375.31 54.7% 0118351 519030 COVID19 PERSONAL 0 0 0 .00 .00 .00 .0% 0118351 519999 RESERVED FOR REV 0 0 0 .00 .00 .00 .0% TOTAL OSPCD-HOUSING PERSONAL SVC 1,229,403 -32,000 1,197,403 568,419.39 .00 628,983.61 47.5% 0118352 OSPCD-HOUSING ORDINARY MAINT 0118352 524007 REPAIRS OFFICE E 0 0 0 .00 .00 .00 .0% 0118352 524034 MAINT CONTRACT-O 0 0 0 .00 .00 .00 .0% 0118352 527001 RENTAL - BUILDIN 0 0 0 .00 .00 .00 .0% 0118352 530000 PROFESSIONL & TE 110,000 -147 109,853 2,261.67 .00 107,590.99 2.1% 0118352 530011 ADVERTISING 500 0 500 108.00 .00 392.00 21.6% 0118352 530023 STAFF DEVELOPMEN 0 0 0 .00 .00 .00 .0% 0118352 530200 TRANSLATION SERV 1,750 0 1,750 .00 .00 1,750.00 .0% 0118352 534003 POSTAGE 250 0 250 .00 .00 250.00 .0% 0118352 534006 EXPRESS/FREIGHT 0 147 147 75.48 39.37 32.49 77.9% 0118352 542000 OFFICE SUPPLIES 0 0 0 .00 .00 .00 .0% 0118352 542001 PRINTING & STATI 500 0 500 81.45 81.45 337.10 32.6% 0118352 542005 OFFICE EQUIPMENT 2,000 0 2,000 1,654.00 .00 346.00 82.7% 0118352 542006 OFFICE FURNITURE 0 0 0 .00 .00 .00 .0% 0118352 542007 COMPUTER EQUIPME 0 0 0 .00 .00 .00 .0% 0118352 542008 BOOKS & BOOKBIND 0 0 0 .00 .00 .00 .0% 0118352 549000 FOOD SUPPLIES & 200 0 200 .00 .00 200.00 .0% 0118352 558002 ONLINE SUBSCRIPT 1,000 0 1,000 450.00 450.00 100.00 90.0% 0118352 558004 MAGAZINES,NEWS,S 0 0 0 .00 .00 .00 .0% 0118352 558006 UNIFORMS 1,500 0 1,500 .00 .00 1,500.00 .0% 0118352 571000 IN STATE TRAVEL 0 0 0 .00 .00 .00 .0% 0118352 571001 IN STATE CONFERE 0 0 0 .00 .00 .00 .0% 0118352 572000 OUT OF STATE TRA 0 0 0 .00 .00 .00 .0% 0118352 573000 DUES AND MEMBERS 6,150 0 6,150 .00 .00 6,150.00 .0% 0118352 578010 RECORDINGS 0 0 0 .00 .00 .00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 31 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED TOTAL OSPCD-HOUSING ORDINARY MAINT 123,850 0 123,850 4,630.60 570.82 118,648.58 4.2% 0118451 REDEV AUTH PERSONAL SERVICES 0118451 511002 SALARIES - MONTH 22,753 0 22,753 11,235.00 .00 11,518.00 49.4% 0118451 515006 HOLIDAYS NON-UNI 0 0 0 .00 .00 .00 .0% 0118451 519999 RESERVED FOR REV 0 0 0 .00 .00 .00 .0% TOTAL REDEV AUTH PERSONAL SERVICES 22,753 0 22,753 11,235.00 .00 11,518.00 49.4% 0118452 REDEV AUTH OM 0118452 530010 LEGAL SERVICES 0 0 0 .00 .00 .00 .0% TOTAL REDEV AUTH OM 0 0 0 .00 .00 .00 .0% 0118551 OSPCD-MOBILITY PERSONAL SRVC 0118551 511000 SALARIES 712,894 0 712,894 390,304.04 .00 322,589.96 54.7% 0118551 515006 HOLIDAYS NON-UNI 5,860 0 5,860 4,244.35 .00 1,615.65 72.4% 0118551 519999 RESERVED FOR REV 0 0 0 .00 .00 .00 .0% TOTAL OSPCD-MOBILITY PERSONAL SRVC 718,754 0 718,754 394,548.39 .00 324,205.61 54.9% 0118552 OSPCD-MOBILITY ORDINARY MAINT 0118552 524034 R&M - SERVICE CO 0 0 0 .00 .00 .00 .0% 0118552 527001 RENTAL - BUILDIN 0 0 0 .00 .00 .00 .0% 0118552 530000 PROFESSIONL & TE 355,000 -19,650 335,350 14,198.00 214,028.52 107,123.67 68.1% 0118552 530011 ADVERTISING 0 0 0 .00 .00 .00 .0% 0118552 530018 POLICE DETAIL 5,000 0 5,000 .00 .00 5,000.00 .0% 0118552 530023 STAFF DEVELOPMEN 0 0 0 .00 .00 .00 .0% 0118552 530028 SOFTWARE SERVICE 0 19,550 19,550 .00 19,550.00 .00 100.0% 0118552 534003 POSTAGE 0 0 0 .00 .00 .00 .0% 0118552 538010 ADMINISTRATION C 0 0 0 .00 .00 .00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 32 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0118552 540000 SUPPLIES 0 100 100 99.81 .00 .00 100.0% 0118552 542000 OFFICE SUPPLIES 0 0 0 .00 .00 .00 .0% 0118552 542001 PRINTING & STATI 0 0 0 .00 .00 .00 .0% 0118552 542002 PHOTOCOPYING 0 0 0 .00 .00 .00 .0% 0118552 542005 OFFICE EQUIPMENT 0 0 0 .00 .00 .00 .0% 0118552 542008 BOOKS & BOOKBIND 0 0 0 .00 .00 .00 .0% 0118552 542012 OTH EQUIPMENT NO 0 0 0 .00 .00 .00 .0% 0118552 546000 GROUNDSKEEPING S 0 0 0 .00 .00 .00 .0% 0118552 549000 FOOD SUPPLIES & 0 0 0 .00 .00 .00 .0% 0118552 553001 SIGNS AND CONES 25,000 0 25,000 2,012.00 .00 22,988.00 8.0% 0118552 553002 BITUMINOUS SUPPL 0 0 0 .00 .00 .00 .0% 0118552 558002 ONLINE SUBSCRIPT 0 0 0 .00 .00 .00 .0% 0118552 558005 RECREATION SUPPL 0 0 0 .00 .00 .00 .0% 0118552 571000 IN STATE TRAVEL 0 0 0 .00 .00 .00 .0% 0118552 571001 IN STATE CONFERE 0 0 0 .00 .00 .00 .0% 0118552 572000 OUT OF STATE TRA 0 0 0 .00 .00 .00 .0% 0118552 572001 OUT OF STATE CON 0 0 0 .00 .00 .00 .0% 0118552 573000 DUES AND MEMBERS 15,000 0 15,000 67.55 .00 14,932.45 .5% 0118552 574000 INSURANCE PREMIU 0 0 0 .00 .00 .00 .0% 0118552 578015 AWARDS 0 0 0 .00 .00 .00 .0% 0118552 584000 SITE IMPROVEMENT 0 0 0 .00 .00 .00 .0% 0118552 584002 TREE PLANTING 0 0 0 .00 .00 .00 .0% TOTAL OSPCD-MOBILITY ORDINARY MAINT 400,000 0 400,000 16,377.36 233,578.52 150,044.12 62.5% 0118558 OSPCD-MOBILITY CAPITAL EXP 0118558 581001 LAND ACQUISITION 0 0 0 .00 .00 .00 .0% 0118558 584002 TREE PLANTING 0 0 0 .00 .00 .00 .0% 0118558 585022 BIKE SHARE SERVI 0 0 0 .00 .00 .00 .0% TOTAL OSPCD-MOBILITY CAPITAL EXP 0 0 0 .00 .00 .00 .0% 0118560 OSPCD MOBILITY SPECIAL ITEMS 0118560 538009 TRANSPORTATION ( 0 0 0 .00 .00 .00 .0% 0118560 578037 COVID 19 OM EXP 0 0 0 .00 .00 .00 .0% TOTAL OSPCD MOBILITY SPECIAL ITEMS 0 0 0 .00 .00 .00 .0% 0118651 OSPCD-EC DEV PERSONAL SERVICES 0118651 511000 SALARIES 790,986 -25,000 765,986 353,610.20 .00 412,375.80 46.2%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 33 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0118651 512000 SALARIES & WAGES 0 25,000 25,000 10,859.93 .00 14,140.07 43.4% 0118651 515006 HOLIDAYS NON-UNI 6,034 0 6,034 3,519.27 .00 2,514.73 58.3% 0118651 519999 RESERVED FOR REV 0 0 0 .00 .00 .00 .0% TOTAL OSPCD-EC DEV PERSONAL SERVICES 797,020 0 797,020 367,989.40 .00 429,030.60 46.2% 0118652 OSPCD-EC DEV ORDINARY MAINT 0118652 516100 FIRE DETAIL - CI 0 0 0 .00 .00 .00 .0% 0118652 524034 R&M - SERVICE CO 0 0 0 .00 .00 .00 .0% 0118652 527001 RENTAL - BUILDIN 0 0 0 .00 .00 .00 .0% 0118652 527015 RENTALS EQUIPMEN 0 0 0 .00 .00 .00 .0% 0118652 530000 PROFESSIONL & TE 320,000 -1,500 318,500 4,782.00 69,083.00 244,635.00 23.2% 0118652 530011 ADVERTISING 1,500 -420 1,080 .00 .00 1,080.00 .0% 0118652 530020 FIRE DETAIL 0 0 0 .00 .00 .00 .0% 0118652 530022 APPRAISALS 25,000 0 25,000 21,000.00 .00 4,000.00 84.0% 0118652 530023 STAFF DEVELOPMEN 0 0 0 .00 .00 .00 .0% 0118652 530028 SOFTWARE SERVICE 0 0 0 .00 .00 .00 .0% 0118652 530029 CUSTODIAL DETAIL 0 0 0 .00 .00 .00 .0% 0118652 534003 POSTAGE 0 0 0 .00 .00 .00 .0% 0118652 538010 ADMINISTRATION C 0 0 0 .00 .00 .00 .0% 0118652 540000 SUPPLIES 2,000 1,500 3,500 259.50 2,245.78 994.72 71.6% 0118652 542000 OFFICE SUPPLIES 0 0 0 .00 .00 .00 .0% 0118652 542001 PRINTING & STATI 500 0 500 .00 .00 500.00 .0% 0118652 542005 OFFICE EQUIPMENT 0 0 0 .00 .00 .00 .0% 0118652 542006 OFFICE FURNITURE 0 0 0 .00 .00 .00 .0% 0118652 542007 COMPUTER EQUIPME 0 0 0 .00 .00 .00 .0% 0118652 542012 OTH EQUIPMENT NO 0 0 0 .00 .00 .00 .0% 0118652 549000 FOOD SUPPLIES & 0 0 0 .00 .00 .00 .0% 0118652 558002 ONLINE SUBSCRIPT 6,350 0 6,350 252.00 272.00 5,826.00 8.3% 0118652 558004 MAGAZINES,NEWS,S 0 0 0 .00 .00 .00 .0% 0118652 558011 FLOWERS & FLAGS 0 0 0 .00 .00 .00 .0% 0118652 558018 PROGRAM SUPPLIES 0 0 0 .00 .00 .00 .0% 0118652 558019 PROMOTIONAL MATE 0 0 0 .00 .00 .00 .0% 0118652 571000 IN STATE TRAVEL 0 0 0 .00 .00 .00 .0% 0118652 571001 IN STATE CONFERE 0 0 0 .00 .00 .00 .0% 0118652 572000 OUT OF STATE TRA 0 0 0 .00 .00 .00 .0% 0118652 572001 OUT OF STATE CON 0 0 0 .00 .00 .00 .0% 0118652 573000 DUES AND MEMBERS 5,000 0 5,000 .00 .00 5,000.00 .0% 0118652 578010 RECORDINGS 150 420 570 525.00 .00 45.00 92.1% 0118652 581001 LAND ACQUISITION 0 0 0 .00 .00 .00 .0% TOTAL OSPCD-EC DEV ORDINARY MAINT 360,500 0 360,500 26,818.50 71,600.78 262,080.72 27.3%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 34 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0118660 OSPSD - EC DEVELOPMENT 0118660 512000 SALARIES & WAGES 0 0 0 .00 .00 .00 .0% 0118660 558023 GRANT MATCH 0 0 0 .00 .00 .00 .0% TOTAL OSPSD - EC DEVELOPMENT 0 0 0 .00 .00 .00 .0% 0118751 ISD-ISD PERSONAL SERVICES 0118751 511000 SALARIES 3,135,799 -1,133 3,134,666 1,639,260.83 .00 1,495,405.17 52.3% 0118751 512000 SALARIES & WAGES 0 0 0 .00 .00 .00 .0% 0118751 513000 OVERTIME 85,500 0 85,500 75,555.67 .00 9,944.33 88.4% 0118751 514004 SHIFT DIFFERENTI 0 0 0 .00 .00 .00 .0% 0118751 514006 LONGEVITY 14,350 0 14,350 8,900.00 .00 5,450.00 62.0% 0118751 514008 OUT OF GRADE 15,000 0 15,000 7,960.78 .00 7,039.22 53.1% 0118751 514015 OTHER DIFFERENTI 60,539 0 60,539 41,392.63 .00 19,146.37 68.4% 0118751 515006 HOLIDAYS NON-UNI 7,758 0 7,758 4,532.14 .00 3,225.86 58.4% 0118751 515011 HOLIDAYS - S.M.E 16,530 0 16,530 8,171.89 .00 8,358.11 49.4% 0118751 515012 PERFECT ATTENDAN 0 0 0 2,000.00 .00 -2,000.00 100.0% 0118751 519004 UNIFORM ALLOWANC 6,767 1,133 7,900 7,900.00 .00 .00 100.0% 0118751 519005 SICK LEAVE BUYBA 0 0 0 .00 .00 .00 .0% 0118751 519013 OTHER LUMP SUM P 2,000 0 2,000 .00 .00 2,000.00 .0% 0118751 519015 AUTO ALLOWANCE 11,328 0 11,328 7,299.52 .00 4,028.48 64.4% 0118751 519030 COVID19 PERSONAL 0 0 0 .00 .00 .00 .0% 0118751 519104 SALARY STIPEND 0 0 0 .00 .00 .00 .0% 0118751 519999 RESERVED FOR REV 0 0 0 .00 .00 .00 .0% TOTAL ISD-ISD PERSONAL SERVICES 3,355,571 0 3,355,571 1,802,973.46 .00 1,552,597.54 53.7% 0118752 ISD-ISD ORDINARY MAINTENANCE 0118752 524001 R&M - BUILDINGS 0 0 0 .00 .00 .00 .0% 0118752 524007 REPAIRS OFFICE E 0 0 0 .00 .00 .00 .0% 0118752 524013 R&M - TOOLS & EQ 2,000 0 2,000 .00 .00 2,000.00 .0% 0118752 524034 MAINT CONTRACT-O 2,000 0 2,000 1,547.32 452.68 .00 100.0% 0118752 527006 LEASE-PHOTOCPIER 0 0 0 .00 .00 .00 .0% 0118752 527018 POSTAGE MACHINE 2,018 0 2,018 465.84 465.84 1,086.32 46.2% 0118752 527019 RENTAL-WATER COO 300 0 300 123.80 133.80 42.40 85.9%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 35 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0118752 529011 DEMOLITION SERVI 7,500 0 7,500 .00 .00 7,500.00 .0% 0118752 530000 PROFESSIONL & TE 190,000 0 190,000 83,522.50 95,367.50 11,110.00 94.2% 0118752 530011 ADVERTISING 0 0 0 .00 .00 .00 .0% 0118752 530023 STAFF DEVELOPMEN 25,000 0 25,000 7,730.05 7,950.00 9,319.95 62.7% 0118752 530028 SOFTWARE SERVICE 40,000 0 40,000 34,717.20 .00 5,282.80 86.8% 0118752 534003 POSTAGE 20,000 -7,000 13,000 .00 .00 13,000.00 .0% 0118752 534007 PSTN-USAGE 0 0 0 .00 .00 .00 .0% 0118752 538004 EXTERMINATION 140,667 0 140,667 57,361.00 83,306.00 .00 100.0% 0118752 542000 OFFICE SUPPLIES 8,000 0 8,000 1,258.07 1,854.54 4,887.39 38.9% 0118752 542001 PRINTING & STATI 18,000 0 18,000 690.00 .00 17,310.00 3.8% 0118752 542005 OFFICE EQUIPMENT 1,000 0 1,000 .00 .00 1,000.00 .0% 0118752 542006 OFFICE FURNITURE 7,000 0 7,000 1,611.98 2,318.34 3,069.68 56.1% 0118752 542007 COMPUTER EQUIPME 3,000 0 3,000 .00 .00 3,000.00 .0% 0118752 542008 BOOKS & BOOKBIND 25,000 0 25,000 5,851.96 84.00 19,064.04 23.7% 0118752 543011 HARDWARE & SMALL 5,000 0 5,000 .00 270.00 4,730.00 5.4% 0118752 549000 FOOD SUPPLIES & 0 2,000 2,000 389.22 1,610.78 .00 100.0% 0118752 553001 SIGNS AND CONES 0 0 0 .00 .00 .00 .0% 0118752 558006 UNIFORMS & FOUL 15,000 0 15,000 4,905.57 .00 10,094.43 32.7% 0118752 558010 INSPECTION SVC S 5,000 5,000 10,000 8,615.16 169.05 1,215.79 87.8% 0118752 571000 IN STATE TRAVEL 2,500 0 2,500 399.11 747.98 1,352.91 45.9% 0118752 572000 OUT OF STATE TRA 2,000 0 2,000 724.68 .00 1,275.32 36.2% 0118752 573000 DUES AND MEMBERS 3,000 0 3,000 615.00 410.00 1,975.00 34.2% 0118752 578001 CREDIT CARD CONV 0 0 0 .00 .00 .00 .0% 0118752 578007 REIMB OF LICENSE 1,000 0 1,000 .00 100.00 900.00 10.0% 0118752 578010 RECORDINGS 0 0 0 .00 .00 .00 .0% 0118752 582003 BUILDING IMPROVE 0 0 0 .00 .00 .00 .0% TOTAL ISD-ISD ORDINARY MAINTENANCE 524,985 0 524,985 210,528.46 195,240.51 119,216.03 77.3% 0118760 INSPECTIONAL SERVICE SPECIAL 0118760 578037 COVID 19 OM EXP 0 0 0 .00 .00 .00 .0% TOTAL INSPECTIONAL SERVICE SPECIAL 0 0 0 .00 .00 .00 .0% 0119051 OSPCD- HOUSING STABILITY PS 0119051 511000 SALARIES 792,188 0 792,188 408,302.86 .00 383,885.14 51.5% 0119051 512000 SALARIES & WAGES 0 0 0 .00 .00 .00 .0% 0119051 515006 HOLIDAYS NON-UNI 7,310 0 7,310 3,811.77 .00 3,498.23 52.1%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 36 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED TOTAL OSPCD- HOUSING STABILITY PS 799,498 0 799,498 412,114.63 .00 387,383.37 51.5% 0119052 OSPCD - HOUSING STABILITY OM 0119052 524034 R&M - SERVICE CO 0 0 0 .00 .00 .00 .0% 0119052 530000 PROFESSIONAL & T 487,000 0 487,000 21,509.66 409,198.33 56,292.01 88.4% 0119052 530010 LEGAL SERVICES 0 0 0 .00 .00 .00 .0% 0119052 530011 ADVERTISING 1,500 0 1,500 .00 .00 1,500.00 .0% 0119052 530023 STAFF DEVELOPMEN 0 0 0 .00 .00 .00 .0% 0119052 530028 SOFTWARE SERVICE 2,500 0 2,500 .00 .00 2,500.00 .0% 0119052 530200 TRANSLATION SERV 10,000 0 10,000 1,546.60 4,453.40 4,000.00 60.0% 0119052 534003 POSTAGE 20,000 0 20,000 .00 .00 20,000.00 .0% 0119052 542000 OFFICE SUPPLIES 1,000 0 1,000 .00 .00 1,000.00 .0% 0119052 542001 PRINTING & STATI 3,000 0 3,000 875.00 .00 2,125.00 29.2% 0119052 542002 PHOTOCOPYING 250 0 250 .00 .00 250.00 .0% 0119052 542005 OFFICE EQUIPMENT 500 0 500 .00 .00 500.00 .0% 0119052 542006 OFFICE FURNITURE 0 0 0 .00 .00 .00 .0% 0119052 549000 FOOD SUPPLIES & 500 0 500 .00 .00 500.00 .0% 0119052 558002 ONLINE SUBSCRIPT 0 0 0 .00 .00 .00 .0% 0119052 558019 PROMOTIONAL MATE 0 0 0 .00 .00 .00 .0% 0119052 571000 IN STATE TRAVEL 1,000 0 1,000 .00 .00 1,000.00 .0% 0119052 571001 IN STATE CONFERE 500 0 500 100.00 45.00 355.00 29.0% 0119052 573000 DUES AND MEMBERS 750 0 750 .00 .00 750.00 .0% 0119052 578010 RECORDINGS 500 0 500 .00 .00 500.00 .0% TOTAL OSPCD - HOUSING STABILITY OM 529,000 0 529,000 24,031.26 413,696.73 91,272.01 82.7% 0119060 OSPCD HSG STABI SPECIAL ITEM 0119060 578037 COVID 19 OM EXP 0 0 0 .00 .00 .00 .0% TOTAL OSPCD HSG STABI SPECIAL ITEM 0 0 0 .00 .00 .00 .0% 0119151 OSPCD-PSUF PERSONAL SVC 0119151 511000 SALARIES 490,462 0 490,462 308,843.46 .00 181,618.54 63.0% 0119151 515006 HOLIDAYS NON-UNI 4,802 0 4,802 3,968.89 .00 833.11 82.7%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 37 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED TOTAL OSPCD-PSUF PERSONAL SVC 495,264 0 495,264 312,812.35 .00 182,451.65 63.2% 0119152 OSPCD-PSUF ORDIN MAINT 0119152 530000 PROFESSIONAL & T 582,500 -7,043 575,457 1,625.00 106,140.00 467,692.43 18.7% 0119152 530006 ENGINEER'G/ARCHI 0 0 0 .00 .00 .00 .0% 0119152 530011 ADVERTISING 200 0 200 .00 .00 200.00 .0% 0119152 530018 POLICE DETAIL 0 0 0 .00 .00 .00 .0% 0119152 530028 SOFTWARE SERVICE 1,000 0 1,000 1,000.00 .00 .00 100.0% 0119152 530029 CUSTODIAL DETAIL 0 0 0 .00 .00 .00 .0% 0119152 534006 EXPRESS/FREIGHT 0 0 0 .00 .00 .00 .0% 0119152 540000 SUPPLIES 500 6,543 7,043 6,541.86 250.71 250.00 96.5% 0119152 542000 OFFICE SUPPLIES 0 0 0 .00 .00 .00 .0% 0119152 542001 PRINTING & STATI 0 0 0 .00 .00 .00 .0% 0119152 553001 SIGNS AND CONES 5,000 0 5,000 196.00 .00 4,804.00 3.9% 0119152 558002 ONLINE SUBSCRIPT 0 500 500 159.00 341.00 .00 100.0% 0119152 558006 UNIFORMS 0 0 0 .00 .00 .00 .0% 0119152 571000 IN STATE TRAVEL 0 0 0 .00 .00 .00 .0% 0119152 571001 IN STATE CONFERE 0 0 0 .00 .00 .00 .0% 0119152 572000 OUT OF STATE TRA 0 0 0 .00 .00 .00 .0% 0119152 572001 OUT OF STATE CON 0 0 0 .00 .00 .00 .0% 0119152 573000 DUES AND MEMBERS 3,445 0 3,445 542.55 1,025.00 1,877.45 45.5% TOTAL OSPCD-PSUF ORDIN MAINT 592,645 0 592,645 10,064.41 107,756.71 474,823.88 19.9% 0119158 OSPCD-PSUF CAPITAL 0119158 584002 TREE PLANTING 500,000 0 500,000 .00 .00 500,000.00 .0% TOTAL OSPCD-PSUF CAPITAL 500,000 0 500,000 .00 .00 500,000.00 .0% 0119160 OSPCD - PSUF SPECIAL 0119160 578037 COVID 19 OM EXP 0 0 0 .00 .00 .00 .0% TOTAL OSPCD - PSUF SPECIAL 0 0 0 .00 .00 .00 .0% 0121051 POLICE PERSONAL SERVICES 0121051 511000 SALARIES 12,600,683 -41,289 12,559,394 6,522,892.39 .00 6,036,502.04 51.9%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 38 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0121051 511003 CROSSING GUARDS 462,713 44,403 507,116 158,037.68 .00 349,078.32 31.2% 0121051 512000 SALARIES & WAGES 20,000 0 20,000 .00 .00 20,000.00 .0% 0121051 513000 OVERTIME 1,292,800 0 1,292,800 1,040,557.94 .00 252,242.06 80.5% 0121051 513001 TRAINING-OVERTIM 308,500 0 308,500 172,536.89 .00 135,963.11 55.9% 0121051 514004 SHIFT DIFFERENTI 1,018,836 0 1,018,836 511,340.83 .00 507,495.17 50.2% 0121051 514006 LONGEVITY 99,100 0 99,100 93,300.00 .00 5,800.00 94.1% 0121051 514007 COURT TIME 150,000 0 150,000 55,536.23 .00 94,463.77 37.0% 0121051 514008 OUT OF GRADE 12,190 0 12,190 11,102.10 .00 1,087.90 91.1% 0121051 514015 OTHER DIFFERENTI 0 0 0 .00 .00 .00 .0% 0121051 515004 HOLIDAYS 767,675 0 767,675 358,517.32 .00 409,157.68 46.7% 0121051 515006 HOLIDAYS NON-UNI 5,829 2,126 7,955 7,955.42 .00 .00 100.0% 0121051 515011 HOLIDAYS - S.M.E 1,286 0 1,286 1,203.20 .00 82.80 93.6% 0121051 515012 PERFECT ATTENDAN 0 9,850 9,850 8,600.00 .00 1,250.00 87.3% 0121051 519002 EDUCATIONAL INCE 4,000 0 4,000 2,000.00 .00 2,000.00 50.0% 0121051 519004 UNIFORM ALLOWANC 1,400 6,050 7,450 4,100.00 .00 3,350.00 55.0% 0121051 519005 SICK LEAVE BUYBA 0 0 0 .00 .00 .00 .0% 0121051 519006 WEAPONS PAY 72,000 0 72,000 59,575.00 .00 12,425.00 82.7% 0121051 519007 5/2 BUYBACK 74,352 0 74,352 49,952.91 .00 24,399.09 67.2% 0121051 519013 OTHER LUMP SUM P 0 181,262 181,262 181,262.15 .00 .00 100.0% 0121051 519014 LUMP SUM SETTLEM 0 0 0 .00 .00 .00 .0% 0121051 519022 HAZARDOUS DUTY S 212,018 0 212,018 105,374.10 .00 106,643.90 49.7% 0121051 519023 DETENTION ATTEND 15,000 0 15,000 6,449.33 .00 8,550.67 43.0% 0121051 519030 COVID19 PERSONAL 0 0 0 .00 .00 .00 .0% 0121051 519999 RESERVED FOR REV 0 0 0 .00 .00 .00 .0% TOTAL POLICE PERSONAL SERVICES 17,118,382 202,403 17,320,785 9,350,293.49 .00 7,970,491.51 54.0% 0121052 POLICE ORDINARY MAINTENANCE 0121052 524003 REPAIRS-VEHICLES 0 0 0 .00 .00 .00 .0% 0121052 524007 REPAIRS OFFICE E 6,400 0 6,400 2,596.94 3,803.06 .00 100.0% 0121052 524017 EQUIP MAINTENANC 6,900 0 6,900 .00 1,600.00 5,300.00 23.2% 0121052 524030 REPAIRS-RADIO AL 12,800 0 12,800 1,094.26 3,905.74 7,800.00 39.1% 0121052 524033 MAINT SOFTWARE 17,000 0 17,000 6,425.00 8,188.00 2,387.00 86.0% 0121052 527015 RENTALS EQUIPMEN 2,100 0 2,100 1,000.94 1,099.06 .00 100.0% 0121052 527016 RENTALS - VEHICL 36,200 0 36,200 11,176.34 13,823.66 11,200.00 69.1% 0121052 527019 RENTAL-WATER COO 3,300 0 3,300 2,344.63 955.37 .00 100.0% 0121052 530000 PROFESSIONL & TE 69,600 -5,500 64,100 5,169.80 10,489.25 48,440.95 24.4% 0121052 530001 MEDICAL & DENTAL 76,000 0 76,000 11,820.00 8,280.00 55,900.00 26.4% 0121052 530011 ADVERTISING 0 0 0 .00 .00 .00 .0% 0121052 530019 DETENTION ATTEND 0 0 0 .00 .00 .00 .0% 0121052 530021 TOWING 0 0 0 .00 .00 .00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 39 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0121052 530025 IN SERVICE TRAIN 68,400 -280 68,120 8,266.00 15,787.00 44,067.00 35.3% 0121052 530028 SOFTWARE SERVICE 39,800 0 39,800 13,758.01 5,842.44 20,199.55 49.2% 0121052 534003 POSTAGE 6,500 0 6,500 .00 6,500.00 .00 100.0% 0121052 534007 PSTN-USAGE 26,600 0 26,600 12,859.94 13,640.06 100.00 99.6% 0121052 534008 WEB SITE COSTS 600 0 600 .00 .00 600.00 .0% 0121052 542000 OFFICE SUPPLIES 15,700 -1,500 14,200 6,025.59 3,989.38 4,185.03 70.5% 0121052 542001 PRINTING & STATI 6,300 0 6,300 5,385.00 422.00 493.00 92.2% 0121052 542004 COMPUTER SUPPLIE 6,800 0 6,800 259.95 1,240.05 5,300.00 22.1% 0121052 542005 OFFICE EQUIPMENT 1,000 0 1,000 .00 .00 1,000.00 .0% 0121052 542006 OFFICE FURNITURE 1,000 1,500 2,500 1,458.76 596.94 444.30 82.2% 0121052 542007 COMPUTER EQUIPME 1,600 0 1,600 .00 .00 1,600.00 .0% 0121052 542008 BOOKS & BOOKBIND 0 0 0 .00 .00 .00 .0% 0121052 542012 OTH EQUIPMENT NO 0 320 320 319.64 .00 .00 100.0% 0121052 548006 MOTOR PARTS & AC 0 0 0 .00 .00 .00 .0% 0121052 548007 VEHICLES-NON CAP 0 0 0 .00 .00 .00 .0% 0121052 549000 FOOD SUPPLIES & 2,100 0 2,100 850.99 .00 1,249.01 40.5% 0121052 551010 AUDIO VISUAL SUP 0 0 0 .00 .00 .00 .0% 0121052 558003 PUBLIC SAFETY SU 86,800 -2,000 84,800 1,469.67 42,772.13 40,558.20 52.2% 0121052 558004 MAGAZINES,NEWS,S 3,700 280 3,980 3,980.00 .00 .00 100.0% 0121052 558006 UNIFORMS 0 0 0 .00 .00 .00 .0% 0121052 558011 FLOWERS & FLAGS 0 0 0 .00 .00 .00 .0% 0121052 558012 BADGES, EMBLEMS, 1,000 0 1,000 746.50 .00 253.50 74.7% 0121052 558014 PHOTOGRAPHIC SUP 300 0 300 92.98 41.31 165.71 44.8% 0121052 558015 SUPPLIES FOR MEN 27,100 -320 26,780 5,719.39 1,020.67 20,040.30 25.2% 0121052 558016 COLORGUARD 3,700 0 3,700 .00 3,500.00 200.00 94.6% 0121052 558017 TRAFFIC SUPV SUP 6,300 0 6,300 800.00 4,270.00 1,230.00 80.5% 0121052 572000 OUT OF STATE TRA 0 5,500 5,500 4,975.82 311.39 212.79 96.1% 0121052 572001 OUT OF STATE CON 2,100 0 2,100 1,200.00 .00 900.00 57.1% 0121052 573000 DUES AND MEMBERS 17,300 0 17,300 9,460.00 2,040.00 5,800.00 66.5% 0121052 573001 BAPERN MEMBERSHI 5,300 0 5,300 .00 2,651.00 2,649.00 50.0% 0121052 578007 REIMB OF LICENSE 0 0 0 .00 .00 .00 .0% 0121052 578013 CARE OF PRISONER 3,200 0 3,200 .00 1,000.00 2,200.00 31.3% 0121052 578037 COVID 19 OM EXP 0 0 0 .00 .00 .00 .0% 0121052 578065 GUN BUYBACK INCE 1,000 2,000 3,000 3,000.00 .00 .00 100.0% TOTAL POLICE ORDINARY MAINTENANCE 564,500 0 564,500 122,256.15 157,768.51 284,475.34 49.6% 0121058 POLICE CAPITAL OUTLAY 0121058 585001 VEHICLES 0 0 0 .00 .00 .00 .0% 0121058 585010 OFFICE EQUIPMENT 0 0 0 .00 .00 .00 .0% 0121058 585015 ATHLETIC EQUIPME 0 0 0 .00 .00 .00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 40 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0121058 585016 AUDIO / VISUAL E 0 0 0 .00 .00 .00 .0% TOTAL POLICE CAPITAL OUTLAY 0 0 0 .00 .00 .00 .0% 0121060 POLICE SPECIAL ITEMS 0121060 511000 SALARIES 0 0 0 .00 .00 .00 .0% 0121060 527001 RENTAL - BUILDIN 60,000 0 60,000 43,000.00 14,600.00 2,400.00 96.0% 0121060 558020 GRANT MATCH 0 0 0 .00 .00 .00 .0% 0121060 578037 COVID 19 OM EXP 0 0 0 .00 .00 .00 .0% TOTAL POLICE SPECIAL ITEMS 60,000 0 60,000 43,000.00 14,600.00 2,400.00 96.0% 0121151 POLICE-E911 PERSONAL SERVICES 0121151 511000 SALARIES 966,101 0 966,101 454,018.24 .00 512,082.76 47.0% 0121151 513000 OVERTIME 217,480 0 217,480 184,331.61 .00 33,148.39 84.8% 0121151 514004 SHIFT DIFFERENTI 54,001 0 54,001 31,184.69 .00 22,816.31 57.7% 0121151 514006 LONGEVITY 17,550 0 17,550 1,700.00 .00 15,850.00 9.7% 0121151 515004 HOLIDAYS 100,326 0 100,326 14,950.25 .00 85,375.75 14.9% 0121151 515006 HOLIDAYS NON-UNI 0 0 0 .00 .00 .00 .0% 0121151 515012 PERFECT ATTENDAN 0 0 0 .00 .00 .00 .0% 0121151 519004 UNIFORM ALLOWANC 7,000 0 7,000 6,500.00 .00 500.00 92.9% 0121151 519013 OTHER LUMP SUM P 0 0 0 .00 .00 .00 .0% TOTAL POLICE-E911 PERSONAL SERVICES 1,362,458 0 1,362,458 692,684.79 .00 669,773.21 50.8% 0121251 POLICE-PATROL PERSONAL SVCS 0121251 515006 HOLIDAYS NON-UNI 0 0 0 .00 .00 .00 .0% TOTAL POLICE-PATROL PERSONAL SVCS 0 0 0 .00 .00 .00 .0% 0121351 POLICE-TRAFFIC PERSONAL SVCS 0121351 515006 HOLIDAYS NON-UNI 0 0 0 .00 .00 .00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 41 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED TOTAL POLICE-TRAFFIC PERSONAL SVCS 0 0 0 .00 .00 .00 .0% 0121451 POLICE-CRIM INV PERSONAL SVCS 0121451 515006 HOLIDAYS NON-UNI 0 0 0 .00 .00 .00 .0% TOTAL POLICE-CRIM INV PERSONAL SVCS 0 0 0 .00 .00 .00 .0% 0121551 POLICE-SPEC OPS PERSONAL SVCS 0121551 515006 HOLIDAYS NON-UNI 0 0 0 .00 .00 .00 .0% TOTAL POLICE-SPEC OPS PERSONAL SVCS 0 0 0 .00 .00 .00 .0% 0121651 POLICE-ADMIN&FIN PERSONAL SVC 0121651 515006 HOLIDAYS NON-UNI 0 0 0 .00 .00 .00 .0% TOTAL POLICE-ADMIN&FIN PERSONAL SVC 0 0 0 .00 .00 .00 .0% 0122051 FIRE PERSONAL SERVICES 0122051 511000 SALARIES 16,234,901 -131,670 16,103,231 8,539,426.01 .00 7,563,804.77 53.0% 0122051 512000 SALARIES & WAGES 0 8,970 8,970 8,970.33 .00 .00 100.0% 0122051 513000 OVERTIME 2,000,000 0 2,000,000 1,596,314.88 .00 403,685.12 79.8% 0122051 513001 TRAINING-OVERTIM 87,550 0 87,550 55,153.60 .00 32,396.40 63.0% 0122051 514006 LONGEVITY 700 0 700 400.00 .00 300.00 57.1% 0122051 514008 OUT OF GRADE 90,000 46,000 136,000 97,953.29 .00 38,046.71 72.0% 0122051 514015 OTHER DIFFERENTI 0 0 0 .00 .00 .00 .0% 0122051 515004 HOLIDAYS 1,065,351 0 1,065,351 483,970.16 .00 581,380.84 45.4% 0122051 515006 HOLIDAYS NON-UNI 3,981 0 3,981 3,170.45 .00 810.55 79.6% 0122051 515011 HOLIDAYS - S.M.E 2,027 0 2,027 1,013.72 .00 1,013.28 50.0% 0122051 515012 PERFECT ATTENDAN 0 66,800 66,800 66,800.00 .00 .00 100.0% 0122051 516100 FIRE DETAIL - CI 0 221 221 221.00 .00 .00 100.0% 0122051 519002 EDUCATIONAL INCE 0 0 0 .00 .00 .00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 42 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0122051 519003 IN SERVICE TRAIN 40,000 0 40,000 5,600.00 .00 34,400.00 14.0% 0122051 519004 UNIFORM ALLOWANC 1,400 0 1,400 1,400.00 .00 .00 100.0% 0122051 519005 SICK LEAVE BUYBA 0 16,411 16,411 16,411.22 .00 .00 100.0% 0122051 519008 E.M.T.'S 0 0 0 .00 .00 .00 .0% 0122051 519009 DEFIBRILLATOR ST 0 0 0 .00 .00 .00 .0% 0122051 519010 HAZARDOUS DUTY S 451,000 0 451,000 439,000.00 .00 12,000.00 97.3% 0122051 519011 REIMBURSEMENT FO 178,500 0 178,500 128,806.30 .00 49,693.70 72.2% 0122051 519012 PHYSICAL EXAMINA 14,500 0 14,500 .00 .00 14,500.00 .0% 0122051 519013 OTHER LUMP SUM P 0 0 0 .00 .00 .00 .0% 0122051 519025 CERTIFICATION 80,300 -5,274 75,026 75,026.00 .00 .00 100.0% 0122051 519026 PEER SUPPORT 2,500 -500 2,000 2,000.00 .00 .00 100.0% 0122051 519027 METER TECH 2,500 -958 1,542 1,541.67 .00 .00 100.0% 0122051 519030 COVID19 PERSONAL 0 0 0 .00 .00 .00 .0% TOTAL FIRE PERSONAL SERVICES 20,255,210 0 20,255,210 11,523,178.63 .00 8,732,031.37 56.9% 0122052 FIRE ORDINARY MAINTENANCE 0122052 524003 REPAIRS-VEHICLES 190,000 -138 189,863 64,543.39 87,370.15 37,948.96 80.0% 0122052 524007 REPAIRS OFFICE E 0 0 0 .00 .00 .00 .0% 0122052 524013 REPAIRS-TOOLS & 58,900 -2,900 56,000 7,546.36 12,086.95 36,366.69 35.1% 0122052 524030 REPAIRS-RADIO AL 13,300 0 13,300 111.78 1,888.22 11,300.00 15.0% 0122052 524032 R&M - LIGHTING 0 0 0 .00 .00 .00 .0% 0122052 524033 R&M - SOFTWARE 15,000 0 15,000 2,001.70 .00 12,998.30 13.3% 0122052 524034 MAINT CONTRACT-O 6,900 0 6,900 1,471.20 28.80 5,400.00 21.7% 0122052 527019 RENTAL-WATER COO 3,100 0 3,100 2,060.64 939.36 100.00 96.8% 0122052 530000 PROFESSIONAL & T 26,500 0 26,500 10,555.00 .00 15,945.00 39.8% 0122052 530011 ADVERTISING 0 0 0 .00 .00 .00 .0% 0122052 530018 POLICE DETAIL 0 0 0 .00 .00 .00 .0% 0122052 530021 TOWING 3,200 1,800 5,000 3,300.00 1,700.00 .00 100.0% 0122052 530025 IN SERVICE TRAIN 3,100 0 3,100 1,281.64 500.00 1,318.36 57.5% 0122052 530028 SOFTWARE SERVICE 0 0 0 .00 .00 .00 .0% 0122052 534000 COMMUNICATIONS 0 0 0 .00 .00 .00 .0% 0122052 534003 POSTAGE 300 0 300 .00 .00 300.00 .0% 0122052 534006 EXPRESS/FREIGHT 200 0 200 103.94 90.43 5.63 97.2% 0122052 538003 LAUNDRY SERVICES 0 0 0 .00 .00 .00 .0% 0122052 538005 PHOTOGRAPHY 0 0 0 .00 .00 .00 .0% 0122052 542000 OFFICE SUPPLIES 7,500 0 7,500 2,421.47 578.53 4,500.00 40.0% 0122052 542001 PRINTING & STATI 500 138 638 637.50 .00 .00 100.0% 0122052 542004 COMPUTER SUPPLIE 7,600 0 7,600 1,750.98 1,400.00 4,449.02 41.5% 0122052 542005 OFFICE EQUIPMENT 2,600 0 2,600 599.99 429.00 1,571.01 39.6% 0122052 542006 OFFICE FURNITURE 2,600 0 2,600 .00 .00 2,600.00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 43 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0122052 542007 COMPUTER EQUIPME 8,300 -5,000 3,300 .00 .00 3,300.00 .0% 0122052 542008 BOOKS & BOOKBIND 1,100 0 1,100 .00 .00 1,100.00 .0% 0122052 542012 OTH EQUIPMENT NO 2,100 0 2,100 .00 .00 2,100.00 .0% 0122052 543011 HARDWARE & SMALL 13,000 0 13,000 705.29 2,383.38 9,911.33 23.8% 0122052 545000 CUSTODIAL & MAIN 0 0 0 .00 .00 .00 .0% 0122052 548001 MOTOR GAS AND OI 2,100 900 3,000 2,701.48 298.52 .00 100.0% 0122052 548002 ANTI-FREEZE 500 0 500 .00 .00 500.00 .0% 0122052 548003 BATTERIES 2,200 2,000 4,200 1,762.40 967.34 1,470.26 65.0% 0122052 548004 TIRES AND TUBES 20,300 5,000 25,300 5,894.40 8,350.18 11,055.42 56.3% 0122052 548007 VEHICLES NOT CAP 0 0 0 .00 .00 .00 .0% 0122052 549000 FOOD SUPPLIES & 0 0 0 .00 .00 .00 .0% 0122052 550000 MEDICAL/DENTAL S 48,800 0 48,800 7,350.23 4,649.77 36,800.00 24.6% 0122052 551006 ATHLETIC SUPPLIE 0 0 0 .00 .00 .00 .0% 0122052 558001 FIRE HOSES-REPAI 9,600 0 9,600 .00 .00 9,600.00 .0% 0122052 558003 PUBLIC SAFETY SU 48,100 0 48,100 14,125.76 9,553.33 24,420.91 49.2% 0122052 558006 UNIFORMS 4,700 -1,800 2,900 .00 .00 2,900.00 .0% 0122052 558010 INSPECTION SVC S 0 0 0 .00 .00 .00 .0% 0122052 558011 FLOWERS & FLAGS 0 0 0 .00 .00 .00 .0% 0122052 558012 BADGES, EMBLEMS, 0 0 0 .00 .00 .00 .0% 0122052 558015 SUPPLIES FOR MEN 33,100 0 33,100 .00 .00 33,100.00 .0% 0122052 558016 COLORGUARD 4,700 0 4,700 .00 .00 4,700.00 .0% 0122052 571000 IN STATE TRAVEL 100 0 100 .00 .00 100.00 .0% 0122052 572000 OUT OF STATE TRA 0 0 0 .00 .00 .00 .0% 0122052 573000 DUES AND MEMBERS 6,500 0 6,500 5,655.00 .00 845.00 87.0% 0122052 574000 INSURANCE PREMIU 600 0 600 517.00 .00 83.00 86.2% TOTAL FIRE ORDINARY MAINTENANCE 547,100 0 547,100 137,097.15 133,213.96 276,788.89 49.4% 0122058 FIRE CAPITAL OUTLAY 0122058 585001 VEHICLES 0 0 0 .00 .00 .00 .0% TOTAL FIRE CAPITAL OUTLAY 0 0 0 .00 .00 .00 .0% 0122060 FIRE DEPT SPECIAL ITEMS 0122060 513000 OVERTIME 0 0 0 .00 .00 .00 .0% 0122060 558003 PUBLIC SAFETY SU 0 0 0 .00 .00 .00 .0% 0122060 558020 FIRE GRANT MATCH 24,455 0 24,455 .00 .00 24,455.00 .0% 0122060 578037 COVID 19 OM EXP 0 0 0 .00 .00 .00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 44 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED TOTAL FIRE DEPT SPECIAL ITEMS 24,455 0 24,455 .00 .00 24,455.00 .0% 0122151 FIRE-SUPPRESSION PERSONAL SVC 0122151 511000 FIRE-SUPPRESSION 0 0 0 .00 .00 .00 .0% 0122151 515006 HOLIDAYS NON-UNI 0 0 0 .00 .00 .00 .0% TOTAL FIRE-SUPPRESSION PERSONAL SVC 0 0 0 .00 .00 .00 .0% 0122152 FIRE-SUPPRESSION ORDINARY MNT 0122152 530000 FIRE-SUPPRESSION 0 0 0 .00 .00 .00 .0% TOTAL FIRE-SUPPRESSION ORDINARY MNT 0 0 0 .00 .00 .00 .0% 0122158 FIRE-SUPPRESSION CAPITAL OUTLY 0122158 580000 FIRE-SUPPRESSION 0 0 0 .00 .00 .00 .0% TOTAL FIRE-SUPPRESSION CAPITAL OUTLY 0 0 0 .00 .00 .00 .0% 0122251 FIRE-PREVENTION PERSONAL SVC 0122251 511000 FIRE-PREVENTION 0 0 0 .00 .00 .00 .0% 0122251 515006 HOLIDAYS NON-UNI 0 0 0 .00 .00 .00 .0% TOTAL FIRE-PREVENTION PERSONAL SVC 0 0 0 .00 .00 .00 .0% 0122252 FIRE-PREVENTION ORDINARY MNT 0122252 530000 FIRE-PREVENTION 0 0 0 .00 .00 .00 .0% TOTAL FIRE-PREVENTION ORDINARY MNT 0 0 0 .00 .00 .00 .0% 0122258 FIRE-PREVENTION CAPITAL OUTLAY

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 45 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0122258 580000 FIRE-PREVENTION 0 0 0 .00 .00 .00 .0% TOTAL FIRE-PREVENTION CAPITAL OUTLAY 0 0 0 .00 .00 .00 .0% 0122351 FIRE-ADMIN&FIN PERSONAL SVC 0122351 511000 FIRE-ADMIN&FIN P 0 0 0 .00 .00 .00 .0% 0122351 515006 HOLIDAYS NON-UNI 0 0 0 .00 .00 .00 .0% TOTAL FIRE-ADMIN&FIN PERSONAL SVC 0 0 0 .00 .00 .00 .0% 0122352 FIRE-ADMIN&FIN ORDINARY MAINT 0122352 530000 FIRE-ADMIN&FIN O 0 0 0 .00 .00 .00 .0% TOTAL FIRE-ADMIN&FIN ORDINARY MAINT 0 0 0 .00 .00 .00 .0% 0122358 FIRE-ADMIN&FIN CAPITAL OUTLAY 0122358 580000 FIRE-ADMIN&FIN C 0 0 0 .00 .00 .00 .0% TOTAL FIRE-ADMIN&FIN CAPITAL OUTLAY 0 0 0 .00 .00 .00 .0% 0122951 FIRE ALARM PERSONAL SERVICES 0122951 511000 SALARIES 795,477 -3,300 792,177 413,254.98 .00 378,922.02 52.2% 0122951 511001 SALARIES - PROFE 0 0 0 .00 .00 .00 .0% 0122951 513000 OVERTIME 358,500 0 358,500 209,536.26 .00 148,963.74 58.4% 0122951 513001 TRAINING-OVERTIM 10,000 0 10,000 .00 .00 10,000.00 .0% 0122951 514006 LONGEVITY 9,000 0 9,000 9,000.00 .00 .00 100.0% 0122951 514008 OUT OF GRADE 5,500 0 5,500 879.90 .00 4,620.10 16.0% 0122951 515004 HOLIDAYS 64,250 0 64,250 31,893.69 .00 32,356.31 49.6% 0122951 515006 HOLIDAYS NON-UNI 0 0 0 .00 .00 .00 .0% 0122951 515012 PERFECT ATTENDAN 0 3,300 3,300 2,800.00 .00 500.00 84.8% 0122951 519002 CAREER/EDUCATION 0 0 0 .00 .00 .00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 46 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0122951 519004 UNIFORM ALLOWANC 11,000 0 11,000 9,900.00 .00 1,100.00 90.0% 0122951 519005 SICK LEAVE BUYBA 0 0 0 .00 .00 .00 .0% 0122951 519013 OTHER LUMP SUM P 22,500 0 22,500 12,000.00 .00 10,500.00 53.3% 0122951 519030 COVID19 PERSONAL 0 0 0 .00 .00 .00 .0% TOTAL FIRE ALARM PERSONAL SERVICES 1,276,227 0 1,276,227 689,264.83 .00 586,962.17 54.0% 0122952 FIRE ALARM ORDINARY MAINTENANC 0122952 530000 PROFESSIONAL & T 0 0 0 .00 .00 .00 .0% TOTAL FIRE ALARM ORDINARY MAINTENANC 0 0 0 .00 .00 .00 .0% 0129151 EMERG MGMT PERSONAL SERVICES 0129151 511000 SALARIES 153,937 0 153,937 .00 .00 153,937.00 .0% 0129151 515006 HOLIDAYS NON-UNI 1,005 0 1,005 .00 .00 1,005.00 .0% 0129151 519025 CERTIFICATION 0 0 0 .00 .00 .00 .0% TOTAL EMERG MGMT PERSONAL SERVICES 154,942 0 154,942 .00 .00 154,942.00 .0% 0129152 EMERG MGMT ORDINARY MAINT 0129152 524003 REPAIRS-VEHICLES 0 0 0 .00 .00 .00 .0% 0129152 524013 REPAIRS-TOOLS & 0 0 0 .00 .00 .00 .0% 0129152 524030 R&M - RADIO ALAR 0 0 0 .00 .00 .00 .0% 0129152 530000 PROFESSIONAL & T 25,000 25,000 50,000 .00 50,000.00 .00 100.0% 0129152 530008 EMPLOYEE TRAININ 5,600 0 5,600 .00 .00 5,600.00 .0% 0129152 530025 IN SERVICE TRAIN 3,000 0 3,000 .00 .00 3,000.00 .0% 0129152 534003 POSTAGE 50 0 50 .00 .00 50.00 .0% 0129152 542005 OFFICE EQUIPMENT 0 0 0 .00 .00 .00 .0% 0129152 542007 COMPUTER EQUIPME 15,000 -15,000 0 .00 .00 .00 .0% 0129152 542012 OTH EQUIPMENT NO 10,000 -10,000 0 .00 .00 .00 .0% 0129152 543011 HARDWARE & SMALL 0 0 0 .00 .00 .00 .0% 0129152 545000 CUSTODIAL & MAIN 0 0 0 .00 .00 .00 .0% 0129152 549000 FOOD SUPPLIES & 0 0 0 .00 .00 .00 .0% 0129152 558003 PUBLIC SAFETY SU 10,000 0 10,000 .00 .00 10,000.00 .0% 0129152 558006 UNIFORMS 500 0 500 .00 .00 500.00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 47 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0129152 558012 BADGES,EMBLEMS,T 0 0 0 .00 .00 .00 .0% 0129152 558015 SUPPLIES FOR MEN 0 0 0 .00 .00 .00 .0% 0129152 571000 IN STATE TRAVEL 1,200 0 1,200 .00 .00 1,200.00 .0% 0129152 571001 IN STATE CONFERE 200 0 200 .00 .00 200.00 .0% 0129152 572000 OUT OF STATE TRA 4,500 0 4,500 .00 .00 4,500.00 .0% 0129152 572001 OUT OF STATE CON 1,500 0 1,500 .00 .00 1,500.00 .0% 0129152 573000 DUES AND MEMBERS 1,500 0 1,500 .00 .00 1,500.00 .0% 0129152 574000 INSURANCE PREMIU 0 0 0 .00 .00 .00 .0% TOTAL EMERG MGMT ORDINARY MAINT 78,050 0 78,050 .00 50,000.00 28,050.00 64.1% 0129251 POLICE-ANIMAL CTL PERSONAL SVC 0129251 511000 SALARIES 118,323 0 118,323 65,987.78 .00 52,335.22 55.8% 0129251 513000 OVERTIME 22,000 0 22,000 8,165.19 .00 13,834.81 37.1% 0129251 514006 LONGEVITY 850 0 850 300.00 .00 550.00 35.3% 0129251 514015 OTHER DIFFERENTI 4,574 0 4,574 2,661.99 .00 1,912.01 58.2% 0129251 515004 HOLIDAYS 0 0 0 .00 .00 .00 .0% 0129251 515006 HOLIDAYS NON-UNI 0 0 0 .00 .00 .00 .0% 0129251 515011 HOLIDAYS - S.M.E 231 0 231 230.94 .00 .06 100.0% 0129251 519004 UNIFORM ALLOWANC 1,400 0 1,400 1,400.00 .00 .00 100.0% 0129251 519013 OTHER LUMP SUM P 0 0 0 .00 .00 .00 .0% TOTAL POLICE-ANIMAL CTL PERSONAL SVC 147,378 0 147,378 78,745.90 .00 68,632.10 53.4% 0129252 POLICE-ANIMAL CTL ORD MAINT 0129252 524003 REPAIRS-VEHICLES 0 0 0 .00 .00 .00 .0% 0129252 529010 KENNELS 0 0 0 .00 .00 .00 .0% 0129252 530000 PROFESSIONL & TE 7,500 200 7,700 2,524.64 5,069.03 106.33 98.6% 0129252 530011 ADVERTISING 0 0 0 .00 .00 .00 .0% 0129252 530025 IN SERVICE TRAIN 200 200 400 100.00 .00 300.00 25.0% 0129252 534003 POSTAGE 500 0 500 .00 .00 500.00 .0% 0129252 542000 OFFICE SUPPLIES 2,000 0 2,000 1,182.18 618.12 199.70 90.0% 0129252 542001 STATIONERY 1,300 -200 1,100 .00 .00 1,100.00 .0% 0129252 558003 PUBLIC SAFETY SU 4,300 -200 4,100 582.55 1,517.45 2,000.00 51.2% 0129252 558006 UNIFORMS 0 0 0 .00 .00 .00 .0% 0129252 558012 BADGES, EMBLEMS, 100 0 100 .00 .00 100.00 .0% 0129252 571001 IN STATE CONFERE 0 0 0 .00 .00 .00 .0% 0129252 572001 OUT OF STATE CON 0 0 0 .00 .00 .00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 48 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED TOTAL POLICE-ANIMAL CTL ORD MAINT 15,900 0 15,900 4,389.37 7,204.60 4,306.03 72.9% 0129351 PARKING PERSONAL SVC 0129351 511000 SALARIES 2,927,677 -15,454 2,912,223 1,443,503.58 .00 1,468,719.71 49.6% 0129351 511002 SALARIES - MONTH 3,500 0 3,500 2,040.50 .00 1,459.50 58.3% 0129351 512000 SALARIES & WAGES 0 14,854 14,854 10,581.74 .00 4,271.97 71.2% 0129351 513000 OVERTIME 130,000 0 130,000 124,789.57 .00 5,210.43 96.0% 0129351 514004 SHIFT DIFFERENTI 0 0 0 .00 .00 .00 .0% 0129351 514006 LONGEVITY 21,450 0 21,450 11,600.00 .00 9,850.00 54.1% 0129351 514008 OUT OF GRADE 10,000 0 10,000 2,378.08 .00 7,621.92 23.8% 0129351 514010 OUT OF GRADE-LAB 0 0 0 .00 .00 .00 .0% 0129351 514015 OTHER DIFFERENTI 67,872 0 67,872 37,393.46 .00 30,478.54 55.1% 0129351 515006 HOLIDAYS NON-UNI 5,546 0 5,546 2,853.24 .00 2,692.76 51.4% 0129351 515011 HOLIDAYS - S.M.E 18,460 0 18,460 6,420.70 .00 12,039.30 34.8% 0129351 515012 PERFECT ATTENDAN 0 600 600 600.00 .00 .00 100.0% 0129351 519004 UNIFORM ALLOWANC 25,900 0 25,900 21,300.00 .00 4,600.00 82.2% 0129351 519005 SICK LEAVE BUYBA 0 0 0 .00 .00 .00 .0% 0129351 519013 OTHER LUMP SUM P 2,000 0 2,000 1,000.00 .00 1,000.00 50.0% 0129351 519015 AUTO ALLOWANCE 16,500 0 16,500 7,974.42 .00 8,525.58 48.3% 0129351 519999 RESERVED FOR REV 0 0 0 .00 .00 .00 .0% TOTAL PARKING PERSONAL SVC 3,228,905 0 3,228,905 1,672,435.29 .00 1,556,469.71 51.8% 0129352 PARKING ORD MAINT 0129352 524001 R&M - BUILDINGS 2,500 0 2,500 .00 .00 2,500.00 .0% 0129352 524003 REPAIRS-VEHICLES 2,000 0 2,000 .00 .00 2,000.00 .0% 0129352 524006 REPAIRS-COMMUN. 9,500 0 9,500 .00 .00 9,500.00 .0% 0129352 524007 REPAIRS OFFICE E 0 0 0 .00 .00 .00 .0% 0129352 524008 R&M - MEDICAL EQ 0 0 0 .00 .00 .00 .0% 0129352 524028 REPAIRS-PARKING 69,940 0 69,940 17,846.81 2,936.18 49,157.01 29.7% 0129352 524029 REPAIRS-HIGHWAYS 0 0 0 .00 .00 .00 .0% 0129352 524034 MAINT CONTRACT-O 5,355 0 5,355 2,844.70 406.80 2,103.50 60.7% 0129352 527000 RENTALS 43,000 0 43,000 23,511.11 16,793.65 2,695.24 93.7% 0129352 527015 RENTALS EQUIPMEN 0 0 0 .00 .00 .00 .0% 0129352 527018 POSTAGE MACHINE 1,261 0 1,261 814.59 271.53 174.88 86.1% 0129352 527019 RENTAL-WATER COO 1,000 0 1,000 66.90 233.10 700.00 30.0% 0129352 530000 PROFESSIONL & TE 487,634 0 487,634 176,781.61 177,117.31 133,735.08 72.6%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 49 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0129352 530008 EMPLOYEE TRAININ 250 0 250 .00 .00 250.00 .0% 0129352 530011 ADVERTISING 8,500 0 8,500 1,290.00 1,710.00 5,500.00 35.3% 0129352 530018 POLICE DETAIL 0 0 0 .00 .00 .00 .0% 0129352 534003 POSTAGE 30,000 0 30,000 .00 30,000.00 .00 100.0% 0129352 534007 PSTN-USAGE 0 0 0 .00 .00 .00 .0% 0129352 542000 OFFICE SUPPLIES 8,500 0 8,500 2,970.20 2,383.36 3,146.44 63.0% 0129352 542001 PRINTING & STATI 49,000 0 49,000 9,377.75 7,515.00 32,107.25 34.5% 0129352 542004 COMPUTER SUPPLIE 0 0 0 .00 .00 .00 .0% 0129352 542005 OFFICE EQUIPMENT 250 0 250 .00 .00 250.00 .0% 0129352 542006 OFFICE FURNITURE 0 0 0 .00 .00 .00 .0% 0129352 542007 COMPUTER EQUIPME 850 0 850 .00 .00 850.00 .0% 0129352 542008 BOOKS & BOOKBIND 0 0 0 .00 .00 .00 .0% 0129352 543011 HARDWARE & SMALL 5,000 0 5,000 1,957.67 3,042.33 .00 100.0% 0129352 549000 FOOD SUPPLIES & 0 0 0 .00 .00 .00 .0% 0129352 553001 SIGNS AND CONES 97,000 0 97,000 15,129.65 34,967.35 46,903.00 51.6% 0129352 558003 PUBLIC SAFETY SU 0 0 0 .00 .00 .00 .0% 0129352 558006 UNIFORMS 3,500 0 3,500 .00 .00 3,500.00 .0% 0129352 558012 BADGES, EMBLEMS, 500 0 500 .00 .00 500.00 .0% 0129352 571000 IN STATE TRAVEL 0 0 0 .00 .00 .00 .0% 0129352 571001 IN STATE CONFERE 900 0 900 165.00 .00 735.00 18.3% 0129352 572000 OUT OF STATE TRA 0 0 0 .00 .00 .00 .0% 0129352 573000 DUES AND MEMBERS 900 0 900 .00 .00 900.00 .0% 0129352 578001 CREDIT CARD CONV 319,000 0 319,000 119,620.17 129,424.57 69,955.26 78.1% 0129352 578037 COVID 19 OM EXP 0 0 0 .00 .00 .00 .0% TOTAL PARKING ORD MAINT 1,146,340 0 1,146,340 372,376.16 406,801.18 367,162.66 68.0% 0129358 PARKING CAPITAL 0129358 585001 VEHICLES 0 0 0 .00 .00 .00 .0% 0129358 588509 PARKING METER IN 0 0 0 .00 .00 .00 .0% TOTAL PARKING CAPITAL 0 0 0 .00 .00 .00 .0% 0129360 PARK SPECIAL ITEM 0129360 578037 COVID 19 OM EXP 0 0 0 .00 .00 .00 .0% TOTAL PARK SPECIAL ITEM 0 0 0 .00 .00 .00 .0% 0140151 DPW-ADMIN PERSONAL SERVICES 0140151 511000 SALARIES 875,823 0 875,823 433,684.87 .00 442,138.13 49.5%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 50 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0140151 512000 SALARIES & WAGES 0 0 0 .00 .00 .00 .0% 0140151 513000 OVERTIME 11,275 0 11,275 234.48 .00 11,040.52 2.1% 0140151 513002 OVERTIME - LABOR 0 0 0 .00 .00 .00 .0% 0140151 514006 LONGEVITY 0 0 0 .00 .00 .00 .0% 0140151 514008 OUT OF GRADE 2,765 0 2,765 .00 .00 2,765.00 .0% 0140151 515006 HOLIDAYS NON-UNI 4,808 0 4,808 3,249.32 .00 1,558.68 67.6% 0140151 515011 HOLIDAYS - S.M.E 2,210 0 2,210 884.97 .00 1,325.03 40.0% 0140151 515012 PERFECT ATTENDAN 0 0 0 .00 .00 .00 .0% 0140151 519004 UNIFORM ALLOWANC 1,750 0 1,750 1,750.00 .00 .00 100.0% 0140151 519013 OTHER LUMP SUM P 0 0 0 .00 .00 .00 .0% 0140151 519999 RESERVED FOR REV 0 0 0 .00 .00 .00 .0% TOTAL DPW-ADMIN PERSONAL SERVICES 898,631 0 898,631 439,803.64 .00 458,827.36 48.9% 0140152 DPW-ADMIN ORDINARY MAINT 0140152 524000 REPAIRS AND MAIN 38,184 -28,211 9,973 600.00 .00 9,372.73 6.0% 0140152 524006 REPAIRS-COMMUN. 0 0 0 .00 .00 .00 .0% 0140152 524007 REPAIRS OFFICE E 0 0 0 .00 .00 .00 .0% 0140152 524034 MAINT CONTRACT-O 2,449 3,000 5,449 1,674.46 3,774.54 .00 100.0% 0140152 527006 LEASE - PHOTOCPI 3,975 0 3,975 367.67 632.33 2,975.00 25.2% 0140152 527015 RENTALS EQUIPMEN 0 0 0 .00 .00 .00 .0% 0140152 527018 POSTAGE MACHINE 3,074 0 3,074 157.41 .00 2,916.59 5.1% 0140152 527019 RENTAL-WATER COO 5,000 0 5,000 762.80 237.20 4,000.00 20.0% 0140152 529007 HAZARDOUS WASTE 0 0 0 .00 .00 .00 .0% 0140152 530000 PROFESSIONL & TE 210,000 0 210,000 113,318.10 90,515.54 6,166.36 97.1% 0140152 530008 EMPLOYEE TRAININ 30,000 0 30,000 5,172.17 951.00 23,876.83 20.4% 0140152 530011 ADVERTISING 0 0 0 .00 .00 .00 .0% 0140152 530018 POLICE DETAIL 35,600 -3,000 32,600 960.00 .00 31,640.00 2.9% 0140152 530020 FIRE DETAIL 1,000 -427 573 .00 .00 573.00 .0% 0140152 530025 IN SERVICE TRAIN 0 0 0 .00 .00 .00 .0% 0140152 530028 SOFTWARE SERVICE 0 0 0 .00 .00 .00 .0% 0140152 534003 POSTAGE 3,500 0 3,500 3,500.00 .00 .00 100.0% 0140152 534006 EXPRESS/FREIGHT 0 0 0 .00 .00 .00 .0% 0140152 542000 OFFICE SUPPLIES 11,000 0 11,000 5,411.32 5,088.68 500.00 95.5% 0140152 542001 PRINTING & STATI 6,000 5,238 11,238 9,512.50 1,725.00 .00 100.0% 0140152 542005 OFFICE EQUIPMENT 12,116 0 12,116 1,361.74 287.20 10,467.06 13.6% 0140152 542008 BOOKS & BOOKBIND 0 0 0 .00 .00 .00 .0% 0140152 548001 MOTOR GAS AND OI 450,000 0 450,000 198,131.26 151,868.74 100,000.00 77.8% 0140152 549000 FOOD SUPPLIES & 10,000 0 10,000 4,000.00 .00 6,000.00 40.0% 0140152 550000 MEDICAL/DENTAL S 0 0 0 .00 .00 .00 .0% 0140152 553001 SIGNS AND CONES 0 3,000 3,000 148.00 460.00 2,392.00 20.3%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 51 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0140152 558003 PUBLIC SAFETY SU 7,975 401 8,376 4,257.90 4,117.87 .00 100.0% 0140152 558004 MAGAZINES/SUBSCR 2,725 0 2,725 .00 .00 2,725.00 .0% 0140152 558006 UNIFORMS 41,500 20,000 61,500 51,228.65 9,093.63 1,177.72 98.1% 0140152 571000 IN STATE TRAVEL 3,000 0 3,000 50.20 349.80 2,600.00 13.3% 0140152 571001 IN STATE CONFERE 0 0 0 .00 .00 .00 .0% 0140152 573000 DUES AND MEMBERS 5,000 0 5,000 .00 .00 5,000.00 .0% 0140152 578007 REIMB OF LICENSE 5,000 0 5,000 585.00 170.00 4,245.00 15.1% 0140152 578010 RECORDINGS 0 0 0 .00 .00 .00 .0% TOTAL DPW-ADMIN ORDINARY MAINT 887,098 0 887,098 401,199.18 269,271.53 216,627.29 75.6% 0140158 DPW-ADMIN CAPITAL OUTLAY 0140158 530006 ENGINEER'G/ARCHI 0 0 0 .00 .00 .00 .0% TOTAL DPW-ADMIN CAPITAL OUTLAY 0 0 0 .00 .00 .00 .0% 0140160 DPW ADMINSTRATION SPECIAL ITEM 0140160 578037 COVID 19 OM EXP 0 0 0 .00 .00 .00 .0% TOTAL DPW ADMINSTRATION SPECIAL ITEM 0 0 0 .00 .00 .00 .0% 0140251 DPW-ELEC PERSONAL SERVICES 0140251 511000 SALARIES 5,216 0 5,216 .00 .00 5,216.00 .0% 0140251 511300 WAGES 367,185 0 367,185 115,540.87 .00 251,644.13 31.5% 0140251 513000 OVERTIME 0 0 0 .00 .00 .00 .0% 0140251 513002 OVERTIME - LABOR 110,000 0 110,000 67,085.90 .00 42,914.10 61.0% 0140251 514004 SHIFT DIFFERENTI 0 0 0 .00 .00 .00 .0% 0140251 514006 LONGEVITY 3,950 0 3,950 850.00 .00 3,100.00 21.5% 0140251 514008 OUT OF GRADE 0 0 0 .00 .00 .00 .0% 0140251 514009 LONGEVITY-LABOR 3,950 0 3,950 .00 .00 3,950.00 .0% 0140251 514010 OUT OF GRADE-LAB 8,800 0 8,800 2,197.58 .00 6,602.42 25.0% 0140251 514015 OTHER DIFFERENTI 9,580 0 9,580 4,631.64 .00 4,948.36 48.3% 0140251 515006 HOLIDAYS NON-UNI 0 0 0 .00 .00 .00 .0% 0140251 515011 HOLIDAYS - S.M.E 2,312 0 2,312 878.42 .00 1,433.58 38.0% 0140251 515012 PERFECT ATTENDAN 0 0 0 .00 .00 .00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 52 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0140251 519004 UNIFORM ALLOWANC 1,050 0 1,050 1,050.00 .00 .00 100.0% 0140251 519013 OTHER LUMP SUM P 0 0 0 .00 .00 .00 .0% 0140251 519015 AUTO ALLOWANCE 0 0 0 .00 .00 .00 .0% 0140251 519030 COVID19 PERSONAL 0 0 0 .00 .00 .00 .0% 0140251 519999 RESERVED FOR REV 0 0 0 .00 .00 .00 .0% TOTAL DPW-ELEC PERSONAL SERVICES 512,043 0 512,043 192,234.41 .00 319,808.59 37.5% 0140252 DPW-ELEC ORDINARY MAINT 0140252 524001 R&M - BUILDINGS 0 0 0 .00 .00 .00 .0% 0140252 524004 REPAIRS-TRAFFIC 90,000 0 90,000 19,450.98 15,831.06 54,717.96 39.2% 0140252 524006 REPAIRS-COMMUN. 20,000 0 20,000 .00 .00 20,000.00 .0% 0140252 524021 REPAIRS-FIRE ALA 40,000 0 40,000 8,001.82 19,230.49 12,767.69 68.1% 0140252 524032 REPAIRS TO LIGHT 60,000 0 60,000 .00 .00 60,000.00 .0% 0140252 530000 PROFESSIONL & TE 145,000 -40,000 105,000 .00 .00 105,000.00 .0% 0140252 530008 EMPLOYEE TRAININ 0 0 0 .00 .00 .00 .0% 0140252 534005 PRINTING 0 0 0 .00 .00 .00 .0% 0140252 542000 OFFICE SUPPLIES 0 0 0 .00 .00 .00 .0% 0140252 542001 STATIONERY 0 0 0 .00 .00 .00 .0% 0140252 542006 OFFICE FURNITURE 0 0 0 .00 .00 .00 .0% 0140252 542007 COMPUTER EQUIPME 0 0 0 .00 .00 .00 .0% 0140252 542008 BOOKS & BOOKBIND 1,000 0 1,000 .00 .00 1,000.00 .0% 0140252 542009 TELECOM. EQUIP N 0 0 0 .00 .00 .00 .0% 0140252 543006 ELECTRICAL SUPPL 15,000 40,000 55,000 12,557.86 38,560.29 3,881.85 92.9% 0140252 543007 PAINT 1,500 0 1,500 .00 .00 1,500.00 .0% 0140252 543011 HARDWARE & SMALL 10,000 0 10,000 2,545.53 2,832.95 4,621.52 53.8% 0140252 553001 SIGNS AND CONES 0 0 0 .00 .00 .00 .0% 0140252 558004 MAGAZINES/SUBSCR 0 0 0 .00 .00 .00 .0% TOTAL DPW-ELEC ORDINARY MAINT 382,500 0 382,500 42,556.19 76,454.79 263,489.02 31.1% 0140258 DPW-ELEC CAPITAL OUTLAY 0140258 585000 EQUIPMENT 0 0 0 .00 .00 .00 .0% 0140258 585002 EQUIPMENT-COMMUN 0 0 0 .00 .00 .00 .0% 0140258 588004 STREET AND TRAFF 0 0 0 .00 .00 .00 .0% TOTAL DPW-ELEC CAPITAL OUTLAY 0 0 0 .00 .00 .00 .0% 0140351 ENGINEERING PERSONAL SVC 0140351 511000 SALARIES 646,929 5,715 652,644 292,662.11 .00 359,982.31 44.8%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 53 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0140351 512000 SALARIES & WAGES 8,000 0 8,000 4,800.00 .00 3,200.00 60.0% 0140351 513000 OVERTIME 12,360 0 12,360 .00 .00 12,360.00 .0% 0140351 514004 SHIFT DIFFERENTI 0 0 0 .00 .00 .00 .0% 0140351 514006 LONGEVITY 0 0 0 .00 .00 .00 .0% 0140351 514015 OTHER DIFFERENTI 1,035 0 1,035 .00 .00 1,035.00 .0% 0140351 515006 HOLIDAYS NON-UNI 4,795 0 4,795 2,930.37 .00 1,864.63 61.1% 0140351 515011 HOLIDAYS - S.M.E 246 0 246 .00 .00 246.00 .0% 0140351 515012 PERFECT ATTENDAN 0 0 0 .00 .00 .00 .0% 0140351 519004 UNIFORM ALLOWANC 140 210 350 350.00 .00 .00 100.0% 0140351 519013 OTHER LUMP SUM P 0 0 0 .00 .00 .00 .0% 0140351 519015 AUTO ALLOWANCE 0 0 0 .00 .00 .00 .0% 0140351 519999 RESERVED FOR REV 0 0 0 .00 .00 .00 .0% TOTAL ENGINEERING PERSONAL SVC 673,505 5,925 679,430 300,742.48 .00 378,687.94 44.3% 0140352 ENGINEERING ORDINARY MAINT 0140352 524007 REPAIRS OFFICE E 0 0 0 .00 .00 .00 .0% 0140352 524029 R&M - HIGHWAYS 316,506 0 316,506 258,116.97 51,882.03 6,507.00 97.9% 0140352 524034 R&M - SERVICE CO 0 0 0 .00 .00 .00 .0% 0140352 524036 CABLING NON CAPI 0 0 0 .00 .00 .00 .0% 0140352 527006 LEASE - PHOTOCPI 0 0 0 .00 .00 .00 .0% 0140352 527019 RENTAL-WATER COO 0 0 0 .00 .00 .00 .0% 0140352 530000 PROFESSIONAL & T 110,000 0 110,000 55,060.50 404.00 54,535.50 50.4% 0140352 530006 ENGINEER'G/ARCHI 0 0 0 .00 .00 .00 .0% 0140352 530008 EMPLOYEE TRAININ 0 0 0 .00 .00 .00 .0% 0140352 530025 IN SERVICE TRAIN 0 0 0 .00 .00 .00 .0% 0140352 530028 SOFTWARE SERVICE 0 0 0 .00 .00 .00 .0% 0140352 534003 POSTAGE 0 0 0 .00 .00 .00 .0% 0140352 534006 EXPRESS/FREIGHT 0 0 0 .00 .00 .00 .0% 0140352 542000 OFFICE SUPPLIES 0 0 0 .00 .00 .00 .0% 0140352 542001 PRINTING & STATI 0 0 0 .00 .00 .00 .0% 0140352 542005 OFFICE EQUIPMENT 0 0 0 .00 .00 .00 .0% 0140352 542006 OFFICE FURNITURE 0 0 0 .00 .00 .00 .0% 0140352 542007 COMPUTER EQUIPME 0 0 0 .00 .00 .00 .0% 0140352 543007 PAINT 0 0 0 .00 .00 .00 .0% 0140352 543011 HARDWARE & SMALL 0 0 0 .00 .00 .00 .0% 0140352 545000 SUNDRY MAINT SUP 0 0 0 .00 .00 .00 .0% 0140352 553001 SIGNS AND CONES 0 0 0 .00 .00 .00 .0% 0140352 558004 MAGAZINES/SUBSCR 0 0 0 .00 .00 .00 .0% 0140352 558006 UNIFORMS 0 0 0 .00 .00 .00 .0% 0140352 571001 IN STATE CONFERE 0 0 0 .00 .00 .00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 54 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0140352 572000 OUT OF STATE TRA 0 0 0 .00 .00 .00 .0% 0140352 572001 OUT OF STATE CON 0 0 0 .00 .00 .00 .0% 0140352 573000 DUES AND MEMBERS 0 0 0 .00 .00 .00 .0% TOTAL ENGINEERING ORDINARY MAINT 426,506 0 426,506 313,177.47 52,286.03 61,042.50 85.7% 0140358 ENGINEERING CAPITAL 0140358 530006 ENGINEER'G/ARCHI 200,000 0 200,000 27,067.50 133,482.50 39,450.00 80.3% 0140358 588002 INFR-STREET REPA 0 0 0 .00 .00 .00 .0% TOTAL ENGINEERING CAPITAL 200,000 0 200,000 27,067.50 133,482.50 39,450.00 80.3% 0140451 DPW-SNOW REMVL PERSONAL SVC 0140451 511000 SALARIES 0 0 0 .00 .00 .00 .0% 0140451 513000 OVERTIME 0 0 0 1,175.19 .00 -1,175.19 100.0% 0140451 515006 HOLIDAYS NON-UNI 0 0 0 .00 .00 .00 .0% TOTAL DPW-SNOW REMVL PERSONAL SVC 0 0 0 1,175.19 .00 -1,175.19 100.0% 0140452 DPW-SNOW REMVL ORDINARY MAINT 0140452 529002 SNOW REMOVAL 1,653,150 0 1,653,150 608,756.47 4,609,169.68 -3,564,776.15 315.6% 0140452 530018 POLICE DETAIL 34,338 0 34,338 .00 .00 34,338.00 .0% 0140452 585000 EQUIPMENT 0 28,200 28,200 49,231.79 57,492.64 -78,524.43 378.5% TOTAL DPW-SNOW REMVL ORDINARY MAINT 1,687,488 28,200 1,715,688 657,988.26 4,666,662.32 -3,608,962.58 310.4% 0140458 DPW-SNOW REMVL CAPITAL OUTLAY 0140458 585001 VEHICLES 0 0 0 .00 .00 .00 .0% TOTAL DPW-SNOW REMVL CAPITAL OUTLAY 0 0 0 .00 .00 .00 .0% 0140551 DPW HIGHWAY PERSONAL SERVCS 0140551 511000 SALARIES 217,975 0 217,975 117,231.22 .00 100,743.78 53.8%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 55 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0140551 511300 WAGES 2,130,625 -17,959 2,112,666 967,378.63 .00 1,145,287.50 45.8% 0140551 513000 OVERTIME 0 0 0 .00 .00 .00 .0% 0140551 513002 OVERTIME - LABOR 522,000 -10,619 511,381 359,944.88 .00 151,436.12 70.4% 0140551 514004 SHIFT DIFFERENTI 0 0 0 .00 .00 .00 .0% 0140551 514006 LONGEVITY 23,200 0 23,200 9,750.00 .00 13,450.00 42.0% 0140551 514008 OUT OF GRADE 0 0 0 .00 .00 .00 .0% 0140551 514009 LONGEVITY-LABOR 34,000 0 34,000 .00 .00 34,000.00 .0% 0140551 514010 OUT OF GRADE-LAB 32,365 0 32,365 16,899.63 .00 15,465.37 52.2% 0140551 514015 OTHER DIFFERENTI 16,711 22,545 39,256 38,495.39 .00 760.48 98.1% 0140551 515006 HOLIDAYS NON-UNI 1,686 0 1,686 1,214.95 .00 471.05 72.1% 0140551 515011 HOLIDAYS - S.M.E 17,276 0 17,276 7,540.92 .00 9,735.08 43.6% 0140551 515012 PERFECT ATTENDAN 0 200 200 200.00 .00 .00 100.0% 0140551 519004 UNIFORM ALLOWANC 3,267 5,833 9,100 9,100.00 .00 .00 100.0% 0140551 519013 OTHER LUMP SUM P 0 0 0 .00 .00 .00 .0% 0140551 519030 COVID19 PERSONAL 0 0 0 .00 .00 .00 .0% 0140551 519999 RESERVED FOR REV 0 0 0 .00 .00 .00 .0% TOTAL DPW HIGHWAY PERSONAL SERVCS 2,999,105 0 2,999,105 1,527,755.62 .00 1,471,349.38 50.9% 0140552 DPW HIGHWAY ORDINARY MAINT 0140552 524003 REPAIRS-VEHICLES 0 0 0 .00 .00 .00 .0% 0140552 524013 REPAIRS-TOOLS & 5,000 0 5,000 832.21 1,635.34 2,532.45 49.4% 0140552 524014 R&M - PAVING 120,000 -25,000 95,000 32,000.00 .00 63,000.00 33.7% 0140552 524017 EQUIP MAINTENANC 0 0 0 .00 .00 .00 .0% 0140552 524018 FENCE INSTALLATI 15,000 0 15,000 .00 .00 15,000.00 .0% 0140552 524029 REPAIRS-HIGHWAYS 0 0 0 .00 .00 .00 .0% 0140552 527015 RENTALS EQUIPMEN 15,000 0 15,000 .00 .00 15,000.00 .0% 0140552 527016 RENTALS - VEHICL 40,000 0 40,000 .00 .00 40,000.00 .0% 0140552 529003 RUBBISH REMOVAL 160,000 140,000 300,000 189,169.60 105,829.40 5,001.00 98.3% 0140552 529005 CARE OF TREES 0 0 0 .00 .00 .00 .0% 0140552 530000 PROFESSIONL & TE 540,000 -20,000 520,000 158,866.00 221,134.00 140,000.00 73.1% 0140552 530008 EMPLOYEE TRAININ 0 0 0 .00 .00 .00 .0% 0140552 530011 ADVERTISING 1,000 0 1,000 .00 .00 1,000.00 .0% 0140552 530021 TOWING 0 0 0 .00 .00 .00 .0% 0140552 530028 SOFTWARE SERVICE 0 0 0 .00 .00 .00 .0% 0140552 534003 POSTAGE 0 0 0 .00 .00 .00 .0% 0140552 542000 OFFICE SUPPLIES 0 0 0 .00 .00 .00 .0% 0140552 542001 STATIONERY 0 0 0 .00 .00 .00 .0% 0140552 542006 OFFICE FURNITURE 0 0 0 .00 .00 .00 .0% 0140552 542007 COMPUTER EQUIPME 0 0 0 .00 .00 .00 .0% 0140552 542008 BOOKS & BOOKBIND 0 0 0 .00 .00 .00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 56 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0140552 542012 OTH EQUIPMENT NO 10,000 0 10,000 .00 .00 10,000.00 .0% 0140552 543003 TOOLS 10,000 0 10,000 .00 .00 10,000.00 .0% 0140552 543007 PAINT 5,000 0 5,000 .00 .00 5,000.00 .0% 0140552 543008 GLASS 0 0 0 .00 .00 .00 .0% 0140552 543011 HARDWARE & SMALL 10,000 0 10,000 3,847.24 1,933.92 4,218.84 57.8% 0140552 546000 GROUNDSKEEPING S 0 0 0 .00 .00 .00 .0% 0140552 548004 TIRES AND TUBES 0 0 0 .00 .00 .00 .0% 0140552 548006 MOTOR PARTS & AC 0 0 0 .00 .00 .00 .0% 0140552 550000 MEDICAL/DENTAL S 0 0 0 .00 .00 .00 .0% 0140552 553000 SAND AND GRAVEL 1,200 0 1,200 .00 .00 1,200.00 .0% 0140552 553001 SIGNS AND CONES 75,000 -65,000 10,000 358.00 .00 9,642.00 3.6% 0140552 553002 BITUMINOUS SUPPL 75,000 0 75,000 12,734.76 41,656.24 20,609.00 72.5% 0140552 553003 READY MIX CONCRE 155,000 -30,000 125,000 53,071.62 46,928.38 25,000.00 80.0% 0140552 553004 LUMBER & WOOD PR 5,000 0 5,000 .00 .00 5,000.00 .0% 0140552 553006 MASONRY SUPPLIES 5,000 0 5,000 .00 .00 5,000.00 .0% 0140552 558000 OTHER SUPPLIES 0 0 0 .00 .00 .00 .0% 0140552 558004 MAGAZINES/SUBSCR 0 0 0 .00 .00 .00 .0% 0140552 558006 UNIFORMS 0 0 0 .00 .00 .00 .0% 0140552 571000 IN STATE TRAVEL 0 0 0 .00 .00 .00 .0% 0140552 585000 EQUIPMENT 0 0 0 .00 .00 .00 .0% 0140552 588005 INFR-SIDEWALK RE 0 0 0 .00 .00 .00 .0% TOTAL DPW HIGHWAY ORDINARY MAINT 1,247,200 0 1,247,200 450,879.43 419,117.28 377,203.29 69.8% 0140558 DPW HIGHWAY CAPITAL OUTLAY 0140558 585001 VEHICLES 0 0 0 .00 .00 .00 .0% 0140558 585002 EQUIPMENT-COMMUN 0 0 0 .00 .00 .00 .0% 0140558 588002 STREET REPAIRS 0 0 0 .00 .00 .00 .0% TOTAL DPW HIGHWAY CAPITAL OUTLAY 0 0 0 .00 .00 .00 .0% 0140560 DPW HIGHWAY SPECIAL 0140560 578037 COVID 19 OM EXP 0 0 0 .00 .00 .00 .0% TOTAL DPW HIGHWAY SPECIAL 0 0 0 .00 .00 .00 .0% 0140652 DPW-SANITATION ORDINARY MAINT 0140652 524001 R&M - BUILDINGS 0 0 0 .00 .00 .00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 57 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0140652 524013 R&M - TOOLS & EQ 0 0 0 .00 .00 .00 .0% 0140652 529003 RUBBISH REMOVAL 1,882,000 0 1,882,000 616,798.40 1,241,710.91 23,490.69 98.8% 0140652 529006 RECYCLING 1,150,000 0 1,150,000 515,027.64 534,742.36 100,230.00 91.3% 0140652 529007 HAZARDOUS WASTE 150,000 0 150,000 51,520.10 88,678.90 9,801.00 93.5% 0140652 529013 COMPOSTING 0 0 0 .00 .00 .00 .0% 0140652 530000 PROFESSIONL & TE 5,412,672 0 5,412,672 2,661,758.23 2,715,913.73 35,000.04 99.4% 0140652 530028 SOFTWARE SERVICE 0 0 0 .00 .00 .00 .0% 0140652 534003 POSTAGE 2,000 0 2,000 .00 .00 2,000.00 .0% 0140652 542001 PRINTING & STATI 3,000 0 3,000 1,878.55 .00 1,121.45 62.6% 0140652 553008 RECYCLING CARTS 120,000 0 120,000 82,600.00 .00 37,400.00 68.8% 0140652 558008 BENCHES & BARREL 136,351 0 136,351 37,880.92 98,470.08 .00 100.0% 0140652 558014 PHOTOGRAPHIC SUP 0 0 0 .00 .00 .00 .0% 0140652 571000 IN STATE TRAVEL 0 0 0 .00 .00 .00 .0% TOTAL DPW-SANITATION ORDINARY MAINT 8,856,023 0 8,856,023 3,967,463.84 4,679,515.98 209,043.18 97.6% 0140751 DPW-BUILDING PERSONAL SVC 0140751 511000 SALARIES 287,606 0 287,606 83,690.92 .00 203,915.08 29.1% 0140751 511300 WAGES 1,199,710 -27,551 1,172,159 570,809.33 .00 601,349.51 48.7% 0140751 513000 OVERTIME 118,235 19,952 138,187 138,187.08 .00 .00 100.0% 0140751 513002 OVERTIME - LABOR 210,000 -22,090 187,910 15,693.99 .00 172,216.09 8.4% 0140751 514004 SHIFT DIFFERENTI 0 0 0 .00 .00 .00 .0% 0140751 514006 LONGEVITY 17,950 0 17,950 9,050.00 .00 8,900.00 50.4% 0140751 514008 OUT OF GRADE 0 10,000 10,000 6,539.73 .00 3,460.27 65.4% 0140751 514009 LONGEVITY-LABOR 20,975 0 20,975 .00 .00 20,975.00 .0% 0140751 514010 OUT OF GRADE-LAB 8,850 0 8,850 .00 .00 8,850.00 .0% 0140751 514015 OTHER DIFFERENTI 41,999 0 41,999 22,329.01 .00 19,669.99 53.2% 0140751 515006 HOLIDAYS NON-UNI 2,286 0 2,286 1,186.51 .00 1,099.49 51.9% 0140751 515011 HOLIDAYS - S.M.E 9,976 0 9,976 4,212.97 .00 5,763.03 42.2% 0140751 515012 PERFECT ATTENDAN 0 3,600 3,600 3,600.00 .00 .00 100.0% 0140751 519004 UNIFORM ALLOWANC 7,262 0 7,262 6,300.00 .00 962.00 86.8% 0140751 519005 SICK LEAVE BUYBA 0 0 0 .00 .00 .00 .0% 0140751 519013 OTHER LUMP SUM P 1,000 18,072 19,072 19,071.62 .00 .38 100.0% 0140751 519015 AUTO ALLOWANCE 0 0 0 .00 .00 .00 .0% 0140751 519030 COVID19 PERSONAL 0 0 0 .00 .00 .00 .0% 0140751 519999 RESERVED FOR REV 0 0 0 .00 .00 .00 .0% TOTAL DPW-BUILDING PERSONAL SVC 1,925,849 1,983 1,927,832 880,671.16 .00 1,047,160.84 45.7% 0140752 DPW - BUILDINGS OM 0140752 521001 ELECTRICITY 2,750,000 0 2,750,000 1,847,263.50 599,421.05 303,315.45 89.0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 58 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0140752 521002 NATURAL GAS 800,000 0 800,000 207,926.56 526,803.44 65,270.00 91.8% 0140752 521005 OIL 100,000 0 100,000 16,379.69 58,620.31 25,000.00 75.0% 0140752 524001 REPAIRS-BUILDING 119,000 -8,534 110,466 15,024.95 19,562.62 75,878.43 31.3% 0140752 524002 REPAIRS PARKS & 0 0 0 .00 .00 .00 .0% 0140752 524010 HVAC MAINTENANCE 2,905,471 0 2,905,471 1,494,156.16 914,918.91 496,395.93 82.9% 0140752 524013 REPAIRS-TOOLS & 15,000 -10,000 5,000 .00 .00 5,000.00 .0% 0140752 524014 PAVING 0 0 0 .00 .00 .00 .0% 0140752 524017 R&M - OTHER EQUI 0 9,999 9,999 8,918.00 1,080.00 1.00 100.0% 0140752 524018 FENCE INSTALLATI 125,000 0 125,000 7,559.68 92,656.32 24,784.00 80.2% 0140752 524019 INTERIOR BLDG MA 775,000 -159,874 615,126 72,265.15 195,911.46 346,949.21 43.6% 0140752 524020 EXTERIOR BLDG MA 350,000 -62,225 287,775 53,664.88 77,497.48 156,612.64 45.6% 0140752 524021 FIRE ALARM & EXT 225,313 11,000 236,313 82,594.24 144,941.72 8,777.04 96.3% 0140752 524022 PROGRAM TIME CLO 30,000 5,000 35,000 .00 .00 35,000.00 .0% 0140752 524023 INTERCOM EQUIP R 12,000 0 12,000 .00 .00 12,000.00 .0% 0140752 524024 ELEVATORS R & M 150,000 0 150,000 66,210.00 57,167.50 26,622.50 82.3% 0140752 524025 PLUMBING R & M 75,000 10,407 85,407 3,640.38 71,359.62 10,407.23 87.8% 0140752 524026 ROOFING R & M 550,000 0 550,000 28,509.34 72,625.57 448,865.09 18.4% 0140752 524027 FLOOR COVERING R 400,000 0 400,000 5,429.43 41,724.30 352,846.27 11.8% 0140752 524031 REPAIRS TO PARK 0 0 0 .00 .00 .00 .0% 0140752 524032 R&M - LIGHTING 0 0 0 .00 .00 .00 .0% 0140752 524036 CABLING NON CAPI 0 0 0 .00 .00 .00 .0% 0140752 527000 RENTALS 0 0 0 .00 .00 .00 .0% 0140752 527001 RENTALS-BUILDING 0 11,060 11,060 .00 .00 11,059.72 .0% 0140752 527014 RENTAL - TABLES 0 10,889 10,889 10,888.95 .00 .00 100.0% 0140752 527015 RENTALS EQUIPMEN 80,000 51,113 131,113 59,940.98 70,983.64 188.38 99.9% 0140752 529009 ALARMS 120,000 0 120,000 47,990.10 41,704.90 30,305.00 74.7% 0140752 530000 PROFESSIONL & TE 190,000 0 190,000 33,903.84 34,013.22 122,082.94 35.7% 0140752 530020 FIRE DETAIL 0 0 0 .00 .00 .00 .0% 0140752 530021 TOWING 0 0 0 .00 .00 .00 .0% 0140752 530028 SOFTWARE SERVICE 0 0 0 .00 .00 .00 .0% 0140752 534003 POSTAGE 0 0 0 .00 .00 .00 .0% 0140752 534006 EXPRESS/FREIGHT 0 0 0 .00 .00 .00 .0% 0140752 534011 LICENSING FEES 0 0 0 .00 .00 .00 .0% 0140752 538004 EXTERMINATION 100,000 0 100,000 32,722.50 51,808.82 15,468.68 84.5% 0140752 538008 MOVING SERVICES 105,000 300,001 405,001 202,434.57 69,565.43 133,001.00 67.2% 0140752 542000 OFFICE SUPPLIES 0 0 0 .00 .00 .00 .0% 0140752 542001 PRINTING & STATI 0 0 0 .00 .00 .00 .0% 0140752 542005 OFFICE EQUIPMENT 0 0 0 .00 .00 .00 .0% 0140752 542006 OFFICE FURNITURE 30,000 0 30,000 3,675.99 .00 26,324.01 12.3% 0140752 542007 COMPUTER EQUIPME 0 0 0 .00 .00 .00 .0% 0140752 542012 OTH EQUIPMENT NO 50,000 0 50,000 23,722.47 4,363.53 21,914.00 56.2% 0140752 543002 PLUMBING SUPPLIE 100,000 0 100,000 18,394.75 27,312.00 54,293.25 45.7% 0140752 543006 ELECTRICAL SUPPL 55,000 0 55,000 11,868.77 19,914.30 23,216.93 57.8% 0140752 543007 PAINT 20,000 0 20,000 .00 20,000.00 .00 100.0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 59 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0140752 543008 GLASS 100,000 0 100,000 7,312.47 3,557.02 89,130.51 10.9% 0140752 543011 HARDWARE & SMALL 0 50,000 50,000 23,944.96 21,044.08 5,010.96 90.0% 0140752 545000 SUNDRY MAINT SUP 265,000 0 265,000 149,738.91 90,695.11 24,565.98 90.7% 0140752 546000 GROUNDSKEEPING S 0 0 0 .00 .00 .00 .0% 0140752 546003 LOAM,SOD,FERTILI 0 0 0 .00 .00 .00 .0% 0140752 548001 MOTOR GAS AND OI 0 0 0 .00 .00 .00 .0% 0140752 548006 MOTOR PARTS & AC 0 0 0 .00 .00 .00 .0% 0140752 548007 VEHICLES NOT CAP 0 0 0 .00 .00 .00 .0% 0140752 549000 FOOD SUPPLIES & 0 0 0 .00 .00 .00 .0% 0140752 550000 MEDICAL/DENTAL S 0 0 0 .00 .00 .00 .0% 0140752 551010 AUDIO VISUAL SUP 0 0 0 .00 .00 .00 .0% 0140752 553001 SIGNS AND CONES 0 0 0 .00 .00 .00 .0% 0140752 553004 LUMBER & WOOD PR 0 0 0 .00 .00 .00 .0% 0140752 558000 OTHER SUPPLIES 15,000 0 15,000 175.18 .00 14,824.82 1.2% 0140752 558006 UNIFORMS 0 0 0 .00 .00 .00 .0% 0140752 558011 FLOWERS & FLAGS 0 0 0 .00 .00 .00 .0% 0140752 572000 OUT OF STATE TRA 0 0 0 .00 .00 .00 .0% 0140752 574000 INSURANCE PREMIU 0 0 0 .00 .00 .00 .0% 0140752 578009 HOLIDAY LIGHTING 0 0 0 .00 .00 .00 .0% 0140752 585019 CABLING 0 0 0 .00 .00 .00 .0% TOTAL DPW - BUILDINGS OM 10,611,784 218,836 10,830,620 4,536,256.40 3,329,252.35 2,965,110.97 72.6% 0140758 DPW - BUILDINGS CAPITAL 0140758 582003 BUILDING IMPROVE 0 0 0 .00 .00 .00 .0% 0140758 585000 EQUIPMENT 0 0 0 .00 .00 .00 .0% 0140758 588003 PAVING 0 0 0 .00 .00 .00 .0% TOTAL DPW - BUILDINGS CAPITAL 0 0 0 .00 .00 .00 .0% 0140760 DPW - BUILDINGS SPECIAL 0140760 578037 COVID 19 OM EXP 0 0 0 .00 .00 .00 .0% TOTAL DPW - BUILDINGS SPECIAL 0 0 0 .00 .00 .00 .0% 0140852 DPW FLEET ORDINARY MAINTENANCE 0140852 524003 R&M - VEHICLES 120,000 50,000 170,000 63,461.66 66,344.38 40,193.96 76.4%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 60 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0140852 524013 R&M - TOOLS & EQ 3,000 8,299 11,299 670.35 8,143.68 2,485.00 78.0% 0140852 524014 R&M - PAVING 0 0 0 .00 .00 .00 .0% 0140852 524017 R&M - OTHER EQUI 0 0 0 .00 .00 .00 .0% 0140852 524018 R&M - FENCE 0 0 0 .00 .00 .00 .0% 0140852 524029 R&M - HIGHWAYS 0 0 0 .00 .00 .00 .0% 0140852 524036 CABLING NON CAPI 0 0 0 .00 .00 .00 .0% 0140852 527015 RENTALS EQUIPMEN 0 0 0 .00 .00 .00 .0% 0140852 527016 RENTALS - VEHICL 0 0 0 .00 .00 .00 .0% 0140852 529003 RUBBISH REMOVAL 0 0 0 .00 .00 .00 .0% 0140852 529005 CARE OF TREES 0 0 0 .00 .00 .00 .0% 0140852 530000 PROFESSIONAL & T 75,000 -10,000 65,000 .00 19,443.75 45,556.25 29.9% 0140852 530008 EMPLOYEE TRAININ 0 0 0 .00 .00 .00 .0% 0140852 530011 ADVERTISING 0 0 0 .00 .00 .00 .0% 0140852 530021 TOWING 10,000 15,000 25,000 10,931.31 9,452.63 4,616.06 81.5% 0140852 530028 SOFTWARE SERVICE 15,000 0 15,000 13,980.00 .00 1,020.00 93.2% 0140852 542000 OFFICE SUPPLIES 0 0 0 .00 .00 .00 .0% 0140852 542001 PRINTING & STATI 0 0 0 .00 .00 .00 .0% 0140852 542005 OFFICE EQUIPMENT 0 0 0 .00 .00 .00 .0% 0140852 542006 OFFICE FURNITURE 0 0 0 .00 .00 .00 .0% 0140852 542007 COMPUTER EQUIPME 12,000 0 12,000 9,985.86 .00 2,014.14 83.2% 0140852 542008 BOOKS & BOOKBIND 0 0 0 .00 .00 .00 .0% 0140852 542009 TELECOM. EQUIP N 6,400 0 6,400 .00 .00 6,400.00 .0% 0140852 543003 TOOLS 35,000 -6,000 29,000 .00 .00 29,000.00 .0% 0140852 543007 PAINT 0 0 0 .00 .00 .00 .0% 0140852 543008 GLASS 5,000 0 5,000 1,617.34 .00 3,382.66 32.3% 0140852 543011 HARDWARE & SMALL 20,000 -2,299 17,701 2,585.57 4,148.48 10,966.92 38.0% 0140852 546000 GROUNDSKEEPING S 0 0 0 .00 .00 .00 .0% 0140852 548004 TIRES AND TUBES 40,000 0 40,000 17,580.56 1,425.28 20,994.16 47.5% 0140852 548006 MOTOR PARTS & AC 300,000 -55,000 245,000 121,074.11 73,508.44 50,417.45 79.4% 0140852 550000 MEDICAL & DENTAL 30 0 30 .00 .00 30.00 .0% 0140852 553000 PUBLIC WORKS SUP 0 0 0 .00 .00 .00 .0% 0140852 553001 SIGNS AND CONES 0 0 0 .00 .00 .00 .0% 0140852 553002 BITUMINOUS SUPPL 0 0 0 .00 .00 .00 .0% 0140852 553003 READY MIX CONCRE 0 0 0 .00 .00 .00 .0% 0140852 553004 LUMBER & WOOD PR 0 0 0 .00 .00 .00 .0% 0140852 553006 MASONRY SUPPLIES 0 0 0 .00 .00 .00 .0% 0140852 558000 OTHER SUPPLIES 0 0 0 .00 .00 .00 .0% 0140852 558004 MAGAZINES/SUBSCR 0 0 0 .00 .00 .00 .0% 0140852 558006 UNIFORMS 0 0 0 .00 .00 .00 .0% 0140852 585019 CABLING 0 0 0 .00 .00 .00 .0% TOTAL DPW FLEET ORDINARY MAINTENANCE 641,430 0 641,430 241,886.76 182,466.64 217,076.60 66.2% 0140951 DPW GROUNDS PERSONAL SERVICE 0140951 511000 SALARIES 216,885 0 216,885 119,728.55 .00 97,156.45 55.2%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 61 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0140951 511300 WAGES - HOURLY P 948,932 -28,569 920,363 360,234.92 .00 560,128.39 39.1% 0140951 513002 OVERTIME - LABOR 200,000 -22,109 177,891 133,414.04 .00 44,477.08 75.0% 0140951 514006 LONGEVITY 10,500 0 10,500 5,000.00 .00 5,500.00 47.6% 0140951 514010 OUT OF GRADE-LAB 0 20,000 20,000 14,190.92 .00 5,809.08 71.0% 0140951 514015 OTHER DIFFERENTI 31,520 0 31,520 12,869.85 .00 18,650.15 40.8% 0140951 515006 HOLIDAYS NON-UNI 1,674 0 1,674 1,238.58 .00 435.42 74.0% 0140951 515011 HOLIDAYS - S.M.E 7,928 0 7,928 2,375.84 .00 5,552.16 30.0% 0140951 515012 PERFECT ATTENDAN 0 200 200 200.00 .00 .00 100.0% 0140951 519004 UNIFORM ALLOWANC 5,571 0 5,571 4,900.00 .00 671.00 88.0% 0140951 519013 OTHER LUMP SUM P 0 30,478 30,478 30,477.57 .00 .00 100.0% TOTAL DPW GROUNDS PERSONAL SERVICE 1,423,010 0 1,423,010 684,630.27 .00 738,379.73 48.1% 0140952 DPW GROUNDS ORDINARY MAINTENAN 0140952 524002 R&M - REC FACIL/ 610,000 -10,200 599,800 312,725.37 283,096.82 3,977.81 99.3% 0140952 524031 REPAIRS TO PARK 20,000 -16,605 3,395 .00 .00 3,394.81 .0% 0140952 529005 CARE OF TREES 372,645 0 372,645 230,865.65 91,980.00 49,799.35 86.6% 0140952 530000 PROFESSIONAL & T 56,300 0 56,300 9,939.84 12,000.00 34,360.16 39.0% 0140952 542012 OTH EQUIPMENT NO 65,000 -7,500 57,500 .00 488.75 57,011.25 .9% 0140952 543011 HARDWARE & SMALL 0 12,000 12,000 11,610.90 3.88 385.22 96.8% 0140952 546000 GROUNDSKEEPING S 50,000 -2,000 48,000 18,049.35 7,899.60 22,051.05 54.1% 0140952 546003 LOAM,SOD,FERTILI 20,000 0 20,000 221.25 .00 19,778.75 1.1% 0140952 549000 FOOD SUPPLIES & 0 0 0 .00 .00 .00 .0% 0140952 553004 LUMBER & WOOD PR 0 0 0 .00 .00 .00 .0% 0140952 558006 UNIFORMS 0 0 0 .00 .00 .00 .0% 0140952 558011 FLOWERS & FLAGS 75,000 1,428 76,428 15,071.08 41,280.85 20,075.98 73.7% 0140952 558012 BADGES,EMBLEMS,T 0 1,000 1,000 350.00 .00 650.00 35.0% 0140952 571000 IN STATE TRAVEL 0 377 377 376.49 .79 .00 100.0% 0140952 578009 HOLIDAY LIGHTING 60,000 21,500 81,500 77,734.65 3,765.35 .00 100.0% TOTAL DPW GROUNDS ORDINARY MAINTENAN 1,328,945 0 1,328,945 676,944.58 440,516.04 211,484.38 84.1% 0141051 DPW-FIELD MAINT PS 0141051 511000 SALARIES 0 136,338 136,338 65,919.68 .00 70,418.32 48.4% 0141051 513000 OVERTIME 0 20,000 20,000 14,072.75 .00 5,927.25 70.4% 0141051 514006 LONGEVITY 0 600 600 300.00 .00 300.00 50.0% 0141051 514015 OTHER DIFFERENTI 0 5,474 5,474 2,636.79 .00 2,837.21 48.2% 0141051 515006 HOLIDAYS NON-UNI 0 361 361 .00 .00 361.00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 62 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0141051 515011 HOLIDAYS - S.M.E 0 1,296 1,296 500.08 .00 795.92 38.6% 0141051 515012 PERFECT ATTENDAN 0 0 0 .00 .00 .00 .0% 0141051 519004 UNIFORM ALLOWANC 0 1,050 1,050 700.00 .00 350.00 66.7% TOTAL DPW-FIELD MAINT PS 0 165,119 165,119 84,129.30 .00 80,989.70 51.0% 0141052 DPW-FIELDS MAINT OM 0141052 524002 R&M - REC FACIL/ 0 15,000 15,000 11,559.00 .00 3,441.00 77.1% 0141052 524017 R&M - OTHER EQUI 0 5,000 5,000 1,180.59 .00 3,819.41 23.6% 0141052 524018 R&M - FENCE 0 10,869 10,869 10,869.00 .00 .00 100.0% 0141052 524031 REPAIRS TO PARK 0 5,000 5,000 .00 .00 5,000.00 .0% 0141052 527001 RENTAL - BUILDIN 0 25,000 25,000 .00 .00 25,000.00 .0% 0141052 527020 RENTAL- EQUIPMEN 0 1,000 1,000 .00 .00 1,000.00 .0% 0141052 530000 PROFESSIONAL & T 0 134,631 134,631 50,855.10 .00 83,775.90 37.8% 0141052 542000 OFFICE SUPPLIES 0 0 0 .00 .00 .00 .0% 0141052 543007 PAINT 0 20,000 20,000 19,231.00 .00 769.00 96.2% 0141052 546000 GROUNDSKEEPING S 0 29,000 29,000 8,410.46 7,178.93 13,410.61 53.8% 0141052 546003 LOAM,SOD,FERTILI 0 30,000 30,000 20,025.00 .00 9,975.00 66.8% 0141052 571000 IN STATE TRAVEL 0 1,500 1,500 .00 .00 1,500.00 .0% TOTAL DPW-FIELDS MAINT OM 0 277,000 277,000 122,130.15 7,178.93 147,690.92 46.7% 0141151 DPW-SCHL CUSTDN PERSONAL SVC 0141151 511000 SALARIES 2,310,290 76,400 2,386,690 1,292,388.46 .00 1,094,301.54 54.1% 0141151 511002 SALARIES - MONTH 0 0 0 .00 .00 .00 .0% 0141151 513000 OVERTIME 120,284 42,198 162,482 71,516.53 .00 90,965.74 44.0% 0141151 514006 LONGEVITY 25,900 6,600 32,500 18,150.00 .00 14,350.00 55.8% 0141151 514008 OUT OF GRADE 4,510 6,200 10,710 5,620.24 .00 5,089.76 52.5% 0141151 514015 OTHER DIFFERENTI 10,038 -350 9,688 4,508.00 .00 5,180.00 46.5% 0141151 515004 HOLIDAYS 17,555 0 17,555 3,682.65 .00 13,872.35 21.0% 0141151 515006 HOLIDAYS NON-UNI 0 0 0 .00 .00 .00 .0% 0141151 515011 HOLIDAYS - S.M.E 18,929 5,940 24,869 24,868.73 .00 .00 100.0% 0141151 515012 PERFECT ATTENDAN 0 10,250 10,250 10,250.00 .00 .00 100.0% 0141151 519004 UNIFORM ALLOWANC 350 350 700 700.00 .00 .00 100.0% 0141151 519005 SICK LEAVE BUYBA 0 0 0 .00 .00 .00 .0% 0141151 519013 OTHER LUMP SUM P 172,621 229,514 402,135 176,264.43 .00 225,870.57 43.8% 0141151 519014 LUMP SUM SETTLEM 0 350 350 .00 .00 350.00 .0% 0141151 519015 AUTO ALLOWANCE 0 0 0 .00 .00 .00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 63 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0141151 519030 COVID19 PERSONAL 0 0 0 .00 .00 .00 .0% 0141151 519104 SALARY STIPEND 0 0 0 .00 .00 .00 .0% 0141151 519999 RESERVED FOR REV 0 0 0 .00 .00 .00 .0% TOTAL DPW-SCHL CUSTDN PERSONAL SVC 2,680,477 377,452 3,057,929 1,607,949.04 .00 1,449,979.96 52.6% 0141152 SCHL CUSTO ORDINARY MAINTENANC 0141152 530000 PROFESSIONAL & T 1,400,000 0 1,400,000 713,180.00 586,612.00 100,208.00 92.8% TOTAL SCHL CUSTO ORDINARY MAINTENANC 1,400,000 0 1,400,000 713,180.00 586,612.00 100,208.00 92.8% 0141160 SCHOOL CUSTODIAN SPECIAL 0141160 578037 COVID 19 OM EXP 0 0 0 .00 .00 .00 .0% TOTAL SCHOOL CUSTODIAN SPECIAL 0 0 0 .00 .00 .00 .0% 0142951 DPW-WEIGHTS&MEAS PERSONAL SVC 0142951 511000 SALARIES 0 0 0 .00 .00 .00 .0% 0142951 513000 OVERTIME 0 0 0 .00 .00 .00 .0% 0142951 514006 LONGEVITY 0 0 0 .00 .00 .00 .0% 0142951 514010 OUT OF GRADE-LAB 0 0 0 .00 .00 .00 .0% 0142951 514015 OTHER DIFFERENTI 0 0 0 .00 .00 .00 .0% 0142951 515006 HOLIDAYS NON-UNI 0 0 0 .00 .00 .00 .0% 0142951 515011 HOLIDAYS - S.M.E 0 0 0 .00 .00 .00 .0% 0142951 515012 PERFECT ATTENDAN 0 0 0 .00 .00 .00 .0% 0142951 519004 UNIFORM ALLOWANC 0 0 0 .00 .00 .00 .0% 0142951 519013 OTHER LUMP SUM P 0 0 0 .00 .00 .00 .0% TOTAL DPW-WEIGHTS&MEAS PERSONAL SVC 0 0 0 .00 .00 .00 .0% 0142952 DPW-WEIGHTS&MEAS ORDINARY MAIN 0142952 524007 R&M - OFFICE EQU 0 0 0 .00 .00 .00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 64 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0142952 524013 REPAIRS-TOOLS & 0 0 0 .00 .00 .00 .0% 0142952 530011 ADVERTISING 0 0 0 .00 .00 .00 .0% 0142952 530024 TUITION 0 0 0 .00 .00 .00 .0% 0142952 542001 PRINTING & STATI 0 0 0 .00 .00 .00 .0% 0142952 542007 COMPUTER EQUIPME 0 0 0 .00 .00 .00 .0% 0142952 543011 HARDWARE & SMALL 0 0 0 .00 .00 .00 .0% 0142952 571000 IN STATE TRAVEL 0 0 0 .00 .00 .00 .0% 0142952 571001 IN STATE CONFERE 0 0 0 .00 .00 .00 .0% 0142952 573000 DUES AND MEMBERS 0 0 0 .00 .00 .00 .0% 0142952 578007 REIMB OF LICENSE 0 0 0 .00 .00 .00 .0% TOTAL DPW-WEIGHTS&MEAS ORDINARY MAIN 0 0 0 .00 .00 .00 .0% 0151251 BOARD OF HEALTH PERSONAL SVC 0151251 511000 SALARIES 2,038,256 -3,927 2,034,329 1,025,023.69 .00 1,009,305.00 50.4% 0151251 511002 SALARIES - MONTH 11,628 0 11,628 6,783.00 .00 4,845.00 58.3% 0151251 512000 SALARIES & WAGES 44,500 0 44,500 31,708.57 .00 12,791.43 71.3% 0151251 513000 OVERTIME 8,034 0 8,034 4,600.68 .00 3,433.32 57.3% 0151251 514006 LONGEVITY 850 0 850 425.00 .00 425.00 50.0% 0151251 514008 OUT OF GRADE 0 0 0 .00 .00 .00 .0% 0151251 514015 OTHER DIFFERENTI 0 0 0 .00 .00 .00 .0% 0151251 515006 HOLIDAYS NON-UNI 12,397 0 12,397 10,761.14 .00 1,635.86 86.8% 0151251 515011 HOLIDAYS - S.M.E 3,214 0 3,214 2,108.47 .00 1,105.53 65.6% 0151251 515012 PERFECT ATTENDAN 0 700 700 700.00 .00 .00 100.0% 0151251 519004 UNIFORM ALLOWANC 291 0 291 .00 .00 291.00 .0% 0151251 519013 OTHER LUMP SUM P 0 2,887 2,887 2,887.31 .00 .00 100.0% 0151251 519015 AUTO ALLOWANCE 0 340 340 340.00 .00 .00 100.0% 0151251 519030 COVID19 PERSONAL 0 0 0 .00 .00 .00 .0% 0151251 519999 RESERVED FOR REV 0 0 0 .00 .00 .00 .0% 0151251 558012 BADGES,EMBLEMS,T 0 0 0 .00 .00 .00 .0% TOTAL BOARD OF HEALTH PERSONAL SVC 2,119,170 0 2,119,170 1,085,337.86 .00 1,033,832.14 51.2% 0151252 BOARD OF HEALTH ORDINARY MAINT 0151252 524007 REPAIRS OFFICE E 200 0 200 .00 .00 200.00 .0% 0151252 524034 MAINT CONTRACT-O 3,500 0 3,500 2,265.36 734.64 500.00 85.7% 0151252 524035 R&M - RECONDITIO 1,215 0 1,215 .00 .00 1,215.00 .0% 0151252 527000 RENTALS 500 0 500 .00 .00 500.00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 65 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0151252 527019 RENTAL-WATER COO 700 0 700 424.85 275.15 .00 100.0% 0151252 530000 PROFESSIONL & TE 714,407 -40,840 673,567 227,011.44 301,882.64 144,673.20 78.5% 0151252 530008 EMPLOYEE TRAININ 22,500 0 22,500 1,245.00 500.00 20,755.00 7.8% 0151252 530011 ADVERTISING 300 0 300 94.50 .00 205.50 31.5% 0151252 530029 CUSTODIAL DETAIL 0 0 0 .00 .00 .00 .0% 0151252 534003 POSTAGE 800 0 800 .00 .00 800.00 .0% 0151252 534006 EXPRESS/FREIGHT 50 0 50 .00 .00 50.00 .0% 0151252 534011 LICENSING FEES 1,000 0 1,000 158.64 .00 841.36 15.9% 0151252 538004 EXTERMINATION 0 0 0 .00 .00 .00 .0% 0151252 542000 OFFICE SUPPLIES 9,000 0 9,000 853.60 2,146.40 6,000.00 33.3% 0151252 542001 PRINTING & STATI 6,750 0 6,750 245.00 .00 6,505.00 3.6% 0151252 542005 OFFICE EQUIPMENT 1,000 0 1,000 .00 .00 1,000.00 .0% 0151252 542006 OFFICE FURNITURE 2,400 0 2,400 .00 .00 2,400.00 .0% 0151252 549000 FOOD SUPPLIES & 4,000 0 4,000 717.98 782.02 2,500.00 37.5% 0151252 550000 MEDICAL/DENTAL S 57,000 2,323 59,323 45,651.96 718.38 12,952.16 78.2% 0151252 551000 EDUCATIONAL SUPP 5,500 0 5,500 .00 .00 5,500.00 .0% 0151252 553001 SIGNS AND CONES 0 0 0 .00 .00 .00 .0% 0151252 558004 MAGAZINES & PUBL 500 0 500 .00 .00 500.00 .0% 0151252 558006 UNIFORMS 1,000 0 1,000 145.60 .00 854.40 14.6% 0151252 558011 FLOWERS & FLAGS 0 0 0 .00 .00 .00 .0% 0151252 558012 BADGES,EMBLEMS,T 200 0 200 .00 .00 200.00 .0% 0151252 558018 PROGRAM SUPPLIES 25,000 -2,323 22,678 8,834.89 727.60 13,115.01 42.2% 0151252 571000 IN STATE TRAVEL 2,200 0 2,200 113.76 .00 2,086.24 5.2% 0151252 571001 IN STATE CONFERE 2,000 0 2,000 20.00 .00 1,980.00 1.0% 0151252 572000 OUT OF STATE TRA 1,300 200 1,500 1,302.51 54.92 142.57 90.5% 0151252 572001 OUT OF STATE CON 1,600 -200 1,400 .00 .00 1,400.00 .0% 0151252 573000 DUES AND MEMBERS 3,600 0 3,600 980.00 .00 2,620.00 27.2% 0151252 578007 REIMB OF LICENSE 885 0 885 .00 .00 885.00 .0% 0151252 578008 REIMB/ALLOWANCES 0 0 0 .00 .00 .00 .0% TOTAL BOARD OF HEALTH ORDINARY MAINT 869,107 -40,840 828,267 290,065.09 307,821.75 230,380.44 72.2% 0151260 BOARD OF HEALTH SPECIAL 0151260 578037 COVID 19 OM EXP 0 0 0 .00 .00 .00 .0% TOTAL BOARD OF HEALTH SPECIAL 0 0 0 .00 .00 .00 .0% 0151351 HEALTH-SCH NURSING PERSONL SVC 0151351 511000 HEALTH-SCH NURSI 0 0 0 .00 .00 .00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 66 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0151351 515006 HOLIDAYS NON-UNI 0 0 0 .00 .00 .00 .0% TOTAL HEALTH-SCH NURSING PERSONL SVC 0 0 0 .00 .00 .00 .0% 0151352 HEALTH-SCH NURSING ORD MAINT 0151352 530000 HEALTH-SCH NURSI 0 0 0 .00 .00 .00 .0% TOTAL HEALTH-SCH NURSING ORD MAINT 0 0 0 .00 .00 .00 .0% 0151358 HEALTH-SCH NURSING CAP OUTLAY 0151358 580000 HEALTH-SCH NURSI 0 0 0 .00 .00 .00 .0% TOTAL HEALTH-SCH NURSING CAP OUTLAY 0 0 0 .00 .00 .00 .0% 0151451 HEALTH-PUBLIC HLTH PERSONL SVC 0151451 511000 HEALTH-PUBLIC HL 0 0 0 .00 .00 .00 .0% 0151451 515006 HOLIDAYS NON-UNI 0 0 0 .00 .00 .00 .0% TOTAL HEALTH-PUBLIC HLTH PERSONL SVC 0 0 0 .00 .00 .00 .0% 0151452 HEALTH-PUBLIC HLTH ORD MAINT 0151452 530000 HEALTH-PUBLIC HL 0 0 0 .00 .00 .00 .0% TOTAL HEALTH-PUBLIC HLTH ORD MAINT 0 0 0 .00 .00 .00 .0% 0151458 HEALTH-PUBLIC HLTH CAP OUTLAY 0151458 580000 HEALTH-PUBLIC HL 0 0 0 .00 .00 .00 .0% TOTAL HEALTH-PUBLIC HLTH CAP OUTLAY 0 0 0 .00 .00 .00 .0% 0151551 HEALTH-ADMIN&FIN PERSONAL SVC

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 67 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0151551 511000 HEALTH-ADMIN&FIN 0 0 0 .00 .00 .00 .0% 0151551 515006 HOLIDAYS NON-UNI 0 0 0 .00 .00 .00 .0% TOTAL HEALTH-ADMIN&FIN PERSONAL SVC 0 0 0 .00 .00 .00 .0% 0151552 HEALTH-ADMIN&FIN ORDINARY MNT 0151552 530000 HEALTH-ADMIN&FIN 0 0 0 .00 .00 .00 .0% TOTAL HEALTH-ADMIN&FIN ORDINARY MNT 0 0 0 .00 .00 .00 .0% 0151558 HEALTH-ADMIN&FIN CAPITL OUTLAY 0151558 580000 HEALTH-ADMIN&FIN 0 0 0 .00 .00 .00 .0% TOTAL HEALTH-ADMIN&FIN CAPITL OUTLAY 0 0 0 .00 .00 .00 .0% 0154351 VETERANS BENEFITS PERSONAL SVC 0154351 511000 SALARIES 214,800 57,716 272,516 95,786.87 .00 176,729.24 35.1% 0154351 513000 OVERTIME 1,000 0 1,000 307.45 .00 692.55 30.7% 0154351 514006 LONGEVITY 500 0 500 250.00 .00 250.00 50.0% 0154351 514008 OUT OF GRADE 0 0 0 .00 .00 .00 .0% 0154351 515006 HOLIDAYS NON-UNI 1,292 0 1,292 801.20 .00 490.80 62.0% 0154351 515011 HOLIDAYS - S.M.E 428 0 428 .00 .00 428.00 .0% 0154351 515012 PERFECT ATTENDAN 0 0 0 .00 .00 .00 .0% 0154351 519004 UNIFORM ALLOWANC 350 0 350 350.00 .00 .00 100.0% 0154351 519013 OTHER LUMP SUM P 0 0 0 .00 .00 .00 .0% 0154351 519015 AUTO ALLOWANCE 0 0 0 .00 .00 .00 .0% TOTAL VETERANS BENEFITS PERSONAL SVC 218,370 57,716 276,086 97,495.52 .00 178,590.59 35.3% 0154352 VETERANS BENEFITS ORDINARY MNT 0154352 524001 GROUNDS MAINTENA 20,000 0 20,000 .00 .00 20,000.00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 68 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0154352 524007 REPAIRS OFFICE E 0 0 0 .00 .00 .00 .0% 0154352 524034 MAINT CONTRACT-O 0 0 0 .00 .00 .00 .0% 0154352 527001 RENTAL - BUILDIN 0 0 0 .00 .00 .00 .0% 0154352 527014 RENTAL - TABLES 0 0 0 .00 .00 .00 .0% 0154352 527019 RENTAL-WATER COO 0 0 0 .00 .00 .00 .0% 0154352 530000 PROFESSIONL & TE 180,000 -5,000 175,000 53,399.48 29,050.00 92,550.52 47.1% 0154352 530018 POLICE DETAIL 0 0 0 .00 .00 .00 .0% 0154352 530020 FIRE DETAIL 0 0 0 .00 .00 .00 .0% 0154352 534003 POSTAGE 1,500 0 1,500 .00 .00 1,500.00 .0% 0154352 534011 LICENSING FEES 0 0 0 .00 .00 .00 .0% 0154352 542000 OFFICE SUPPLIES 1,500 0 1,500 744.02 263.22 492.76 67.1% 0154352 542001 PRINTING & STATI 2,000 0 2,000 1,008.00 .00 992.00 50.4% 0154352 542005 OFFICE EQUIPMENT 0 0 0 .00 .00 .00 .0% 0154352 542006 OFFICE FURNITURE 0 0 0 .00 .00 .00 .0% 0154352 543011 HARDWARE & SMALL 0 0 0 .00 .00 .00 .0% 0154352 549000 FOOD SUPPLIES & 2,500 2,000 4,500 3,210.88 75.12 1,214.00 73.0% 0154352 551010 AUDIO VISUAL SUP 0 1,000 1,000 242.36 190.00 567.64 43.2% 0154352 553001 SIGNS AND CONES 1,000 0 1,000 332.00 .00 668.00 33.2% 0154352 558004 MAGAZINES,NEWS,S 0 0 0 .00 .00 .00 .0% 0154352 558006 UNIFORMS 1,000 0 1,000 204.06 .00 795.94 20.4% 0154352 558011 FLOWERS & FLAGS 5,500 0 5,500 1,663.67 1,901.33 1,935.00 64.8% 0154352 558012 BADGES, EMBLEMS, 1,000 0 1,000 49.75 .00 950.25 5.0% 0154352 558018 PROGRAM SUPPLIES 0 2,000 2,000 730.03 .00 1,269.97 36.5% 0154352 558019 PROMOTIONAL MATE 5,000 0 5,000 .00 .00 5,000.00 .0% 0154352 571000 IN STATE TRAVEL 750 0 750 .00 400.00 350.00 53.3% 0154352 571001 IN STATE CONFERE 2,500 0 2,500 .00 1,040.00 1,460.00 41.6% 0154352 572000 OUT OF STATE TRA 4,000 0 4,000 .00 .00 4,000.00 .0% 0154352 572001 OUT OF STATE CON 11,000 0 11,000 .00 .00 11,000.00 .0% 0154352 573000 DUES AND MEMBERS 5,000 0 5,000 90.00 .00 4,910.00 1.8% 0154352 577000 VETERANS BENEFIT 410,000 -57,716 352,284 119,882.79 .00 232,401.10 34.0% 0154352 585017 SOFTWARE 0 0 0 .00 .00 .00 .0% TOTAL VETERANS BENEFITS ORDINARY MNT 654,250 -57,716 596,534 181,557.04 32,919.67 382,057.18 36.0% 0154360 VETERAN BENEFITS SPECIAL 0154360 578037 COVID 19 OM EXP 0 0 0 .00 .00 .00 .0% TOTAL VETERAN BENEFITS SPECIAL 0 0 0 .00 .00 .00 .0% 0161051 LIBRARIES PERSONAL SERVICES 0161051 511000 SALARIES 2,159,338 -1,300 2,158,038 1,129,823.18 .00 1,028,214.82 52.4%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 69 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0161051 512000 SALARIES & WAGES 270,000 0 270,000 155,751.58 .00 114,248.42 57.7% 0161051 513000 OVERTIME 154,030 0 154,030 93,943.71 .00 60,086.29 61.0% 0161051 514004 SHIFT DIFFERENTI 42,545 0 42,545 20,234.38 .00 22,310.62 47.6% 0161051 514006 LONGEVITY 20,600 0 20,600 9,600.00 .00 11,000.00 46.6% 0161051 514008 OUT OF GRADE 0 0 0 .00 .00 .00 .0% 0161051 515006 HOLIDAYS NON-UNI 2,612 0 2,612 1,881.41 .00 730.59 72.0% 0161051 515011 HOLIDAYS - S.M.E 14,508 0 14,508 6,615.35 .00 7,892.65 45.6% 0161051 515012 PERFECT ATTENDAN 0 1,300 1,300 1,300.00 .00 .00 100.0% 0161051 519004 UNIFORM ALLOWANC 11,405 0 11,405 10,500.00 .00 905.00 92.1% 0161051 519005 SICK LEAVE BUYBA 0 0 0 .00 .00 .00 .0% 0161051 519013 OTHER LUMP SUM P 0 0 0 .00 .00 .00 .0% 0161051 519015 AUTO ALLOWANCE 0 0 0 .00 .00 .00 .0% 0161051 519999 RESERVED FOR REV 0 0 0 .00 .00 .00 .0% TOTAL LIBRARIES PERSONAL SERVICES 2,675,038 0 2,675,038 1,429,649.61 .00 1,245,388.39 53.4% 0161052 LIBRARIES ORDINARY MAINTENANCE 0161052 524007 REPAIRS OFFICE E 0 0 0 .00 .00 .00 .0% 0161052 524015 REPAIRS COMPUTER 0 0 0 .00 .00 .00 .0% 0161052 527018 POSTAGE MACHINE 350 0 350 .00 350.00 .00 100.0% 0161052 527019 RENTAL-WATER COO 1,000 0 1,000 466.40 533.60 .00 100.0% 0161052 529008 SECURITY 0 0 0 .00 .00 .00 .0% 0161052 530000 PROFESSIONL & TE 88,733 0 88,733 77,278.26 3,891.70 7,563.04 91.5% 0161052 534003 POSTAGE 600 0 600 130.88 .00 469.12 21.8% 0161052 534009 INTERNET MAINTEN 13,379 0 13,379 6,874.30 624.50 5,880.20 56.0% 0161052 534011 LICENSING FEES 0 0 0 .00 .00 .00 .0% 0161052 538007 MICROFILMING 1,975 0 1,975 1,520.00 205.00 250.00 87.3% 0161052 542000 OFFICE SUPPLIES 14,560 0 14,560 8,679.99 3,284.67 2,595.34 82.2% 0161052 542001 STATIONERY 500 0 500 16.00 .00 484.00 3.2% 0161052 542004 COMPUTER SUPPLIE 44,000 0 44,000 30,838.83 7,532.57 5,628.60 87.2% 0161052 542005 OFFICE EQUIPMENT 0 0 0 .00 .00 .00 .0% 0161052 542006 OFFICE FURNITURE 2,500 0 2,500 850.61 678.64 970.75 61.2% 0161052 542007 COMPUTER EQUIPME 0 0 0 .00 .00 .00 .0% 0161052 549000 FOOD SUPPLIES & 1,500 0 1,500 793.31 398.84 307.85 79.5% 0161052 551000 EDUCATIONAL SUPP 6,000 0 6,000 1,131.73 2,535.82 2,332.45 61.1% 0161052 551004 TEXTBOOKS 160,000 0 160,000 57,669.24 50,724.78 51,605.98 67.7% 0161052 551010 AUDIO VISUAL SUP 38,600 0 38,600 17,405.96 19,518.15 1,675.89 95.7% 0161052 551012 MUSIC SUPPLIES/I 6,000 0 6,000 2,067.52 2,582.48 1,350.00 77.5% 0161052 558002 ONLINE SUBSCRIPT 288,081 0 288,081 221,452.66 62,490.19 4,138.15 98.6% 0161052 558004 MAGAZINES,NEWS,S 19,623 0 19,623 11,445.83 1,680.30 6,496.87 66.9% 0161052 558007 LIBRARY SUPPLIES 8,115 0 8,115 7,388.70 96.81 629.49 92.2%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 70 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0161052 558009 BOOK THEFT SYSTE 1,200 0 1,200 .00 .00 1,200.00 .0% 0161052 558018 PROGRAM SUPPLIES 7,000 0 7,000 1,957.96 1,355.22 3,686.82 47.3% 0161052 571000 IN STATE TRAVEL 350 0 350 .00 .00 350.00 .0% 0161052 571001 IN STATE CONFERE 2,000 0 2,000 .00 .00 2,000.00 .0% 0161052 572000 OUT OF STATE TRA 7,000 0 7,000 .00 .00 7,000.00 .0% 0161052 573000 DUES AND MEMBERS 700 0 700 183.00 .00 517.00 26.1% 0161052 585014 COMPUTER EQUIPME 35,000 0 35,000 10,536.45 3,975.00 20,488.55 41.5% TOTAL LIBRARIES ORDINARY MAINTENANCE 748,766 0 748,766 458,687.63 162,458.27 127,620.10 83.0% 0161058 LIBRARIES CAPITAL EXPENDITURE 0161058 585023 SECURITY EQUIPME 0 0 0 .00 .00 .00 .0% TOTAL LIBRARIES CAPITAL EXPENDITURE 0 0 0 .00 .00 .00 .0% 0161151 LIBRARY-CENTRAL PERSONAL SVC 0161151 511000 LIBRARY-CENTRAL 0 0 0 .00 .00 .00 .0% 0161151 515006 HOLIDAYS NON-UNI 0 0 0 .00 .00 .00 .0% TOTAL LIBRARY-CENTRAL PERSONAL SVC 0 0 0 .00 .00 .00 .0% 0161152 LIBRARY-CENTRAL ORDINARY MAINT 0161152 530000 LIBRARY-CENTRAL 0 0 0 .00 .00 .00 .0% TOTAL LIBRARY-CENTRAL ORDINARY MAINT 0 0 0 .00 .00 .00 .0% 0161158 LIBRARY-CENTRAL CAPITAL OUTLAY 0161158 580000 LIBRARY-CENTRAL 0 0 0 .00 .00 .00 .0% TOTAL LIBRARY-CENTRAL CAPITAL OUTLAY 0 0 0 .00 .00 .00 .0% 0161251 LIBRARY-WEST PERSONAL SVC 0161251 511000 LIBRARY-WEST PER 0 0 0 .00 .00 .00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 71 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0161251 515006 HOLIDAYS NON-UNI 0 0 0 .00 .00 .00 .0% TOTAL LIBRARY-WEST PERSONAL SVC 0 0 0 .00 .00 .00 .0% 0161252 LIBRARY-WEST ORDINARY MAINT 0161252 530000 LIBRARY-WEST ORD 0 0 0 .00 .00 .00 .0% TOTAL LIBRARY-WEST ORDINARY MAINT 0 0 0 .00 .00 .00 .0% 0161258 LIBRARY-WEST CAPITAL OUTLAY 0161258 580000 LIBRARY-WEST CAP 0 0 0 .00 .00 .00 .0% TOTAL LIBRARY-WEST CAPITAL OUTLAY 0 0 0 .00 .00 .00 .0% 0161351 LIBRARY-EAST PERSONAL SVC 0161351 511000 LIBRARY-EAST PER 0 0 0 .00 .00 .00 .0% 0161351 515006 HOLIDAYS NON-UNI 0 0 0 .00 .00 .00 .0% TOTAL LIBRARY-EAST PERSONAL SVC 0 0 0 .00 .00 .00 .0% 0161352 LIBRARY-EAST ORDINARY MAINT 0161352 530000 LIBRARY-EAST ORD 0 0 0 .00 .00 .00 .0% TOTAL LIBRARY-EAST ORDINARY MAINT 0 0 0 .00 .00 .00 .0% 0161358 LIBRARY-EAST CAPITAL OUTLAY 0161358 580000 LIBRARY-EAST CAP 0 0 0 .00 .00 .00 .0% TOTAL LIBRARY-EAST CAPITAL OUTLAY 0 0 0 .00 .00 .00 .0% 0163051 REC/YOUTH PROG PERSONAL SVC

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 72 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0163051 511000 SALARIES 988,961 0 988,961 485,545.44 .00 503,415.56 49.1% 0163051 512000 SALARIES & WAGES 744,480 -12,000 732,480 293,921.46 .00 438,558.54 40.1% 0163051 513000 OVERTIME 750 12,000 12,750 12,357.81 .00 392.19 96.9% 0163051 514004 SHIFT DIFFERENTI 0 0 0 .00 .00 .00 .0% 0163051 514006 LONGEVITY 850 0 850 425.00 .00 425.00 50.0% 0163051 515006 HOLIDAYS NON-UNI 5,756 0 5,756 4,362.25 .00 1,393.75 75.8% 0163051 515011 HOLIDAYS - S.M.E 932 0 932 681.80 .00 250.20 73.2% 0163051 515012 PERFECT ATTENDAN 0 0 0 .00 .00 .00 .0% 0163051 519004 UNIFORM ALLOWANC 350 0 350 350.00 .00 .00 100.0% 0163051 519013 OTHER LUMP SUM P 2,500 0 2,500 .00 .00 2,500.00 .0% 0163051 519015 AUTO ALLOWANCE 0 0 0 .00 .00 .00 .0% 0163051 519104 SALARY STIPEND 0 0 0 .00 .00 .00 .0% TOTAL REC/YOUTH PROG PERSONAL SVC 1,744,579 0 1,744,579 797,643.76 .00 946,935.24 45.7% 0163052 REC/YOUTH PROG ORDINARY MAINT 0163052 521005 OIL 1,400 0 1,400 660.49 .00 739.51 47.2% 0163052 524001 R&M - BUILDINGS 10,000 0 10,000 1,125.00 .00 8,875.00 11.3% 0163052 524003 REPAIRS-VEHICLES 2,000 0 2,000 .00 .00 2,000.00 .0% 0163052 524007 REPAIRS OFFICE E 2,000 0 2,000 .00 .00 2,000.00 .0% 0163052 524017 R&M - OTHER EQUI 1,000 0 1,000 .00 .00 1,000.00 .0% 0163052 524027 R&M - FLOOR COVE 2,500 0 2,500 .00 .00 2,500.00 .0% 0163052 527002 RENTAL-BUILDINGS 37,500 -37,500 0 .00 .00 .00 .0% 0163052 527019 RENTAL-WATER COO 600 0 600 84.80 215.20 300.00 50.0% 0163052 527020 RENTAL- EQUIPMEN 0 11,972 11,972 795.00 2,325.50 8,851.50 26.1% 0163052 530000 PROFESSIONL & TE 100,000 971 100,971 41,270.26 18,099.74 41,600.50 58.8% 0163052 530011 ADVERTISING 2,500 0 2,500 .00 .00 2,500.00 .0% 0163052 530021 TOWING 0 0 0 .00 .00 .00 .0% 0163052 530023 STAFF DEVELOPMEN 6,000 0 6,000 705.28 .00 5,294.72 11.8% 0163052 530029 CUSTODIAL DETAIL 0 37,500 37,500 1,715.00 .00 35,785.00 4.6% 0163052 534011 LICENSING FEES 4,000 0 4,000 .00 .00 4,000.00 .0% 0163052 534015 FEE 0 5,678 5,678 5,677.50 .00 .00 100.0% 0163052 535003 RECREATION-ADMIS 12,000 0 12,000 .00 2,574.20 9,425.80 21.5% 0163052 535005 RECREATION-TRANS 9,000 0 9,000 2,900.00 .00 6,100.00 32.2% 0163052 538005 PHOTOGRAPHY 0 0 0 .00 .00 .00 .0% 0163052 542000 OFFICE SUPPLIES 4,000 0 4,000 3,147.47 3.47 849.06 78.8% 0163052 542001 PRINTING & STATI 2,500 0 2,500 .00 .00 2,500.00 .0% 0163052 542008 BOOKS & BOOKBIND 0 0 0 .00 .00 .00 .0% 0163052 542012 OTH EQUIPMENT NO 0 0 0 .00 .00 .00 .0% 0163052 543011 HARDWARE & SMALL 1,000 0 1,000 .00 .00 1,000.00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 73 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0163052 545000 CUSTODIAL & MAIN 1,000 0 1,000 .00 .00 1,000.00 .0% 0163052 548004 TIRES AND TUBES 0 0 0 .00 .00 .00 .0% 0163052 549000 FOOD SUPPLIES & 8,500 0 8,500 5,727.73 1,214.27 1,558.00 81.7% 0163052 550000 MEDICAL/DENTAL S 5,500 0 5,500 .00 .00 5,500.00 .0% 0163052 551006 ATHLETIC SUPPLIE 43,500 0 43,500 8,713.22 8,947.03 25,839.75 40.6% 0163052 551010 AUDIO VISUAL SUP 1,500 0 1,500 .00 .00 1,500.00 .0% 0163052 553001 SIGNS AND CONES 2,500 0 2,500 580.00 .00 1,920.00 23.2% 0163052 558004 MAGAZINES & PUBL 25,000 -5,000 20,000 .00 .00 20,000.00 .0% 0163052 558005 RECREATION SUPPL 60,000 0 60,000 55,491.08 1,895.79 2,613.13 95.6% 0163052 558006 UNIFORMS 65,000 0 65,000 19,973.00 .00 45,027.00 30.7% 0163052 563200 DCR-BOAT HOUSE 34,000 0 34,000 34,000.00 .00 .00 100.0% 0163052 571000 IN STATE TRAVEL 0 0 0 .00 .00 .00 .0% 0163052 572000 OUT OF STATE TRA 11,000 0 11,000 2,480.50 .00 8,519.50 22.6% 0163052 573000 DUES AND MEMBERS 3,000 0 3,000 1,798.69 1,021.31 180.00 94.0% 0163052 578037 COVID 19 OM EXP 0 0 0 .00 .00 .00 .0% TOTAL REC/YOUTH PROG ORDINARY MAINT 458,500 13,620 472,120 186,845.02 36,296.51 248,978.47 47.3% 0163060 REC - SPECIAL ITEMS 0163060 563200 DCR-BOAT HOUSE 0 0 0 .00 .00 .00 .0% 0163060 578037 COVID 19 OM EXP 0 0 0 .00 .00 .00 .0% TOTAL REC - SPECIAL ITEMS 0 0 0 .00 .00 .00 .0% 0163151 REC-RECREATION PERSONAL SVC 0163151 515006 HOLIDAYS NON-UNI 0 0 0 .00 .00 .00 .0% TOTAL REC-RECREATION PERSONAL SVC 0 0 0 .00 .00 .00 .0% 0163251 REC-YOUTH PROG PERSONAL SVC 0163251 515006 HOLIDAYS NON-UNI 0 0 0 .00 .00 .00 .0% TOTAL REC-YOUTH PROG PERSONAL SVC 0 0 0 .00 .00 .00 .0% 0163351 P&R-FIELDS PERSONAL SVCS 0163351 511000 SALARIES 156,338 -156,338 0 .00 .00 .00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 74 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0163351 513000 OVERTIME 0 0 0 .00 .00 .00 .0% 0163351 514006 LONGEVITY 600 -600 0 .00 .00 .00 .0% 0163351 514010 OUT OF GRADE-LAB 0 0 0 .00 .00 .00 .0% 0163351 514015 OTHER DIFFERENTI 5,474 -5,474 0 .00 .00 .00 .0% 0163351 515006 HOLIDAYS NON-UNI 361 -361 0 .00 .00 .00 .0% 0163351 515011 HOLIDAYS - S.M.E 1,296 -1,296 0 .00 .00 .00 .0% 0163351 515012 PERFECT ATTENDAN 0 0 0 .00 .00 .00 .0% 0163351 519004 UNIFORM ALLOWANC 1,050 -1,050 0 .00 .00 .00 .0% 0163351 519015 AUTO ALLOWANCE 0 0 0 .00 .00 .00 .0% TOTAL P&R-FIELDS PERSONAL SVCS 165,119 -165,119 0 .00 .00 .00 .0% 0163352 P&R-FIELDS PERSONAL ORDIN MAIN 0163352 524002 R&M - REC FACIL/ 15,000 -15,000 0 .00 .00 .00 .0% 0163352 524012 R&M - AUDIO/VISU 0 0 0 .00 .00 .00 .0% 0163352 524013 R&M - TOOLS & EQ 0 0 0 .00 .00 .00 .0% 0163352 524017 R&M - OTHER EQUI 5,000 -5,000 0 .00 .00 .00 .0% 0163352 524031 REPAIRS TO PARK 10,000 -10,000 0 .00 .00 .00 .0% 0163352 527001 RENTAL - BUILDIN 0 0 0 .00 .00 .00 .0% 0163352 527020 RENTAL- EQUIPMEN 0 0 0 .00 .00 .00 .0% 0163352 530000 PROFESSIONAL & T 170,500 -170,500 0 .00 .00 .00 .0% 0163352 542000 OFFICE SUPPLIES 0 0 0 .00 .00 .00 .0% 0163352 542012 OTH EQUIPMENT NO 0 0 0 .00 .00 .00 .0% 0163352 543007 PAINT 15,000 -15,000 0 .00 .00 .00 .0% 0163352 546000 GROUNDSKEEPING S 30,000 -30,000 0 .00 .00 .00 .0% 0163352 546003 LOAM,SOD,FERTILI 30,000 -30,000 0 .00 .00 .00 .0% 0163352 553001 SIGNS AND CONES 0 0 0 .00 .00 .00 .0% 0163352 558006 UNIFORMS 0 0 0 .00 .00 .00 .0% 0163352 571000 IN STATE TRAVEL 1,500 -1,500 0 .00 .00 .00 .0% TOTAL P&R-FIELDS PERSONAL ORDIN MAIN 277,000 -277,000 0 .00 .00 .00 .0% 0170059 DEBT SERVICE 0170059 591000 PRINCIPAL ON LNG 11,711,557 0 11,711,557 5,864,822.00 .00 5,846,735.00 50.1% 0170059 591500 INTEREST ON LTD 8,344,150 0 8,344,150 4,435,324.69 .00 3,908,825.31 53.2% 0170059 592500 INTEREST ON NOTE 995,401 0 995,401 .00 .00 995,401.00 .0% 0170059 593000 INTEREST ON TAX 10,000 0 10,000 .00 .00 10,000.00 .0% TOTAL DEBT SERVICE 21,061,108 0 21,061,108 10,300,146.69 .00 10,760,961.31 48.9%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 75 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0182052 STATE & COUNTY ASSESSMENTS 0182052 563100 SPECIAL EDUCATIO 17,516 0 17,516 8,760.00 .00 8,756.00 50.0% 0182052 563600 RETIRED EMPLOYEE 0 0 0 .00 .00 .00 .0% 0182052 564000 AIR POLLUTION CO 33,589 0 33,589 16,800.00 .00 16,789.00 50.0% 0182052 564100 METROPOLTN PLANN 46,255 0 46,255 23,130.00 .00 23,125.00 50.0% 0182052 564600 RMV NON-RENEWAL 160,500 0 160,500 80,250.00 .00 80,250.00 50.0% 0182052 565001 CHARTER SCHOOL 0 0 0 .00 .00 .00 .0% 0182052 565002 SCHOOL CHOICE AS 118,064 -50,360 67,704 33,185.00 .00 34,519.00 49.0% 0182052 565003 CHARTER SCH SEND 9,373,716 17,150 9,390,866 4,503,533.00 .00 4,887,333.00 48.0% 0182052 565004 SCH CHOICE SENDI 0 0 0 .00 .00 .00 .0% 0182052 566100 MBTA ASSESSMENTS 5,807,352 0 5,807,352 2,903,676.00 .00 2,903,676.00 50.0% 0182052 566200 BOSTON METRO TRA 1,198 0 1,198 600.00 .00 598.00 50.1% 0182052 578033 BOND INTEREST AS 0 0 0 .00 .00 .00 .0% TOTAL STATE & COUNTY ASSESSMENTS 15,558,190 -33,210 15,524,980 7,569,934.00 .00 7,955,046.00 48.8% 0190151 HEALTH & LIFE INS PERSONAL SVC 0190151 515006 HOLIDAYS NON-UNI 0 0 0 .00 .00 .00 .0% 0190151 517003 HEALTH INSURANCE 31,513,877 -2,000,000 29,513,877 .00 .00 29,513,877.00 .0% 0190151 517005 FLEX SPEND BENEF 0 0 0 .00 .00 .00 .0% 0190151 517010 BCBS CLAIMS 0 0 0 .00 .00 .00 .0% 0190151 517011 BCBS ADMIN FEES 0 0 0 .00 .00 .00 .0% 0190151 517015 HARVARD CLAIMS 0 0 0 .00 .00 .00 .0% 0190151 517016 HARVARD ADMIN FE 0 0 0 .00 .00 .00 .0% 0190151 517020 HARVARD ENHANCED 0 0 0 .00 .00 .00 .0% 0190151 517021 HARVARD ENHANCED 0 0 0 .00 .00 .00 .0% 0190151 517025 TUFTS CLAIMS 0 0 0 .00 .00 .00 .0% 0190151 517026 TUFTS ADMIN FEES 0 0 0 .00 .00 .00 .0% 0190151 517030 TUFTS PREFERRED 0 0 0 .00 .00 .00 .0% 0190151 517031 TUFTS PREFERRED 0 0 0 .00 .00 .00 .0% 0190151 517035 STOP LOSS REIMBU 0 0 0 .00 .00 .00 .0% 0190151 517040 PRESCRIPTIONS - 0 0 0 .00 .00 .00 .0% 0190151 517041 PRESCRIPTION ADM 0 0 0 .00 .00 .00 .0% 0190151 517050 GIC HEALTH OPT O 454,000 0 454,000 253,328.77 .00 200,671.23 55.8% 0190151 517051 GIC ACTIVE-CITY 0 0 0 5,622,110.07 .00 -5,622,110.07 100.0% 0190151 517052 GIC ADMIN ACTIVE 0 0 0 16,866.34 .00 -16,866.34 100.0% 0190151 517053 GIC ACTIVE-SCHOO 0 0 0 6,189,752.55 .00 -6,189,752.55 100.0% 0190151 517054 GIC ADMIN ACTIVE 0 0 0 18,569.26 .00 -18,569.26 100.0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 76 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0190151 517055 GIC RETIREE-CITY 0 0 0 2,859,530.46 .00 -2,859,530.46 100.0% 0190151 517056 GIC ADMIN RETIRE 0 0 0 8,578.59 .00 -8,578.59 100.0% 0190151 517057 GIC RETIREE-SCHO 0 0 0 1,831,286.30 .00 -1,831,286.30 100.0% 0190151 517058 GIC ADMIN RETIRE 0 0 0 5,493.87 .00 -5,493.87 100.0% 0190151 517059 GIC SURV SPOUSE- 0 0 0 128,192.48 .00 -128,192.48 100.0% 0190151 517060 GIC ADMIN SURV S 0 0 0 384.58 .00 -384.58 100.0% 0190151 517061 GIC SURV SPOUSE- 0 0 0 .00 .00 .00 .0% 0190151 517062 GIC ADMIN SURV S 0 0 0 .00 .00 .00 .0% 0190151 517600 LIFE INSURANCE 0 0 0 .00 .00 .00 .0% 0190151 517601 LIFE INSURANCE - 0 0 0 .00 .00 .00 .0% 0190151 517602 LIFE INSURANCE - 0 0 0 .00 .00 .00 .0% 0190151 517603 LIFE INSURANCE - 0 0 0 .00 .00 .00 .0% 0190151 517604 LIFE INS. - SCHO 0 0 0 .00 .00 .00 .0% 0190151 517700 SOCIAL SECURITY 0 0 0 .00 .00 .00 .0% 0190151 517900 MEDICARE INSURAN 0 0 0 .00 .00 .00 .0% 0190151 596006 TRANSFERS TO TRU 0 2,000,000 2,000,000 2,000,000.00 .00 .00 100.0% TOTAL HEALTH & LIFE INS PERSONAL SVC 31,967,877 0 31,967,877 18,934,093.27 .00 13,033,783.73 59.2% 0190152 HEALTH & LIFE INS ORDINARY MAI 0190152 530000 PROFESSIONL & TE 20,000 0 20,000 .00 .00 20,000.00 .0% 0190152 542001 PRINTING & STATI 0 0 0 .00 .00 .00 .0% 0190152 549000 FOOD SUPPLIES & 0 0 0 .00 .00 .00 .0% 0190152 578008 REIMB/ALLOWANCES 0 0 0 .00 .00 .00 .0% 0190152 578032 MEDICARE PENALLT 192,150 0 192,150 83,732.30 .00 108,417.70 43.6% TOTAL HEALTH & LIFE INS ORDINARY MAI 212,150 0 212,150 83,732.30 .00 128,417.70 39.5% 0190251 LIFE INS & FLEX SPEND PS 0190251 517005 FLEX SPEND BENEF 20,000 0 20,000 .00 .00 20,000.00 .0% 0190251 517600 LIFE INSURANCE 0 0 0 .00 .00 .00 .0% 0190251 517601 LIFE INSURANCE - 28,305 0 28,305 20,700.19 .00 7,604.81 73.1% 0190251 517602 LIFE INSURANCE - 15,929 0 15,929 11,222.14 .00 4,706.86 70.5% 0190251 517603 LIFE INSURANCE - 24,975 0 24,975 16,128.37 .00 8,846.63 64.6% 0190251 517604 LIFE INS. - SCHO 19,314 0 19,314 13,133.81 .00 6,180.19 68.0% TOTAL LIFE INS & FLEX SPEND PS 108,523 0 108,523 61,184.51 .00 47,338.49 56.4% 0190351 MEDICARE & SSI PS 0190351 517700 SOCIAL SECURITY 0 0 0 .00 .00 .00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 77 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0190351 517900 MEDICARE INSURAN 2,691,613 2,106 2,693,719 1,416,871.51 .00 1,276,847.02 52.6% TOTAL MEDICARE & SSI PS 2,691,613 2,106 2,693,719 1,416,871.51 .00 1,276,847.02 52.6% 0191051 WORKERS COMP PERSONAL SVC 0191051 511000 SALARIES 95,119 0 95,119 53,046.57 .00 42,072.43 55.8% 0191051 512000 SALARIES & WAGES 0 0 0 .00 .00 .00 .0% 0191051 512100 WORKERSCOMP REEM 10,500 0 10,500 .00 .00 10,500.00 .0% 0191051 515006 HOLIDAYS NON-UNI 762 0 762 548.76 .00 213.24 72.0% 0191051 517001 WORKER'S COMPENS 0 0 0 .00 .00 .00 .0% 0191051 519999 RESERVED FOR REV 0 0 0 .00 .00 .00 .0% TOTAL WORKERS COMP PERSONAL SVC 106,381 0 106,381 53,595.33 .00 52,785.67 50.4% 0191052 WORKERS COMP ORDINARY MAINT 0191052 530000 PROFESSIONL & TE 20,000 0 20,000 3,263.00 5,537.00 11,200.00 44.0% 0191052 530001 MEDICAL & DENTAL 0 0 0 .00 .00 .00 .0% 0191052 530008 EMPLOYEE TRAININ 20,000 0 20,000 .00 9,995.00 10,005.00 50.0% 0191052 530009 ACCOUNTING AND A 0 0 0 .00 .00 .00 .0% 0191052 530010 LEGAL SERVICES 30,000 0 30,000 .00 30,000.00 .00 100.0% 0191052 530028 SOFTWARE SERVICE 0 0 0 .00 .00 .00 .0% 0191052 538012 WELLNESS PROGRAM 0 0 0 .00 .00 .00 .0% 0191052 542000 OFFICE SUPPLIES 1,000 0 1,000 .00 .00 1,000.00 .0% 0191052 542001 PRINTING & STATI 0 0 0 .00 .00 .00 .0% 0191052 542005 OFFICE EQUIPMENT 0 0 0 .00 .00 .00 .0% 0191052 542006 OFFICE FURNITURE 9,000 0 9,000 2,485.00 5,515.00 1,000.00 88.9% 0191052 542012 OTH EQUIPMENT NO 0 0 0 .00 .00 .00 .0% 0191052 550000 MEDICAL/DENTAL S 1,600 0 1,600 64.42 .00 1,535.58 4.0% 0191052 558000 OTHER SUPPLIES 0 0 0 .00 .00 .00 .0% 0191052 558003 PUBLIC SAFETY SU 27,500 0 27,500 16,272.80 5,304.45 5,922.75 78.5% 0191052 558004 MAGAZINES,NEWS,S 0 0 0 .00 .00 .00 .0% 0191052 558006 UNIFORMS 0 0 0 .00 .00 .00 .0% 0191052 571000 IN STATE TRAVEL 750 0 750 .00 .00 750.00 .0% 0191052 571001 IN STATE CONFERE 0 0 0 .00 .00 .00 .0% 0191052 576000 JUDGEMENTS/SETTL 0 0 0 .00 .00 .00 .0% TOTAL WORKERS COMP ORDINARY MAINT 109,850 0 109,850 22,085.22 56,351.45 31,413.33 71.4% 0191551 UNEMPLOYMENT COMP PERSONAL SVC 0191551 515006 HOLIDAYS NON-UNI 0 0 0 .00 .00 .00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 78 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0191551 517002 UNEMPLOYMENT INS 225,888 0 225,888 39,075.13 .00 186,812.87 17.3% TOTAL UNEMPLOYMENT COMP PERSONAL SVC 225,888 0 225,888 39,075.13 .00 186,812.87 17.3% 0192052 PENSION/NON-CONTRIB ORD MAINT 0192052 578008 REIMB/ALLOWANCES 0 0 0 .00 .00 .00 .0% 0192052 578020 PENSIONS/NON-CON 96,016 0 96,016 54,910.87 .00 41,105.13 57.2% TOTAL PENSION/NON-CONTRIB ORD MAINT 96,016 0 96,016 54,910.87 .00 41,105.13 57.2% 0192151 PENSION ACCUM FUND PERSONL SVC 0192151 515006 HOLIDAYS NON-UNI 0 0 0 .00 .00 .00 .0% 0192151 517004 RETIREMENT FUND 16,635,921 0 16,635,921 16,634,921.00 .00 1,000.00 100.0% TOTAL PENSION ACCUM FUND PERSONL SVC 16,635,921 0 16,635,921 16,634,921.00 .00 1,000.00 100.0% 0193058 CAPITAL 0193058 527001 RENTAL - BUILDIN 0 1,191,786 1,191,786 758,423.02 433,362.98 .00 100.0% 0193058 582003 10123 BUILDING IM 0 500,000 500,000 .00 .00 500,000.00 .0% 0193058 582003 10400 BUILDING IM 500,000 0 500,000 242,315.88 76,455.59 181,228.53 63.8% 0193058 585001 10400 VEHICLES 500,000 0 500,000 158,725.26 341,274.74 .00 100.0% 0193058 588002 10403 INFR-STREET 1,061,347 0 1,061,347 .00 .00 1,061,347.00 .0% TOTAL CAPITAL 2,061,347 1,691,786 3,753,133 1,159,464.16 851,093.31 1,742,575.53 53.6% 0194352 BUILDING INSUR ORDINARY MAINT 0194352 574001 BUILDING INSURAN 1,162,247 0 1,162,247 1,088,906.52 73,340.48 .00 100.0% TOTAL BUILDING INSUR ORDINARY MAINT 1,162,247 0 1,162,247 1,088,906.52 73,340.48 .00 100.0% 0197059 OTHER FINANCING USES 0197059 596001 TRANSFERS TO GEN 0 0 0 .00 .00 .00 .0%

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 79 FOR 2024 07 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED 0197059 596002 TRANSFERS TO SPE 675,000 49,974 724,974 724,974.00 .00 .00 100.0% 0197059 596003 TRANSFERS TO CAP 0 1,370,177 1,370,177 1,370,177.00 .00 .00 100.0% 0197059 596005 TRANSFERS TO ENT 447,937 0 447,937 447,937.00 .00 .00 100.0% 0197059 596006 TRANSFERS TO TRU 0 0 0 .00 .00 .00 .0% 0197059 596007 TRANSFER TO STAB 0 0 0 .00 .00 .00 .0% TOTAL OTHER FINANCING USES 1,122,937 1,420,151 2,543,088 2,543,088.00 .00 .00 100.0% 0199052 DAMAGE TO PERSON & PROPERTY 0199052 576000 JUDGEMENTS/SETTL 183,750 0 183,750 152,386.57 .00 31,363.43 82.9% TOTAL DAMAGE TO PERSON & PROPERTY 183,750 0 183,750 152,386.57 .00 31,363.43 82.9% 0199851 BENEFITS REIMBURSEMENT 0199851 517003 HEALTH INS-BENEF 0 0 0 -102,670.02 .00 102,670.02 100.0% TOTAL BENEFITS REIMBURSEMENT 0 0 0 -102,670.02 .00 102,670.02 100.0% 0199951 CONTINGENCY ACCOUNT 0199951 511000 SALARIES 2,532,535 -236,249 2,296,286 110,306.63 .00 2,185,979.84 4.8% 0199951 515006 HOLIDAYS NON-UNI 0 0 0 .00 .00 .00 .0% 0199951 515012 PERFECT ATTENDAN 82,000 0 82,000 .00 .00 82,000.00 .0% 0199951 519005 SICK LEAVE BUYBA 53,045 0 53,045 .00 .00 53,045.00 .0% 0199951 519021 FURLOUGH REIMBUR 0 0 0 .00 .00 .00 .0% TOTAL CONTINGENCY ACCOUNT 2,667,580 -236,249 2,431,331 110,306.63 .00 2,321,024.84 4.5% TOTAL CITY GENERAL FUND 235,472,747 3,684,168 239,156,915 126,185,235.16 20,565,279.38 92,406,400.46 61.4% TOTAL EXPENSES 235,472,747 3,684,168 239,156,915 126,185,235.16 20,565,279.38 92,406,400.46

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 80 FOR 2024 07 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD EXPENDED ENC/REQ BUDGET USED GRAND TOTAL 235,472,747 3,684,168 239,156,915 126,185,235.16 20,565,279.38 92,406,400.46 61.4% ** END OF REPORT - Generated by Emily Peng **

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 81 REPORT OPTIONS Field # Total Page Break Sequence 1 1 Y Y Sequence 2 9 Y N Sequence 3 0 N N Sequence 4 0 N N Report title: YEAR-TO-DATE BUDGET REPORT Includes accounts exceeding 0% of budget. Print totals only: N Year/Period: 2024/ 7 Print Full or Short description: F Print MTD Version: N Print full GL account: N Format type: 1 Roll projects to object: N Double space: N Carry forward code: 2 Suppress zero bal accts: N Include requisition amount: Y Print Revenues-Version headings: N Print revenue as credit: Y Print revenue budgets as zero: N Include Fund Balance: N Print journal detail: N From Yr/Per: 2024/ 7 To Yr/Per: 2024/ 7 Include budget entries: Y Incl encumb/liq entries: Y Sort by JE # or PO #: J Detail format option: 1 Include additional JE comments: N Multiyear view: D Amounts/totals exceed 999 million dollars: N Find Criteria Field Name Field Value Fund 0001 Func Year Prog/DOEFunc Dept/Loc SDeptSubject Rev DOEPrg Budget Ctrl Character Code Org Object Project Account type Expense

City of Somerville YEAR-TO-DATE BUDGET REPORT Report generated: 02/12/2024 12:44 User: 1278epeng Program ID: glytdbud Page 82 REPORT OPTIONS Account status Rollup Code