HomeMy Public PortalAbout08 Required Supplmentary InformationCOMPREHENSIVE
ANNUAL
FINANCIAL REPORT
CITY OF RANCHO MIRAGE, CALIFORNIA
m
A
C
_;o
Z m
„v
o'n
:0C
Z m
Z
D
CITY OF RANCHO MIRAGE
Notes to Required Supplemental Information
Year ended June 30, 2005
(1) Budgetary Data
The City uses the following procedures in establishing the budgetary data reflected in the
financial statements:
(1) Before the beginning of the fiscal year the City Manager submits to the City
Council a proposed budget for the year commencing the following July 1.
(2) Public hearings are conducted to obtain taxpayer comments.
(3) The budget is subsequently adopted through passage of a resolution.
(4) All appropriated amounts are as originally adopted or as amended by the City
Council and lapse at year end, except for continuing appropriations for capital
proj ects.
(5) Original appropriations are modified by supplementary appropriations and
transfers among budget categories. The City Manager is authorized to transfer
appropriations within an object of a General Fund department and within total
fund appropriations for other funds. The City Council approves all other changes.
Individual amendments were not material in relation to the original
appropriations.
(6) The legal level for which expenditures are not to exceed appropriations is at the
fund level for all funds except the General Fund and at the object level for the
General Fund. The City classifies each General Fund expenditure into one of the
following three objects: personnel, operations and maintenance, and capital.
(7) Formal budgetary integration is employed as a management control device during
the year for the following funds which also have legally adopted annual budgets:
General, Special Revenue and Capital Projects Funds. Formal budgetary
integration is not employed for Debt Service Funds, except for the Redevelopment
Agency Debt Service Funds, because effective budgetary control is alternatively
achieved through debt indenture provisions.
(8) Budgets for General, Special Revenue, Redevelopment Agency Debt Service
Funds and Capital Projects Funds are adopted on a basis consistent with generally
accepted accounting principles, except advances from the General Fund to other
funds are budgeted as expenditures in the General Fund and as revenue in the
funds receiving the advances. Repayment of advances is budgeted as revenue in
the General Fund and as an expenditure in the funds repaying the advance.
97
CITY OF RANCHO MIRAGE
Notes to Required Supplemental Information
(Continued)
(2) Required Disclosures
The following funds reported expenditures in excess of appropriations:
Special Revenue Fund:
Low Cost Housing
Budget
$1,581,450
98
Variance -
Favorable
Actual (Unfavorable)
1,582,117 (667)
CITY OF RANCHO MIRAGE
BUDGETARY COMPARISON SCHEDULE
GENERAL FUND
Year ended June 30, 2005
Licenses and permits:
Business licenses
219,400
219,400
Variance with
Construction permits
1,507,000
1,357,000
Final Budget
Budgeted Amounts
Positive
Revenues:
Original
Final
Actual (Negative)
Taxes:
1,576,900
1,458,318 (118,582)
Charges for services:/
Property taxes
$ 775,500
872,800
1071964 199,164
Sales taxes
5,150,725
4,180,400
3:985:310--/(195,090)
Franchise taxes
932,000
932,000
970,997/ 38,997
Transient occupancy taxes
5,584,000
5,244,600
5,644,962--'400,362
Real property transfer taxes
690,000
690,000
691,7441/ 1,744
Licenses taxes
3,000,000
1,100,000
1,118,449 lino X0318,449
Total taxes
16,132,225
13,019,800
13,483,426 463,626
Intergovernmental:
Reimbursement from Non -Govt
-
J�-�kVv 4 `j['15I
Motor vehicle in -lieu
793,300
289,400
396,845 107,445
Other
100,000
838,600
1,110,498 271,898
Total intergovernmental
893,300
1,128,000
1,507,343 379,343
Licenses and permits:
Business licenses
219,400
219,400
216,912
Construction permits
1,507,000
1,357,000
(2,489�Dib"V-W+
1,241,0413 115,959)
Other
500
500
365 (135)
Total licenses and permits
1,726,900
1,576,900
1,458,318 (118,582)
Charges for services:/
�i L1,311)
Planning fees
120,000
140,000
154,306-10' 1,W'l4,306
Plan check fees
575,000
625,000
554,1701 (70,830)
Community facilities districts
1,157,000
1,369,600
1,321,306 (48,294)
X01 -4b�tD
Public works inspections and fees
365,000
503,000
674,181® 171,181
Reimbursement from State
34,000
49,700
49,680 (20)
Reimbursement from Non -Govt
-
-
287,160 7,160
010,050
Other
15,000
15,000
25,050J1� I-V
Total charges for services
2,266,000
2,702,300
3,065,853 363,553
Fines and forfeitures
17,000
17,000
29,364/ 12,364
Interest income
1,990,500
1,990,500
QD 2,048,718 ✓ 58,218
�� i5-iW)
Net increase (decrease) in
-
investment fair value
-
-
(236,053) (236,053)
Capital loan reimbursement
625,593
625,593
- (625,593)
Miscellaneous
100,000
100,000
94,673,/ (5,327)
Total revenues
$ 23,751,518
21,160,093
21,451,642 291,549
O �IJJ,_Vk -5jma i(4o1 1011
('Continued}
�,\z aK kwl
99
CITY OF RANCHO MIRAGE
BUDGETARY COMPARISON SCHEDULE
GENERAL FUND
(Continued)
City Clerk:
Personnel
507,011
507,011
451,331 55,680
Variance with
143,665
143,665
73,884 69,781
Capital
Final Budget
Expenditures:
Budgeted Amounts
Total city clerk
Positive
655,676
Original
Final
Actual
(Negative)
General government:
City council:
Personnel
$ 151,379
154,374
154,373
1
Operations and maintenance
42,200
45,080
39,894
5,186
Capital
5,000
5,000
-
5,000
Total city council
198,579
204,454
194,267
10,187
City Clerk:
Personnel
507,011
507,011
451,331 55,680
Operations and maintenance
143,665
143,665
73,884 69,781
Capital
5,000
5,000
- 5,000
Total city clerk
655,676
655,676
525,215 130,461
City manager:
Personnel
912,429
933,629
912,539 21,090
Operations and maintenance
55,310
55,310
49,139 6,171
Capital
750
750
- 750
Total city manager
968,489
989,689
961,678 28,011
City attorney:
Operations and maintenance 461,000 673,990 673,987 3
Total city attorney 461,000 673,990 673,987 3
Administration:
Personnel 331,721 340,206 340,203 3
Operations and maintenance 17,000 67,450 67,170 280
Total administration 348,721 407,656 407,373 283
Finance:
Personnel 374,171 374,921 374,918 3
Operations and maintenance 217,011 217,836 217,827 9
Total finance 591,182 592,757 592,745 12
(Continued)
100
CITY OF RANCHO MIRAGE
BUDGETARY COMPARISON SCHEDULE
GENERAL FUND
(Continued)
(Continued)
101
Variance with
Final Budget
Budgeted Amounts
Positive
Original
Final
Actual
(Negative)
Information services:
Personnel
$ 254,265
256,125
256,121
4
Operations and maintenance
197,432
197,432
162,903
34,529
Capital
35,269
35,269
29,848
5,421
Total information services
486,966
488,826
448,872
39,954
Information and marketing:
Operations and maintenance
1,153,317
1,163,317
1,061,301
102,016
Total information & marketing
1,153,317
1,163,317
1,061,301
102,016
General government:
Personnel
309,315
351,520
351,516
4
Operations and maintenance
824,409
891,074
750,502
140,572
Capital
74,931
74,931
14,821/
60,110
Total general government
1,208,655
1,317,525
1,116,839
z
200,686
Special programs:
Operations and maintenance
624,297
867,777
709,548
158,229
Total special programs
624,297
867,777
709,548
158,229
Planning:
Personnel
944,580
951,120
951,114
6
Operations and maintenance
578,165
518,165
472,384
45,781
Total planning
1,522,745
1,469,285
1,423,498
45,787
Building and safety:
Personnel
646,480
646,480
535,463
111,017
Operations and maintenance
200,608
200,608
157,732
42,876
Total building and safety
847,088
847,088
693,195
153,893
Mandated programs:
Operations and maintenance
384,863
384,863
241,812
143,051
Total mandated programs
384,863
384,863
241,812
143,051
Regional plan and implementation
Operations and maintenance
55,010
55,010
31,629
23,381
Total regional plan and
implementation
55,010
55,010
31,629
23,381
II
�fl(1,637,013)
Iuterfundreimbursements
(1,659,929)
(1,659,929)
(22,916)
Total general government
7,846,659
8,457,984
7,444,946
1,013,038
(Continued)
101
CITY OF RANCHO MIRAGE
BUDGETARY COMPARISON SCHEDULES
GENERAL FUND
(Continued)
Public safety:
Code compliance:
Personnel
Operations and maintenance
Total code compliance
Emergency services:
Operations and maintenance
Total emergency services
Police services:
Operations and maintenance
Capital
Total police services
Citizens Option for Public Safety (COPS)
Operations and maintenance
Capital
Total COPS
Law Enforcement Equipment
Operations and maintcnance
Capital
Total law enforcement equipment
Total public safety
Public works:
Buildings and landscaping:
Personnel
Operations and maintenance
Capital
Total buildings and landscaping
Variance with
Final Budget
Budgeted Amounts Positive
Original Final Actual e ative
$ 276,231
276,231
274,379
1,852
51,089
51,089
11,309
39,780
327,320
327,320
285,688
41,632
9,500 13,165 13,157 8
9,500 13,165 13,157 8
4,476,859 4,558,259 4,502,465 55,794
- 29,500 20,435 9,065
4,476,859 4,587,759 4,522,900 64,859
136,500
136,500
123,223
13,277
2,500
2,500
-
2,500
139,000
139,000
123,223
15,777
633,377
355,083
278,294
Capital
900
900
2,166
(1,266)
-
9,730
8,459
1,271
900
10,630
10,625
5
4,953,579
5,077,874
4,955,593
122,281
353,750
353,750
308,970 44,780
527,281
556,481
523,699 32,782
46,069
46,069
46,069 -
927,100
956,300
878,738 77,562
Street maintenance:
Personnel
458,144
461,654
461,646
8
Operations and maintenance
372,827
633,377
355,083
278,294
Capital
84,999
88,699
42,962
45,737
Total street maintenance
915,970
1,183,730
859,691
324,039
Engineering:
Personnel
1,071,082
1,085,882
1,085,855
27
Operations and maintenance
403,194
352,409
215,161
137,248
Total engineering
1,474,276
1,438,291
1,301,016
137,275
Total public works
$ 3,317,346
3,578,321
3,039,445
538,876
(Continued)
102
CITY OF RANCHO MIRAGE
BUDGETARY COMPARISON SCHEDULES
GENERAL FUND
Cultural and recreation:
Child Enrichment Center:
Operations and maintenance
Capital
Total summer recreation
Total cultural and recreation
Capital projects:
Capital improvements financed from
fund balance and license tax
General Fund Capital Projects
License Tax Fund Capital Projects
Total capital improvements
Total capital projects
Total expenditures
Excess (deficiency) of revenues over (under)
expenditures
Other financing sources:
Transfers in
Transfers out
Issuance of long-term debt
Total other financing sources
Net change in fund balance
(Continued)
Variance with
Final Budget
Budgeted Amounts Positive
Original Final Actual (Negative)
85,447
4,940
85,447
4,940
42,886 42,561
- 4,940
90,387
90,387
42,886 47,501
90,387
90,387
42,886 47,501
4,645,846
7,145,846
2,003,124
5,142,722
15,046,553
14,636,553
3,375,587
11,260,966
19,692,399
21,782,399
5,378,711
16,403,688
19,692,399
21,782,399
5,378,711
16,403,688
35,900,370
38,986,965
20,861,581
18,125,384
(12,148,852)
(17,826,872)
590,061
18,416,933
-
-
5,851,673
5,851,673
(1,935,603)
(4,479,981)
��� (4,224,729)
255,252
-
2,500,000
y -
(2,500,000)
(1,935,603)
(1,979,981)
1,626,944
3,606,925
(14,084,455)
(19,806,853)
2,217,005
22,023,858
Fund balance, beginning of year (as restated)
68,874,618
68,874,618
68,874,618 -
Fund balance, end of year
$ 54,790,163
49,067,765
71,091,623 22,023,858
103
CITY OF RANCHO MIRAGE
BUDGETARY COMPARISON SCHEDULE
LIBRARY SPECIAL REVENUE FUND
Revenues:
Intergovernmental
Fines and forfeitures
Interest income
Miscellaneous
Total revenues
Expenditures:
Current:
Cultural and recreation
Total expenditures
Excess (deficiency)
of revenues over
expenditures
Other financing sources (uses):
Transfers in
Transfers out
Total other financing
sources (uses)
Total change in fund balances
Fund balances, beginning of year
Fund balances (deficit), end of year
Year ended June 30, 2005
Budgeted Amounts
Original Final
Variance with
Final Budget
Positive
Actual (Negative)
104,000
124,000
141,726
17,726
33,000
38,000
40,225
2,225
40,000
40,000
40,172
172
56,600
76,600
107,845
31,245
233,600 278,600 329,968 51,368
1,850,497
1,875,497
1,704,385
171,112
1,850,497
1,875,497
1,704,385
171,112
(1,616,897) (1,596,897) (1,374,417) 222,480
1,601,955 1,601,955 1,708,624 106,669
- (243,286) (389,220) (145,934)
1,601,955 1,358,669 1,319,404 (39,265)
(14,942) (238,228) (55,013) 183,215
1,837,761 1,837,761 1,837,761 -
$ 1,822,819 1,599,533 1,782,748 183,215
104
CITY OF RANCHO MIRAGE
BUDGETARY COMPARISON SCHEDULE
FIRE TAX SPECIAL REVENUE FUND
Year ended June 30, 2005
Expenditures:
Current:
Public safety 3,390,316 3,658,316 3,625,893 32,423
Total expenditures 3,390,316 3,658,316 3,625,893 32,423
Excess (deficiency)
of revenues over
expenditures (3,370,316) (3,554,716) (3,406,628) 148,088
Other financing sources (uses):
Transfers in
3,315,000
3,252,000
Variance with
88,732
Final Budget
Budgeted Amounts
Positive
Orijzinal Final
Actual
e ative
Revenues:
3,340,732
88,732
Intergovernmental
$ - 83,600
83,543
(57)
Charges for services
20,000 20,000
21,580
1,580
Interest income
- -
11,911
11,911
Miscellaneous
- -
102,231
102,231
Total revenues
20,000 103,600
219,265
115,665
Expenditures:
Current:
Public safety 3,390,316 3,658,316 3,625,893 32,423
Total expenditures 3,390,316 3,658,316 3,625,893 32,423
Excess (deficiency)
of revenues over
expenditures (3,370,316) (3,554,716) (3,406,628) 148,088
Other financing sources (uses):
Transfers in
3,315,000
3,252,000
3,340,732
88,732
Total other financing
sources (uses)
3,315,000
3,252,000
3,340,732
88,732
Total change in fund balance
(55,316)
(302,716)
(65,896)
236,820
Fund balances, beginning of year (as restated)
283,447
283,447
283,447
-
Fund balances (deficit), end of year
$ 228,131
$ (19,269)
217,551
236,820
105
CITY OF RANCHO MIRAGE
BUDGETARY COMPARISON SCHEDULE
HOUSING AUTHORITY SPECIAL REVENUE FUND
Year ended June 30, 2005
Expenditures:
Current:
General government 2,403,924 4,000,889 4,176,411 (175,522)
Capital projects 13,801,596 17,020,115 1,986,573 15,033,542
Total expenditures 16,205,520 21,021,004 6,162,984 14,858,020
Excess (deficiency)
of revenues over
expenditures (15,423,520) (20,239,004) (5,327,450) 14,911,554
Other financing sources (uses):
Transfers in 3,636,369 3,636,369 3,669,336 32,967
Transfers out (245,787) (245,787) (32,787) 213,000
Total other financing
sources (uses) 3,390,582 3,390,582 3,636,549 245,967
Total change in fund balance (12,032,938) (16,848,422) (1,690,901) 15,157,521
Fund balances, beginning of year
17,414,866
17,414,866
17,414,866 -
Variance with
$ 5,381,928
$ 566,444
15,723,965 15,157,521
Final Budget
Budgeted Amounts
Positive
Original
Final
Actual
(Negative)
Revenues:
Licenses and permits
$ 5,000
5,000
5,119
119
Interest income
400,000
400,000
349,786
(50,214)
Net increase (decrease) in
investment fair value
-
-
(41,853)
(41,853)
Miscellaneous
377,000
377,000
522,482
145,482
Total revenues
782,000
782,000
835,534
53,534
Expenditures:
Current:
General government 2,403,924 4,000,889 4,176,411 (175,522)
Capital projects 13,801,596 17,020,115 1,986,573 15,033,542
Total expenditures 16,205,520 21,021,004 6,162,984 14,858,020
Excess (deficiency)
of revenues over
expenditures (15,423,520) (20,239,004) (5,327,450) 14,911,554
Other financing sources (uses):
Transfers in 3,636,369 3,636,369 3,669,336 32,967
Transfers out (245,787) (245,787) (32,787) 213,000
Total other financing
sources (uses) 3,390,582 3,390,582 3,636,549 245,967
Total change in fund balance (12,032,938) (16,848,422) (1,690,901) 15,157,521
Fund balances, beginning of year
17,414,866
17,414,866
17,414,866 -
Fund balances (deficit), end of year
$ 5,381,928
$ 566,444
15,723,965 15,157,521
106
CITY OF RANCHO MIRAGE
BUDGETARY COMPARISON SCHEDULE
LOW COST HOUSING SPECIAL REVENUE FUND
Revenues:
Interest income
Net increase (decrease) in investment
fair value
Total revenues
Expenditures:
Current:
General government
Debt service:
Principal
Interest
Total expenditures
Excess (deficiency) of
revenues over expenditures
Other financing sources (uses):
Transfers in
Transfers out
Total other financing
sources (uses)
Total change in fund balances
Fund balances, beginning of year
Fund balances (deficit), end of year
YEAR ENDED JUNE 30, 2005
Budgeted Amounts
Oriyzinal Final
$ 909,200 909,200
Variance with
Final Budget
Positive
Actual (Negative)
1,045,450 136,250
- - (32,813) (32,813)
909,200 909,200 1,012,637 103,437
94,137 94,156 94,823 (667)
1,487,294 1,487,294 1,487,294 -
1,581,431 1,581,450 1,582,117 (667)
(672,231) (672,250) (569,480) 102,770
5,004,800 5,004,800 5,242,085 237,285
(3,423,369) (3,670,003) (3,669,336) 667
1,581,431 1,334,797 1,572,749 237,952
909,200 662,547 1,003,269 340,722
35,725,547 35,725,547 35,725,547 -
$ 36,634,747 36,388,094 36,728,816 340,722
i
107
801