Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Reg 2012-05-21 Item 2C - Presentation - 2012 First Quarter Financial Report
Prepared By: Peggy McCarthy & Craig Zellerhoff March 31, 2012 I et J I i� 0 ;0 mimi ;.1 ;m10.4 g Cit w� CNI ro a" Summary City-wide, unreserved fund balances increased $1.095 million in the first quarter 2012 from $43.9 million at December 31, 2011 to $45 million at March 31, 2012. The governmental funds reduced the City-wide fund balance by $45 thousand, the internal service funds and the enterprise funds contributed $531 thousand and $609 thousand respectively as increases to the City-wide balance. Of the governmental funds, the General Fund experienced a fund balance increase $225 thousand which is slightly lower than the increase experienced in 2011 (after adjustment). Further discussion of the governmental funds and the General Fund occurs on the following pages. The enterprise funds had a net increase of $609 thousand due mainly to revenue received from the January semi-annual billing of the surface water fees. The Water Fund decline stems from the cyclical nature of water usage with greater consumption occurring in the summer months billed out at the higher summer water rates. The Golf Course revenue is also cyclical with few- er rounds of golf played in the winter months causing a revenue shortfall and a corresponding decline in fund balance for the first quarter. The financial outlook for the City remains stable. However, financial uncertainly continues to be a concern. Global issues, such as the financial troubles with the European Union, have an affect on national and local economies. Nationally, the federal income tax rates will increase in 2013 unless the federal government takes action in 2012 to retain the existing rates. Any reduction in discretionary income affects consumer spending and thereby sales tax collections — impacting both City and State revenues. To protect against these financial uncertainties, the City continues to follow conservative financial policy. CITY-WIDE FUND BALANCES CHANGE IN FUND BALANCES Variance ACTUAL -- ACTUAL ----- BUDGET -- YTD 12/31/2011 03/31/2012 YTD YTD Governmental funds $ 24,804,984 $ 24,760,196 $ (44,788) $ 605,970 $ (650,758) Enterprise funds 9,028,484 9,637,594 609,110 (765,186) $ 1,374,296 Internal service funds 10,125,668 10,656,870 531,202 39,170 $ 492,031 City-wide Total $ 43,959,136 $ 45,054,660 $ 1,095,524 $ (120,046) $ 1,215,570 General Fund Hotel/Motel Tax Fund Street Fund Arterial Street Fund Contingency Fund Fire Equip Cum Reserve Drug Seizure Fund Debt Service Funds Parks Acq Fund Facility Replacement Fund General Gov Improvements Fire Impact Fee Fund Water Fund Sewer Fund Foster Golf Fund Surface Water Fund Equipment Replacement Fund Self -Insurance Fund - LEOFF Insurance Fund * * Unreserved /unrestricted Fund Balances** As of March 31, 2012 IJ 1 $496,220 $960,886 0 929 i $1 457 $226,462 r 6884,410 $2,019,099 $3,314,752 !! $1,430,473 0 $6 110 $316,59 $4,251,751 & $2,078,188 $14,771 $3,292,884 $3,653,947 695,503 $5,307,41 i 011 1 $6 137 79 6,882.475 $1,000,000 $2,000,000 $3,000 000 $4,000 000 $5,000 000 $6,000 000 $7,000.000 Inside this issue: Governmental Funds 2 General Fund Expenditures General Fund Revenues 2-4 5 Enterprise and Internal Service Funds 1 Governmental Funds Change in Fund Balances Governmental Funds FUND BALANCES CHANGE IN FUND BALANCES Variance YTD ACTUAL 12/31/2011 03/31/2012 --- ACTUAL -------- YTD BUDGET ---- YTD 000 -General Fund $ 5,912,116 $ 6,137,790 $ 225,674 $ (781,603) $ 1,007,276 101 - Hotel/Motel Tax Fund 787,568 $ 496,220 (291,348) (76,900) (214,448) 103 - Street Fund 903,937 960,886 56,949 (52,224) 109,172 104 - Arterial Street Fund 6,929,396 6,882,475 (46,921) 1,345,723 (1,392,644) 105 - Contingency Fund 1,457,728 1,457,929 201 750,454 (750,253) 107 - Fire Equip Cum Reserve 890,797 884,410 (6,387) 32,281 (38,668) 109 - Drug Seizure Fund 229,711 226,462 (3,249) 17,750 (20,999) Special Revenue Funds 11,199,137 10,908,381 (290,756) 2,017,084 (2,307,840) 2xx - Debt Service 3,316,312 3,314,752 (1,560) (72,745) 71,184 301 - Parks Acq Fund 1,427,973 1,430,473 2,500 (361,851) 364,351 302 - Facility Replacement Fund 2,027,014 2,019,099 (7,915) (20,550) 12,635 303 - General Gov Improvements 608,613 633,110 24,497 (186,892) 211,389 304 - Fire Impact Fee Fund 313,819 316,591 2,772 12,525 (9,753) Capital Project Funds 4,377,419 4,399,273 21,854 (556,767) 578,622 TOTAL GOVERNMENTAL FUND $24,804,984 $24,760,196 $ (44,788) $ 605,970 $ (650,758) First quarter activity resulted in a slight decrease of $44,788 in the governmental fund balances comprised of an increase in the General fund balance of $225,674 and a decrease of $291K in the Hotel/Motel Tax Fund. The decline in the Hotel/Motel Tax Fund balance was due to a delay in receiving reimbursement funds from Seattle Southside member agencies. These amounts were received in second quarter. The General Fund balance increase of $225K compares with the 2011 fund balance increase of $456K (this amount is adjusted to achieve comparability between the two years - the 2011 transfer out to the Contingency Fund of $556K is added back to fund balance since a corresponding transfer out was not made in the first quarter of 2012). First quarter General Fund revenue was $10.929 million for 2012 compared with $10.876 million for 2011; General Fund expenditures were $10.704 million for 2012 compared with $10.42 million in 2011 (after reducing 2011 expenditures for the $566K transfer out to the Contingency Fund). The increase in expenditures is partially due to the increase in the WCIA liability insurance assessment as a result of lowing the deductible from $100,000 in 2011 to $25,000 in 2012. General Fund revenues and expenditures are discussed in more detail on the following pages. Paget 2012 FIRST QUARTER FINANCIAL REPORT 2 General Fund Revenue Actual revenue achieved for the first quarter was 20.50% of the annual budget instead of the 25% expected, producing a $2.4 million negative variance for the quarter. First quarter 2012 reve- nues totaled $10.929 million compared with $10.876 for 2011. Selected revenues are dis- cussed below. 2012 Annual Budget Prorated Budget Actual Year -To -Date Variance Actual to Prorated Budget %of Annual Budget $53,317,041 $13,329,260 j $10,929,730 I ($2,399,530) 20.50% Taxes PROPERTY TAX REVENUE 2012 Annual Budget Prorated Budget Actual Year -To -Date Variance ActualtoProrated Budget %of Annual Budget Real and Personal Property $13,868,250 $3,467,063 $445,399 ($3,021,663) 3.21% The first quarter negative revenue variance is due to the timing of property tax collections which are received mostly in the 2nd and 4th quarters of the year corresponding with the April 30th and October 31st tax payment due dates. Property tax received through the first quarter represented only 3.21% of budget. However, the property tax collected as of this writing totals $7 2 million and exceeds 50% of budget suggesting all budgeted property tax will be collected for the year. SALES & USE TAX 2012 Annual Budget Prorated Budget Actual Year -To -Date Variance Actual to ANNUAL Budget %of Annual Budget Sales Tax $14,413,000 $3,603,250 $3,948,063 $344,813 27.39% Sales Tax Mitigation $1,200,000 $300,000 $301,763 $1,763 25.15% Natural Gas Use Tax $280,000 $70,000 $83,376 $13,376 29.78% Sales Tax Criminal Justice $355,000 $88,750 $96,654 $7,904 27.23% TOTAL SALES & USE TAX $16,248,000 $4,062,000 $4,429,857 $367,857 27.26% Sales and use tax received in the first quarter totaled $4.4 million which exceeds the prorated budget for this period by $367,857. The revenue includes sales tax collected in November and December of 2011 and January 2012 but received by the City in Janu- ary, February and March of 2012 reflecting the two-month delay in the tax remittance from the State. Of sales tax received in the past four months (January through April 2012), the $50K year over year increase in the April remittance was the only substantial increase experienced. More in depth sales tax information will be presented at the Finance & Safety Committee meeting June 19th. OTHER TAX REVENUE 2012 Annual Budget Prorated Budget Actual Year -To -Date Variance Actual to Prorated Budget %of Annual Budget ADMISSION TAXES $654,000 $163,500 $120,813 ($42,687) 18.47% EXCISE TAX Gambling tax $2,502,142 $625,536 $218,196 ($407,340) 8.72% Leasehold tax $139,161 $34,790 $609 ($34,182) 0.44% TOTAL EXCISE TAX $2,641,303 $660,326 $218,804 ($441,521) 8.28% In 2011, admissions tax collections were less than budget and this trend continues in 2012. The revenue for the first quarter 2012 totaled $120,813, exceeding first quarter 2011 by approximately $5,000. Most of this revenue is generated by the movie theatres. Attendance fluctuates based on popularity of movies shown and other factors. Gambling tax revenue is below budget due to reduced revenues received from one casino in particular; this reduction is partially offset by increased revenue by a new casino that opened in December 2011. Page 3 24312 FIRST QUARTER FINANCIAL REPORT 3 General Fund Revenue -Continued License Fees FEE REVENUE 2012 Annual Budget Prorated Budget Actual Year -To -Date Variance Actual to ANNUAL Budget o of Annual /o Budget Revenue Generating Regulatory License (RGRL) $1,975,000 $493,750 $1,640,354 ($334,646) 83.06% Rental Housing License $42,750 $10,688 $28,950 ($13,800) 67.72% Business Licenses $807,227 $201,807 $441,350 ($365,877) 54.67% Revenue Generating Regulatory License (RGRL) fees generated revenue equal to 83% of the annual budget or $334,646 less than expected for the year. Business License Fee revenue is equal to 54.67% of the annual budget or $365,877 less than expected for the year. The majority of the revenue is received in the first quarter, however collection of late payments and continual collection of fees from new business and contractors doing business in the City will add to this revenue total throughout the remainder of the year. Charges for Services CHARGES FOR SERVICES 2012 Annual Budget Prorated Budget Actual Year -To -Date Variance Actual to Prorated Budget o /o of Annual Budget SECURITY Law Enforcement Services $185,000 $46,250 $13,714 ($32,536) 7.41% Probation Services $85,390 $21,348 $20,538 ($809) 24.05% Protective inspection fees $231,019 $57,755 $84,161 $26,407 36.43% Other $9,725 $2,431 $2,822 ($6,939) 29.02% TOTAL SECURITY $511,134 $127,784 $121,235 $18,658 23.72% PLAN CHECK & REVIEW FEES Zoning and subdivision fees $130,000 $32,500 $16,592 ($15,908) 12.76% Plan checking fees $685,000 $171,250 $96,559 ($74,691) 14.10% Other $43,500 $10,875 $3,883 ($6,992) 8.93% TOTAL PLAN CHECK & REVIEW $858,500 $214,625 $117,034 ($97,591) 13.63% CULTURE AND REC FEES Fitness drop ins, passes $68,000 $17,000 $26,939 $9,939 39.62% Youth & Teen programs $399,000 $99,750 $30,392 ($69,358) 7.62% Adult & Senior Programs $144,500 $36,125 $24,154 ($11,971) 16.72% TOTAL CULTURE & REC $611,500 $152,875 $81,527 ($71,348) 13.33% The General Fund revenue category, charges for services, yielded only 15.01% of budget producing a $220,714 negative budget variance. This variance is partially due to the cyclical nature of the fees as many of the activates generating the fees occur more frequently in the second and third quarter of the year. The Recreation programs have many more participants in the summer months; construction activity, which generates protective inspection fees and plan check and review fees, also accelerates in the spring and summer months. The first quarter total for Charges for Services revenue of $331,811 is comparable to the first quarter revenue for the first quarter of 2011 of $363.206. Page 4 2012 FIRST QUARTER FINANCIAL REPORT 4 General Fund Expense GENERAL FUND EXPENDITURES -By Department DEPARTMENTS Annual Budget Prorated Budget 1st Qtr Actual Variance** %of Budget City Council 269,655 67,414 $ 60,512 $ (6,901) 22.4% Mayor 2,543,991 635,998 458,394 (177,604) 18.0% Human Resources 573,396 143,349 124,569 (18,780) 21.7% Finance 1,603,133 400,783 368,366 (32,417) 23.0% City Attorney 542,734 135,684 80,320 (55,364) 14.8% Recreation 2,530,147 632,537 521,242 (111,295) 20.6% Community Development 2,858,579 714,645 629,064 (85,581) 22.0% Municipal Court 993,849 248,462 237,168 (11,295) 23.9% Police 14,197,710 3,549,428 3,408,027 (141,400) 24.0% Fire 10,308,193 2,577,048 2,456,619 (120,429) 23.8% Information Technology 1,153,947 288,487 230,546 (57,940) 20.0% Public Works 3,613,803 903,451 755,803 (147,648) 20.9% Park Maintenance 935,027 233,757 245,544 11,787 26.3% Street Maintenance 2,676,535 669,134 778,741 109,608 29.1% Dept 20 11,642,752 2,910,688 349,142 (2,561,546) 3.0% TOTAL $ 56,443,451 $ 14,110,863 $ 10,704,057 $ (3,406,806) 19.0% The General Fund expenditures constituted 19.0% of the budget at March 31st, producing a quarterly prorated savings of $3.4 million. Some of the savings, $2.5 million, comes from delayed transfers out of the general fund and into other funds. The $10,364,752 annual budget for transfers out of the general fund is comprised of the amounts in the table at right. These trans- fers will be made to the funds on an as needed basis. All departments in the General Fund are below budget with the exception of Street Maintenance which incurred costs in connection with the January snow storm. The City is currently applying for disaster reimbursement through FEMA for costs associated with storm. BUDGET- Dept 20, Transfers -out Fund # Fund Name in Thous $ 103 Residential Streets $ 220 104 Arterial Streeet 2,000 105 Contingency 3,000 107 Fire Equipment Rsv 130 109 Drug Seizure 75 303 Gen'I Govt Imprvments 1,300 various Debt Service 3,309 401 Water Fund 106 411 Golf Course Fund 225 TOTAL $ 10,365 GENERAL FUND EXPENDITURES - By Type CATEGORIES Annual Budget Prorated Budget 1st Qtr Actual Variance** %of Budget Salary and benefits $ 33,702,558 $ 8,425,640 $ 7,891,054 $ (534,586) 23.4% Supplies 1,193,673 298,418 214,730 (83,689) 18.0% Professional services 8,180,993 2,045,248 2,186,797 141,549 26.7% Intergovernmental 1,969,475 492,369 374,107 (118,262) 19.0% Capital expenditures 307,000 76,750 12,754 (63,996) 4.2% Miscellaneous general 11,089,752 2,772,438 24,615 (2,747,823) 0.2% TOTAL $ 56,443,451 $ 14,110,863 $ 10,704,057 $ (3,406,806) 19.0% Salaries and Benefits are slightly lower than budget by $534,586 as salary increases for the non -represented employees were re- flected in the budget but will not be paid until the second quarter. The below budget variances on the other expenditure types is due to timing of expenditures. Page 5 2012 FIRST QUARTER FINANCIAL REPORT 5 Other Governmental funds Fund 104 -Arterial Street Fund. Capital expenditure activi- ty included work on the Urban Transit Center and Andover Park West, the Southcenter Parkway Extension and overlay projects. Fund 303 -General Government Fund. On May 14th, the King County Flood Control District agreed to provide 75% of the funds needed for the removal of the sandbags and other flood mitigation devices along the Green River. Enterprise Funds ENTERPRISE FUNDS FUND BALANCES CHANGE IN FUND BALANCES Variance YTD ACTUAL --- ACTUAL -------- BUDGET ---- 12/31/2011 03/31/2012 YTD YTD 401 - Water Fund $ 4,787,053 $ 4,251,751 $ (535,302) $ (222,305) $ (312,997) 402 - Sewer Fund 1,890,166 2,078,188 188,022 (292,154) 480,176 411 - Foster Golf Fund 200,116 14,771 (185,345) (39,379) (145,967) 412 - Surface Water Fund 2,151,149 3,292,884 1,141,735 (211,348) 1,353,084 ENTERPRISE FUNDS $ 9,028,484 $ 9,637,594 $ 609,110 $ (765,186) $ 1,374,296 Fund 401 -Water. The Water fund realized a fund balance decrease of $535K during the quarter. Revenue through the first quarter is at 19.98% of budget with revenue from the sale of water at 19.96%. The cost to purchase water is at 31.95% of budget and includes an annual fee paid to Cascade Water Alliance in the first quarter each year. Fund 402 -Sewer. The Sewer fund realized a fund balance increase of $188,022 on sewer revenue of $1.5 million or 28.89% of budget. Revenues and expenses through the first quarter are 28.89% and 21.03% of budget. Fund 411 -Golf Course. The Golf Course realized a fund bal- ance decrease of $185,345. Revenues and expenses through the first quarter are 6.22% and 14.69% of budget. Green fees during the first quarter were 6.06% of budget, but should increase dur- ing the second and third quarters as the weather improves and golf rounds played increases. Fund 412 -Surface Water. The Surface Water fund realized a fund balance increase of $1.1 million, due to the timing of the semi-annual billings during the first quarter. Revenues and ex- penses through the first quarter are 49.25% and 15.09% of budget. Internal Service Funds INTERNAL SERVICE FUNDS FUND BALANCES CHANGE IN FUND BALANCES Variance YTD ACTUAL --- ACTUAL -------- BUDGET ---- 12/31/2011 03/31/2012 YTD YTD 501 - Equipment Replacement $ 3,513,202 $ 3,653,947 $ 140,745 $ 336,027 $ (195,282) 502 - Self -Insurance Fund 4,983,480 5,307,419 323,939 (81,237) 405,176 503 - LEOFF Insurance Fund 1,628,986 1,695,503 66,517 (98,109) 164,626 INTERNAL SERVICE FUNDS $10,125,668 $10,656,870 $ 531,202 $ 156,681 $ 374,521 Fund 501 -Equipment Replacement. Expenditures for the first quarter are $454,129 or 22.37% of budget. Fund 502 -Insurance. Employee healthcare costs are under - budget for the first quarter. In the second quarter the fund has experienced an increase in claim activity and amounts, which will have a negative impact on the fund balance. During the first quarter, activity resulted in an increase of $323,939 to the fund balance. Fund 503-LEOFF Insurance. First quarter activity resulted in an increase of $66,517 to the fund balance. Claim activity through 2012 was lower than the revenue received through em- ployer contributions. Page 6 2012 FIRST QUARTER FINANCIAL REPORT 6 City of Tukwila Statement Footnotes As of March 31 2012 The following footnotes comment on significant differences in the following quarterly financial statements. FN Comment (a) Insurance premiums are paid once a year at the beginning of the year. Therefore most, if not all, of the annual budget has been expended by the end of the first quarter. (b) Purchase of network and computer equipment will occur later in the year. (C) Fire Department salaries are slightly over budget due to 2012 clothing allowance of $20,319 paid in January, Standby Pay, Fire Admin budgeted at .75 FTE, EOC budget based on .5 FTE Cert Trainer but working full-time and Emergency Management Coordinator budgted as non -rep position, but filled by Batallion Chief Martin Grisham with a higher compensation than budget. (d) 2012 EDEN maintenance fees of $53,085 (e) 2012 Property tax of $1,969 (f) Park Department salaries are over budget due to two positions eliminated for 2011-2012 budget, but positions were reinstated after union grievance. (g) 2012 Snow/Ice storm related expenses, a portion of the expenses will be reimbursed by FEMA. (h) Pubilic Utility costs include the 1st Half of 2012 Surface Water and Sewer charges. (i) Attorney costs relate to the revolving fund with WCIA. (i) Intergovernment revenues for the first quarter were received in April. (k) Advertising costs exceed the prorated budget due to the printing costs related to the Annual Planning Guide. (I) Certain Public Works staff, whose salaries are budgeted in the general fund, worked on arterial street projects and charged their time to this fund creating an overbudget situation. The only two staff that are budgeted into the arterial street fund are Mike Ronda and Cyndy Knighton. (m) Construction projects for 2012 include the Urban Transit Center, Andover Park West, ongoing Southcenter Parkway and 2012 overlay projects. Acitvity on these projects will ramp up during the second quarter of 2012. (n) Water purchases during the first quarter include the annual fee charge of $126,558. (a) Sewer Department salaries are over budget due to coverage by other employees from various departments due to an employee out on medical leave. Time loss reimbursements of $10,000 were received and deposited in April 2012. (p) The decrease in revenue for 2012 was due to poor spring weather affecting participation rates. 7 City of Tukwila General Fund 000 - Revenue and Expenditures As of March 31 2012 % of year expired 25.00% 2012 Annual Budget Prorated Budget Actual Year -To -Date Variance " % of Annual Budget Revenue General Revenue Property Taxes Sales and Use Taxes Revenue Generating Regulatory Lics Rental housing license Admissions Tax Utility Taxes Interfund Utility Tax Excise Taxes LEASEHOLD EXCISE TAX GAMBLING TAXES Penalties/Interest Total General Revenue Licenses and Permits Business Licenses and Permits Building Permits and Fees Total Licenses and Permits Intergovernmental Revenue Charges for Services General Government Security Engineering Services Transportation Plan Check and Review Fees Culture and Rec Fees Total Charges for Services Fines and Penalties Miscellaneous Revenue Investment Earnings Rents and Concessions Insurance Premiums/Recovery Contributions/Donations Other Misc Revenue Total Miscellaneous Revenue Sale of Capital Assets Transfers In / Indirect cost allocation Total Revenue Total Expenses (g) Change in Fund Balance Beginning Fund Balance Ending Fund Balance Cash and investments $ 13,868,250 16,248,000 1,975,000 42,750 654,000 4,840,000 1,524,000 2,641,303 139,161 2,502,142 67 41,793,370 $ 3,467,063 4,062,000 493,750 10,688 163,500 1,210,000 381,000 660,326 34,790 625,536 17 $ 445,399 4,429,857 1,640,354 28,950 120,813 1,132,756 437,949 218,804 609 218,196 28 10,448,343 807,227 201,807 1,058,589 264,647 8,454,912 $ (3,021,663) 367,857 1,146,604 18,263 (42,687) (77,244) 56,949 (441,521) (34,182) (407,340) 12 (1,993,431) 3.21% 27.26% 83.06% 67.72% 18.47% 23.40% 28.74% 8.28% 0.44% 8.72% 42.33% 20.23% 441,350 239,543 54.67% 195,968 (68,680) 18.51% 1,865,816 466,454 2,944,147 736,037 60,951 15,238 511,134 127,784 9,867 2,467 158,149 39,537 858,500 214,625 611,500 152,875 637,317 170,863 34.16% 735,521 (516) 24.98% 10,926 (4,312) 17.93% 121,235 (6,548) 23.72% (2,467) 0.00% 1,089 (38,448) 0.69% 117,034 (97,591) 13.63% 81,527 (71,348) 13.33% 2,210,101 552,525 213,270 53,318 133,757 33,439 417,203 104,301 1,000 250 1,600 400 99,200 24,800 331,811 (220,714) 15.01% 49,467 (3,850) 23.19% 20,544 (12,895) 15.36% 99,939 (4,361) 23.95% (250) 0.00% 3 (397) 0.17% 17,549 (7,251) 17.69% 652,760 163,190 1,300,500 325,125 2,337,077 584,269 138,036 (25,154) 21.15% (325,125) 0.00% 582,666 (1,603) 24.93% 53, 317, 041 13, 329, 260 10, 929, 730 56,443,451 14,110, 863 10, 704, 057 (3,126,410) (781,603) 4,441,652 4,441,652 225,674 5,912,116 (2,399,530) 20.50% (3,406,806) 18.96% 1,007,276 -7.22% 1,470,464 133.11% $ 1,315,242 $ 3,660,050 $ 6,137,790 $ 2,477,740 ** Variance = Actual over (under) prorated budget Fund 000 8 $ 3,263,311 City of Tukwila General Fund Expenditures - By Department As of March 31 2012 TOTALS - ALL DEPARTMENTS CITY COUNCIL MAYOR HUMAN RESOURCES FINANCE CITY ATTORNEY RECREATION COMMUNITY DEVELOPMENT MUNICIPAL COURT POLICE FIRE INFORMATION TECHNOLOGY PUBLIC WORKS PARK MAINTENANCE STREET MAINTENANCE & OPERATION DEPT 20 TOTAL Annual Budget $ 269,655 2,543,991 573,396 1,603,133 542,734 2,530,147 2,858,579 993,849 14,197,710 10,308,193 1,153,947 3,613,803 935,027 2,676,535 11,642,752 $ 56,443,451 Prorated Budget $ 67,414 635,998 143,349 400,783 135,684 632,537 714,645 248,462 3,549,428 2,577,048 288,487 903,451 233,757 669,134 2,910,688 $ 14,110,863 Actual Spent $ 60,512 458,394 124,569 368,366 80,320 521,242 629,064 237,168 3,408,027 2,456,619 230,546 755,803 245,544 778,741 349,142 $ 10,704,057 of year expired 25.00% Variance % Spent $ (6,901) 22.44% (177,604) 18.02% (18,780) 21.72% (32,417) 22.98% (55,364) 14.80% (111,295) 20.60% (85,581) 22.01% (11,295) 23.86% (141,400) 24.00% (120,429) 23.83% (57,940) 19.98% (147,648) 20.91% 11,787 26.26% 109,608 29.10% (2,561,546) 3.00% $ (3,406,806) • 18.96% 01 - CITY COUNCIL • Annual Budget Prorated Budget Actual Spent Variance % Spent 11 SALARIES 21 FICA 23 PERS 24 INDUSTRIAL INSURANCE 25 MEDICAL,DENTAL,LIFE,OPTICAL 31 OFFICE & OPERATING SUPPLIES 41 PROFESSIONAL SERVICES 42 COMMUNICATION 43 TRAVEL 49 MISCELLANEOUS CITY COUNCIL 177,720 13,274 8,016 2,745 20,630 3,870 1,500 4,400 25,000 12500 269,655 44,430 3,319 2,004 686 5,158 968 375 1,100 6,250 3,125 43,782 3,281 1,576 503 4,197 410 974 5,564 225 I 60,512 " Variance = Actual over (under) prorated budget Fund 000 By Dept (648) (37) (428) (183) (961) (557) (375) (126) (686) (2,900) (6,901) 24.64% 24.72% 19.66% 18.33% 20.34% 10.61% 0.00% 22.14% 22.26% 1.80% 22.44% 9 City of Tukwila General Fund Expenditures - By Department As of March 31 2012 % of year expired 25.00% 03 - MAYOR Annual Budget Prorated Budget Actual Spent Variance % Spent 11 SALARIES 12 EXTRA LABOR 13 OVERTIME 21 FICA 23 PERS 24 INDUSTRIAL INSURANCE 25 MEDICAL,DENTAL,LIFE,OPTICAL 31 OFFICE & OPERATING SUPPLIES 35 SMALL TOOLS & MINOREQUIPMENT 41 PROFESSIONAL SERVICES 42 COMMUNICATION 43 TRAVEL 44 ADVERTISING 45 OPERATING RENTALS & LEASES 48 REPAIRS & MAINTENANCE 49 MISCELLANEOUS 49-00 Miscellaneous 49-01 Memberships, dues, subscriptons 49-02 Microfilm imaging 49-03 Employee recognition 49-04 Recorded documents 49-05 Registrations 49-08 Credit card fees 49-51 CTR reimbursement 49-53 Hearing examiner fees 49-56 Green initiatives 51 INTERGVRNMTL PROFESSIONAL SVCS 64 MACHINERY & EQUIPMENT MAYOR 1,001,516 15,500 573 71,953 89,697 4,167 173,067 33,856 4,935 759,470 85,300 19,800 17,250 28,108 14,500 176,799 34,415 40,900 14,300 15,000 4,300 2,500 431 1,000 5,800 58,153 26,500 21000 2,543,991 250,379 222.605 3,875 143 17,988 16,841 22,424 16,074 1,042 635 43,267 34,964 8,464 5,334 1,234 - 189,868 92,151 21,325 12,325 4,950 2,708 4,313 1,186 7,027 6,365 3,625 813 44,200 45,221 8,604 5,019 10,225 26,283 3,575 - 3,750 3,979 1,075 2,500 625 - 108 15 250 4,575 1,450 - 14,538 2,850 6,625 1,173 5,250 - 635,998 458,394 (27,774) (3,875) (143) (1,147) (6,351) (407) (8,302) (3,130) (1,234) (97,717) (9,000) (2,242) (3,127) (662) (2,812) 1,021 (3,585) 16,058 (3,575) 229 1,425 (625) (92) 4,325 (1,450) (11,688) (5,452) (5,250) (177,604) 22.23% 0.00% 0.00% 23.41% 17.92% 15.24% 20.20% 15.76% 0.00% 12.13% 14.45% 13.68% 6.87% 22.65% 5.60% 25.58% 14.58% 64.26% 0.00% 26.53% 58.14% 0.00% 3.55% 457.50% 0.00% 4.90% 4.42% 0.00% 18.02% 04 - HUMAN RESOURCES r Annual Budget Prorated Budget Actual Spent Variance % Spent 11 SALARIES 21 FICA 23 PERS 24 INDUSTRIAL INSURANCE 25 MEDICAL,DENTAL,LIFE,OPTICAL 31 OFFICE & OPERATING SUPPLIES 41 PROFESSIONAL SERVICES 43 TRAVEL 44 ADVERTISING 45 OPERATING RENTALS & LEASES 48 REPAIRS & MAINTENANCE 49 MISCELLANEOUS HUMAN RESOURCES " Variance = Actual over (under) prorated budget 10 347,760 25,201 31,151 1,373 56,803 7,103 79,050 2,500 9,000 50 5,405 8,000 86,940 6,300 7,788 343 14,201 1,776 19,763 625 2,250 13 84,775 6,178 6,058 235 14,116 1,047 6,589 2,447 5 1,351 - 2,000 3,118 124,569 Fund 000 By Dept (2,165) (122) (1,730) (109) (85) (729) (13,173) (625) 197 (7) (1,351) 1,118 (18,780) 24.38% 24.52% 19.45% 17.09% 24.85% 14.74% 8.34% 0.00% 27.19% 10.96% 0.00% 38.97% 21.72%, City of Tukwila General Fund Expenditures - By Department As of March 31 2012 05 - FINANCE 11 SALARIES 12 EXTRA LABOR 13 OVERTIME 21 FICA 23 PERS 24 INDUSTRIAL INSURANCE 25 MEDICAL,DENTAL,LIFE,OPTICAL 26 UNEMPLOYMENT COMPENSATION 31 OFFICE & OPERATING SUPPLIES 41 PROFESSIONAL SERVICES 42 COMMUNICATION 43 TRAVEL 46 INSURANCE 48 REPAIRS & MAINTENANCE 49 MISCELLANEOUS 49-00 Miscellaneous 49-08 Credit card fees 64 MACHINERY & EQUIPMENT FINANCE 06 - CITY ATTORNEY 12 EXTRA LABOR 21 FICA 24 INDUSTRIAL INSURANCE 31 OFFICE & OPERATING SUPPLIES 41 PROFESSIONAL SERVICES 41-00 Professional services 41-01 Contracted Attorney services 41-02 Contracted prosecution service 41-03 Special matters 42 COMMUNICATION 45 OPERATING RENTALS & LEASES 48 REPAIRS & MAINTENANCE 49 MISCELLANEOUS CITY ATTORNEY Annual Budget 978,689 10,000 1,147 72,356 87,592 4,118 205,614 24,849 190,000 1,000 5,000 5,000 12,768 1 1.900 859 5,000 Prorated Budget 244,672 2,500 287 18,089 21,898 1,030 51,404 6,212 47,500 250 1,250 1,250 3,192 2,975 217 1,250 % of year expired 25.00% Actual Spent Variance % Spent 213,091 (31,582) 21.77% (2,500) 0.00% 2,665 2,378 232.30% 16,262 (1,827) 22.48% 15,581 (6,317) 17.79% 640 (389) 15.55% 44,379 (7,024) 21.58% - 0.00% 2,195 (4,017) 8.83% 65,481 17,981 34.46% (d) 185 (65) 18.50% 397 (853) 7.94% 807 807 0.00% 352 (898) 7.03% 6,331 3,139 49.58% 4,466 1,491 37.53% (e) 1.886 1,648 214.87% (1,250) 0.00% 1,603,133 400,783 368,366 (32,418) 22.98* Annual Budget 2,500 795 439 5,000 528,000 2,000 324,000 102,000 100,000 2,500 500 2,000 1,000 542,734 Prorated Budget 625 199 110 1,250 132,000 500 81,000 25,500 25,000 625 125 500 250 135,684 Actual Spent Variance % Spent (625) 0.00% (199) 0.00% (110) 0.00% 428 (822) 8.57% 79,831 (52,169) 15.12% 149 (352) 7.43% 51,310 (29,690) 15.84% 21,752 (3,748) 21.33% 6,621 (18,379) 6.62 % (625) 0.00% (125) 0.00% (500) 0.00% 60 (190) 6.02% 80,320 (55,364) 14.80% ** Variance = Actual over (under) prorated budget Fund 000 By Dept 11 12 City of Tukwila General Fund Expenditures - By Department As of March 31 2012 % of year expired 25.00% 07 - RECREATION Annual Budget Prorated Budget Actual Spent Variance % Spent 11 SALARIES 12 EXTRA LABOR 13 OVERTIME 21 FICA 23 PERS 24 INDUSTRIAL INSURANCE 25 MEDICAL,DENTAL,LIFE,OPTICAL 31 OFFICE & OPERATING SUPPLIES 34 ITEMS PURCH. FOR INVENT/RESALE 41 PROFESSIONAL SERVICES 42 COMMUNICATION 43 TRAVEL 44 ADVERTISING 45 OPERATING RENTALS & LEASES 47 PUBLIC UTILITY SERVICES 48 REPAIRS & MAINTENANCE 49 MISCELLANEOUS 49-01 Printing and binding 49-04 Trip admissions Seniors 49-05 Trip admissions Youth 49-08 Special Accomodations other 53 EXT TAXES & OPERATING ASSMNTS RECREATION 1,165,454 296,627 600 130,960 120,980 35,855 247,844 81,188 14,200 200,666 27,380 8,000 21,000 55,861 32,550 90,982 35,000 10,800 12,460 12,390 20.332 291,364 74,157 150 32,740 30,245 8,964 61,961 20,297 3,550 50,167 6,845 2,000 5,250 13,965 8,138 22,746 8,750 2,700 3,115 3,098 5.083 292,351 49,630 25,810 22,730 5,752 59,736 8,940 5,043 13,922 923 292 2,282 9,763 26 14,799 9,231 1,238 890 7,103 12 987 (24,527) (150) (6,930) (7,515) (3,212) (2,225) (11,357) 1,493 (36,245) (5,922) (1,708) (2,968) (4,202) 26 6,662 (13,515) (7,512) (1,810) (3,115) (3,098) 2,020 12 25.08% 16.73% 0.00% 19.71% 18.79% 16.04% 24.10% 11.01% 35.51% 6.94% 3.37% 3.65% 10.87% 17.48% 0.00% 45.47% 10.15% 3.54% 8.24% 0.00% 0.00% 34.93% 0.00% 2,530,147 632,537 521,242 (111,295) 20.60% 08 - COMMUNITY DEVELOPMENT Annual Budget Prorated Budget Actual Spent Variance % Spent 11 SALARIES 12 EXTRA LABOR 13 OVERTIME 21 FICA 23 PERS 24 INDUSTRIAL INSURANCE 25 MEDICAL,DENTAL,LIFE,OPTICAL 28 UNIFORM CLOTHING 31 OFFICE & OPERATING SUPPLIES 35 SMALL TOOLS & MINOR EQUIPMENT 41 PROFESSIONAL SERVICES 42 COMMUNICATION 43 TRAVEL 45 OPERATING RENTALS & LEASES 47 PUBLIC UTILITY SERVICES 48 REPAIRS & MAINTENANCE 49 MISCELLANEOUS 51 INTERGVRNMTL PROFESSIONAL SVCS 64 MACHINERY & EQUIPMENT COMMUNITY DEVELOPMENT 1,783,293 38,650 4,672 133,308 160,852 11,224 275,436 1,805 34,181 600 86,283 4,500 12,500 33,775 1,000 62,190 21,310 18,000 175,000 2,858,579 445,823 9,663 1,168 33,327 40,213 2,806 68,859 451 8,545 150 21,571 1,125 3,125 8,444 250 15,548 5,328 4,500 43,750 714,645 ** Variance = Actual over (under) prorated budget Fund 000 By Dept 452,743 11,633 1,372 35,050 33,600 2,824 67,803 3,030 343 232 8,454 5,491 6,490 629,064 6,920 1,970 204 1,723 (6,613) 18 (1,056) (451) (5,516) (150) (21,228) (1,125) (2,893) 10 (250) (10,056) 1,162 (4,500) (43,750) (85,581) 25.39% 30.10% 29.36% 26.29% 20.89% 25.16% 24.62% 0.00% 8.86% 0.00% 0.40% 0.00% 1.86% 25.03% 0.00% 8.83% 30.46% 0.00% 0.00% 22.01% City of Tukwila General Fund Expenditures - By Department As of March 31 2012 of year expired 25.00% 09 - MUNICIPAL COURT Annual Budget Prorated Budget Actual Spent Variance % Spent 11 SALARIES 12 EXTRA LABOR 13 OVERTIME 21 FICA 23 PERS 24 INDUSTRIAL INSURANCE 25 MEDICAL,DENTAL,LIFE,OPTICAL 31 OFFICE & OPERATING SUPPLIES 35 SMALL TOOLS & MINOR EQUIPMENT 41 PROFESSIONAL SERVICES 49-01 Pro Tern Judge 49-03 Interpreters 49-04 Court Security 42 COMMUNICATION 43 TRAVEL 45 OPERATING RENTALS & LEASES 48 REPAIRS & MAINTENANCE 49 MISCELLANEOUS MUNICIPAL COURT 619,552 2,500 5,016 46,849 59,983 3,432 102,906 10,908 1,200 108,000 13,000 53,000 42,000 5,550 6,215 2,300 19,438 154,888 625 1,254 11,712 14,996 858 25,727 2,727 300 27,000 3,250 13,250 10,500 1,388 1,554 575 4,860 160,082 12,055 11,954 520 24,322 2,895 18,717 1,200 11,040 6,477 1,277 59 235 318 4,736 5,194 (625) (1,254) 343 (3,042) (338) (1,405) 168 (300) (8,283) (2,050) (2,210) (4,023) (111) (1,495) 235 (257) (124) 25.84% 0.00% 0.00% 25.73% 19.93% 15.16% 23.63% 26.54% 0.00% 17.33% 9.23% 20.83% 15.42% 23.00% 0.95% 0.00% 13.81% 24.36% 993,849 248,462 237,168 (11,295) 23.86% 10 - POLICE 11 SALARIES 12 EXTRA LABOR 13 OVERTIME 21 FICA 22 LEOFF 23 PERS 24 INDUSTRIAL INSURANCE 25 MEDICAL, DENTAL,LIFE,OPTICAL 31 OFFICE & OPERATING SUPPLIES 35 SMALL TOOLS & MINOR EQUIPMENT 41 PROFESSIONAL SERVICES 42 COMMUNICATION 43 TRAVEL 44 ADVERTISING 45 OPERATING RENTALS & LEASES 46 INSURANCE 48 REPAIRS & MAINTENANCE 48-00 Repair and maintenance 48-01 800 MHZ radio assessment 49 MISCELLANEOUS 49-00 Miscellaneous 49-03 Explorer post 51 INTERGVRNMTL PROFESSIONAL SVCS 64 MACHINERY & EQUIPMENT Annual Budget 7,209,468 5,000 930,062 544,835 325,645 93,745 137,676 1,642,640 156,428 600 48,175 62,031 23,300 800 908,531 225,080 167,894 109,394 58,500 56,245 54,895 1,350 1,639,555 20,000 Prorated Budget 1,802,367 1,250 232,516 136,209 81,411 23,436 34,419 410,660 39,107 150 12,044 15,508 5,825 200 227,133 56,270 41,974 27,349 14,625 14,061 13,724 338 409,889 5,000 Actual Spent 1,671,346 256,793 146,435 85,878 18,861 25,836 365,542 50,364 5,604 13,522 10,188 212,066 225,000 38,936 34,826 4,110 10,340 10,340 271,315 Variance (131,021) (1,250) 24,277 10,227 4,467 (4,576) (8,583) (45,118) 11,257 (150) (6,440) (1,986) 4,363 (200) (15,066) 168,730 (3,038) 7,477 (10,515) (3,721) (3,384) (338) (138,573) 5,000 % Spent 23.18% 0.00% 27.61% 26.88% 26.37% 20.12% 18.77% 22.25% 32.20% 0.00% 11.63% 21.80% 43.72% 0.00% 23.34% 99.96% (a) 23.19% 31.84% 7.03% 18.38% 18.84% 0.00% 16.55% 0.00% feLME " Variance = Actual over (under) prorated budget Fund 000 By Dept 13 City of Tukwila General Fund Expenditures - By Department As of March 31 2012 of year expired 25.00% 11 - FIRE Annual Budget Prorated Budget Actual Spent Variance % Spent 11 SALARIES 13 OVERTIME 15 HOLIDAY PAY 21 FICA 22 LEOFF 23 PERS 24 INDUSTRIAL INSURANCE 25 MEDICAL,DENTAL,LIFE,OPTICAL 28 UNIFORM CLOTHING 31 OFFICE & OPERATING SUPPLIES 35 SMALL TOOLS & MINOR EQUIPMENT 41 PROFESSIONAL SERVICES 42 COMMUNICATION 43 TRAVEL 45 OPERATING RENTALS & LEASES 46 INSURANCE 47 PUBLIC UTILITY SERVICES 48 REPAIRS & MAINTENANCE 49 MISCELLANEOUS 49-00 Miscellaneous 49-05 Uniform cleaning 49-08 Credit card fees 51 INTERGVRNMTL PROFESSIONAL SVCS FIRE Mr - 6,139,768 416,552 178,248 89,288 264,752 32,766 167,746 1,599,900 1,140 187,080 28,500 65,300 44,670 14,500 489,962 90,000 60,000 41,000 99,601 73,083 26,000 518 285,420 10,308,193 1,534,942 104,138 44,562 22,322 66,188 8,192 41,937 399,975 285 46,770 7,125 16,325 11,168 3,625 122,491 22,500 15,000 10,250 24,900 18,271 6,500 130 71,355 1,543,029 49,641 23,070 74,164 5,563 29,811 338,797 36,401 159 3,544 5,246 26 122,957 90,000 19,291 6,857 6,470 6,339 75 56 101,593 2,574,048 2,456,619 8,087 (54,497) (44,562) 748 7,976 (2,628) (12,125) (61,178) (285) (10,369) (6,966) (12,781) (5,921) (3,599) 466 67,500 4,291 (3,393) (18,431) (11,932) (6,425) (74) 30,238 (117,429) 25.13% (c) 11.92% 0.00% 25.84% 28.01% 16.98% 17.77% 21.18% 0.00% 19.46% 0.56% 5.43% 11.74% 0.18% 25.10% 100.00% (a) 32.15% 16.72% 6.50% 8.67% 0.29% 10.74% 35.59% 23.83% 12 - INFORMATION TECHNOLOGY Annual Budget Prorated Budget Actual Spent Variance % Spent 11 SALARIES 12 EXTRA LABOR 13 OVERTIME 21 FICA 23 PERS 24 INDUSTRIAL INSURANCE 25 MEDICAL,DENTAL,LIFE,OPTICAL 31 OFFICE & OPERATING SUPPLIES 35 SMALL TOOLS & MINOR EQUIPMENT 41 PROFESSIONAL SERVICES 42 COMMUNICATION 43 TRAVEL 45 OPERATING RENTALS & LEASES 48 REPAIRS & MAINTENANCE 49 MISCELLANEOUS 49-00 Miscellaneous 49-01 Software upgrades 49-03 Training 64 MACHINERY & EQUIPMENT INFORMATION TECHNOLOGY 581,079 2,500 44,335 52,041 3,228 135,998 5,766 122,000 1,000 99,000 1,500 1,500 31,500 40,500 35,000 3,000 145,270 625 11,084 13,010 807 34,000 1,442 30,500 250 24,750 375 375 7,875 10,125 8,750 750 142,879 469 10,819 10,388 428 32,219 1,232 4,354 22,348 160 385 1,395 3,468 1,602 1,541 2,500 625 325 (2,391) (625) 469 (265) (2,622) (379) (1,780) (209) (26,146) (250) (2,402) (215) 10 (6,480) (6,657) (7,148) 791 24.59% 0.00% 0.00% 24.40% 19.96% 13.27% 23.69% 21.37% 3.57% (b) 0.00% 22.57% 10.67% 25.66% 4.43% 8.56% 4.58% 51.37% (300) 13.00% 32,000 8,000 8,000 0.00% " Variance = Actual over (under) prorated budget Fund 000 By Dept 14 City of Tukwila General Fund Expenditures - By Department As of March 31 2012 13 - PUBLIC WORKS 11 SALARIES 12 EXTRA LABOR 13 OVERTIME 21 FICA 23 PERS 24 INDUSTRIAL INSURANCE 25 MEDICAL,DENTAL,LIFE,OPTICAL 28 UNIFORM CLOTHING 31 OFFICE & OPERATING SUPPLIES 35 SMALL TOOLS & MINOR EQUIPMENT 41 PROFESSIONAL SERVICES 42 COMMUNICATION 43 TRAVEL 45 OPERATING RENTALS & LEASES 47 PUBLIC UTILITY SERVICES 48 REPAIRS & MAINTENANCE 49 MISCELLANEOUS 49-00 Miscellaneous 49-08 Credit card fees 49-50 Neighborhood revitalization 64 MACHINERY & EQUIPMENT PUBLIC WORKS Annual Budget Prorated Budget 1,912,535 478,134 3,500 4,556 140,874 171,274 28,420 387,934 3,800 99,460 3,750 70,400 7,750 800 177,745 379,449 165,521 21,035 14,035 2,000 5,000 35,000 875 1,139 35,219 42,819 7,105 96,984 950 24,865 938 17,600 1,938 200 44,436 94,862 41,380 5,259 3,509 500 1,250 of year expired 25.00% Actual Spent Variance % Spent 3,613,803 894,701 • 15 - PARK MAINTENANCE 11 SALARIES 12 EXTRA LABOR 13 OVERTIME 21 FICA 23 PERS 24 INDUSTRIAL INSURANCE 25 MEDICAL, DENTAL,LIFE,OPTICAL 28 UNIFORM CLOTHING 31 OFFICE & OPERATING SUPPLIES 35 SMALL TOOLS & MINOR EQUIPMENT 41 PROFESSIONAL SERVICES 43 TRAVEL 45 OPERATING RENTALS & LEASES 47 PUBLIC UTILITY SERVICES 48 REPAIRS & MAINTENANCE 49 MISCELLANEOUS 63 OTHER IMPROVEMENTS PARK MAINTENANCE Annual Budget 411,432 35,020 2,295 31,000 36,844 10,973 72,300 1,425 36,968 1,500 25,000 70,270 149,000 40,000 4,000 7,000 935,027 425,781 (52,352) 22.26% - (875) 0.00% 726 (413) 15.93% 31,751 (3,467) 22.54% 30,606 (12,213) 17.87% 4,344 (2,761) 15.29% 77,212 (19,772) 19.90% (950) 0.00% 23,274 (1,591) 23.40% 516 (421) 13.76% 1,585 (16,015) 2.25% 958 (980) 12.36% 175 (25) 21.88% 38,159 (6,277) 21.47% 76,712 (18,150) 20.22% 26,959 (14,421) 16.29% 4,291 (968) 20.40% 819 (2,689) 5.84% 526 26 26.31% 2,945 1,695 58.91% 12,754 36.44% 755,803 (151,652) T 20.91% Prorated Budget Actual Spent Variance % Spent 102,858 127,444 24,586 30.98% (f) 8,755 (8,755) 0.00% 574 (574) 0.00% 7,750 9,447 1,697 30.47% 9,211 9,132 (79) 24.78% 2,743 2,462 (282) 22.43% 18,075 19,538 1,463 27.02% 356 - (356) 0.00% 9,242 11,552 2,310 31.25% 375 382 7 25.45% 6,250 4,372 (1,878) 17.49% 98 98 0.00% 17,568 17,525 (43) 24.94% 37,250 42,119 4,869 28.27% 10,000 847 (9,153) 2.12% 1,000 629 (371) 15.73% 1,750 1,750 0.00% 233,757 " Variance = Actual over (under) prorated budget Fund 000 By Dept 15 City of Tukwila General Fund Expenditures - By Department As of March 31 2012 % of year expired 25.00% 16 - STREET MAINTENANCE & OPERATION Annual Budget Prorated Budget Actual Spent Variance % Spent 11 SALARIES 776,843 194,211 190,693 (3,518) 24.55% 12 EXTRA LABOR 43,723 10,931 13,288 2,357 30.39% 13 OVERTIME 11,474 2,869 12,983 10,114 113.15% (g) 21 FICA 58,961 14,740 16,654 1,914 28.25% 23 PERS 69,571 17,393 15,847 (1,546) 22.78% 24 INDUSTRIAL INSURANCE 22,944 5,736 5,371 (365) 23.41% 25 MEDICAL,DENTAL,LIFE,OPTICAL 181,879 45,470 43,050 (2,420) 23.67% 28 UNIFORM CLOTHING 2,375 594 279 (315) 11.74% 31 OFFICE & OPERATING SUPPLIES 318,800 79,700 56,590 (23,110) 17.75% (g) 35 SMALL TOOLS & MINOR EQUIPMENT 10,931 2,733 583 (2,150) 5.33% 41 PROFESSIONAL SERVICES 4,000 1,000 640 (360) 16.01% 42 COMMUNICATION 4,300 1,075 297 (778) 6.90% 43 TRAVEL 2,700 675 709 34 26.27% 44 ADVERTISING 1,500 375 (375) 0.00% 45 OPERATING RENTALS & LEASES 381,943 95,486 92,636 (2,850) 24.25% 46 INSURANCE 35,455 8,864 35,455 26,591 100.00% (a) 47 PUBLIC UTILITY SERVICES 716,836 179,209 288,985 109,776 40.31% (h) 48 REPAIRS & MAINTENANCE 27,100 6,775 4,637 (2,138) 17.11% 49 MISCELLANEOUS 5,200 1,300 30 (1,270) 0.58% 53 EXT TAXES & OPERATING ASSMNTS - 14 0.00% STREET MAINTENANCE & OPERATION 2,676,535 669,134 778,741 109,594 29.10% 20 - CONTRIBUTIONS / FUND BALANCE Annual Budget Prorated Budget Actual Spent Variance % Spent 01 TRANSFERS OUT 10,364,752 2,591,188 24,615 (2,566,573) 0.24% 26 UNEMPLOYMENT COMPENSATION 30,000 7,500 4,076 (3,424) 13.59% 46 INSURANCE 200,000 50,000 222,560 172,560 111.28% 49 MISCELLANEOUS 323,000 80,750 97,891 17,141 30.31% 49-00 Miscellaneous 3,000 750 (750) 0.00% 49-01 Repair and demolition (building abatement) 50,000 12,500 (12,500) 0.00% 49-03 Claims and judgments 270,000 67,500 97,891 30,391 36.26% (i) 79 OTHER DEBT 725,000 181,250 181,250 0.00% CONTRIBUTIONS / FUND BALANCE, - } 2,910,688 349,142 ** Variance = Actual over (under) prorated budget Fund 000 By Dept 16 City of Tukwila General Fund Expenditures - By Category As of March 31 2012 of year expired 25.00% TOTALS BY CATEGORY Annual Budget Prorated Budget Actual Spent Variance % Spent TRANSFERS OUT SALARIES AND BENEFITS SUPPLIES PROFESSIONAL SERVICES INTERGOVERNMENTAL CAPITAL EXPENDITURES Grand Totals $ 11,814,752 33,702,558 1,193,673 8,180,993 1,969,475 307,000 $ 57,168,451 $ 2,772,438 8,425,640 298,418 2,045,248 492,369 76,750 $ 24,615 7,891,054 214,730 2,186,797 374,107 12,754 $ (2,747,823) (534,586) (83,689) 141,549 (118,262) (63,996) $ 14,110,863 $ 10,704,057 $ (3,406,806) 0.21% 23.41% 17.99% 26.73% 19.00% 4.15% TOTALS BY CATEGORY -- DETAIL Annual Budget Prorated Budget Actual Spent Variance % Spent 00 MISCELLANEOUS GENERAL GOVERNMT 11 SALARIES 12 EXTRA LABOR 13 OVERTIME 15 HOLIDAY PAY 21 FICA 22 LEOFF 23 PERS 24 INDUSTRIAL INSURANCE 25 MEDICAL,DENTAL,LIFE,OPTICAL 26 UNEMPLOYMENT COMPENSATION 28 UNIFORM CLOTHING 31 OFFICE & OPERATING SUPPLIES 34 ITEMS PURCH. FOR INVENT/RESALE 35 SMALL TOOLS & MINOR EQUIPMENT 41 PROFESSIONAL SERVICES 42 COMMUNICATION 43 TRAVEL 44 ADVERTISING 45 OPERATING RENTALS & LEASES 46 INSURANCE 47 PUBLIC UTILITY SERVICES 48 REPAIRS & MAINTENANCE 49 MISCELLANEOUS 51 INTERGVRNMTL PROFESSIONAL SVCS 53 EXT TAXES & OPERATING ASSMNTS 63 OTHER IMPROVEMENTS 64 MACHINERY & EQUIPMENT Grand Totals $ 11,089,752 23,105,109 455,520 1,376,947 178,248 1,403,989 590,397 1,014,512 434,340 5,102,951 30,000 10,545 1,005,457 14,200 174,016 2,166,844 348,381 121,815 49,550 2,148,245 550,535 1,306,285 596,960 892,378 1,969,475 7,000 300,000 $ 2,772,438 5,776,277 113,880 344,237 44,562 350,997 147,599 253,628 108,585 1,275,738 7,500 2,636 251,364 3,550 43,504 541,711 87,095 30,454 12,388 537,061 137,634 326,571 149,240 223,095 492,369 1,750 75,000 $ 56,443,451 $ 14,110,863 $ 24,615 5,570,600 74,551 324,647 353,653 160,042 197,969 79,362 1,125,875 4,076 279 203,693 5,043 5,994 292,779 58,055 20,608 5,915 508,550 573,822 427,133 101,404 198,530 374,081 27 12,754 $ 10,704,057 " Variance = Actual over (under) prorated budget Fund 000 By Category $ (2,747,823) (205,677) (39,329) (19,590) (44,562) 2,656 12,443 (55,659) (29,223) (149,863) (3,424) (2,357) (47,671) 1,493 (37,510) (248,932) (29,040) (9,846) (6,472) (28,511) 436,188 100,562 (47,836) (24,565) (118,288) 27 (1,750) (62,246) $ (3,406,806) 0.22% 24.11% 16.37% 23.58% 0.00% 25.19% 27.11% 19.51% 18.27% 22.06% 13.59% 2.64% 20.26% 35.51% 3.44% 13.51% 16.66% 16.92% 11.94% 23.67% 104.23% (a) 32.70% (h) 16.99% 22.25% 18.99% 0.00% 0.00% 4.25% 17 City of Tukwila Hotel/Motel Tax Fund 101 - Revenue and Expenditures As of March 31 2012 of year expired 25.00% Prorated Actual Annual Budget Budget Year -To -Date Variance ** 1 % of Annual Budget 2012 llllll� Revenue General Revenue Hotel/Motel Taxes $ 385,401 $ 96,350 $ 102,685 $ 6,335 26.64% Total General Revenue 385,401 96,350 102,685 6,335 26.64% Intergovernmental Revenue 853,000 213,250 22,611 (190,639) 2.65% Q) Miscellaneous Revenue Investment Earnings 1,766 442 61 (381) 3.43% Other Misc Revenue 15,953 3,988 1,270 (2,718) 7.96% Total Miscellaneous Revenue 17,719 4,430 1,331 (3,099) 7.51% Total Revenue 1,256,120 314,030 J 126,627 (187,403) 10.08% Expenditures 11 Salaries 283,378 70,845 70,731 (114) 24.96% 12 Extra Labor 24,000 6,000 3,422 (2,578) 14.26% 13 Overtime 10,110 2,528 3,418 890 33.80% 21 FICA 21,679 5,420 5,874 454 27.10% 22 LEOFF - - - - 0.00% 23 PERS 25,380 6,345 5,624 (721) 22.16% 24 Industrial Insurance 2,033 508 295 (213) 14.53% 25 Medical, Dental, Life, Optical 38,304 9,576 9,936 360 25.94% 31 Office & Operating Supplies 16,000 4,000 7,575 3,575 47.34% 41 Professional Services 223,000 55,750 34,754 (20,996) 15.58% 42 Communication 60,000 15,000 19,393 4,393 32.32% 43 Travel 23,000 5,750 6,000 250 26.09% 44 Advertising 657,000 164,250 203,815 39,565 31.02% (k) 45 Operating Rentals & Leases 49,000 12,250 10,493 (1,757) 21.41% 47 Public Utility Services 1,500 375 428 53 28.56% 48 Repairs & Maintenance 1,000 250 396 146 39.56% 49 Miscellaneous 21,400 5,350 11,589 6,239 54.15% 64 Capital Outlay 10,000 2,500 - (2,500) 0.00% Total Hotel/Motel Tax Fund 1,466,784 366,696 393,741 27,045 26.84% Transfers Out / Indirect cost allocation 96,937 24,234 24,234 (0) 25.00% Total Expenses 1,563,721x c 27,045 26.73% Change in Fund Balance (307,601) (76,900) (291,348) (214,448) 94.72% Beginning Fund Balance 451,952 451,952 787,568 335,616 174.26% Ending Fund Balance $ 144,351 $ 375,052 $ 496,220 $ 121,168 343.76% Cash and investments " Variance = Actual over (under) prorated budget Fund 101 18 $ 453,158 $ 362,277 $ 683,948 $ 960,886 $ 276,938 ci City of Tukwila Street Fund 103 - Revenue and Expenditures As of March 31 2012 % of year expired 25.00% 2012 Prorated Actual % of Annual Annual Budget Budget Year -To -Date Variance "* Budget Revenue Intergovernmental Revenue (MVFT Taxes) $ 232,000 $ 58,000 $ 61 ,425 3,425 26.48% Miscellaneous Revenue Investment Earnings 1,000 250 123 (127) 12.31% Total Miscellaneous Revenue 1,000 250 123 (127) 12.31% Total Revenue 453,000 278,250 61,548 (216,702) I 13.59% Expenditures 11 Salaries 1,304 1,304 0.00% 21 FICA 95 95 0.00% 23 PERS - - 95 95 0.00% 24 Industrial Insurance 3 3 0.00% 25 Medical, Dental, Life, Optical 128 128 0.00% 41 Professional Services 650,000 162,500 - (162,500) 0.00% Total 650,000 162,500 1,626 (160,874) 0.25% Transfers Out / Indirect cost allocation Total Expenses 11,894 2,974 2,974 0 25.00% 661,894 I 165,474 4,599 (160,874) Change in Fund Balance (208,894) Beginning Fund Balance 571,171 112,777 56,949 571,171 903,937 (55,828) -27.26% 332,766 158.26% Ending Fund Balance " Variance = Actual over (under) prorated budget Fund 103 19 City of Tukwila Arterial Street Fund 104 - Revenue and Expenditures As of March 31 2012 % of year expired 25.00% 2012 Annual Budget Prorated Budget Actual Year -To -Date Variance " % of Annual Budget Revenue General Revenue Parking Taxes Real Estate Excise Taxes Total General Revenue Intergovernmental Revenue Miscellaneous Revenue Investment Earnings Contributions/Donations Total Miscellaneous Revenue Transfer In Debt Proceeds Total Revenue Expenditures 11 Salaries 12 Extra Labor 13 Overtime 21 FICA 23 PERS 24 Industrial Insurance 25 Medical, Dental, Life, Optical 31 Office & Operating Supplies 41 Professional Services 45 Operating Rentals & Leases 47 Public Utility Services 48 Repairs & Maintenance 64 Capital Outlay Total Arterial Streets 104 111,257 100,000 211,257 9,941,581 3,820 466,000 469,820 2,000,000 9,230,000 27,814 25,000 52,814 2,485,395 955 116,500 117,455 500,000 2,307,500 33,341 9,602 42,943 1,717,081 1,437 13,347 14,784 5,527 (15,398) (9,871) (768,315) 482 (103,153) (102,671) (500,000) (2,307,500) 21,852,658 5,463,165 1,774,808 (3,688,356) Transfers Out / Indirect cost allocation Total Expenses Change in Fund Balance Beginning Fund Balance Ending Fund Balance Cash and investments I 207,768 3,000 15,417 18,606 686 27,727 4,589,000 11,221,000 16,083,204 386,563 5,382,891 4,789,469 $ 10,172,360 51,942 750 3,854 4,652 172 6,932 1,147,250 2,805,250 4,020,801 96,641 1,345,723 4,789,469 99,758 1,567 7,597 7,346 610 15,507 340 274,871 333 750 90,645 1,225,517 1,725,089 96,641 1,821,729 (46,921) 6,929.396 47,816 (750) 1,567 3,742 2,695 439 8,575 340 (872,379) 333 750 90,645 (1,579,733) (2,295,712) (0) (2,295,712) (1,392,644) 2,139,927 $ 6,135,192 $ 6,882,475 $ 747,283 " Variance = Actual over (under) prorated budget Fund 104 20 $ 4,595,453 29.97% 9.60% 20.33% 17.27% 37.61% 2.86% 3.15% 0.00% 0.00% 48.01% (I) 0.00% 0.00% 49.27% 39.48% 88.97% 55.93% 0.00% 5.99% (m) 0.00% 0.00% 0.00% 10.92% (m) 10.73% 25.00% -0.87% 144.68% City of Tukwila Contingency Fund 105 - Revenue and Expenditures As of March 31 2012 % of year expired 25.00% 2012 Prorated Actual Annual Budget Budget Year -To -Date Variance ** % of Annual Budget Revenue Miscellaneous Revenue Investment Earnings $ 1,816 $ 454 $ 201 $ (253) 11.09% Total Miscellaneous Revenue 1,816 454 201 (253) 11.09% Transfers In 3,000,000 750,000 - (750,000) 0.00% Total Revenue 3,001,816 750,454 201 (750,253) 0.01% Change in Fund Balance 3,001,816 750,454 201 (750,253) 0.01% Beginning Fund Balance 1,293,816 1,293,816 1,457,728 163,912 112.67% Ending Fund Balance $ 4,295,632 $ 2,044,270 $ 1,457,929 $ (586,341) 33.94% Cash and investments $ 1,457,930 " Variance = Actual over (under) prorated budget Fund 105 21 City of Tukwila Fire Equipment Cum. Reserve 107 - Revenue and Expenditures As of March 31 2012 % of year expired 25.00% 2012 Prorated Actual % of Annual Annual Budget Budget Year -To -Date Variance ** Budget Revenue Miscellaneous Revenue Investment Earnings $ 1,685 $ 421 $ 131 $ (291) 7.76% Total Miscellaneous Revenue 1,685 421 146 (276) 8.65% Transfers In 130,000 32,500 (32,500) 0.00% Total Revenue 131,685 32,921 146 (32,776) 0.11% Expenditures 31 Office & Operating Supplies 2,000 500 6,393 5,893 Transfers Out / Indirect cost allocation 561 140 140 Total Expenses 2,561 640 6,533 5,893 319.63% 25.00% 255.09% Change in Fund Balance 129,124 32,281 (6,387) (38,668) Beginning Fund Balance 769,671 769,671 890,797 121,126 Ending Fund Balance $ 898,795 $ 801,952 $ 884,410 $ 82,458 Cash and investments $ 943,501 ** Variance = Actual over (under) prorated budget Fund 107 22 -4.95% 115.74% 98.40% City of Tukwila Drug Seizure Fund 109 - Revenue and Expenditures As of March 31 2012 % of year expired 25.00% 2012 Prorated Actual % of Annual Annual Budget Budget Year -To -Date Variance ** Budget Revenue Miscellaneous Revenue Investment Earnings $ 1,000 $ 250 $ - $ (250) 0.00% Seizure Revenue 20,000 5,000 - (5,000) -% Total Miscellaneous Revenue 21,000 5,250 (5,250) 0.00% Transfers In 75,000 18,750 - (18,750) 0.00% Total Revenue 96,000 24,000 (24,000) 0.00% Expenditures 31 Office & Operating Supplies 3,000 750 - (750) 0.00% 35 Small Tools & Minor Equipment - 1,639 1,639 0.00% 41 Professional Services 10,000 2,500 (2,500) 0.00% 45 Operating Rentals & Leases 10,000 2,500 (2,500) 0.00% 49 Miscellaneous 2,000 500 - (500) 0.00% 64 Capital Outlay - 1,610 1,610 - Total Expenses 25,000 6,250 3,249 (3,001) 13.00% Change in Fund Balance Beginning Fund Balance Ending Fund Balance Cash and investments 71,000 17,750 (3,249) (20,999) -4.58% 112,000 112,000 229,711 117,711 205.10% $ 183,000 $ 129,750 $ 226,462 $ 96,712 123.75% ** Variance = Actual over (under) prorated budget Fund 109 $ 226,462 23 City of Tukwila Debt Service Funds 2XX - Revenue and Expenditures As of March 31 2012 % of year expired 25.00% 2012 Prorated Actual Annual Budget Budget Year -To -Date Variance ** of Annual Budget Revenue Intergovernmental Revenue 66,657 16,664 - (66,657) 0.00% Miscellaneous Revenue Investment Earnings $ 3,000 $ 750 $ $ (3,000) 0.00% Total Miscellaneous Revenue 3,000 750 (3,000) 0.00% Transfers In 2,958,752 739,688 (739,688) 0.00% Total Revenue 3,028,409 757,102 (809,345) Expenditures 80 Debt Service Principal 1,874,707 468,677 (468,677) 0.00% 81 Debt Service Interest 1,104,038 276,010 1,560 (274,449) 0.14% Total Debt Service Funds 2,978,745 744,686 1,560 (743,126) 0.05% Transfers Out / Indirect cost allocation 340,642 85,161 (85,161) 0.00% Total Expenses 3,319,387 829,847 1,560 (828,286) Change in Fund Balance (290,978) (72,745) (1,560) 71,184 0.54% Beginning Fund Balance 3,316,312 3,316,312 0.00% Ending Fund Balance $ (290,978) $ (72,745) $ 3,314,752 $ 3,387,496 -1139.18% Cash and investments $ 3,314,751 " Variance = Actual over (under) prorated budget Fund 2XX 24 City of Tukwila Open Space and Parks Acq. Fund 301 - Revenue and Expenditures As of March 31 2012 % of year expired 25.00% 2012 Prorated Actual Annual Budget Budget Year -To -Date Variance ** % of Annual Budget Revenue General Revenue Property Taxes $ 65,000 $ 16,250 $ 826 $ (15,424) Real Estate Excise Taxes 100,250 25,063 9,642 (15,421) Total General Revenue 165,250 41,313 10,468 (30,845) Charges for Services Park Impact Fees 25,000 6,250 3,560 (2,690) Total Charges for Services 25,000 6,250 3,560 (2,690) Intergovernmental Revenue 500,000 125,000 (125,000) Miscellaneous Revenue Investment Earnings Rents and Concessions Total Miscellaneous Revenue 7,000 1,750 7,238 5,488 5.000 1 ,250 2,000 750 12,000 3,000 9,238 6,238 1.27% 9.62% 6.33% 14.24% 14.24% 0.00% 103.40% 40.00% 76.98% Total Revenue 702,250 0 175,563 0 23,266 0 (152,296) 3.31% Expenditures 11 Salaries 2,504 2,504 0.00% 21 FICA - 186 186 0.00% 23 PERS - - 182 182 0.00% 24 Industrial Insurance - - 7 7 0.00% 25 Medical, Dental, Life, Optical 575 575 0.00% 41 Professional Services 239,000 59,750 6,088 (53,662) 2.55% 48 Repairs & Maintenance - 2,581 2,581 0.00% 64 Capital Outlay 1,810,000 452,500 640 (451,860) 0.04% Total Park Acquisition Fund 2,049,000 512,250 12,762 (499,488) 0.62% Transfers Out / Indirect cost allocation Total Expenses Change in Fund Balance Beginning Fund Balance Ending Fund Balance Cash and investments 100,653 275,163 8,004 (267,159) 7.95% 2,149,653 787,413 20,766 (766,647) (1,447,403) (611,851) 2,500 614,351 3,993,522 3,993,522 1,427,973 (2,565,549) -0.17% 35.76% $ 2,546,119 $ 3,381,671 $ ' 1,430,473 $ (1,951,198) " Variance = Actual over (under) prorated budget Fund 301 $ 1,665,327 25 City of Tukwila Facility Replacement Fund 302 - Revenue and Expenditures As of March 31 2012 % of year expired 25.00% 2012 Prorated Actual Annual Budget Budget Year -To -Date Variance ** % of Annual Budget Revenue Charges for Services Sales and Use Taxes Total Charges for Services 326 $ 82 $ 25 $ (56) 7.82% 326 82 25 (56) 7.82% Miscellaneous Revenue Investment Earnings 5,602 1,401 279 (1,121) 4.99% Facilities leases (long-term) - - - - 0.00% Total Miscellaneous Revenue 5,602 1,401 279 (1,121) 4.99% Total Revenue Expenditures 11 Salaries 21 FICA 23 PERS 24 Industrial Insurance 31 Office & Operating Supplies 41 Professional Services 44 Advertising 47 Public Utility Services 49 Miscellaneous Total Expenditures Transfers Out I Indirect cost allocation Total Expenses SAW 8,220 (13,812) Change in Fund Balance (82,199) (20,550) (7,915) 12,635 Beginning Fund Balance 1,880,193 1,880,193 2,027,014 146,821 Ending Fund Balance $ 1,797,994 $ 1,859,643 $ 2,019,099 $ 159,456 Cash and investments 5,928 1,482 305 , . , . 5.14%, 14,000 3,500 112 112 0.00% 8 8 0.00% 8 8 0.00% 0 0 0.00% 0.00% 5,125 1,625 36.61% 0.00% 2,684 2,684 0.00% 0.00% 87,000 21,750 7,938 (13,812) 9.12% 1,127 282 282 0 25.00% ** Variance = Actual over (under) prorated budget Fund 302 26 $ 2,019.099 9.63% 107.81% City of Tukwila General Government Improvements 303 - Revenue and Expenditures As of March 31 2012 % of year expired 25.00% 2012 Prorated Actual % of Annual Annual Budget Budget Year -To -Date Variance ** Budget Revenue Intergovernmental Revenue $ 58,077 $ 14.519 $ 56,618 $ 42,098 97.49% Miscellaneous Revenue Investment Earnings 842 211 79 (131) 9.42% Total Miscellaneous Revenue 842 211 79 (131) 9.42% Transfers In 1,650,000 412,500 (412,500) 0.00% Total Revenue 1,708,919 427,230 56,697 (370,533) 3.32% Expenditures 11 Salaries 97,296 24,324 4,490 (19,834) 4.61% 13 Overtime - - 0.00% 21 FICA 7,819 1,955 340 (1,615) 4.35% 23 PERS 8,800 2,200 325 (1,875) 3.70% 24 Industrial Insurance 1,100 275 4 (271) 0.33% 25 Medical, Dental, Life, Optical 14,798 3,700 515 (3,185) 3.48% 31 Office & Operating Supplies 363 363 0.00% 35 Small Tools & Minor Equipment 2,240 2,240 0.00% 41 Professional Services 440,000 110,000 7,048 (102,953) 1.60% 42 Communication - 0.00% 49 Miscellaneous 2,734 2,734 0.00% 64 Capital Outlay 1,860,000 465,000 (1,783) (466,783) -0.10% Total Fire Impact Fees 2,429,813 607,453 25,531 (581,922) 1.05% Transfers Out / Indirect cost allocation Total Expenses Change in Fund Balance Beginning Fund Balance Ending Fund Balance Cash and investments 26,673 6,668 6,668 2,456,486 614,122 32,200 (581,922) (747,567) (186,892) 24,497 211,389 291,987 291,987 608,613 316,626 25.00% 1.31% -3.28% 208.44% $ (455,580) $ 105,095 $ 633,110 $ 528,015 -138.97% ** Variance = Actual over (under) prorated budget Fund 303 $ 584,287 27 City of Tukwila Fire Impact Fees 304 - Revenue and Expenditures As of March 31 2012 of year expired 25.00% 2012 Prorated Actual Annual Budget Budget Year -To -Date Variance " °/0 of Annual Budget Revenue Charges for Services Fire Impact Fees $ 50,000 $ 12,500 $ 2,772 $ (9,728) 5.54% Total Charges for Services 50,000 12,500 2,772 (9,728) 5.54% Investment Earnings 100 25 - (25) 0.00% Total Miscellaneous Revenue 100 25 - (25) 0.00% Total Revenue 50,100 12,525 2,772 (9,753) 5.53% Expenditures 64 Capital Outlay Total Expenses 0.00% 0.00% Change in Fund Balance 50,100 12,525 2,772 Beginning Fund Balance 190,100 190,100 313,819 Ending Fund Balance $ 240,200 $ 202,625 $ 316,591 $ 113,966 Cash and investments $ 316,591 (9,753) 5.53% 123,719 165.08% " Variance = Actual over (under) prorated budget Fund 304 28 131.80% City of Tukwila Water Fund 401 - Revenue and Expenditures As of March 31 2012 % of year expired 25.00% MIL 2012 Annual Budget Prorated Actual Budget Year -To -Date Variance "" % of Annual Budget Revenue Charges for Services Water Sales $ 5,041,000 $ 1,260,250 $ 1,005,960 $ (254,290) 19.96% Security 1,000 250 45 (205) 4.50% Total Charges for Services 5,042,000 1,260,500 1,006,005 (254,495) 19.95% Miscellaneous Revenue Investment Earnings 9,234 2,309 4,526 2,218 49.02% Connection fees 25,000 6,250 200 (6,050) 0.80% Other Misc Revenue 300 75 40 (35) 13.33% Total Miscellaneous Revenue 34,534 8,634 4,766 (3,867) 13.80% Transfers In hydrant rental Total Revenue Expenditures 11 Salaries 12 Extra Labor 106,000 26,500 24,615 (1,885) 23.22% 5,182,534 1,295,634 1,035,386 (260,248) 556,692 139,173 135,224 (3,949) 24.29% 6,000 1,500 - (1,500) 0.00% 13 Overtime 5,738 1,435 2,639 1,204 45.99% 21 FICA 42,472 10,618 10,472 (146) 24.66% 23 PERS 49,851 12,463 9,955 (2,508) 19.97% 24 Industrial Insurance 14,137 3,534 2,752 (782) 19.47% 25 Medical, Dental, Life, Optical 113,690 28,423 30,303 1,881 26.65% 26 Unemployment Compensation 1,000 250 (250) 0.00% 28 Uniform Clothing 1,330 333 (333) 0.00% 31 Office & Operating Supplies 93,181 23,295 22,215 (1,080) 23.84% 33 Water Purchased for Resale 2,068,000 517,000 660,689 143,689 31.95% (n) 35 Small Tools & Minor Equipment 9,500 2,375 - (2,375) 0.00% 41 Professional Services 314,300 78,575 16,142 (62,433) 5.14% 42 Communication 2,500 625 177 (448) 7.08% 43 Travel 1,500 375 (375) 0.00% 45 Operating Rentals & Leases 60,919 15,230 14,855 (375) 24.38% 46 Insurance 20,260 5,065 20,260 15,195 100.00% 47 Public Utility Services 23,000 5,750 3,283 (2,467) 14.27% 48 Repairs & Maintenance 3,000 750 1,314 564 43.79% 49 Miscellaneous 14,811 3,703 10,547 6,844 71.21% 53 Excise Taxes 184,000 46,000 33,868 (12,132) 18.41% 54 Interfund utility taxes 517,000 129,250 100,688 (28,562) 19.48% 64 Capital Outlay 1,287,000 321,750 10,330 (311,420) 0.80% 80 Debt Service Principal 128,881 32,220 310,000 277,780 240.53% 81 Debt Service Interest 35,616 8,904 45,632 36,728 128.12% Total Water Fund 5,554,378 1,388,595 1,441,343 52,749 25.95% Transfers Out / Indirect cost allocation 517,377 129,344 129,344 25.00% Total Expenses 6,071,755 1,517,939 1,570,688 52,749_ 25.87% Change in Fund Balance Beginning Fund Balance (889,221) (222,305) (535,302) (312,997) 60.20% 1,959,365 1,959,365 4,787,053 2,827,688 244.32% Ending Fund Balance $ 1,070,144 $ 1,737,060 $ 4,251,751 $ 2,514,691 Cash and investments $ 4,009,633 *" Variance = Actual over (under) prorated budget Fund 401 29 City of Tukwila Sewer Fund 402 - Revenue and Expenditures As of March 31 2012 of year expired 25.00% 2012 Annual Budget Prorated Budget Actual Year -To -Date Variance ** % of Annual Budget Revenue Charges for Services Sewer Sales Total Charges for Services Intergovernmental Revenue Miscellaneous Revenue Investment Earnings Connection fees Total Miscellaneous Revenue $ 5,398,000 $ 1,349,500 $ 1,543,012 $ 193,512 28.58% 5,398,000 1,349,500 1,543,012 193,512 28.58% 17,524 17,524 0.00% 4,426 1,107 458 (649) 10.35% 120,000 30,000 34,200 4,200 28.50% 124,426 31,107 34,658 3,551 27.85% Total Revenue 5,522,426 1,380,607 1,595,194 214,588 28.89% Expenditures 11 Salaries 12 Extra Labor 13 Overtime 21 FICA 23 PERS 24 Industrial Insurance 25 Medical, Dental, Life, Optical 26 Unemployment Compensation 28 Uniform Clothing 31 Office & Operating Supplies 33 Metro Sewage Treatment 35 Small Tools & Minor Equipment 41 Professional Services 42 Communication 43 Travel 44 Advertising 45 Operating Rentals & Leases 46 Insurance 47 Public Utility Services 48 Repairs & Maintenance 49 Miscellaneous 53 Excise Taxes 54 Interfund utility tax 64 Capital Outlay 80 Debt Service Principal 81 Debt Service Interest Total Sewer Fund Transfers Out/Indirect cost allocation Total Expenses Change in Fund Balance Beginning Fund Balance Ending Fund Balance Cash and investments 267,360 8,000 3,442 20,338 23,943 6,156 50,356 1,000 570 22,491 3,749,000 4,000 161,600 2,500 500 150 124,415 15,195 22,050 43,000 8,799 40,000 543,000 770,000 272,861 83,337 66,840 84,910 18,070 31.76% (o) 2,000 - (2,000) 0.00% 861 751 (109) 21.83% 5,085 6,193 1,108 30.45% 5,986 5,910 (76) 24.68% 1,539 1,213 (326) 19.71% 12,589 15,684 3,095 31.15% 250 - (250) 0.00% 143 - (143) 0.00% 5,623 5,501 (122) 24.46% 937,250 813,658 (123,592) 21.70% 1,000 178 (822) 4.44% 40,400 7,785 (32,615) 4.82% 625 411 (214) 16.43% 125 - (125) 0.00% 38 - (38) 0.00% 31,104 30,604 (500) 24.60% 3,799 15,195 11,396 100.00% (a) 5,513 5,132 (381) 23.27% 10,750 2,542 (8,208) 5.91% 2,200 9,011 6,811 102.41% 10,000 15,430 5,430 38.58% 135,750 154,332 18,582 28.42% 192,500 120,801 (71,699) 15.69% 68,215 - (68,215) 0.00% 20,834 188 (20,646) 0.23% 6,244,063 1,561,016 1,295,427 (265,589) 20.75% 446,980 6,691,043 (1,168,617) 1,158,774 111,745 1,672,761 (292,154) 1,158, 774 111,745 (0) 25.00% 1,407,172 (265,589) 21.03% 188,022 480,176 -16.09% 1,890,166 731,392 163.12% $ (9,843) $ 866,620 $ 2,078,188 $ 1,211,568 -21113.36% ** Variance = Actual over (under) prorated budget Fund 402 30 $ 1,203,983 City of Tukwila Foster Golf Course 411- Revenue and Expenditures As of March 31 2012 % of year expired 25.00% 2012 Annual Budget Actual Prorated Budget Year -To -Date Variance ** % of Annual Budget Revenue General Revenue Excise Taxes $ 1,617 $ 404 $ 744 $ 339 45.99% Total General Revenue 1,617 404 744 339 45.99% Charges for Services Sale of Merchandise 151,000 37,750 17,483 (20,267) 11.58% Greens Fees, Instruction 1,205,500 301,375 73,037 (228,338) 6.06% Total Charges for Services 1,356,500 339,125 90,520 (248,605) 6.67% (p) Miscellaneous Revenue Investment Earnings 1,130 283 - (283) 0.00% Rents and Concessions 331,000 82,750 27,960 (54,790) 8.45% Other Misc Revenue - - (81) (81) 0.00% Total Miscellaneous Revenue 332,130 83,033 27,879 (55,153) 8.39% (p) Transfers In 225,000 56,250 (56,250) 0.00% Total Revenue Expenditures 11 Salaries 12 Extra Labor 13 Overtime 21 FICA 23 PERS 24 Industrial Insurance 25 Medical, Dental, Life, Optical 26 Unemployment Compensation 28 Uniform Clothing 31 Office & Operating Supplies 34 Items Purchased for Resale 35 Small Tools & Minor Equipment 41 Professional Services 42 Communication 43 Travel 44 Advertising 45 Operating Rentals & Leases 46 Insurance 47 Public Utility Services 48 Repairs & Maintenance 49 Miscellaneous 53 Excise Taxes 54 Interfund admissions tax 64 Capital Outlay 80 Debt Service Principal 81 Debt Service Interest Total Foster Golf Course Fund 1,915,247 IMIMEIME 119,143 (359,669) 686,142 171,536 152,914 (18,622) 22.29% 133,900 33,475 3,467 (30,008) 2.59% 6,885 1,721 - (1,721) 0.00% 51,306 12,827 11,710 (1,116) 22.82% 61,449 15,362 11,064 (4,298) 18.00% 15,565 3,891 2,206 (1,686) 14.17% 123,977 30,994 26,420 (4,574) 21.31% 11,000 2,750 - (2,750) 0.00% 1,164 291 - (291) 0.00% 98,908 24,727 8,385 (16,342) 8.48% 130,500 32,625 6,316 (26,309) 4.84% 2,500 625 876 251 35.04% 10,000 2,500 1,500 (1,000) 15.00% 9,700 2,425 723 (1,702) 7.45% 1,250 313 127 (185) 10.19% 7,000 1,750 614 (1,136) 8.77% 101,650 25,413 24,385 (1,027) 23.99% 15,195 3,799 15,195 11,396 100.00% (a) 64,765 16,191 20,283 4,092 31.32% (h) 36,000 9,000 6,705 (2,295) 18.62% 39,722 9,931 3,445 (6,485) 8.67% 6,000 1,500 242 (1,258) 4.03% 67,000 16,750 4,123 (12,627) 6.15% 25,000 6,250 - (6,250) 0.00% 212,959 53,240 (53,240) 0.00% 138,064 34,516 (34,516) 0.00% 2,057,601 514,400 300,698 (213,702) 14.61% Transfers Out / Indirect cost allocation 15,160 3,790 3.790 (0) 25.00% Total Expenses 2,072,761 1 518,190 304,488 (213,702) 14 Change in Fund Balance (157,514) (39,379) (185,345) (145,967) 117.67% Beginning Fund Balance 52,831 52,831 200116 147,285 378.79% Ending Fund Balance $ (104,683) KM 13,453 $ 14,771 $ 1,318 Cash and investments $ (143.262) ** Variance = Actual over (under) prorated budget Fund 411 31 City of Tukwila Surface Water Fund 412 - Revenue and Expenditures As of March 31 2012 of year expired 25.00% • 2012 ' Prorated Actual Annual Budget Budget Year -To -Date Variance ** of Annual Budget Revenue Charges for Services Surface Water Sales Total Charges for Services $ 3,660,309 $ 915,077 $ 1,825,469 $ 910,391 49.87% 3,660,309 915,077 1,825,469 910,391 49.87% Intergovernmental Revenue 44,000 Miscellaneous Revenue Investment Earnings Other Misc Revenue Total Miscellaneous Revenue 11,000 (11,000) 0.00% 11,091 2,773 4,185 120 11,091 2,773 4,305 1,413 120 1,533 37.74% 0.00% 38.82% Total Revenue - 3,715,400 928,850 1,829,774 Expenditures 11 Salaries 12 Extra Labor 13 Overtime 21 FICA 23 PERS 24 Industrial Insurance 25 Medical, Dental, Life, Optical 26 Unemployment Compensation 28 Uniform Clothing 31 Office & Operating Supplies 35 Small Tools & Minor Equipment 41 Professional Services 42 Communication 43 Travel 44 Advertising 45 Operating Rentals & Leases 46 Insurance 47 Public Utility Services 48 Repairs & Maintenance 49 Miscellaneous 53 Excise Taxes 54 Interfund utility tax 64 Capital Outlay 80 Debt Service Principal 81 Debt Service Interest Total Surface Water Fund Transfers Out Total Expenses Change in Fund Balance Beginning Fund Balance 721,168 180,292 169,049 (11, 243) 23.44% 23,000 5,750 (5,750) 0.00% 11,653 2,913 5,745 2,832 49.30% 54,463 13,616 13,208 (407) 24.25% 64,589 16,147 12,646 (3,501) 19.58% 17,301 4,325 2,688 (1,637) 15.54% 167,666 41,917 35,965 (5,951) 21.45% 1,000 250 - (250) 0.00% 1,425 356 - (356) 0.00% 42,521 10,630 6,245 (4,385) 14.69% 3,000 750 279 (471) 9.30% 628,570 157,143 56,351 (100,791) 8.96% 2,000 500 - (500) 0.00% 2,000 500 115 (385) 5.77% 500 125 - (125) 0.00% 96,638 24,160 20,233 (3,926) 20.94% 15,195 3,799 15,195 11,396 100.00% 61,600 15,400 41,942 26,542 68.09% 13,965 3,491 1,338 (2,153) 9.58% 8,685 2,171 11,143 8,972 128.30% 25,000 6,250 12,733 6,483 50.93% 371,000 92,750 182,929 90,179 49.31% 1,510,000 377,500 - (377,500) 0.00% 286,554 71,639 - (71,639) 0.00% 30,514 7,629 36 (7,592) 0.12% 4,160,007 1,040,002 587,842 (452,160) 14.13% 400,786 100,197 100,196 (0) 25.00% 4,560,793 1,140,198 I 688,039 (452,160) 15.09% (845,393) (211,348) 1,141,735 1,353,084 135.05% 937,263 937,263 2,151,149 1,213,886 229.51% Ending Fund Balance $ ] 91,870 $ 725,915 $ 3,292,884 $ 2,566,970 3584.29% Cash and investments $ 3,126,965 " Variance = Actual over (under) prorated budget Fund 412 32 City of Tukwila Equipment Rental/Replacement Fund 501 - Revenue and Expenditures As of March 31 2012 % of year expired 25.00% 2012 Annual Budget Prorated Budget Actual Year -To -Date Variance *0 % of Annual Budget Revenue Charges for Services ERR O&M Dept Charges Equipment Replacement Charges Fuel Sales Transportation Total Charges for Services Miscellaneous Revenue Investment Earnings Total Miscellaneous Revenue Sale of Capital Assets $ 1,099,806 777,801 474,000 150 2,351,757 14,269 14,269 $ 274,952 194,450 118,500 38 587,939 3,567 3,567 $ 274,952 $ 179,363 118,500 572,815 13,453 Total Revenue 2,366,026 591,507 Expenditures 11 Salaries 12 Extra Labor 13 Overtime 21 FICA 23 PERS 24 Industrial Insurance 25 Medical, Dental, Life, Optical 26 Unemployment Compensation 28 Uniform Clothing 31 Office & Operating Supplies 34 Items Purchased for Resale 35 Small Tools & Minor Equipment 41 Professional Services 42 Communication 43 Travel 45 Operating Rentals & Leases 46 Insurance 48 Repairs & Maintenance 49 Miscellaneous 64 Capital Outlay Total Equipment Rental Fund Transfers Out Total Expenses Change in Fund Balance Beginning Fund Balance Ending Fund Balance Cash and investments 352,844 10,000 1,147 26,814 31,601 9,976 82,161 1,000 950 2,979 689,000 2,500 550 2,000 37,399 10,130 130,781 6,500 322,000 1,720,332 88,211 2,500 287 6,704 7,900 2,494 20,540 250 238 745 172,250 625 138 500 9,350 2,533 32,695 1,625 80,500 430,083 309,667 77,417 507,500 13,453 8,607 (15,087) (38) (15,125) 9,886 9,886 8,607 25.00% 23.06% 25.00% 0.00% 24.36% 94.28% 94.28% 0.00% 594,875 - 25.14% 87,957 2,880 1,548 7,041 6,698 2,182 19,465 626 122,442 53 696 305 144 9,255 10,130 17,250 2,190 85,851 376,712 77,417 454,129 (254) 380 1,261 337 (1,202) (312) (1,075) (250) (238) (119) (49,808) (572) 558 (195) 144 (95) 7,598 (15,445) 565 5,351 (53,371) (0) (53,371) 24.93% 28.80% 134.93% 26.26% 21.20% 21.88% 23.69% 0.00% 0.00% 21.00% 17.77% 2.12% 126.54% 15.23% 0.00% 24.75% 100.00% 13.19% 33.69% 26.66% 21.90% 25.00% 336,027 84,007 140,745 56,739 41.89% 3,410,129 3,410,129 3,513,202 103,073 103.02% $ 3,746,156 $ 3,494,136 $ • 3,653,947 $ -WIN2 ,IM " Variance = Actual over (under) prorated budget Fund 501 $ 3,652,343 33 City of Tukwila Insurance Fund 502 - Revenue and Expenditures As of March 31 2012 of year expired 25.00% 2012 Annual Budget Prorated Budget Actual Year -To -Date Variance ** % of Annual Budget Revenue Charges for Services Employee Benefit Programs Total Charges for Services Miscellaneous Revenue Investment Earnings Employer Trust Contributions Employee Contributions Other Misc Revenue Total Miscellaneous Revenue 621 $ 621 10,032 4,367,715 60,000 6,200 4,443,947 155 $ 155 2,508 1,091,929 15,000 1,550 1,110,987 254 $ 254 48,127 1,070,776 18,737 1,137,640 99 99 45,619 (21,153) 3,737 (1,550) 26,653 40.89% 40.89% 479.73% 24.52% 31.23% 0.00% 25.60% Total Revenue 4,444,568 1,111,142 1,137,894 26,752 25.60% Expenditures 25 Medical, Dental, Life, Optical 41 Professional Services 49 Miscellaneous Total Transfers Out / Indirect cost allocation Total Expenses Change in Fund Balance Beginning Fund Balance Ending Fund Balance Cash and investments 4,400,000 25,000 20,500 4,445,500 80,305 4,525,805 (81,237) 4,431,820 1,100,000 6,250 5,125 1,111,375 20,076 1,131,451 (20,309) 4,431,820 788,280 3,688 1,910 793,878 20,076 813,954 323,939 4,983,480 (311,720) (2,562) (3,215) (317,497) (0) 17.92% 14.75% 9.32% 17.86% 25.00% (317,497) 17.98% 344,248 551,660 -398.76% 112.45% $ 4,350,583 4,411,511 $ 5,307,419 $ 895,908 121.99% " Variance = Actual over (under) prorated budget Fund 502 34 $ 6,479,031 City of Tukwila LEOFF Insurance Fund 503 - Revenue and Expenditures As of March 31 2012 % of year expired 25.00% 2012 Annual Budget Prorated Budget Actual Year -To -Date Variance ** % of Annual Budget Revenue Miscellaneous Revenue Investment Earnings Employer Trust Contributions Other Misc Revenue Expenditures 25 Medical, Dental, Life, Optical 41 Professional Services 49 Miscellaneous Total Transfers Out Total Expenses $ 3,340 575,000 700 579,040 659,530 3,000 10,000 672,530 4,619 $ 835 143,750 175 144,760 164,883 750 2,500 168,133 1,155 $ 256 118,306 118,562 49,880 340 670 50,890 1,155 $ (579) 7.67% (25,444) 20.57% (175) 0.00% (115,002) (410) (1,830) 677,149 169,287 52,045 Change in Fund Balance Beginning Fund Balance (98,109) 1,246,806 (24,527) 1,246,806 66,517 1,628,986 7.56% 11.33% 6.70% (117,242) 7.57% 0 25.00% (117,242) Y.61118‘ 91,044 -67.80% 382,180 130.65% Ending Fund Balance $ 1,148,697 $ 1,222,279 1,695,503 $ 473,224 147.60% Cash and investments " Variance = Actual over (under) prorated budget Fund 503 $ 1,888,703 35