SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT
3/31/2014
QUARTERLY FINANCIAL REPORT A financial summary of the first three months of 2014
SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT
SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT FIRST QUARTER 2014
EXECUTIVE SUMMARY INTRODUCTION The following quarterly financial report provides an analysis of the first three months of the 2014 calendar year. The information contained in this report is based on unaudited budgetary financial statements and excludes adjustments that may be required by the County’s auditors at a later date. This report provides a summary of revenues and expenditures of the County for the first three months of the calendar year of 2014. Comparative analysis will also be provided for the major revenue and expenditure categories including comparisons to budgeted and prior year amounts for the same time period.
REVENUE HIGHLIGHTS This section will show revenues received by the County during the first three months of 2014. These revenues will be compared to the budgeted amount for the same time period and the amount received during the prior year for the same time period. Shawnee County received total revenue of $47,728,043 during the first three months of 2014. This represents 2.6% over the budgeted amount for this period. Total Revenue $50,000,000 $45,000,000 $40,000,000 $35,000,000 $30,000,000
Other Revenue
$25,000,000 $20,000,000
Other Taxes
$15,000,000 Special Assessments
$10,000,000 $5,000,000
Property Taxes
$2014 YTD $ 47,728,043
BUDGET $46,517,604
2013 YTD $43,839,828
Page 1
SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT
Ad Valorem Taxes Ad Valorem Tax is the largest single revenue source available to Kansas Counties. This revenue is derived from taxes levied on real property, personal property and state assessed property. The Shawnee County Appraiser’s office values real and personal property and the State of Kansas assigns values to state assessed property such as utilities. Ad Valorem Taxes represented approximately 65% of the County’s revenue in 2013. The largest portion of Ad Valorem taxes are received in January and June when real estate taxes are distributed to the taxing authorities.
Special Assessments $2,500,000 $2,000,000 $1,500,000 $1,000,000 $500,000
$-
2014 YTD $2,167,408
BUDGET $2,392,049
2013 YTD $2,224,054
Special Assessments are amounts assessed on real property for special projects that benefit the neighborhood. Projects that might result in special assessments include sewer and water system improvements, installation or improvements to roads and sidewalks and installation of public utilities. Special assessments are most common on new land developments.
Other Taxes Other taxes include the following:
$1,800,000
Motor Vehicle Tax RV Tax Local Alcohol Liquor Tax Highway Tax Franchise Tax 1620 Truck Tax Other Misc. Taxes
$1,600,000 $1,400,000 $1,200,000
$1,000,000 $800,000 $600,000 $400,000 $200,000
$-
2014 YTD $1,706,285
BUDGET $1,357,401
2013 YTD $1,581,320
Page 2
SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT
Other Revenue Other revenue includes the following:
$4,500,000
$4,000,000 $3,500,000 $3,000,000 $2,500,000
$2,000,000 $1,500,000 $1,000,000 $500,000
$-
2014 YTD $3,539,540
BUDGET $3,434,081
2013 YTD $4,222,101
Property Related Fees such as Mortgage Registration Tax, Register of Deeds filing fees, Zoning Fees, Planning Fees Charges for Services including Parks and Recreation fees, Detention Facility Care of Prisoner fees, Sheriff process fees, County Officer Fees and other miscellaneous fees Miscellaneous other revenue
EXPENDITURE HIGHLIGHTS Expenditures for the County total $25,855,333 which is approximately 7.9% under budget for the first three months of 2014. The year-to-date expenditures are also $3,790,064 or 12.8% less than the expenditures for this period last year.
Total Expenditures
30,000,000.00
25,000,000.00 20,000,000.00 15,000,000.00
10,000,000.00 5,000,000.00 -
2014 YTD $25,855,333
BUDGET $28,099,750
2013 YTD $29,645,397
Page 3
SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT
The following information shows Shawnee County First Quarter expenditures by category.
EXPENDITURES BY CATEGORY CATEGORY Public Safety, Judicial & Emergency Services Public Works Public Health & Human Services Recreation & Culture Debt Service Operational Services Total Expenditures
2014 YTD $
$
10,722,745 $ 1,947,892 3,775,701 3,830,380 1,292,477 4,286,139 25,855,333 $
BUDGET 11,161,804 $ 1,949,618 3,775,701 4,545,441 1,411,631 5,041,106 27,885,301 $
ACTUAL TO BUDGET
2013 YTD 11,269,316 $ 2,100,419 4,479,322 4,898,149 1,604,746 5,293,445 29,645,397 $
ACTUAL TO 2013
(439,059) $ (1,727) (1) (715,060) (119,155) (754,967) (2,029,968) $
(546,571) (152,527) (703,622) (1,067,769) (312,269) (1,007,306) (3,790,064)
This pie chart displays the expenditure categories based on their percentage of total County Expenditures.
MARCH 31, 2014 - YTD EXPENDITURES Operational Services 17% Debt Service 5%
Public Safety, Judicial & Emergency Services 41%
Recreation & Culture 15%
Public Health & Human Services 15%
Public Works 7%
Page 4
SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT
MARCH 2014 YEAR-TO-DATE EXPENDITURES BY DEPARTMENT DEPARTMENT SOCIAL SERVICE ALLOCATIONS DETENTION FACILITY SHERIFF PARKS & REC PUBLIC WORKS DISTRICT ATTORNEY CAPITAL OUTLAY INFORMATION TECHNOLOGY GENERAL EXPENSE DEBT SERVICE APPRAISER AUDIT FINANCE BOARD COUNTY COMMISSIONERS COUNSELOR COUNTY CLERK COURTS ELECTIONS EMERGENCY MANAGEMENT HUMAN RESOURCES MEDICAL EXAMINER NOXIOUS WEEDS PLANNING DEPARTMENT REGISTER OF DEEDS TREASURER TOTAL
2014 YTD $
$
5,157,450 $ 5,195,448 3,684,678 3,051,457 1,947,892 956,086 1,000,000 695,272 1,281,569 653,475 406,468 120,173 70,832 143,756 214,010 532,131 231,760 64,864 57,825 108,612 45,311 69,154 51,173 115,935 25,855,333 $
BUDGET YTD 5,026,808 $ 5,291,900 3,888,358 3,900,172 1,949,618 955,086 1,000,000 760,503 1,826,041 777,787 412,589 131,261 74,943 148,870 221,441 680,760 310,969 53,151 55,555 105,660 35,143 131,275 55,326 92,083 27,885,301 $
2013 YTD 6,061,428 5,255,520 3,880,468 4,257,723 2,100,419 882,451 1,000,000 804,630 2,304,014 719,836 412,620 124,603 76,166 143,970 231,460 598,047 234,425 64,405 58,573 104,901 60,812 119,405 59,532 89,989 29,645,397
Page 5
SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT
GENERAL FUND BALANCE The General Fund is the primary operating fund of the County. It accounts for the financial resources of the general government, except those required to be accounted for separately. The General Fund is also used to account for payments made for principal and interest on general long-term debt of the County. The General Fund Balance represents the unencumbered balance of general operating funds on a budgetary basis. Bond rating services generally recommend a general fund balance of 18-20% of budgeted expenditures to present a healthy level of reserves. It is the goal of the Board of County Commissioners to steadily increase this balance to the recommended level. This chart shows the General Fund Balance at the end of years 2003-2013. The recommended level is shown as 19% of expenditures.
GENERAL FUND BALANCE $20,000,000 $18,000,000 $16,000,000 $14,000,000 $12,000,000 $10,000,000 $8,000,000 $6,000,000 $4,000,000
General Fund 19% of Budget
$2,000,000 $-
Page 6