Loading...
HomeMy WebLinkAboutFIN 2020-04-13 Item 1A - Report - February Monthly Financial ReportCity of Tukwila Allan Ekberg, Mayor INFORMATIONAL MEMORANDUM TO: Finance Committee FROM: Vicky Carlsen, Finance Director BY: Jeff Friend, Fiscal Manager CC: Mayor Ekberg DATE: April 13, 2020 SUBJECT: February 2020 Departmental Budget-to-Actuals Report Summary The purpose of the February 2020 General Fund Financial Report is to summarize for the City Council the general state of departmental expenditures and to highlight significant items. The following provides a high-level summary of the departmental financial performance. The February 2020 Report is based on financial data available as of April 2, 2020, for the period ending February 29, 2020. Additional details can be found within the attached financial report. Expenditures General Fund expenditures totaled $10.7 million through February, which is $653 thousand less than the allocated budget of $11.4 million. The allocated budget is calculated to reflect year-to- date spending patterns of the previous year. Departmental Variances Thirteen of fourteen General Fund departments were under their allocated budget through February 2020. Major variances are: • Public Works was $7 thousand over the allocated budget of $728 thousand. The variance is due to the annual property insurance payment being $55 thousand more than anticipated in the annual budget. The City's insurance company performed an audit in 2019 which resulted in increased insurance rates. INFORMATIONAL MEMO Page 2 Year -to -Date Department Expenditures Compared to Allocated Budget (Through February 2020) City Council $56 $64 Mayor $407 - $458 Administrative Services $249 - $282 Finance $705 $773 Attorney $58 $63 Recreation $516 - $530 Community Development $529 $572 Municipal Court $226 _ $227 Police Fire Technology & Innovation $267 Svcs $290 Public Works $735 $728 Park Maintenance $361 $371 Street Maintenance & - Operations - Dept 20 $0 $0 $0 $500 GENERALFUND CITY OF TUKW ILA GENERAL FUND EXPENDITURES i2,292 $2,362 $1,208 $1,254 $1,000 $1,500 $2,000 $2,500 $3,000 ■ YTD Actual ■ YTD Budget $3,468 $3,500 $4,000 Thousands Year -to -Date as of February 28. 2020 BUDGET ACTUAL COMPARISON OF RESULTS EXPENDITURES BY ACTUAL DEPARTMENT OV ER/(UNDER) % CHANGE 2020 2020 ANNUAL ALLOCATED 2018 2019 2020 ALLOCATED BDGT EXPENDED 2018/2019 2019/2020 01 CityCouncil 439,772 64,458 58,476 59,842 56,499 (7,959) 13% 2% (6)% 03 Mayor 2,652,852 457,573 407,646 422,262 407,158 (50,415) 15 % 4 % (4) % 04 Administrative Services 2,180,956 282,453 249,794 219,056 248,846 (33,607) 11% (12)% 14% 05 Finance 2,753,260 772,510 634,862 680,306 704,752 (67,758) 26 % 7 % 4 % 06 Attorney 710,730 63,328 1,743 665 57,676 (5,652) 8% (62)% 8568% 07 Recreation 3,354,374 529,817 469,729 471,354 516,291 (13,526) 15 % 0 % 10% 08 Community Development 3,611,354 572,473 500,579 530,659 529,376 (43,097) 15% 6% (0)% 09 Municipal Court 1,330,951 227,147 203,122 192,182 225,877 (1,270) 17% (5)% 18% 10 Police 19,194,006 3,468,281 3,113,670 3,176,565 3,179,748 (288,533) 17% 2% 0% 11 Fire 13,118,888 2,361,783 2,059,503 2,271,472 2,292,300 (69,483) 17% 10% 1% 12 Technology&Innovation Svcs 2,099,687 289,851 290,907 270,546 266,748 (23,103) 13% (7)% (1)% 13 Public Works 4,043,635 728,054 663,098 661,597 734,557 6,502 18% (0)% 11% 15 Park Maintenance 1,656,398 371,220 261,306 346,884 361,473 (9,747) 22% 33% 4% 16 Street Maintenance & Operations 3,255,276 1,253,543 744,576 1,282,090 1,208,122 1 (45,421) 37 % 72 % (6) % Subtotal 60,402,139 11,442,492 9,659,009 10,585,479 10,789,422 (653,070) 18% 10% 2% 20 Dept 20 7,319,140 - 2,050,000 1,350,000 - - - (34)% - TotalExpenditures 67,721,279 11,442,492 11,709,009 11,935,479 10,789,422 (653,070) 16% 2% (10)% Percent of year conpleted 17% 2 INFORMATIONAL MEMO Page 3 GENERALFUND CITY OF TUKW ILA GENERAL FUND EXPENDITURES Year -to -Date as of February 28, 2020 BUDGET ACTUAL COMPARISON OF RESULTS ACTUAL SALARIES AND BENEFITS 0VB7/(UNDER) %CHANGE 2020 ALLOCATED 2020 ANNUAL ALLOCATED 2018 2019 2020 13DGT B(PENDED 2018/2019 2019/2020 11 Salaries 30,064,147 5,010,691 4,521,543 4,608,338 4,854,409 (156,282) 16% 2% 5% 12 Extra Labor 764,697 127,450 81,481 97,922 87,937 (39,512) 11 % 20% (10)% 13 Overtime 1,354,099 237,080 220,522 272,001 231,013 (6,067) 17% 23% (15)% 15 Holiday Pay 555,369 - 97 3,891 1,853 1,853 0% 3930% (52)% 21 FICA 2,100,726 350,121 296,020 296,589 308,206 (41,915) 15% 0% 4% 22 Pension-LEOFF2 913,369 152,228 138,003 139,809 143,287 (8,941) 16% 1% 2% 23 Pension-PERS/PSERS 1,805,556 300,926 279,347 284,940 298,079 (2,847) 17% 2% 5% 24 Industrial Insurance 934,878 155,813 96,455 162,267 133,590 (22,223) 14% 68% (18)% 25 Medical & Dental 6,457,336 1,076,223 923,300 943,627 1,052,869 (23,353) 16% 2% 12 % 26 Unemployment - - 16,622 - 6,681 6,681 - - 28 Uniform/Clothing 8,525 616 1,030 235 239 (377) 3% (77)% 2% Total Salaries and Benefits 44,958,702 71411,148 1 6,574,418 6,809,618 7,118,164 1 (292,984) 16% 4% 5% BUDGET ACTUAL COMPARISON OF RESULTS SUPPLIES, SERVICES, AND ACTUAL CAPITAL OVER/(UNDER) % CHANGE ALLOCATED % 2020 2020 ANNUAL ALLOCATED 2018 2019 2020 BDGT IXPENDED 2018/2019 2019/2020 0 Transfers 7,319,140 - 2,050,000 1,350,000 - - - (34)% - 31 Supplies 1,066,112 228,832 138,545 226,085 119,784 (109,049) 11 % 63% (47)% 34 Items Purchased for resale 22,000 235 - - 235 - 1% - - 35 Small Tools 133,569 5,000 11,144 4,528 14,946 9,946 11% (59)% 230% 41 Professional Services 5,908,964 693,475 680,039 601,856 582,843 (110,632) 10% (11)% (3)% 42 Communication 434,600 61,647 55,448 57,908 60,954 (693) 14% 4% 5% 43 Travel 159,630 21,108 28,622 22,886 21,946 838 14% (20)% (4)% 44 Advertising 47,550 11,261 3,796 1,539 3,840 (7,421) 8% (59)% 149% 45 Rentals and Leases 2,422,514 445,688 351,180 468,793 365,809 (79,879) 15% 33% (22)% 46 Insurance 1,047,762 1,043,128 967,328 883,280 980,935 (62,193) 94% (9)% 11 % 47 Public Utilities 2,069,101 1,118,549 602,659 1,069,128 1,137,147 18,598 55% 77% 6% 48 Repairs and Maintenance 587,912 182,568 32,316 191,581 100,436 (82,132) 17% 493% (48)% 49 Miscellaneous 1,273,723 181,519 208,702 248,275 282,382 100,863 22% 19% 14% 64 Machinery&Equipment 270,000 38,333 4,812 - - (38,333) - - - Total Supplies, Services, and Capital 1 22,762,577 4,031,3441 5,134,592 5,125,861 3,671,258 (360,086) 16% (0) % (28) Total Expenditures 1 67,721,279 11,442,492 1 11,709,009 11,935,479 10,789,422 (653,070) 16% 2% (10) Percent of year completed 17%