HomeMy Public PortalAbout07 Required Supplementary InformationCOMPREHENSIVE
ANNUAL
FINANCIAL REPORT
CITY OF RANCHO MIRAGE, CALIFORNIA
CITY OF RTIYCjO MIRAGE
(11 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
projects.
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.
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 (including the Joint Powers
Financing Authority Debt Service Fund), except for the Redevelopment Agency
Debt Service Funds, because effective budgetary control is alternatively achieved
through debt indenture provisions.
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.
(5)
(7)
(
CITY OF RANCHO MIRAGE
Notes to Required Supplemental Information
Year ended June 30, 2010
93
Revenues:
Taxes:
Property taxes
Sales taxes
Franchise taxes
Transient occupancy taxes
Real property transfer taxes
Licenses taxes
Total taxes
Intergovernmental:
Motor vehicle in -lieu
Other
Total intergovernmental
Licenses and permits:
Business licenses
Construction permits
Other
Total licenses and permits
Charges for services:
Planning fees
Plan check fees
Developer fee
Public works inspections and fees
Reimbursement from State
Reimbursement from Non -Govt
Total charges for services
Fines and forfeitures
Interest income
Net increase (decrease) in
investment fair value
Miscellaneous
Total revenues
CITY OF RANCHO MIRAGE
BUDGETARY COMPARISON SCHEDULE
GENERAL FUND
Year ended June 30, 2010
Budgeted Amounts
Original
$ 3,085,000
3,971,250
1,275,000
4,128,750
175,000
50,000
12,685,000
35,000
132,300
167,300
175,000
300,000
26,000
501,000
150,000
150,000
572,000
304,980
2.632,000
3,808,980
44,000
2,301,000 2,101,000 2,116,636
810,808
20,318,088
94
Final Actual
3,085,000 3,044,694
3,971,250 3,772,259
1,275,000 1,190,558
3,893,000 3,892,316
175,000 229,744
50,000 89,375
12,449,250 12,218,946
35,000 50,389
216,840 258,117
251.840 308,506
175,000 236,580
300,000 311,258
26,000 20,912
501,000 568,750
150,000 133,369
150.000 125,425
572,000 -
304,980 115,472
28.981
1,176,980 403,247
44,000 113,063
304,733
810,808 815,503
17,334,878 16,849,384
Variance with
Final Budget
Positive
(Negative)
(40,306)
(198,991)
(84,442)
(684)
54,744
39,375
(230,304)
15,389
41,277
56,666
61,580
11,258
(5,088)
67,750
(16,631)
(24,575)
(572,000)
(189,508)
28,981
(773,733)
69,063
15,636
304,733
4,695
(485,494)
(Continued)
Expenditures:
General government:
City council:
Personnel
Operations and maintenance
Capital
Total city council
City clerk:
Personnel
Operations and maintenance
Capital
Total city clerk
City manager:
Personnel
Operations and maintenance
Capital
Total city manager
City attorney.
Operations and maintenance
Total city attorney
Administration:
Personnel
Operations and maintenance
Total administration
Finance:
Personnel
Operations and maintenance
Total finance
Information services:
Personnel
Operations and maintenance
Capital
Total information services
CITY OF RANCHO MIRAGE
BUDGETARY COMPARISON SCHEDULE
GENERAL FUND
(Continued)
Budgeted Amounts
Original Final
Variance with
Final Budget
Positive
Actual (Negative)
$ 248,322 221,361 221,361
15,500 15500 4,712 10,788
2,500 2,500 - 2,500
266,322 239,361 226,073 13,288
578,466 440,359 439,263 1,096
206,720 152,720 116.723 35,997
6,000 1,000 652 348
791,186 594,079 556,638 37,441
1,561,585 1,512,105 1,473,991 38,114
81,840 68,840 46,077 22,763
7,000 7.000 1,947 5,053
1,650,425 1,587,945 1,522,015 65,930
531,000 531,000 420,420 110,580
531,000 531,000 420,420 110,580
221,513 219.513 218,587 926
46,335 40,693 40,693
267,848 260,206 259,280 926
538,524 494,343 494,343
15 8, 840 184,275 184,274 1
697,364 678,618 678,617 1
260,830 256,800 256,800 -
537,818 494.818 419,716 75,102
79,200 79,200 71,072 8,128
877,848 830,818 747,588 83,230
95
(Continued)
CITY OF RANCHO MIRAGE
BUDGETARY COMPARISON SCHEDULE
GENERAL FUND
(Continued)
Variance with
Final Budget
Budgeted Amounts Positive
Original Final Actual (Negative)
Public information & com. relations:
Operations and maintenance 290,950 290,950 218,888 72,062
Total information & com. relations 290,950 290,950 218,888 72,062
General government:
Personnel 929,595 933,465 884,284 49,181
Operations and maintenance 976,911 931,261 1,007,951 (76,690)
Capital 15,000 15,000 9,921 5,079
Total general government 1,921,506 1,879,726 1,902,156 (22,430)
Special programs:
Operations and maintenance 1,469,343 1,711,543 1,308,849 402,694
Total special programs 1,469,343 1,711,543 1,308,849 402,694
Planning:
Personnel 872,625 863,778 863,777 1
Operations and maintenance 312,862 312,862 234,010 78,852
Total planning 1,185,487 1,176,640 1,097,787 78,853
Building and safety'
Personnel 507,674 500,774 499,201 1,573
Operations and maintenance 86,940 86,940 30,335 56,605
Total building and safety 594,614 587,714 529,536 58,178
Mandated programs:
Operations and maintenance 137,500 108,525 68,107 40,418
Total mandated programs 137,500 108,525 68,107 40,418
Regional plan and implementation
Operations and maintenance 133,355 176,212 176,211 1
Total regional plan and
implementation 133,355 176,212 176,211 1
Interfund reimbursements (3,441,519) (3,441.519) (3.419,389) (22,130)
Tourism and marketing
Personnel 144,467 142,956 142,956 -
Operations and maintenance 942,325 930.833 930,832 1
Capital 2,000 2.000 - 2,000
Total tourism and marketing 1,088,792 1,075,789 1,073,788 2,001
Economic Development
Operations and maintenance 38,000 38,000 9,803 28,197
Total economic development 38,000 38,000 9,803 28,197
Total general government 8,500,021 8,325,607 7,376,367 949,240
(Continued)
96
Public safety:
Code compliance:
Personnel
Operations and maintenance
Total code compliance
Emergency services:
Personnel
Operations and maintenance
Capital
Total emergency services
Police services:
Operations and maintenance
Capital
Total police services
Citizens Option for Public Safety (COPS)
Operations and maintenance
Total COPS
Law Enforcement Equipment
Capital
Total law enforcement equipment
Reimbursement for Public Safety
Operations and maintenance
Total Reimbursement for
Public Safety
Total public safety
Public works:
Facilities & fleet maintenance:
Personnel
Operations and maintenance
Capital
Total buildings and landscaping
Street maintenance:
Personnel
Operations and maintenance
Capital
Total street maintenance
Engineering:
Personnel
Operations and maintenance
Capital
Total engineering
Total public works
CITY OF RANCHO MIRAGE
BUDGETARY COMPARISON SCHEDULES
GENERAL FUND
(Continued)
Budgeted Amounts
Original Final
$ 528,083 523,383 512,801
67,380 67,380 57,731
595,463 590,763 570,532
22,783 24,157 24,157
92,816 92,816 72,718
15,000 18,168 18,168
130,599 135,141 115,043
6,088,528 6,088,528 5,669,635
8,200 8,200 4,571
6,096.728 6,096,728 5,674,206
101,000 106,150 106,150
101,000 106,150 106,150
7,698 7,697
7,698 7,697
18,000 18,000 17,323
18,000 18,000 17,323
6,941,790 6,954,480 6,490,951
517,133 508,233 503,450
712,446 734,446 711,415
25,800 25,800 3,100
1,255,379 1,268,479 1,217,965
412,236 404,873 404,874
491,361 491,361 306,927
90,930 91,876 67,761
994,527 988,110 779,562
1,371,207 1,351.849 1,351,849
122,771 122,771 65,858
1,819 1,819 -
1,495,797 1,476.439 1,417,707
$ 3,745,703 3,733.028 3,415,234
97
Variance with
Final Budget
Positive
Actual (Negative)
10,582
9,649
20,231
20,098
20,098
418,893
3,629
422,522
1
1
677
677
463,529
4,783
23,031
22,700
50,514
(1)
184,434
24,115
208,548
56,913
1,819
58,732
317,794
(Continued)
CITY OF RANCHO MIRAGE
BUDGETARY COMPARISON SCHEDULES
GENERAL FUND
(Continued)
Variance with
Final Budget
Budgeted Amounts Positive
Original Final Actual (Negative)
Cultural and recreation:
Child Enrichment Center:
Operations and maintenance 63,700 63,700 41,700 22,000
Total summer recreation 63,700 63,700 41,700 22,000
Total cultural and recreation
63,700 63,700 41,700 22,000
Capital projects:
Capital improvements financed from
fund balance and license tax
General Fund Capital Projects 3,661,443 3,661,443 660,708 3,000,735
License Tax Fund Capital Projects 1,431,800 1,431,800 598,759 833,041
Total capital improvements 5,093,243 5,093,243 1,259,467 3,833,776
Total capital projects 5,093,243 5.093,243 1,259,467 3,833,776
Total expenditures 24,344,457 24,170,058 18,583,719 5,586,339
Excess (deficiency) of revenues over (under)
expenditures (4,026,369) (6,835,180) (1,734,335) 5,100,845
Other financing sources:
Transfers in 2,466,284 2,466,284 2,480,715 14,431
Transfers out (1,554,460) (1,300,491) (523,102) 777,389
Total other financing sources 911,824 1,165,793 1,957,613 791,820
Net change in fund balance (3,114,545) (5,669,387) 223,278 5,892,665
Fund balance, beginning of year 75,490,961 75,490,961 75,490,961 -
Fund balance, end of year $ 72,376,416 69,821,574 75,714,239 5,892,665
98
Revenues:
Intergovernmental
Fines and forfeitures
Interest income
Net increase (decrease) in investment
fair value
Miscellaneous
Total revenues
Expenditures:
Current:
Cultural and recreation
Total expenditures
Excess (deficiency)
of revenues over
(under) expenditures
Other financing sources (uses):
Transfers in
Total other financing
sources (uses)
Total change in fund balances
Fund balances, beginning of year
Fund balances (deficit), end of year
CITY OF RANCHO MIRAGE
BUDGETARY COMPARISON SCHEDULE
LIBRARY SPECIAL REVENUE FUND
Year ended June 30, 2010
Budgeted Amounts
Original Final
227,300 227,300 274,695
21,000 21,000 58,663
48,900 48,900 53,355
$ 1,924,549 1,924,549
99
Variance with
Final Budget
Positive
Actual (Negative)
47,395
37,663
4,455
- 22,040 22,040
77,500 77,500 192,807 115,307
374,700 374.700 601,560 226,860
3,465,156 3,465,156 3,317,549 147,607
3,465,156 3,465.156 3,317,549 147,607
(3,090,456) (3,090.456) (2,715,989) 374,467
2,552,757 2,552,757 2,684,179 131,422
2,552,757 2,552,757 2,684,179 131,422
(537,699) (537,699) (31,810) 505,889
2,462,248 2,462,248 2,462,248
2,430,438 505,889
Total revenues
CITY OF RANCHO MIRAGE
BUDGETARY COMPARISON SCHEDULE
FIRE TAX SPECIAL REVENUE FUND
Year ended June 30, 2010
Variance with
Final Budget
Budgeted Amounts Positive
Original Final Actual (Negative)
Revenues:
Charges for services $ 30,000 30,000 22,574 (7,426)
Interest income 20,000 20,000 31,728 11,728
Net increase (decrease) in investment
fair value 13,844 13,844
50,000 50,000 68,146 18,146
Expenditures:
Current:
Public safety 5,190,922 5,190,922 4,487,489 703,433
Total expenditures 5,190,922 5,190,922 4,487,489 703,433
Excess (deficiency)
of revenues over
(under) expenditures (5,140,922) (5,140,922) (4,419,343) 721,579
Other financing sources (uses):
Transfers in 4,984,410 4,934,410 4,123,357 (811,053)
Total other financing
sources (uses) 4,984,410 4,934.410 4,123,357 (811,053)
Total change in fund balance (156,512) (206,512) (295,986) (89,474)
Fund balances, beginning of year 884,806 884,806 884,806
Fund balances (deficit), end of year $ 728,294 678,294 588,820 (89,474)
100
Revenues:
Intergovernmental
Licenses and permits
Interest income
Net increase (decrease) in
investment fair value
Miscellaneous
Total revenues
Expenditures:
Current:
General government
Capital projects
Total expenditures
Excess (deficiency)
of revenues over
(under) expenditures
Other financing sources (uses):
Transfers in
Transfers out
Total other financing
sources (uses)
Total change in fund balance
Fund balances, beginning of year
Fund balances (deficit), end of year
CITY OF RANCHO MIRAGE
BUDGETARY COMPARISON SCHEDULE
HOUSING AUTHORITY SPECIAL REVENUE FUND
Year ended June 30, 2010
Budgeted Amounts
Original Final
5,000 5,000
1,000,000 1,000,000
1,271,951 1,271.951
22,879,553 8,989,464
58,759
4,020
418,918
2,276,951 2,276,951 1,288,114 (988,837)
4,863,359 4,862,359 4,150,833
27,742,912 13,851,823 13,552,575
Variance with
Final Budget
Positive
Actual (Negative)
58,759
(980)
(581,082)
(199,291) (199,291)
1,005,708 (266,243)
711,526
9,401,742 (412,278)
299,248
(25,465,961) (11,574,872) (12,264,461) (689,589)
19,687,982 19,687,982 14,868,089 (4,819,893)
(352,244) (352,244)
19,335,738
(6,130,223)
21,369,558
$ 15,239,335
19,335,738
7.760,866
21,369.558
$ 29,130,424
101
(230,356) 121,888
14,637,733 (4,698,005)
2,373,272 (5,387,594)
21,369,558 -
23,742,830 (5,387,594)
Revenues:
Interest income
Net increase (decrease) in investment
fair value
Total revenues
Expenditures:
Current:
General government
Debt service:
Principal
Interest
Service Fees
Total expenditures
Excess (deficiency) of revenues
over (under) 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
CITY OF RANCHO MIRAGE
BUDGETARY COMPARISON SCHEDULE
LOW COST HOUSING SPECIAL REVENUE FUND
Year ended June 30, 2010
Budgeted Amounts
Original Final
$ 640,000 640,000
640,000 640,000
6,362
1,135,000
1,377,956
120,750
2,640,068 2,640,068 2,635,191
(2,000,068) (2,000.068)
6,960,000 6,960,000 6,971.723
(19,687,982) (19,687,982) (14,868,089)
(12,727,982)
(14,728,050)
28,746,327
$ 14,018,277
(12,727,982)
(14,728,050)
28,746,327
14,018,277
102
6,362
1,135,000
1,377,956
120.750
Variance with
Final Budget
Positive
Actual (Negative)
607,015
(7,896,366)
(10,026,974)
28,746,327
18,719,353
1,135,000
1,377,956
116,158
(102,432) (102,432)
504,583 (135,417)
6,077
(32,985)
285
4,592
4,877
(2,130,608) (130,540)
11,723
4,819,893
4,831,616
4,701,076
4,701,076