Loading...
LTC 036-2007 Analysis of Budget to Preliminary Actual Revenues & Expenses for the FY ending 9/30/06 for General, Enterprise and Internal Service Funds & ..... /'v\IAtv\1 BEACH RECEIVED 2007fEB -9 AI1/1: 24 cITy CLEHl'I'S OFF ICE OFFICE OF THE CITY MANAGER NO. LTC # 036-2007 LETTER TO COMMISSION TO: Mayor David Dermer and Members of the City Commission FROM: Jorge M. Gonzalez, City Manager ~~ DATE: February 8, 2007 () ~ 0 SUBJECT: ANALYSIS OF BUDGET TO PRELIMINARY ACTUAL REVENUES AND EXPENSES FOR THE FISCAL YEAR ENDING SEPTEMBER 30, 2006, FOR GENERAL, ENTERPRISE, AND INTERNAL SERVICE FUNDS. The Purpose of this LTC is to provide the preliminary actual revenue and expenses for the Fiscal Year ending September 30, 2006. The year-end budget to preliminary actual comparisons for General, Enterprise, and Internal Service Funds are presented in the following pages. It shows that overall, there will be an operating budget surplus of $5,618,159 (2.7%) in the General Fund. I recommend this surplus be used as follows: (1) allocate $2 million to begin to set aside funds for the Citis accrued liability' for post- employment (retiree health) benefits pursuant to new requirements of GASB 45; and (2) the remainder to increase our Capital Reserve Fund. This last item will continue to ensure adequate funding related to previously approved capital projects for expenditures due to bids that are overbudget, change orders, or other unforeseen items. It should be noted that this actual is preliminary in nature due to the fact that the City's financial records will not be closed until after the external auditors complete their review. Historically, this occurs in April, with the City's Comprehensive Annual Financial Report (CAFR) For the Year Ended September 30, 2006, available in May 2007. However, this analysis has considered all year-end closing entries to date and typically, any additional changes are minor in nature. I. General Fund Overview At this writing, operating revenues received from all sources by the General Fund total $217,061,208, which is $9,136,091 more than the adopted budget of $207,925,117. This surplus is primarily due to higher than anticipated revenues from taxes on electricity, building and trade permits, FEMA hurricane reimbursements, and an increase in interest earnings. Operating expenditures incurred by all departments in the General Fund total $211 ,443,049, which is $3,517,932 more than the adopted budget of $207,925,117. This is mainly due to hurricane expenses for non-debris removal and retroactive payments to Miami-Dade County Water and Sewer on behalf of residents to offset otherwise necessary fee increases.' These items were slightly offset by some department savings. Since Florida Statutes prohibit the overexpenditure of departmental budgets and funds, a budget amendment will be necessary for those functions which projections indicate will overexpend their appropriation. A Resolution to adopt the first amendment to the General, Enterprise and Internal Service Fund Budgets for Fiscal Year 2005/06 will be presented at the February 14'h City Commission meeting. Summing the revenue surplus of $9, 136,091 and the overexpend itu res of $3,517,932 equals a budget surplus of $5,618,159 (including open encumbrances of $1,315,456). A summary of preliminary General Fund Revenues and Expenditures as of September 30, 2006 is as follows: General Fund Revenues Expenditures Surplus/(Deficit) Adopted Budget FY 05/06 $207,925,117 207.925.117 $ 0 Preliminary Actual/Enc as of 02/05/07 $217,061,208 211.443.049 $ 5,618,159 Budget/Actual Over/(Under) $ 9,136,091 3.517.932 $ 5,618,159 Note: . Includes current year encumbrances totaling $1,315,456. For a detail of General Fund Revenues and Expenditures by category and classification, see "Attachment A". Detailed comments on those revenue and expenditure categories with significant variance are shown below. General Fund Operating Revenues As of September 30, 2006,. revenues collected equal $217,061,208 and represent an excess of $9,136,091 or 4.4% of the adopted budget. 1. Ad Valorem Property Taxes - Year-end collections of $109,816,531 are 1.8% under the budget creating a net shortfall of $1,961,561. This is primarily due to higher than anticipated property value appeals approved by Miami-Dade County. 2. Other Taxes - This category includes franchise and utility taxes on services which are sensitive to local economic indicators. Based on actual collections of $22,257,255, an excess of $1,493,955, or 7.2%, resulted at year-end. This is primarily due to an increase in revenues from taxes on electricity. 3. Licenses and Permits - This category includes licenses and building and special use permits. Based on actual collections of $16,236,245, an excess of $3,725,232, or 29.8%, resulted at year-end. This is primarily due to higher than anticipated revenues from building and trade permits. 4. Intergovernmental - This category includes state-shared revenues such as cigarette, convention development, gas and sales taxes. Based on actual collections of $15,765,113, an excess of $2,744,517, or 21.1%, resulted year-end. This is mainly due to FEMA hurricane reimbursements and sales tax proceeds. 5. Charges for Services - This category includes fees for copies, passports, fire rescue, and recreational services. Based on actual collections of $8,496,229, an excess of $853,429, or 11.2%, resulted at year-end. This is due primarily to higher than expected revenues from the Miami Beach Golf Course. 6. Fines and Forfeits - This category includes traffic citations, and code and fire violation fees. Based on actual collections of $2,322,452, an excess of $581 ,452, or 33.4%, resulted at year-end. This is due to an increase in code enforcement violation revenues and parking fines issued by the Police Department. 7. Interest - This category includes interest income from City investments. Based on actual collections of $5,794,944, an excess of $1,554,944, or 36.7%, resulted at year-end. This is primarily due to rising interest rates during the year. 8. Rents and Leases - This category includes rents and leases on City-owned facilities such as golf courses, Historic City Hall, and others. Projections indicate that year-end revenues will exceed budget by less than 1 % or $538,767. This is primarily due to an increase in revenues from the rental of the Miami Beach Marina previously recorded in the former South Pointe RDA as well as revenues from bus shelters and South Pointe Park Restaurant. 9. Miscellaneous - This category includes concessions, planning fees, and other reimbursements. Projections indicate that year-end revenues will be 4.6% below budget or $289,159 due primarily to lower reimbursements for capital project charges as a result of CIP department savings from unfilled vacant positions throughout the year. General Fund Operating Expenditures As of September 30, 2006, actual expenditures of $211,443,049 were 1.7% over budget or $3,517,932. Variances for all departments are provided below. Significant variances to budget in excess of $100,000 by General Fund department are explained. 1. Mayor and Commission Adopted Budget FY 05/06 $ 1,343,332 Preliminary Actual/Enc. as of 02/05/07 $1,194,865 Budget/Actual Over/(Under) $ (148,467) This department is expected to spend 88.9% of its budget with a year-end surplus of $148,467 due primarily to savings in operating costs as well as unfilled vacant positions throughout the year. 2. City Manager Adopted Budget FY 05/06 $ 2,177,714 Preliminary Actual/Enc" as of 02/05/07 $ 2,172,397 Budget/Actual Over/(Under) $ (5,317) Budget/Actual Over/(Under) $ (120,566) The Communications Department is expected to spend 88.7% of its budget with a year-end surplus of $120,566 due primarily to savings in operating costs as well as unfilled vacant positions throughout the year. 3. Communications Adopted Budget FY 05/06 $1,067,074 Preliminary Actual/Enc' as of 02/05/07 $ 946,508 4. Office of Budget & Performance Improvement Adopted Budget Preliminary Actual/Enc. FY 05/06 as of 02/05/07 $ 1,736,275 $1,656,994 Budget/Actual Over/(Under) $ (79,281) 5. Finance Adopted Budget FY 05/06 $ 3,976,543 Preliminary Actual/Enc. as of 02/05/07 $ 3,610,662 Budget/Actual Over/(Under) $ (365,881) , This department is expected to spend 90.8% of its budget with a year-end surplus of $365,881 due primarily to unfilled vacant positions throughout the year. 6. Procurement Adopted Budget FY 05/06 $ 765,613 7. Human Resources Adopted Budget FY 05/06 $ 1,406,214 8. Labor Relations Adopted Budget FY 05/06 $ 223,132 9. City Clerk Adopted Budget FY 05/06 $ 1,499,264 Preliminary Actual/Enc' as of 02/05/07 $ 798,240 Preliminary Actual/Enc' as of 02/05/07 $ 1,364,405 Preliminary Actual/Enc' as of 02/05/07 $ 252,124 Preliminary Actual/Enc. as of 02/05/07 $ 1,346,695 Budget/Actual Over/(Under) $ 32,627 Budget/Actual Over/(Under) $ (41,809) Budget/Actual Over/(Under) $ 28,992 Budget/Actual Over/(Under) $ (152,569) This department is expected to spend 89.8% of its budget with a year-end surplus of $152,569 due primarily to savings in operating expenses and unfilled vacant positions throughout the year. 10. City Attorney Adopted Budget FY 05/06 $ 3,955,117 Preliminary Actual/Enc. as of 02/05/07 $ 3,737,863 Budget/Actual Over/(Under) $ (217,254) This department is expected to spend 94.5% of its budget with a year-end surplus of $217,254 due primarily to unfilled vacant positions throughout the year and savings in operating expenses. 11. Economic Development Adopted Budget FY 05/06 $ 863,936 Preliminary Actual/Enc. as of 02/05/07 $ 836,242 Budget/Actual Over/(Under) $ (27,694) 12. Building Adopted Budget FY 05/06 $ 6,565,945 Preliminary Actual/Enc. as of 02/05/07 $ 6,688,070 Budget/Actual Over/(Under) $ 122,125 This department is expected to spend 1.9% over its budget in the amount of $122, 125. This is due primarily to the use of outside professional services to cover vacant positions. These costs were offset from higher than anticipated revenues from permits and Building Training Surcharge. 13. Planning Adopted Budget FY 05/06 $ 2,910,361 Preliminary Actual/Enc. as of 02/05/07 $ 2,656,191 Budget/Actual Over/(Under) $ (254,170) This department is expected to spend 91.3% of its budget with a year-end surplus of $254,170 due primarily to unfilled vacant positions throughout the year and savings in operating expenses. 14. Tourism & Cultural Development Adopted Budget Preliminary Actual/Enc. FY 05/06 as of 02/05/07 $ 2,623,647 $ 2,442,360 Budget/Actual Over/(Under) $ (181,287) This department is expected to spend 93.1 % of its budget with a year-end surplus of $181,287 due primarily to the delay in opening of the Colony Theatre. 15. Neighborhood Services Adopted Budget FY 05/06 $ 4,486,086 Preliminary Actual/Enc. as of 02/05/07 $ 4,385,270 Budget/Actual Over/(Under) $ (100,816) This department is expected to spend 97.8% of its budget with a year-end surplus of $100,816 due primarily to savings in operating costs as well as unfilled vacant positions throughout the year. 16. Parks and Recreation Adopted Budget FY 05/06 $24,842,148 Preliminary Actual/Enc' as of 02/05/07 $24,158,799 Budget/Actual Over/(Under) $ (683,349) The Parks and Recreation Department is expected to spend 97.2% of its budget with a year-end surplus of $683,349 due primarily to unfilled vacant positions and savings in operating expenses 17. Public Works Adopted Budget FY 05/06 $ 6,092,697 Preliminary Actual/Enc. as of 02/05/07 $ 5,715,097 Budget/Actual Over/(Under) $ (377,600) This department is expected to spend 93.8% of its budget with a year-end surplus of $377,600 due primarily to unfilled vacant positions throughout the year. 18. Capital Improvement Program Adopted Budget Preliminary Actual/Enc' FY 05/06 as of 02/05/07 $ 3,179,602 $ 2,701,968 Budget/Actual Over/(Under) , $ (477,634) This department is expected to spend 85% of its budget' with a year-end surplus of $477,634 due primarily to unfilled vacant positions throughout the year. 19. Police Adopted Budget FY 05/06 $67,738,027 Preliminary Actual/Enc. as of 02/05/07 $68,703,087 Budget/Actual ' Over/(Under) $ 965,060 The Police Department is expected to spend 1.4% over its budget in the amount of $965,060 due primarily to higher than anticipated overtime usage for special events. 20. Fire Adopted Budget FY 05/06 $40,073,894 Preliminary Actual/Enc' as of 02/05/07 $40,501,624 Budget/Actual ' Over/(Under) $ 427,730 This department is projected to spend 1.1 % over its budget in the amount of $427,730. This is primarily due to higher than anticipated overtime usage. 21. Citywide Accounts Adopted Budget FY 05/06 $ 27,868,933 Preliminary Actual/Enc. as of 02/05/07 $ 34,944,025 Budget/Actual Over/(Under) $7,075,092 The Citywide Accounts are expected to spend 25.4% over their budget or $7,075,092. Although there was lower than expected need to use budgeted contingencies for special projects, there was $4,100,687 in non-debris removal hurricane expenses. Additionally, as referenced in the Manager's Budget Message for the FY 2006/07 Adopted Budget and as presented at the various meetings, there is also a charge of $1,168,663 in retroactive payments to Miami-Dade County Water and Sewer on behalf of residents to offset otherwise necessary fee increases. The non-debris removal hurricane expenses are offset mainly by FEMA reimbursements. Note: . Includes encumbra'nces II. ENTERPRISE FUNDS The City accounts for proprietary operations in Enterprise Funds. Convention Center, Parking, Sanitation, Sewer, Stormwater, and Water are included in this grouping. Based upon our review, the Enterprise Funds are at a significant surplus. However, it is necessary to amend the appropriation for those departments for which our year-end expenditure projections indicate will exceed their budget appropriation. Therefore, the Convention Center and Sanitation Funds will require a budget amendment. For a detail of Enterprise Fund Revenues and Expenses by department, see "Attachment B". The Convention Center Fund overspent its budget by a net of $1,682,000 due to higher personnel and electricity expenses associated with a higher volume of events and Hurricane expenses. These expenses will be offset by revenues from a higher than previously anticipated volume of events. The Sanitation Fund overspent its budget by a net of $4.2 million due to debris removal expenses in the aftermath of Hurricane Wilma. These expenses will be offset by higher than anticipated revenues from Sanitation Franchise and Roll-Off Fees as well as reimbursements from FEMA. III. INTERNAL SERVICE FUNDS The City accounts for those goods and services provided by one department to other departments citywide on a cost reimbursement basis. Central Services, Fleet Management, Information Technology, Property Management, and Risk Management (Self Insurance) are included in this grouping. Based upon our review, all of these funds operated within budget or at a surplus. For a detail of Internal Service Fund Revenues and Expenses by department, see "Attachment C". CONCLUSION This analysis of preliminary operating revenues and expenses for General, Enterprise, and Internal Funds for the year ended September 30, 2006, is presented as part of our on-going efforts to keep the Commission informed of the status of the FY 2005/06 Budget. A Resolution to adopt the first amendment to the General, Enterprise and Internal Service fund Budgets for Fiscal Year 2005/06 will be presented at the February 14th City Commission meeting. JMG/KGB/JC~ Attachments A-C ATTACHMENT A FY 2005/06 General Fund Operating Summary REVENUES Ad Valorem Taxes Ad Valorem Cap. Renewal & Replace. Other Taxes Licenses and Permits Intergovernmental Charges for Services Fines and Forfeits Interest Rents and Leases Miscellaneous Other - Resort Tax contribution Other - Non Operating revenues Fund Balance TOTAL REVENUES EXPENDITURES Mayor and Commission City Manager Communications City Clerk Finance Office of Budget & Perf Improve. Human Resources Labor Relations Procurement City Attorney Economic Development Building Planning Tourism & Cultural Development Neighborhood Services Parks and Recreation Public Works Capital Improvement Program Fire Police Citywide Accounts Citywide Accounts-Hurricanes Citywide Accounts-WASA retro pymt Capital Renewal & Replacement SUBTOTAL EXPENDITURES Adopted Prelim Actual/Enc FY 2005/06 05/06 as of Feb 5th $ 109,248,527 $ 107,286,968 $ (1,961,559) 2,529,563 2,529,563 0 20,763,300 22,257,255 1,493,955 12,511,013 16,236,245 3,725,232 13,020,596 15,765,113 2,744,517 7,642,800 8,496,229 853,429 1,741,000 2,322,452 581 ,452 4,240,000 5,794,944 1,554,944 2,605,184 3,143,951 538,767 6,272,901 5,983,742 (289,159) 19,571,309 19,571,310 1 7,778,924 7,673,436 (105,488) 0 0 0 $207,925,117 $ 217,061,208 $ 9,136,091 $ 1,343,332 $ 1,194,865 $ (148,467) 2,177,714 2,172,397 (5,317) 1,067,074 946,508 (120,566) 1 ,499,264 1,346,695 (152,569) 3,976,543 3,610,662 (365,881 ) 1,736,275 1,656,994 (79,281) 1,406,214 1,364,405 (41,809) 223,132 252,124 28,992 765,613 798,240 32,627 3,955,117 3,737,863 (217,254) 863,936 836,242 (27,694) 6,565,945 6,688,070 122,125 2,910,361 2,656,191 (254,170) 2,623,647 2,442,360 (181,287) 4,486,086 4,385,270 (100,816) 24,842,148 24,158,799 (683,349) 6,092,697 5,715,097 (377,600) 3,179,602 2,701,968 (477,634) 40,073,894 40,501,624 427,730 67,738,027 68,703,087 965,060 27,868,933 27,774,675 (94,258) 0 4,100,687 4,100,687 0 1,168,663 1,168,663 2,529,563 2,529,563 0 $ 207,925,117 $ 211,443,049 $ 3,517,932 1$ 5,618,159 $ 5,618.1591 o $ ATTACHMENT B FY 2005/06 Enterprise Funds Operating Summary CONVENTION CENTERlTOPA REVENUES CHARGES FOR SERVICES Rents and Leases Concessions Telephones Electrical Income Services Miscellaneous and Other Subtotal OTHER Convention Development Tax Hurricane Reimbursement Interest Earnings Retained Earnings Subtotal TOTAL REVENUES EXPENSES Payroll and Fringes Operating Electricity Management Fees to GF Hurricane Expenses Depreciation Caoital TOTAL EXPENSES Adopted FY 2005/06 Prelim Actual/Enc 05/06 as of Feb 5th $ 4,583,569 $ 5,222,395 1,329,867 1,595,304 290,039 279,162 933,849 998,718 211,082 491,622 449,173 732,351 $ 7,797,579 $ 9,319,552 $ 4,500,000 $ 4,500,000 0 76,491 36,250 160,706 3,150,000 3,150,000 $ 7,686,250 $ 7,887,197 $ 15,483,829 $ 17,206,749 $ 4,392,248 $ 5,298,034 5,363,095 5,333,676 1,301,970 1,786,556 740,600 740,600 0 320,898 3,150,000 3,150,000 535,916 535,916 $ 15,483,829 $ 17,165,680 1$ o $ 41,06911 $ $ 638,826 265,437 (10,877) 64,869 280,540 283,178 $ 1,521,973 $ 0 76,491 124,456 0 $ 200,947 $ 1,722,920 $ 905,786 (29,419) 484,586 0 320,898 0 0 $ 1,681,851 41,0691 FY 2005/06 Enterprise Funds Operating Summary PARKING REVENUES CHARGES FOR SERVICES Meters Parking Citations Attended Parking Permits Preferred Lot Garages Space Rental Valet Towino Fees Subtotal OTHER Interest Earnings Miscellaneous Subtotal TOTAL REVENUES EXPENSES Payroll & Fringes Operating Management Fees to GF Depreciation Debt Service Capital TOTAL EXPENSES Adopted FY 2005/06 Prelim Actual/Enc 05/06 as of Feb 5th $ 10,753,838 $ 11,534,941 3,217,495 2,551,002 1,849,500 2,274,104 623,039 745,841 580,000 864,045 3,713,800 4,458,525 379,600 382,679 390,000 475,165 150,000 125,087 $ 21,657,272 $ 23,411,389 $ 300,000 $ 1,138,184 102,800 (16,195 $ 402,800 $ 1,121,989 $ 22,060,072 $ 24,533,378 $ 6,311,101 6,385,545 9,313,161 8,675,044 2,433,400 2,433,400 1,633,409 1,261,065 2,184,901 1,820,473 184,100 946,925 $ 22,060,072 21,522,452 1$ 3,010,92611 $ o $ $ 781,103 (666,493) 424,604 122,802 284,045 744,725 3,079 85,165 (24,913' $ 1,754,117 $ 838,184 (118,995' $719,189 $ 2,473,306 $ 74,444 (638,117) 0 (372,344 ) (364,428) 762,825 $ (537,620 3,010,9261 FY 2005/06 Enterprise Funds Operating Summary SANITATION REVENUES CHARGES FOR SERVICES Sanitation Fees Franchise Tax-Waste Contractors Franchise Tax-Right of Way Trash Removal Roll Off Impact Fee-Construction Impact Fee-Commercial City Center RDA-Reimbursement Amended CDT Interlocal Agreement Violations/Fines Subtotal OTHER Interest Earnings/Other Hurricane Reimbursement Retained Earnings Stormwater Fund Contribution Subtotal TOTAL REVENUES EXPENSES Payroll & Fringes Operating Garbage Contracts Management Fees to GF Hurricane Expenses Depreciation Debt Service - Loan Program Caoital TOTAL EXPENSES Adopted FY 2005/06 Prelim Actual/Enc 05/06 as of Feb 5th $ 3,194,249 $ 3,202,333 1,982,616 2,407,078 251,250 309,611 35,000 52,599 360,000 636,309 665,000 857,512 700,000 683,774 862,648 532,913 2,665,002 2,473,354 75,000 27,552 $ 10,790,765 $ 11,183,035 $ 55,200 $ 174,113 0 3,628,079 0 46,995 584,000 584,000 $ 639,200 $ 4,433,187 $ 11,429,965 $ 15,616,222 $ 6,037,484 $ 4,467,405 1,969,567 3,075,354 2,349,736 2,097,972 264,500 264,500 0 4,337,544 255,378 464,896 150,000 155,431 403,300 735,997 $ 11,429,965 $ 15,599,099 1$ 17,12311 $ o $ $ 8,084 424,462 58,361 17,599 276,309 192,512 (16,226) (329,735) (191,648) , (47,448' $ 392,270 $ 118,913 3,628,079 46,995 0 $ 3,793,987 $ 4,186,257 $ (1,570,079) 1,105,787 (251,764) 0 4,337,544 209,518 5,431 332,697 $ 4,169,134 17,1231 FY 2005/06 Enterprise Funds Operating Summary SEWER OPERATIONS REVENUES CHARGES FOR SERVICES Sewer User Fees Sewer Connection Fees Sewer Fees-Cities Subtotal OTHER Interest Earnings Miscellaneous Hurricane Reimbursement Retained EarninQs Subtotal TOTAL REVENUES EXPENSES Payroll & Fringes Operating Sewer Treatment Management Fees to GF Hurricane Expenses DERM Fee Depreciation Debt Service Capital TOTAL EXPENSES Adopted FY 2005/06 Prelim Actual/Enc 05/06 as of Feb 5th $ 25,595,538 $ 24,580,555 65,000 15,916 2,260,000 2,444,360 $ 27,920,538 $ 27,040,831 $ 125,000 $ 229,720 630,000 630,844 0 106,206 590,970 0 $ 1,345,970 $ 966,770 $ 29,266,508 $ 28,007,601 $ 2,226,427 $ 2,102,428 2,884,718 2,517,074 14,762,731 14,806,541 1,388,957 1,388,957 0 97,500 1,843,065 1,930,168 1,080,000 1,082,400 4,489,640 1,891,843 590,970 435,041 $ 29,266,508 $ 26,251,952 1$ o $ 1,755,64911 $ $ (1,014,983) (49,084) 184,360 $ (879,707 $ 104,720 844 106,206 (590,970 $ (379,200 $ (1,258,907 $ (123,999) (367,644) 43,810 0 97,500 87,103 2,400 (2,597,797) (155,929 $ (3,014,556 1,755,6491 FY 2005/06 Enterprise Funds Operating Summary STORMWATER REVENUES Stormwater Fees Interest EarninQs/Other TOTAL REVENUES EXPENSES Payroll & Fringes Operating Contribution Sanitation Management Fees to GF Depreciation Debt Service Capital TOTAL EXPENSES Adopted Prelim Actual/Enc FY 2005/06 05/06 as of Feb 5th $ 8,085,000 $ 7,415,170 $ (669,830) 165,000 338,431 173,431 $ 8,250,000 $ 7,753,601 $ 1496,399 $ 1,386,822 $ 1,114,144 962,548 906,151 584,000 584,000 264,500 264,500 130,000 201,666 3,575,000 2,782,104 1,347,130 946,093 $ 8,250,000 $ 6,798,658 1$ 954,94311 $ o $ $ (272,678) (56,397) 0 0 71,666 (792,896) 1401,037' $ 11,451,342 954,9431 FY 2005/06 Enterprise Funds Operating Summary WATER OPERATIONS REVENUES CHARGES FOR SERVICES Water Sales Firelines Water Connection Fees Water TaooinQ Subtotal OTHER Interest Earnings Hurricane Reimbursement Miscellaneous Retained Earnings Subtotal TOTAL REVENUES EXPENSES Payroll & Fringes Operating Water Purchase Management Fees to GF Hurricane Expenses DERM Fee Depreciation Debt Service Capital TOTAL EXPENSES Adopted FY 2005/06 Prelim Actual/Enc 05/06 as of Feb 5th $ 19,336,628 $ 19,448,656 100,000 70,889 3,000 514 215,000 132,084 $ 19,654,628 $ 19,652,143 $ 40,000 $ 73,741 0 101,634 600,000 595,434 883,400 0 $ 1,523,400 $ 770,809 $ 21,178,028 $ 20,422,952 $ 3,629,410 $ 2,958,272 2,561,316 2,125,226 7,038,000 6,891,574 1,673,843 1,673,843 0 97,500 1,421,699 1,353,675 660,000 673,071 3,310,360 2,266,634 883,400 551,721 $ 21,178,028 $ 18,591,516 1$ o $ 1,831,43611 $ $ 112,028 (29,111) (2,486) 182,916; $ (2,485 $ 33,741 101,634 (4,566) 883,400 $ 752,591 $ 755,076 $ (671,138) (436,090) . (146,426) 0 97,500 (68,024) 13,071 (1,043,726) 1331,679 $ 12,586,512 1,831,4361 ATTACHMENT C FY 2005/06 Internal Service Funds Operating Summary CENTRAL SERVICES REVENUES Inter-departmental Charges Interest/Other Retained EarninQs TOTAL REVENUES EXPENSES Payroll & Fringes Operating Postage Depreciation Caoital TOTAL EXPENSES Adopted Prelim Actual/Enc FY 2005/06 05/06 as of Feb 5th $733,793 4,000 54,750 $792,543 $670,539 13,304 103,563 $787,406 $326,544 $319,208 291,631 300,105 170,000 163,702 4,368 4,391 0 0 $792,543 $787,406 $0 $0 II ($63,254 ) 9,304 48,813 ($5,137 ($7,336) 8,474 (6,298) 23 o ($5,137 $0 I FY 2005/06 Internal Service Funds Operating Summary FLEET MANAGEMENT REVENUES Inter-departmental Charges Sale of City Property Interest/Other Motor Fuel Tax Refund Retained EarninQs TOTAL REVENUES EXPENSES Payroll & Fringes Operating Fuel Debt Service Caoital TOTAL EXPENSES Adopted Prelim Actual/Enc FY 2005/06 05/06 as of Feb 5th $5,842,191 220,000 127,001 72,000 540,402 $6,801,594 $6,856,151 128,375 645,793 92,645 o $7,722,964 $1,403,896 $1,316,864 1,746,150 1,875,414 1,820,000 2,111,316 1,686,548 1,702,167 145,000 41,757 $6,801,594 $7,047,518 $0 $675,4461 I $1,013,960 (91,625) 518,792 20,645 (540,402' $921,370 ($87,032) 129,264 291,316 15,619 (103,243' $245,924 $675,4461 FY 2005/06 Internal Service Funds Operating Summary INFORMATION TECHNOLOGY REVENUES Inter-departmental Charges Other/lnterest Retained Earninos TOTAL REVENUES EXPENSES Payroll & Fringes Operating Telephone Depreciation Debt Service Capital TOTAL EXPENSES Adopted Prelim Actual/Enc FY 2005/06 05/06 as of Feb 5th $9,591,245 69,678 2,408,800 $12,069,723 $9,479,137 306,803 358,872 $10,144,812 $3,914,816 $3,623,490 3,046,702 2,711,193 1,049,000 1,085,690 1,085,789 100,616 517,956 646,105 2,455,460 1,977,718 $12,069,723 $10,144,812 $0 $0 II ($112,108) 237,125 2,049,928 $1,924,911 ($291,326) (335,509) 36,690 (985,173) 128,149 (477,742' ($1,924,911 $0 I FY 2005/06 Internal Service Funds Operating Summary PROPERTY MANAGEMENT REVENUES Inter-departmental Charges Other/lnterest Construction Projects Retained EarninQs TOTAL REVENUES EXPENSES Payroll & Fringes Operating Depreciation Caoital TOTAL EXPENSES Adopted Prelim Actual/Enc FY 2005/06 05/06 as of Feb 5th $7,276,821 5,000 794,282 174,770 $8,250,873 $7,675,020 28,231 355,038 102,218 $8,160,507 $3,883,582 $3,685,633 3,807,521 4,023,393 185,000 170,492 374,770 280,989 $8,250,873 $8,160,507 $0 $0 II $398,199 23,231 (439,244) 72,552 $90,366 ($197,949) 215,872 (14,508) 193,781 ($90,366) $0 I FY 2005106 Internal Service Funds Operating Summary RISK MANAGEMENT REVENUES Inter-departmental Charges Other/Interest General Fund Contribution Retained EarninQs TOTAL REVENUES EXPENSES Operating Administrative Fees Non-OperatinQ TOTAL EXPENSES $618,314 $637,682 $19,368 674,481 674,481 0 16,937,237 15,045,407 11,891,830\ $18,230,032 $16,357,570 ($1,872,462 $0 $1,000,000 I I $1,000,000 I Adopted Prelim Actual/Enc FY 2005/06 05/06 as of Feb 5th $14,851,032 $14,848,285 100,000 34,837 1,000,000 2,000,000 2,279,000 474,448 $18,230,032 $17,357,570 ($2,747) (65,163) 1,000,000 11,804,552 1$872,462