HomeMy Public PortalAbout08 REQUIRED SUPPLEMENTARY INFORMATIONCity of Rancho Mirage
California
Comprehensive Annual Financial Report
YEAR ENDED JUNE 30, 2003 rf
(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 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.
(5)
(
(
CITY OF RANCHO MIRAGE
Notes to Required Supplemental Information
Year ended June 30, 2003
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.
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.
77
CITY OF RANCHO MIRAGE
Notes to Required Supplemental Information
(continued)
(2) Reconciliation of Actual Data for Budgetary Presentations
Reconciliations of the actual data reported in the governmental funds' statement
of revenues, expenditures, and changes in fund balances (GAAP basis) to the
actual data reported in the budgetary comparison schedules (budgetary basis) are
as follows:
Total change in fund balances (GAAP
basis) $7,143,224
Loan reimbursements:
Reimbursement revenue
Reimbursed expenditure (2 040 642)
Total change in fund balances (budgetary
basis) $5.102
78
General Fund
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
Community facilities districts
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
GENERAL FUND
BUDGETARY COMPARISON SCHEDULE
Year Ended June 30, 2003
Budgeted Amounts
Orieinal Final
$ 662,820
4,040,000
683,948
6,080,000
290,130
1,705,000
13,461,898
706,000
100,000
806,000
125,000
$ 18,833,904
79
683,000
4,100,000
795,600
5,363,000
290,130
2,705,000
13,936,730
772,500
489,000
1,261,500
Variance with
Final Budget
Actual Positive
(Budgetary Basis) (Negative)
718,588
3,877,261
868,640
5,195,663
410,878
2,931,588
14,002,618
862,191
647,019
1,509,210
35,588
(222,739)
73,040
(167,337)
120,748
226,588
65,888
89,691
158,019
247,710
162,240 176,800 197,084 20,284
800,000 1,250,000 1,363,872 113,872
21,200 21,200 19,682 (1,518)
983,440 1,448,000 1,580,638 132,638
80,000 150,000 168,332 18,332
250,000 450,000 459,021 9,021
237,800 370,000 500,710 130,710
510,000 685,000 751,416 66,416
37,426 37,426 72,610 35,184
108,000 155,456 47,456
1,115,226 1,800,426 2,107,545 307,119
16,590 16,590 31,087 14,497
2,325,750 2,126,120 2,300,147 174,027
- 402,885 402,885
250,000 260,576 10,576
20,839,366 22,194,706 1,355,340
(Continued)
Expenditures:
CITY OF RANCHO MIRAGE
GENERAL FUND
BUDGETARY COMPARISON SCHEDULE
(Continued)
Variance with
Final Budget
Budgeted Amounts Actual Positive
Original Final (Budgetary Basis) fNegative)
General government:
City council:
Personnel $ 118,800 99,667 98,866 801
Operations and maintenance 45,664 47,464 27,075 20,389
Capital 5,000 5,000 5,000
Total city council 169,464 152,131 125,941 26,190
City Clerk:
Personnel 97,732 316,168 315,093 1,075
Operations and maintenance 37,931 98,131 98,080 51
Capital 7,210 7,202 8
Total city clerk 135,663 421,509 420,375 1,134
City manager:
Personnel 708,550 676,549 676,548 1
Operations and maintenance 76,378 78,378 39,046 39,332
Capital 1,555 1,555 - 1,555
Total city manager 786,483 756,482 715,594 40,888
City attorney:
Personnel 254,770 186,823 186,824 (1)
Operations and maintenance 184,346 351,346 350,741 605
Total city attorney 439,116 538,169 537,565 604
Administration:
Personnel 455,805 320,164 317,607 2,557
Operations and maintenance 19,850 40,850 32,667 8,183
Total administration 475,655 361,014 350,274 10,740
Finance:
Personnel 448,178 349,717 347,468 2,249
Operations and maintenance 91,600 144,600 122,045 22,555
Total finance 539,778 494,317 469,513 24,804
80
(Continued)
Expenditures, (Continued):
Information services:
Personnel
Operations and maintenance
Capital
Total information services
Information and marketing:
Operations and maintenance
Total information and marketing
General government:
Personnel
Operations and maintenance
Capital
Total general government
Special programs:
Operations and maintenance
Total special programs
Planning:
Personnel
Operations and maintenance
Total planning
Building and safety:
Personnel
Operations and maintenance
Capital
Total building and safety
Mandated programs:
Operations and maintenance
Total mandated programs
Regional plan and implementation
Operations and maintenance
Total regional plan and
implementation
Interfund reimbursements
Total general government
CITY OF RANCHO MIRAGE
GENERAL FUND
BUDGETARY COMPARISON SCHEDULE
(Continued)
Budgeted Amounts
Original Final
$ 362,671
201,797
21,155
585,623
259,166
259,166
43,011
81
212,425
218,927
102,357
533,709
341,423
341,423
43,011
43,011 43,011
(1,496,555) (1,496,555)
6,409,213 7,372,758
Actual
(Budgetary Basis)
211,407
165,349
96,867
473,623
1,178,897 1,088,060 941,262 146,798
1,178,897 1,088,060 941,262 146,798
162,503 242,406 238,435 3,971
585,012 717,833 556,489 161,344
14,000 141,442 39,985 101,457
761,515 1,101,681 834,909 266,772
873,550 1,086,819 915,632 171,187
873,550 1,086,819 915,632 171,187
861,936 768,987 757,919 11,068
174,475 447,217 285,883 161,334
1,036,411 1,216,204 1,043,802 172,402
514,381 523,829 515,466 8,363
107,055 210,955 210,884 71
621,436 734,784 726,350 8,434
97,879
97,879
31,965
Variance with
Final Budget
Positive
(Negative)
1,018
53,578
5,490
60,086
243,544
243,544
11,046
31,965 11,046
(1,463,680) 32,875
6,221,004 1,217,504
(Continued)
CITY OF RANCHO MIRAGE
GENERAL FUND
BUDGETARY COMPARISON SCHEDULE
(Continued)
Variance with
Final Budget
Budgeted Amounts Actual Positive
Ori final Final (Budgetary Basis) (Negative)
Expenditures, (Continued):
Public safety
Code compliance:
Personnel $ 254,577 226,100 216,536 9,564
Operations and maintenance 55,310 69,010 51,752 17,258
Total code compliance 309,887 295,110 268,288 26,822
Emergency services:
Operations and maintenance 4,505 4,505 4,455 50
Capital
Total emergency services 4,505 4,505 4,455 50
Police services:
Operations and maintenance 3,241,409 3,432,958 3,428,168 4,790
Capital - - 4,318 (4,318)
Total police services 3,241,409 3,432,958 3,432,486 472
Citizens Option for Public Safety (COPS)
Operations and maintenance 94,200 109,606 110,347 (741)
Capital 5,000 6,936 4,448 2,488
Total COPS 99,200 116,542 114,795 1,747
Law Enforcement Equipment
Operations and maintenance - 1,618 (1,618)
Capital 32,127 29,665 2,462
Total enforcement equipment 32,127 31,283 844
Total public safety 3,655,001 3,881,242 3,851,307 29,935
Public works:
Buildings and landscaping:
Personnel 313,150 292,664 289,770 2,894
Operations and maintenance 457,518 507,148 507,027 121
Capital 4,000 32,463 27,412 5,051
Total buildings and landscaping 774,668 832,275 824,209 8,066
Street maintenance:
Personnel 400,708 375,000 374,994 6
Operations and maintenance 474,398 502,306 291,157 211,149
Capital - 35,000 34,748 252
Total street maintenance 875,106 912,306 700,899 211,407
Engineering:
Personnel 910,871 860,355 850,951 9,404
Operations and maintenance 343,116 545,172 360,809 184,363
Capital - - - -
Total engineering 1,253,987 1,405,527 1,211,760 193,767
Total public works $ 2,903,761 3,150,108 2,736,868 413,240
(Continued)
82
Expenditures, (Continued):
Cultural and recreation:
Summer recreation:
Operations and maintenance
Total summer recreation
Total cultural and recreation .
Capital projects:
Capital improvements financed
from Fund Balance and License Tax
General Fund Capital Projects
Capital Loans
License Tax Fund Capital Projects
Total capital improvements
Total capital projects
Total expenditures
Excess (deficiency) of
revenues over (under)
expenditures
Other financing sources:
Transfers out
Proceeds from sale of capital assets
Issuance of long -term debt
Total other financing sources
Net change in fund balance
Fund balance, beginning of year
Fund balance, end of year
CITY OF RANCHO MIRAGE
GENERAL FUND
BUDGETARY COMPARISON SCHEDULE
(Continued)
Budgeted Amounts
Original Final
$ 40,000
40,000
40,000
42,000
42,000
42,000
1,345,000 5,038,484
2,436,000
2,770,000 4,548,705
4,115,000 12,023,189
4,115,000 12,023,189
17,122,975 26,469,297
1,710,929 (5,629,931)
1,710,929 (5,629,931)
57,809,871 57,809,871
83
Variance with
Final Budget
Actual Positive
(Budgetary Basis) (Negative)
21,228
21,228
21,228
1,693,398 3,345,086
2,040,642 395,358
968,835 3,579,870
4,702,875 7,320,314
4,702,875 7,320,314
17,533,282 9,001,765
4,661,424 10,291,355
(350,394)
690,112
101,440
441,158
57,809,871
0
20,772
20,772
20,772
(350,394)
690,112
101,440
441,158
10,732,513
$ 59,520,800 52,179,940 ( 62,912,453 / 10,732,513
Revenues:
Taxes $
Intergovernmental
Total revenues
Expenditures:
Current:
General government
CITY OF RANCHO MIRAGE
FIRE TAX
BUDGETARY COMPARISON SCHEDULE
YEAR ENDED JUNE 30, 2003
Variance with
Final Budget
Budgeted Amounts Positive
Original Final Actual (Negative)
84
Licenses and permits -
Charges for services - 26,896 26,896
Fines and forfeitures
Special assessments -
Developer fees
Interest income 14,375 14,375 12,893 (1,482)
Net increase (decrease) in investment
fair value - (5,981) (5,981)
Miscellaneous - -
14,375 14,375 33,808 19,433
Public safety 2,660,481 3,191,351 3,062,756 128,595
Public works -
Cultural and recreation
Capital projects
Total expenditures 2,660,481 3,191,351 3,062,756 128,595
Excess (deficiency)
of revenues over
expenditures (2,646,106) (3,176,976) (3,028,948) 148,028
Other financing sources (uses):
Transfers in 2,377,325 2,535,305 2,395,074 (140,231)
Transfers out
Total other financing
sources (uses) 2,377,325 2,535,305 2,395,074 (140,231)
Total change in fund balances (268,781) (641,671) (633,874) 7,797
Fund balances, beginning of year 673,070 673,070 673,070
Fund balances (deficit), end of year $ 404,289 31,399 39,196 7,797
CITY OF RANCHO MIRAGE
PARKLAND
BUDGETARY COMPARISON SCHEDULE
YEAR ENDED JUNE 30, 2003
Variance with
Final Budget
Budgeted Amounts Positive
Original Final Actual (Negative)
Revenues:
Taxes $
Intergovernmental 100,000 109,000 (109,000)
Licenses and permits - -
Chargesforservices 37,508 37,508 57,389 19,881
Fines and forfeitures - - -
Special assessments 324,000 324,000 295,862 (28,138)
Developer fees - 200,000 249,748 49,748
Interest income 50,000 50,000 80,280 30,280
Net increase (decrease) in investment
fair value - 24,474 24,474
Miscellaneous
Total revenues 511,508 720,508 707,753 (12,755)
Expenditures:
Current:
General government - - -
Public safety - - -
Public works - - -
Cultural and recreation 450,671 441,671 248,809 192,862
Capital projects
Total expenditures 450,671 441,671 248,809 192,862
Excess (deficiency)
of revenues over
expenditures 60,837 278,837 458,944 180,107
Other financing sources (uses):
Transfers in 1,858 1,858 1,555 (303)
Transfers out
Total other financing
sources (uses) 1,858
Total change in fund balances 62,695
Fund balances, beginning of year 1,401,849
Fund balances (deficit), end of year $ 1,464,544
85
1,858
280,695
1,401,849
1,682,544
1,555 (303)
460,499 179,804
1,401,849
1,862,348
179,804
Revenues:
Taxes $
Intergovernmental
Licenses and permits 6,000 6,000 4,583 (1,417)
Charges for services - -
Fines and forfeitures - -
'Special assessments - - -
Developer fees - -
Interest income 520,700 520,700 449,596 (71,104)
Net increase (decrease) in
investment fair value - 128,941 128,941
Miscellaneous 403,956 388,656 393,689 5,033
Total revenues
CITY OF RANCHO MIRAGE
HOUSING AUTHORITY
BUDGETARY COMPARISON SCHEDULE
YEAR ENDED JUNE 30, 2003
Variance with
Actual - Final Budget
Budgeted Amounts (Budgetary Positive
Original Final Basis) (Negative)
930,656 915,356 976,809 61,453
Expenditures:
Current:
General government 2,090,677 3,036,437 1,610,074 1,426,363
Public safety -
Public works
Cultural and recreation
Capital projects 1,011,817 15,358,497 734,312 14,624,185
Total expenditures 3,102,494 18,394,934 2,344,386 16,050,548
Excess (deficiency) of
revenues over
expenditures (2,171,838) (17,479,578) (1,367,577) 16,112,001
Other financing sources (uses):
Transfers in 3,594,120 4,122,400 4,296,788 174,388
Transfers out (73,092) (73,092) (133,385) (60,293)
Proceeds from sale of land -
Total other financing 3,521,028 4,049,308 4,163,403 114,095
sources (uses)
Total change in fund balances 1,349,190 (13,430,270) 2,795,826 16,226,096
Fund balances, beginning of year 14,566,625 14,566,625 14,566,625
Fund balances (deficit), end of year $ 15,915,815 1,136,355 17,362,451 16,226,096
86