Quarterly Summary for the Twelve Months Ended September 30, 2010 December 15, 2010 Report # 692
Released on: December 15, 2010
OFFICE OF THE COUNCIL AUDITOR
Suite 200, St. James Building
December 15, 2010
Special Report # 692
Honorable Members of the City Council City of Jacksonville Pursuant to Chapter 106 of the Ordinance Code, attached are the required financial statements and narratives for the fiscal year ended September 30, 2010 for the City and its Independent Agencies. The various reporting entities compiled these reports, which are not audited by the Council Auditor’s Office except for tests of reasonableness on a sample basis. Thus, our report does not represent an audit or attestation conducted pursuant to Government Auditing Standards. Municipal Code Sections 106.421 through 106.423 require this quarterly financial report. To meet the reporting dates specified by law, the Director of Finance or Chief Financial Officer of the City and each of its independent agencies were to submit their reports to the Council Auditor on or before November 30, 2010, and we are to submit the consolidated financial report by December 15, 2010. The footnotes attached to the statements and the narrative reports from the reporting entities are generally sufficient for understanding the statements presented; however, we have commented to provide further clarification. CITY OF JACKSONVILLE We noted that many of the City of Jacksonville’s various sub-funds presented in this quarterly report are financially challenged. The reader will note many of the same comments repeated for several Sub-funds. Our review consisted of the General Fund and 29 other Sub-funds. The General Fund and 9 of the other 29 Sub-funds reviewed experienced an unfavorable budget variance for the fiscal year. We are concerned regarding the cumulative negative effect of these sub-funds on the overall financial condition of the City. In an effort to assist the reader to comprehend more fully how the General Fund revenue and expenditures are divided among the various departments we have included two new schedules that show the revenue and expenditures broken out among the various departments in the City. (See pages 20 and 21 for the new schedules.) General Fund / General Services District As discussed in the Finance Director’s narrative, the General Fund incurred an unfavorable variance of ($7.0 million). Revenues were $10.5 million less than budgeted and expenditures were $3.5 million less than budgeted. The effect of the unfavorable variance is to reduce the City’s Operating Reserve by $7 million.
117 West Duval Street Jacksonville, Florida 32202-3701 Telephone (904) 630-1625 Fax (904) 630-2908 www.coj.net
Clerk of the Court (Sub-fund 016) The Sub-fund incurred an unfavorable variance of ($341,316) for the fiscal year after being subjected to a ($500,000) extraordinary lapse. The Sub-fund balance sheet shows negative cash and negative fund equity. The Clerk and the City need to take action to address this situation. Worthy of mention is the September 20, 2010 letter from Clerk of the Court Jim Fuller to Mayor Peyton giving ninety days written notice of his intention to terminate the February 6, 2008 Memorandum of Understanding between the City and Clerk. Parking Garage Revenue (Sub-fund 412) Sub-fund 412 is in poor financial condition. The Sub-fund incurred an unfavorable variance of ($752,277) for the fiscal year. The balance sheet for Sub-fund 412 shows a negative cash balance ($2,234,900) with current liabilities of $1,251,313. Stormwater Services (Sub-fund 461) Although it ended the fiscal year with a small favorable budget variance, the Sub-Fund shows negative cash of $13.7 million and current liabilities of $1.1 million. This is due to the timing of the stormwater services user fee bill. When the fee was placed on the tax bill, it resulted in user fees being collected in arrears. Therefore, the sub-fund will likely experience a negative cash balance for a portion of each fiscal year. Municipal Stadium (Sub-fund 4A0) The Municipal Stadium Sub-Fund incurred an unfavorable budget variance of ($68,159) for the fiscal year. The balance sheet shows that current liabilities exceed current assets by $611,749. Baseball Stadium (Sub-fund 4C0) The Baseball Stadium Sub-fund incurred an unfavorable budget variance of ($103,743) for the fiscal year. Times Union Performing Arts Center (Sub-fund 4D0) The Performing Arts Center Sub-fund incurred an unfavorable variance of ($169,806) for the fiscal year. The balance sheet shows a negative cash balance of ($95,911), Taxes and Other Receivables of $43,134, and current liabilities of $993,367. Equestrian Center (Sub-fund 4F0) The Equestrian Center Sub-fund incurred an unfavorable variance of ($109,085) for the fiscal year. The balance sheet shows a negative cash balance of ($394,090), Taxes and Other Receivables of $25,386, and current liabilities of $139,700. Fleet Management Operations (Sub-fund 511) The Fleet Management Operations Sub-fund incurred an unfavorable variance of ($626,398) for the fiscal year. The balance sheet shows a negative cash balance of ($172,321) and current liabilities of $2,342,254, which far exceed accounts receivable amounts totaling $1,036,841.
-2-
Copy Center (Sub-fund 521) The Copy Center Sub-fund remains insolvent. Although the Sub-Fund experienced a favorable budget variance of $273,786 for the fiscal year, the balance sheet for the Copy Center shows a negative cash balance of ($11,056), negative total assets of ($6,650), current liabilities of $85,756 and negative fund equity of ($144,019). The Administration needs to take action to address this situation. ITD Operations (Sub-fund 531) The ITD Operations Sub-Fund incurred an unfavorable budget variance of ($193,974) for the fiscal year. The balance sheet for ITD Operations shows a negative cash balance of ($510,586) and current liabilities of $2,950,075. This Sub-fund does not have the financial capacity to meet its liabilities. The Administration needs to take action to address this situation. Communications (Sub-fund 533) The Communications Sub-Fund incurred an unfavorable budget variance of ($8,534) for the fiscal year. INDEPENDENT AGENCIES JEA Electric System The financial report for the fiscal year ended September 30, 2010 indicates that the Electric System experienced a balanced Fuel Fund and a Non-Fuel operating surplus of $4,715,192. However, JEA withdrew $64,474,378 from the Rate Stabilization Fund without which JEA would have shown a Fuel Fund deficit. It is JEA’s policy to maintain its Fuel Rate Stabilization Fund at a balance of 15% of annual fuel expense. Based on fuel expense for the year, this would equate to approximately $82 million. The Fuel Rate Stabilization balance at September 30, 2010 was $55,934,622, but this includes a board approved $35 million loan from the electric system base side to be repaid over three years. Annually, per the JEA Variable Fuel Rate Policy, the Variable Fuel Rate is calculated to incorporate changes in actual fuel cost and adjusted for the following fiscal year Fuel Fund Budget. JEA indicates that due to extreme weather, electric sales are higher than were budgeted for in fiscal 2009/2010. Consequently, JEA submitted a Bill (2010-662), enacted by City Council September 14, 2010, in order to increase total budgeted revenues and appropriations for fiscal 2009/2010 by $62,293,671 from $1,294,662,940 to $1,356,956,611 to pay for the projected increase in associated expenses. Sales exceeded this projection by $34,000,000 and JEA adjusted the budget to $1,390,956,611 and, by law, defeased additional debt with those funds. Water & Sewer System The financial report for the fiscal year ended September 30, 2010 shows that the Water & Sewer System produced an operating surplus of $9,207,197. JEA noted in the report that the surplus will be used to defease Water & Sewer System debt in November and March of fiscal year 2011.
-3-
District Energy System District Energy System produced a fiscal year surplus of $233,239. JEA Capital Projects Per JEA, the majority of the favorable capital budget variance is due to the deferment or delay of projects. These projects will be funded by subsequent capital budgets.
Water and Sewer Expansion Authority WSEA’s quarterly summary for the 12 months ending September 30, 2010 indicates no budgetary stress. Jacksonville Transportation Authority The financial report of the Jacksonville Transportation Authority (JTA) for the fiscal year ended September 30, 2010 indicates considerable budgetary stress. Bus Operations suffered a loss of ($8,112,213) and the Engineering General Fund incurred a loss of ($2,893,790). These losses are primarily attributed to lower than budgeted revenue from sales tax. Although CTC Operations did not incur a loss, the balance sheet shows that current liabilities greatly exceed current assets and the fund has negative equity. Jacksonville Port Authority The Jacksonville Port Authority’s (JPA) financial report for the fiscal year ending September 30, 2010 indicates no budgetary stress. Jacksonville Aviation Authority The Jacksonville Aviation Authority’s (JAA) financial report for the fiscal year ending September 30, 2010 indicates that the JAA experienced no budgetary stress. Although the report indicates no year-end surplus or deficit, Net Income before transfers to Operating Capital Outlay, PFC Reserve and Retained Earnings was $16,398,913, with these funds being transferred to Operating Capital Outlay, PFC Reserve and Retained Earnings.
DEBT RATINGS In an effort to monitor any significant changes in debt ratings on outstanding debt issued by the City and its Independent Agencies, we asked that the Director of Finance and any Independent Agencies who issue bonds provide rating information on a quarterly basis. In reviewing this information, we noted that Moodys downgraded the City’s BJP Infrastructure pledge two notches from Aa2 to A1. The reason cited for the downgrade was a debt service coverage ratio that was not consistent with a AA pledge. This downgrade is directly attributable to the decrease in sales tax revenue. Please refer to pages 15 and 16 for a detailed list of individual bond ratings.
-4-
FINANCIAL REPORTS The following financial reports are presented as prepared by the various reporting entities. NARRATIVES City of Jacksonville JEA Water and Sewer Expansion Authority Jacksonville Transportation Authority Jacksonville Port Authority Jacksonville Aviation Authority
PAGES 6-8 9 10 11-12 13 14
BOND RATINGS City of Jacksonville Independent Agencies Bond Rating Scale
15 16 17 – 19
FINANCIAL STATEMENTS Revenues and Expenditures by Department City of Jacksonville JEA Water and Sewer Expansion Authority Jacksonville Transportation Authority Jacksonville Port Authority Jacksonville Aviation Authority
20 – 21 22 – 52 53 – 63 64 – 66 67 – 71 72 – 73 74 – 75 Respectfully submitted,
Kirk A. Sherman, CPA Council Auditor
-5-
6
7
8
November 23, 2010
SUBJECT:
QUARTERLY FINANCIAL SUMMARY – September 30, 2010
FROM:
Paul E. McElroy, Chief Financial Officer JEA
TO:
Mr. Kirk Sherman, CPA Council Auditor City Hall
The attached financial summary for JEA has been prepared in accordance with the instructions provided by the Council Auditor’s Office. For the year ended September 30, 2010, JEA contributed a record high $99.2 million to the City’s General Fund. JEA also paid to the City $79.5 million Public Service Tax and $38.6 million City of Jacksonville Franchise Fee for a total payment of $217.3 million which represents an increase of $12.6 million over prior year. The Electric System produced a positive fund balance of $4.7 million for the year ended September 30, 2010. This represents 0.56% of the annual operating budget. The Water and Sewer System produced a positive fund balance of $9.2 million for the year ended September 30, 2010. This represents 2.97% of the total annual operating budget. The fund balance was utilized to defease $8.5 million of debt in November 2010. The remaining $0.7 million of the fund balance will be used to defease debt in March 2011. The District Energy System produced a favorable fund balance of $233 thousand for the year ended September 30, 2010. JEA experienced higher than expected sales and revenues due in large part to weather conditions throughout the year. A colder than anticipated winter and significantly less annual rainfall than normal contributed to increased electric system and water system revenues, respectively. In accordance with the City Ordinance, JEA submitted an Electric System budget amendment to City Council reflecting the increased sales. The amendment was enacted September 14, 2010. Credit markets have regained some stability. JEA is actively monitoring the credit markets in order to efficiently manage debt and maintain access for new capital (debt). JEA has taken a proactive approach to mitigate the impact of the economic downturn on our business by reducing capital, as well as operating and maintenance expense spending. A schedule of JEA’s bond ratings as of September 2010 is included with this report.
Paul E. McElroy, Chief Financial Officer Attachments: As noted
9
October 21, 2010
MEMORANDUM
TO:
Kirk Sherman, CPA Council Auditor
FROM:
Fred C. Odom, P.E. Executive Director
SUBJECT: Quarterly Financial Summary ending September 2010 ______________________________________________________________________ The attached financial summary for WSEA has been prepared in accordance with the instructions provided by the Council Auditor’s Office. Operating Budget: Our fiscal year 2009 - 2010 operating budget consists of benefits and salaries, supplies and other operating expenses from JEA and the payment to the city loan pool. We are within budget on all of these items. See attached monthly and quarterly report. Capital Budget: The pilot project in Lincoln Villas Phase 1 is complete and will be available for connection by December 2010. The WSEA also received a 2008 CIBR grant from the State in the amount of 300K for Lincoln Villas Phase 2. We have secured those funds and we are in the process of putting legislation together to move forward with Lincoln Villa Phase 2 and use of this grant funding. The EPA required an Environmental Information Document (EID) to spend federal funding to show that there aren’t environmental impacts to the Lincoln Villa area. We have completed that and turned it into EPA for review. We believe they are considering a Categorical Exclusion, which will speed the approval process up. Please see the attached WSEA capital spreadsheet for projects that have been appropriated through City Council with the status of each project, and the project costs. To date, City Council has approved $4,840,644.57 for these projects, and total expenditures on completed projects are $3,842,511.04. As always, please feel free to contact me at 665-5125 or 571-2397 if you have any questions or would like additional information.
21 West Church Street, T-16 • Jacksonville, FL 32202 Office: 904-665-449610• Fax: 904-665-4238 Web site: www.wsea.org
JACKSONVILLE TRANSPORTATION AUTHORITY P.O. DRAWER "O"
TELEPHONE 904/630-3181
• 100 N. MYRTLE AVENUE • JACKSONVILLE, FLORIDA 32203
November 24, 2010
Mr. Kirk Sherman, CPA Council Auditor City Hall - Suite 200 117 West Duval Street Jacksonville, Florida 32202
Dear Mr. Sherman: Enclosed are the quarterly reports for the Jacksonville Transportation Authority for the year ended September 30, 2010. Engineering/Highway Division General Fund Sales tax receipts for the fiscal year were $63.6 million as compared to the budget amount of $68.8 million. This is a $5.2 million shortfall, or 7.6%. We do not expect a turnaround in the next fiscal year until lagging indicators such as the unemployment rate improve. General fund expenditures in total were under budget by $3.3 million. The primary reason was the sales tax outflow for State of Florida and Better Jacksonville Plan bonds. Less sales tax revenues translate into less sales tax transferred out for debt service on those bonds. Though under budget, the General Fund finished the year with revenues falling short of expenditures by $2.9 million. The current assets balance of $33.3 million includes a receivable of $20.7 million due from The City of Jacksonville for completed BJP work that has been invoiced but unpaid. $13.6 million of this unreimbursed amount has been outstanding since 2008.
Mass Transit Division Bus Operations Bus Operations’ expenditures for the year ended September 30th were under budget by $5 million or 6.9%. As a net number, after eliminating transfers between funds, this level of spending was consistent with the prior year, and down $11.1 million from the year before that. continued
11
JTA-Providing Transportation Solutions www.RideJTA.net
JACKSONVILLE TRANSPORTATION AUTHORITY P.O. DRAWER "O"
TELEPHONE 904/630-3181
• 100 N. MYRTLE AVENUE • JACKSONVILLE, FLORIDA 32203
Mr. Kirk Sherman, CPA November 24, 2010 – Page 2 Bus operations’ revenues were $13.1million under budget. This is down $13.7 million from last year and down $13.2 million from two years ago. While cost containment has helped to decrease expenses, the revenue shortfall has been even greater, resulting in the $8.1 million deficit for the fiscal year.
Automated Skyway Express (ASE) Skyway finished the year under budget by $709K (or 14%) due to cost containment and personnel transfers. The majority of the favorable variance was centered in salaries and fringes. Compared to the same period last year, Skyway under spent by $1 million.
Connexion (CTC) Expenditures for our Connexion service (providing transportation to the disabled population) were under budget for the year by $1,582. Compared to the same period a year ago, Connexion’s expenses are only 0.4% higher ($52K). Our eligibility center continues to evaluate riders for participation in the paratransit system and is one of the leading reasons that costs have stabilized. Please call me at 630-3116 if you have any questions concerning the above. Sincerely,
Thomas E. Cerino Controller
12
JTA-Providing Transportation Solutions www.RideJTA.net
13
November 24, 2010
Mr. Kirk Sherman, CPA Council Auditor City Hall at St. James, Suite 200 117 W. Duval Street Jacksonville, FL 32202
RE:
Quarterly Report
Dear Mr. Sherman: The attached financial summary for the Jacksonville Aviation Authority has been prepared in accordance with the instructions provided by the Council Auditor’s Office. Enclosed is the Unaudited Quarterly Report of the Jacksonville Aviation Authority for the twelve months ended September 30, 2010. Operating Revenues were $59.3 million which results in a negative variance of $2,414,722. Operating Expenditures were $38.6 million which results in a positive variance of $5.3 million. The fiscal year end closes with a positive Operating Income variance of $2.88 million. The Jacksonville Aviation Authority is in a good financial position and has experienced no budgetary stress during the fiscal year. If you have any questions or need additional information, please call Jill Schneider at 741-3756.
Sincerely,
Richard A. Rossi Chief Financial Officer
14
BOND CLASSIFICATION
FROM
TO
MOODY'S
S&P
FITCH
Issuer Credit Rating (Implied GO)
1997 2000 2004 2008
1999 2003 2007 Current
Aa2 Aa2 n/a Aa3
AA n/a n/a AA
AA n/a n/a AA
Covenant Bonds
2008
Current
Aa3
AA-
AA-
Revenue Bonds
1997 2000 2001 2003 2004 2005 2006 2008
1999 2000 2002 2003 2004 2005 2007 Current
A1 A1 Aa3 Aa2 / A2 Aa2 / A2 Aa3 / A1 Aa3 / A1 Aa3 / A1
A+ A+ A+ AA / AAAA- / A AA- / A AA- / A+ AA- / A
A+ AA AA AA / AAAA / AAAA / AAAA / AAAA / A+
Better Jacksonville Plan
1997 2000 2001 2007 2009
1999 2000 2006 2008 Current
n/a n/a Aa3 Aa3 Aa3
n/a n/a A+ AAAA-
n/a n/a AA AA AA-
Commercial Paper Notes
2002 2004 2010
2003 2009 Current
n/a n/a P-1
n/a A-1+ n/a
n/a n/a n/a
15
Bond Ratings for Independent Agencies As of September 30, 2010 Fitch
S&P
Moody
JEA Uninsured Long Term Electric Senior Electric Subordinated
AAAA-
AAA+
Aa2 Aa3
Uninsured Short Term Electric Subordinated Commercial Paper Electric Subordinated Bonds
F1+ F1+
A-1+ A-1
P-1 VMIG-1
Uninsured Long Term SJRPP
AA-
AA-
Aa2
Uninsured Long Term Water and Sewer Senior (*) Water and Sewer Subordinated (*)
AA AA
AAAA-
Aa2 Aa2
Uninsured Short Term Water and Sewer Senior Bonds
F1+
A-1+
VMIG-1
District Energy System Bulk Power Supply System Bonds (**) Long Term (***) Short Term
AAA+ F1+
AAN/A
Aa2 Aa2 VMIG-1
Jacksonville Port Authority Revenue Bonds- Series 2000 (Uninsured) Revenue Bonds - Series 2006 (****) Revenue Bonds - Series 2008
A N/A A
Not Rated Not Rated Not Rated
A2 N/A A2
A A A A
AAAA-
A2 A2 A2 A2
Jacksonville Airport Authority JAA Revenue Bonds- Series 2003A JAA Revenue Bonds- Series 2003B JAA Revenue Refunding Bonds- Series 2005 JAA Revenue Bonds -Series 2006
Source: JEA- Helen Kehrt, Treasurer JPA- Michael Poole, Deputy Executive Director and Chief Financial Officer JAA- Diane Pinkerman, Acting Controller * During the 3rd quarter Fitch and Moody's upgraded the Senior and Subordinated Water and Sewer long term bond ratings to AA from AA- and from Aa3 to Aa2 respectively. ** JEA issued debt for environmental improvements at the Scherer Plant in FY2009. *** The Fitch rating on this issue was downgraded from AA- to A+. Per JEA, this bond issue has a letter of credit and the rating downgrade is a reflection of a reduction in the bank's rating (State Street), not JEA's rating.
****JPA paid off the 2006 Revenue Bonds in November of 2009.
.
16
Long-Term Bond Ratings Moody's Aaa
S&P AAA
Fitch AAA
Definitions Prime Maximum Safety
Aa1 Aa2 Aa3
AA+ AA AA-
AA+ AA AA-
High Grade High Quality
A1 A2 A3
A+ A A-
A+ A A-
Upper Medium Grade
Baa1 Baa2 Baa3
BBB+ BBB BBB-
BBB+ BBB BBB-
Lower Medium Grade
Ba1
BB+
BB+
Non Investment Grade
Ba2 Ba3
BB BB-
BB BB-
Speculative
B1 B2 B3
B+ B B-
B+ B B-
Highly Speculative
Caa1
CCC+
CCC
Substantial Risk
Caa2 Caa3
CCC CCC-
-
In Poor Standing
Ca
-
-
Extremely Speculative
C
-
-
Maybe in Default
-
D -
DDD DD D -
Default
17
Short-Term Bond Ratings Moody's This designation denotes A-1 superior credit quality. Excellent protection is afforded by established cash flows, highly reliable liquidity support, or demonstrated broad based access to the market for refinancing.
S&P A short-term obligation rated F-1 'A-1' is rated in the highest category by S&P. The obligator's capacity to meet its financial commitment on the obligation is strong. Within this category, certain obligations are designated with a plus sign (+). This indicates that the obligor's capacity to meet its financial commitment on these obligations is extremely strong.
Fitch Indicates the strongest capacity for timely payment of financial commitments relative to other issuers or issues in the same country. Under their national rating scale, this rating is assigned to the "best" credit risk relative to all others in the same country and is normally assigned to all financial commitments issued or guaranteed by the sovereign state. Where the credit risk is particularly strong, a "+" is added to the assigned rating.
VMIG2
This designation denotes A-2 strong credit quality. Margins of protection are ample, although not as large as in the preceding group.
A short-term obligation rated F-2 'A-2' is somewhat more susceptible to the adverse effects of changes in circumstances and economic conditions than obligations in higher rating categories. However, the obligator's capacity to meet its financial commitment on the obligation is satisfactory.
Indicates a satisfactory capacity for timely payment of financial commitments relative to other issuers or issues in the same country. However, the margin of safety is not as great as in the case of the higher ratings.
VMIG3
This designation denotes A-3 acceptable credit quality. Liquidity and cash-flow protection may be narrow, and market access for refinancing is likely to be less well-established.
A short-term obligation rated F-3 'A-3' exhibits adequate protection parameters. However, adverse economic conditions or changing circumstances are more likely to lead to a weakened capacity of the obligor to meet its financial commitment on the obligation.
Indicates an adequate capacity for timely payment of financial commitments relative to other issuers or issues in the same country. However, such capacity is more susceptible to near-term adverse changes than for financial commitments in higher rated categories.
VMIG1
18
Short-Term Bond Ratings SG
Moody's This designation denotes B speculative-grade credit quality. Debt instruments in this category may lack sufficient margins of protection.
S&P A short-term obligation rated B 'B' is regarded as having significant speculative characteristics. The obligor currently has the capacity to meet its financial commitment on the obligation; however, it faces major ongoing uncertainties which could lead to the obligor's inadequate capacity to meet its financial commitment on the obligation.
Fitch Indicates an uncertain capacity for timely payment of financial commitments relative to other issuers or issues in the same country. Such capacity is highly susceptible to near-term adverse changes in financial and economic conditions.
C
A short-term obligation rated C 'C' is currently vulnerable to nonpayment and is dependent upon favorable business, financial, and economic conditions for the obligor to meet its financial commitment on the obligation.
Indicates a highly uncertain capacity for timely payment of financial commitments relative to other issuers or issues in the same country. Capacity or meeting financial commitments is solely reliant upon a sustained, favorable business and economic environment.
D
A short-term obligation rated D 'D' is in payment default. The 'D' rating category is used when payments on an obligation are not made on the date due even if the applicable grace period has not expired, unless S&P believes that such payments will be made during such grace period. The 'D' rating also will be used upon the filing of a bankruptcy petition or the taking of a similar action if payments on an obligation are jeopardized.
Indicates actual or imminent payment default.
19
CONSOLIDATED CITY OF JACKSONVILLE QUARTERLY FINANCIAL SUMMARY FOR THE QUARTER ENDED SEPTEMBER 30, 2010 GENERAL FUND GSD - 011 REVENUE - VARIOUS DEPARTMENTS
Variance Favorable (Unfavorable)
Revised Budget
Actuals
470,085,407
476,531,734
1,131,466
1,057,830
(73,636)
39,444,236
39,842,249
398,013
129,456,900
126,878,390
(2,578,510)
8,067,732
8,052,071
(15,661)
FEDERAL GRANTS
94,150
108,094
13,944
FEDERAL PAYMENTS IN LIEU OF TAXES
30,000
23,685
(6,315)
AD VALOREM TAXES SALES AND USE TAXES FRANCHISE FEES UTILITY SERVICE TAXES BUSINESS TAXES
STATE GRANTS STATE SHARED REVENUES CONTRIBUTIONS FROM OTHER LOCAL UNITS
6,446,327
297,000
410,488
129,200,828
118,716,464
(10,484,364)
113,488
99,187,538
99,187,528
(10) (1,404,891)
GENERAL GOVERNMENT
10,443,725
9,038,834
PUBLIC SAFETY
18,371,568
19,204,387
832,819
218,360
387,439
169,079
HUMAN SERVICES
1,965,015
1,452,114
(512,901)
CULTURE AND RECREATION
1,725,860
1,796,461
70,601
0
2,044
2,044
28,072,129
27,222,548
(849,581)
1,391,863
914,706
(477,157)
PHYSICAL ENVIRONMENT
COURT-RELATED REVENUES OTHER CHARGES FOR SERVICES JUDGMENT AND FINES VIOLATIONS OF LOCAL ORDINANCES
865,186
646,777
(218,409)
1,893,614
1,435,151
(458,463)
10,995,038
10,353,436
(641,602)
1,070,732
1,321,339
DISPOSITION OF FIXED ASSETS
75,000
15,129
(59,872)
CONTRIB & DONATIONS FROM PRIVATE SOURCES
75,000
6,917
(68,083)
OTHER MISCELLANEOUS REVENUE
13,956,063
14,973,761
1,017,698
CONTRIBUTIONS FROM OTHER FUNDS
16,105,830
17,502,984
1,397,154
6,944,462
3,556,484
(3,387,977)
991,164,702
980,639,045
(10,525,657)
OTHER FINES AND/OR FORFEITS INTEREST, INCL PROFITS ON INVESTMENTS RENTS AND ROYALTIES
DEBT PROCEEDS
20
250,607
CONSOLIDATED CITY OF JACKSONVILLE QUARTERLY FINANCIAL SUMMARY FOR THE QUARTER ENDED SEPTEMBER 30, 2010 GENERAL FUND GSD - 011 EXPENDITURES BY DEPARTMENT
ADVISORY BOARDS CENTRAL OPERATIONS
Revised Budget
Actuals plus Encumbrances
Variance Favorable (Unfavorable)
425,687
456,475
(30,788)
21,910,868
20,422,136
1,488,732
CITY COUNCIL
9,685,321
8,931,577
753,743
COURTS
1,579,035
1,293,736
285,299
20,219,454
19,234,019
985,434
ENVIRONMENTAL & COMPLIANCE FINANCE FIRE AND RESCUE GENERAL COUNSEL HUMAN RIGHTS COMMISSION
8,718,108
8,399,765
318,343
166,893,436
165,730,063
1,163,373
717,156
720,026
1,310,784
1,242,854
(2,870) 67,929
MAYOR'S OFFICE
2,074,510
2,084,743
(10,233)
MEDICAL EXAMINER
3,162,368
2,882,202
280,166
359,555,225
352,822,948
6,732,277
8,741,515
8,428,588
312,927
OFFICE OF THE SHERIFF PLANNING AND DEVELOPMENT PUBLIC DEFENDER
944,505
944,146
359
PUBLIC HEALTH
732,899
281,497
451,402
PUBLIC LIBRARIES
42,316,450
41,626,557
689,892
PUBLIC WORKS
83,207,559
80,497,509
2,710,050
RECREATION & COMMUNITY SERVICES
49,393,213
48,362,026
1,031,187
441,159
359,181
81,978
9,068,555
6,211,970
2,856,585
JACKSONVILLE CITYWIDE ACTIVITIES
46,437,671
71,296,901
(24,859,230)
TRANSFERS OUT - DEBT
67,622,828
59,638,898
7,983,930
TRANSFERS OUT
85,571,962
85,368,081
203,881
990,730,267
987,235,899
3,494,368
STATE ATTORNEY SUPERVISOR OF ELECTIONS
21
CONSOLIDATED CITY OF JACKSONVILLE YEAR-END FINANCIAL SUMMARY - SUBFUND LEVEL FOR THE QUARTER ENDED SEPTEMBER 30, 2010 011 - GENERAL FUND - GSD BALANCE SHEET INFORMATION ASSETS
LIABILITIES
Pooled Cash and Investments Taxes and other Receivable, Net
40,655,582.18 29,892,919.95
Due from Other Government Units
47,199,352.83
Inventories Other Current Assets
7,113,498.72 58,667,903.10
Current Liabilities Other Liabilities
43,755,837.93 80,160,648.55
TOTAL LIABILITIES
123,916,486.48
FUND EQUITY Beginning of Year
48,497,879.07
Current Yr Less Encumbrances
4,001,392.51
Reserves and Encumbrances
7,113,498.72
TOTAL FUND EQUITY TOTAL ASSETS
183,529,256.78
59,612,770.30
TOTAL LIABILITIES FUND EQUITY
183,529,256.78
BUDGET INFORMATION REVISED BUDGET
Y-T-D ACTUAL
Y-T-D ENCUMB.
VARIANCE
Taxes
640,118,009
644,310,204
0
4,192,195
Licenses and Permits Intergovernmental Revenue
8,067,732 129,621,978
8,052,071 119,258,732
0 0
(15,661) (10,363,246)
Charges for Services
60,796,657
59,103,826
0
(1,692,831)
Fines and Forfeits Miscellaneous Revenue
4,150,663 26,171,833
2,996,634 26,670,581
0 0
(1,154,029) 498,748
+ Fav / - Unfav
REVENUE
Other Sources
6,944,462
3,556,484
0
(3,387,977)
Transfers From Other Funds
16,105,830
17,502,984
0
1,397,154
Transfers From Component Units
99,187,538
99,187,528
0
(10)
991,164,702
980,639,045
0
(10,525,657)
Salaries Lapse
380,002,809 (8,067,029)
370,717,511 0
7,504 0
9,277,794 (8,067,029)
Employer Provided Benefits
167,870,567
166,636,920
0
Internal Service Charges Other Operating Expenses
73,995,932 149,890,705
74,146,693 132,799,559
0 7,790,858
TOTAL
REVENUE
EXPENDITURES
Library Materials
1,233,647 (150,760) 9,300,287
3,809,736
3,719,601
0
90,135
Capital Outlay
10,373,061
6,292,900
1,546,723
2,533,438
Debt Service Grants and Aids
67,622,828 31,604,885
59,638,898 31,270,365
0 87,479
7,983,930 247,041
Supervision Allocation
(1,142,986)
Indirect Cost Transfers to Other Funds Other Extraordinary Lapse Banking Fund Debt Repayment Fiscal and Other Debt Fees TOTAL
EXPENDITURES
0
(635,581)
8,936,376 104,929,795
8,936,376 104,443,437
0 0
0 486,357
6,562,827
1,713,715
0
4,849,112
0
0
(21,771,389)
15,315,266 796,884
17,257,550 737,214
0 0
(1,942,284) 59,670
990,730,267
977,803,335
9,432,564
(21,771,389)
22
(507,405)
3,494,368
CURRENT YEAR
434,435
FUND BALANCE TRANSFERS
311,658
CARRYOVERS CONTINGENCIES
0 (11,852,757)
RESERVE - PRIOR YEAR ENCUMBRANCES
11,106,664
BUDGET DIFFERENCE
0
23
2,835,710
(9,432,564)
(7,031,289)
CONSOLIDATED CITY OF JACKSONVILLE YEAR-END FINANCIAL SUMMARY - SUBFUND LEVEL FOR THE QUARTER ENDED SEPTEMBER 30, 2010 015 - PROPERTY APPRAISER BALANCE SHEET INFORMATION ASSETS
LIABILITIES
Pooled Cash and Investments
1,153,372.99
Current Liabilities
345,534.30
TOTAL LIABILITIES
345,534.30
FUND EQUITY Beginning of Year Current Yr Less Encumbrances
578,916.94 228,921.75 807,838.69
TOTAL FUND EQUITY TOTAL ASSETS
1,153,372.99
TOTAL LIABILITIES FUND EQUITY
1,153,372.99
BUDGET INFORMATION REVISED BUDGET
Y-T-D ACTUAL
Y-T-D ENCUMB.
VARIANCE + Fav / - Unfav
REVENUE Charges for Services Miscellaneous Revenue Transfers From Other Funds TOTAL
REVENUE
349,766
341,157
0
(8,609)
74,331
114,394
0
40,063
8,496,946
8,496,946
0
0
8,921,043
8,952,497
0
31,454
EXPENDITURES Salaries
5,765,234
5,549,601
0
215,633
Lapse Employer Provided Benefits
(137,094) 1,776,377
0 1,760,167
0 0
(137,094) 16,210
Internal Service Charges
1,043,160
1,147,750
0
(104,590)
Other Operating Expenses Capital Outlay
1,045,290 72,501
740,739 70,540
12,000 0
292,552 1,961
4,807
4,779
0
28
9,570,275
9,273,576
12,000
284,700
(12,000)
316,154
Banking Fund Debt Repayment TOTAL
EXPENDITURES CURRENT YEAR
(649,232)
FUND BALANCE TRANSFERS
550,000
CARRYOVERS
0
CONTINGENCIES
0
RESERVE - PRIOR YEAR ENCUMBRANCES
99,232
BUDGET DIFFERENCE
0
24
(321,078)
CONSOLIDATED CITY OF JACKSONVILLE YEAR-END FINANCIAL SUMMARY - SUBFUND LEVEL FOR THE QUARTER ENDED SEPTEMBER 30, 2010 016 - CLERK OF THE COURT BALANCE SHEET INFORMATION ASSETS
LIABILITIES
Pooled Cash and Investments Due from Other Government Units
(955,967.75) 591,569.64
Current Liabilities
69,722.18
TOTAL LIABILITIES
69,722.18
FUND EQUITY Beginning of Year Current Yr Less Encumbrances
(92,804.66) (341,315.63) (434,120.29)
TOTAL FUND EQUITY TOTAL ASSETS
(364,398.11)
TOTAL LIABILITIES FUND EQUITY
(364,398.11)
BUDGET INFORMATION REVISED BUDGET
Y-T-D ACTUAL
Y-T-D ENCUMB.
VARIANCE + Fav / - Unfav
REVENUE Charges for Services
2,524,770
Miscellaneous Revenue
11,739
Transfers From Other Funds TOTAL
REVENUE
2,547,394 (32,916)
0
22,624
0
(44,655)
1,063,700
1,063,700
0
0
3,600,209
3,578,178
0
1,186,431
1,121,626
0
64,805
0 419,860
0 0
(39,903) 21,911
(22,031)
EXPENDITURES Salaries Lapse Employer Provided Benefits
(39,903) 441,771 1,026,142
979,666
0
46,476
Other Operating Expenses Capital Outlay
Internal Service Charges
492,596 1
413,852 0
0 0
78,744 1
Supervision Allocation
220,000
211,319
0
8,681
Indirect Cost
773,171
773,171
0
0
0
(500,000)
3,919,494
0
(319,285)
0
(341,316)
Extraordinary Lapse TOTAL
(500,000)
EXPENDITURES
3,600,209 CURRENT YEAR
0
FUND BALANCE TRANSFERS
0
CARRYOVERS
0
CONTINGENCIES
0
RESERVE - PRIOR YEAR ENCUMBRANCES
0
BUDGET DIFFERENCE
0
25
(341,316)
0
CONSOLIDATED CITY OF JACKSONVILLE YEAR-END FINANCIAL SUMMARY - SUBFUND LEVEL FOR THE QUARTER ENDED SEPTEMBER 30, 2010 017 - TAX COLLECTOR BALANCE SHEET INFORMATION ASSETS
LIABILITIES
Pooled Cash and Investments
4,323,357.76
Current Liabilities
569,402.52
TOTAL LIABILITIES
569,402.52
FUND EQUITY Beginning of Year Current Yr Less Encumbrances
1,334,289.62 2,419,665.62 3,753,955.24
TOTAL FUND EQUITY TOTAL ASSETS
4,323,357.76
TOTAL LIABILITIES FUND EQUITY
4,323,357.76
BUDGET INFORMATION REVISED BUDGET
Y-T-D ACTUAL
Y-T-D ENCUMB.
VARIANCE + Fav / - Unfav
REVENUE Charges for Services Miscellaneous Revenue Transfers From Other Funds TOTAL
REVENUE
9,811,555
9,537,345
0
(274,210)
99,069
317,886
0
218,817
3,856,019
3,856,019
0
0
13,766,643
13,711,250
0
(55,393)
EXPENDITURES Salaries
8,808,370
8,291,786
0
516,584
Lapse Employer Provided Benefits
(573,963) 2,865,760
0 2,730,107
0 0
(573,963) 135,653
Internal Service Charges
1,321,016
1,183,690
0
137,326
Other Operating Expenses Capital Outlay
2,582,554 2,174,986
2,269,282 46,594
98,564 121,446
214,708 2,006,946
243,069
239,271
0
3,798
17,421,792
14,760,729
220,010
2,441,053
(3,655,149)
(1,049,479)
(220,010)
2,385,660
Banking Fund Debt Repayment TOTAL
EXPENDITURES CURRENT YEAR FUND BALANCE TRANSFERS
3,469,145
CARRYOVERS
0
CONTINGENCIES
0
RESERVE - PRIOR YEAR ENCUMBRANCES
186,004
BUDGET DIFFERENCE
0
26
CONSOLIDATED CITY OF JACKSONVILLE YEAR-END FINANCIAL SUMMARY - SUBFUND LEVEL FOR THE QUARTER ENDED SEPTEMBER 30, 2010 159 - BUILDING INSPECTION BALANCE SHEET INFORMATION ASSETS
LIABILITIES
Pooled Cash and Investments Taxes and other Receivable, Net
1,654,869.28 0.00
Current Liabilities
550,919.04
TOTAL LIABILITIES
550,919.04
FUND EQUITY Beginning of Year Current Yr Less Encumbrances
712,015.93 391,934.31 1,103,950.24
TOTAL FUND EQUITY TOTAL ASSETS
1,654,869.28
TOTAL LIABILITIES FUND EQUITY
1,654,869.28
BUDGET INFORMATION REVISED BUDGET
Y-T-D ACTUAL
Y-T-D ENCUMB.
VARIANCE + Fav / - Unfav
REVENUE Charges for Services
6,673,656
6,516,367
0
Fines and Forfeits
100,740
112,806
0
12,066
Miscellaneous Revenue
234,570
285,211
0
50,641
7,008,966
6,914,384
0
(94,582)
TOTAL
REVENUE
(157,289)
EXPENDITURES Salaries
5,231,419
5,060,485
0
170,934
Lapse Employer Provided Benefits
(158,249) 1,701,832
0 1,675,704
0 0
(158,249) 26,128
Internal Service Charges
1,534,369
1,372,312
0
162,057
673,584 3
563,742 0
1,100 0
108,742 3 0
Other Operating Expenses Capital Outlay Supervision Allocation
0
0
0
Indirect Cost
595,233
595,233
0
0
Banking Fund Debt Repayment
781,717
598,845
0
182,872
10,359,908
9,866,321
1,100
492,488
(3,350,942)
(2,951,937)
(1,100)
397,906
TOTAL
EXPENDITURES CURRENT YEAR FUND BALANCE TRANSFERS
3,343,871
CARRYOVERS
0
CONTINGENCIES
0
RESERVE - PRIOR YEAR ENCUMBRANCES
7,071
BUDGET DIFFERENCE
0
27
CONSOLIDATED CITY OF JACKSONVILLE YEAR-END FINANCIAL SUMMARY - SUBFUND LEVEL FOR THE QUARTER ENDED SEPTEMBER 30, 2010 191 - JACKSONVILLE CHILDREN'S COMMISSION BALANCE SHEET INFORMATION ASSETS
LIABILITIES
Pooled Cash and Investments
2,720,488.82
Current Liabilities
416,127.42
TOTAL LIABILITIES
416,127.42
FUND EQUITY Beginning of Year Current Yr Less Encumbrances
955,679.26 1,348,682.14 2,304,361.40
TOTAL FUND EQUITY TOTAL ASSETS
2,720,488.82
TOTAL LIABILITIES FUND EQUITY
2,720,488.82
BUDGET INFORMATION REVISED BUDGET
Y-T-D ACTUAL
Y-T-D ENCUMB.
VARIANCE + Fav / - Unfav
REVENUE Miscellaneous Revenue Transfers From Other Funds TOTAL
REVENUE
435,667
496,784
0
61,117
21,058,173
21,058,173
0
0
21,493,840
21,554,957
0
61,117
2,499,289
2,334,716
0
164,573
0
0
(138,608)
666,611 636,722
686,941 754,712
0 0
(20,330) (117,990)
2,070,226
1,476,827
444,314
149,085
9,923 13,415,567
0 11,942,476
9,054 1,070,098
869 402,993
3,009,672
3,009,672
0
0
948
930
0
18
22,170,350
20,206,275
1,523,466
440,609
1,348,682
(1,523,466)
501,726
EXPENDITURES Salaries Lapse
(138,608)
Employer Provided Benefits Internal Service Charges Other Operating Expenses Capital Outlay Grants and Aids Transfers to Other Funds Banking Fund Debt Repayment TOTAL
EXPENDITURES CURRENT YEAR
(676,510)
FUND BALANCE TRANSFERS
0
CARRYOVERS
0
CONTINGENCIES
0
RESERVE - PRIOR YEAR ENCUMBRANCES
676,510
BUDGET DIFFERENCE
0
28
CONSOLIDATED CITY OF JACKSONVILLE YEAR-END FINANCIAL SUMMARY - SUBFUND LEVEL FOR THE QUARTER ENDED SEPTEMBER 30, 2010 411 - PUBLIC PARKING SYSTEM BALANCE SHEET INFORMATION ASSETS
LIABILITIES
Pooled Cash and Investments Capital Assets, Net
291,034.87 4,262,368.78
Current Liabilities Other Liabilities
223,031.65 164,592.80
TOTAL LIABILITIES
387,624.45
FUND EQUITY Beginning of Year
4,228,387.65
Current Yr Less Encumbrances
(62,608.45)
TOTAL FUND EQUITY TOTAL ASSETS
4,553,403.65
4,165,779.20
TOTAL LIABILITIES FUND EQUITY
4,553,403.65
BUDGET INFORMATION REVISED BUDGET
Y-T-D ACTUAL
Y-T-D ENCUMB.
VARIANCE + Fav / - Unfav
REVENUE Charges for Services
2,227,749
1,904,861
0
(322,888)
683,075
551,107
0
(131,968)
27,751 5,300
29,811 5,300
0 0
2,943,875
2,491,080
0
1,347,815
1,101,629
0
246,186
0
0
(116,884)
475,942 307,211
427,633 260,430
0 1
48,309 46,780
Other Operating Expenses
444,634
330,780
66,220
47,634
Capital Outlay
198,465
0
0
198,465
Indirect Cost Transfers to Other Funds
157,042 377,711
157,042 377,711
0 0
0 0
3,191,936
2,655,226
66,221
470,490
(66,221)
17,694
Fines and Forfeits Miscellaneous Revenue Transfers From Other Funds TOTAL
REVENUE
2,060 0 (452,795)
EXPENDITURES Salaries Lapse
(116,884)
Employer Provided Benefits Internal Service Charges
TOTAL
EXPENDITURES CURRENT YEAR
(248,061)
FUND BALANCE TRANSFERS
198,464
CARRYOVERS
0
CONTINGENCIES
0
RESERVE - PRIOR YEAR ENCUMBRANCES
49,597
BUDGET DIFFERENCE
0
29
(164,146)
CONSOLIDATED CITY OF JACKSONVILLE YEAR-END FINANCIAL SUMMARY - SUBFUND LEVEL FOR THE QUARTER ENDED SEPTEMBER 30, 2010 412 - PARKING GARAGE REVENUE BALANCE SHEET INFORMATION ASSETS
LIABILITIES
Pooled Cash and Investments Capital Assets, Net
(2,234,900.12) 4,983,737.72
Current Liabilities Other Liabilities
1,251,313.11 994,839.21
TOTAL LIABILITIES
2,246,152.32
FUND EQUITY Beginning of Year
(2,954,042.76)
Current Yr Less Encumbrances
3,456,728.04
TOTAL FUND EQUITY TOTAL ASSETS
2,748,837.60
502,685.28
TOTAL LIABILITIES FUND EQUITY
2,748,837.60
BUDGET INFORMATION REVISED BUDGET
Y-T-D ACTUAL
Y-T-D ENCUMB.
VARIANCE + Fav / - Unfav
REVENUE Charges for Services
1,646,027
927,002
0
(719,025)
(82,180)
0
(82,180)
377,711
377,711
0
2,023,738
1,222,533
0
(801,205)
393,318 1,364,265
327,935 1,372,500
8,220 0
57,163 (8,235)
263,682
263,682
0
0
5,300
5,300
0
0
2,026,565
1,969,417
8,220
48,928
(8,220)
(752,277)
Miscellaneous Revenue
0
Transfers From Other Funds TOTAL
REVENUE
0
EXPENDITURES Other Operating Expenses Debt Service Indirect Cost Transfers to Other Funds TOTAL
EXPENDITURES CURRENT YEAR
(2,827)
FUND BALANCE TRANSFERS
0
CARRYOVERS
0
CONTINGENCIES
0
RESERVE - PRIOR YEAR ENCUMBRANCES
2,827
BUDGET DIFFERENCE
0
30
(746,884)
CONSOLIDATED CITY OF JACKSONVILLE YEAR-END FINANCIAL SUMMARY - SUBFUND LEVEL FOR THE QUARTER ENDED SEPTEMBER 30, 2010 431 - MOTOR VEHICLE INSPECTION BALANCE SHEET INFORMATION ASSETS
LIABILITIES
Pooled Cash and Investments Taxes and other Receivable, Net
57,334.08 60,887.00
Inventories
Current Liabilities Other Liabilities
8,261.27
Capital Assets, Net
30,396.59 45,790.48
TOTAL LIABILITIES
33,423.59
76,187.07
FUND EQUITY Beginning of Year
63,010.76
Current Yr Less Encumbrances
20,708.11
TOTAL FUND EQUITY TOTAL ASSETS
159,905.94
83,718.87
TOTAL LIABILITIES FUND EQUITY
159,905.94
BUDGET INFORMATION REVISED BUDGET
Y-T-D ACTUAL
Y-T-D ENCUMB.
VARIANCE + Fav / - Unfav
REVENUE Charges for Services Miscellaneous Revenue TOTAL
REVENUE
449,481
431,028
0
(18,453)
3,500
5,895
0
2,395
452,981
436,923
0
(16,058)
263,482
EXPENDITURES 261,553
0
1,929
Lapse Employer Provided Benefits
Salaries
(7,958) 90,276
0 90,881
0 0
(7,958) (605)
Internal Service Charges
35,295
11,928
0
23,367
Other Operating Expenses Indirect Cost
43,079 90,731
17,506 90,731
2,205 0
23,369 0
514,905
472,598
2,205
40,103
(61,924)
(35,674)
(2,205)
24,045
TOTAL
EXPENDITURES CURRENT YEAR FUND BALANCE TRANSFERS
59,939
CARRYOVERS
0
CONTINGENCIES
0
RESERVE - PRIOR YEAR ENCUMBRANCES
1,985
BUDGET DIFFERENCE
0
31
CONSOLIDATED CITY OF JACKSONVILLE YEAR-END FINANCIAL SUMMARY - SUBFUND LEVEL FOR THE QUARTER ENDED SEPTEMBER 30, 2010 441 - SOLID WASTE DISPOSAL BALANCE SHEET INFORMATION ASSETS
LIABILITIES
Pooled Cash and Investments Taxes and other Receivable, Net
2,674,170.51 23,500,984.08
Due from Other Government Units Capital Assets, Net Other Deferred Charges
Current Liabilities Other Liabilities
23,834.70
8,280,916.39 37,238,257.82
TOTAL LIABILITIES
17,541,160.24 19,991,476.03
45,519,174.21
FUND EQUITY Beginning of Year
16,509,533.70
Current Yr Less Encumbrances
1,702,917.65
TOTAL FUND EQUITY TOTAL ASSETS
63,731,625.56
18,212,451.35
TOTAL LIABILITIES FUND EQUITY
63,731,625.56
BUDGET INFORMATION REVISED BUDGET
Y-T-D ACTUAL
Y-T-D ENCUMB.
VARIANCE + Fav / - Unfav
REVENUE Charges for Services Miscellaneous Revenue Transfers From Other Funds TOTAL
REVENUE
45,228,482
44,470,824
0
(757,658)
1,155,007
1,013,870
0
(141,137)
21,417,409
21,417,409
0
67,800,898
66,902,103
0
(898,795)
(1,577) (338,174)
0
EXPENDITURES Salaries Lapse
3,889,306 (338,174)
3,890,883 0
0 0
Employer Provided Benefits
2,006,511
2,020,050
0
(13,539)
Internal Service Charges Other Operating Expenses
3,714,269 58,873,545
4,107,711 52,536,629
0 4,191,500
(393,443) 2,145,416
Capital Outlay
2
0
0
2
Debt Service
5,555,560
5,131,411
0
424,149
Supervision Allocation Indirect Cost
(378,072) 1,388,761
(378,072) 1,388,761
0 0
0 0
750,000
750,000
0
0
75,461,708
69,447,373
4,191,500
1,822,834
(7,660,810)
(2,545,270)
(4,191,500)
Transfers to Other Funds TOTAL
EXPENDITURES CURRENT YEAR FUND BALANCE TRANSFERS
1,650,000
CARRYOVERS
0
CONTINGENCIES
0
RESERVE - PRIOR YEAR ENCUMBRANCES
6,010,810
BUDGET DIFFERENCE
0
32
924,039
CONSOLIDATED CITY OF JACKSONVILLE YEAR-END FINANCIAL SUMMARY - SUBFUND LEVEL FOR THE QUARTER ENDED SEPTEMBER 30, 2010 461 - STORMWATER SERVICES BALANCE SHEET INFORMATION ASSETS
LIABILITIES
Pooled Cash and Investments Taxes and other Receivable, Net
(13,702,115.42) 32,789,812.15
Current Liabilities Other Liabilities
1,099,461.84 7,587,895.00
TOTAL LIABILITIES
8,687,356.84
FUND EQUITY Beginning of Year
10,357,058.63
Current Yr Less Encumbrances
43,281.26
TOTAL FUND EQUITY TOTAL ASSETS
19,087,696.73
10,400,339.89
TOTAL LIABILITIES FUND EQUITY
19,087,696.73
BUDGET INFORMATION REVISED BUDGET
Y-T-D ACTUAL
Y-T-D ENCUMB.
VARIANCE + Fav / - Unfav
REVENUE Charges for Services
28,101,452
Miscellaneous Revenue
95,000
Transfers From Other Funds TOTAL
REVENUE
28,034,663 (268,500)
0
(66,789)
0
(363,500)
1,293,851
1,293,851
0
0
29,490,303
29,060,014
0
(430,289)
39,972 (200,465)
EXPENDITURES Salaries Lapse
6,464,741 (200,465)
6,424,769 0
0 0
Employer Provided Benefits
2,384,231
2,355,043
0
Internal Service Charges Other Operating Expenses
1,803,028 5,098,018
2,928,374 4,051,105
0 757,216
Capital Outlay Indirect Cost Transfers to Other Funds Banking Fund Debt Repayment TOTAL
EXPENDITURES CURRENT YEAR
1
0
0
1
1,138,296
1,138,296
0
0
12,119,145 1,507,898
12,119,145 0
0 0
0 1,507,898
30,314,893
29,016,733
757,216
540,945
(757,216)
110,655
(824,590)
FUND BALANCE TRANSFERS CARRYOVERS
29,188 (1,125,346) 289,697
0 (222,788)
CONTINGENCIES
0
RESERVE - PRIOR YEAR ENCUMBRANCES
1,047,378
BUDGET DIFFERENCE
0
33
43,281
CONSOLIDATED CITY OF JACKSONVILLE QUARTERLY FINANCIAL SUMMARY - FUND LEVEL FOR THE QUARTER ENDED SEPTEMBER 30, 2010 4A0 - MUNICIPAL STADIUM BALANCE SHEET INFORMATION ASSETS
LIABILITIES
Pooled Cash and Investments Taxes and other Receivable, Net Capital Assets, Net
8,630,773.00 297,532.77
Current Liabilities Other Liabilities
190,449,718.18
Other Deferred Charges
9,540,054.67 144,835,000.00
TOTAL LIABILITIES
30,116.81
154,375,054.67
FUND EQUITY Beginning of Year
46,375,584.30
Current Yr Less Encumbrances
(1,342,498.21)
TOTAL FUND EQUITY TOTAL ASSETS
199,408,140.76
45,033,086.09
TOTAL LIABILITIES FUND EQUITY
199,408,140.76
BUDGET INFORMATION REVISED BUDGET
Y-T-D ACTUAL
Y-T-D ENCUMB.
VARIANCE + Fav / - Unfav
REVENUE Taxes
6,766,136
6,560,692
0
(205,444)
Charges for Services
4,209,521
3,719,338
0
(490,183)
5,285,412 25,832,271
5,759,405 25,571,072
0 0
473,993 (261,199)
42,093,340
41,610,507
0
(482,833)
1,543,142
1,523,971
0
19,171
553,000
422,509
0
130,492
237,446 9,576,588
185,814 9,498,691
0 0
51,632 77,897
43,005
0
0
43,005
11,388,163 18,857,640
11,233,046 18,857,640
0 0
155,117 0
0
0
(62,639)
41,721,671
0
414,674
0
(68,159)
Miscellaneous Revenue Transfers From Other Funds TOTAL
REVENUE
EXPENDITURES Salaries Employer Provided Benefits Internal Service Charges Other Operating Expenses Capital Outlay Debt Service Transfers to Other Funds Extraordinary Lapse TOTAL
(62,639)
EXPENDITURES
42,136,345 CURRENT YEAR
(43,005)
FUND BALANCE TRANSFERS
0
CARRYOVERS
0
CONTINGENCIES
0
RESERVE - PRIOR YEAR ENCUMBRANCES
43,005
BUDGET DIFFERENCE
0
34
(111,164)
CONSOLIDATED CITY OF JACKSONVILLE QUARTERLY FINANCIAL SUMMARY - FUND LEVEL FOR THE QUARTER ENDED SEPTEMBER 30, 2010 4B0 - MEMORIAL ARENA BALANCE SHEET INFORMATION ASSETS
LIABILITIES
Pooled Cash and Investments Taxes and other Receivable, Net Capital Assets, Net
7,048,351.49 570,528.76
Current Liabilities Other Liabilities
108,422,562.22
Other Deferred Charges
6,855,429.97 107,556,582.86
TOTAL LIABILITIES
146,807.63
114,412,012.83
FUND EQUITY Beginning of Year
929,925.45
Current Yr Less Encumbrances
846,311.82
TOTAL FUND EQUITY TOTAL ASSETS
116,188,250.10
1,776,237.27
TOTAL LIABILITIES FUND EQUITY
116,188,250.10
BUDGET INFORMATION REVISED BUDGET
Y-T-D ACTUAL
Y-T-D ENCUMB.
VARIANCE + Fav / - Unfav
REVENUE Charges for Services
4,917,419
4,797,487
0
(119,932)
Miscellaneous Revenue
2,764,870
3,699,237
0
934,367
Other Sources Transfers From Other Funds
8,148,952 1,712,235
8,056,757 1,712,235
0 0
(92,195) 0
17,543,476
18,265,716
0
722,240
1,328,813
1,291,564
0
37,249
418,311
316,931
0
101,380
Internal Service Charges Other Operating Expenses
121,533 5,685,477
123,803 6,227,406
0 0
(2,270) (541,929)
Debt Service
8,148,952
8,124,255
0
24,697
Transfers to Other Funds Extraordinary Lapse
1,871,597 (31,207)
1,871,597 0
0 0
0 (31,207)
TOTAL
REVENUE
EXPENDITURES Salaries Employer Provided Benefits
TOTAL
EXPENDITURES
17,543,476
17,955,556
0
(412,080)
CURRENT YEAR
0
310,160
0
310,160
FUND BALANCE TRANSFERS
0
CARRYOVERS
0
CONTINGENCIES
0
RESERVE - PRIOR YEAR ENCUMBRANCES
0
BUDGET DIFFERENCE
0
35
CONSOLIDATED CITY OF JACKSONVILLE QUARTERLY FINANCIAL SUMMARY - FUND LEVEL FOR THE QUARTER ENDED SEPTEMBER 30, 2010 4C0 - BASEBALL STADIUM BALANCE SHEET INFORMATION ASSETS
LIABILITIES
Pooled Cash and Investments Taxes and other Receivable, Net Capital Assets, Net
1,684,438.10 14,033.68
Current Liabilities Other Liabilities
28,043,956.14
Other Deferred Charges
1,619,764.68 28,288,874.81
TOTAL LIABILITIES
6,129.49
29,908,639.49
FUND EQUITY Beginning of Year
(180,307.59)
Current Yr Less Encumbrances
20,225.51
TOTAL FUND EQUITY TOTAL ASSETS
29,748,557.41
(160,082.08)
TOTAL LIABILITIES FUND EQUITY
29,748,557.41
BUDGET INFORMATION REVISED BUDGET
Y-T-D ACTUAL
Y-T-D ENCUMB.
VARIANCE + Fav / - Unfav
REVENUE Charges for Services
398,495
425,878
0
27,383
Miscellaneous Revenue
168,973
226,159
0
57,186
2,153,069 1,181,198
2,128,709 1,018,904
0 0
(24,360) (162,294)
3,901,735
3,799,651
0
(102,084)
240,912
265,069
0
(24,157)
56,685
60,393
0
(3,708)
1,199 1,003,349
229 979,137
0 0
970 24,212
Other Sources Transfers From Other Funds TOTAL
REVENUE
EXPENDITURES Salaries Employer Provided Benefits Internal Service Charges Other Operating Expenses Capital Outlay Debt Service Transfers to Other Funds Extraordinary Lapse TOTAL
26,910
26,909
0
1
2,153,069 452,022
2,146,544 452,022
0 0
6,525 0
0
0
(5,502)
3,930,302
0
(1,659)
0
(103,743)
(5,502)
EXPENDITURES
3,928,644 CURRENT YEAR
(26,909)
FUND BALANCE TRANSFERS
0
CARRYOVERS
0
CONTINGENCIES
0
RESERVE - PRIOR YEAR ENCUMBRANCES
26,909
BUDGET DIFFERENCE
0
36
(130,651)
CONSOLIDATED CITY OF JACKSONVILLE QUARTERLY FINANCIAL SUMMARY - FUND LEVEL FOR THE QUARTER ENDED SEPTEMBER 30, 2010 4D0 - PERFORMING ARTS CENTER BALANCE SHEET INFORMATION ASSETS
LIABILITIES
Pooled Cash and Investments Taxes and other Receivable, Net Capital Assets, Net
(95,911.42) 43,134.69
Current Liabilities Other Liabilities
24,478,644.71
Other Deferred Charges
993,367.10 1,012,283.00
TOTAL LIABILITIES
8,528.02
2,005,650.10
FUND EQUITY Beginning of Year
23,360,182.86
Current Yr Less Encumbrances
(931,436.96)
TOTAL FUND EQUITY TOTAL ASSETS
24,434,396.00
22,428,745.90
TOTAL LIABILITIES FUND EQUITY
24,434,396.00
BUDGET INFORMATION REVISED BUDGET
Y-T-D ACTUAL
Y-T-D ENCUMB.
VARIANCE + Fav / - Unfav
REVENUE Charges for Services Miscellaneous Revenue Other Sources Transfers From Other Funds TOTAL
REVENUE
1,938,898
1,759,608
0
(179,290)
597,086
543,109
0
(53,977)
51,568 1,384,452
51,312 1,384,452
0 0
(256) 0
3,972,004
3,738,480
0
(233,524)
EXPENDITURES Salaries
627,328
631,356
0
(4,028)
Employer Provided Benefits
156,200
149,317
0
6,883
44,789 2,658,873
44,966 2,540,262
0 0
Internal Service Charges Other Operating Expenses Capital Outlay
(177) 118,611
5,420
5,419
0
Debt Service Transfers to Other Funds
51,568 447,839
94,545 447,839
0 0
(42,977) 0
Extraordinary Lapse
(14,594)
0
0
(14,594)
3,913,705
0
63,718
0
(169,806)
TOTAL
EXPENDITURES
3,977,423 CURRENT YEAR
(5,419)
FUND BALANCE TRANSFERS
0
CARRYOVERS
0
CONTINGENCIES
0
RESERVE - PRIOR YEAR ENCUMBRANCES
5,419
BUDGET DIFFERENCE
0
37
(175,225)
1
CONSOLIDATED CITY OF JACKSONVILLE QUARTERLY FINANCIAL SUMMARY - FUND LEVEL FOR THE QUARTER ENDED SEPTEMBER 30, 2010 4E0 - CONVENTION CENTER BALANCE SHEET INFORMATION ASSETS
LIABILITIES
Pooled Cash and Investments Taxes and other Receivable, Net Capital Assets, Net
929,135.99 24,835.56
Current Liabilities Other Liabilities
18,675,593.41
Other Deferred Charges
549,653.29 .42
TOTAL LIABILITIES
6,174.78
549,653.71
FUND EQUITY Beginning of Year
19,728,850.38
Current Yr Less Encumbrances
(642,764.35)
TOTAL FUND EQUITY TOTAL ASSETS
19,635,739.74
19,086,086.03
TOTAL LIABILITIES FUND EQUITY
19,635,739.74
BUDGET INFORMATION REVISED BUDGET
Y-T-D ACTUAL
Y-T-D ENCUMB.
VARIANCE + Fav / - Unfav
REVENUE Taxes
4,503,995
4,238,095
0
(265,900)
Charges for Services
945,862
794,644
0
(151,218)
Miscellaneous Revenue Transfers From Other Funds
963,650 800,892
933,311 800,892
0 0
(30,339) 0
7,214,399
6,766,942
0
(447,457)
TOTAL
REVENUE
EXPENDITURES Salaries Employer Provided Benefits Internal Service Charges Other Operating Expenses Capital Outlay Debt Service Transfers to Other Funds Extraordinary Lapse TOTAL
1,021,863
982,963
0
38,900
305,000
280,170
0
24,830
85,066 1,904,994
86,478 1,761,737
0 0
(1,412) 143,256
10,954
10,875
0
0 4,073,403
15,581 3,649,910
0 0
(15,581) 423,493
0
0
(16,223)
6,787,714
0
597,342
0
149,885
(16,223)
EXPENDITURES
7,385,056 CURRENT YEAR
(170,657)
FUND BALANCE TRANSFERS
157,729
CARRYOVERS
0
CONTINGENCIES
0
RESERVE - PRIOR YEAR ENCUMBRANCES
12,928
BUDGET DIFFERENCE
0
38
(20,772)
79
CONSOLIDATED CITY OF JACKSONVILLE QUARTERLY FINANCIAL SUMMARY - FUND LEVEL FOR THE QUARTER ENDED SEPTEMBER 30, 2010 4F0 - EQUESTRIAN CENTER BALANCE SHEET INFORMATION ASSETS
LIABILITIES
Pooled Cash and Investments Taxes and other Receivable, Net Capital Assets, Net
(394,090.73) 25,386.04
Current Liabilities Other Liabilities
13,738,547.31
Other Deferred Charges
139,700.79 2,491,805.26
TOTAL LIABILITIES
1,941.19
2,631,506.05
FUND EQUITY Beginning of Year
11,516,831.44
Current Yr Less Encumbrances
(776,553.68)
TOTAL FUND EQUITY TOTAL ASSETS
13,371,783.81
10,740,277.76
TOTAL LIABILITIES FUND EQUITY
13,371,783.81
BUDGET INFORMATION REVISED BUDGET
Y-T-D ACTUAL
Y-T-D ENCUMB.
VARIANCE + Fav / - Unfav
REVENUE Charges for Services
387,522
203,077
0
(184,445)
Miscellaneous Revenue
194,130
77,464
0
(116,666)
143,393 1,078,090
122,518 1,078,090
0 0
(20,875) 0
1,803,135
1,481,149
0
(321,986)
Other Sources Transfers From Other Funds TOTAL
REVENUE
EXPENDITURES Salaries
342,984
267,452
0
75,532
Employer Provided Benefits
97,000
65,324
0
31,676
Internal Service Charges Other Operating Expenses
62,866 806,661
44,086 571,333
0 0
18,780 235,328
Capital Outlay
(37,584)
Debt Service Transfers to Other Funds
143,393 401,555
Extraordinary Lapse
(51,325)
EXPENDITURES
0
0
(51,325)
0
(3,134)
1,765,550
1,552,649
0
212,901
0
(109,085)
37,585
FUND BALANCE TRANSFERS
0
CARRYOVERS
0
CONTINGENCIES
0
BUDGET DIFFERENCE
(43,004) (50,952) 0
3,134
CURRENT YEAR
RESERVE - PRIOR YEAR ENCUMBRANCES
0 0 0
0
Fiscal and Other Debt Fees TOTAL
5,419 194,345 401,555
(37,585) 0
39
(71,500)
CONSOLIDATED CITY OF JACKSONVILLE YEAR-END FINANCIAL SUMMARY - SUBFUND LEVEL FOR THE QUARTER ENDED SEPTEMBER 30, 2010 511 - FLEET MGMT - OPERATIONS BALANCE SHEET INFORMATION ASSETS
LIABILITIES
Pooled Cash and Investments Taxes and other Receivable, Net
(172,321.15) 435.69
Due from Other Government Units
1,036,406.28
Inventories Capital Assets, Net
1,489,641.84 1,226,154.23
Current Liabilities Other Liabilities
2,342,254.69 1,203,111.65
TOTAL LIABILITIES
3,545,366.34
FUND EQUITY Beginning of Year
(470,570.27)
Current Yr Less Encumbrances
505,520.82
TOTAL FUND EQUITY TOTAL ASSETS
3,580,316.89
34,950.55
TOTAL LIABILITIES FUND EQUITY
3,580,316.89
BUDGET INFORMATION REVISED BUDGET
Y-T-D ACTUAL
Y-T-D ENCUMB.
VARIANCE + Fav / - Unfav
REVENUE 37,254,502
36,658,474
0
(596,028)
Miscellaneous Revenue
Charges for Services
526,171
281,141
0
(245,030)
Other Sources
367,450
367,450
0
38,148,123
37,307,064
0
(841,059)
324,930 (184,015)
TOTAL
REVENUE
0
EXPENDITURES Salaries Lapse
5,442,102 (184,015)
5,117,172 0
0 0
Employer Provided Benefits
1,946,701
1,892,195
0
Internal Service Charges Other Operating Expenses
925,259 28,285,414
1,228,431 26,870,111
0 1,173,123
434,443
434,440
0
3
0
0
0
0
1,446,857 98,813
1,446,857 18,584
0 0
0 80,229
38,395,574
37,007,790
1,173,123
214,661
(1,173,123)
(626,398)
Capital Outlay Supervision Allocation Indirect Cost Banking Fund Debt Repayment TOTAL
EXPENDITURES CURRENT YEAR
(247,451)
FUND BALANCE TRANSFERS
0
CARRYOVERS
0
CONTINGENCIES
0
RESERVE - PRIOR YEAR ENCUMBRANCES
247,451
BUDGET DIFFERENCE
0
40
299,274
54,506 (303,173) 242,180
CONSOLIDATED CITY OF JACKSONVILLE YEAR-END FINANCIAL SUMMARY - SUBFUND LEVEL FOR THE QUARTER ENDED SEPTEMBER 30, 2010 512 - FLEET MGMT - VEHICLE REPLACEMENT BALANCE SHEET INFORMATION ASSETS
LIABILITIES
Pooled Cash and Investments Due from Other Government Units Capital Assets, Net
7,082,894.62 1,429.52
Current Liabilities Other Liabilities
34,636,447.55
7,014,104.63 13,889,238.10
TOTAL LIABILITIES
20,903,342.73
FUND EQUITY Beginning of Year
18,477,619.00
Current Yr Less Encumbrances
2,339,809.96
TOTAL FUND EQUITY TOTAL ASSETS
41,720,771.69
20,817,428.96
TOTAL LIABILITIES FUND EQUITY
41,720,771.69
BUDGET INFORMATION REVISED BUDGET
Y-T-D ACTUAL
Y-T-D ENCUMB.
VARIANCE + Fav / - Unfav
REVENUE Charges for Services Miscellaneous Revenue Other Sources TOTAL
REVENUE
16,854,402
16,708,393
0
275,000
1,635,962
0
1,360,962
(146,009)
5,491,170
3,629,307
0
(1,861,863)
22,620,572
21,973,662
0
(646,910)
143,318 (4,796)
171,786 0
0 0
(28,468) (4,796)
42,893
44,058
0
(1,165)
46,791 5,438,149
36,516 3,636,246
2,500 0
EXPENDITURES Salaries Lapse Employer Provided Benefits Other Operating Expenses Capital Outlay Transfers to Other Funds Banking Fund Debt Repayment TOTAL
EXPENDITURES CURRENT YEAR
3,079,838
3,079,838
0
13,593,392
13,882,904
0
22,339,585
20,851,347
2,500
280,987
1,122,314
(2,500)
FUND BALANCE TRANSFERS CARRYOVERS
0 (280,987)
CONTINGENCIES
0
RESERVE - PRIOR YEAR ENCUMBRANCES
0
BUDGET DIFFERENCE
0
41
7,775 1,801,903 0 (289,512) 1,485,738 838,827
CONSOLIDATED CITY OF JACKSONVILLE YEAR-END FINANCIAL SUMMARY - SUBFUND LEVEL FOR THE QUARTER ENDED SEPTEMBER 30, 2010 521 - COPY CENTER BALANCE SHEET INFORMATION ASSETS
LIABILITIES
Pooled Cash and Investments Taxes and other Receivable, Net
(11,056.32) 1,588.55
Due from Other Government Units Capital Assets, Net
Current Liabilities Other Liabilities
(1,532.55)
85,756.47 51,612.86
TOTAL LIABILITIES
4,349.77
137,369.33
FUND EQUITY Beginning of Year
(431,556.96)
Current Yr Less Encumbrances
287,537.08
TOTAL FUND EQUITY TOTAL ASSETS
(6,650.55)
(144,019.88)
TOTAL LIABILITIES FUND EQUITY
(6,650.55)
BUDGET INFORMATION REVISED BUDGET
Y-T-D ACTUAL
Y-T-D ENCUMB.
VARIANCE + Fav / - Unfav
REVENUE Charges for Services
2,083,803
Miscellaneous Revenue TOTAL
0
REVENUE
2,149,044 (40,705)
0
65,241
0
(40,705) 24,536
2,083,803
2,108,339
0
Salaries
306,246
295,590
0
10,656
Lapse Employer Provided Benefits
(11,701) 96,955
0 89,504
0 0
(11,701) 7,451
EXPENDITURES
Internal Service Charges Other Operating Expenses Capital Outlay
25,458
21,259
0
4,199
1,558,825 1
1,224,358 0
95,823 0
238,645 1
Supervision Allocation Indirect Cost TOTAL
EXPENDITURES CURRENT YEAR
0
0
0
0
118,230
118,230
0
0
2,094,014
1,748,941
95,823
249,250
(95,823)
273,786
(10,211)
FUND BALANCE TRANSFERS
0
CARRYOVERS
0
CONTINGENCIES
0
RESERVE - PRIOR YEAR ENCUMBRANCES
10,211
BUDGET DIFFERENCE
0
42
359,398
CONSOLIDATED CITY OF JACKSONVILLE YEAR-END FINANCIAL SUMMARY - SUBFUND LEVEL FOR THE QUARTER ENDED SEPTEMBER 30, 2010 531 - ITD OPERATIONS BALANCE SHEET INFORMATION ASSETS
LIABILITIES
Pooled Cash and Investments Due from Other Government Units Capital Assets, Net
(510,586.74) 47,498.73
Current Liabilities Other Liabilities
17,722,071.80
2,950,075.24 1,430,771.41
TOTAL LIABILITIES
4,380,846.65
FUND EQUITY Beginning of Year
11,187,658.10
Current Yr Less Encumbrances
1,690,479.04
TOTAL FUND EQUITY TOTAL ASSETS
17,258,983.79
12,878,137.14
TOTAL LIABILITIES FUND EQUITY
17,258,983.79
BUDGET INFORMATION REVISED BUDGET
Y-T-D ACTUAL
Y-T-D ENCUMB.
VARIANCE + Fav / - Unfav
REVENUE Charges for Services
25,498,536
Miscellaneous Revenue Other Sources Transfers From Other Funds TOTAL
0
860,519
(203,016)
0
(204,616)
76,210 687,917
13,638 500,000
0 0
(62,572) (187,917)
26,264,263
26,669,677
0
405,414
11,157,213
11,092,058
0
65,155
0
0
(547,863) (75,555) (451,047)
1,600
REVENUE
26,359,055
EXPENDITURES Salaries Lapse
(547,863)
Employer Provided Benefits Internal Service Charges
2,900,739 1,752,428
2,976,294 2,203,475
0 0
Other Operating Expenses
10,178,306
8,415,329
1,578,727
184,251
95,809
28,767
62,572
4,470
1,200,844 731,488
1,200,844 510,286
0 0
0 221,202
27,468,964
26,427,054
1,641,299
(599,388)
(1,641,299)
(193,974)
Capital Outlay Indirect Cost Banking Fund Debt Repayment TOTAL
EXPENDITURES CURRENT YEAR
(1,204,701)
FUND BALANCE TRANSFERS
0
CARRYOVERS
0
CONTINGENCIES
0
RESERVE - PRIOR YEAR ENCUMBRANCES
1,204,701
BUDGET DIFFERENCE
0
43
242,623
CONSOLIDATED CITY OF JACKSONVILLE YEAR-END FINANCIAL SUMMARY - SUBFUND LEVEL FOR THE QUARTER ENDED SEPTEMBER 30, 2010 533 - COMMUNICATIONS BALANCE SHEET INFORMATION ASSETS
LIABILITIES
Pooled Cash and Investments Due from Other Government Units
653,434.56 112.57
Inventories
515,783.71
Capital Assets, Net
Current Liabilities Other Liabilities
460,755.79 41,084.18
TOTAL LIABILITIES
90,737.46
501,839.97
FUND EQUITY Beginning of Year
479,185.44
Current Yr Less Encumbrances
279,042.89
TOTAL FUND EQUITY TOTAL ASSETS
1,260,068.30
758,228.33
TOTAL LIABILITIES FUND EQUITY
1,260,068.30
BUDGET INFORMATION REVISED BUDGET
Y-T-D ACTUAL
Y-T-D ENCUMB.
VARIANCE + Fav / - Unfav
REVENUE Charges for Services Miscellaneous Revenue Transfers From Other Funds TOTAL
REVENUE
7,192,164
7,183,925
0
(8,240)
52,035
30,877
0
(21,158)
480
480
0
7,244,679
7,215,282
0
(29,397)
(13,329) (15,275)
0
EXPENDITURES Salaries Lapse
408,338 (15,275)
421,667 0
0 0
Employer Provided Benefits
115,349
116,226
0
281,770 6,611,187
280,647 5,936,771
0 625,197
Internal Service Charges Other Operating Expenses Capital Outlay Indirect Cost TOTAL
EXPENDITURES CURRENT YEAR
(877) 1,124 49,219
1
0
0
1
90,401
90,401
0
0
7,491,771
6,845,712
625,197
20,863
(625,197)
(8,534)
(247,092)
FUND BALANCE TRANSFERS
0
CARRYOVERS
0
CONTINGENCIES
0
RESERVE - PRIOR YEAR ENCUMBRANCES
247,092
BUDGET DIFFERENCE
0
44
369,570
CONSOLIDATED CITY OF JACKSONVILLE YEAR-END FINANCIAL SUMMARY - SUBFUND LEVEL FOR THE QUARTER ENDED SEPTEMBER 30, 2010 534 - RADIO COMMUNICATIONS BALANCE SHEET INFORMATION ASSETS
LIABILITIES
Pooled Cash and Investments Due from Other Government Units Capital Assets, Net
3,704,071.11 17,436.17
Current Liabilities Other Liabilities
583,205.66
347,775.76 193,393.13
TOTAL LIABILITIES
541,168.89
FUND EQUITY Beginning of Year
67,886.63
Current Yr Less Encumbrances
3,695,657.42
TOTAL FUND EQUITY TOTAL ASSETS
4,304,712.94
3,763,544.05
TOTAL LIABILITIES FUND EQUITY
4,304,712.94
BUDGET INFORMATION REVISED BUDGET
Y-T-D ACTUAL
Y-T-D ENCUMB.
VARIANCE + Fav / - Unfav
REVENUE Charges for Services
7,280,636
6,460,098
0
(820,538)
0
133,459
0
133,459
188,120
158,558
0
(29,561)
7,468,756
6,752,116
0
(716,639)
20,539 (29,318)
Miscellaneous Revenue Other Sources TOTAL
REVENUE
EXPENDITURES Salaries Lapse
729,037 (29,318)
708,498 0
0 0
Employer Provided Benefits
198,941
200,571
0
192,443 2,199,035
178,555 1,771,441
0 157,090
13,888 270,505
190,341
160,778
0
29,562
83,333
83,333
0
0
4,139,027
224,599
0
3,914,428
7,702,839
3,327,775
157,090
4,217,974
3,424,341
(157,090)
3,501,335
Internal Service Charges Other Operating Expenses Capital Outlay Indirect Cost Banking Fund Debt Repayment TOTAL
EXPENDITURES CURRENT YEAR
(234,083)
FUND BALANCE TRANSFERS
0
CARRYOVERS
0
CONTINGENCIES
0
RESERVE - PRIOR YEAR ENCUMBRANCES
234,083
BUDGET DIFFERENCE
0
45
(1,630)
CONSOLIDATED CITY OF JACKSONVILLE YEAR-END FINANCIAL SUMMARY - SUBFUND LEVEL FOR THE QUARTER ENDED SEPTEMBER 30, 2010 536 - TECH SYSTEM DEVELOPMENT BALANCE SHEET INFORMATION ASSETS
LIABILITIES
Pooled Cash and Investments Capital Assets, Net
4,481,823.60 6,390,966.66
Current Liabilities Other Liabilities
188,355.02 6,256,452.03
TOTAL LIABILITIES
6,444,807.05
FUND EQUITY Beginning of Year
2,293,122.40
Current Yr Less Encumbrances
2,134,860.81
TOTAL FUND EQUITY TOTAL ASSETS
10,872,790.26
4,427,983.21
TOTAL LIABILITIES FUND EQUITY
10,872,790.26
BUDGET INFORMATION REVISED BUDGET
Y-T-D ACTUAL
Y-T-D ENCUMB.
VARIANCE + Fav / - Unfav
REVENUE Charges for Services
4,517,984
4,169,237
0
0
41,395
0
3,042,826
1,502,071
0
(1,540,755)
7,560,810
5,712,704
0
(1,848,106)
375,595 96,276
12,049 14,520
0 0
Miscellaneous Revenue Other Sources TOTAL
REVENUE
(348,747) 41,395
EXPENDITURES Salaries Employer Provided Benefits
363,546 81,756
Other Operating Expenses
1,042,558
800,133
45,326
197,098
Capital Outlay Banking Fund Debt Repayment
2,707,362 3,524,513
1,202,178 1,780,112
34,162 0
1,471,022 1,744,401
7,746,303
3,808,993
79,488
3,857,822
1,903,710
(79,488)
2,009,715
TOTAL
EXPENDITURES CURRENT YEAR
(185,493)
FUND BALANCE TRANSFERS
0
CARRYOVERS
0
CONTINGENCIES
0
RESERVE - PRIOR YEAR ENCUMBRANCES
185,493
BUDGET DIFFERENCE
0
46
CONSOLIDATED CITY OF JACKSONVILLE YEAR-END FINANCIAL SUMMARY - SUBFUND LEVEL FOR THE QUARTER ENDED SEPTEMBER 30, 2010 551 - OFFICE OF GENERAL COUNSEL BALANCE SHEET INFORMATION ASSETS
LIABILITIES
Pooled Cash and Investments Due from Other Government Units
3,386,860.63 465,337.11
Capital Assets, Net
Current Liabilities Other Liabilities
9,908.16
671,167.34 747,791.34
TOTAL LIABILITIES
1,418,958.68
FUND EQUITY Beginning of Year
663,919.49
Current Yr Less Encumbrances
1,779,227.73
TOTAL FUND EQUITY TOTAL ASSETS
3,862,105.90
2,443,147.22
TOTAL LIABILITIES FUND EQUITY
3,862,105.90
BUDGET INFORMATION REVISED BUDGET
Y-T-D ACTUAL
Y-T-D ENCUMB.
VARIANCE + Fav / - Unfav
REVENUE Charges for Services Miscellaneous Revenue Transfers From Other Funds TOTAL
REVENUE
9,275,075
9,885,436
0
610,361
69,212
166,901
0
97,689
750,000
750,000
0
0
10,094,287
10,802,338
0
708,051
EXPENDITURES Salaries Lapse
6,131,636 (298,065)
5,792,416 0
0 0
339,220 (298,065)
Employer Provided Benefits
1,534,499
1,450,180
0
84,319
Internal Service Charges Other Operating Expenses
637,018 2,402,475
538,581 1,506,355
0 765,156
98,437 130,964
Capital Outlay Indirect Cost TOTAL
EXPENDITURES CURRENT YEAR
1
0
0
1
420,824
420,824
0
0
10,828,388
9,708,357
765,156
354,876
1,093,981
(765,156)
(734,101)
FUND BALANCE TRANSFERS
688,802
CARRYOVERS
0
CONTINGENCIES
0
RESERVE - PRIOR YEAR ENCUMBRANCES
45,299
BUDGET DIFFERENCE
0
47
1,062,927
CONSOLIDATED CITY OF JACKSONVILLE YEAR-END FINANCIAL SUMMARY - SUBFUND LEVEL FOR THE QUARTER ENDED SEPTEMBER 30, 2010 561 - SELF INSURANCE BALANCE SHEET INFORMATION ASSETS
LIABILITIES
Pooled Cash and Investments Taxes and other Receivable, Net Due from Other Government Units Other Current Assets Other Non Current Assets
70,148,175.11 1,552,501.49
Current Liabilities Other Liabilities
7,859,620.70
Insurance Reserves
434,623.66 13,893,539.16
Capital Assets, Net
134,519.92 69,847.31 83,656,761.00
TOTAL LIABILITIES
83,861,128.23
FUND EQUITY
66,844.16
Beginning of Year
55,698.72
Current Yr Less Encumbrances
10,038,477.33
TOTAL FUND EQUITY TOTAL ASSETS
93,955,304.28
10,094,176.05
TOTAL LIABILITIES FUND EQUITY
93,955,304.28
BUDGET INFORMATION REVISED BUDGET
Y-T-D ACTUAL
Y-T-D ENCUMB.
VARIANCE + Fav / - Unfav
REVENUE Charges for Services Miscellaneous Revenue Other Sources TOTAL
REVENUE
25,395,189
25,911,440
0
516,251
4,471,855 0
4,974,224 1,071,608
0 0
502,369 1,071,608
29,867,044
31,957,271
0
2,090,227
1,031,978
945,553
0
86,425
0
0
(37,985) (2,241) (15,421)
EXPENDITURES Salaries Lapse
(37,985)
Employer Provided Benefits Internal Service Charges
264,705 1,114,966
266,946 1,130,387
0 0
Other Operating Expenses
30,324,818
22,078,543
723,944
1
0
0
1
574,130 556,210
574,130 556,210
0 0
0 0
7,032,064
7,032,064
0
0
40,860,887
32,583,835
723,944
7,553,108
(723,944)
9,643,336
Capital Outlay Supervision Allocation Indirect Cost Transfers to Other Funds TOTAL
EXPENDITURES CURRENT YEAR
(10,993,843)
FUND BALANCE TRANSFERS
10,686,739
CARRYOVERS
0
CONTINGENCIES
0
RESERVE - PRIOR YEAR ENCUMBRANCES
307,104
BUDGET DIFFERENCE
0
48
(626,563)
7,522,330
CONSOLIDATED CITY OF JACKSONVILLE YEAR-END FINANCIAL SUMMARY - SUBFUND LEVEL FOR THE QUARTER ENDED SEPTEMBER 30, 2010 571 - GROUP HEALTH BALANCE SHEET INFORMATION ASSETS
LIABILITIES
Pooled Cash and Investments Taxes and other Receivable, Net
3,303,466.59 150,000.00
Capital Assets, Net
Current Liabilities Other Liabilities
19,957.83
93,433.52 121,358.30
Insurance Reserves
17,500.00
TOTAL LIABILITIES
232,291.82
FUND EQUITY Beginning of Year
1,934,149.46
Current Yr Less Encumbrances
1,306,983.14
TOTAL FUND EQUITY TOTAL ASSETS
3,473,424.42
3,241,132.60
TOTAL LIABILITIES FUND EQUITY
3,473,424.42
BUDGET INFORMATION REVISED BUDGET
Y-T-D ACTUAL
Y-T-D ENCUMB.
VARIANCE + Fav / - Unfav
REVENUE Charges for Services Miscellaneous Revenue TOTAL
REVENUE
87,311,943
87,043,866
0
(268,077)
187,733
776,228
0
588,495
87,499,676
87,820,095
0
320,419
0 0
58,252 (60,456)
EXPENDITURES Salaries Lapse
692,210 (60,456)
633,958 0
Employer Provided Benefits
183,383
173,447
0
144,354 86,252,005
230,620 85,298,516
0 196,078
Internal Service Charges Other Operating Expenses Capital Outlay Indirect Cost TOTAL
EXPENDITURES CURRENT YEAR
51,416
51,415
0
1
144,705
144,705
0
0
87,407,616
86,532,661
196,078
678,876
92,060
1,287,433
(196,078)
999,295
FUND BALANCE TRANSFERS CARRYOVERS
9,936 (86,266) 757,410
0 (292,187)
CONTINGENCIES
0
RESERVE - PRIOR YEAR ENCUMBRANCES
200,127
BUDGET DIFFERENCE
0
49
CONSOLIDATED CITY OF JACKSONVILLE YEAR-END FINANCIAL SUMMARY - SUBFUND LEVEL FOR THE QUARTER ENDED SEPTEMBER 30, 2010 581 - INSURED PROGRAMS BALANCE SHEET INFORMATION ASSETS
LIABILITIES
Pooled Cash and Investments Capital Assets, Net
6,368,453.90 5,823.59
Other Deferred Charges
2,357,698.95
Current Liabilities Other Liabilities
41,538.05 2,410,607.07
TOTAL LIABILITIES
2,452,145.12
FUND EQUITY Beginning of Year
3,833,681.87
Current Yr Less Encumbrances
2,446,149.45
TOTAL FUND EQUITY TOTAL ASSETS
8,731,976.44
6,279,831.32
TOTAL LIABILITIES FUND EQUITY
8,731,976.44
BUDGET INFORMATION REVISED BUDGET
Y-T-D ACTUAL
Y-T-D ENCUMB.
VARIANCE + Fav / - Unfav
REVENUE Charges for Services
7,708,580
8,293,360
0
584,780
290,307
590,828
0
300,521
7,998,887
8,884,188
0
885,301
Salaries
336,370
327,047
0
9,323
Lapse Employer Provided Benefits
(20,272) 84,166
0 83,133
0 0
(20,272) 1,033
Miscellaneous Revenue TOTAL
REVENUE
EXPENDITURES
Internal Service Charges Other Operating Expenses Capital Outlay Supervision Allocation Indirect Cost Transfers to Other Funds TOTAL
EXPENDITURES CURRENT YEAR
220,707
199,660
0
21,047
10,031,928 1
7,886,729 0
578,008 0
1,567,191 1
(574,130)
(574,130)
0
0
83,627
83,627
0
0
400,000
400,000
0
0
10,562,397
8,406,066
578,008
1,578,323
(578,008)
2,463,624
(2,563,510)
FUND BALANCE TRANSFERS
1,969,164
CARRYOVERS
0
CONTINGENCIES
0
RESERVE - PRIOR YEAR ENCUMBRANCES
594,346
BUDGET DIFFERENCE
0
50
478,122
CONSOLIDATED CITY OF JACKSONVILLE YEAR-END FINANCIAL SUMMARY - SUBFUND LEVEL FOR THE QUARTER ENDED SEPTEMBER 30, 2010 721 - JACKSONVILLE HOUSING FINANCE AUTHORITY BALANCE SHEET INFORMATION ASSETS
LIABILITIES
Pooled Cash and Investments Taxes and other Receivable, Net Other Deferred Charges
2,709,608.82 7,507,890.30
Current Liabilities
13,928.88
TOTAL LIABILITIES
329,107.18
13,928.88
FUND EQUITY Beginning of Year Current Yr Less Encumbrances
8,363,397.21 2,169,280.21 10,532,677.42
TOTAL FUND EQUITY TOTAL ASSETS
10,546,606.30
TOTAL LIABILITIES FUND EQUITY
10,546,606.30
BUDGET INFORMATION REVISED BUDGET
Y-T-D ACTUAL
Y-T-D ENCUMB.
VARIANCE + Fav / - Unfav
REVENUE Miscellaneous Revenue
209,422
343,817
0
134,395
Other Sources
256,000
1,018,221
0
762,221
465,422
1,362,038
0
896,616
217,445
206,010
0
11,435
0
0
(6,716) 40,237 (21,205)
TOTAL
REVENUE
EXPENDITURES Salaries Lapse
(6,716)
Employer Provided Benefits Internal Service Charges
88,606 14,089
48,369 35,294
0 0
Other Operating Expenses
325,980
239,475
59,123
27,382
Capital Outlay Supervision Allocation
1 134,167
0 0
0 0
1 134,167 (28,195)
Indirect Cost Other TOTAL
EXPENDITURES CURRENT YEAR FUND BALANCE TRANSFERS CARRYOVERS
0
28,195
0
1,036,975
1,036,975
0
0
1,810,547
1,594,319
59,123
157,105
(1,345,125) 1,301,561 (3,664)
CONTINGENCIES
0
RESERVE - PRIOR YEAR ENCUMBRANCES
47,228
BUDGET DIFFERENCE
0
51
(232,281)
(59,123)
1,053,722
CONSOLIDATED CITY OF JACKSONVILLE YEAR-END FINANCIAL SUMMARY - SUBFUND LEVEL FOR THE QUARTER ENDED SEPTEMBER 30, 2010 751 - JACKSONVILLE ECONOMIC DEVELOPMENT COMM BALANCE SHEET INFORMATION ASSETS
LIABILITIES
Pooled Cash and Investments
3,453,512.10
Current Liabilities
1,039,394.43
TOTAL LIABILITIES
1,039,394.43
FUND EQUITY Beginning of Year Current Yr Less Encumbrances
1,296,293.32 1,117,824.35 2,414,117.67
TOTAL FUND EQUITY TOTAL ASSETS
3,453,512.10
TOTAL LIABILITIES FUND EQUITY
3,453,512.10
BUDGET INFORMATION REVISED BUDGET
Y-T-D ACTUAL
Y-T-D ENCUMB.
VARIANCE + Fav / - Unfav
REVENUE Miscellaneous Revenue Transfers From Component Units TOTAL
REVENUE
246,776
420,717
0
173,941
9,692,005
9,692,005
0
0
9,938,781
10,112,722
0
173,941
1,256,948
1,230,416
0
26,532
0
0
(111,549)
311,074 587,433
317,075 779,396
0 0
(6,001) (191,963)
6,802,622
5,429,943
361,400
2 228,660
0 199,799
0 47,911
EXPENDITURES Salaries Lapse
(111,549)
Employer Provided Benefits Internal Service Charges Other Operating Expenses Capital Outlay Grants and Aids Indirect Cost Transfers to Other Funds Banking Fund Debt Repayment TOTAL
EXPENDITURES CURRENT YEAR
1,011,279 2 (19,050)
147,719
147,719
0
1,328,533
1,328,533
0
0
223,021
209,824
0
13,197
10,774,463
9,642,705
409,310
722,448
(409,310)
896,389
(835,682)
FUND BALANCE TRANSFERS
647,807
CARRYOVERS
0
CONTINGENCIES
0
RESERVE - PRIOR YEAR ENCUMBRANCES
187,875
BUDGET DIFFERENCE
0
52
470,017
0
JEA QUARTERLY FINANCIAL SUMMARY - ELECTRIC SYSTEM September 30, 2010 ASSETS: Cash and Investments Other Current Assets Fixed and Other Assets TOTAL ASSETS
LIABILITIES & EQUITY $
$
209,328,000 254,937,000 3,578,909,000 4,043,174,000
Current Liabilities Other Liabilities Fund Equity (Net Assets) TOTAL LIABILITIES & EQUITY
FUEL RELATED REVENUES & EXPENSES: Revised Budget
FUEL REVENUES Transfer (To)/From Fuel Recovery Total Net Revenues
$
585,794,765 (38,469,312) 547,325,453
FUEL EXPENSES: Fuel & Purchased Power (1)
$
547,325,453
SURPLUS/(DEFICIT)
$
NON-FUEL REVENUES/TRANSFERS: Base Rate Revenues Environmental Charge Revenue Conservation Fund Investment Income Other Revenues Recovery Fund Carry-Over Transfer (To)/From Fuel Recovery Total Non Fuel Revenues
$
As of 12 months Actual
$
$
NON-FUEL EXPENSES: Operating and Maintenance Environmental Conservation & Demand-side Management Non-Fuel Purchased Power Non-Fuel Uncollectibles & PSC Tax Debt Service City Contribution Expense Contingencies & Working Capital Renewal and Replacement Fund Operating Capital Outlay Emergency Reserve Total Non-Fuel Expenses
$
SURPLUS/(DEFICIT)
$
TOTAL REVENUES TOTAL APPROPRIATIONS
$ $
$
-
$ $
575,426,836 (37,783,023) 537,643,813
$
537,643,813
$
714,147,840 8,224,474 1,200,000 2,521,906 79,067,626 38,469,312 843,631,158
150,424,670 8,083,832 8,250,329 171,864,018 5,913,959 235,491,830 79,007,260 51,280,554 66,918,307 61,396,399 5,000,000 843,631,158 1,390,956,611 1,390,956,611
$
$
$
-
707,283,788 8,083,290 1,687,320 1,030,855 80,070,896 37,783,023 835,939,172
Projected
$
$
173,212,000 3,365,863,000 504,099,000 4,043,174,000
BUDGET VARIANCE FAVORABLE (UNFAVORABLE)
$
575,426,836 (37,783,023) 537,643,813
$
(10,367,929) 686,289 (9,681,640)
$
537,643,813
$
9,681,640
$
$
$
$
147,773,492 8,083,290 8,240,034 171,863,454 2,263,814 234,778,745 79,007,252 51,000,000 66,817,500 61,396,399 831,223,980
$
$
4,715,192
$
$ 1,373,582,985 $ 1,368,867,792
$
$
-
707,283,788 8,083,290 1,687,320 1,030,855 80,070,896 37,783,023 835,939,172
$
$
$
$
147,773,492 $ 8,083,290 8,240,034 171,863,454 2,263,814 234,778,745 79,007,252 51,000,000 (2) 66,817,500 61,396,399 831,223,980 $ 4,715,192
$
-
(6,864,052) (141,184) 487,320 (1,491,051) 1,003,270 (686,289) (7,691,986)
2,651,179 542 10,295 564 3,650,144 713,085 8 280,554 100,807 5,000,000 12,407,178 4,715,193
$ 1,373,582,985 $ 1,368,867,792
(1) September 2010 fuel fund reserve is $55.9 million. (2) Includes transfer to rate stabilization to mitigate the projected fuel fund deficit.
53 Page 1
JEA QUARTERLY FINANCIAL SUMMARY - WATER & SEWER SYSTEM September 30, 2010 ASSETS: Cash and Investments Other Current Assets Fixed and Other Assets TOTAL ASSETS
$
46,806,000 75,815,000 3,044,464,000 $ 3,167,085,000
LIABILITIES & EQUITY Current Liabilities Other Liabilities Fund Equity (Net Assets) TOTAL LIABILITIES & EQUITY
REVENUES AND EXPENSES: Revised Budget REVENUES: Revenues Investment Income Capacity/Extension Fees Contributed Capital Other Revenues Total Operating Revenues
$
$
EXPENSES: Operating and Maintenance Environmental WSEA Contribution Uncollectibles Contributed Capital Outlay Debt Service City Contribution Expense Contingencies & Working Capital Renewal and Replacement Fund Operating Capital Outlay Emergency Reserve Total Expenses
$
SURPLUS/(DEFICIT)
$
TOTAL REVENUES TOTAL APPROPRIATIONS
$ $
$
As of 12 months Actual
282,461,804 2,115,692 8,000,000 9,500,000 8,046,020 310,123,516
$
108,183,777 718,568 960,243 11,081,766 128,885,505 20,180,278 3,042,339 13,675,900 23,395,140 310,123,516
$
310,123,516 310,123,516
Projected
296,606,250 1,101,934 10,730,903 350,862 10,520,891 319,310,840
$
$
$
108,167,666 718,568 956,823 11,081,766 128,885,504 20,180,276 3,042,000 13,675,900 23,395,140 310,103,643
$ $ $
$
$
$
24,952,000 2,099,120,000 1,043,013,000 3,167,085,000
BUDGET VARIANCE FAVORABLE (UNFAVORABLE)
296,606,250 1,101,934 10,730,903 350,862 10,520,891 319,310,840
$
$
$
108,167,666 718,568 956,823 11,081,766 128,885,504 20,180,276 3,042,000 13,675,900 23,395,140 310,103,643
$
16,111 3,420 1 2 339 19,873
9,207,197
$
9,207,197
$
9,207,197
319,310,840 310,103,643
$ $
319,310,840 310,103,643
$
$
14,144,447 (1,013,758) 2,730,904 (9,149,138) 2,474,869 9,187,324
54 Page 2
JEA QUARTERLY FINANCIAL SUMMARY - DISTRICT ENERGY SYSTEM September 30, 2010
ASSETS: Cash and Investments Other Current Assets Fixed and Other Assets TOTAL ASSETS
$
$
Revised Budget
REVENUES AND EXPENSES: REVENUES: Revenues Total Operating Revenues EXPENSES: Operating and Maintenance Renewal and Replacement Fund Debt Service Contracts & Contingencies Operating Capital Outlay Total Expenses
LIABILITIES & EQUITY Current Liabilities Other Liabilities Fund Equity (Net Assets) TOTAL LIABILITIES & EQUITY
4,020,000 200,000 47,936,000 52,156,000
As of 12 months Actual
Projected
$
$
74,000 51,691,000 391,000 52,156,000
BUDGET VARIANCE FAVORABLE (UNFAVORABLE)
$ $
7,400,000 7,400,000
$ $
7,595,357 7,595,357
$ $
7,595,357 7,595,357
$ $
195,357 195,357
$
3,902,000 250,000 3,148,000 100,000 7,400,000
$
$
$
3,865,189 249,800 3,147,129 100,000 7,362,118
$
$
3,865,189 249,800 3,147,129 100,000 7,362,118
$
36,811 200 871 37,882
$
233,239
$
233,239
$
233,239
$ $
7,595,357 7,362,118
$ $
7,595,357 7,362,118
$
SURPLUS/(DEFICIT)
$
TOTAL REVENUES TOTAL APPROPRIATIONS
$ $
-
7,400,000 7,400,000
55 Page 3
JEA QUARTERLY FINANCIAL SUMMARY - CAPITAL PROJECTS September 30, 2010 Revised Budget
ELECTRIC SYSTEM Capital Funds Renewal & Replacement Deposits Construction Fund Investment Income Debt Proceeds Other Proceeds Operating Capital Outlay Total Capital Funds Capital Projects Generation Projects Transmission & Distribution Projects Other Projects Total Capital Projects
$
$
$
$
66,918,307 220,000 151,865,294 62,400,000 61,396,399 342,800,000
189,963,994 119,778,962 33,057,044 342,800,000
As of 12 months Actual
$
$
$
$
66,817,500 83,000 45,467,581 62,400,000 61,396,399 236,164,480
129,663,411 76,675,307 29,825,762 236,164,480
Projected
$
$
$
$
66,817,500 83,000 45,467,581 62,400,000 61,396,399 236,164,480
129,663,411 76,675,307 29,825,762 236,164,480
Difference
$
$
$
$
(100,807) (137,000) (106,397,713) (106,635,520)
(60,300,583) (43,103,655) (3,231,282) (106,635,520)
WATER & SEWER SYSTEM Capital Funds Renewal & Replacement Deposits Construction Fund Investment Income Debt Proceeds Other Proceeds Capacity Fees Contributed Capital Operating Capital Outlay Total Capital Funds Capital Projects Water Projects Sewer Projects Other Projects Total Capital Projects
$
$
$
$
13,675,900 42,000 68,386,960 8,000,000 9,500,000 23,395,140 123,000,000
$
37,907,000 67,579,000 17,514,000 123,000,000
$
$
$
13,675,900 24,000 26,425,785 10,730,903 350,862 23,395,140 74,602,590
$
20,898,706 43,216,313 10,487,571 74,602,590
$
$
$
13,675,900 24,000 26,425,785 10,730,903 350,862 23,395,140 74,602,590
20,898,706 43,216,313 10,487,571 74,602,590
$
$
$
$
(18,000) (48,379,410) (48,397,410)
(17,008,294) (24,362,687) (7,026,429) (48,397,410)
DISTRICT ENERGY SYSTEM Capital Funds Debt Proceeds Renewal & Replacement Deposits Other Proceeds Operating Capital Outlay Total Capital Funds Capital Projects District Energy Projects Total Capital Projects
$
$
250,000 602,000 100,000 952,000
$ $
952,000 952,000
$
$
249,800 100,000 349,800
$ $
127,445 127,445
$
$
249,800 100,000 349,800
$
$
(200) (602,000) (602,200)
$ $
127,445 127,445
$ $
(824,555) (824,555)
56
Page 4
JEA QUARTERLY FINANCIAL SUMMARY RATE STABILIZATION AND FUEL RECOVERY FUNDS September 30, 2010
FUEL RATE STABILIZATION FUND $
$
84,781,130 627,870 37,783,023 (37,783,023) (64,474,378) 35,000,000 55,934,622
October 1, 2009 Balance Rate stabilization contribution (.97) (1) Recovery fund contribution (2.90) Contributions from Fuel Rate Surplus Withdrawals from Fuel Rate Surplus Unbilled adjustment Withdrawals from the Recovery Fund Withdrawals from Fuel Rate Stabilization Withdrawals from recovery carry-over balance Contributions from Base Side Revenues Stabilization Balance as of September 30, 2010 (2)
FUEL RECOVERY FUND (3) $ 166,421,130 Collections as of September 30, 2009 37,783,023 Year to Date Collections FY 10 $ 204,204,153 Total Collections as of September 30, 2010
(1) Billing cycle carry over, the rate is $0 for FY 10. (2) Includes contributions from base side revenues. (3) This $2.90 charge per 1,000 kWh will be collected until March 31, 2012 or until the prior fuel fund loss of $252,000,000 has been recovered, whichever occurs first.
57 5 Page
JEA Electric System Utility Comparison on Operating Efficiency Operating Revenue per Megawatt Hour (mWh) Sold per FERC JEA Tampa Electric Company Orlando Utilities Commission Gainesville Regional Utilities
FY 10 104.35
FY 09 107.63 118.03 97.84 120.24
FY 08 91.11 105.46 97.08 115.78
FY 07 77.41 105.23 84.37 99.94
FY 06 77.72 100.84 80.02 99.32
FY05 65.24 92.65 80.43 86.64
Definition: Ratio of total electric operating revenues from sales to total megawatt-hour sales. JEA Observation: JEA maintains residential electric rates competitive with peer utilities in the State of Florida. However, increases in operating revenue per megawatt hour after FY 04 is primarily a result of higher fuel costs/revenues and the implementation of a four-year base rate adjustment beginning in FY 08. The other utilities experienced similar increases in fuel costs and revenues during the same period.
Page 58 6
FY04 58.55 89.48 72.93 80.18
FY03 58.07 84.28 69.49 76.45
JEA Electric System Utility Comparison on Operating Efficiency Operating and Maintenance Expense per mWh Sold per FERC JEA Tampa Electric Company Orlando Utilities Commission Gainesville Regional Utilities
FY 10 69.56
FY 09 69.07 73.56 63.27 89.51
FY 08 65.76 79.11 66.60 88.16
FY 07 57.19 71.76 56.92 72.63
FY 06
FY05
56.62 69.00 55.87 77.03
Definition: Ratio of total electric utility operation and maintenance expenses including fuel to total megawatt-hour sales. Does not include City contribution, debt service, renewal and replacement, or operating capital outlay. JEA Observation: JEA has maintained a low cost per mWh sold through its new efficient electric generating fleet as well as tight control on other operating expenses. Increases in operating expense per megawatt hour after FY 04 is a direct result of higher fuel costs/revenues. The other utilities experienced similar increases in fuel costs and revenues during the same period.
Page 59 7
49.90 67.97 55.38 64.83
FY04 45.02 55.28 51.06 59.32
FY03 43.47 53.09 42.81 51.76
JEA Electric System Summary Financial Information - Per JEA Budget Basis FY 10
FY 09
FY 08
FY07
FY06
FY05
FY04
FY03
FY02
Total Revenue per Megawatt Hour (mWh) Sold (1)
101.21
102.68
86.71
75.21
73.93
62.63
58.42
56.94
56.89
Total Expense per Megawatt Hour (mWh) Sold (2)
100.86
102.56
86.54
75.14
73.57
62.91
59.15
56.62
57.25
0.35
0.12
0.17
0.07
0.36
(0.28)
(0.73)
0.32
(0.36)
Difference
Definitions: (1) Ratio of total electric revenues to total megawatt-hour sales computed on the budget basis which is the basis for ratemaking. Includes investment income. Does not include state utility taxes, franchise fees, or interchange sales. Interchange sales are reflected as an offset to fuel expense on the budget basis. (2) Ratio of total electric expenses including fuel to total megawatt-hour sales computed on the budget basis. Includes City contribution, debt service, renewal and replacement, and operating capital outlay. JEA Observation: Today JEA operates with the philosophy of balancing the fuel fund on a current basis. JEA historically maintained sufficient balances in the base rate fund to offset shortages in the fuel fund. Surpluses in the base rate fund resulted primarily from one time events/transactions, such as debt refunding, debt defeasances, reduced capital outlay transfers and other revenue generating activities.
Page 60 8
JEA Electric System Summary Financial Information - Per JEA Budget Basis Fuel Rate Fuel Revenue per mWh sold Fuel Expense per mWh sold Net surplus/(deficit) per mWh sold
FY 10 39.62 39.62 0.00
FY 09 49.37 49.25 0.12
FY 08 39.55 39.66 (0.11)
FY 07 33.01 33.01 0.00
FY06 34.27 34.27 0.00
FY05 23.74 27.73 (3.99)
FY04 17.60 23.30 (5.70)
FY03 17.79 21.13 (3.34)
Definition: Fuel related revenues minus fuel related expenses. JEA Observation: Today JEA operates with the philosophy of balancing the fuel fund, and utilizes a rate stabilization fund to balance the fuel fund on a current basis.
Base Rate Base Revenue per mWh sold Base Expense per mWh sold Net surplus/(deficit) per mWh sold
FY 10 YTD 61.59 61.25 0.35
FY 09 53.31 53.30 0.01
FY 08 47.17 46.88 0.28
FY 07 42.20 42.13 0.07
Definition: Non-fuel related revenues minus non-fuel related expenses. JEA Observation: In the past JEA has been able to maintain sufficient balances in the base rate to offset shortages in the fuel rate. Surpluses in the base rate resulted primarily from one time events/transactions such as debt refunding, debt defeasances, reduced capital outlay transfers and other revenue generating activities.
JEA Electric System Utility Comparison on Operating Efficiency Current Fuel and Base Rate Analysis Residential $/1000 kWh
JEA Tampa Electric Company Orlando Utilities Commission Gainesville Regional Utilities
As of Sept 10 Base 66.30 68.24 77.75 74.45
Fuel 44.16 41.67 42.07 56.00
61
Page 9
110.46 109.91 119.82 130.45
FY06 39.66 39.30 0.36
FY05 38.90 35.18 3.72
FY04 FY03 40.82 35.82 5.00
39.14 35.50 3.64
Electric Utility Comparison Contribution to City General Fund $ 000's JEA Orlando Utilities Commission Gainesville Regional Utilities
Percent of Operating Revenues JEA Orlando Utilities Commission Gainesville Regional Utilities
$ Per mWh Sold JEA Orlando Utilities Commission Gainesville Regional Utilities
$ in thousands Contribution Increase from prior year % Increase
FY 10 79,007
FY 09 76,094 70,650 20,230
FY 08 73,847 69,199 19,500
FY 07 73,100 64,246 18,927
FY 06 71,031 66,985 18,574
FY05 68,677 52,633 17,681
FY 04 67,385 48,087 17,456
FY 03 67,039 48,341 16,901
FY 10 5.58%
FY 09 5.33% 10.03% 8.00%
FY 08 5.92% 9.22% 8.04%
FY 07 6.80% 9.54% 8.99%
FY 06 6.51% 10.06% 8.86%
FY05 7.71% 7.75% 10.00%
FY 04 8.66% 7.94% 10.77%
FY 03 8.74% 9.62% 10.76%
FY 10
FY 09
FY 08
FY 07
FY 06
FY05
FY 04 5.07 5.92 8.64
FY 03 5.08 6.92 8.22
FY 04 83,188 4,691 5.98%
FY 03 78,496 1,890 2.47%
5.82
5.74 9.81 9.61
5.39 8.95 9.31
Total JEA Contribution to the City's General Fund * FY 10 FY 09 FY 08 99,188 96,688 94,188 2,500 2,500 2,750 2.59% 2.65% 3.01%
5.27 8.05 8.99
FY 07 91,438 2,750 3.10%
* includes the Water and Sewer system
The percent of operating revenues have decreased because most of the operating revenue increase after FY 04 is due to fuel rate increases which, by agreement, were intentionally excluded from the contribution formula. JEA also transfers a 3% franchise fee to the City general fund that became effective April 1, 2008, and public service tax.
Page 62 10
5.06 8.05 8.80
FY 06 88,688 2,750 3.20%
5.03 6.08 8.67
FY05 85,938 2,750 3.31%
JEA Electric System Utility Comparison on Operating Efficiency Debt Service Coverage - Total FY 10 3.35x
JEA - Electric System Tampa Electric Company Orlando Utilities Commission ** Gainesville Regional Utilities **
FY 09 2.99x * 2.41x 2.05x
FY 08 2.40x * 2.45x 2.12x
FY 07 2.37x * 2.45x 2.05x
FY06 2.28x * 2.24x 1.88x
FY05 2.11x * 2.26x 2.16x
FY04 2.03x * 2.24x 2.47x
FY03 2.33x * 2.13x 2.53x
Definition: Ratio of net revenues available for debt service to total long-term debt service for the year. Measures the ability to meet annual debt service obligation. * Tampa Electric Company is an investor-owned utility and the debt service coverage calculation is computed on a basis not comparable with municipal-owned utilities. ** The ratios for Orlando Utilities Commission and Gainesville Regional Utilities reflect a combining of Electric and Water/Sewer System revenues and expenses. JEA Observation: It is extremely important to maintain a debt service coverage ratio which meets the bond rating agencies expectations and is favorable when compared to peers. Higher bond ratings result in lower interest cost for the utility and its ratepayers. JEA's preferred electric system total debt service coverage is 2.5x. JEA's FY 2010 debt service coverage ratio was favorably impacted by low variable interest rates.
Bond Rating FY 10 JEA - Electric System Tampa Electric Company Orlando Utilities Commission Gainesville Regional Utilities
AA-
FY 09 AABBB AA AA
FY 08 AABBBAA AA
Definition: Rating assigned by Standard & Poor's. JEA Observation: Higher bond ratings result in lower interest cost to the utility and its ratepayers. JEA ratings were confirmed in April 2010
Page 63 11
FY 07 AABBBAA AA
FY06 AABBBAA AA
FY05 AABBBAA AA
FY04 AABBBAA AA
FY03 AA BBBAA AA
WATER AND SEWER EXPANSION AUTHORITY QUARTERLY FINANCIAL SUMMARY FOR THE QUARTER ENDED SEPTEMBER 30, 2010 OPERATING BUDGET INFORMATION
ACTUAL YEAR TO DATE
BUDGET REVENUES Contribution from JEA JEA Fund Balance Carrry Over of STAG Grant Contribution from City Total Revenues
$
800,000
$
$
459,300 436,030 1,695,330
$
718,568 436,030 1,154,598
166,587 51,652 511 499,819 436,030 1,154,598
APPROPRIATIONS Salaries Benefits Supplies Other Services & Charges Payment to City Loan Pool Total Expenditures
$
175,036 $ 52,500 3,500 1,028,264 (1) 436,030 1,695,330 $
BUDGET DIFFERENCE
$
-
$
FTE Allocations =
(1) Other Services and Charges Professional Services Travel Licenses,Fees, Dues, Membership Subscriptions and Publications Outside Consultants Total Other Services & Charges
$
3
$
$
315,000 (a) $ 5,000 1,000 300 706,964 (b) 1,028,264 $
PROJECTED $
$
$
$
BUDGET VARIANCE FAVORABLE (UNFAVORABLE)
718,568 436,030 1,154,598
$ $
166,587 51,652 511 499,819 436,030 1,154,599
$ $ $ $
-
$
$
3
(81,432) (459,300) (540,732)
8,449 848 2,989 528,445 540,732 -
3
314,994 2,744 2,307 179,775 499,819
$
$
314,994 (a) $ 2,744 $ 2,307 $ $ 179,775 (b) $ 499,820 $
(a) For Fred Odom’s consulting contract. (b) For engineering & planning services, contract management, funding support, and an outside audit
64
7 2,256 (1,307) 300 527,189 528,445
# of Connections
Project No.
GEN RESERVE (PWCP322WSEXP)
2004-713-E
APPROPRIATIONS $2,631,200 2005-652-E 2005-313-E
Triangular/ FT Caroline YMCA
30
PW0540/41
(798,000.00)
292,000.00
Clark Road/ Drury Lane
6
PW0543/44
2004-1284-E (55,000.00)
2006-299-E 42,232.43
La Villas
1
PW0545
2005-70-E (50,000.00)
TOTAL (50,000.00)
Nate Circle
4
PW0572
2005-191-E (22,500.00)
TOTAL (22,500.00)
PW0570
2005-312-E (280,000.00)
TOTAL (280,000.00)
Wagner Road (Canceled)
(50,000.00)
TOTAL (556,000.00)
TOTAL (12,767.57)
Iroquois/Milam/Forest Park
53
PW0573
2005-436-E (1,448,000.00)
2007-10-E 394,800.00
-
TOTAL (1,053,200.00)
McGlothin & Buttercup
24
PW0583
2005-850-E (106,000.00)
2006-904-E (20,000.00)
-
TOTAL (126,000.00)
Shakir- Sewer
1
PW0608
2005-1089-E (39,250.00)
-
TOTAL (39,250.00)
Shakir- Water
1
PW0608
2006-903-E (20,000.00)
-
TOTAL (20,000.00)
Unitarian Church
1
PW0625
2006-29-E (150,000.00)
-
TOTAL (150,000.00)
Cannon Street
4
PW0622
2006-129-E (45,344.00)
-
TOTAL (25,344.00)
Hendricks
1
PW0618
2006-243-E (113,335.00)
-
TOTAL (113,335.00)
Church Fellowship
1
PW0619
2006-242-E (95,000.00)
-
TOTAL (118,000.00)
The Hartley Press
1
2007-1001-E PW0701 – 01
Zona SUBTOTAL TOTAL WSEA GEN RESERVE REMAINING BALANCE
2 128
65
2009-0329 (26,000.00)
-
2006-904-E 20,000.00
-
2007-599-E (23,000.00)
TOTAL -
-
-
-
-
-
-
TOTAL (26,000.00) (2,592,396.57) 2,631,200.00 38,803.43
Loan Pool (JXARS591CCWSE = AFTR591 & JXMS011WSEA) $1,974,000 PW0579
2005-539-E (1,026,448.00)
-
TOTAL (1,026,448.00)
182
PW0579
2006-810-E (300,000.00)
-
TOTAL (300,000.00)
D & W Electric
1
PW0635
2006-812-E (48,000.00)
-
-
TOTAL (48,000.00)
Glendale Road
9
2007-98-E (136,000.00)
-
-
TOTAL (136,000.00)
Tree Hill Nature Center
1
2007-598-E (138,000.00)
-
-
TOTAL (138,000.00)
2007-1001-E (205,000.00)
-
-
-
-
-
-
-
-
Pine Forest- Sewer
Pine Forest- Connections
The Hartley Press SUBTOTAL TOTAL WSEA LOAN POOL REMAINING BALANCE
1 194
TOTAL (205,000.00) (1,853,448.00) 1,974,000.00 120,552.00
Autumn Bond $1M (PWCP363WSEXP) Iroquois/Milam/Forest Park SUBTOTAL TOTAL AUTUMN BOND REMAINING BALANCE
PW0573
2007-10-E (394,800.00)
Capital Accounts Subtotals SUBTOTAL TOTAL WSEA LOAN POOL REMAINING BALANCE
TOTAL (394,800.00) (394,800.00) 1,000,000.00 605,200.00
(4,840,644.57) 5,605,200.00 764,555.43
Professional Services (JXM011WSEA)
2007-10-E (394,800.00)
Professional Services (# 03109) SUBTOTAL TOTAL PROFESSIONAL SVCS REMAINING BALANCE
TOTAL SUBTOTAL TOTAL ACCOUNTS REMAINING BALANCE
322
TOTAL (394,800.00) (394,800.00) 394,800.00 -
(5,235,444.57) 6,000,000.00 764,555.43
66
JACKSONVILLE TRANSPORTATION AUTHORITY MASS TRANSIT DIVISION-BUS QUARTERLY SUMMARY FOR THE PERIOD ENDED SEPTMBER 30, 2010
BALANCE SHEET INFORMATION-COMBINED Cash & Investments Current Assets Fixed Assets Total Assets
$
$
(4,675,741) 23,877,083 67,165,827 86,367,169
Current Liabilities Other Liabilities Fund Equity Total Liab. & Equity
$
$
5,718,765 2,468,032 78,180,372 86,367,169
BUDGET INFORMATION-BUS OPERATIONS
Annual Budget Revenues Federal, State & Local Grants Local Option Gas Tax Sales Tax Passenger Fares Preventive Maintenance Grant Non-transportation Interest earnings All other Transfers in From CTC
$
12 mos YTD Actual
9,385,718 27,951,000 26,000,000 8,165,500 361,963 225,000 260,000 207,081 100,000
$
6,087,756 28,269,053 13,407,500 8,758,234 2,227,898 419,370 12,722 255,614 100,080
Projected Favorable (Unfavorable) Budget Variance
2010 Projected
$
6,087,756 28,269,053 13,407,500 8,758,234 2,227,898 419,370 12,722 255,614 100,080
$
(3,297,962) 318,053 (12,592,500) 592,734 1,865,935 194,370 (247,278) 48,533 80
Total Revenues
72,656,262
59,538,227
59,538,227
(13,118,035)
Appropriations Salaries & Fringe Benefits Fuel Materials & Supplies Insurance Services ADA expense (revenue to CTC) Taxes & Licenses Utilities Lease expense Transfer to Skyway Transfer to CTC Reserve for Operations Miscellaneous
37,557,245 5,891,544 2,894,734 1,367,490 5,598,117 7,120,000 130,110 729,373 64,400 2,500,000 8,100,000 703,249
36,689,628 5,232,205 3,907,075 849,756 7,355,794 8,842,021 116,936 578,148 70,350 3,275,219 121,406 611,902
36,689,628 5,232,205 3,907,075 849,756 7,355,794 8,842,021 116,936 578,148 70,350 3,275,219 121,406 611,902
867,617 659,339 (1,012,341) 517,734 (1,757,677) (1,722,021) 13,174 151,225 (5,950) (775,219) (121,406) 8,100,000 91,347
Total Appropriations
72,656,262
67,650,440
67,650,440
5,005,822
Budget Difference
$
-
$
67
(8,112,213)
$
(8,112,213)
$
(8,112,213)
JACKSONVILLE TRANSPORTATION AUTHORITY MASS TRANSPORTATION DIVISION - SKYWAY QUARTERLY SUMMARY FOR THE PERIOD ENDED SEPTEMBER 30, 2010
BALANCE SHEET INFORMATION-COMBINED
Cash & Investments Current Assets Fixed Assets Total Assets
$
$
4,557,420 3,106,715 90,562,868 98,227,003
Current Liabilities Other Liabilities Fund Equity Total Liab. & Equity
$
$
2,957,789 193,742 95,075,472 98,227,003
BUDGET INFORMATION-SKYWAY OPERATIONS
Annual Budget Passenger fares: - Parking Fees - Parking Fee Fares - Circulation Fares
$
subtotal
12 mos YTD Actual
115,200 195,800 189,000 500,000
$
118,692 83,234 142,410 344,336
Projected Favorable (Unfavorable) Budget Variance
2010 Projected
$
118,692 83,234 142,410 344,336
$
3,492 (112,566) (46,590) (155,664)
Preventive maintenance grant Interest Income All other Local Option Gas Tax Transfer in from Bus
2,000,000 113,148 2,718 620,000 2,500,000
1,400,000 5,335 1,116 3,275,219
1,400,000 5,335 1,116 3,275,219
(600,000) (107,813) (1,602) (620,000) 775,219
Total Revenues
5,735,866
5,026,006
5,026,006
(709,860)
Appropriations Salaries & Fringes Fuel and Lubricants Materials & Supplies Insurance Services Utilities Miscellaneous
3,338,605 15,000 1,093,231 371,454 566,859 315,214 35,503
2,624,148 15,483 911,094 452,468 672,334 323,626 26,853
2,624,148 15,483 911,094 452,468 672,334 323,626 26,853
714,457 (483) 182,137 (81,014) (105,475) (8,412) 8,650
Total Appropriations
5,735,866
5,026,006
5,026,006
709,860
Budget Difference
$
-
$
-
68
$
-
$
-
JACKSONVILLE TRANPORTATION AUTHORITY MASS TRANSIT DIVISION-CTC QUARTERLY SUMMARY FOR THE PERIOD ENDED SEPTEMBER 30, 2010
BALANCE SHEET INFORMATION Cash & Investments Current Assets Fixed Assets Total Assets
$
$
190,265 1,429,093 2,001,028 3,620,386
Current Liabilities Other Liabilities Fund Equity Total Liab. & Equity
$
$
4,150,528 (*) 189,000 (719,142) 3,620,386
BUDGET INFORMATION Annual Budget
12 mos YTD Actual
Projected Fav (Unfav) Budget Variance
2010 Projected
REVENUES Passenger fares State-Transportation Disadvantaged JTA - ADA Complementary Paratransit City of Jacksonville contribution Preventive maintenance grant Interest earnings/all other Transfer in from Bus
$
Total Revenues
500,000 1,200,000 7,120,000 1,220,350 1,000,000 36,045 1,429,000
$
541,777 1,058,090 8,842,021 1,102,757 716,195 121,567 121,406
$
541,777 1,058,090 8,842,021 1,102,757 716,195 121,567 121,406
$
41,777 (141,910) 1,722,021 (117,593) (283,805) 85,522 (1,307,594)
12,505,395
12,503,813
12,503,813
(1,582)
3,326,447 968,350 541,666 42,170 7,229,749 500 132,632 92,258 100,000 71,623
2,616,158 1,320,252 642,743 43,408 7,522,509 89,415 95,826 100,080 73,422
2,616,158 1,320,252 642,743 43,408 7,522,509 89,415 95,826 100,080 73,422
710,289 (351,902) (101,077) (1,238) (292,760) 500 43,217 (3,568) (80) (1,799)
12,505,395
12,503,813
12,503,813
APPROPRIATIONS Salaries & Fringe Benefits Fuel and lubricants Materials & Supplies Insurance Services Taxes & Licenses Utilities Building lease, Training Transfer to Bus ( T D Ride Program) Miscellaneous Total Appropriations Budget Difference
$
-
$
-
$
(*) The majority of the current liabilities are owed to other funds at JTA and not to outside vendors.
69
-
1,582 $
-
JACKSONVILLE TRANSPORTATION AUTHORITY ENGINEERING DIVISION-GENERAL FUND QUARTERLY SUBMISSION FOR THE PERIOD ENDED SEPTEMBER 30, 2010
BALANCE SHEET INFORMATION Cash & Investments Current Assets Fixed Assets Total Assets
$
64,841,807 33,334,148
$
98,175,955
Annual Budget REVENUES Sales Tax Interest Income All Other (incl. BJP revenue) Total Revenues
EXPENDITURES(*) Salaries & Fringe Benefits Insurance Repairs & Maintenance Legal & Professional Utilities Supplies All other/Miscellaneous Total Administrative Expenses
Current Liabilities Other Liabilities Fund Equity Total Liab. & Equity
12 mos YTD Actual
2010 Projected
$
$
4,274,488 93,901,467 98,175,955
Projected Favorable (Unfavorable) Budget Variance
$
68,760,864 1,881,262 -
$ 63,573,456 111,789 811,339
$
63,573,456 111,789 811,339
$
(5,187,408) (1,769,473) 811,339
$
70,642,126
$ 64,496,584
$
64,496,584
$
(6,145,542)
$
1,431,486 20,477 117,359 131,940 13,312 110,482 34,206
2,492,278 29,645 231,127 904,786 144,642 173,355 97,844
$
1,859,262
Administrative Capital Expenditures
$
4,073,677
2,492,278 29,645 231,127 904,786 144,642 173,355 97,844 $
4,073,677
(1,060,792) (9,168) (113,768) (772,846) (131,330) (62,873) (63,638) $
22,000
21,516
$
68,760,864
$ 63,295,181
$
63,295,181
$
5,465,683
Total Appropriations
$
70,642,126
$ 67,390,374
$
67,390,374
$
3,251,752
Difference
$
$
$
(2,893,790) (**)
$
(2,893,790)
Trfs out(Debt Service & BJP)
-
(2,893,790)
21,516
(2,214,415)
(**) This decreases fund balance at year end. Similar decreases took place in 2009 (-$2.1M), in 2008 (-$5.8M) and 2006 (-$8.4M). Fund balance still remains strong at $94M, 69% of which is cash and investments.
70
484
JACKSONVILLE TRANSPORTATION AUTHORITY CAPITAL BUDGET AND EXPENDITURES FOR THE YEAR ENDED: SEPTEMBER 30, 2010
Annual Budget
12 mos YTD Actual
Projected Fav/(Unfav) Budget Variance
2010 Projected
BUS OPERATIONS Federal, State and Local Grants
$
13,029,052
$
52,869
$
52,869
$
(12,976,183)
Total Revenues
$
13,029,052
$
52,869
$
52,869
$
(12,976,183)
Communications Equipment Computer Equipment Enhancements (Landscaping) Facility Improvements Information Kiosks Jacksonville Transportation Center (JTC) Office Furnishings & Equipment Program Administration Purchase Transit Vehicles (9 Buses) Purchase Vans (6 Van) Rapid Transit System (RTS) Real Estate Acquisition Security & Equipment (CCTV Video Surveillance) Shop Equipment Support Vehicles Transit Satellite Amenities (Bus Shelters) Transit Vehicles (6 Vans) Total Appropriations
$
395,000 461,500 155,000 386,145 625,000 3,593,750 89,257 45,000 3,000,000 120,000 1,500,000 1,500,000 160,000 7,600 20,000 970,800 13,029,052
$
Budget Difference
$
SKYWAY Federal Grants
$
Total Revenues
$
40,448
$
40,448
$
395,000 461,500 155,000 369,717 625,000 3,593,750 89,257 29,170 3,000,000 120,000 1,500,000 1,500,000 160,000 7,600 20,000 962,610 12,988,604
$
12,421
$
12,421
$
12,421
1,418,787
$
135,354
$
135,354
$
(1,283,433)
$
1,418,787
$
135,354
$
135,354
$
(1,283,433)
Associated Capital Maintenance Parts Barrier Protection Computer Equipment Facility Improvements Modernization Rehab/Renovate Transit Vehicles Security & Equipment (CCTV Video Surveillance)
$ $
310,000 100,000 390,854 250,000 367,933
$
109,480
$
109,480
$
(109,480) 310,000 100,000 (27,561) 390,854 250,000 367,933
Total Appropriations
$
1,418,787
$
Budget Difference
$
CONNEXION (CTC) Federal Grants JTA Amount (BJP) Total Revenue
$
$ $
Communications Equipment Miscellaneous Support Equipment (CCTV) Transit Vehicles (6 Vans) Total Appropriations
$
Budget Difference
$
$
-
16,428
16,428
15,830
15,830
8,190
8,190
27,561 -
-
$
2,027,445 2,027,445
$
393,000 630,000 1,004,445 2,027,445
137,041
(1,687)
$
274,440 274,440
$
274,440 274,440
27,561 -
$
$
$
137,041
(1,687)
$
274,440 274,440
$
274,440 274,440
$
$
(1,687)
$
(1,753,005) (1,753,005)
$
$
-
$
-
$
-
Note: Current fiscal year unexpended capital funds are carried over to subsequent years for future purchases.
71
1,281,746
$ $
393,000 355,560 1,004,445 1,753,005 -
JACKSONVILLE PORT AUTHORITY QUARTERLY REPORT SUMMARY For the Twelve Months Ending September 30, 2010 UNAUDITED
BALANCE SHEET Cash and Investments (1) Other Current Assets Fixed and Other Assets TOTAL ASSETS
(1) Includes restricted funds of
$
$
45,465,751 28,360,494 615,006,028 688,832,273
$
37,966,856
Current Current Liabilities Liabilities Other Other Liabilities Liabilities Total Equity TOTAL LIABILITIES & EQUITY
$
$
26,483,673 353,927,946 308,420,655 688,832,273
OPERATING & NON-OPERATING ITEMS
ORIGINAL BUDGET OPERATING REVENUES Autos Containers Break Bulk Cruise Liquid Bulk Dry Bulk Military Ferry Operations Other Operating Revenues TOTAL OPERATING REVENUES
OPERATING EXPENDITURES Salaries (2) Employee Benefits (2) Services & Supplies Security Services Business Travel & Training Promotion, Advertising & Dues Utility Services Repairs & Maintenance Projects Dredging Stormwater Fee Bad Debt Expense Ferry Operations Miscellaneous TOTAL OPERATING EXPENDITURES OPERATING INCOME NON-OPERATING REVENUES Investment Income Shared Revenue from Primary Govt Operating Grants Other Revenue
$
$
$
$
10,168,476 3,827,909 4,709,613 5,053,273 415,803 894,800 1,202,630 1,882,126 3,600,000 535,000 50,000 1,759,791 79,890 34,179,311
$
$
$ NON-OPERATING EXPENSES Debt Service Other Expenditures
11,162,935 22,872,980 3,605,724 3,352,354 705,046 2,126,899 1,300,000 1,196,942 1,786,317 48,109,197
$
$
$
12,491,445 23,241,887 4,357,138 3,403,221 854,827 1,895,418 2,126,017 935,644 1,941,515 51,247,111
$
9,887,838 3,512,664 4,217,727 4,972,970 360,198 737,676 1,173,188 1,858,364 3,264,918 133,985 50,000 1,675,764 144,980 31,990,271
13,929,886
$
152,567 8,445,478 2,860 8,600,905
$
$
$
ANNUAL PROJECTED $
$
$
12,491,445 23,241,887 4,357,138 3,403,221 854,827 1,895,418 2,126,017 935,644 1,941,515 51,247,111
$
$
$
9,887,838 3,512,664 4,217,727 4,972,970 360,198 737,676 1,173,188 1,858,364 3,264,918 133,985 50,000 1,675,764 144,980 31,990,271
$
280,638 315,245 491,886 80,303 55,605 157,124 29,442 23,762 335,082 401,015 84,027 (65,090) 2,189,040
19,256,840
$
19,256,840
$
5,326,954
119,896 8,010,594 113,751 117,778 8,362,019
$
119,896 8,010,594 113,751 117,778 8,362,019
$
$
$
$
21,189,238 20,062 21,209,300
$
1,328,510 368,907 751,414 50,867 149,781 (231,481) 826,017 (261,298) 155,198 3,137,914
$
$ NET INCOME BEFORE CAPITAL OUTLAY AND CONTINGENCY
$
2,207,732
$
6,409,559
$
6,409,559
$
4,201,827
Transfer (to)/from Operating Capital Outlay SURPLUS (DEFICIT)
$
(2,207,732) -
$
(2,207,732) 4,201,827
$
(2,207,732) 4,201,827
$ $
(4,201,827)
$ $
56,710,102 56,710,102
$ $
59,609,130 55,407,303
$ $
59,609,130 55,407,303
(2) Includes accrual for the remainder of Rick Ferrin's contract ($200,353) 1
72
$
$
21,189,238 20,062 21,209,300
(32,671) (434,884) 113,751 114,918 (238,886)
20,300,859 22,200 20,323,059
TOTAL REVENUES TOTAL APPROPRIATIONS
$
YTD ACTUAL
FAVORABLE (UNFAVORABLE) BUDGET VARIANCE
$
(888,379) 2,138 (886,241)
JACKSONVILLE PORT AUTHORITY QUARTERLY REPORT SUMMARY For the Twelve Months Ending September 30, 2010 UNAUDITED
CAPITAL
ANNUAL BUDGET RECEIPTS Federal Contributions State Contributions City Contributions JPA Financing Customer Contribution Insurance Proceeds (3) Capital Outlay Carryover TOTAL RECEIPTS
APPROPRIATIONS & EXPENDITURES Capital Outlay - Blount Island Projects Capital Outlay - Dames Point Projects Capital Outlay - Talleyrand Projects Capital Outlay - Miscellaneous Projects TOTAL APPROPRIATIONS & EXPENDITURES CAPITAL BUDGET DIFFERENCE
$
$
$
YTD ACTUAL
9,648,270 8,899,902 95,440 22,631,757 5,000,000 23,345,000 69,620,369
$
39,607,603 11,975,000 6,891,750 11,146,016 69,620,369
$
-
$
$
$
1,367,689 8,793,493 9,938,434 5,000,000 2,207,732 27,307,348
$
8,381,280 3,115,316 3,129,893 6,877,320 21,503,809
$
5,803,539
(3) Funds received on account from Insurance company (Replace BI Container Cranes) (4) Unexpended capital dollars will be carried over to new fiscal year (5) Some receipts collected in current FY were for prior year expenditures
2
73
ANNUAL PROJECTED
$
$
$
1,367,689 8,793,493 9,938,434 5,000,000 2,207,732 27,307,348
FAVORABLE (UNFAVORABLE) BUDGET VARIANCE
$
$
(8,280,581) (106,409) (95,440) (12,693,323) (5,000,000) (18,345,000) 2,207,732 (42,313,021)
$
8,381,280 3,115,316 3,129,893 6,877,320 21,503,809
$
31,226,323 8,859,684 3,761,857 4,268,696 48,116,560 (4)
$
5,803,539
$
5,803,539 (5)
SEP-2010 Jacksonville Aviation Authority Jacksonville, Florida Quarterly Report Summary For the twelve months ended September 30, 2010 UNAUDITED Cash and investments Other current assets Fixed and other assets Total assets
$
$
91,953,939 10,533,544 556,645,732 659,133,215
Current liabilities Other liabilities Total equity Total liabilities and equity
2009/2010 Revised Budget
OPERATING REVENUES Concessions Fees & Charges Space & Facility Rentals Parking Sale of Utilities Other Miscellaneous Operating Revenue TOTAL OPERATING REVENUES
$
14,057,412 12,591,580 17,819,232 15,604,373 1,513,033 121,296 61,706,926
OPERATING EXPENDITURES Salaries Benefits Services and Supplies Repairs & Maintenance Promotion, Advertising and Dues Registration & Travel Insurance Expense Cost of Goods for Sale Utilities, Taxes & Gov't Fees Emergency Reserve TOTAL OPERATING EXPENDITURES
OPERATING INCOME NON-OPERATING REVENUES Passenger Facility Charges Investment income Other Revenues TOTAL NON-OPERATING REVENUES NON-OPERATING EXPENDITURES Debt Service Other Expenditures TOTAL NON-OPERATING EXPENDITURES
$
YTD Actual
$
$
$
12,193,497 5,254,083 13,331,844 2,782,441 610,985 374,503 1,096,823 682,202 6,097,105 1,500,000 43,923,483
$
17,783,443
$
10,814,641 2,457,914 495,860 13,768,415
$
19,312,545 74,200 19,386,745
TOTAL REVENUES TOTAL APPROPRIATIONS FULLTIME POSITIONS TEMPORARY EMPLOYEE HOURS
$
25,195,935 197,050,326 436,886,954 659,133,215 Budget Variance Favorable (Unfavorable)
$
13,768,133 12,282,665 15,730,343 15,406,820 1,713,323 390,921 59,292,204
$
(289,279) (308,915) (2,088,889) (197,553) 200,290 269,625 (2,414,722)
$
12,127,479 4,436,272 12,331,819 2,200,471 485,793 237,327 1,088,319 567,460 5,152,453 38,627,393
$
12,127,479 4,436,272 12,331,819 2,200,471 485,793 237,327 1,088,319 567,460 5,152,453 38,627,393
$
66,018 817,811 1,000,025 581,970 125,192 137,176 8,504 114,742 944,652 1,500,000 5,296,090
$
20,664,811
$
20,664,811
$
2,881,368
$
11,329,159 1,871,717 1,454,303 14,655,178
$
11,329,159 1,871,717 1,454,303 14,655,178
$
18,692,524 228,553 18,921,077
$
16,398,913
Transfer (to) Operating Capital Outlay (8,717,000) Transfer (to)/from Passenger Facility Charge Reserve(2,915,382) Transfer (to)/from Retained Earnings (532,731) SURPLUS/(DEFICIT)
$
Annual Projected
13,768,133 12,282,665 15,730,343 15,406,820 1,713,323 390,921 59,292,204
$ 12,165,113 NET INCOME BEFORE OPERATING CAPITAL OUTLAY, PFC RESERVE AND CONTINGENCY
$
$
$
514,518 (586,197) 958,443 886,763
$
18,692,524 228,553 18,921,077
$
620,021 (154,353) 465,668
$
16,398,913
$
4,233,799
(1,165,780) (3,278,839) (11,954,294)
$ $
7,551,220 (363,457) (11,421,563)
(1,165,780) (3,278,839) (11,954,294)
$
0
$
0
$
0
$
(0)
$ $
75,475,341 75,475,341
$ $
73,947,382 73,947,382
$ $
73,947,382 73,947,382
$ $
(1,527,959) 1,527,959
251
220
66,020
37,150
74
220 37,150
31 28,870
Jacksonville Aviation Authority Jacksonville, Florida Quarterly Report Summary For the twelve months ended September 30, 2010 UNAUDITED
Annual Budget Capital revenues: Federal Contributions State Contributions Contingent Funding PFC Operating Capital Outlay Total revenues
Capital appropriations: Jacksonville International Airport Cecil Field Craig Airport Herlong Airport Total Appropriations
$
$
YTD Actual
9,073,094 1,235,000 8,145,000 3,220,531 8,717,000 30,390,625
$
$
638,737 241,102 4,084,609 1,165,780 6,130,228
Budget Variance Favorable (Unfavorable)
Annual Projected
$
$
638,737 241,102 4,084,609 1,165,780 6,130,228
$
$ $
(8,434,357) (993,898) (8,145,000) 864,078 (7,551,220) (24,260,397)
$
22,376,125 7,707,500 140,000 167,000
$
4,932,539 1,132,696 9,069 55,924
$
4,932,539 1,132,696 9,069 55,924
$
17,443,586 6,574,804 130,931 111,076
$
30,390,625
$
6,130,228
$
6,130,228
$
24,260,397
Note: JAA anticipates completion of all budgeted projects, however given the multi-year nature of these expenditures, JAA spent only $6,130,228 at fiscal year end.
75