SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT
3/31/2016
QUARTERLY FINANCIAL REPORT A financial summary of the first three months of 2016
SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT
SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT FIRST QUARTER 2016
EXECUTIVE SUMMARY INTRODUCTION The following quarterly financial report provides an analysis of the first three months of the 2016 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 2016. 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 2016. 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 $48,590,745 during the first three months of 2016. This represents 0.12% over the budgeted amount for this period.
$50,000,000 Other Revenue
$40,000,000 $30,000,000
Other Taxes
$20,000,000 $10,000,000 $-
Property Taxes
2016 YTD $48,590,745
BUDGET YTD $48,469,809
2015 YTD $48,400,385
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 72% of the County’s revenue in 2015.
$50,000,000 $40,000,000 $30,000,000 $20,000,000 $10,000,000 $-
2016 YTD $42,256,478
BUDGET YTD $42,631,754
2015 YTD $41,472,933
The largest portion of Ad Valorem taxes are received in January and June when real estate taxes are distributed to the taxing authorities.
Other Taxes Other taxes include the following:
$4,000,000 $3,500,000 $3,000,000 $2,500,000 $2,000,000 $1,500,000 $1,000,000 $500,000 $-
2016 YTD $3,758,785
BUDGET YTD $3,349,962
2015 YTD $3,900,237
• • • • • • • •
Motor Vehicle Tax RV Tax Special Assessments Local Alcohol Liquor Tax Highway Tax Franchise Tax 1620 Truck Tax Other Misc. Taxes
Other Revenue Other revenue includes the following: •
•
•
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
$3,500,000 $3,000,000 $2,500,000 $2,000,000 $1,500,000 $1,000,000 $500,000 $-
2016 YTD $2,575,482
BUDGET YTD $2,488,093
2015 YTD $3,027,215
Page 2
SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT
EXPENDITURE HIGHLIGHTS Expenditures for the County total $23,538,667 which is approximately 0.83% under budget for the first three months of 2016. The year-to-date expenditures are also $1,171,874 or 4.74% less than the expenditures for this period last year. TOTAL YEAR-TO-DATE EXPENDITURES $25,000,000
DEBT SERVICE
$20,000,000
PARKS & REC
$15,000,000
PUBLIC WORKS
$10,000,000
ADMIN. SERVICES
$5,000,000 $0
PUBLIC HEALTH
YTD $23,538,667
BUDGET YTD $24,371,758
PUBLIC SAFETY
PRIOR YTD $24,710,541
The following information shows Shawnee County First Quarter expenditures by category. CATEGORY
YTD $23,538,667
BUDGET YTD $24,371,758
PUBLIC SAFETY $ 9,213,007 $ PUBLIC HEALTH 3,600,583 ADMIN. SERVICES 3,300,197 PUBLIC WORKS 2,323,041 PARKS & REC 3,632,052 DEBT SERVICE 1,469,787 $ 23,538,667 $
PRIOR YTD $24,710,541
9,999,883 $ 3,596,140 3,309,247 2,338,414 3,562,301 1,565,773 24,371,758 $
YTD BUDGET VARIANCE
10,492,373 $ 3,595,462 3,481,768 2,408,827 3,593,282 1,138,829 24,710,541 $
(786,876) $ 4,443 (9,050) (15,373) 69,751 (95,986) (833,091) $
MONTH BUDGET VARIANCE
YTD VARIANCE TO PRIOR YTD
(229,970) $ (2,221) 93,886 (46,501) (134,621) (319,428) $
(1,279,366) 5,121 (181,571) (85,786) 38,770 330,959 (1,171,874)
This pie chart displays the expenditure categories based on their percentage of total County Expenditures. DEBT SERVICE 6%
PARKS & REC 16% PUBLIC WORKS 10%
ADMIN. SERVICES 14%
PUBLIC SAFETY 39%
PUBLIC HEALTH 15%
Page 3
SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT
MARCH 2016 YEAR-TO-DATE EXPENDITURES BY DEPARTMENT DEPARTMENT ADMINISTRATIVE SERVICES GENERAL EXPENSES CONTINGENCY CAPTIAL OUTLAY AUDIT FINANCE BOARD OF COUNTY COMMISSIONERS COUNSELOR COUNTY CLERK ELECTIONS FACILITIES MANAGEMENT HUMAN RESOURCES INFORMATION TECHNOLOGY TREASURER TOTAL - ADMINISTRATIVE SERVICES PUBLIC SAFETY DEPARTMENT OF CORRECTIONS DISTRICT ATTORNEY DISTRICT COURTS DRUG COURT EMERGENCY MANAGEMENT SAFE STREETS SHERIFF TOTAL - PUBLIC SAFETY PUBLIC WORKS APPRAISER PLANNING DEPARTMENT PUBLIC WORKS REGISTER OF DEEDS TOTAL - PUBLIC WORKS PUBLIC HEALTH AMBULANCE ANIMAL SHELTER COMMUNITY RESOURCES CONSERVATION DISTRICT CORONER HEALTH AGENCY HEALTHACCESS EXTENSION COUNCIL MENTAL HEALTH - VALEO MENTAL RETARDATION - TARC SERVICE PROGRAMS FOR THE ELDERLY SOCIAL SERVICE GRANTS TOTAL - PUBLIC HEALTH PARKS & RECREATION EXPOCENTRE FAIR ASSOCIATION PARKS & RECREATION NOXIOUS WEEDS TOTAL - PARKS & RECREATION DEBT SERVICE BOND DEBT SERVICE COP DEBT SERVICE TOTAL - DEBT SERVICE TOTAL
2016 YTD
YTD BUDGET
2015 YTD
598,476 1,000,000 127,296 69,971 127,547 187,359 176,564 158,203 38,438 726,417 89,927
584,554 1,000,000 125,183 66,298 135,575 206,768 194,417 151,921 61,636 674,081 108,814
648,562 1,000,000 129,774 75,982 161,765 222,799 283,603 139,157 57,173 653,752 109,200
3,300,197
3,309,247
3,481,768
4,482,078 887,603 484,640 15,000 59,611 7,500 3,276,575
5,022,019 869,634 597,616 15,000 75,237 7,500 3,412,877
5,187,965 978,189 517,472 15,000 64,966 5,000 3,723,782
9,213,007
9,999,883
10,492,373
393,198 56,663 1,825,602 47,578
384,434 78,693 1,828,218 47,069
431,468 66,197 1,852,751 58,410
2,323,041
2,338,414
2,408,827
316,399 60,000 17,533 20,500 133,886 1,025,445 50,000 286,756 813,256 467,843 305,500 103,466
316,399 55,557 17,533 20,500 133,886 1,025,445 50,000 286,756 813,256 467,843 305,500 103,466
372,649 58,100 16,533 20,000 127,064 1,085,798 50,000 276,756 763,256 437,843 291,500 95,966
3,600,583
3,596,140
3,595,462
866,973 30,500 2,687,528 47,050
822,224 30,500 2,654,341 55,235
899,909 30,000 2,591,660 71,713
3,632,052
3,562,301
3,593,282
491,712 978,075
587,580 978,192
613,511 525,318
1,469,787
1,565,773
1,138,829
23,538,667
24,371,758
24,710,541
Page 4
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 actual general fund balance at the end of years 2003-2015 and the estimated balance at the end of 2016. The target minimum is shown at 19% of budgeted expenditures.
General Fund Reserves 35,000,000 30,000,000 25,000,000 Reserves
20,000,000 15,000,000
Target Minimum
10,000,000 5,000,000 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 Est 2016
Page 5