LTC 033-2006 Analysis of Budget to Preliminary Actual Revenues & Expenses for FY End
lD
~
MIAMI BEACH
OFFICE OF THE CITY MANAGER
NO. LTC # 033-2006
LETTER TO COMMISSION
(.'J
--(
o
a'
-.,
rr1
ro
I
w
A~)
. ';j
FROM:
Mayor David Dermer and Members Ojh; City Commission
Jorge M. Gonzalez, City Manager '<Ivf 4- ~
February 1, 2006
""MI
..r;;,t.c",iIl
TO:
DATE:
/F': -0
....,.)
-..;.,...
.~-
';~
(\1
SUBJECT: ANALYSIS OF BUDGET TO PRELIMINARY ACTUAL REVENUES AND EXPENSES FOR THE f1SCA~
YEAR ENDING SEPTEMBER 30, 2005, FOR GENERAL, ENTERPRISE, AND INTERNAL SERVICE FUND~ ~
The Purpose of this LTC is to provide the preliminary actual revenue and expenses for the
Fiscal Year ending September 30, 2005. 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
$4,040,294 (2.4%) in the General Fund which I recommend be used to increase our capital
reserve fund.
It must 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,2005, available in May 2006. However, typically,
any changes are minor in nature.
I. General Fund Overview
At this writing, operating revenues received from all sources by the General Fund total
$172,490,949, which is $4,143,456 more than the amended budget of $168,347,493.
Operating expenditures incurred by all departments in the General Fund total $168,450,655,
which is $103,162 more than the amended budget of $168,347,493. Summing the revenue
surplus of $4,143,456 and the overexpenditures of $103,162 equals a budget surplus of
$4,040,294 (including open encumbrances of $1 ,419,129). 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 summary of preliminary General Fund Revenues and Expenditures as of September 30,
2005 is as follows:
General Fund
Revenues
Expenditures
Surplus/(Deficit)
Amended Budget
FY 04/05
$168,347,493
168.347.493
$ 0
Preliminary Actual/Ene
as of 01/20/06
$172,490,949
168.450.655
$ 4,040,294
Budget! Actual
Over/(Under)
$4,143,456
103,162
$4,040,294
Note: * Includes current year encumbrancestotaling $1,419,129.
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, 2005, revenues collected equal $172,490,949 and represent an
excess of $4,143,456 or 2.5% of the amended budget
1. Ad Valorem Property Taxes - Year-end collections of $78,262,606 are less than
1 % over the budget creating an excess of $136,446.
2. Other Taxes - This category includes franchise and utility taxes on services which
are sensitive to local economic indicators. Based on actual collections of
$20,815,659 an excess of$1,247,059 or 6.4% 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 $13,666,686, an excess of $2,220,055 or
19.4% resulted at year-end. 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, convention development, gas and sales taxes. Based on actual collections
of $1 0,429,490, a net shortfall of$687,510 or6.2% resulted year-end. This is mainly
due to the transfer of convention development tax from the General Fund where it
was previously appropriated to support the Botanical Gardens and Bass Museum to
the Convention Center Fund for their operating and capital needs.
5. Fines and Forfeits - This category includes traffic citations, and code and fire
violation fees. Based on actual collections of $2,564,21 0, an excess of$1,160,210 or
82.6% resulted at year-end. This is due to an increase in code enforcement violation
revenues and parking fines issued by the Police Department that were previously
recorded in the Parking Fund.
6. Interest - This category includes interest income from City investments. Based on
actual collections of $3,153,582, an excess of $316,702 or 11.2% resulted at year-
end. This is primarily due to rising interest rates during the year.
General Fund Operating Expenditures
As of September 30,2005, actual expenditures of $168,450,655 were less than 1% over
budget or $103,162. 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
Amended Budget
FY 04/05
$ 1,260,879
Preliminary ActuallEnc*
as of 01/20/06
$ 1,181 ,430
Budget!Actual
Over/(Under)
$ ( 79,449)
2.
City Manager
Amended Budget
FY 04/05
$ 1,888,209
Preliminary ActuallEnc*
as of 01/20/06
$ 1,864,944
Preliminary ActuallEnc*
as of 01/20/06
$ 167,019
Budget!Actual
Over/(Under)
$ ( 23,265)
Budget! Actual
Over/(Under)
$ (105,569)
The Communications Department is expected to spend 61.3% of its budget with a year-end
surplus of $105,569 due primarily to savings in operating costs from deferral of producing
and distributing the City's newsletter to Fiscal Year 2005/2006
3.
Communications
Amended Budget
FY 04/05
$ 272,588
Office of Budget & Perbrmance Improvement
Amended Budget Preliminary ActuallEnc*
FY 04/05 as of 01/20/06
$ 1,569,053 $ 1,412,295
Budget! Actual
Over/(Under)
$ (156,758)
This department is expected to spend 90% of its budget with a year-end surplus of
$156,758 due primarily to vacant positions and savings in operating expenses.
4.
5.
Finance
Amended Budget
FY 04/05
$ 3,460,126
Preliminary ActuallEnc*
as of 01/20/06
$ 3,541,982
Preliminary ActuaVEnc*
as of 01/20/06
$ 697,926
Preliminary Actual/Enc*
as of 01/20/06
$ 1,202,669
Budget/Actual
Over/(Under)
$ 81,856
Budget!Actual
Over/(Under)
$ ( 9,073)
Budget/Actual
Over/(Under)
$(191,310)
This department is expected to spend 86.3% of its budget with a year-end surplus of
$191,310 due primarily to vacant positions and savings in operating expenses.
6.
Procurement
Amended Budget
FY 04/05
$ 706,999
Preliminary ActuallEnc*
as of 01/20/06
$ 198,727
Preliminary Actual/Enc*
as of 01/20/06
$ 1,380,639
Budget/Actual
Over/(Under)
$ 5,395
Budget!Actual
Over/(Under)
$ (147,015)
This department is expected to spend 90.4% of its budget with a year-end surplus of
$147,015 due primarily to vacant positions and savings in operating expenses.
7.
Human Resources
Amended Budget
FY 04/05
$ 1,393,979
8.
Labor Relations
Amended Budget
FY 04/05
$ 193,332
9.
City Clerk
Amended Budget
FY 04/05
$ 1,527,654
10. City Attorney
Amended Budget
FY 04/05
$ 3,438,595
11. Economic Development
Amended Budget
FY 04/05
$ 854,064
12. Building
Amended Budget
FY 04/05
$ 5,482,359
Preliminary ActuallEnc*
as of 01/20/06
$ 3,436,885
Preliminary ActuallEnc*
as of 01/20/06
$ 770,930
Preliminary ActuallEnc*
as of 01/20/06
$ 5,616,733
Budget! Actual
Over/(Under)
$( 1,710)
Budget/Actual
Over/(Under)
$ (83,134)
Budget/Actual
Over/(Under)
$ 134,374
This department is expected to spend 2.5% over its budget in the amount of $134,374. 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.
13. Planning
Amended Budget
FY 04/05
$ 2,615,594
Preliminary ActuallEnc*
as of 01/20/06
$ 2,408,122
Budget/Actual
Over/(Under)
$ (207,472)
This department is expected to spend 92% of its budget with a year-end surplus of
$207,472 due primarily to vacant positions and savings in operating expenses.
14. Tourism & Cultural Development
Amended Budget Preliminary ActuallEnc*
FY 04/05 as of 01/20/06
$ 2,397,835 $ 1,981,530
Budget/Actual
Over/(Under)
$ (416,305)
This department is expected to spend 82.6% of its budget with a year-end surplus of
$416,305 due primarily to the delay in opening of the Colony Theatre and to savings in
operating expenses from the first year of operations of the Byron/Carlyle Theater.
15. Neighborhood Services
Amended Budget
FY 04/05
$ 3,730,078
16. Parks and Recreation
Amended Budget
FY 04/05
$21,556,169
Preliminary ActuallEnc*
as of 01/20/06
$ 3,776,395
Preliminary ActuallEnc*
as of 01/20/06
$21,302,199
Budget/Actual
Over/(Under)
$ 46,317
Budget! Actual
Over/(Under)
$ (253,970)
The Parks and Recreation Department is expected to spend 98.9% of its budget with a
year-end surplus of $253,970 due primarily to vacant positions and savings in operating
expenses
17. Public Works
Amended Budget
FY 04/05
$ 6,095,758
Preliminary ActuallEnc*
as of 01/20/06
$ 6,066,857
Budget/Actual
Over/(Under)
$ (28,901)
18. Capital Improvement Program
Amended Budget Preliminary ActuallEnc*
FY 04/05 as of 01/20/06
$ 2,784,730 $ 2,378,227
Budget/Actual
Over/(Under)
$ (406,503)
This department is expected to expend 85.4% of its budget with a year-end surplus of
$406,503 due primarily to unfilled vacant positions throughout the year.
19. Police
Amended Budget
FY 04/05
$61,386,186
Preliminary ActuallEnc*
as of 01/20/06
$62,128,794
Budget/Actual
Over/(Under)
$ 742,608
The Police Department is expected to spend 1.2% over its budget in the amount of
$742,608 due primarily to higher than anticipated overtime usage.
20. Fire
Amended Budget
FY 04/05
$36,364,606
Preliminary ActuallEnc*
as of 01/20/06
$36,658,387
Budget!Actual
Over/(Under)
$ 293,781
This department is projected to spend less than 1 % over its budget in the amount of
$293,781. This is primarily due to higher than anticipated overtime usage.
21. Citywide Accounts
Amended Budget
FY 04/05
$ 8,021,630
Preliminary ActuallEnc*
as of 01/20/06
$ 8,794,232
Budget/Actual
Over/(Under)
$ 909.265
The Citywide Accounts are expected to expend 11.3% over their budget in the amount of
$909,265. This is due primarily to payment of termination fees on pension bonds that were
previously approved in July 2005.
Note: * Includes encumbrances
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,
Parking, Sanitation, and Sewer Funds will require a budget amendment.
The Convention Center Fund overspent its budget by a net of $680,000 due to higher
personnel and electricity expenses associated with a higher volume of events. These
expenses will be offset by revenues from a higher than previously anticipated volume of
events. In addition, this fund received an influx in convention development tax budgeted in
the General Fund for its operating and capital needs.
The Parking Fund overspent its budget by a net of $330,000 due primarily to higher costs
associated with capital acquisitions. These costs will be offset by higher than anticipated
revenues from Meters.
The Sanitation Fund overspent its budget by a net of $903,000 due to cleanup expenses in
the aftermath of Hurricane Katrina. These expenses will be offset by higher than anticipated
revenues from Sanitation and Roll-Off Fees.
The Sewer Fund also overspent its budget by a net of $780,000 due to higher costs for
sewer treatment. 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".
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, the Information Technology, Property
Management, and Risk Management funds operated within budget or at a surplus.
However, the Central Services and Fleet Management Funds overspent their budgets and
will require a budget amendment
The Central Services Fund overspent its budget by $34,000 due to higher operating
expenses. These expenses will be offset by higher than anticipated revenues from outside
users and from Retained Earnings.
The Fleet Management Fund also overspent its budget by $350,000 due to higher fuel
costs. These will be offset by higher charges to user departments. 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, 2005, is presented as part of our on-going
efforts to keep the Commission informed of the status of the FY 04/05 Budget.
A Resolution to adopt the third amendment to the General, Enterprise and Internal Service
fund Budgets for Fiscal Year 2004/05 Budget to appropriate funds to amend certain
budgets will be discussed at the February 8, City Commission meeting.
JMG/KGB/JC
Attachments A-C
ATTACHMENT A
FY 2004/05 General Fund Operating Summary Projection
REVENUES
Ad Valorem Taxes
Millage-Capital Renewal & Replace.
Other Taxes
Licenses and Permits
Intergovernmental
Charges for Services
Fines and Forfeits
Interest Earnings
Rents and Leases
Miscellaneous
Other - Resort Tax contribution
Other - Non Operating revenues
Fund Balance
TOTAL REVENUES
EXPENDITURES
Mayor and Commission
City Manager
Communications
Office of Budget & Perf Improve.
Finance
Procurement
Human Resources
Labor Relations
City Clerk
City Attorney
Economic Development
Building
Planning
Tourism & Cultural Development
Neighborhood Services
Parks and Recreation
Public Works
Capital Improvement Projects
Police
Fire
Citywide Accounts
Citywide Accounts-Hurricanes
Citywide Acc.-Term fee Pension Bds
Citywide Accounts-Normandy Shore
Millage-Capital Renewal & Replace.
TOTAL EXPENDITURES
Amended
FY 2004/05
Preliminary
FY 2004/05
$ 78,126,160 $ 78,262,606
1,347,070 1,347,070
19,568,600 20,815,659
11,446,631 13,666,686
11,117,000 10,429,490
6,141,136 6,174,594
1,404,000 2,564,210
2,836,880 3,153,582
2,679,145 2,658,679
6,409,227 6,419,452
18,928,608 18,928,609
8,165,421 8,070,312
177,615 0
$ 168,347,493 $ 172,490,949
$ 1,260,879 $ 1,181,430
1,888,209 1,864,944
272,588 167,019
1,569,053 1,412,295
3,460,126 3,541,982
706,999 697,926
1,393,979 1,202,669
193,332 198,727
1,527,654 1,380,639
3,438,595 3,436,885
854,064 770,930
5,482,359 5,616,733
2,615,594 2,408,122
2,397,835 1,981,530
3,730,078 3,776,395
21,556,169 21,302,199
6,095,758 6,066,857
2,784,730 2,378,227
61,386,186 62,128,794
36,364,606 36,658,387
7,884,967 7,431,771
0 112,461
0 1,250,000
136,663 136,663
1,347,070 1,347,070
$ 168,347,493 $ 168,450,655
$ 136,446
0
1,247,059
2,220,055
(687,510)
33,458
1,160,210
316,702
(20,466)
10,225
1
(95,109)
(177,615)
$ 4,143,456
$ (79,449)
(23,265)
(105,569)
(156,758)
81,856
(9,073)
(191,310)
5,395
(147,015)
(1,710)
(83,134)
134,374
(207,472)
(416,305)
46,317
(253,970)
(28,901 )
(406,503)
742,608
293,781
(453,196)
112,461
1,250,000
0
0
$ 103,162
1$
o $
4,040,2941 I $ 4,040,2941
ATTACHMENT B
FY 2004105 Enterprise Fund Operating Summary
CONVENTION CENTERlTOPA
REVENUES
CHARGES FOR SERVICES
Rents and Leases
Concessions
Telephones
Electrical Income
Services
Miscellaneous and Other
Subtotal
OTHER
Convention Development Tax
Interest Earnings
Retained Earnings
Subtotal
TOTAL REVENUES
EXPENSES
Payroll and Fringes
Operating
Electricity
Management Fees to GF
Depreciation
Capital
TOTAL EXPENSES
Amended
FY 2004/05
$ 4,632,970 $ 4,759,235
1,414,988 1,772,209
332,887 332,569
985,513 1,045,646
454,736 573,530
577,430 687,518
$ 8,398,524 $ 9,170,707
$ 3,060,000 $ 4,500,000
38,850 64,769
3,075,000 2,937,976
$ 6,173,850 $ 7,502,745
$ 14,572,374 $ 16,673,452
$ 4,816,082 $ 5,178,090
4,786,692 4.787,618
1,154,000 1,606,578
740,600 740,600
3,075,000 2,937,976
0 0
$ 14,572,374 $ 15,250,862
1$
1,422,590 II $
o $
$ 126,265
357,221
(318)
60,133
118,794
110,088
$ 772,183
$ 1,440,000
25,919
(137,024\
$ 1,328,895
$ 2,101,078
$ 362,008
926
452,578
0
(137,024)
0
$ 678,488
1,422,590 I
FY 2004/05 Enterprise Fund Operating Summary
PARKING
REVENUES
CHARGES FOR SERVICES
Meters
Parking Citations
Attended Parking
Permits
Preferred Lot
Garages
Space Rental
Valet
Towina Fees
Subtotal
OTHER
Interest Earnings
Retained Earnings
Miscellaneous
Subtotal
TOTAL REVENUES
EXPENSES
Payroll & Fringes
Operating
Management Fees to GF
Depreciation
Contributions to ElectrowavelTransp.
Debt Service
Capital
TOTAL EXPENSES
EXCESS OF REVENUES OVER/
(UNDER EXPENSES
Amended
FY 2004/05
$ 10,656,626 $ 11,433,113
3,217,495 3,035,965
1,676,500 2,003,942
623,039 765,014
580,000 586,790
3,488,500 4,205,507
379,600 449,885
390,000 417,017
150,000 174,416
$ 21,161,760 $ 23,071,649
$ 300,000 $ 743,930
163,505 0
104,930 (204,764)
$ 568,435 $ 539,166
$ 21,730,195 $ 23,610,815
$ 5,932,492 $ 5,735,590
7,404,387 7,539,593
2,433,400 2,433,400
1,633,409 1,488,838
1,600,000 1,780,045
2,186,106 1,598,436
540,401 1 ,483,423
$ 21,730,195 $ 22,059,325
1$
1,551,490 II $
o $
$ 776,487
(181,530)
327,442
141,975
6,790
717,007
70,285
27,017
24,416
$ 1,909,889
$ 443,930
(163,505)
(309,694)
$ (29,269)
$ 1,880,620
$ (196,902)
135,206
0
(144,571 )
180,045
(587,670)
943,022
$ 329,130
1,551,490 I
FY 2004/05 Enterprise Fund 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
Violations/Fines
Subtotal
OTHER
Interest Earnings/Other
Retained Earnings
Stormwater Fund Contribution
Subtotal
TOTAL REVENUES
EXPENSES
Payroll & Fringes
Operating
Garbage Contracts
Management Fees to GF
Depreciation
Debt Service - Loan Program
Capital
TOTAL EXPENSES
EXCESS OF REVENUES OVER/
UNDER) EXPENSES
Amended
FY 2004/05
$ 2,946,236 $ 3,434,908
1,879,452 1,948,546
238,243 251,219
20,400 51,668
357,875 779,918
663,093 716,426
724,461 768,911
50,000 59,505
$ 6,879,760 $ 8,011,101
$ 430,437 $ 408,502
112,449 0
381,542 531,542
$ 924,428 $ 940,044
$ 7,804,188 $ 8,951,145
$ 3,923,475 $ 3,232,675
1,336,866 2,850,342
1,883,969 1,983,557
264,500 264,500
195,378 255,135
150,000 15,637
50,000 104,639
$ 7,804,188 $ 8,706,485
1$
244,660 II $
o $
$ 488,672
69,094
12,976
31,268
422,043
53,333
44,450
9,505
$ 1,131,341
$ (21,935)
(112,449)
150,000
$ 15,616
$ 1,146,957
$ (690,800)
1,513,476
99,588
0
59,757
(134,363)
54,639
$ 902,297
244,660 I
FY 2004/05 Enterprise Fund Operating Summary
WATER OPERATIONS
REVENUES
CHARGES FOR SERVICES
Water Sales
Firelines
Water Connection Fees
Water Tappinq
Subtotal
OTHER
Interest Earnings
Miscellaneous
Retained Earninqs
Subtotal
TOTAL REVENUES
EXPENSES
Payroll & Fringes
Operating
Water Purchase
Management Fees to GF
DERM Fee
Depreciation
Debt Service
Capital
TOTAL EXPENSES
Amended
FY 2004/05
$ 18,377,000 $ 19,230,455
100,000 136,384
5,000 1,963
200,000 228,963
$ 18,682,000 $ 19,597,765
$ 10,000 $ 36,934
500,000 561,562
969,399 0
$ 1,479,399 $ 598,496
$ 20,161,399 $ 20,196,261
$ 3,251,088 $ 3,095,161
2,299,203 2,712,440
6,584.292 6,733,076
1,673,843 1,673,843
1,350,000 1,494,653
660,000 656,885
2,899,574 2,426,082
1,443,399 1,060,584
$ 20,161,399 $ 19,852,724
1$
343,53711 $
o $
$ 853,455
36,384
(3,037)
28,963
$ 915,765
$ 26,934
61,562
(969,399)
$ (880,903)
$ 34,862
$
$
343,5371
FY 2004/05 Enterprise Fund Operating Summary
SEWER OPERATIONS
REVENUES
CHARGES FOR SERVICES
Sewer User Fees
Sewer Connection Fees
Sewer Fees-Cities
Subtotal
OTHER
Interest Earnings
Miscellaneous
Retained Earnings
Subtotal
TOTAL REVENUES
EXPENSES
Payroll & Fringes
Operating
Sewer Treatment
Management Fees to GF
DERM Fee
Depreciation
Debt Service
Capital
TOTAL EXPENSES
EXCESS OF REVENUES OVERt
(UNDER) EXPENSES
Amended
FY 2004/05
$ 23,691,000 $ 25,735,571
65,000 58,696
2,200,000 2,390,103
$ 25,956,000 $ 28,184,370
$ 24,000 $ 88,606
530,000 565,503
343,433 0
$ 897,433 $ 654,109
$ 26,853,433 $ 28,838,479
$ 1,979,428 $ 2,054,830
2,552,434 2,893,789
13,843,500 14,906,131
1,388,957 1,388,957
1,737,750 1,789,189
1,080,000 1,078,282
3,507,931 2,965,211
763,433 552,950
$ 26,853,433 $ 27,629,339
1$
1,209,140 II $
o $
$ 2,044,571
(6,304)
190,103
$ 2,228,370
$ 64,606
35,503
(343,433)
$ (243,324\
$ 1,985,046
$ 75,402
341,355
1,062,631
0
51,439
(1,718)
(542,720)
(210,483)
$ 775,906
1,209,140 I
FY 2004/05 Enterprise Fund Operating Summary
STORMWATER
REVENUES
Stormwater Fees
Interest Earnings
Retained Earnings/Other
TOTAL REVENUES
EXPENSES
Payroll & Fringes
Operating
Contribution Sanitation
Management Fees to GF
Depreciation
Debt Service
Capital
TOTAL EXPENSES
Amended
FY 2004/05
$ 7,970,000 $ 8,256,473 $ 286,473
60,000 150,936 90,936
173,065 58,006 (115,059)
$ 8,203,065 $ 8,465,415 $ 262,350
$ 1,213,532 $ 1,167,019
1,536,426 1,370,078
381,542 381,542
264,500 264,500
130,000 115,786
3,575,000 3,561,586
1,102,065 693,903
$ 8,203,065 $ 7,554,414
1$
o $
911,001 11$
$ (46,513)
(166,348)
0
0
(14,214)
(13,414)
(408,162)
$ (648,651)
911,001 I
ATTACHMENT C
FY 2004/05 Internal Service Funds Operating Summary
CENTRAL SERVICES
REVENUES
Inter-departmental Charges
Charges to Outside Users
Interest Earnings
Retained Earnings
TOTAL REVENUES
EXPENSES
Payroll & Fringes
Operating
Postage
Depreciation
Capital
TOTAL EXPENSES
Amended
FY 2004/05
$ 697,066 $ 684,099
0 23,748
1,500 3,119
54,750 75,426
$ 753,316 $ 786,392
$ 302,078 $ 314,165
289,484 295,586
155,610 173,435
6,144 3,206
0 0
$ 753,316 $ 786,392
1$
o $
Variance
Over/(Under
$ (12,967)
23,748
1,619
20,676
$ 33,076
$ 12,087
6,102
17,825
(2,938)
0
$ 33,076
o II $
01
FY 2004105 Internal Service Funds Operating Summary
PROPERTY MANAGEMENT
REVENUES
Inter-departmental Charges
Other/Interest Earnings
Construction Projects
Retained EarninCls
TOTAL REVENUES
EXPENSES
Payroll & Fringes
Operating
Depreciation
Capital
TOTAL EXPENSES
Amended
FY 2004/05
$ 6,609,649 $ 7,129,751
5,000 (3,860)
634,737 233,665
253,050 252,705
$ 7,502,436 $ 7,612,261
$ 3,460,671 $ 3,519,123
3,603,715 3,497,169
185,000 242,457
253,050 232,705
$ 7,502,436 $ 7,491,454
1$
120.80711 $
o $
$
520,102
(8,860)
(401,072)
(345)
109,825
$
$
$
120,8071
FY 2004105 Internal Service Funds Operating Summary
INFORMATION TECHNOLOGY
REVENUES
Inter-departmental Charges
Other/Interest Earnings
Loan Proceeds
Retained Earnings
TOTAL REVENUES
EXPENSES
Payroll & Fringes
Operating
Telephone
Depreciation
Debt Service
Capital
TOTAL EXPENSES
Amended
FY 2004/05
$ 8,516,394 $ 9,008,958
75,377 33,770
2,777,507 1,665,046
3,871,041 4,808,179
$ 15,240,319 $ 15,515,953
$ 3,497,803 $ 3,312,775
2,878,431 2,695,482
1,317,474 1,019,372
1,085,789 1,093,511
249,426 222,806
6,211,396 6,473,225
$ 15,240,319 $ 14,817,171
1$
698,78211 $
o $
$ 492,564
(41,607)
(1,112,461)
937,138
$ 275,634
$ (185,028)
(182,949)
(298,102)
7,722
(26,620)
261,829
$ (423,148\
698,7821
FY 2004/05 Internal Service Funds Operating Summary
FLEET MANAGEMENT
REVENUES
Inter-departmental Charges
Sale of City Property
Other/Interest Earnings
Motor Fuel Tax Refund
Retained Earnings
TOTAL REVENUES
EXPENSES
Payroll & Fringes
Operating
Fuel
Debt Service
Capital
TOTAL EXPENSES
EXCESS OF REVENUES OVER/
UNDER) EXPENSES
Amended
FY 2004/05
$ 5,166,317 $ 5,779,566
220,000 237,651
123,321 119,106
85,000 70,204
77,500 43,276
$ 5,672,138 $ 6,249,803
$ 1,226,440 $ 826,382
1,798,252 2,014,759
1,278,800 1,763,624
1,291,146 1,370,597
77,500 43,276
$ 5,672,138 $ 6,018,638
1$
231,16511 $
o $
$ 613,249
17,651
(4,215)
(14,796)
(34,224)
$ 577,665
$ (400,058)
216,507
484,824
79,451
(34,224)
$ 346,500
231,1651
FY 2004/05 Internal Service Funds Operating Summary
Amended
RISK MANAGEMENT FY 2004/05
REVENUES
Inter-departmental Charges $ 13,243,922 $ 14,968,959 $
Other/Interest Earnings 100,000 28,758
Retained Earninos 2,279,000 0
TOTAL REVENUES $ 15,622,922 $ 14,997,717 $
EXPENSES
Operating $ 1,428,841 $ 1,079,606 $ (349,235)
Administrative Fees 674,481 674,481 0
Non-OperatinQ 13,519,600 12,978,069 (541,531)
TOTAL EXPENSES $ 15,622,922 $ 14,732,156 $ (890,766)
1$ 0 $ 265,561 I 1$ 265,561 I