HomeMy WebLinkAbout7/25/2007 - STAFF REPORTS - 2.L. �PP'LAI qA
c
V N
+F N
. 1pot CITY COUNCIL STAFF REPORT
DATE: July 25, 2007 Consent Calendar
SUBJECT: APPROVAL OF BUDGET TRANSFER TO CAPITAL PROJECTS FUND
AND CONTINUING APPROPRIATIONS
FROM: David H. Ready, City Manager
BY: Department of Finance and Treasury
SUMMARY
At the end of each fiscal year staff recommends certain accounts be continued into the
next fiscal year by resolution under the title of "Continuing Appropriations". In addition,
there are remaining funds in Convention Center Operations Account that staff is
recommending be transferred into the Capital Projects Fund for equipment and projects
that will be submitted to the City Council for approval during Fiscal Year 2007-08.
RECOMMENDATION:
1. Approve Resolution No. "Of the City Council of the City of Palm
Springs, California, Amending the Budget for the 2006-07 Fiscal Year."
2. Approve Resolution No. "A Resolution of the City Council of the
City of Palm Springs, California, Approving Continuing Appropriations from
Fiscal Year 2006-07 to Fiscal Year 2007-08."
STAFF ANALYSIS:
At the end of each fiscal year staff recommends certain accounts be continued into the
next fiscal year. These are appropriations accounts for specific projects or purposes.
Many are appropriations that are restricted by special revenues either by gift, grants or
funding source. Staff has reviewed the attached list of Continuing Appropriations to
ensure that they are needed to complete a designated project and/or are connected to a
grant or designated revenue source or are associated with a donation or gift. The
majority of this year's continuing appropriations are related to various capital projects.
In order to continue spending on these items, the City Council must approve the
continuing of these appropriations into Fiscal Year 2007-08.
ITEM NO.
City Council Staff Report
July 25, 2007-- Page 2
Approval of Budget Transfer and Continuing Appropriations
As has traditionally been our past practice, capital projects at the Convention Center
have been funded with operating funds remaining in their accounts at the end of the
Fiscal Year. Fortunately, with increased operational efficiencies and higher than
projected revenues at the Convention Center for the Fiscal Year ending June 30, 2007,
$436,000 is available for capital projects. The Convention Center's list of
recommendations for such expenditures is attached.
Hence, staff is recommending that the unspent Convention Center operating funds be
transferred to the designated accounts in the Capital Projects Fund. These projects and
equipment purchased will be presented for approval by the City Council during Fiscal
Year 2007-08. Reporting these expenditures in the Capital Projects Fund is in
accordance with the new reporting standards of GASB and will more accurately reflect
the actual operating costs in the Community Promotions Fund.
FISCAL IMPACT:
Adequate funds remain in the Convention Center Operations Account to fund the
$436,000 transfer to the Capital Projects Fund accounts.
\S3\P>7t A
Craig A. Graves, Director of Finance and Troy . Butzla , A istant City Manager-
Treasurer Admi trative a ces
David H. Ready, City
Attachments:
Resolution Amending Budget
Resolution Approving Continuing Appropriations Transfer
RESOLUTION NO.
OF THE CITY COUNCIL OF THE CITY OF PALM
SPRINGS, CALIFORNIA, AMENDING THE BUDGET
FOR THE 2006-07 FISCAL YEAR.
WHEREAS Resolution 21611 approving the budget forthe fiscal year 2006-07 was
adopted on June 7,2006; and
WHEREAS the City Manager has recommended, and the City Council desires to
approve, certain amendments to said budget;
NOW THEREFORE BE IT RESOLVED that the Director of Finance is authorized to
record inter-fund cash transfers as required in accordance with this Resolution, and
that Resolution 21611, adopting the budget for the 2006-07 fiscal year is hereby
amended as follows:
SECTION 1. ADDITIONS
Fund Activity Account Amount
112 2080 43240 436,000
Purpose Transfer funds to Capital Projects
SECTION 2. SOURCE Remaining amount of Convention Center Operations
Fund Activity Account Amount
261 1395 63565 436,000
ADOPTED THIS 111" day of July, 2007.
David H. Ready, City Manager
ATTEST:
James Thompson, City Clerk
oa0aa
CERTIFICATION
STATE OF CALIFORNIA )
COUNTY OF RIVERSIDE ) ss.
CITY OF PALM SPRINGS )
I, JAMES THOMPSON, City Clerk of the City of Palm Springs, hereby certify that
Resolution No. is a full, true and correct copy, and was duly adopted
at a regular meeting of the City Council of the City of Palm Springs on
by the following vote:
AYES:
NOES:
ABSENT:
ABSTAIN:
James Thompson, City Clerk
City of Palm Springs, California
REC'D IN FINANCE
JUN z 12007
'fHE K4f_'PNG ORS:G
P A L M S P R I N G S
CONVENTION CENTER
Monday, June 11, 2007
Craig Graves
City of Palm Springs
3200 E Tahquitz Canyon Way
Palm Springs, CA 92263-2743
Dear Craig:
Please let this letter and enclosed attachments serve as our request that$436,000 of
our operating allowance for the fiscal year 2006-2007 be transferred from account 112-
2080-43240 to account 261-1395-63565 Unscheduled Capital Projects. These and will
be used to fund the bald projects detailed in the attached Capital Projects list, Also
attached is a reconciliation of our draw allowance for 2006-2007" Please contact me if
you have any questions or need additional information.
Best regards,
M tthew E" Mi er
Accounting Department
Enclosures (2)
277 N Avenida Caballeros Patin Sprivgs,CA M62.6440 (760)322-8412 D (760)778-0102 F www-mlyal LjLigq-m-c
� � fl rl UiD
Palm Springs Convention Center
Projects Fundin
Expenditure in: Project Leader Source of Funds
261-1395-63565 1 112.2050.43240
Unscheduled
Ca lial Pro I Operatinq Funds
2007-2003
Card Kay Entry at Selected Entry Points 20,000
• Signage improvements 20,000
Information Mont ors In Lobby 6 Hallways 50,000
Airmagnet Enterprise WLAN security gyatem 7,0m
` Lobby furniture 50,000
5acurity Cameras in Parking Lot 11,000
Carpet Extractor 15,000
Bathroom repairslremodel 225,000
Table Storage Carts for 72"Rounds 20,000
Landscaping 25,000
Palm Grove Wlndcw Coverings/Shutters 20,000
Booking System Enhancements 20,000
Convert Robertshaw HVAC controls to Aledon System 95,000
Arc Wall rehablllration/re-fabric 250,000
Cooling Tower## Rebuild 30 w0
Replace exhlba hall carpet 290 000
11149,000
• Install compatible lighting frxtures to blend with expansion 490,000 Consider lease option
2008.2009
FFE Annual Equlpmom Replacement 75,000
Cooling Tower 02 Rebuild 30,000
Computer Workstation Replacements 10,000
Network mplar scanner upgrade/replacement 20,000
Network Sarver upgrade/addition 20 090
155,000
2009-2010
1 FFE Annual Equipment Replacement 75,000
2 Computer Workstation Replacements 10,000
85,000
2010.2011
1 FFE Annual Equipment Replacement 75,000
2 Computer Workstahon Replacements 10,000
05,000
Note: " expansion ralatod
updated o6-11-07
nc;nnns�
RESOLUTION NO. 7l12l2007
A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF PALM SPRINGS,
CALIFORNIA, APPROVING CONTINUING APPROPRIATIONS FROM FISCAL
YEAR 2006-07 TO FISCAL YEAR 2007-08
WHEREAS the City Council of the City of Palm Springs has adopted a budget for the
I
2006-07 fiscal year; and —
WHEREAS certain projects budgeted in the 2006-07 fiscal year budget have been started
but not completed; and
WHEREAS the unencumbered balances of those certain appropriations are necessary for
completion of the projects;
NOW THEREFORE BE IT RESOLVED that the City Council of the City of Palm Springs
hereby authorizes carrying forward to the nearest dollar, as continuing appropriations into
the_2b07-08 fiscal year, the amount indicated or the final audited unencumbered balances,
whichever is the lesser amount, as of June 30, 2007 of the following accounts:
ACCOUNT NO: ACCOUNT TITLE AMOUNT
- - --- -- -
General Fund � —
001-1010:42692 Contingency - Wells Fargo 2,283.55
001-1120-42960 Hardware Maintentance 0.00
001-1120-42980 Radio Maintentance 4,249.79
001-1220-40075 Performance Pay 108,469.05
001-1220-42691 Unallocated Council Priorities 48,307.12
001-1220-6511D Economic Development Program_ _ 125,713.76
001-1231-43200 1 Contractual__Services 12,585.26 _
001-1300-43250 Auditing _,_ 15,000,00 Only
001-2451-43530 Parkway Maint Dist#6A 953.15
601-2451-43540 Parkway Maint Dist#613 114.73
00 1-245 1-43 550 Parkway Maint Dist#6C 2,102.52
001-245143560 _Lighting Maint Dist#7 2,093.21
0 0 1-245 1-43 570 Parkway Maint Dist#8 _ 7,055.02 _
001-2451-43580 Parkway Maint Dist#9 7,293.04
001-245143590 y Parkw Maint DisT#10-1 - 1,056.64
— ---- — --
001-2451-43596 Parkway Maint Dist#11 15,000.00_
001-2590-43890 JOJDHUC Spec Prog Donation 4,0..
00.00
001-2710-44055 Literacy Program
- 35,01124
001-2710-44056 Family Literacy Program 4,281,64
001-2710-44057 Support from Library Trust 40,504,57
001-3017-40800 Click It or Ticket Grant _ _, 3,706,24
001-3024-40800 DUI Grant 06-07 20,941.01
001-3520-40000 Employee Salary _ — 35,000.00
001-3520-50010 Office Furn & E uip 23,000.00
001-3521-ALL SAFER Grant _ 11,670-04
001-4151-43840 Historic Preservation_ _ _ 7,611,69 _
601-416142501 _SMIP Training _ 3,611.75
001-4301-43600 Light Maint 1 3,658.21
00 1-43 01-4 36 1 0 Light Maint 2 4,347.10
001-4301-43620 Light Maint 3 _ 1,917.79
00 1-43 0 1-4363 0 Light Maint 4 7,218.94 558,657.06
Community Promotion Fund
1 1 2-201 6-50003 Building & Equipment 1,642.94 _
112 2018-45500 Special Activities _ 7,058.14
1 1 2-201 8-4561 0 July 4th Celebration 19,901.62 __
112-20M45634 G&Fn mu-nity Concerts 1,317.54
112-2018-45636 Veterans Day Sponsor _ 9,098.61
112-2018-45651 Youth Concerts _ 13,344.07
112-2018-45653 Bob Hope Classic_ _ 124,680.42
112-2080-45520 Advertising 212,323.16 389,266.50
Forfeited Asset Fund
120-3012-42015 Communications 3,928.31
120-3012-43921 Federal PSNTF 289,813.91
120-3012-43922 State PSNTF _ 1,058.72
120-3012-43929 PSPD Local Seizure - City 388,698.18 683,499.12
Safety Augmentation Fund
121-3014-ALL Police Special Contribution 197,196.18
1 21-3523-421 95 Special Dept Supplies 10,702.87
121-3523-42490 Non Capital Equipment 5,203,72
121-3523-42991 DMAC Maintenance 10,800.00
121-3523-50015 Specialized Equipment ___ 2,151.53
121-3523-52030 K-9 Donations 5,421.34 231,475.64
Special Development Fund L _ __
123-ALL Special Develop m--e-n t Fund —_ 246,775,10 246,775.10
Neighborhood Involvement Fund _
128-4180-43244 ONIP Support 7,280.42 7,180.22
Gas Tax Fund I -
1 33-429 8-501 00 Slurry Seal _ _ 3,263.76
133-4298-50101 Safety Lighting _-_ 7,943.94_
133-4298-50105 Equipment Replacement 5,428.73
1334298-50108 Traffic Signal Cab/Pales _ 15,974.00 —
133-4298-50190 Residential Traffic Speed Reduction 12,428-61
133-4298-50204 Traffic Signal Flow Improve 144,349.14 _
133-4298-50221 5-Palm Canyon Bridge 86,000.00
133-4298-50242 Curb & Gutter- Citywide 63,389.80_
133-4298-50250 Drainage - Patencio 75,472-52 414,250.50
Measure A Fund _-- --
134-4497-50170 Indian Widening 238,170.00
134-4497-50185 Indian/1-10 Interchange 199,444.31
134-4497-50196 Indian RR Bridge 238,170.00
134.4497-50214 Gene Autry RR Bridge 12,044.36 _
134-4497-50216 lnd Cyn Widen @ WW Wash 131,502.53
134-4497-50217 Gene Autry Widen @ WW Wash —2,392,932.47
134-4497-50245 Ramon Widening Study 50,000.00 _
134-4498-50000 Unscheduled Capital Projects 353,078.00-
134-4498-50100 Slurry Seal Program _ 4,916.72
134-4498-50120 Bridge Repairs _ _ _ 103,488.61
134-4498-50169 Belardo Bridge 299,021.80
1 34-4498-501 70 Indian Canyon Drive Widening 233,859.22
134-4498-50185 Indian / 1-1.0 Interchange 805,712-40
134-4498-50192 Gene Autry/ I-10 Interchange 595,249-30
134-4498-50196 Indian Avenue UPRR Bridge 189,830.34
134-4498-50214 Gene Autry RR Bridge _ 61,000-00
1 34-4498-5021 6 Ind Cyn Widen @ WW Wash 149,819,91
1 34-449 8-5 021 7 Gene A"_@ WW Wash_ _ _ 794,620.31
134-4498-50224 Traffic Safety t—f—
40,000.00
134 4498-50225 ARHM Over_ 88,259.83134-4498-50244 Bogert Trail Bridge Repair 50.000.00
134-4498-50245 Ramon Widening Study 50,000.00
134-4498-50249 SN829 06-07� _ 24,458.11
134-4498-50252 Indian/Tamarisk Signal 199,158.65_ 7,604,736.87
Drainage Fund 1-._ ___
135-ALL (— Drainage Fund _ 3,886,095.79 3,886,095.79
Community Development Block Grant Fund
fl�0003
137-ALL Community Development Block Grant 602,028-861 602,028.86
Public Art Fund —
150-4408-50015____LSpecialized Equipment 27,500.751 27,500.75
Library Trust Fund
151-2752-42690 Contingency 1 59,533.59
- - ------------
151-3752-43880 Special Programs 122,396.75
151-2752-44030 Supplemental Acquisitions 20.6,249.92
151-2752-44061 Susan Friedman Acquisitions L 11200-00
151-2752-44070 William Dean Award 1,000.00
151-2752-44075 Wouk Foundation 2,000.00
151-275244080 Koss Memorial _ 40,115.58
151-2752-45520 Advertising 9,377.46 441,873.30
Quimby Fees-1- --- i
152-2460-51554 Landscape GAT &VC TE Match_ _ 425,000.00
152-2460-51555 Landscape Gene A V Chino 145,181.93 570,181.93
Special Project/Developer Fees Fundl
160-ALL — — Special Projects 1,310,791.60 1,310,791.60
Capital Project Fund -- - --
261-1395-50000 Unscheduled Capital Projects 19,904.84
261-1395-54029 Motion Sensors-City Hall & Engineering_ 25,000,00
261-1395-54031 Billing Meters - Cogen 31,906.00
261-1395-54035 Portable Toilets-Villagefest 4,870.50
261-1395-54040 Chamber Lighting 10,000.00
261-1395-54046 Tech Enhancement 406,884.00
261-1395-54049 General Plan Update _ 43,278.00
261-1395-54050 Bollards 1 _ 73,802.06
261-1395-54052 Finance System Upgrade 14,759-63
261-1395-54057 City Hail Furniture _ 3,614.00
261-1395-54058 _ City Hall Directional Signage 8,500.00
261-1395-54059 Security Improve City Hall 13,630.71 _
261-1395-54060 City Hall Repair S Parking Lot 20,000-00
261-1395-63557 Convention Center Expand_ 94,281.10 —
261-1395-63558 Villagefest Equipment 12,104.89
261-1395-63559 Visitor Center Improvements 20,411.00
261-1395-63565 SMG Convention Center Improvements 436,000.00 NEW
261-1395-63565 SMG Convention Center Improvementsi 443,729-71
261-1395-63568_ _ Facility Need Assessment _ 50,000.00
261 2493-51512 Demuth Park Conc Sfd Improvements 16,311.71
261-2493-51523 Computer Irrigation 65,000.00
261-2493-51528 Park Development 35,815.00
261-2493-5-51533 Demuth Pk Elec Panels 4,676.47
261-2493-51534 Recreation Dept Van 8,420.74
261-2493-51552 Pool Replaster- Tile - Lane _ _ 177,521.79
261-2493-51553 Tennis Court Relighting 23,360.23
261-2493-51557 DHUC Kitchen Remadel 30,000.00
261-2494-51514 Repair Parks Restrooms _ 10,060.64
261-2494-51524 Com Park Master Plan 14,038.00
261-2494-51525 Desert Landscape Conversion 129,639-63
261-2494-51526 New Park Entry Signs 5,984.84
261-2494-51527 Shade Structure DeM_u_t_h Dugout 4,635.72
261-2494-51531 Stadium Renovation 16,494.14
261-2494-51536 Dog Park Improvements _ 14,665.48
261-2496-51003 Library Unsceduled Proj 178,901.89
261-2496-51005 Youth Room Renovations 13,585.53
261-2496-51008 Librar Restroom Upgrade _ 105,176.74
261-2496-51010 Library Hard/Software U rade 68,734.0
261-2496-5 1 529'T Library Roof Replacement 50,000.00
261-2498-51537 07 Tribal Donations -� 15,000.00
000M
261-3200-52071 _Recon PD HVAC System 35,000.00
261-3200-52072 lAir Filtration Jail Havac 5,454.78
261-3201-52059 iArmored Rescue Vehicle 7,500,00
261-3201-52062 Ed Byrnes Justice Grant 50,522.66
261-3201-52064 IState SLESF 05-06 755.27
261-3201-52069 Ed Byrnes Justice Grant _ 27,000.00
261-3201-52073 SLE8F06-07 100,000.00-
261-3600-53000 Fire Dept Capital Improvements 1 14,481,01
- - ---- -Ba- -- 18,047.58
261-3600-53D01 Fire Hydrants
261-3600-53007 ckflow Devices 4,967.90
261-3600-53009 FS#2 Apparatus Room Remodel 25,000.00
261-3600-53010 FS #3 Ext Remodel/Security ___ 10,443,94
2614600-53024_ Wildland Fire Shelters 3,611.22
261-3600 53030 Fire Training Classrooms 144,699.50 _
261-3600-53031 Mobile Data Terminals _ _ 38,319.52
261-3600-53032 Tamar Opticom _ 9,032.49
261-4283-43200 Contractual Services 86,324.80
261-4283-50003 Building & Equipment 38,095.36
261-4490-501 1 8 PM 10_Mitigation _ 5,495.24
261-4491-501 03 Traffic Volume Cour1Lmq__1 1,879.48
261-4491-50170 Indian Canyon Dr Widening 310,692-30
261-4491-50189 Speed Survey 2,979.17
261-4491-50190 Residential Traffic Speed Reduction 2,959.00
26 1-44 91-5 01 9 6 Indian Ave Uprr Bridge 273,098.57
---- —
261-4491-50200 Indian Canyon Proj - CVAG 3,A49.35
--- -- --- ---
261-4491-5D21D Oleanders & Irrigation - 18,704,24
261-4491-50211 Electric & Irrigation NPC @ EPC 86,528,70 _
261-4491-50219 _ Downtown Relighting __ _- 13,400.00
261-4491-50221 South Palm Canyon Bridge 381,494.00 --
261-4491-50230 Signal Via Escueia/Gene Aut 22,425.00_
261-4491-50241 2005 STP Pvmt Rehab^^ 86,493-21 _
26 1-449 1-5 0244 Bogert Trail Bridge Rep 655,786.00
261-4491-50249 ISS821 06-07 115,7 00.00
261-4491-5029 Golf Club Drive Culvert 350,499-61
261-4491-50257 Gene Autry Trail/Vista Chino Median 1,374,225-00 -
261-4491-50258 Caballeros St Improve (MSRC) 7,123-00
261-4491-50289 Ca6alle_ros St Improve (CMAQ) 4,388.00 _
261-4491-50261 _Signal Modification Project _ 100,000,00
261-4496-54002 Open Space Program 83,612.21
261-4496-54045 PalmCanyon LLC Habitat 102,000.00
261-4496-54048 (Monte Serena June Beetle 24,780-00 7,367,767.77
A.D. 161 Fund I _
325-7871-5028�Construction AD 161 59,465.76 59,465.76
A.D. 162 Fund I
326-7874-50289 Construction AD 162 1 _ 58,315,12 58,315.12
A.D. 164 Fund _
327-7875-50291 Construction AD 164 281,499.56 281,499.56
405p--600� Contractual Services 7,500.00 7,500.00
Airport CFC Fund_ _
Air ortFu d
415-6400-56062 AIP 37 313,897.20
415-6500-56077 Parking Gate Equip 21,200.00
415-6500-56078 Road Signage Enhancer 15,000.00
415-6600-68082 Airport Holdroom __ 1,358,365.40
415-6600-56063 AIP 38 _ _144,890.41
415-6600-56068 AIP 39 _ 238,510-29 2,091,863.30
Wastewater Treatment Plant Fund
420-6800-50000 Unscheduled Capital Pro ectsl 241,254.89 241,254-86
06d41- t
Facility Maintence Fund
520-5641-43240 Other Contractual Services 44,205.09 44,205,09
Risk Management Fund T
540-5904-486S5�Claims Expenses 456,895,00 456,895.00
'GIZANDTOTAL- — 27,583,179-9327.5-3�7-9-9
Section 2__ All appropriations approved subsequent to passage of this resolution
for the 2005-06 fiscal year, and not expended, are authorized to be
continued into the 2006-07 fiscal year.
ADOPTED this day of 12007
I
David H. Ready, City Manager
ATTEST'- _ _ -
James Thompson, City Clerk
CERTIFICATION
STATE OF CALIFORNIA )
COUNTY OF RIVERSIDE
CITY OF PALM SPRINGS ) _
I, JAMES THOMPSON, City Clerk of theme of Palm Springs, hereby certify that
Resolution No. is a full, true and correct copy, and was duly adopted at a regular
meeting of the City Councel of the City of the City of Palm Springs on
by the following vote:
AYES: --
NOES: _
ABSENT.
ABSTAIN: - - - — --
James Thompson, City Clerk
City of Palm Springs, California
- -- - —
®Gp®1 °
CITY OF PALM SPRINGS
APPROPRIATION LIMIT CALCULATION
2007/2008 Page 1
A Last Year's Limit 106,518.537
B Adjustment Factors
1. Population % 1.0022
2. Per Capita Personal Income% 1-0442
Total Adjustment(B1 X B2) 1.046497240
C Annual Adjustment((5-1.00)'A) 4,952,818
n Other Adjustments 0
E Total Adjustments 4,952,818
F This Year's Limit(07/03) (A+E) 111,471,355
Prepared by; Kim Hardcastle Prop 4 Limitation 7/16/2007
WORKSHEET#4 2007/2008 Page 2
A Proceeds of Taxes 64,711,851
B Exclusion 0
C Appropriation Subject to Limit 64,711,851
D Current Year Limit 111,471,355
E Over(Under) Limit(C-D) (46,759,504)
Prepared by: Kim Hardcastle Prop 4 Limitation 7/1 612 0 0 7
INTEREST EAPNINGS PRODUCED BY TAXES 2007/2008 Page 3
A Non Interest Tax Proceeds 64,711,851
a Minus Exclusions 0
C Net Invested Taxes (A-B) 64.711,851
D Total Non Interest Budget 85,206.165
E Tax Proceeds as Percent of Budget(C/D) 75.95%
F Interest Earnings 1,248,500
G Amount of Interest Earned From Taxes (E x F) 948,203
H Amount of Interest Earned From Non Taxes(F-G) 300.297
Prepared by: Kim Hardcastle Prop 4 Limitation 7/1 612 0 0 7
PROP4 CITY OF PALM SPRINGS 7/16/2007
APPROPRIATION LIMIT CALCULATION
2007/2008 Page 4
Interfund
FUND NAME FUND# Proceeds of taxes Revenues Interest Other Total
General Fund 001 52,789,005-00 1,249,871-00 568,000.00 9,905.562.00 64,512,438.00
Community Promotion 112 8,396,000.00 0,00 0-00 105,000-00 8,501,000-00
Forfeited Assets 120 0.00 0.00 2.000.00 0.00 2,000.00
Safety Augmentation 121 700,000,00 0.00 8,000.00 0.00 708,000.00
Indian Gaming 122 0.00 0.00 10,000,00 1,104,831-00 1,114,831-00
CSA 152 124 565,895.00 0.00 0.00 0.00 665,895.00
Recycling 125 0,00 0-00 125,000-00 475,000.00 600,000.00
Villagefest 127 0.00 0.00 0.00 380,250,00 380,250-00
Business Imp Dist 129 0.00 0,00 0.00 125,000.00 125,000.00
Parking 131 0.00 0.00 0.00 100,000-00 100,000.00
Parking Capital Projects 132 0,00 0,00 0.00 0,00 0.00
Gas Tax Improvement 133 0.00 0.00 17,000.00 838,000.00 855,000-00
Measure 134 1,989,000,00 0-00 120,000.00 1,100,000.00 3,209,000.00
Drainage 135 0.00 0.00 150,000,00 750,000.00 900,000-00
CDBG 137 0-00 0,00 0.00 519,000.00 519,000.00
Master Lease 139 0.00 0,00 5,000.00 1,262,000,00 1,267,000-00
CFD Public Safety#1 140 271,951,00 0.00 0.00 0.00 271,951.00
AQMD 149 0.00 0.00 500.00 52.500.00 53,000,00
Public Arts 150 0.00 0.00 15,000.00 252,000.00 267.000.00
Library Endowment 151 0.00 0-00 48,000-00 28,000.00 76,000.00
Special Projects 160 0.00 0.00 0.00 100,000.00 100,000-00
Capital Improvements 261 0.00 0.00 0,00 2,147,300.00 2,147,300.00
Debt Service Fund 301 0.00 0.00 180,000.00 0,00 180,000-00
Airport Customer Fee 405 0.00 0,00 0-00 1,200,000.00 1,200,000.00
Airport PFC 410 0.00 0.00 60,000.00 3,050.000.00 3,110,000-00
Airport 415 0.00 0.00 300,000,00 18,607,572.00 18,907,572.00
WVVfP 420 0,00 0.00 200,000-00 6.115,000.00 6,315,000,00
Golf Course 430 0.00 0.00 66,000.00 3,018,000,00 3,084,000-00
MVR 510 0.00 0.00 20,000.00 3,865,326.00 3,835,326.00
Facilities Maintenance 520 0.00 0.00 0.00 3,748,488.00 3,748,488-00
PERS 530 0.00 0.00 0.00 10,151.491.00 10,151,491-00
Risk Management 540 0.00 0.00 60,000.00 12,872,990-00 12,932,990.00
Retiree Health Insur 541 0,00 0-00 1,000-00 149,000.00 150,000,00
Energy 550 0.00 0.00 20.000.00 3,862,245,00 3,882.245-00
TOTAL 64,711,851.00 1,249.871,00 1,975,500,00 85,884,555.00 153,821,777.00
Enterprise/Internal Service 0.00 0,00 727,000-00 66,640,112.00 67,367,112.00
64,711,851.00 1,249,871.00 1,248,500-00 19.244,443.00 86,454,665,00
Prepared by: Kim Hardcastle Prop 4 Limitation 7/1612007
w IIII n
DEPARTMENT OF ARNOLD SCHWARZENEGGER, GOVERNOR
�4ipbRN��FINANCE 91 5 L STREET A 5ACRAMENTC CA A 95614-390e m M1YM'.00F.CA.BOv
May 2007
E01J, 1r.1 r_Ir•,IANGE
Dear Fiscal Officer:
Subject: price and Population Information MAY o 3 2007
Appropriations Limit
The California Revenue and Taxation Code, Section 2227, mandates the Department of Finance
(Finance)to transmit an estimate of the percentage change in population to local governments. Each
local jurisdiction must use their percentage change in population factor for January 1,2007, in conjunction
with a change in the cost of living, or price factor,to calculate their appropriations limit for fiscal year
2007-08. Enclosure I provides the change in California's per capita personal income and an example for
utilizing the price factor and population percentage change factor to calculate the 2007-08 appropriations
limit. Enclosure If provides city and unincorporated county population percentage changes, and
Enclosure IIA provides county and incorporated areas population percentage changes. The population
percentage change data excludes federal and state institutionalized populations and military populations,
as noted.
Population Percent Change for Special Districts
Some special districts must establish an annual appropriations limit. Consult the Revenue and Taxation
Code,Section 2228 for further information regarding the appropriation IimiL You can access the Code
from the following website: "http://www-leqinfo.ca.gov/calaw-html'check: "Revenue and Taxation Code"
and enter 2228 for the search term to learn more about the various population change factors available to
special districts to calculate their appropriations limit_ Article XIII B, Section 9, of the State Constitution
exempts certain special districts from the appropriations limit calculation mandate. Consult the following
website: "httpY/www.leginfo.ca.gov/.constt.artiole_136"for additional information. Special districts
required by law to calculate their appropriations limit must present the calculation as part of their annual
audit. Any questions special districts have on this issue should be referred to their respective county for
clarification, or to their legal representation, or to the law itself. No State agency reviews the local
appropriations limits.
Population Certification
The population certification program applies only to cities and counties. Revenue and Taxation Code
Section 11005.6 mandates Finance to automatically certify any population estimate that exceeds the
cul( troller's Offic
Please Note: City population estimates are controlled to independently calculated county population
estimates. Due to county estimates revisions;prior year's city population estimates may have also been
revised.
If you have any questions regarding this data, please contact the Demographic Research Unit
at(916)323-4086.
MICHAEL C. GENEST
Director
By.
VINCENT P. BROWN
Chief Deputy Director
Enclosure
May2007 Enclosure 1
A. Price Factor: Article XIII B specifies that local jurisdictions select their
cost-of-living factor to compute their appropriation limit by a vote of their governing
body. The cost-of-living factor provided here is per capita personal income. If the
percentage change in per capita personal income is selected, the percentage
change to be used in setting the 2007-2008 appropriation limit is:
Per Capita Personal Income
Fiscal Year Percentage change
(FY) over prior year
2007-2008 4.42
B. Following is an example using sample population change and the change in
California per capita personal income as growth factors in computing a 2007-2008
appropriation limit.
2007-2008:
Per Capita Cost of Living Change=4.42 percent
Population Change= 1.20 percent
Per Capita Cost of Living converted to a ratio: 4.4�0+0100 = 1.0442
Population converted to a ratio: 1.2010+0 00 = 1.0120
Calculation of factor for FY 2007-2008:
1.0442 x 1.0120=1.0567
Fiscal Year 2007-2008
Enclosure 11
Annual Percent Change in Population Minus Exclusions(`)
January 1,2006 to January 1,2007 and Total Population,January 1,2007
Total
County PerCnt Change - Population Minus Exclusions - Population
City 2006-2007 1.1.06 1-1-07 1-1-2007
Riverside
Banning -0.17 28,321 28,272 28,272
Beaumont 21.22 23,304 28,250 28,250
Blythe 0.29 13,610 13,650 22,625
Calimesa -0.68 7.465 7,414 7,414
Canyon Lake -0.40 11,013 10,969 10,969
Cathedral City 1,32 51,386 52,064 52,115
Coachella 8,57 35,449 38,486 38.486
Corona 0.35 145,659 146.164 146,164
Desert Hot Springs 6.23 22,163 23.544 23,544
Hemet 2.41 70,015 71.705 71,705
Indian Wells 0.88 4,899 4,942 4,942
Indio 6.94 72,142 77,146 77,146
Lake Elsinore 15.42 41,271 47,634 47,634
La Quinta 6.44 33,604 41,092 41,092
Moreno Valley 2,67 175,769 180.466 180,466
Mumeta 3,94 93,567 97,257 97.257
Norco -0.51 22,730 22,614 27,361
Palm Desert -0.25 49.879 49,752 49,752
Palm Springs 022 46.754 46,858 46,858
Perris 6,74 47,463 50,663 50,663
Rancho Mirage - 0,90 16,783 16,944 16,944
Riverside 0.57 289,747 291.398 291.398
San Jacinto 9.80 31,280 34,345 34,345
Temecula 3.55 94,575 97,935 97,935
Unincorporated 3.65 519.243 538,171 538,288
County Total 3,31 1.953,091 2,017.735 2.031.625
(')Exdusions include residents on federal military installations and group quarters'residents in state mental institutions,and state and federal
correctional Institutions.
Page 1
SUNGARD PENTAMATION - FUND ACCOUNTING MANAGER PAGE NUMBER: 1
DATE: 07/02/07 CITY OF PALM SPRINGS REVSTAII
TIME; 12:23:15 REVENUE STATUS REPORT
SELECTION CRITERIA: ALL
ACCOUNTING PERIOD: 1/06
SORTED BY: FUND,FUNCTION,DEPARTMENT,IST SUBTOTAL,ZND SUBTOTAL,ACCOUNT
TOTALED ON: FUND,FUNCTION,DEPARTMENT,IST 9UETOTAL,2ND SUBTOTAL
PAGE BREAKS ON; FUND,FUNCTION,DEPARTMENT
FUND-001 GENERAL, FUND
FUNCTION-1 GENERAL FUND
DEPARTMENT- TITLE NOT FOUND
1ST SUBTOTAL-7100 TAXES _
PERIOD YEAR TO DATE AVAILABLE YTD/
ACCOUNT - - - - - TITLE - - - - - BUDGET RECEIPTS RECEIVABLES REVENUE BALANCE BUD
31101 CURRENT YEAR TAXES SECUR 18,350,760.00 .0o 00 ,00 16,350,760,00 .00
31102 CURRENT YEAR TAXES UNSSC 750,000.00 ,00 .00 .00 750,000.00 .00
31103 PRIOR YEAR TAXES UNSEC $5,000.00 .Do .DO ,Do 55,000.00 ,00
31104 IN LIEU PROP TAX - MVIL 3,652,257,00 .Do .DO .00 3,652,257.00 .00
31130 CRA PASS THEO CITY OF P5 232,000.00 .Do .00 .00 232,000.00 ,00
31201 SALES & USE TAXES 8,845,220,00 .Do .00 .00 8,845,220.00 .00
31202 SALES TAX-ERAF REIMB 3,O1B,768.00 .Do .00 .00 31018,768.00 .00
31250 PARKING TAX SO,DD0.00 .00 ,OD .00 50,000.00 .00
31301 FRANCHISES 2,992,000.00 .00 .00 .00 2,992,000.00 .00
31401 TRANSIENT OCCUPANCY TAX 6,403,Do0,00 ,DO .00 .00 6,403,000.00 .00
31501 DOCUMENTARY TRANSFER TAX S60f000.00 .00 ,00 ,00 560,000.Op .00
31601 NEW DEVELOPMENT TAX 5051000.00 .Do .00 ,DO 505,000.00 .00
31701 UTILITY USERS TAX 7,375,000,00 .00 .00 ,Do 7,375,000,00 .00
TOTAL TITLE NOT FOUND 52,789,005.00 .00 ,00 .00 52,759,005.00 ,00
TOTAL TAXES Z,759,005.00 .00 .00 .00 52,789,o05.0o ,00
32108 ALARM FEES - FIRE 15,000.00 ,DO 00 ,Do 15,000.00 .00
32215 NEWS RACK PERMIT 500.p0 .0o ,00 .00 500,00 .00
32101 BUSINESS LICENSE 970,000.D0 .00 .Do ,OD 570,000,00 ,00
32102 ANIMAL LICENSES 324000.00 .00 .00 ,Do 32,000,00 .Do
32103 ABANDONED VEHIC ABATE FE 213,500.00 .00 .00 ,00 13,505,00 .00
32104 BASIC LIFE SUPPORT-FIRE 35,000.00 .Do .00 ,00 35,000.00 .Do
32105 ALARM FEES - POLICE 1151000.00 .Do ,pp ,00 115,000.00 .00
32201 BUILDING PERMITS 990,00o.00 .00 .00 ,Do 990,000,00 .00
32202 SEWER PERMITS INS FEE 20,000.00 .00 .Do .00 20,000,00 .Do
32202 CONSTRUCTION PERMITS 370,500.00 .00 .Do .00 370,800.00 .Do
32204 PERMIT ISSUANCE L35,500.Do .00 ,pp .00 I35,SDO.OD .00 32205 SIGN PERMITS 17,300,00 .00 .00 ,00 I7,500.00 .00
32206 TRANSPORTATION PERMIT 10,0pD.Op .00 ,00 ,00 I0,000.00 .00 32207 POOL DRAIN PERMITS 0,000.00 .00 .DO .00 2,DDo.00 .Do 32210 CODE COMPLIANCE INSPECT 34,000.00 .0o .Do ,00 32,000,00 .DO 32210 RENEWALS/MISC PERMITS 39,250.00 .00 .00 ,00 39,250.DD .OD
S2213 ZONING FEES 89,000.00 .00 .00 .00 89,000,00 .00
32213 SUBDIVISION FEES 185,p00,00 00 .00 .00 185,000,00 .00. 50,200.00 00
32301 RENT CONTROL REGISTRATIO 50,200.00 .00 00 ,00 .32302 RENT CONTROL MISC FEES 1,000.00 .00 .00 ,00 , 00 00
00 .TOTAL TITLE NOT FOUND 3,125,250,DO ,DD .00 .00 3,125,250.00 ,OD
TOTAL LICENSES AND PERMITS 3,125,250,00 ,00 .Do ,00 3,125,250.00 .00
33649 SAFER GRANT IOS,570.00 .00 .00 ,DO SD5,57D.00 .00
33GSO102 SAFER GRANT TRIBAL MATCH S8,5o3,Do .Da .O0 ,D0 85,503.D0 .00
33103 STATE HOMEOWNERS TAX REL 250,000,00 .00 ,Do .00 250,000,00 ,Oo
33103 STATE MOTOR IN LIEU TAY, 325,200.00 .00 .Do .00 250,000,00 .00
SUNGARD PENTAMATION - FUND ACCOUNTING MANAGER PAGE NUMBER: 2
DATE; 07/02/07 CITY OF PA1.44 SPRINGS REVSTAII
TIME; 12:23;15 REVENUE STATUS REPORT
SELECTION CRITERIA; ALL
ACCOUNTING PERIOD: 1/08
SORTED BY: FUND,FUNCTION,DEPARTMENT,IST SUBTOTAL,2ND SUBTOTAL,ACCOUNT
TOTALED ON: FDND,FUNCTSON,DEPARTMENT,l5T SUBTOTAL,2ND SUBTOTAL
PAGE BREAKS ON; FUND,FUNCTION,DEPARTMENT
FUND-001 GENERAL FUND
FUNCTION-1 GENERAL FUND
DEPARTMENT- TITLE NOT FOUND
1ST SUBTOTAL-3300 INTERGOVERNMENTAL
PERIOD YEAR TO DATE AVAILABLE YTD/
ACCOUNT - - - - - TITLE - - - - - BUDGET RECEIPTS RECEIVABLES REVENUE BALANCE BUD
33104 OFF HIGHWAY LICENSE FEE 500.00 .00 ,00 .00 500.00 .00
33109 PEACE OFF TRAINING FUNDS 25,000,00 .00 .00 .00 25,000,00 .00
33199 CASINO AGREEMENT 250,000.00 .00 .00 ,00 2501000100 .00
33200 TOURISM CONTR - TRIBE 434,000.00 .00 .00 .00 434,000.00 .00
33E20 OTS DUI GRANT 40,000,00 .00 .00 .DD 40,000.00 .00
33611 ST HIGHWAY MAINTENANCE 76,251,00 .00 .OD .00 26,251.00 .00
12620 FAMILY LITERACY GRANT 41,000.00 .00 .Oo ,00 41,000,00 .Do
33635 CA STATE LIE FUND NON GR 38,000.OD .00 .00 ,00 39,000.00 .00
TOTAL TITLE NOT FOUND 1,621,024.00 .00 .00 ,00 1,621,024.00 .00
TOTAL INTERGOVERNMENTAL 1,621,024.00 .00 .00 ,00 1,621,024,00 .00
34102 CONCESSIONS 500.00 .00 .00 .00 500.00 .00
34104 PRINTING CHARGES 10,000,00 ,00 ,00 .00 101DOO.00 .00
34105 ANIMAL SHELTER FEES 62,1$0.00 .00 .00 ,00 62,150.00 .00
34105 SALE OF MAPS & FUEL 4,000.00 .00 .00 .00 4,000.00 .00
34107 ASSESS DIST INFO GEN FUN 6,000.00 .00 .00 .00 51000.00 .00
34109 SMOKE DETECTOR INSPECTIO 84,600.00 ,00 ,00 ,00 84,600.DO ,00
34110 OTHER CHARGES CURRENT SV 7,500.00 ,00 .00 .00 7,500.00 .00
34112 TOWING FEES 95,000,00 .00 ,00 ,00 951DO0,00 .00
34114 MULTI UNST FIRE INSP FEE 103,000.00 .00 .00 .00 1D3r000.00 .00
34201 SHOOTING RANGE REVENUE 10,000,DO .00 ,00 ,00 10fooD.00 .00
34202 INMATE ENTERTAINMENT REV 500.00 ,00 ,00 ,00 500.00 .00
34203 SPEC POLICE DEPT SERVICE 210,659.00 ,OD ,00 .00 210,659,00 .00
34204 FINGERPRINT FEES 8,000.00 ,00 .00 co. g,000.00 .00
34205 RENT A CELL 130,000.00 ,00 .00 .00 1701000.0o .00
34206 SPEC. FIRE DEPT, SERVICE 275,956.00 ,00 .00 .00 273,956.00 .00
34209 FIRE INSPECTION FEE Soo.00 ,00 ,Oa .00 500.00 .00
34210 FIRE PLAN CHECK FEE 43,200.00 .00 .00 .00 43,200.00 .00
34211 FIRE COMMERCIAL INSP FEE 14,000.00 ,00 .00 .00 14,000.00 .00
34212 FIRE FEES MISC 13,000.00 .00 .00 ,OD 13,000.00 .00 34301 13UILDING PLAN CHECK FEES 576,000.00 -OD co ,00 578,000.00 .00
34302 ENGINEERING PLAN CHK F5E 570,100.00 ,00 ,00 .00 578,000.00 .00
34303 MISCELLANEOUS FILING F9E 622,47p,00 .00 00 .UO 570,100.00 .00 34304 MISC ENGINEERING FEES 22,470.00 .00 ,00 ,00 22,470.00 .00 34305 FAST TRACK PLAN CHECK FE 0,540.00 ,00 .Op ,DO 3,000.00 .00
3 a307 INHOUSE FAST PLAN CK FEE 63,500.OD ,OD .OD ,00 63,500.00 .00
34308 MICROFILMING FEES 42,200.00 ,00 .00 .00 42,200.D0 .00
34209 REAL. PROPERTY FEES 6,000.00 ,00 .00 ,OD 2,200.00 ,00
34330 GEN PLAN MAINT SURCFARGE 80,000.00 ,00 .00 .00 861000.00 .00
34330 PLANNING ADMIN SERV 10,000,00 .DO .00 ,p0 10,000.00 .00
34380 ADMIN SERVICE CHARGES � .00 ,00 .00 1,210,000.00 .00
343 BO NUISANCE ABATEMENT so QUO'QQ ,DO ,00 .00 49,571,00 .00 34381 NUISANCE ABATEMENT ADMIN 21,400.00 .00 .OD ,00 %1,400.00 .00 34401 DESERT DORADO LANDSCAPE 7:672.00 .00 ,00 .00 7,672,00 .00
SUNGARD PENTAMATION - FUND ACCOUNTING MANAGER PAGE NUMBER: 3
DATE: 07/02/07 CITY OF PALM SPRINGS REVSTAII
TIME: 12:23:15 REVENUE STATUS REPORT
SELECTION CRITERIA: ALL
ACCOUNTING PERIOD: 1/08
SORTED BY. FUND,FUNCTION,DEPARTMENT,IST SUBTOTAL,2ND SUBTOTAL,ACCOUNT
TOTALED ON: FUND,FUNCTION,DEPARTMENT,IST SUBTOTAL,= SUBTOTAL
PAGE BREAKS CN: FUND,FUNCTION,DEPARTMENT
FUND-001 GENERAL FUND
FUNCTION-1 GENERAL FUND
DEPARTMENT- TITLE NOT FOUND
IST SUBTOTAL-3400 CHARGES FOR SERVICES
PERIOD YEAR TO DATE AVAILABLE YTD/
ACCOUNT - - - - - TITLE - _ - - - EU➢GET RECEIPTS RECEIVABLES REVENUE BALANCE BUD
34402 CAMELOT VILLAS LANDSCAPE 5,341,00 .00 .00 .00 5,341,00 .00
34403 RANCHO PARK II LANDSCAPE 20,000,0o .00 .00 .00 20,000,00 .00
34404 PARKWAY MAINT DISTRICT 6 4,000,00 .00 .00 .00 4,000.00 .00
34405 PARKWAY MAINT ➢ISTRICT 1 3,000.00 .00 .00 .00 31000.00 .DD
34405 PARKWAY MAINT DISTRICT 9 7,OD0.00 .00 .00 .00 7,000,00 .00
34407 PARKWAY LGHTNG MNT DST 7 10,300.00 .00 .00 .00 10,300,00 .00
34410 PARKWAY MAINT DIST #10 10,000.00 .Do .00 .00 10,000.00 .00
34411 LIGHT MAINT DISTRICT #1 10,000,00 .00 .00 .00 101000,00 ,00
34412 LIGHT MAINT DISTRICT $2 4,000.00 .00 .00 .00 4,000.00 .00
34413 LIGHT MAINT DISTRICT #3 21 000.00 .00 .oa .00 21000.00 .00
34414 LIGHT MAINT DISTRICT #4 1,000,00 .00 ,00 .00 11000,00 .00
34415 PARKWAY MAINT DIST #6A 5,000,00 ,00 .00 ,00 5,000.00 _00
34416 PARKWAY MAINT DIST #6E 2,000.00 .00 .00 .00 21000,00 .ao
14417 PARKWAY MAINT DIST #6C 11,000,00 .Do .00 .00 I11000.00 .00
34505 ISSUANCE FEE 55,000,00 .Do .00 .aD 55,000,00 .00
34506 TLC/PSVU SITE FEES 10,000,00 .Do .00 .co 10,000,00 .00
34511 LIBRARY FEES 27,000.00 .aD .00 .00 27,000,00 .00
34602 CAMP 50,000,00 .00 .D0 .00 80,000.00 .Do
34503 INSTRUCTIONAL DANCE 163,000,00 ,00 .DD .30 163,Ooo.no .Do
34805 PRESCHOOL PROGRAMS 25,000,00 .DO .00 .00 25,000.00 .00
34606 YOUTH PROGRAMS 45,000,00 .00 .00 .00 45,000.00 .00
34606 FACILITES RENT 105,000.00 .00 .00 .00 105,000.00 .00
34609 SPECIAL ACTIVITIES 25,000.00 .00 .00 .aa 25,o00,0o .00
34610 LOCATION PERMITS 12,OOD.00 .00 .00 .00 12,ODD,00 .00
34612 DAILY ADMISSIONS 15,000.00 .00 .00 .00 15,000.00 .00
34613 GROUP LESSONS l,00➢.00 .00 .00 .DD 1,000.00 -DO
34615 POOL RENTAL GROUP 33,000.00 .00 .00 .00 35,000.00 .00
34616 POOL PASSES 15,000.00 .00 .00 .00 15,000,00 .00
34617 COIN LOCKERS 500,00 .00 .00 .0o 5D0.00 .Do
34619 SOFTBALL 6,aao.00 .00 .00 .00 61000,00 .00
34621 INSTRUCTIONAL CLASSES 4,000,00 .00 .00 _00 4,000,00 .00
34622 HIKING 15,000.00 .OD .00 .00 15,000.00 .00
34623 TOURNAMENTS 40,200,00 ,00 .00 .00 40,200,00 .00
34624 PS ANGELS STADIUM RENT 40,000.00 .00 .00 .00 40,000,00 .00
34925 JOJDHUC SPECIAL PROGRAMS 1,000.00 .00 .00 .00 11000,00 .00
34626 JCJDHUC FACILITY RENT 10,000.00 .00 .00 .00 10,000,00 .00
34627 JOJDHVC VENDING 500.00 .00 .0a .00 500.00 .00
34650 SKeATE PARK ADMISSION 16,000.00 .00 .00 .00 15,000.00 ,00
TOTAL TITLE NOT FOUND 5,236,159.00 ,00 5,218,000.00 ,00
TOTAL CHARGES FOR SERVICES 5,236,159.00 .00 .00 .00 5,236,159.00 ,0o
35I01 FALSE ALARM FEZ 125,000,00 00 125,000.00 ,00
.OD .00 ,35102 VEHICLE CODE FINES 190,000.00 ,00 ,Do ,
35103 CRIMINAL CODE FINES 121500,D0 .00 Do .00 190,000.00 00
. .00 12,500,00 .00
SUNGARD PENTAMATION - FUND ACCOUNTING MANAGER PAGE NUMBER: 4
DATE: 07/02/07 CITY OF PALM SPRINGS REVSTAll
TIME: 12:23;15 REVENUE STATUS REPORT
SELECTION CRITERIA: ALL
ACCOUNTING PERIOD: 1/pa
SORTED BY: FUND,FUNCTICN,DEPARTMENT,1ST $USTOTAL,2ND SUBTOTAL„ACCOUNT
TOTALED ON: FUND,FUNCTION,DEPARTMENT,IST SUBTOTAL,2ND SUBTOTAL
PAGE BREAKS ON; FUND,FUNCTION,DEPARTMENT
FOND-001 GENERAL FUND
FUNCTION-1 GENERAL FUND
DEPARTMENT- TITLE NOT FOUND
1ST SUBTOTAL-3500 FINES AND PENALTIES
PERIOD YEAR TO DATE AVAILABLE YTD/
ACCOUNT - - - - - TITLE - - - - - BUDGET RECEIPTS RECEIVABLES REVENUE BALANCE BUD
3510$ LAI'E CHARGES 1,000,00 ,q0 .00 .00 1,000.00 .00
35106 LIBRARY FINES & FEES 26,500,00 .00 .00 .00 26,500,00 ,00
351D6 ADMINISTRATIVE CITATIONS 31,000,00 .oQ .00 .00 31,000,00 .00
TOTAL TITLE NOT FOUND 1$61000.00 .00 .00 .Do 386,000,00 .00
TOTAL FINES AND PENALTIES 386,000.00 .00 ,00 .00 386,000,00 .00
36101 INTEREST INCOME 568,000.00 .00 .00 .00 56S,000.00 .Oq
36104 LAND RENTAL 335,000.00 ,00 ,00 ,00 335,000.00 .OD
36105 BUILDING/PACILITTES RENT 40,000.00 ,00 ,00 .00 40,000.00 .00
36106 POLICE BUILDING RENT 100,500.00 .00 .00 ,00 100,500,00 .00
36107 CRA OFFICE RENTAL 16,500,00 ,DO ,00 .00 16,500.0o ,00
35109 VILLAGE GREEN RENTAL 24,000.00 .00 .00 -00 24,000,00 .00
TOTAL TITLE NOT FOUND 1,084,000.00 ,00 .00 .Do 1,084,000.00 ,00
TOTAL USE OF MONEY 1,0B4,ODD.00 .00 .00 .00 1,084,000.00 .00
37102 WASTE DISPOSAL CLEARING 15,000.00 .00 .00 .00 15,000,00 .Do
37103 AUDIT RECOVERY 15,0OD.00 .00 .00 .00 15,000.00 .00
37107 CRA ADMIN SERVICES 160,000.00 .00 .00 ,00 160,Op0,00 .00
31110 PSCT SERVICES 1,000.00 .00 00 .00 1,000,00 .00
37111 SMIP 2,500,00 .00 ..00 .00 2,500.0D .00
37112 SMIP II 2,000.00 ,00 .00 .00 2,000.00 .00
37113 MISCELLANEOUS REVENUE 15,000.00 .OD ,00 .00 15,000.00 .00
37119 VENDING MACHINES 7,soo.ao .aD .Do .00 7,500.00 .00
37117 PARK & FIELD RENTAL 40,000,00 .00 ,p0 ,pp 40,000.pO .00
37118 BANNER HANGING 8,000,p0 .GD .00 .00 E,000,00 .00
TOTAL TITLE NOT FOUND 26E,000,00 .OD .00 .00 268,000,00 ,00
TOTAL MISC 266,000.00 .00 .00 .00 266,000.00 .00
37801 SALE REAL OR PERSNL PROP 51000,00 .00 .00 00 5,000.00 .00
TOTAL TXTLE NOT FOUND 5,000.00 .00 .00 .OD 5,000.00 .00
TOTAL SALES OF FIRED ASSETS 5,000,00 ,00 ,00 ,00 5,000,00 .00
TOTAL TITLE NOT FOUND 54,512r438.00 ,OD .00 .00 64,512,438.00 .00
TOTAL GENERAL FUND 64,512,438.00 .00 .00 .00 64,512,438.o0 .00
TOTAL GENERAL FUND 64,512,438.00 .00 .00
.00 64,SI2,43B.00 .00
SUNG=) PENTAMATION - FUND ACCOUNTING MANAGER PAGE NUMBER: 5
DATE: 07/02/07 CITY OF PALM $?RINGS REV$TA11
TIME: 1$;23:15 REVENUE STATUS REPORT
SELECTION CRITERIA: ALL
ACCOUNTING PERIOD: 1/05
SORTED EY: FUND,FUNCTION,DEPARTMENT,1$T SUBTOTAL,= SUBTOTAL,ACCOUNT
TOTALED ON: FUND,FUNCTION,I]EPARTMENT,AST SUBTOTAL,2ND SUBTOTAL
PAGE BREAKS ON: FUND,FUNCTION,DEPARTMENT
FUND-112 COMMUNITY PROMOTION
FUNCTION-2 SPECIAL REVENUE FUNDS
DEPARTMENT- TITLE NOT FOUND
1ST SUBTOTAL-3100 TAXES
PERIOD YEAR TO DATE AVAILABLE YTD/
ACCOUNT - - - - - TITLE - - - - - BUDGET RECEIPTS RECEIVABLES REVENUE BALANCE BUD
31401 TRANSIENT OCCUPANCY TAX 8,395,000.00 .00 ,DO .00 8,395,000.00 .Do
31402 TRANSIENT OCCUPANCY PERM 11 000,00 .00 .00 .00 11 000.00 .00
TOTAL TITLE NOT FOUND 8,396,000,00 .00 .DO .00 8,396,000.OD .00
TOTAL TAXES 8,396,000.00 .00 .00 ,00 8,396,000.00 _00
34609 SPECIAL ACTIVITIES 40,000.00 ,00 .00 ,00 40,000,00 .00
TOTAL TITLE NOT FOUND 40,OD0.00 .00 .00 .00 40,000.00 .00
TOTAL C%ARCES FOR SERVICES 40,000.00 .00 ,00 .00 40,000.00 .00
3610S BUILDING/FACILITIE$ RENT 10,000.00 .00 .00 .00 101000,00 .00
TOTAL TITLE NOT FOUND 10,000.00 .00 .00 ,00 10,000,00 .00
TOTAL USE OF MONEY 10,000.00 ,00 .00 .00 10,000.00 .DO
37101 PEN/INT DELQ TAXES 75,000,00 .00 .00 .00 25,000,00 .00
37703 AUDIT RECOVERY 30,000,00 .00 ,00 .00 30,000.00 .00
TOTAL TITLE NOT FOUND 55,000.00 .00 .00 ,00 55,000.00 .00
TOTAL MISC 95,000.00 .00 .00 ,00 55,000,00 .00
TOTAL TITLE NOT FOUND S,5011000.00 ,00 .00 .00 8,501,000.00 .00
TOTAL SPECIAL REVENUE FUNDS 8,501,000.00 .00 .00 .00 8,501,000.00 ,OD
TOTAL COMMUNITY PROMOTION 8,501,000.OD .00 .00 ,00 $1501,000.00 .00
SUNGARD PENTAMATION - FUND ACCOUNTING MANAGER PAGE NUMBER: 6
DATE. 07/02/07 CITY OF PALM SPRINGS REVSTAII
TIME: 12;23:15 REVENUE STATUS REPORT
SELECTION CRITERIA; ALL
ACCOUNTING PERIOD: 1/06
SORTED BY: FUND,FUNCTION,DEPARTMENT,IST SUBTOTAL,2ND SUBTOTAL,ACCOUNT
TOTALED ON: FUND,FUNCTION,DEPARTMENT,1ST SU]3TOTAL,2ND SUBTOTAL
' PAGE BREAKS ON: FUND,FUNCTION,DEPARTMENT
FUND-120 FORFEITED ASSETS
FUNCTION-2 SPECIAL REVENUE FUNDS
DEPARTMENT- TITLE NOT FOUND
1ST SUBTOTAL-3600 USE OF MONEY
PERIOD YEAR TO DATE AVAILABLE YTD/
ACCOUNT - - - - - TITLE - - - - - BUDGET RECBIPTS RECEIVABLES REVENUE BALANCE BUD
36101 INTEREST INCOME 2,000.00 ,00 .00 .00 2.000,00 .00
TOTAL TITLE NOT FOUND 2,000.00 ,00 .00 .00 2,000.00 .00
TOTAL USE OF MONEY 2,000.00 .00 .00 ,00 2,000,00 ,00
TOTAL TITLE NOT FOUND 2,000.00 .00 .00 .00 2,000.00 .00
TOTAL SPECIAL REVENUE FUNDS 21000,00 .00 .00 ,00 2,000.00 .00
TOTAL FORFEITED ASSETS 2,000.00 .00 .00 .00 2,000.00 .00
SVNGARD PENTADIATION - FUND ACCOLTITSNG MANAGER
PAGE NUMBER: 7
DATE: 07/02/07 CITY OF P7�LM SPRINGS REVSTAll
TIME: 12:23:15 REVENUE STATUS REPORT
SELECTION CRITERIA; ALL
ACCOUNTING PERIOD: 1/08
SORTED BY: FUND,FUNCTION,DEPARTMENT,IST SUETOTAL,2ND 5UBTOTAL,ACCOUNT
TOTALED ON: FUND,FUNCTION,DEPARTMENT,IST SUSTOTAL,2ND SUBTOTAL
PAGE BREAKS ON: FUND,FUNCTION,DEPARTMENT
FUND-121 SAFETY AUGMENTATION
FUNCTION-2 SPECIAL REVENUE FUNS
DEPARTMENT- TITLE NOT FOUND
1ST SUBTOTAL-3100 TAXES
PERIOD YEAR TO DATE AVAILABLE YTD/
ACCOUNT - - - - - TITLE - - - - - BUDGET RECEIPTS RECEIVABLES REVENUE BALANCE BUD
21201 SALES & USE TAXES 700,000.00 .00 .00 .00 700,000.00 .00
TOTAL TITLE NOT FOUNT] 700,000.00 .00 ,00 .00 700,000.00 .00
TOTAL TAXES 00,000.00 .00 ,00 .00 700,000,00 .00
29101 INTEREST INCOME 8,000.00 .00 .00 .00 51000,00 .00
TOTAL TITLE NOT FOUND 8,000.00 .00 ,00 .00 9,000,00 .00
TOTAL USE CF MONEY 6,000.00 .00 .00 _00 5,000.00 .00
TOTAL TITLE NOT FOUND 708,000,00 .00 .00 .00 709,000.00 .00
TOTAL SPECIAL REVENUE FUNDS 700,Oo0.00 00 ,00 .00 70$,000.00 .00
TOTAL SAFETY AUGMENTATION 7OS,000,00 .00 ,00 ,00 708,000.00 .00
SUNGARD PENTAMATICN - FUND ACCOUNTING MANAGER PAGE NUMBER: 6
DATE: 07/02/07 CITY OF PALM SPRINGS REVSTAII
TIME: 12;23:15 REVENUE STATUS REPORT
SELECTION CRITERIA: ALL
ACCOUNTING PERIOD: 1/06
SORTED BY; FUND,FUNCTION,DEPARTMENT,IST SUBTOTAL,2ND SUBTOTAL,ACCOUNT
TOTALED ON; FUND,FUNCTION,DEPARTMENT,I5T SUBTOTAL,2ND SUBTOTAL
PAGE BREAKS ON: FUND,FUNCTION,DEPARTMENT
FUND-122 INDSAN GAMING SP ➢ISTRIB
FUNCTION-2 SPECIAL REVENUE FUNDS
DEPARTMENT- TITLE NOT FOUND
1ST SUBTOTAL-3300 INTERGOVERNMENTAL
PERIOD YEAR TO DATE AVAILABLE YTD/
ACCOUNT - .. - - - TITLE - - - - - BUDGET RECEIPTS RECEIVAELES REVENUE BALANCE BUD
33196 INDIAN SPECIAL DIST FEE 1,104,831.00 ,00 .00 .00 1,104,831.00 .00
TOTAL TITLE NOT POUND 1,104,631 00 .00 .00 ,00 1,104,831.00 ,00
TOTAL INTERGOVERNMENTAL 1,104,831.00 .00 ,00 .00 1,104,831,00 .00
36101 INTEREST INCOME 10,000.00 .00 .00 .00 10,000.00 .00
TOTAL TITLE NOT FOUND 10,000.00 .00 ,00 .00 10,000.00 .00
TOTAL USE OF MONEY 10,000,00 .00 .00 ,00 10,000.00 .00
TOTAL TITLE NOT FOUND 1,114,831.00 .00 .00 ,00 1,114,831,00 .00
TOTAL SPECIAL REVENUE FUNDS 1,114,031.00 ,00 .DO .00 1,114,831.00 .00
TOTAL INDIAN GAMING SP DISTRI 1,114,831,00 .00 ,p0 .00 1,114,831.00 .00
SUNGARD PF,NTAMATION - FUND ACCOUNTING MANAGER PAGE NUMBER: 9
DATE; 07/02/07 CITY CF PALM SPRINGS REVSTAII
TIME: 12:23:15 REVENUE STATUS REPORT
SELECTION CRITERIA: ALL
ACCOUNTING PERIOD: 1/08
SORTED BY: FUND,FUNCTION,DEPARTMENT,IST SUETOTAL,2ND SUBTOTAL„ACCOUNT
TOTALED ON: FUND,FUNCTION,DEPARTMENT,1ST SUBTOTAL,2ND SUBTOMs
PAGE BREAKS ON: FUND,FUNCTICN,DEPARTMENT
FUND-124 CSA 152
FUNCTION-2 SPECIAL REVENUE FONDS
DEPARTMENT- TITLE NOT FOUND
1ST SUBTOTAL-3550 SPECIAL ASSESSMENTS
PERIOD YEAR TO DATE AVAILABLE YTD/
ACCOUNT - - - - - TITLE - - _ - - BUDGET RECEIPTS RECEIVABLES REVENUE BALANCE BUD
38501 CSA 152 ASSESSMENT 565,895.00 .00 .00 .00 565,855.00 .00
TOTAL TITLE NOT FOUND 565,655.00 .00 .00 .00 565,895.00 .00
TOTAL SPECIAL ASSESSMENTS 565,895.0 .00 ,00 .00 5651895,00 .00
TOTAL TITLE NOT FOUND 565,895.00 .00 .00 .00 565,895.00 .00
TOTAL SPECIAL REVENUE FUNDS 565,895.00 .00 ,DD .00 565,895.00 .00
TOTAL, CSA 152 595,695.00 .00 .OD .00 $65,895,00 .00
SUNGARD PENTAMATION - FUND ACCOUNTING MANAGER PAGE NUMBER: 10
DATE; 07/02/07 CITY OF PALM SPRINGS REVSTAII
TIME: 12:23:15 REVENUE STATUS REPORT
SELECTION CRITERIA: ALL
ACCOUNTING PERIOD; 1/06
SORTED BY: FUND,FUNCTION,DEPARTMENT,IST SUBTOTAL,2ND SUBTOTAL,ACCOUNT
TOTALED ON: FUND,FUNCTION,DEPARTMENT,IST SUBTOTAL,2ND SUBTOTAL
PAGE BREAKS ON: FUND,FCNCTION,DEPARTMENT
FUND-125 RECYCLING
FUNCTION-2 SPECIAL REVENUE FUNDS
DEPARTMENT- TITLE NOT FOUND
1ST SLTSTQTAL-3400 CHARGES FOR SERVICES
PERIOD YEAR TO DATE AVAILABLE YTD/
ACCOUNT - - - - - TITLE - - - - - BUDGET RECEIPTS RECEIVABLES REVENUE BALANCE BUD
34395 RECYCLING SURCHARGE 175,000,00 .00 ,00 .00 175,000.00 .00
34399 DIVERSION FACILITY FEE 300,000.00 ,00 00 .00 3001000.00 ,00
TOTAL TITLE NOT FOUND 475,000.00 .00 00 .00 475,000.00 .00
TOTAL CHARGES FOR SERVICES 475,000.00 .00 .00 .00 475,000.00 -00
36101 INTEREST INCOME. 125,000.00 .00 .00 .00 125,000.00 .00
TOTAL TITLE NOT FOUND 125,000.00 ,00 .00 ,O0 125,000,00 .00
TOTAL USE OF MONEY 125,000.00 .00 ,00 .00 125,000.00 .00
TOTAL TITLE NOT FOUND $00,000,00 .00 .00 .00 600,000,00 .00
TOTAL SPECIAL REVENUE FUNDS 600,000.00 .00 00 .00 600,000.00 .00
TOTAL RECYCLING 900,000,00 .O0 .00 .00 600,000.00 .00
SUNGARD PENTAMILTION - FUND ACCOUNTING MANAGER PAGE NUMBER: 11
DATE: 07/02/07 CITY OF PALM SPRINGS REVSTAII
TIME: 12:23:15 REVENUE STATUS REPORT
SELECTION CRITERIA: ALL
ACCOUNTING PERIOD: 1/06
SORTED BY: FUND,FUNCTION,DEPARTMENT,IST SUBTOTAL,2ND SUBTOTAL,ACCOUNT
TOTALED ON: FUND,Ft1NCTI0N,DEPARTMENT,IST SUBTOTAL,2ND SUBTOTAL
PAGE BREAKS ON: FUND,FUNCTION,DEPARTMENT
FUND-127 P$ VILLAGEFEST
FUNCTION-2 SPECIAL REVENUE FUNDS
DEPARTMENT- TITLE NOT FOUND
1ST SUBTOTAL-3200 LICENSES AND PERMITS
PERIOD YEAR TO DATE AVAILABLE YTD/
ACCOUNT - - - - - TITLE - - - - - BUDGET RECEIPTS RECEIVABLES REVENUE BALANCE BUD
32107 PALM SPRINGS VILLACEFEST 366,000,00 .DO .00 .00 366,000.00 .00
TOTAL TITLE NOT FOUND 266,000,00 .00 .00 .00 386,000.00 .00
TOTAL LICENSES AND PERMITS 366,000.00 .00 .00 .00 366,000,00 .00
34111 INSURANCE 14,250.00 .00 .00 .00 14,250.00 .00
TOTAL TITLE NOT FOUND 14,250,00 .Oo .00 .00 14,250,00 .00
TOTAT, CHARGES POR SERVICES 14,250.00 .00 .00 .00 14,250.00 .0o
TOTAL TITLE NOT FOUND 380,250.00 .00 .00 .00 380,250,00 .00
TOTAL SPECIAL REVENUE FUNDS 380,250,00 .00 .00 .00 380,250.00 .00
TOTAL PS VILLAGEFEST 380,250.00 .00 .00 .00 380,250,00 .00
SUNGAR➢ PENTAIuaTION - FUND ACCOUNTING MANAGER PAGE NUMBER: 12
DATE: 07/02/07 CITY OF PALM SPRINGS R$VSTAll
TIME; 12:23:15 REVENUE STATUS REPORT
SELECTION CRITERIA: ALL
ACCOUNTING PERIOD: 1/08
SORTED BY: FUND,FUNCTION,DEPARTMENT,IST SUBTOTAI.,2ND SUBTOTAL,ACCOUNT
TOTALED ON: FUN➢,FUNCTTON,DEPARTMENT,IST SUBTOTAL,2ND SUBTOTAL
PAGE BREAKS 00. FUND,FUNCflQN,DEPARTMENT
FUND-129 BUSINESS IMPROV DISTRICT
FUNCTION-20 PUBLIC WORKS
DEPARTMENT- TITLE NOT FOUND
1ST SUBTOTAL-3E50 SPECIAL ASSESSMENTS
PEP.T.OD YEAR TO DATE AVAILABLE YTD/
ACCOUNT - - - - - TITLE - - - - - BUDGET RECEIPTS RECEIVABLES REVENUE $ALANCE BUD
36505 BUSINESS IMPROV DISTRICT 125,000.00 .00 .00 .00 125,000.00 .00
TOTAL TITLE NOT FOUND 125,000 00 00 .00 .00 125,000.00 .00
TOTAL SPECIAL ASSESSMENT$ 125,000.00 .00 .00 .00 125,000.00 .00
TOTAL TITLE. NOT FOUND 125,000.00 .00 00 .00 125,000.00 .00
TOTAL PUBLIC WORKS 125,000.00 .00 .00 .00 125,000.00 .00
TOTAL BUSINESS IMPROV DISTRIC 125,000.00 .00 .00 .00 125,000.00 .00
SUNGARD PENTAMATION - FUND ACCOUNTING MANAGER PAGE NUMBER: 13
DATE- 07/02/07 CITY OF PALM SPRINGS REVSTAII
TIME: 12;23:15 REVENUE STATUS REPORT
SELECTION CRITERIA: ALL
ACCOUNTING PERIOD: 1/08
SORTED BY: FUND,FUNCTION,DEPARTMENT,IST SUBTOTAL,:=) SUBTOTAL,ACCOUNT
TOTALED ON: FUND,FUNCTION,DEPARTMENT,IST SUBTOTAL,2ND SUBTOTAL
PAGE BREAKS ON: FUND,FUNCTION,)EPARTMENT
FUND-131 PARKING
FUNCTION-2 SPECIAL REVENUE FUNDS
DEPARTMENT- TITLE NOT FOUND
IST SMTOTAL-3400 CHARGES FOR SERVICES
PERIOD YEAR TO DATE AVAILABLE YTD/
ACCOUNT - - - - - TITLE - - - - - BUDGET RECEIPTS RECEIVABLES REVENUE BALANCE BUD
14360 HENRY FRANK ARCADE LOT 2 1,000,00 .00 .00 .00 1,000.00 .00
34366 DOWNTOWN PARKING FEES S,000,00 .00 .00 .00 S,000,00 ,00
TOTAL TITLE NOT FOUND 6,000.00 .00 .00 .00 G'000.00 ,00
TOTAL CHARGES FOR SERVICES 6,000.00 .00 ,00 .00 61000.00 .00
35104 RANKING VIOLATIONS 94,000,00 .00 00 .00 94,000,00 .00
TOTAL TITLE NOT FOUND 94,000.00 .00 00 .00 94,000,00 .00
TOTAL FINES AND PENALTIES 94,000600 .00 .00 ,00 9n,000.Do .00
TOTAL TITLE NOT FOUND 100,000,00 .00 .00 .00 100,000.00 .00
TOTAL SPECIAL REVENUE FUNDS 100,000,00 .00 .00 .00 100,000,00 ,00
TOTAL PARKING 100,000.00 .OD .00 .00 100,000.00 .00
SUNGARD FENTAMATION - FUND ACCOUNTING MANAGER PAGE NUMBER; 14
DATE: 07/02/07 CITY OF PALM SPRINGS REVSTAII
TIME: 12:23:15 REVENUE STATUS REPORT
SELECTION CRITERIA: ALL
ACCOUNTING PERIOD; 1/08
SORTED BY: FUND,FUNCTION,DEPARTMENT,IST SU6TOTAL,2ND SUBTOTAL,ACCOUNT
TOTALED ON: FONO,FUNCTION,DEPARTMENT,IST SUBTOTAL,2ND SUBTOTAL
PAGE BREAKS ON: FUND,FUNCTION,DEPARTMENT
FUND-133 SPECIAL GAS TAX IMPRVMENT
FUNCTION-2 SPECIAL REVENUE FUNDS
➢EPnTMENT- TITLE NOT FOUND
1ST SUBTOTAL-3300 INTERGOVERNMENTAL
PERIOD YEAR TO DATE AVAILABLE YTD/
ACCOUNT - - - - - TITLE - - - - - BUDGET RECEIPTS RECEIVABLES REVENUE BALANCE BUD
33201 STATE GAS TAX 2107 FUNDS 360,000.00 .00 .00 .00 360,000.00 ,00
33202 STATE GAS TAX 2107.5 FND 6,000.00 .00 .00 .00 6,000.00 .00
13203 STATE GAS TAX 2106 FUNDS 196,000.00 .00 .00 .00 196,000.00 .00
.13204 STATE GAS TAX 2105 FUNS 276,000.00 .00 .00 .00 276,000.00 .00
TOTAL TITLE NOT FOUND 836,000.00 .00 .00 .00 B28,000.00 .00
TOTAL INTERGOVERNMENTAL 838,000,00 .00 00 .00 828,000.00 .00
36101 INTEREST INCOME 17,000.00 .00 ,DO ,00 17,000,00 .00
TOTAL TITLE NOT FOUND 17,000.00 .00 .00 .00 17,000.00 .00
TOTAL USE OF MONEY 17,000.00 .00 .00 .00 17,000,00 .DD
TOTAL TITLE NOT FOUND 655,000.00 .00 .00 .00 855,000.00 .00
TOTAL SPECIAL REVENUE FONDS 85$,OD0.00 ,00 00 .00 655,000.00 .00
TOTAL SPECIAL GAS TAX IMPRVME 855,000.00 .00 .00 .00 555,000,00 ,00
SUNGARD PENTAMATION - FUND ACCOUNTING MANAGER PAGE NVMSBR: 15
DATE: 07/02/07 CITY OF PALM SPRINGS REVSTAII
TIME: 12:23:15 REVENUE STATUS REPORT
SELECTION CRITERIA: ALL
ACCOUNTING PERIOD: 1/08
SORTED By: FUND,FUNCTION,DEPARTMENT,IST SUBTOTAL,2ND SUBTOTAL,ACCOUNT
TOTALED ON; FUND,FUNCTION,DEPARTMENT,IST SUETOTAL,2ND SUBTOTAL
PAGE BREAKS ON: FUND,FUNCTION,DEPARTMENT
FUND-134 MEASURE A IMPROVEMENTS
FUNCTION-2 SPECIAL REVENUE FONDS
DEPARTMENT- TITLE NOT FOUND
1ST SUBTOTAL-3100 TAXES
PERIOD YEAR TO DATE AVAILABLE YTD/
ACCOUNT - - - - - TITLE - - _ _ _ BUDGET RECEIPTS RECEIVABLES REVENUE BALANCE BUD
31201 SALES & ❑SE TAXES 115891000.00 .00 ,00 .00 11989,000.00 .00
TOTAL TITLE NOT FOUND 11989,000.00 .00 ,00 .00 11969,000,00 .00
TOTAL TAKES 1,989,000.0 .00 ,00 .00 11989,000.00 ,DO
33106 REGIONAL FUNDS - CVAG 1,100,000.00 .00 .00 .00 111001000.00 ,00
TOTAL TITLE NOT FOUND 1,100,000.00 .OD .00 .00 111001000.00 ,00
TOTAL INTERGOVERNMENTAL 1,100,000.00 ,00 00 ,00 1,100,000.00 ,OO
36101 INTEREST INCOME iz0,000.00 .00 00 .00 120,000.00 .00
TOT;Z TITLE NOT FOUND 120,000,00 .DO .00 .00 120,000,00 ,00
TOTAL USE OF MONEY 120,000,00 AD .00 .00 120,000.00 .00
TOTAL TITLE NOT FOUND 3,209,000.00 ,00 ,00 .00 31209,000.00 .00
TOTAL SPECIAL REVENUE FUNDS 3,209,000 00 .00 ,00 .00 312091000.00 ,00
TOTAL MEASURE A IMPROVEMENTS 3,209,000.00 .00 ,DO .00 3,209,000,00 .DO
SUNGARD PENTAMATION - FUND ACCOUNTING MANAGER PAGE NUMBER. 16
DATE: 07/02/07 CITY OF PALM SPRINGS REVSTAll
TIME: 12:23:15 REVENUE STATUS REPORT
SELECTION CRITERIA: ALL
ACCOUNTING PERIOD: 1/06
SORTED BY: FUND,FUNCTION,DEPARTMENT,IST SUBTOTAL,= SUBTOTAL,ACCOUNT
TOTALED ON: FUND,FUNCTION,I)EPARTMENT,IST SUHTOTAL,2ND SUBTOTAL
PAGE BREAKS ON: FUND,FUNCTION,DEPARTMENT
FIIIM-135 DRAINAGE
FUNCTION-2 SPECIAL REVENUE FUNDS
DEPARTMENT- TITLE NOT FOUND
1ST SUBTOTAL-3200 LICENSES AND PERMITS
PERIOD YEAR TO DATE AVAILABLE YTD/
ACCOUNT - - - - - TITLE - - _ ., BUDGET RECEIPTS RECEIVABLES REVENUE BALANCE 8Up
32400 CENTRAL ZONE 430,000.00 .00 .00 .00 430,000.00 .00
12401 SOUTHEAST ZONE 5o,000.00 .00 .00 .00 50,000.00 .00
32402 NORTH ZONE 200,000,00 .00 .00 .00 200,000.00 .00
32403 SOUTH ZONE 50,000,00 .00 .00 .00 50,000,00 .00
32404 EAST ZONE 20,000.00 .00 .DO .00 20,000,00 .00
TOTAL TITLE NOT FOUND 750,000,00 .00 .00 .00 750,000,00 .00
TOTAL LICENSES AND PERMITS 750,00o.G0 .00 .OD .DD 750,000.00 .00
3E101 INTEREST INCOME 150,000,00 .DO .Go .00 150,000.00 .00
TOTAL TITLE NOT FOUND 150,000 00 .00 .00 ,00 150,000.00 .00
TOTAL USE OF MONEY 150,000.00 .00 .00 .00 150,000.00 .00
TOTAL TITLE NOT FOUND 900,000,00 .00 .00 .00 900,000.00 .00
TOTAL SPECIAL REVENUE FUNDS 900,000.00 .00 .00 .00 900,000,00 .00
TOTAL DRAINAGE 900,000.00 .00 .00 .00 900,000.00 .00
SUNGARD PENTAMATSON - FUND ACCOUNTING MANAGER PAGE MUMMER: 17
DATE: 07/02/07 CITY OF PALM SPRINGS REVSTAII
TIME: 12;23:15 REVENUE STATUS REPORT
SELECTION CRITERIA: ALL
ACCOUNTING PERIOD: 1/08
SORTFD ➢Y: FUND,FUNCTIGN,DEPARTMENT,IST SUBTOTAL,= SUBTOTAL,A000UNT
TOTALED ON: FUND,FUNCTION,DEPARTMENT,IST SUBT0TAL,2ND SUBTOTAL
PAGE BREAKS ON: FUNU,FUNCTION,DEPARTMENT
FUND-137 CCMMUNITY DEV BLOCK GRANT
FUNCTION-2 SPECIAL REVENUE FUNDS
DEPARTMENT- TITLE NOT FOUND
1ST SUBTOTAL,-3300 INTERGOVERNMENTAL
PERIOD YEAR TO DATE AVAILABLE YTD/
ACCOUNT - - - - - TITLE - - - - - BUDGET RECEIPTS RECEIVABLES REVENUE BALANCE ➢UD
33411 CMMNTY OEV ELK GRNT 05-0 517,891.00 .00 .00 .00 517,681,00 .00
TOTAL TITLE NOT FOUND 517,881,00 .00 .00 .00 517,681.00 .00
TOTAL INTERGOVERNMENTAL 517,891.00 .00 .00 .00 517,681.00 .00
36104 LAND RENTAL 11119,00 00 .00 .00 11119.00 .00
TOTAL TITLE NOT FOUND 1,119,00 .00 .00 .00 1,115.00 .00
TOTAL USE OF MONEY 1,119.00 .00 .00 .00 1,119.00 .00
TOTAL TITLE NOT FOUND 319,000.00 .00 .00 .00 519,000,00 .00
TOTAL SPECIAL REVENUE FUNDS 5191000.00 .00 ,00 .00 919,000,00 .00
TOTAL COMMUNITY DEV BLOCK ORA 519,000.00 .00 '00 .00 519,000.00 .00
SUNGARD PENTAMATION - FUND ACCOUNTING MANAGER PACE NUMBER: X6
DATE: 07/02/07 CITY OF PALM SPRINGS REVSTAII
TIME: 12:23:15 REVENUE STATUS REPORT
SELECTION CRITERIA: ALL
ACCOUNTING PERIOD: 1/06
SORTED BY: FUND,FUNCTION,DEPARTMENT,IST SUBTOTAL,2ND SUBTOTAL,ACCOUNT
TOTALED ON: FUND,FUNCTION,DEPARTMENT,IST SUBTOTAL,2ND SUBTOTAL
PAGE BREAKS ON: FUND,FUNCTION,DEPARTMENT
FUND-139 MASTER LEASE
FUNCTION-2 SPECIAL REVENUE FUNDS
DEPARTMENT- TITLE NOT FOUND
1ST SUBTOTAL-3600 USE OF MONEY
PERIOD YEAR TO DATE AVAILABLE YTD/
ACCOUNT - - - - - TITLE - - - - - BUDGET RECEIPTS RECEIVABLES REVENUE BALANCE BUD
36102 INTRST INCMB-FISCAL AGEN 5,000.00 .00 ,00 .DO 5,000.00 .00
TOTAL TITLE NOT FOUND 5,000,00 .00 ,00 .00 5,000.00 .00
TOTAL USE OF MONEY 5,000.00 ,00 .00 .00 5,000.00 ,00
37701 RENT - MASTER LEASE 1,257,000.00 .00 .00 .00 1,257,000,00 .00
TOTAL TITLE NOT FOUND 1,257,000,00 .00 .00 .00 1,257,000.00 .00
TOTAL MASTER LEAS$ 1,257,000.00 00 .00 .00 1,257,000.00 .00
TOTAL TITLE NOT FOUND 1,262,000,00 .00 .00 .00 1,262,000.00 .00
TOTAL SPECIAL REVENUE FUNDS 1,262,000.00 00 ,00 ,00 1,262,000,00 .00
TOTAL MASTER LEASE 1,262,000.00 .00 .00 .00 1,262,000.00 ,00
SUNGARD PENTAMATION - FUND ACCOUNTING MANAGER PAGE NUMBER; 19
DATE: 07/02/07 CITY OF PALM SPRINGS REVSTAII
TIME, 12:23-15 REVENUE STATUS REPORT
SELECTION CRITERIA: ALL
ACCOUNTING PERIOD; 1/08
SORTED BY: FUND,FUNCTION,DEPARTMENT,IST SUBTOTAL,2ND SUBTOTAL,ACCOUNT
TOTALED ON: FUND,FUNCTION,DEPARTMENT,IST SDBTOTAL,2ND SUBTOTAL
PAGE BREAKS ON: 'Un,FUNCT10N,DEPARTMENT
FUND-140 CFD PUBLIC SAFETY #1
FUNCTION-2 SPECIAL REVENUE FUNS
➢EPARTMENT- TITLE NOT FOUND
IST SUBTOTAL-3650 SPECIAL ASSESSMENTS
PERIOD YEAR TO DATE AVAILABLE YTD/
ACCOUNT - - - - - TITLE - - - - - BUDGET RECEIPTS RECEIVABLES REV,SNUB BALANCE BUD
365D5 CFD 271,951.00 .00 00 .00 271,951.00 .60
TOTAL TITLE NOT FOUND 271,951.00 .00 .00 .00 271,951,00 ,00
TOTAL SPECIAL ASSESSMENTS 271,951.00 .00 .00 .00 271,951,00 ,00
TOTAL TITLE NOT FOUND 271,951.00 .00 .00 .00 271,951.00 .00
TOTAL SPECIAL REVENUE FUNDS 271,951,00 .00 ,00 .00 271,951.00 .00
TOTAL CFD PUBLIC SAFETY #1 271,951,00 .00 .00 .00 271,951,00 .00
SUNGARD PENTAMATION - FUND ACCOUNTING MANAGER PAGE NUMBER: 20
DATE: 07/02/07 CITY OF PALM SPRINGS REVSTAII
TIME: 32:23:1S REVENUE STATUS REPORT
SELECTION CRITERIA; ALL
ACCOUNTING PERIOD: 1/08
SORTED SY: FOND,FUNCTION,DEPARTMENT,1ST SUBTOTAL,2ND SUETOTAL,ACCOUNT
TOTALED ON: FUND,FVNCTION,DEPARTMENT,IST 9VST0TAL,2ND SUBTOTAL
PAGE BREAKS ON: FUND,kVNCTION,DRPARTMENT
FUND-149 AIR QUALITY MANAGEMENT
FUNCTION-2 SPECIAL REVENUE FUNDS
DEPARTMENT- TITLE NOT FOUND
1ST SUBTOTAL-3300 INTERGOVERNMENTAL.
PERIOD YEAR TO DATE AVAILABLE YTD/
ACCOUNT - - - - - TITLE - - - - - BUDGET RECEIPTS RECEIVABLES REVENUE BALANCE BUD
33301 AIR QUALITY MNGMNT FEES S2,500.00 .00 .00 .00 52,500.00 .00
TOTAL TITLE NOT FOUND 52,500.00 .00 .00 .00 52,500.00 .00
TOTAL INTERGOVERNMENTAL 52,500.00 .00 .00 .00 52,500.00 .00
36I01 INTEREST INCOME 500.00 .00 .00 .00 500.00 .OD
TOTAL TITLE NOT FOUND S00.00 .00 .cc .00 500.00 .00
TOTAL USE OF MONEY 500.00 .00 .00 .00 500.00 .00
TOTAL TITLE NOT FOUND 53,000.00 .00 .00 .00 53,000,00 .00
TOTAL SPECIAL REVENUE FUNDS 53,000.00 .00 .O0 .00 S3,000.00 .00
TOTAL AIR QUALITY MANAGEMENT 53,000.00 .00 .00 .00 55,000.00 .00
SUNCARD PENTAMATION - FUND ACCOUNTING MANAGER PAGE NUMBER: 21
DATE: 07/02/07 CITY OF PALM SPRINGS REVSTASI
TIME: 12:23:15 REVENUE STATUS REPORT
SELECTION CRITERIA: ALL
ACCOUNTING PERIOD: 1/08
SORTED BY: FUND,FUNCTION,DEPARTMENT,1ST SUBTOTAL,2ND SUBTOTAL,ACCOUNT
TOTALED ON: FUND,FUNCTICN,DEPARTMENT,IST SUBTOTlL,2ND SUBTOTAL
PAGE BREAKS ON: FDND,FUNCTION,DEPARTMENT
FUND-150 PUBLIC ART$
FUNCTION-2 SPECIAL REVENUE FUNDS
DEPARTMENT- TITLE NOT FOUND
19T SUBTOTAL-3400 CnA-RGES FOR SERVICES
PERIOD YEAR TO DATE AVAILABLE YTP/
ACCOUNT - - - - TITLE - - - - - BUDGET RECEIPTS TIECEIVABLE$ REVENUE BALANCE BUD
34106 SALE OF MAPS & PUBL 2,000.00 .00 .00 .00 2,000.00 .00
34350 PUBLIC ARTS FEE 230,000.00 .00 .00 .00 2S0,000.00 .00
TOTAL TITLE NOT FOUND 252,000,00 ,00 .00 .00 2S2,000,00 .00
TOTAL CHARGES FOR SERVICES 2S2,000.00 .00 .00 .00 2S2,000.00 .00
36101 INTEREST INCOME 15,000.00 ,00 .00 .00 15,000.00 .00
TOTAL TITLE NOT FOUND 15,000100 .00 .00 .00 15,000.00 .00
TOTAL V$E OF MONEY 15,000.00 .00 .00 .00 15,000.00 .00
TOTAL TITLE NOT FOUND 267,000.00 ,00 .00 .00 267,000.00 .00
TOTAL SPECIAL REVENUE FUNDS 267,000.00 .00 ,00 .00 267,000.00 .00
TOTAL PUBLIC ARTS 267,000,00 .00 .00 .00 267,000.00 ,00
SUNGARO PENTAMATION - FUND ACCOUNTING MANAGER PAGE NUMBER: 22
DATE; 07/02/07 CITY OF PALM SPRINGS REVSTAi.
TIME; 12:23:I5 REVENUE STATUS REPORT
SELECTION CRITERIA: ALL
ACCOUNTING PERIO➢: 1/08
SORTED BY: FUND,FUNCTION,DEPARTMENT,1ST SUBTOTAL,2ND SUBTOTAL,ACCOUNT
TOTALED ON: FUND,FUN=ION,DEPARTMENT,IST SUBTOTAL,2ND SUBTOTAL
PAGE BREAKS ON; FUND,FUNCTION,DEPARTMENT
FUND-151 LIBRARY ENDOWMENT
FUNCTION-2 SPECIAL REVENUE FUNDS
DEPARTMENT- TITLE NOT FOUND
1ST SUBTOTAL-3400 CHARGES FOR SERVICES
PERIOD YEAR TO DATE AVAILABLE YTD/
ACCOUNT - - - - - TITLE - - - - - BUDGET RECEIPTS RECEIVABLES REVENUE BALANCE BUD
34504 SPECIAL BOOK SALES 1,000.00 .00 .00 .00 1,000.00 .00
34509 EOGERT BOOK SALES 10,000,00 .00 .00 .00 10,000,00 .00
TOTAL TITLE NOT FOUND 11,000,00 .00 .00 .00 11,000.00 ,00
TOTAL CHARGES FOR SERVICES 11,000.00 .00 ,00 .00 11,000,00 .00
36101 INTEREST INCOME 461000.00 .00 ,ap .00 45,000.00 .00
36105 BUILDING/FACILITIES RENT 1,000.00 .00 00 .00 1,000.00 .00
TOTAL TITLE NOT FOUND 4P,000.00 .00 00 .00 49,000.00 ,00
TOTAL USE OF MONEY 49,000,00 .00 ,pp .00 49,000.00 ,00
37113 MISCELLANEOUS REVENUE 1,000.00 ,00 .00 .00 1,000.00 ,pp
TOTAL TITLE NOT FOUND 1,000,00 .00 .00 .00 1,000,00 ,00
TOTAL MISC 1,000 00 00 ,00 .00 1,000,00 ,00
37505 UNRESTRICTED DONATIONS 15,000.00 .00 .p0 .00 15,000.00 .00 TOTAL TITLE NOT FOUND 15,000.00 .00 .00 .00 1E,000,00 .00
TOTAL DONATIONS 151000.00 .00 .00 .00 15,000.00 .00
TOTAL TITLE NOT FOUND 76,000.00 00 .00 .00 76,000.00 .00
TOTAL SPECIAL REVENUE FUNDS 76,000.00 .00 00 ,00 7G,000.00 .00
TOTAL LIBRARY ENDOWMENT 76,000.00 .00 ,00 .00 75,000.00 .00
SUNGARD PENTAMATION _ FUND ACCOUNTING MANAGER PAGE NUMBER: 23
DATE: 07/0Z/07 CITY OF PALM SPRINGS REVSTSayl
TIME: 1Z;23:15 REVENUE STATUS REPORT
SELECTION CRITERIA: ALL
ACCOUNTING PERIOD: 1/09
$OPTED BY: FUND,FUNCTION,XIEPARTMENT,IST SUBTOTAL,2ND SUBTOTAL,ACCOUNT
TOTALED ON: FUND,FUNCTXON,DEPARTMENT,7$T SUBTOTAL,2ND SUBTOTAL
PAGE BREAKS ON: FUND,FUNCTION,DEPARTMENT
FUND-160 SPECIAL PROJECTS
FUNCTION-2 SPECIAL REVENUE FUNDS
DEPARTMENT- TITLE NOT FOUND
1ST SUBTOTAL-3400 CHARGES FOR SERVICES
PERIOD YEAR TO DATE AVAILABLE YTp/
ACCOUNT - - - - - TITLE - - - - - BUDGET RECEIPTS RECEIVABLE$ REVENUE BALANCE BUD
34207 POLICE CONTRACT OT 100,000.00 .00 ,00 .00 100,000,00 ,00
TOTAL T1TLG NOT FOUND 100,000,00 .00 .00 .00 400,000.00 .00
TOTAL CHARGES FOR SERVICES 100,000,00 .00 .00 ,00 100,000.00 .00
TOTAL TITLE NOT FOUND 100,000.00 .00 .00 ,00 100,000 00 ,00
TOTAL SPECIAL REVENUE FUNDS 100,000,00 .00 .00 .00 100,000.00 ,00
TOTAL SPECIAL PROJECTS 100,000.00 .00 .00 .00 100,000.00 .00
SUNGAR➢ PENTAMATICN - FUN➢ ACCOUNTING MANAGER PAGE NUMEER: 24
➢ATE: 07/02/07 CITY OF PALM SPRINGS REVSTAYI
TIME: 12;23:15 REVENUE STATUS REPORT
SELECTION CRITERIA: ALL
ACCOUNTING PERIOD: 1/08
SORTED BY: FUND,FUNCT ION,DEPARTMENT,IST SUBTOTAL,2N➢ SUBTOTAL,ACCOUNT
TOTALED ON: FUND,FUNCTION,DEPARTMENT,IST SUBTOTAL,2ND SUBTOTAL
PAGE BREAKS ON: FUND,FUNCTION,DEPARTMENT
FUND-261 CAPITAL PROJECTS
FUNCTION-3 CAPITAL PROJECT FUNDS
DEPARTMENT- TITLE NOT FOUND
IST SUBTOTAL-3200 LICENSES AND PERMITS
PERIOD YEAR TO DATE AVAILABLE YTD/
ACCOUNT - - - - - TITLE - - - - - BUDGET RECEIPTS RECEIVABLES REVENUE BALANCE BUD
32214 TECIiNOLOGY FEE 270,200,00 .00 .00 ,00 270,300.00 .00
TOTAL TITLE NOT FOUND 270,300,00 .00 .00 .00 270,300.00 .00
TOTAL LICENSES AN➢ PERMITS 270,300.00 .00 .00 .00 270,300.00 .00
33600 FAU/ICTEA/STP REVENUE 900,000.00 .00 .00 .00 900,000.00 .00
33600 SIDEWALK SAFETY GRANT 601000.00 .00 .00 .00 50,000.00 .00
33627 PLHD GRANT 100,000,00 .00 .00 .00 100,000.00 .00
336SI FED EMER RELIEF FUNS 367,000.00 .00 .00 ,00 367,000.00 .00
TOTAL TITLE NOT FOUND 1,427,000.00 .00 .00 ,00 1,427,000.00 .00
TOTAL INTERGOVERNMENTAL 1,427,000.00 .00 00 ,00 1,427,000.00 .00
37105 CONTRIB NON-GOVT SOURCES 450,000.00 .00 00 ,00 4S0,000.00 .00
TOTAL TITLE NOT FOUND 450,000.00 .00 00 ,00 450,000.00 .00
TOTAL, MISC 450,000.00 .00 .00 ,00 450,000.00 .00
TOTAL TITLE NOT FOUND 2,147,300,00 .00 ,00 ,00 2,347,300.00 .00
TOTAL CAPITAL PROJECT FUNDS 2,147,300.00 .00 ,00 .D0 2,147,200,00 .00
TOTAL CAPITAL PROJECTS 2,147,300.00 .00 .00 .00 2,147,200.00 .00
SUNGARD PENTAMATION - FUND ACCOUNTING MANAGER PAGE NUMBER: 25
DATE: 07/02/07 CITY OF PALM SPRINGS REVSTAII
TIME: 12:23:15 REVENUE STATUS REPORT
SELECTION CRITERIA: ALL
ACCOUNTING PERIOD: 1/08
SORTED BY; FUND,FUNCTION,DEPARTMENT,IST SUBTOTAL,2ND $USTOTkL,ACCOUKT
TOTALED ON: FUND,FUNCTION,DEPARTMENT,IST SUBTOTAL,2ND SUBTOTAL
PAGE BREAKS ON: FUND,FUNCT10N,UEPARTMENT
FUND-301 DEBT SERVICE
FUNCTION-4 ➢EBT SERVICE FUNDS
DEPARTMENT- TITLE NOT FOUND
1ST SUBTOTAL-3600 USE Cr MONEY
PERIOD YEAR TO PATE AVAILABLE YTD/
ACCOUNT - - - .. - TITLE - - - - - BUDGET RECEIPT$ RECEIVABLES REVENUE BALANCE BUD
36102 INTRST INCME-FISCAL AGEN 1$0,000 00 .00 .00 .co 160,000.00 .00
TOTAL TITLE NOT FOUND 180,000.00 .00 .00 .co 160,o00.00 .00
TOTAL USE OF MONEY ISO,000.00 .00 .00 .00 1$0,000.00 .00
TOTAL TITLE NOT FOUND 190,000.00 .00 ,00 .00 100,000.00 .00
TOTAL DEBT SERVICE FUNDS 180,000.00 00 .00 .00 150,00o.00 .00
TOTAL DEBT SERVICE 180,000.00 .00 00 .00 150,000.00 .00
SUNGARD PENTAMATICN - FUND ACCOUNTING MANAGER PAGE NUM13ER: 33
DATE: 07/D2/07 CITY OF PALM SPRINGS REVSTAII
TIME: 12:23:1S REVENUE STATUS REPORT
SELECTION CRITERIA: ALL
ACCOUNTING PERIOD: 1/05
SORTED BY: FUND,FUNCTION,DEPARTMENT,IST SUBTOTAL,= SUBTOTAL,ACCOUNT
TOTALED ON: FUND,FUNCTION,DEPARTMENT,IST SUBTOTAL,2= SUBTOTAL
PAGE BREAKS ON: FUND,FUNCTION,DEPARTMENT
FUND-405 AIRPORT CUSTOMER FACILITY
FUNCTION-5 ENTERPRISE FUNDS
DEPARTMENT- TITLE NOT FOUND
1ST SUBTOTAL-3500 AIRPORT
PERIOD YEAR TO DATE AVM LABLE YTD/
ACCOUNT - - - - - TITLE - - - - - BUDGET RECEIPTS RECEIVABLES REVENUE BALANCE BUD
38145 CUSTOMER FACILITY C416ARGE 1,200,000.00 .00 .00 .00 1,200,000.00 .00
TOTAL TITLE NOT FOUND 1,200,000.00 .00 .00 .00 1,200,000.00 .00
TOTAL AIRPORT 1,200,000.00 ,a0 .00 .00 1,200,000.00 .00
TOTAL TITLE NOT FOUND 1,200,000,00 .00 .02 .00 1,200,000.00 .00
TOTAL ENTERPRISE FUNDS 1,200,000.00 .00 ,00 .00 1,200,00D.00 .00
TOTAL AIRPORT CUSTOMER FACILI 1,200,000,00 .00 .00 .00 11200,000,00 .00
SUNGARD PENTAMATION - FUND ACCOUNTING MANAGER PACE NUMEER: 34
DATE: 07/02/07 CITY OF PALM SPRINGS REVSTAII
TIME: 1Z:23:15 REVENUE STATUS REPORT
SELECTION CRITERIA: ALL
ACCOUNTING PERIOD; 1/06
SORTED SY: FUND,FUNCTION,DEPARTMENT,IST SUBTOTAL,2ND SUBTOTAL,ACCOUNT
TOTALED ON: FUND,FUNCTION,DEPARTMENT,1ST SUBTOTAL,2ND SUBTOTAL
PAGE AREAAS ON: FUND,FUNCTION,DEPARTMENT
FUN➢-410 AIRPORT PFC
FUNCTION-5 ENTERPRISE FUNDS
DEPARTMENT- TITLE NOT FOUND
15T SUBTOTAL-3000 USE OF MONEY
PERIOD YEAR TO DATE AVAILABLE YT➢/
ACCOUNT - - - - - TITLE - - - - - BUDGET RECEIPTS RECEIVABLES REVENUE DALANCE BUD
36102 INTRST INCME-FISCAL AGEN 60,000.00 .00 .00 .00 60,000.00 .00
TOTAL TITLE NOT FOUND 60,000 00 .00 .00 .00 G0,000,00 .00
TOTAL USE OF MONEY 60,000.00 .00 .00 .00 80,000.00 .00
38119 PASSENGER FACILITY CHG 5,050,000,00 .00 .00 .00 2,050,000,00 .00
TOTAL TITLE NOT FOUND 3,050,000.00 .00 .00 .00 310501000.00 .00
TOTAL AIRPORT 3,050,000.00 .00 ,00 .00 3,050,000,00 .00
TOTAL TITLE NOT FOUND 3,110,000.00 .00 .co .00 3,110,000.00 .00
TOTAL ENTERPRISE FUNDS 3,110,000.00 .00 .00 .00 311101000100 .00
TOTAL AIRPORT PFC 3,110,000.00 .00 .00 .00 3,110,000.00 co.
SUNGARD PENTAMATION - FUND ACCOUZTTING MANAGER PAGE NUMBER: 35
DATE; 07/02/07 CITY OF PALM SPRINGS REVSTAl.1
TIME: 12:23:15 REVENUE STATUS REPORT
SELECTION CRITERIA: ALL
ACCOUNTING PERIOD: 1/08
$OPTED BY: FUND,FUNCTION,DEPARTMENT,IST SUBTOTAL,2ND SUBTOTAL,ACCOUNT
TOTALED ON- FUND,FUNCTION,DEPARTMENT,l$T SUBTOTAL,2ND SUBTOTAL
PAGE BREAKS ON; FUND,FUNCTION,DEPARTMENT
FUND-415 AIRPORT
FUNCTION-5 ENTERPRISE FUNDS
DEPARTMENT- TITLE NOT FOUND
1ST $UETOTAL-3300 INTERGOVERNMENTAL
PERIOD YEAR TO DATE AVAILABLE YTD/
ACCOUNT - _ - - - TITLE - - - - - BUDGET RECEIPTS RECEIVABLES REVENUE BALANCE BUD
33517 AIRPORT SECURITY - TSA 243,017.00 .00 00 .00 24$,017.00 ,00
TOTAL TITLE NOT FOUND 243,017.00 .00 .00 .00 243,017.00 .00
TOTAL INTERGOVERNMENTAL 242,017.00 .00 ,00 .00 243,017.00 .00
36101 INTEREST INCOME 250,000.00 .00 00 .00 250,000.00 .00
36102 INTRST INCME-FISCAL AGEN 50,000.00 .00 00 .00 50,000.0o .00
TOTAL TITLE NOT FOUND 300,000.00 .00 ,00 .00 300,000,00 ,00
TOTAL Ir$E OF MONEY 300,000,00 .00 .00 .00 300,000.00 .00
38101 PARKING VIOLATION 17,500.00 .00 ,00 .00 17,500,00 .00
38104 MISC REV - 341 7,500 00 .00 .00 .00 7,500.00 .00
38105 FEDERAL GRANTS 4,035,000 00 .00 .00 .00 4,035,000.00 .00
36106 SCHEDULED LANDING FEES 1,205,105.00 .00 .00 .00 1,205,105.00 .0o
38107 NON-SCHED LANDING FEES 1,000.00 .00 .00 ,p0 1,000.00 .00
38108 LANDING FEE SURCHARGE 330,000,00 .00 .00 ,00 330,000.00 .00
38109 AIRFIELD CONCESSIONS 319,300,00 .00 ,00 .00 319,300.00 .00
38115 PROPERTY RENTAL-NCN AVTN 477,146,00 .00 .00 .00 477,146.00 .00
36117 LAND RENTAL - 341 11011,823.00 .00 .00 .00 1,011,823.00 ,00
3B119 LEASED PARKING 2,650,000.00 .00 .00 .00 2,650,000,00 .aa
3B120 AIRPORT USE PERMITS 105,000.Do .00 .00 .00 105,000.00 .00
3B121 EMPLOYEE PARKING PERMIT$ 18,000.00 .00 .00 .00 18,000.00 .00
3813E TERM AIR COMM RENTALS 1,444,390.00 00 00 .00 1,444,380.00 .00
3B123 TERM NON-AIR COMM RENTAL, 503,560.00 .00 00 .00 6031 560.Op .00
38124 READY RETURN LOT 160,000.00 .00 ,00 .00 160,000.00 .00
38125 ADVERTISING 300,000.00 .00 ,00 .00 300,000.00 .00
38126 ON-AIRPORT RENTAL CAR 4,752,5B1,00 .00 ,00 .00 4,752,581.00 .00
38127 OFF-AIRPORT RENTAL CAR 15,000.00 .00 ,Do ,00 15,000.00 .00
38128 AIRPORT ACCESS FEES 75,000.00 ,00 ,0u .03 75,000.00 .00
38129 OUTSIDE CATERING 50,000.00 .00 ,00 .00 50,000.00 .00
38130 TERMINAL CONCESSIONS 200,o00.00 .00 ,00 .00 200,000.00 .00
36131 TAXI ACCESS FEES 140,000.Oo .00 ,00 .00 140,000.00 ,pp
38133 GROUND TRANSPORTATION CT 2,000.00 .00 ,00 .00 2 .00 38134 VASI POWER REIMB ,000.00
, 00 200 2,160.00 .00 00 , .38i35 CUSTOMS FEES 165,000,00 .00 .00 .00 165, 0 160 00
,00 .00
00
38137 SECURITY GATE PASSES-ID 25,000.00 .00 .00 .00 5,00000 .00
38139 PS AIR MUSEUM ADMISSION$ 10,000.00 00 ,00 .00 18,p00.00 ,Ap
36140 PS AIR MUSEUM SALES 12,00p.00 .00 .0o .00 12,000.00 .00
36142 ADMIN IN LIEU OF CATERIN 2,500.00 .00 ,00 .00 2,000.00 .00 38204 LOADING BPI➢OE FEE 195,000.00 .00 ,00 .00 195,000,00 .00 TOTAL FAA CHRC FINGERPRINT 25,000.00 .00 .Op .00 95,000,00 .00
TOTAL TITLE NOT POUND 18,364,555.00 .00 .00 .00 1O,325,000.00 .00
TOTAL AIRPORT 18,394,555,00 .00 .00 .00 1$,364,555.00 .00
$UNGARD PENTAMATION - FUND ACCOUNTING MANAGER PACE NUMBER: 36
DATE: 07/02/07 CITY OF PALM SPRINGS REVETAII
TIME: 12:23:1S REVENUE STATUS REPORT
SELECTION CRITERIA: ALL
ACCOUNTING PERIOD: 1/08
SORTED BY: FUND,FUNCTION,DEPARTMENT,1ST 5UETOTAL,2ND SUBTOTAL,ACCOUNT
TOTALED ON: FUND,FUNCTION,DEPARTMENT,IST SUBTOTAL,2ND SUBTOTAL
PAGE BREAKS ON: FUND,FUNCTION,DEPARTMENT
FUND-4I5 AIRPORT
FUNCTION-S ENTERPRISE FUNIIS
DEPARTMENT- TITLE NOT FO=
1ST SUBTOTAL-3800 AIRPORT
PERIOD YEAR TO DATE AVAILABLE YTD/
ACCOUNT - - - - - TITLE - - - - - BUDGET RECEIPTS RECEIVABLES REVENUE BALANCE BUD
TOTAL TITLE NOT FOUND 16,907,572.00 .00 .00 ,00 18,907,572.00 .00
TOTAL ENTERPRISE FUNDS 18,907,S72,00 ,00 .00 .00 18,907,S72,00 .00
TOTAL AIRPORT 18,907,572.00 .00 .00 .00 18,907,572.00 .00
SUNGARD PENTAMATION - FUND ACCOUNTING MANAGER PAGE NUMBER: 37
DATE: 07/02/07 CITY OF PALM SPR;NCS REVSTAII
TIME: 12;23:15 REVENUE STATUS REPORT
SELECTION CRITERIA; ALL
ACCOUNTING PERIOD; 1/09
SORTED BY- FUND,FUNCTION,DEPARTMENT,1ST SUBTOTAL,2ND SUBTOTAL,ACCOUNT
TOTAT,ED ON: FUND,FUNCTION,DEPARTMENT,IST SUBTOTAL,= SUBTCTAL
PAGE BREAKS ON: FUND,FUNCTION,DEPARTMENT
FUND-420 WASTEWATER TREATMENT PLNT
FUNCTION-5 ENTERPRISE FUNDS
DEPARTMENT- TITLE NOT FOUND
1ST SUBTOTAL-3600 USE OF MONEY
PERIOD YEAR TO DATE AVAILABLE YTD/
ACCOUNT - - - - - TITLE - - - - - BUDGET RECEIPTS RECEIVABLES REVENUE. BALANCE BUD
36101 INTEREST INCOME 200,000.00 .00 00 .00 200,000.00 .00
TOTAL TITLE NOT FOUND 200,000.00 .00 ,00 .00 200,000.00 .00
TOTAL USE OF MCNEY 200,000,00 .00 .00 .00 200,000,00 .00
36701 SEWER SERVICE CI4ARGES 4,900,000.00 .00 ,00 .00 41900.000,00 .00
55703 SEWER CONNECTION FEE 1,200,000,00 ,00 .00 .00 1,200,000.00 .00
$5704 SEWER STREET MAINT C$G 10,000.00 00 ,00 .00 10,000.00 .00
36710 CESSPOOL DUMPING FEES S,000.00 ,00 .00 ,00 51000.00 .00
TOTAL TITLE NOT FOUND 61115,000.00 .cc ,00 .CC 61115,000,00 .00
TOTAL WASTEWATER 6111S,000.00 ,Do '00 .00 6,115,000.00 .00
TOTAL TITLE NOT FOUND 61315,000.00 00 .00 .00 6,315,000.00 .00
TOTAL ENTERPRISE FUNDS 6,313,000,00 .00 .00 .00 6,315,000,00 .00
TOTAL WASTEWATER TREATMENT PL 613151000100 00 ,00 .00 6,315,000.00 .00
SUNGARD PENTAMATICN - FUND ACCOUNTING MANAGER PAGE NUMBER: 38
DATE: 07/02/07 CITY OF PALM SPATNG5 REVSTAll
TIME: 12:23:25 REVENUE STATUS REPORT
SELECTION CRITERIA: ALL
ACCOUNTING PERIOD: 1/08
SORTED BY: FUND,FUNCTION,OEPARTMENT,l$T SUBTOTAL,2ND SCATOTAL,ACCOUNT
TOTALED ON: FUND,FUNCTION,DEPARTMENT,IST SUBTOTAL,2NO SUBTOTAL
PAGE BREAKS ON: FUND,FUNCTION,I)EPARTMENT
FUND-430 GOLF COURSE
FUNCTION-5 ENTERPRISE FUNDS
DEPARTMENT- TITLE NOT FOUND
19T SUBTOTAL-3600 USE OF MONEY
PERIOD YEAR TO DATE AVAILABLE YTD/
ACCOUNT - - - - - TITLE - - - - - BUDGET RECEIPTS RECEIVABLES REVENUE BALANCE BUD
36101 INTEREST INCOME 11000.00 .00 .00 .00 I,000.00 .00
36102 INTRST INCME-FISCAL AGEN 65,000.00 .00 .00 .00 65,000.00 .00
TOTAL TITLE NOT FOUND 66,000,00 .00 .00 .00 661000.00 .00
TOTAL USE OF MONEY 66,000.00 .00 .00 ,00 66,000,00 .00
38901 TAHQUITZ GREEN FEES & CA 2,610,000.00 .00 .00 .00 2,610,000.00 .00
Z8902 LAND RENTAL 400,000.00 .00 .00 .00 400,000.00 .00
38903 RESIDENT DISCOUNT CARDS 6,000.00 .00 .00 .00 6,000.00 _00
38920 MISC 2,000.00 .00 .00 .00 2,000,00 .00
TOTAL TITLE NOT FOUND 3,018,000.00 .00 .00 .00 3,01B4Oo0.00 .oa
TOTAL GOLF COURSE 31018,000,00 .00 ,00 .00 3,018,000.00 .00
TOTAL TITLE NOT FOUND 3,084,000,00 .00 .00 .00 3,064,000.00 .00
TOTAL ENTERPRISE FONDS 3,084,000.00 .00 .00 .00 3,064,000,00 .00
TOTAL GOLF COURSE 3,OS4,000.00 .0D .00 .00 310$4,000.00 .00
SUNGARI) PENTAMATION - FUND ACCOUNTING MANAGER PAGE NUMBER: 3S
DATE: 07/02/07 CITY OF PALM SPRINGS REVSTAII
TIME: 12:23:15 REVENUE STATUS REPORT
SELECTION CRITERIA; ALL
ACCOUNTING PERIOD: 1/08
SORTED BY: FUND,FUNCTION,DEPARTMENT,IST SUBTCTAL,2ND SUBTOTAL,ACCOUNT
TOTALED ON; FUND,FUNCTTON,DEPARTMENT,IST SDBTOTAL,2ND SUBTOTAL
PAGE BREAKS ON: FUND,FDNCTION,DEPARTMENT
FUND-510 MOTOR VEHICLE REPLACEMENT
FUNCTION-6 INTERNAL SERVICE FUNDS
DEPARTMENT- TITLE NOT FOUND
1ST SUBTOTAL-3400 CHARGES FOR SERVICES
PERIOD YEAR TO DATE AVAILABLE YTD/
ACCOUNT - - - - - TITLE - - - - - BUDGET RECEIPTS RECEIVABLES REVENUE BALANCE BUD
34110 CTI4ER CHARGES CURRENT SV 128,215,00 .00 .00 .00 128,215,00 .00
TOTAL TITLE NOT FOUND 128,215,00 .00 .00 .00 128,215 00 .00
TOTAL CHARGES FOR SERVICES 128,215.00 ,00 .00 .00 129,215.00 .00
36101 INTEREST INCOME 20,000,00 .00 .ap .00 20,000.00 .00
TOTAL TITLE NOT FOUND 20,000,00 .00 .00 ,00 20,000.00 .00
TOTAL USE OF MONEY 20,000.00 ,00 .00 .00 20,000.00 .00
39104 RIVERSIDE COUNTRY SERVIC 25,000.00 .00 .00 .00 25,000.00 .00
39106 CATHEDRAL CITY SERVICE 15,000,00 .OD ,p0 .00 15,000,00 .00
39110 CITY VEHICLE REPLACE REN 3,692,111,00 .00 .00 .00 316924111.00 .00
39199 MISC REVENUE MVR 5,000,00 .00 00 .00 5,Oo0.00 .00
TOTAL TITLE NOT FOUND 2,737,111.00 .00 .00 .00 3,737,11].,00 .00
TOTAL MOTOR VEHICLE REPLACEME 3,737,111.00 .00 ,00 ,00 3,737,111.00 .00
TOTAL TITLE NOT FOUND 3,885,326.00 .00 .00 .00 31885,326.00 .00
TOTAL INTERNAL SERVICE FUNDS 3,88$,326.00 .00 ,p0 .00 318851326,00 .00
TOTAL MOTOR VEHICLE REPLACEM£ 3,885,326,00 .00 ,p0 ,00 31865,326.00 .00
SUNGARD PENTAMATION - FUND ACCOUNTING MANAGER PAGE NUMBER: 40
DATE: 07/02/07 CITY OF PALM SPRINGS REVSTAII
TIME: 12:23:15 REVENUE STATUS REPORT
SELECTION CRITERIA: ALL
ACCOUNTING PERIOD: 1/05
SORTED BY; F=,FUNCTION,I>EPARTMENT,LST SUBTOTAL,2ND SUBTOTAL,ACCOUNT
TOTALED ON: FUND,FUNCTION,DEPARTMENT,IST SUBTOTAL,2ND SUBTOTAL
PAGE ➢BEAKS ON: FUND,FUNCTION,DEPARTMENT
FUND-520 FACILITIES MAINTENANCE
PVNCTION-6 INTERNAL SERVICE FUNDS
I]EPARTMENT- TITLE NOT FOUND
19T SUBTOTAL-3920 FACILITY MAINTENANCE
PERIOD YEAR TO DATE AVAILABLE YTD/
ACCOUNT - - - - - TITLE - - - - - BUDGET RECEIPTS RECEIVABLES REVENUE BALANCE BUD
39202 INTERFUND SVC CHARGES 3,748,488,00 .00 .00 ,00 3,749,488.00 ,00
TOTAL TITLE NOT FOUND 3,748,488.00 .00 .00 .00 3,748,488.00 .00
TOTAL FACILITY MAINTENANCE 3,749,468,00 .00 .00 .00 3,748,466,00 .00
TOTAL TITLE NOT FOUND 3,748,488,00 .00 ,00 ,00 3,749,483.00 .00
TOTAL INTERNAL SERVICE FUNDS 3,748,488.00 .00 .00 .00 3,748,488,00 ,00
TOTAL FACILITIES MAINTENANCE 3,748,488,00 .00 .00 .00 3,748,488.00 .00
SUNGARD PENTAMATION - FUN➢ ACCOUNTING MANAGER PAGE NUMBER: 41
➢ATE: 07/02/07 CITY OF PALM SPRINGS REVSTAII
TIME: 12:23:15 REVENUE STATUS REPORT
SELECTION CRITERIA: ALL
ACCOUNTING PERIOD: 1/00
SORTED BY: FOND,FUNCTION,DEPARTMENT,IST SIIETOTAL,2ND SUBTOTAL,ACCOUNT
TOTALE➢ ON: FUND,FUNCTION,DEPARTMENT,IST SUBTOTAL,2ND SUBTOTAL
PAGE BREAKS ON; FUND,FUNCTION,➢EPARTMENT
FUND-530 EMPLOYEE RTRMNT BENEFITS
FUNCTION-6 INTERNAL SERVICE FUNDS
DEPARTMENT- TITLE NOT FOUND
19T SUBTOTAL-3930 PERS
PERIOD YEAR TO DATE AVAILABLE YTD/
ACCOUNT - - - - - TITLE - - - - - BUDGET RECEIPTS RECEIVABLES REVENUE BALANCE BU➢
39301 INTERFUND SVC CHARGES 10,151,491.00 ,00 00 .00 10,151,491.00 -00
TOTAL TITLE NOT FOUND 10,151,491.00 ,00 .00 .00 10,151,491.00 .00
TOTAL PER$ 10,151,491-00 .00 .00 .00 10,151,491.00 .00
TOTAL TITLE NOT FOUND 10,151,491.00 .00 .00 .00 10,151,491.00 .00
TOTAL INTERNAL SERVICE FUNDS 10,151,491.00 .00 .00 ,00 10,151,493.00 .00
TOTAL EMPLOYEE RTRMNT BENEFIT 10,151,491.00 .00 .00 .00 10,151,491.00 .00
SUNGAkD PENTAMATION - FUND ACCOUNTING MAkNAGER PAGE NUMEER: 42
DATE: 07/02/07 CITY OF PALM SPRINGS REVSTAII
TIME: 12:23:15 REVENGE STATUS REPORT
SELECTION CRITERIA: ALL
ACCOUNTING PERIOD: 1/OS
SORTED BY; FUND,FUNCTION,DEPARTMENT,IST SUBTOTAL,ZND SUBTOTAL,ACCOUNT
TOTALED ON; FUND,FUNCTION,DEPARTMENT,IST SUBTOTAL,2ND SUBTOTAL
PAGE BREAK$ ON: FUND,FUNCTION,DEPARTMENT
FUND-540 RISK MANAGEMENT
FUNCTION-6 INTERNAL SERVICE FUNDS
DEPARTMENT- TITLE NOT FOUND
IST SUBTOTAL-3600 USE OF MONEY
PERIOD YEAR TO DATE AVAILABLE YTD/
ACCOUNT - - - - - TITLE - - - - - BUDGET RECEIPTS RECEIVABLES REVENUE BALANCE BUD
36101 INTEREST INCOME 60,000.00 .00 .00 .00 601000.00 .00
TOTAL TITLE NOT FOUND 60,000.00 .00 .0o .00 601000.00 .00
TOTAL USE OF MONEY 60,coo.00 .00 .00 .00 60,000.00 .00
39401 INTERFUND SVC CEO FRINGE 6,617,054,00 .00 .00 .00 6,617,054.00 .00
39403 COBRA 20,000.OD .00 .00 .00 20,000.00 .00
39404 SPECIAL EVENTS LIAB INS 10,000,00 .00 .00 .00 10,000.00 .00
39405 PR DEDUCTION$ INSURANCE 153,600.00 '00 00 .00 153,600.00 .Do
3$405 PR DEDUCTIONS SUPP LIFE 1,300.00 .00 ,00 .00 1,300.00 .00
39407 PR DEDUCTIONS STD INS 59,531.00 .00 ,DO .00 69,531.00 .00
39409 INTERFUND SVC CNG INSUR 2,966,445.00 .00 ,00 .00 2,966,445.00 .00
35410 INTERFUND SVC CEG W COMP 31035,060,00 .00 .00 .00 3,035,060.00 .00
TOTAL TITLE; NOT FOUND 12,S72,990.00 .00 ,O0 -00 12,872,990.00 .00
TOTAL RISK MANAGEMENT 12,272,990.00 .00 ,00 .00 12,572,990.00 .00
TOTAL TITLE NOT FOUND 12,932,990.00 .00 ,00 .00 IZ,932,990.00 .0o
TOTAL INTERNAL SERVICE FUNDS 12,932,990,00 .00 100 .00 12,932,990,00 .00
TOTAL RISK MANAGEMENT 124932,990,00 .00 ,DO .00 12,932,990.00 .00
SUNGARD PENTAMATION - FUND ACCOUNTING MANAGER PAGE NUMBER: 43
DATE: 07/02/07 CITY OF PALM SPRINGS REVSTAII
TIME: 12:23:15 REVENUE STATUS REPORT
SELECTION CRITERIA: ALL
ACCOUNTING PERIOD: 1/08
SORTED EY: FUND,FUNCTION,DEPARIMENT,IST SUBTCTAL,2ND SUBTOTAL,ACCOUNT
TOTALED ON: FUNIl,F7UNCTION,DEPARTMENT,IST SUSTOTAL,2ND SU&TOTAL
PAGE EREAAS ON: FUND,FUNCTION,➢EPARTMENT
FUND-541 RETIREE HEALTH INSURANCE
FUNCTION-6 INTERNAL SERVICE FUNDS
DEPARTMENT- TITLE NOT FOUND
12T SUBTOTAL-8600 USE OF MONEY
PERIOD YEAR TO DATE AVAILABLE YTD/
ACCOUNT - - - - TITLE - - _ _ _ BUDGET RECEIPTS RECEIVABLES REVENUE BALANCE BUD
3y101 INTEREST INCOME 11000.00 .00 .00 .00 11000.00 .00
TOTAL TITL3 NOT FOUND 11000.00 .00 .00 .00 11000.00 .00
TOTAL USE OF MONEY 11000.00 .00 .00 .00 11000.00 .00
39408 RETIREES CONTRIBUTIONS 1491000,00 .00 .00 .00 id S,000.00 .00
TOTAL TITLE NOT FOUND 143,000 00 .00 .00 .00 149,000.00 .00
TOTAL RISK MANAGEMENT 149,000.00 .00 .00 .00 149,000.00 .00
TOTAL TITLE NOT FOUND 150,000.00 .00 .00 .00 180,000.00 .00
TOTAL INTERNAL SERVICE FUNDS 150,000.00 ,00 .00 .00 I90,000.00 .00
TOTAL RETIREE HEALTH INSURANC 1S0,000.00 .00 .00 .00 150,000.00 .00
SUNGRRD PENTAMATION - FUND ACCOUNTING MANAGER PAGE NUMBER: 44
DATE: 07/02/07 CITY OF PALM SPRINGS REV$TAII
TIME: 12;23:15 REVENUE STATUS REPORT
SELECTION CRITERIA: ALL
ACCOUNTING PERIOD: 1/08
SORTED BY: FUND,FUNCTION,DEPARTMENT,IBT SUBTOTAL,2ND SUBTOTAL,ACCOUNT
TOTALED ON: FUND,FUNCTION,DEPARTMENT,IST SUBTOTAL,2ND SUBTOTAL
PAGE BREAKS ON: FUND,FUNCTION,DEPARTMENT
FUND-550 ENERGY
FUNCTION-6 INTERNAL SERVICE FUNDS
DEPARTMENT- TITLE NOT FOUND
1ST SUBTOTAL-3600 USE OF MONEY
PERIOD YEAR TO DATE AVAILABLE YTD/
ACCOUNT - - - - - TITLE - - - - - BUDGET RECEIPTS RECEIVABLES REVENUE BALANCE BU➢
36102 INTRST INCME-FISCAL AGEN 20,000.00 .00 ,00 .00 20,000.00 ,Do
TOTAL TITLE NOT FOUND 20,000.00 .00 .00 .Do 20,000.00 .00
TOTAL USE OF MONEY 20,000.00 .0o .00 .00 20,000,00 .00
39501 SUNRISE ELECTRIC SALES 130,000.00 .00 .00 .00 1301000.00 ,00
39502 MUNI COL➢ WATER 2,167,146,00 ,00 .00 .00 2,167,146,00 .00
39503 MUNI COLD WATER COGEN 360,233.00 .00 .00 .00 360,233.00 .00
39504 MUNI HOT WATER 59,754,00 .00 .00 .00 59,754.00 .00
39505 MUNI ELECTRIC SALES 30,000,00 .00 .00 .00 30,OOp.00 .00
39506 SUNRISE / COLD WATER 696,914,p0 .00 ,00 .00 896,914.00 .00
39507 SUNRISE COLD WATER COGEN 97,074,00 .00 ,00 .00 97,074.00 .00
39508 SUNRISE HOT WATER 71,124,00 .Do ,00 .00 7I,124,00 .00
59509 ENERGY OUTREACH 35,000.00 .00 .o0 .00 35,000.00 .00
39$10 CITY P➢ ELEC/COLD WATER 151000.0D .00 .00 .00 15,000.00 .00
TOTAL TITLE NOT FOUND 3,$6Y,245.00 .00 .00 .00 3,862,245.00 .00
TOTAL COGEN 3,S52,245,00 .00 ,00 .00 3,562,24$,0p .00
TOTAL TITLE NOT FOUND 3,892,245,00 .Op .00 .00 3,682,245.00 .00
TOTAL INTERNAL SERVICE FUNDS 3,882,245.00 .Op ,00 .00 3,882,245.00 ,00
TOTAL ENERGY 3,B82,245.00 .00 .00 .00 3,982,245.00 .Op