LTC 137-2006 Analysis of Budget May 18, 2006
lD MIAMI BEACH
OFFICE OF THE CITY MANAGER
NO. LTC # 137-2006
LETTER TO COMMISSlPf\b
...., (J\
::J:
:;:;;a
-<
TO:
Mayor David Dermer and Members of the City Commission
-0
v' =;;:
FROM: Jorge M. Gonzalez, City Manager ~v..r~'
DATE: May 18, 2006 0 w
C)
r:"1 .s;::-
SUBJECT: ANALYSIS OF BUDGET TO ACTUAL REVENUES AND EXPENSES FOR THE SIX MONTHS ENDED
MARCH 31, 2006, WITH OPERATING BUDGET PROJECTIONS THROUGH SEPTEMBER 30, 2006 FOR
GENERAL, ENTERPRISE, AND INTERNAL SERVICE FUNDS.
The Purpose of this LTC is to keep the Mayor and Commission informed of the status of the
FY 2005/06 Budget to actual revenue and expenses at the end of the second quarter with
projections through September 30,2006.
Six month budget to actual comparisons for General, Enterprise, and Intemal Service Funds
are presented in the following pages with comments on those areas which are at a
significant variance to budget.
I. General Fund Overview
An analysis of six month operating revenues and expenditures as of March 31, 2006,
reveals an operating surplus of $47,150,183. Based on actual amounts and operating
projections through September 30,2006, it is anticipated that at year-end we will generate a
budget surplus of approximately $3,640,074 (less than 2% of budget). A portion of this
budget surplus may be used to pay for Hurricane Wilma expenses that FEMA does not
reimburse and the balance to fund Capital Reserves as well as current shortfalls in the
liability within the Risk Management Fund. While the surplus as of March 31st seems
unusually large as compared to the final projected for the year ending on September 30th, it
should be noted that the City receives a greater percentage of its ad valorem taxes in the
first quarter. Ad valorem tax revenues representing approximately 65% of total revenues
have been almost 82% received whereas the remaining 35% of revenues are approximately
at the 50% level as of March 31st.
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 2005/06
$207,925,117
207.925.117
$ 0
Projected *
Sept. 30. 2006
$210,878.191
207.238.117
$ 3,640,074
Budget! Actual
Over/(Under)
$2,953,074
(687.000)
$3,640,074
Note: * Does not Include current year encumbrances totaling $5,592,752.
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.
\D
:Aj
m
()
:il
N
~:C
rn
CJ
General Fund Operating Revenues
As of March 31, 2006, revenues collected were 66% of budget or $136,751,914. On a
straight-line average for six months ended March 31,2006, revenues collected should have
been at a minimum, approximately 50% of budget or $1 03,962,559. While actual revenues
received were greater than this minimum, this can be somewhat misleading. The City
receives a greater percentage of its ad valorem taxes in the first quarter, which must be
duly considered when analyzing actual revenues and formulating year-end revenue
projections. Year-end projections through September 30, 2006 which total $210,878,191
indicate that revenues will be above budget by $2,953,074 or approximately 1%.
1. Ad Valorem Property Taxes - Based on actual collections to date and historical
trends, it is projected that year-end collections will be $109,048,527 or less than 1 %
below budget.
2. Other Taxes - This category includes franchise and utility taxes on services which
are sensitive to local economic indicators. Projections indicate that year-end
collections will exceed budget by 4% or $910,000. 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. Projections indicate that year-end collections will exceed budget by 8%
or $945,987. This is primarily due to higher than anticipated revenues from building
and trade permits and certificates of occupancy.
4. Intergovernmental - This category includes state-shared revenues such as
cigarette, gas, and sales taxes. Projections indicate that year-end collections will
exceed budget by 6% or $827,000. This is mainly due to higher than anticipated
revenues from sales taxes and motor fuel taxes.
5. Charges for Services - This category includes admissions at recreational centers
and facilities, and fees for fire rescue services. Projections indicate that year-end
revenues will exceed budget by less than 1% or $13,000. This is mainly due to an
increase in fire rescue revenues.
6. Fines and Forfeits - This category includes traffic citations, and code and fire
violation fees. Projections indicate that year-end revenues will exceed budget by
11 % or $185,000.This is due to an increase in code enforcement violation revenues.
7. Interest - This category includes interest income from City investments. Projections
indicate that year-end revenues will exceed budget by 13% or $560,000.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 6% or $168,990. This is primarily due to an
increase in revenues from the rental of the Byron Carlyle and Ballet Valet Ramp.
9. Miscellaneous - This category includes concessions, planning fees, and other
reimbursements. Projections indicate that year-end revenues will be 7% below
budget or $456,903 due primarily to lower than expected revenues from construction
management charges to capital projects.
General Fund Operating Expenditures
As of March 31, 2006, actual expenditures were 39% of budget or $89,601,732. On a
straight-line average for six months ended March 31, 2006, expenditures should have been
at a minimum, approximately 50% of budget or $103,962,559. Therefore, at March 31st,
expenditures were 14% under a straight-line average or $14,360,827. Year-end projections
through September 30, 2006 indicate that year-end expenditures of $207,238,117 will be
less than 1 % below budget. 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
Budget
FY 2005/06
$ 1,343,332
Projected*
Sept. 30, 2006
$ 1,308,332
2.
City Manager
Budget
FY 2005/06
$ 2,177,714
Projected*
Sept. 30,2006
$ 2,157,714
3.
Communications
Budget
FY 2005/06
$1,067,074
Projected*
Sept. 30, 2006
$ 1,002,074
4.
Office of Budget & Performance Improvement
Budget Projected*
FY 2005/06 Sept. 30, 2006
$ 1,736,275 $ 1,686,275
5.
Finance
Budget
FY 2005/06
$ 3,976,543
Projected*
Sept. 30,2006
$ 3,846,543
Budget!Projected
Over/(Under)
$ (35,000)
Budget!Projected
Over/(Under)
$ (20,000)
Budget!Projected
Over/(Under)
$ (65,000)
Budget!Projected
Over/(Under)
$ (50,000)
Budget/Projected
Over/(Under)
$ (130,000)
This department is expected to spend 97% of its budget and generate a year-end
surplus of $130,000 due mainly to unfilled vacant positions.
6.
Procurement
Budget
FY 2005/06
$ 765,613
Projected*
Sept. 30, 2006 .
$ 801,613
Budget!Projected
Over/(Under)
$ 36,000
7. Human Resources
Budget Projected* Budget!Projected
FY 2005/06 Sept. 30, 2006 Over/(Under)
$ 1,406,214 $ 1,386,214 $ (20,000)
8. Labor Relations
Budget Projected* Budget!Projected
FY 2005/06 Sept. 30, 2006 Over/(Under)
$ 223,132 $ 223,132 $ 0
9. City Clerk
Budget Projected * Budget!Projected
FY 2005/06 Sept. 30, 2006 Over/(Under)
$ 1,499,264 $ 1,449,264 $ (50,000)
10. City Attorney
Budget Projected* Budget!Projected
FY 2005/06 Sept. 30, 2006 Over/(Under)
$ 3,955,117 $ 3,962,117 $ 7,000
11. Economic Development
Budget Projected* Budget!Projected
FY 2005/06 Sept. 30, 2006 Over/(Under)
$ 863,936 $ 823,936 $ (40,000)
12. Building
Budget Projected* Budget!Projected
FY 2005/06 Sept. 30,2006 Over/(Under)
$ 6,565,945 $ 6,650,945 $ 85,000
13. Planning
Budget Projected* Budget!Projected
FY 2005/06 Sept. 30, 2006 Over/(Under)
$ 2,910,361 $ 2,785,361 $ (125,000)
This department is expected to spend 96% of its budget with a year-end surplus of
$125,000 due primarily to vacant positions and savings in operating expenses.
14. Tourism & Cultural Development
Budget Projected* Budget!Projected
FY 2005/06 Sept. 30, 2006 Over/(Under)
$ 2,623,647 $ 2,533,647 $ (90,000)
15. Neighborhood Services
Budget Projected * Budget!Projected
FY 2005/06 Sept. 30, 2006 Over/(Under)
$ 4,486,086 $ 4,456,086 $ (30,000)
16. Parks and Recreation
Budget
FY 2005/06
$24,842,148
Projected*
Sept. 30, 2006
$24,592,148
Budget!Projected
Over/(Under)
$ (250,000)
The Parks and Recreation Department is expected to spend 99% of its budget with a
year-end surplus of $250,000 due primarily to vacant positions and savings in
operating expenses
17. Public Works
Budget
FY 2005/06
$ 6,092,697
Projected*
Sept. 30, 2006
$ 5,952,697
Budget!Projected
Over/(Under)
$ (140,000)
The Public Works Department is expected to spend 98% of its budget with a year-
end surplus of $140,000 due primarily to vacant positions and savings in operating
expenses.
18. Capital Improvement Program
Budget Projected*
FY 2005/06 Sept. 30, 2006
$ 3,179,602 $ 2,954,602
Budget!Projected
Over/(Under)
$ (225,000)
This department is expected to expend 93% of its budget with a year-end surplus of
$225,000 due primarily to unfilled vacant positions throughout the year.
19. Police
Budget
FY 2005/06
$67,738,027
Projected*
Sept. 30, 2006
$68,723,027
Budget!Projected
Over/(Under)
$ 985,000
The Police Department is expected to spend approximately 1.5% over its budget in
the amount of $985,000 due primarily to higher than anticipated overtime usage.
20. Fire
Budget
FY 2005/06
$40,073,894
Projected*
Sept. 30, 2006
$39,573,894
Budget!Projected
Over/(Under)
$ (500,000)
This department is projected to spend 99% of its budget and generate a year-end
surplus in the amount of $500,000.. This is primarily due to savings in operating
expenses and vacancies.
21. Citywide Accounts
Budget
FY 2005/06
$27,868,933
Projected*
Sept. 30, 2006
$27,838,933
Note: * Does not include encumbrances
Budget!Projected
Over/(Under)
$ (30,000)
II. ENTERPRISE FUNDS
The City accounts for proprietary operations in Enterprise Funds. Convention Center,
Parking, Sanitation, Sewer, Stormwater, and Water are included within this grouping.
Based upon our review, all funds will operate at budget or at a surplus except for the Sewer
Operation. Our projections indicate the Sewer operations will have a budget deficit of
$425,304 due to higher than anticipated sewer treatment costs. These expenses will be
offset by higher Sewer User Fee Revenues. For a detail of Enterprise Fund Revenues and
Expenses by department, see "Attachment B. II
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 funds will operate at budget or at a
surplus. For a detail of Internal Service Fund Revenues and Expenses by department, see
"Attachment C."
CONCLUSION
This analysis of six month budget to actual operating revenues and expenses for General,
Enterprise, and Internal Funds with projections through 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. Measures will be taken by the Administration to ensure that revenue
targets are achieved and expenditures are curtailed to ensure that we close the fiscal year
in a positive position and balanced with overall revenues exceeding overall expenses.
JMG/KGB/JC
Attachments A-C
ATTACHMENT A
FY 2005/06 General Fund Operating Summary Projection
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-Normandy Shore
Citywide Accounts-Transfers
Capital Renewal & Replacement
TOTAL EXPENDITURES
Adopted As of Projected
FY 2005/06 Mar 31, 2006 FY 2005/06
$ 109,248,527 $ 89,314,150 $ 109,048,527
2,529,563 0 2,529,563
20,763,300 9,043,579 21,673,300
12,511,013 9,760,386 13,457,000
13,020,596 4,655,185 13,847,596
7,642,800 3,404,331 7,655,800
1,741,000 1,188,060 1,926,000
4,240,000 2,571,308 4,800,000
2,605,184 1,068,879 2,774,174
6,272,901 2,889,098 5,815,998
19,571,309 9,235,655 19,571,309
7,778,924 3,621,283 7,778,924
0 0 0
$ 207,925,117 $ 136,751,914 $ 210,878,191
$ 1,343,332 $ 538,754 $ 1,308,332
2,177,714 994,423 2,157,714
1,067,074 330,784 1,002,074
1,499,264 670,320 1,449,264
3,976,543 1,559,178 3,846,543
1,736,275 689,046 1,686,275
1,406,214 546,065 1,386,214
223,132 115,787 223,132
765,613 335,773 801,613
3,955,117 1,628,825 3,962,117
863,936 362,001 823,936
6,565,945 2,515,937 6,650,945
2,910,361 1,083,926 2,785,361
2,623,647 867,100 2,533,647
4,486,086 1,772,339 4,456,086
24,842,148 9,782,892 24,592,148
6,092,697 2,479,117 5,952,697
3,179,602 802,202 2,954,602
40,073,894 18,260,749 39,573,894
67,738,027 31,710,283 68,723,027
9,531,272 3,387,400 9,501,272
128,833 64,417 128,833
18,208,828 9,104,414 18,208,828
2,529,563 0 2,529,563
$ 207,925,117 $ 89,601,732 $ 207,238,117
1$
3,640,074\ I $
o $ 47,150,183 $
$ (200,000)
0
910,000
945,987
827,000
13,000
185,000
560,000
168,990
(456,903)
0
0
0
$ 2,953,074
$ (35,000)
(20,000)
(65,000)
(50,000)
(130,000)
(50,000)
(20,000)
0
36,000
7,000
(40,000)
85,000
(125,000)
(90,000)
(30,000)
(250,000)
(140,000)
(225,000)
(500,000)
985,000
(30,000)
0
0
0
$ (687,000)
3,640,0741
ATTACHMENT B
FY 2005/06 Enterprise Funds Summary Projection
CONVENTION CENTERfTOPA
REVENUES
CHARGES FOR SERVICES
Rents and Leases
Concessions
Telephones
Electrical Income
Services
Miscellaneous and Other
Subtotal
OTHER
Convention Development Tax
Interest Earnings
Retained Earn inQs
Subtotal
TOTAL REVENUES
EXPENSES
Payroll and Fringes
Operating
Electricity
Management Fees to GF
Depreciation
Capital
TOTAL EXPENSES
Adopted As of Projected
FY 2005/06 Mar 31, 2006 FY 2005/06
$ 4,583,569 $ 3,430,375 $ 4,959,428
1,329,867 996,398 1,341,834
290,039 196,260 267,171
933,849 766,332 1,005,676
211,082 273,969 414,702
449,173 427,4 78 564,177
$ 7,797,579 $ 6,090,812 $ 8,552,988
$ 4,500,000 $ 4,500,000 $ 4,500,000
36,250 73,799 113,750
3,150,000 1,575,000 3,400,000
$ 7,686,250 $ 6,148,799 $ 8,013,750
$ 15,483,829 $ 12,239,611 $16,566,738
$ 4,392,248 $ 2,544,945 $ 4,326,270
5,363,095 2,714,727 5,107,519
1,301,970 916,533 1,787,518
740,600 370,300 740,600
3,150,000 1,575,000 3,400,000
535,916 0 535,916
$ 15,483,829 $ 8,121,505 $ 15,897,823
1$
668,91511 $
o $ 4,118,106 $
$ 375,859
11 ,967
(22,868)
71,827
203,620
115,004
$ 755,409
$0
77 ,500
250,000
$ 327,500
$ 1 ,082,909
$ (65,978)
(255,576)
485,548
0
250,000
0
$ 413,994
668,915\
FY 2005/06 Enterprise Funds Summary Projection
PARKING
REVENUES
CHARGES FOR SERVICES
Meters
Parking Citations
Attended Parking
Permits
Preferred Lot
Garages
Space Rental
Valet
Towing Fees
Subtotal
OTHER
Interest Earnings
Miscellaneous
Subtotal
TOTAL REVENUES
EXPENSES
Payroll & Fringes
Operating
Management Fees to GF
Depreciation
Debt Service
Capital
TOTAL EXPENSES
Adopted As of Projected
FY 2005/06 Mar 31,2006 FY 2005/06
$ 10,753,838 $ 5,523,978 $11,061,319
3,217,495 432,395 3,217,495
1,849,500 1,076,512 1,894,300
623,039 558,4 76 569,170
580,000 381,759 600,000
3,713,800 2,356,665 3,925,800
379,600 200,968 450,000
390,000 213,790 430,000
150,000 53,609 150,000
$21,657,272 $ 10,798,152 $ 22,298,084
$ 300,000 $ 384,916 $ 700,000
102,800 32,912 350,386
$ 402,800 $ 417,828 $ 1,050,386
$ 22,060,072 $ 11,215,980 $ 23,348,4 70
$ 6,311,101 2,715,635 $ 6,044,287
9,313,161 3,029,469 9,301,021
2,433,400 1,216,700 2,433,400
1,633,409 816,705 1 ,633,409
2,184,901 1,268,233 2,184,901
184,100 88,750 184,100
$ 22,060,072 9,135,492 $21,781,118
$ 307,481
0
44,800
(53,869)
20,000
212,000
70,400
40,000
0
$ 640,812
$400,000
247,586
$647,586
$ 1,288,398
$ (266,814)
(12,140)
0
0
0
0
$ (278,954 )
1$ 0 $ 2,080,489 $ 1,567,35211 $ 1,567,3521
FY 2005/06 Enterprise Funds Summary Projection
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
Capital
TOTAL EXPENSES
Adopted As of Projected
FY 2005/06 Mar 31, 2006 FY 2005/06
$ 3,194,249 $ 1,309,065 $ 3,327,000
1,982,616 1,002,835 2,058,000
251,250 128,743 281,000
35,000 34,526 66,000
360,000 346,726 800,000
665,000 380,493 770,000
700,000 270,019 700,000
862,648 360,156 720,311
2,665,002 1,112,638 2,225,277
75,000 43,918 70,000
$10,790,765 $ 4,989,119 $11,017,588
$ 55,200 $ 38,906 $ 71,000
0 9,074 3,081,093
0 0 0
584,000 190,771 584,000
$ 639,200 $ 238,751 $ 3,736,093
$ 11,429,965 $ 5,227,870 $14,753,681
$ 6,037,484 $ 1,916,223 $ 4,210,107
1,969,567 906,658 2,722,204
2,349,736 988,881 2,220,507
264,500 132,250 264,500
0 1,631,563 3,528,590
255,378 127,689 255,378
150,000 4,925 150,000
403,300 41,700 403,300
$ 11,429,965 $ 5,749,889 $ 13,754,586
1$
999,09511 $
o $
(522,019) $
$ 132,751
75,384
29,750
31,000
440,000
105,000
0
(142,337)
(439,725)
(5,000)
$ 226,823
$ 15,800
3,081,093
0
0
$ 3,096,893
$ 3,323,716
$ (1,827,377)
752,637
(129,229)
0
3,528,590
0
0
0
$ 2,324,621
999,0951
FY 2005/06 Enterprise Funds Summary Projection
SEWER OPERATIONS
REVENUES
CHARGES FOR SERVICES
Sewer User Fees
Sewer Connection Fees
Sewer Fees-Cities
Subtotal
OTHER
Interest Earnings
Miscellaneous
Retained Earninas
Subtotal
TOTAL REVENUES
EXPENSES
Payroll & Fringes
Operating
Sewer Treatment
Management Fees to GF
DERM Fee
Depreciation
Debt Service
Capital
TOTAL EXPENSES
Adopted As of Projected
FY 2005/06 Mar 31, 2006 FY 2005/06
$ 25,595,538 $ 9,366,516 $ 25,150,000
65,000 5,000 55,000
2,260,000 1,145,915 2,450,000
$ 27,920,538 $ 10,517,431 $ 27,655,000
$ 125,000 $ 55,417 $ 115,000
630,000 191,029 605,886
590,970 199,727 590,970
$ 1,345,970 $ 446,173 $ 1,311,856
$ 29,266,508 $ 10,963,604 $ 28,966,856
$ 2,226,427 $ 979,171 $ 2,024,427
2,884,718 1,001,631 2,734,718
14,762,731 5,757,282 15,153,280
1 ,388,957 694,4 79 1,388,957
1,843,065 1,930,168 1,930,168
1,080,000 540,000 1,080,000
4,489,640 1,418,001 4,489,640
590,970 199,727 590,970
$ 29,266,508 $ 12,520,459 $29,392,160
proj - Adptd
Over/(Under
$
$
$
$
$
$ (202,000)
(150,000)
390,549
0
87,103
0
0
0
$ 125,652
I $ 0 $ (1,556,855) $ (425,304)11 $ (425,304)\
FY 2005/06 Enterprise Funds Summary Projection
STORMWATER
REVENUES
Stormwater Fees
Interest Earnings
Other
TOTAL REVENUES
EXPENSES
Payroll & Fringes
Operating
Contribution Sanitation
Management Fees to GF
Depreciation
Debt Service
Capital
TOTAL EXPENSES
Adopted As of Projected
FY 2005/06 Mar 31, 2006 FY 2005/06
$ 8,085,000 $ 2,824,188 $ 7,970,000
165,000 112,649 225,000
0 (1,303) 3,000
$ 8,250,000 $ 2,935,534 $ 8,198,000
$ 1 ,386,822 $ 541 ,523 $ 1 ,176,822
962,548 482,019 937,548
584,000 292,000 584,000
264,500 132,250 264,500
130,000 65,000 130,000
3,575,000 1,291,836 3,575,000
1,347,130 105,010 1,250,000
$ 8,250,000 $ 2,909,638 $ 7,917,870
1$
280,130 II $
o $
25,896 $
$ (115,000)
60,000
3,000
$ (52,000)
$
$
280,130 I
FY 2005/06 Enterprise Funds Summary Projection
WATER OPERATIONS
REVENUES
CHARGES FOR SERVICES
Water Sales
Firelines
Water Connection Fees
Water Tappina
Subtotal
OTHER
Interest Earnings
Miscellaneous
Retained Earninas
Subtotal
TOTAL REVENUES
EXPENSES
Payroll & Fringes
Operating
Water Purchase
Management Fees to GF
DERM Fee
Depreciation
Debt Service
Capital
TOTAL EXPENSES
EXCESS OF REVENUES OVER!
UNDER) EXPENSES
Adopted As of Projected
FY 2005/06 Mar 31, 2006 FY 2005/06
$ 19,336,628 $ 7,343,917 $19,126,628
100,000 36,400 110,000
3,000 2,913 4,000
215,000 79,229 220,000
$ 19,654,628 $ 7,462,459 $19,460,628
$ 40,000 $ 17,569 $ 37,500
600,000 259,225 600,886
883,400 425,267 883,400
$ 1,523,400 $ 702,061 $ 1,521,786
$ 21,178,028 $ 8,164,520 $20,982,414
$ 3,629,410 $ 1,422,367 $ 3,069,410
2,561,316 864,506 2,495,316
7,038,000 2,700,534 6,700,000
1,673,843 836,922 1,673,843
1,421,699 1,353,675 1,353,675
660,000 330,000 660,000
3,310,360 1,043,806 3,310,360
883,400 425,267 883,400
$ 21,178,028 $ 8,977,077 $ 20,146,004
1$
836,410 II $
o $
(812,557) $
$ (210,000)
10,000
1,000
5,000
$ (194,000)
$ (2,500)
886
0
$ (1,614)
$ (195,614)
$ (560,000)
(66,000)
(338,000)
0
(68,024 )
0
0
0
$ (1,032,024)
836,410 I
ATTACHMENT C
FY 2005/06 Internal Service Funds Summary Projection
CENTRAL SERVICES
REVENUES
Inter-departmental Charges
Interest/Other
Retained EarninQs
TOTAL REVENUES
EXPENSES
Payroll & Fringes
Operating
Postage
Depreciation
Capital
TOTAL EXPENSES
Adopted As of Projected
FY 2005/06 Mar 31,2006 FY 2005/06
$733,793
4,000
54,750
$792,543
$254,822
14,302
27,375
$296,499
$704,491
25,302
54,750
$784,543
$326,544 $148,111 $318,544
291,631 105,797 291,631
170,000 104,223 170,000
4,368 1,575 4,368
0 0 0
$792,543 $359,706 $784,543
$0
($63,207)
($29,302)
21,302
o
($8,000)
($8,000)
o
o
o
o
($8,000)
$0 II
$0 I
FY 2005/06 Internal Service Funds Summary Projection
FLEET MANAGEMENT
REVENUES
Inter-departmental Charges
Sale of City Property
I nterestlOther
Motor Fuel Tax Refund
Retained Earnings
TOTAL REVENUES
EXPENSES
Payroll & Fringes
Operating
Fuel
Debt Service
Capital
TOTAL EXPENSES
Adopted As of Projected
FY 2005/06 Mar 31, 2006 FY 2005/06
$5,842,191 $3,235,444 $5,842,191
220,000 109,238 220,000
127,001 89,314 144,001
72,000 34,907 72,000
540,402 0 540,402
$6,801,594 $3,468,903 $6,818,594
$1,403,896 $591,038 $1,313,780
1,746,150 705,891 1,646,488
1,820,000 952,468 2,056,468
1,686,548 819,929 1,639,858
145,000 0 145,000
$6,801,594 $3,069,326 $6,801,594
$0
$17,000 II
$399,577
$0
o
17,000
o
o
$17,000
($90,116)
(99,662)
236,468
(46,690)
o
$0
$17,000 I
FY 2005/06 Internal Service Funds Summary Projection
INFORMATION TECHNOLOGY
REVENUES
Inter-departmental Charges
Other/Interest
Retained Earnings
TOTAL REVENUES
EXPENSES
Payroll & Fringes
Operating
Telephone
Depreciation
Debt Service
Capital
TOTAL EXPENSES
Adopted
FY 2005/06
As of
Mar 31, 2006
$9,591,245
69,678
2,408,800
$12,069,723
$4,795,623
44,952
1,250,494
$6,091,069
Projected
FY 2005/06
$9,591,245
90,678
2,355,460
$12,037,383
$3,914,816 $1,701,606 $3,659,014
3,046,702 1,012,505 3,046,702
1,049,000 283,653 1,049,000
1,085,789 542,895 1,085,789
517,956 242,023 617,956
2,455,460 1,250,494 2,355,460
$12,069,723 $5,033,176 $11,813,921
$0
$1,057,893
$223,4621 I
$223.4621
FY 2005/06 Internal Service Funds Summary Projection
PROPERTY MANAGEMENT
REVENUES
Inter-departmental Charges
Other/I nterest
Construction Projects
Retained Earninas
TOTAL REVENUES
EXPENSES
Payroll & Fringes
Operating
Depreciation
Capital
TOTAL EXPENSES
Adopted As of Projected
FY 2005/06 Mar 31,2006 FY 2005/06
$7,276,821 $3,563,914 $7,276,821
5,000 5,548 7,757
794,282 116,138 516,138
174,770 78,201 174,770
$8,250,873 $3,763,801 $7,975,486
$3,883,582 $1,712,883 $3,695,758
3,807,521 1,689,454 3,719,958
185,000 92,500 185,000
374,770 78,201 374,770
$8,250,873 $3,573,038 $7,975,486
$0
$190,763
$0
2,757
(278,144)
o
($275,387)
($187,824)
(87,563)
o
o
($275,387)
$0 II
$0 I
FY 2005/06 Internal Service Funds Summary Projection
RISK MANAGEMENT
REVENUES
Inter-departmental Charges
I nterestlOther
General Fund Contribution
Retained EarninQs
TOTAL REVENUES
EXPENSES
Operating
Administrative Fees
Non-Operating
TOTAL EXPENSES
$618,314 $272,886 $618,314
674,481 337,240 674,481
16,937,237 5,329,808 15,637,237
$18,230,032 $5,939,934 $16,930,032
$0 $1,965,546 $30,000 I I $30,000 I
Adopted As of Projected
FY 2005/06 Mar 31, 2006 FY 2005/06
$14,851,032 $7,082,679 $14,851,032
I 100,000 63,024 130,000
1,000,000 o. 1,000,000
2,279,000 759,777 979,000
$18,230,032 $7,905,480 $16,960,032
Proj - Adptd
Over/(Under
$0
30,000