HomeMy WebLinkAboutItem 06City of Lakeville
Finance Department
Memorandum
To: Mayor and Council
Justin Miller, City Administrator
From: Jerilyn Erickson, Finance Director
Date: April 24, 2017
Subject: Financial Reports
A first quarter 2017 and a preliminary yearend 2016 financial report are attached for your
review. Both reports are unaudited.
The preliminary yearend 2016 report shows the variances from the amended budget as well
as the budget estimate. Conservative estimates for both revenues and expenditures were
used for the budget estimate since two to three months of activity would still occur at the
time the estimates were being prepared.
The estimated addition to the General Fund reserve at 12/31/2016 is $2.39 million which is
approximately $646,000 higher than estimated during the 2017 budget process. This results
in a 55.9% fund balance ratio which is higher than the 40-50% range established by City
policy.
Because a significant increase to the General Fund reserve was anticipated in 2016, Staff
recommended and the City Council approved a planned use of reserves for one-time or long-
term purchases as well as some items carried forward from 2016, grant-related expenses and
equipment transitions as part of the 2017 budget:
Comp Plan Updates $ 130,000
Facility Improvements $ 200,000
Equipment Replacement $ 945,000*
Carry Forward Items $ 123,805
DUI Grant Expenses $ 61,800
Equipment Transition, Etc. $ 17,917
Total $ 1,478,522
*This eliminated the need to issue debt for equipment replacement.
Taking into account this planned use of reserves, the fund balance ratio could be recalculated
to be 50.3%.
The Council may want to consider some options for committing some of the General Fund
reserves towards specific needs that were identified during the preparation of the 2017
budget as well as the 2017-2021 Capital Improvement Program. This would mitigate some of
the pressure on the 2018 tax levy. Some potential uses would include the following:
• Equipment Fund – currently projected to issue approximately $1.78 million in bonds in
2018 for vehicle/equipment replacement;
• Building Fund
• Park Improvement Fund
• Trail Improvement Fund
• Street Reconstruction Projects
• Pavement Management Fund
• Debt Levy Management
• Severance Payouts
In addition, Staff presented the City/Dakota Fiber Optic Network JPA project at the January
23, 2017 council workshop. This project is estimated at a cost of $650,000 and was not
reflected in the 2017 budget or the 2017-2021 CIP. The General Fund was identified as one of
the funding sources.
Staff will be starting the 2018 budget and 2018-2022 Capital Improvement Program updates
in the coming weeks. They will be reviewing the long-term plans to prioritize projects,
technology and equipment replacement, facility repairs, personnel needs, etc. as well as the
associated funding sources, which could include the use of General Fund reserves.
Attachments:
1) 2017 First Quarter Financial Report
2) 2016 Preliminary Yearend Financial Report
i
FINANCIAL HIGHLIGHTS:
The following financial report and analysis offers readers a narrative overview of the financial
activities of the City for the three-month period ended March 31, 2017. This report includes the
General Fund, Communications Fund, Liquor Fund and Utility Operating Funds. The readers are
encouraged to consider the information presented here in conjunction with the unaudited financial
statements attached to this report, the adopted budget and the five-year Capital Improvement Plan.
General Fund - Revenues
Property tax revenues
• Tax payments from Dakota County are received in two installments in June and
December. The General fund property tax revenues are anticipated to be $18.8 million
for 2017.
Licenses and Permits.
• Building permit revenue continues to be strong. The following chart shows how the
number of permits issued in the first quarter compares to the same period 2016 and the
2017 Adopted Budget:
First 2017 First
Quarter Adopted Quarter
Permit Type 2016 Budget 2017
Single Family 57 300 103
Townhome 14 50 7
Commercial 1 5 0
Intergovernmental.
• Revenues comprised of police and fire aid and various grants are typically received in the
third and fourth quarters.
Charges for Services.
• General government services are in line with budget estimates.
• Public Safety revenues are slightly below budget estimates due in large part to the fire
contract with Eureka Township which is billed out in June of the current year.
• Public works revenues are based on summer construction projects and therefore year-to-
date revenues are below the annual estimates.
ii
FINANCIAL HIGHLIGHTS (continued):
General Fund - Revenues (Continued)
Charges for Services.(Continued)
• Parks and Recreation revenues are exceeding budget estimates. The new RecTrac system
allocates revenues over the course of the program (accrual basis) versus in the year
registration occurred and funds were received (cash basis). As a result, revenues that
would normally have been recognized in 2016 are recognized in 2017.
Court Fines
• Revenues from court fines ($121,984) represent 39 percent of the budget estimates and
are up $11,000 over the period in 2016. The increase is a result of the police traffic unit. It
should be noted that this also increases the CAD call numbers used by the Dakota
Communications Center to allocate the membership fees which will increase Lakeville’s
share of the DCC cost in 2018.
General Fund - Expenditures
Personnel Services - Finance/Information Systems/Engineering. Personnel services for these
departments are in line with budget; however, these departments are exceeding the same
period 2016 due to positions that were hired after the first quarter 2016.
Motor Fuels – The new State of Minnesota fuel contract began February 2016. The
contracted price for unleaded and diesel fuel is $1.59 and $1.60, respectively. The budget
reflects these prices. Motor fuels through March 31, are at 22 percent of the 2017 Budget.
Fewer snow events for the public works departments also contributed to the low fuel
expense.
Street Chemicals – Costs for the first part of 2017 are at 51 percent of the budget. Unused
chemicals are stored at the central maintenance facility and will be utilized in the late fall if
needed.
Utilities – Electric & Natural Gas. Costs are fairly consistent with the same period in 2016. The
2017 adopted budget was reduced significantly to account for the trend of lower utility costs.
Total costs through the first quarter represent 25.5 percent of the adopted budget.
City Clerk-Elections. 2017 is the first year of licensing and maintenance on the new voting
tabulators.
iii
FINANCIAL HIGHLIGHTS (continued):
General Fund - Expenditures (continued)
Planning. Salaries are slightly below budget estimates due to the delay in hiring the new
Zoning Enforcement position which was anticipated for March 1st.
General Government Facilities. Personnel Services are up compared to 2016 due to the hiring
of the custodial staff did not take place until April 2016.
Information Systems. Numerous annual maintenance contracts are paid in the first quarter of
the year.
Operations & Maintenance. Personnel services are below budget estimates due to employee
vacancies.
Parks. Salary costs are down compared to budget due in part to the short rink season.
Recreation/Heritage Center. Personnel costs for Recreation are slightly below budget
whereas Heritage Center costs are exceeding budget. This is the result of an internal salary
allocation of an employee that spends a large part of time on facility rentals.
Communications Fund
Revenues from Franchise fees are received on a quarterly basis. They are typically received
by the end of the month following the quarter. As of the date of this report, the first quarter
franchise fees have not been received and the amount was estimated based on historical
numbers.
Expenses are down over last year at this time due to a $29,000 payment to CivicPlus for the
2016 Website modifications. Additional savings were realized due to the transition within the
Cable TV division.
Capital outlay acquisitions include replacement of two computer workstations, HD
Camcorders and office furniture.
iv
FINANCIAL HIGHLIGHTS (continued):
Liquor Fund
Sales for the first quarter amounted to $2.9 million which is a .4 percent decrease over the
same period in 2016. The decrease can be attributed to the Kenrick store being closed for 4
days due to renovations and Easter falling in the second quarter in 2017 vs. first quarter in
2016.
Total expenditures are tracking slightly below budget appropriations.
Capital outlay acquisitions include flooring replacement and store front sign at Kenrick. The
parking lot improvements ($145,000) will be pushed into 2018 since the project will not take
place during the Kenrick Avenue reconstruction. Capital outlay also includes new floor
scrubbers at Galaxie and Kenrick.
Water Fund
Water revenues are low in the first quarter which is typical for the first quarter, but are
exceeding revenues from the same period a year ago due mainly to the water rate increase
that went in affect February 1, 2017. Water usage increases as residents and businesses turn
on their irrigation systems in late spring.
Water main repair/replacement costs are projected to be $1.1 million for the 2017 street
reconstruction project.
Water meter replacement projects are anticipated to be $397,000 in which $25,000 has been
spent year-to-date.
Water tower cleaning and inspections are budgeted at $59,000, and well rehabilitations are
budgeted at $180,000.
v
FINANCIAL HIGHLIGHTS (continued):
Sewer Fund
Sewer revenues are tracking with budget expectations and are up over the same period in
2016 as a result of the increase in sewer rates for the base charge and discharge effective
February 1, 2017.
Expenditures are consistent with prior year and are below budget expectations as the
number of repairs has been lower than anticipated.
Major maintenance projects include lift station rehabilitations ($45,000); sewer line
improvements ($250,000) and I/I mitigation repairs ($250,000).
Street Lighting Fund
Revenues are in line with budget. Street light fees are also collected at the time of final plat;
$7,300 has been collected with final plats during the first quarter 2017.
Streetlight rates were increased effective February 1, 2017.
2016 electrical costs are in line with budget estimates.
Environmental Resources Fund
Revenues are tracking with budget estimates.
Rates were increased effective February 1, 2017.
Majority of projects are done in the spring, summer and fall months.
Unaudited
2017 2017 Variance from Variance from
Adopted Adopted 3/31/2017 Amended Budget Actual 3/31/2016 2016 Actual
Budget Budget Actual Positive (Negative)Percent Actual Positive (Negative)
Revenues
General property taxes 18,833,557$ 18,833,557$ 2,409$ (18,831,148)$ 0.0% 7,912$ (5,503)$ 30.4%
Licenses and permits 2,202,952 2,202,952 594,196 (1,608,756) 27.0% 396,941 197,255 149.7%
Intergovernmental 1,021,685 1,021,685 87,172 (934,513) 8.5% 36,915 50,257 236.1%
Charges for services 2,641,047 2,641,047 413,228 (2,227,819) 15.6% 337,251 75,977 122.5%
Court fines 315,000 315,000 121,984 (193,016) 38.7% 111,417 10,567 109.5%
Investment income 90,071 90,071 22,898 (67,174) 25.4% 10,016 12,882 228.6%
Miscellaneous 37,860 37,860 9,156 (28,704) 24.2%7,679 1,477 119.2%
Total revenues 25,142,172 25,142,172 1,251,043 (23,891,130) 5.0%908,131 342,912 137.8%
Expenditures
Mayor and Council 101,090 101,090 28,221 72,869 27.9% 27,844 (377) 101.4%
Committees and Commissions 75,660 75,660 6,522 69,138 8.6% 4,958 (1,564) 131.5%
City Administration 423,147 423,147 100,746 322,401 23.8% 103,813 3,067 97.0%
City Clerk 139,774 139,774 39,779 99,996 28.5% 29,282 (10,497) 135.8%
Legal Counsel 57,000 57,000 18,933 38,067 33.2% 10,788 (8,145) 175.5%
Planning 564,262 564,262 116,069 448,194 20.6% 112,834 (3,234) 102.9%
Community and Econ. Development 358,272 358,272 72,523 285,750 20.2% 69,939 (2,584) 103.7%
Inspections 1,061,584 1,061,584 271,431 790,153 25.6% 255,898 (15,533) 106.1%
General Government Facilities 529,611 529,611 133,313 396,299 25.2% 110,156 (23,157) 121.0%
Finance 759,615 759,615 189,556 570,059 25.0% 160,181 (29,374) 118.3%
Information Systems 620,742 620,742 211,257 409,485 34.0% 181,888 (29,370) 116.1%
Human Resources 520,626 520,626 125,576 395,051 24.1% 118,725 (6,850) 105.8%
Insurance 182,180 182,180 45,545 136,635 25.0% 45,545 - 100.0%
Police 10,493,244 10,493,244 2,597,470 7,895,774 24.8% 2,573,296 (24,174) 100.9%
Fire 1,788,770 1,788,770 338,508 1,450,263 18.9% 353,273 14,765 95.8%
Engineering 1,005,397 1,005,397 181,504 823,893 18.1% 140,832 (40,672) 128.9%
Operations and Maintenance 664,477 664,477 50,737 613,740 7.6% 120,914 70,177 42.0%
Streets 3,276,483 3,276,483 982,104 2,294,380 30.0% 812,401 (169,702) 120.9%
Parks 2,541,925 2,541,925 507,186 2,034,739 20.0%496,025 (11,161) 102.3%
Recreation 672,981 672,981 146,419 526,562 21.8% 129,982 (16,436) 112.6%
Heritage Center 95,822 95,822 26,082 69,740 27.2% 19,915 (6,167) 131.0%
Arts Center 502,337 502,337 173,490 328,847 34.5% 136,775 (36,715) 126.8%
Other - - - - 0.0%- - 0.0%
Total expenditures 26,434,999 26,434,999 6,362,968 20,072,031 24.1%6,015,265 (347,703) 105.8%
Excess (deficiency) of revenues
over expenditures (1,292,827) (1,292,827) (5,111,926) (3,819,099) (5,107,134) (4,792)
Other financing sources (uses)
Transfer from other funds 782,655 782,655 195,664 (586,991) 25.0% 201,629 (5,965) 97.0%
Transfer to other funds (1,145,000) (1,145,000) (1,145,000) - 100.0%(50,000) (1,095,000) 2290.0%
Total other financing sources (uses) (362,345) (362,345) (949,336) (586,991) 151,629 (1,100,965) -626.1%
Net change in fund balance (1,655,172) (1,655,172) (6,061,262) (4,406,090) (4,955,505) (1,105,757)
Beginning fund balance 14,121,784 14,121,784 14,768,257 646,473 12,374,928 2,393,329
Ending fund balance 12,466,612$ 12,466,612$ 8,706,995$ (3,759,617)$ 7,419,423$ 1,287,572$
Net change in fund balance percentage (11.7%)(11.7%)(41.0%)(40.0%)
Ratio: Fund balance to CY expenditures 47.2%47.2%136.8%123.3%
General Fund
Summary Statement of Revenues, Expenditures and Changes in Fund Balances
For the Three Month Period Ended March 31, 2017
Comparative
1
Unaudited
General Fund
Schedule of Expenditures
2017 2017 Variance from Variance from
Adopted Amended 3/31/2017 Amended Budget Actual 3/31/2016 2016 Actual
Expenditures Budget Budget Actual Positive (Negative)Percent Actual Positive (Negative)
Mayor and Council
Personnel services 49,151$ 49,151$ 13,371$ 35,780$ 27% 12,974$ (397)$ 103.1%
Commodities 50 50 - 50 0% - - 0.0%
Other charges and services 51,889 51,889 14,850 37,039 29%14,870 20 99.9%
Total 101,090 101,090 28,221 72,869 28%27,844 (377) 101.4%
Committees/Commissions
Personnel services 61,412 61,412 490 60,922 1% 415 (75) 117.9%
Commodities 1,530 1,530 - 1,530 0% - - 0.0%
Other charges and services 12,718 12,718 6,032 6,686 47%4,543 (1,489) 132.8%
Total 75,660 75,660 6,522 69,138 9%4,958 (1,564) 131.5%
City Administration
Personnel services 404,834 404,834 96,371 308,463 24% 99,362 2,991 97.0%
Commodities 800 800 262 538 33% 86 (176) 304.7%
Other charges and services 17,513 17,513 4,113 13,400 23% 4,365 252 94.2%
Capital outlay - - - - 0%- - 0.0%
Total 423,147 423,147 100,746 322,401 24%103,813 3,067 97.0%
City Clerk
Personnel services 110,468 110,468 28,058 82,411 25% 27,693 (365) 101.3%
Commodities 200 200 - 200 0% 49 49 0.0%
Other charges and services 29,106 29,106 11,721 17,385 40% 1,540 (10,181) 761.1%
Capital outlay - - - - 0%- - 0.0%
Total 139,774 139,774 39,779 99,996 28%29,282 (10,497) 135.8%
Legal Counsel
Other charges and services 57,000 57,000 18,933 38,067 33%10,788 (8,145) 175.5%
Planning
Personnel services 505,012 505,012 108,275 396,738 21% 108,934 660 99.4%
Commodities 3,329 3,329 179 3,150 5% 131 (48) 136.6%
Other charges and services 55,921 55,921 7,615 48,306 14% 3,769 (3,846) 202.0%
Capital outlay - - - - 0%- - 0.0%
Total 564,262 564,262 116,069 448,194 21%112,834 (3,234) 102.9%
Community and Economic Development
Personnel services 284,506 284,506 69,523 214,984 24% 64,946 (4,577) 107.0%
Commodities 250 250 56 194 22% 60 4 93.3%
Other charges and services 73,516 73,516 2,944 70,572 4% 4,933 1,989 59.7%
Capital outlay - - - - 0%- - 0.0%
Total 358,272 358,272 72,523 285,750 20%69,939 (2,584) 103.7%
Inspection
Personnel services 830,402 830,402 205,353 625,049 25% 204,269 (1,084) 100.5%
Commodities 12,627 12,627 1,438 11,189 11% 3,012 1,574 47.7%
Other charges and services 218,555 218,555 64,640 153,915 30% 48,617 (16,023) 133.0%
Capital outlay - - - - 0%- - 0.0%
Total 1,061,584 1,061,584 271,431 790,153 26%255,898 (15,533) 106.1%
(continued)
Comparative
2
Unaudited
General Fund
Schedule of Expenditures
2017 2017 Variance from Variance from
Adopted Amended 3/31/2017 Amended Budget Actual 3/31/2016 2016 Actual
Expenditures (continued)Budget Budget Actual Positive (Negative)Percent Actual Positive (Negative)
General Government Facilities
Personnel services 332,817$ 332,817$ 80,881$ 251,937$ 24% 60,023$ (20,858)$ 134.7%
Commodities 22,907 22,907 8,076 14,831 35% 2,560 (5,516) 315.5%
Other charges and services 173,887 173,887 44,356 129,531 26%47,573 3,217 93.2%
Capital outlay - - - - 0%- - 0.0%
Total 529,611 529,611 133,313 396,299 25%110,156 (23,157) 121.0%
Finance
Personnel services 670,563 670,563 167,678 502,885 25% 140,629 (27,048) 119.2%
Commodities 4,229 4,229 1,311 2,918 31% 1,491 180 87.9%
Other charges and services 84,823 84,823 20,567 64,256 24% 18,061 (2,506) 113.9%
Capital outlay - - - - 0%- - 0.0%
Total 759,615 759,615 189,556 570,059 25%160,181 (29,374) 118.3%
Information Systems
Personnel services 391,170 391,170 95,184 295,986 24% 86,445 (8,740) 110.1%
Commodities 6,276 6,276 651 5,625 10% 3,008 2,357 21.6%
Other charges and services 223,296 223,296 115,422 107,874 52% 92,435 (22,987) 124.9%
Capital outlay - - - - 0%- - 0.0%
Total 620,742 620,742 211,257 409,485 34%181,888 (29,370) 116.1%
Human Resources
Personnel services 389,063 389,063 102,695 286,369 26% 92,009 (10,685) 111.6%
Commodities 1,340 1,340 694 646 52% 112 (582) 619.6%
Other charges and services 130,223 130,223 22,187 108,036 17% 25,256 3,069 87.8%
Capital outlay - - - - 0%1,348 1,348 0.0%
Total 520,626 520,626 125,576 395,051 24%118,725 (6,850) 105.8%
Insurance
Other charges and services 182,180 182,180 45,545 136,635 25%45,545 - 100.0%
Police
Personnel services 8,220,190 8,220,190 1,938,582 6,281,608 24% 1,893,983 (44,599) 102.4%
Commodities 411,866 411,866 118,722 293,144 29% 138,559 19,837 85.7%
Other charges and services 1,861,188 1,861,188 540,166 1,321,022 29% 532,254 (7,912) 101.5%
Capital outlay - - - - 0%8,500 8,500 0.0%
Total 10,493,244 10,493,244 2,597,470 7,895,774 25%2,573,296 (24,174) 100.9%
Fire
Personnel services 1,005,382 1,005,382 244,519 760,864 24% 243,566 (953) 100.4%
Fire Relief Contribution/State Aid 343,039 343,039 - 343,039 0% 3,000 3,000 0.0%
Commodities 153,922 153,922 24,739 129,183 16% 31,784 7,045 77.8%
Other charges and services 286,427 286,427 69,250 217,177 24% 74,923 5,673 92.4%
Capital outlay - - - - 0%- - 0.0%
Total 1,788,770 1,788,770 338,508 1,450,263 19%353,273 14,765 95.8%
(continued)
Comparative
3
Unaudited
General Fund
Schedule of Expenditures
2017 2017 Variance from Variance from
Adopted Amended 3/31/2017 Amended Budget Actual 3/31/2016 2016 Actual
Expenditures (continued)Budget Budget Actual Positive (Negative)Percent Actual Positive (Negative)
Engineering
Personnel services 704,482$ 704,482$ 170,382$ 534,100$ 24% 130,640$ (39,742)$ 130.4%
Commodities 8,766 8,766 2,363 6,403 27% 725 (1,638) 325.9%
Other charges and services 292,149 292,149 8,759 283,390 3% 8,325 (434) 105.2%
Capital outlay - - - - 0%1,142 1,142 0.0%
Total 1,005,397 1,005,397 181,504 823,893 18%140,832 (40,672) 128.9%
Operations and Maintenance
Personnel services 614,951 614,951 49,593 565,358 8% 114,053 64,460 43.5%
Commodities 7,723 7,723 441 7,282 6% 1,244 803 35.5%
Other charges and services 14,318 14,318 703 13,615 5% 3,069 2,366 22.9%
Capital outlay 27,485 27,485 - 27,485 0%2,548 2,548 0.0%
Total 664,477 664,477 50,737 613,740 8%120,914 70,177 42.0%
Streets
Personnel services 2,011,988 2,011,988 523,144 1,488,845 26% 525,635 2,492 99.5%
Commodities 912,051 912,051 422,611 489,440 46% 243,034 (179,577) 173.9%
Other charges and services 352,444 352,444 36,349 316,095 10% 43,732 7,383 83.1%
Capital outlay - - - - 0%- - 0.0%
Total 3,276,483 3,276,483 982,104 2,294,380 30%812,401 (169,702) 120.9%
Parks
Personnel services 1,785,414 1,785,414 383,748 1,401,666 21% 375,212 (8,536) 102.3%
Commodities 277,283 277,283 53,787 223,496 19% 44,528 (9,259) 120.8%
Other charges and services 475,478 475,478 69,651 405,827 15% 76,285 6,634 91.3%
Capital outlay 3,750 3,750 - 3,750 0%- - 0.0%
Total 2,541,925 2,541,925 507,186 2,034,739 20%496,025 (11,161) 102.3%
Recreation
Personnel services 393,149 393,149 88,404 304,745 22% 77,744 (10,659) 113.7%
Commodities 35,483 35,483 2,903 32,580 8% 1,517 (1,386) 191.4%
Other charges and services 244,349 244,349 55,112 189,237 23% 48,021 (7,091) 114.8%
Capital outlay - - - - 0%2,700 2,700 0.0%
Total 672,981 672,981 146,419 526,562 22%129,982 (16,436) 112.6%
Heritage Center
Personnel services 34,274 34,274 15,966 18,308 47% 9,637 (6,329) 165.7%
Commodities 12,663 12,663 2,694 9,969 21% 661 (2,033) 407.6%
Other charges and services 48,885 48,885 7,422 41,463 15% 9,617 2,195 77.2%
Capital outlay - - - - 0%- - 0.0%
Total 95,822 95,822 26,082 69,740 27%19,915 (6,167) 131.0%
Arts Center
Personnel services 269,762 269,762 69,716 200,046 26% 62,019 (7,697) 112.4%
Commodities 33,750 33,750 10,576 23,174 31% 8,003 (2,573) 132.2%
Other charges and services 189,925 189,925 84,055 105,870 44% 64,508 (19,547) 130.3%
Capital outlay 8,900 8,900 9,143 (243) 103%2,245 (6,898) 407.3%
Total 502,337 502,337 173,490 328,847 35%136,775 (36,715) 126.8%
Comparative
4
Unaudited
2017 Percent
Adopted of
Budget Actual Variance Budget
Revenues
Licenses franchise fee 676,131$ 169,000$ (507,131)$ 25.0%
PEG Fees 61,296 15,339 (45,957) 25.0%
Intergovernmental State aid 516 - (516) 0.0%
Investment income 3,497 797 (2,700) 22.8%
Total revenues 741,440 185,136 (556,304) 25.0%
Expenditures - General government
Personnel services 358,759 76,879 281,880 21.4%
Commodities 6,260 5,496 764 87.8%
Other charges and services 156,544 31,968 124,576 20.4%
Capital outlay 107,579 17,733 89,846 16.5%
Total expenditures 629,142 132,076 497,066 21.0%
Excess (deficiency) of revenues over expenditures 112,298 53,060 (59,238) 47.2%
Other financing (uses) - Transfers
To General Fund (75,429) (18,857) 56,572 25.0%
Total other financing (uses)(75,429) (18,857) 56,572 25.0%
Net change in fund balance 36,869 34,202 (2,667)
Beginning fund balance 285,483 318,696 33,213
Ending fund balance 322,352$ 352,898$ 30,546$
CITY OF LAKEVILLE, MINNESOTA
Statement of Revenues, Expenditures and Changes in Fund Balances
For the Three Month Period Ended March 31, 2017
Special Revenue - Communications Fund
5
Unaudited
2017 Percent Variance from
Adopted 3/31/2017 of 3/31/2016 2016 Actual
Budget Actual Variance Budget Actual Positive (Negative)
Sales and cost of sales
Sales 14,045,802$ 2,876,860$ (11,168,942)$ 20.5% 2,886,956$ (10,096)$ 99.7%
Cost of sales 10,605,816 2,172,191 8,433,625 20.5%2,215,493 43,302 98.0%
Gross profit 3,439,986 704,669 (2,735,317) 20.5%671,463 33,206 104.9%
Operating expenses
Personnel services 1,443,341 373,880 1,069,462 25.9% 345,075 (28,805) 108.3%
Commodities 70,710 12,224 58,486 17.3% 10,817 (1,407) 113.0%
Other charges and services 857,233 167,481 689,752 19.5% 197,340 29,859 84.9%
Depreciation 116,465 29,116 87,349 25.0%28,690 (426) 101.5%
Total operating expenses 2,487,749 582,701 1,905,048 23.4%581,922 (779) 100.1%
Operating income 952,237 121,968 (830,269) 12.8%89,541 32,427 136.2%
Non-operating revenue (expense)
Investment income 3,744 417 (3,327) 11.1% 6,325 (5,908) 6.6%
Miscellaneous 7,500 - (7,500) 0.0% - - 0.0%
Interest and bond expense (125,959) (31,490) 94,469 25.0% (33,854) 2,364 93.0%
Transfers in (out)
General Fund (198,819) (49,705) 149,114 25.0% (43,243) (6,462) 114.9%
Debt Service:
CIP Bonds-Police Station (346,360) (346,360) - 100.0% (400,000) 53,640 86.6%
Capital Projects:
Equipment Fund - - - 0.0% (500,000) 500,000 0.0%
Enterprise Fund:
Environmental Resources - Recycling (2,275) - 2,275 0.0%- - 0.0%
Total non-operating (net)(662,169) (427,138) 235,031 64.5%(970,772) 543,634 44.0%
Change in net position 290,068 (305,170) (595,238) (881,231) 576,061
Beginning net position 4,017,732 4,177,607 159,875 5,103,267 (925,660)
Ending net position 4,307,800$ 3,872,437$ (435,363)$ 4,222,036$ (349,599)$
Comparative
CITY OF LAKEVILLE, MINNESOTA
Enterprise - Liquor Fund
Statement of Revenues, Expenditures and Changes in Net Assets
For the Three Month Period Ended March 31, 2017
6
Unaudited
2017 Percent
Adopted of
Budget Actual Variance Budget
Operating revenues
User charges for services 4,377,242$ 630,685$ (3,746,557)$ 14.4%
Other 160,488 25,923 (134,565) 16.2%
Total operating revenue 4,537,730 656,608 (3,881,122) 14.5%
Operating expenses
Personnel services 1,090,312 280,721 809,591 25.7%
Commodities 348,183 56,217 291,966 16.1%
Other charges and services 1,239,664 191,348 1,048,316 15.4%
Major Maintenance 1,731,019 - 1,731,019 0.0%
Total operating expenses 4,409,178 528,286 3,880,892 12.0%
Operating income (loss)128,552 128,322 (230)
Non-operating revenue (expense)
Intergovernmental 1,632 - (1,632) 0.0%
Investment income 18,016 7,973 (10,043) 44.3%
Disposal of assets 10,000 - (10,000) 0.0%
Capital outlay (107,242) (2,472) 104,770 2.3%
Bond proceeds 1,094,952 - (1,094,952) 0.0%
Debt Service (759,668) (18,645) 741,023 2.5%
Transfers in (out)(139,244) (34,811) 104,433 25.0%
Total non-operating (net)118,446 (47,955) (166,401) -40.5%
Change in working capital 246,998 80,367 (166,631)
Beginning working capital 4,556,045 6,451,219 1,895,174
Ending working capital 4,803,043$ 6,531,586$ 1,728,543$
CITY OF LAKEVILLE, MINNESOTA
Statement of Revenues, Expenditures and Changes in Net Assets
For the Three Month Period Ended March 31, 2017
Enterprise - Utility Fund Water Operation
7
Unaudited
2017 Percent
Adopted of
Budget Actual Variance Budget
Operating revenue
User charges for services 5,638,031$ 1,416,592$ (4,221,439)$ 25.1%
Operating expenses
Personnel services 817,174 177,535 639,639 21.7%
Commodities 89,742 19,312 70,430 21.5%
Other charges and services 322,728 91,583 231,145 28.4%
Disposal charges 3,509,576 877,395 2,632,181 25.0%
Major maintenance projects 545,000 - 545,000 0.0%
Total operating expenses 5,284,220 1,165,825 4,118,395 22.1%
Operating income (loss)353,811 250,767 (103,044)
Non-operating revenue (expense)
Intergovernmental State aid 1,632 - (1,632) 0.0%
Investment income 11,388 6,000 (5,388) 52.7%
Disposal of assets 24,000 - (24,000) 0.0%
Capital outlay (332,947) (2,472) 330,475 0.7%
Bond proceeds - - - 0.0%
Debt service (21,425) (1,821) 19,604 8.5%
Transfers in 23,873 23,873 - 100.0%
Transfers (out)(143,628) (35,907) (107,721) 25.0%
Total non-operating (net)(437,107) (10,327) 426,780 2.4%
Change in working capital (83,296) 240,440 323,736
Beginning working capital 1,361,527 2,321,568 960,041
Ending working capital 1,278,231$ 2,562,008$ 1,283,777$
CITY OF LAKEVILLE, MINNESOTA
Statement of Revenues, Expenditures and Changes in Net Assets
For the Three Month Period Ended March 31, 2017
Enterprise - Utility Fund Sanitary Sewer Operation
8
Unaudited
2017 Percent
Adopted of
Budget Actual Variance Budget
Operating revenue
User charges for services 810,000$ 207,299$ (602,701)$ 25.6%
Operating expenses
Personnel services 18,262 2,801 15,461 15.3%
Commodities 31 12 19 39.4%
Other charges and services 723,984 178,759 545,225 24.7%
Major Maintenance 400,000 - 400,000 0.0%
Total operating expenses 1,142,277 181,571 960,706 15.9%
Operating income (loss)(332,277) 25,728 358,005
Non-operating revenue (expense)
Investment income 1,608 750 (858) 46.6%
Bond proceeds 400,000 - (400,000) 0.0%
Transfers in (out) - General Fund (4,384) (1,096) 3,288 25.0%
Total non-operating (net)397,224 (346) (397,570) -0.1%
Change in working capital 64,947 25,382 (39,565)
Beginning working capital 271,334 318,786 47,452
Ending working capital 336,281$ 344,168$ 7,887$
CITY OF LAKEVILLE, MINNESOTA
Statement of Revenues, Expenditures and Changes in Net Assets
For the Three Month Period Ended March 31, 2017
Enterprise - Utility Fund Street Light Operation
9
Unaudited
2017 Percent
Adopted of
Budget Actual Variance Budget
Revenues
User charges for services 983,370$ 247,587$ (735,783)$ 25.2%
Charges for services - Recycling 4,642 - (4,642) 0.0%
Total revenues 988,012 247,587 (450,416) 25.1%
Expenditures - Public works
Personnel services 311,912 75,860 236,052 24.3%
Commodities 32,894 16,381 16,513 49.8%
Other charges and services 858,548 29,219 829,329 3.4%
Total expenditures 1,203,354 121,460 1,081,894 10.1%
Excess (deficiency) of revenues over expenditures (215,342) 126,127 341,469
Non-operating revenue (expense)
Intergovernmental 125,000 - (125,000) 0.0%
Investment income 5,965 2,500 (3,465) 41.9%
Transfers in (out)0.0%
General Fund (168,094) (42,024) 126,071 25.0%
Equipment Fund (31,000) (31,000) - 100.0%
Storm Sewer Trunk Fund 110,000 (110,000) (220,000) -100.0%
Liquor Fund 2,275 - (2,275) 0.0%
Sanitary sewer operations (23,873) (23,873) - 100.0%
Total other financing (uses)20,273 (204,397) (224,670) -1008.2%
Change in working capital (195,069) (78,269) 116,800
Beginning working capital 433,220 1,334,775 901,555
Ending working capital 238,151$ 1,256,506$ 1,018,355$
CITY OF LAKEVILLE, MINNESOTA
Statement of Revenues, Expenditures and Changes in Net Assets
For the Three Month Period Ended March 31, 2017
Enterprise - Utility Fund Environmental Resources Operation
10
i
FINANCIAL HIGHLIGHTS:
The following financial report and analysis offers readers a narrative overview of the financial
activities of the City for the year ended December 31, 2016. This report only covers the General Fund.
Readers should take note that this information is preliminary as the City’s annual audit has not
been completed and some amounts may be estimated as the final audit work is still being
completed. The readers are encouraged to consider the information presented here in conjunction
with the unaudited financial statements attached to this report, the adopted budget and the five-year
Capital Improvement Plan.
General Fund - Revenues
Property tax revenues
• General property taxes were below budget estimates by $74,000 due in part to tax
appeals and a change in how delinquent taxes are recorded. All delinquent taxes are
recorded in the General Fund and the other funds receive 100 percent of the levy. Tax
payments from Dakota County were received in June and December, with the final
settlement received in January, 2017.
Licenses and Permits.
• Licenses and Permits exceeded budget estimates by $294,000. Building permit revenue
continues to be strong exceeding 2015 by 13.3 percent. The following chart shows the
2015 actual number of building permits as well as a comparison of the 2016 budget to
actual.
Permit Type
2015
Actual
2016
Budget
2016
Estimate
2016
Actual
Single Family 361 300 350 389
Townhome 59 21 70 76
Commercial 11 4 10 10
Intergovernmental.
• Intergovernmental revenues exceeded budget estimates by $23,000 due to increases in
public safety grant funding for programs such as traffic safety, DUI Officer and Firefighter
Training grants.
ii
General Fund - Revenues (Continued)
Charges for Services.
• Charges and services exceeded budget estimates by $188,000.
• General government services revenues exceeded budget estimates by $80,000 due
largely to increases in planning activities from new development plans and a one-time
payment of $15,000 from the Pan-O-Prog committee for 2016.
• Public safety revenues exceeded budget estimates by $37,000 due to significant
forfeiture sales during the fall auction. Revenues from forfeiture sales have restrictions as
to what they can be spent on.
• Public works revenues for engineering related services in connection with developer
construction administration, inspection and GIS exceeded budget estimates by $76,000.
Revenues of $1,339,000 have been recognized from City improvement projects.
• Parks and Recreation program revenues exceeded the adopted budget, but fell short of
budget estimates by $39,000. The new RecTrac system allocates revenues over the
course of a program (accrual basis) versus in the year registration occurred and funds
were received (cash basis). Park and Heritage Center rentals exceeded estimates by
approximately $9,600 and $11,000, respectively.
Court Fines
• Revenues from court fines ($406,000) exceeded 2015 actual by $37,000. The budget
estimates of $466,000 were overstated due to a duplicate adjustment during the prior
budget cycle.
Investment Revenue and Miscellaneous
• Investment revenue exceeded budget estimates by $31,000. Interest earnings for the
General Fund amounted to $71,000. This is comprised of investment earning, deduction
for the market value adjustment, 2016 premium/discounts and interest from the
interfund loan associated with Post Consumer Brands. Miscellaneous revenues exceed
budget estimates by $41,000 due to donations received by local youth sports associations
as well as $20,000 for the new K-9 Officer.
General Fund - Expenditures
Personnel Services – Personnel services of $18,000,000 were under budget estimates by
$12,000. Savings in the Street Department from another mild fall and savings in Engineering
due to two vacant positions helped offset the overage incurred by the Police Department
resulting from increased overtime.
iii
General Fund - Expenditures (continued)
Motor Fuels – Motor fuels were $63,000 under budget and $76,000 under the 2016 revised
estimates as prices continue to stay low as well as a lower number of snow events.
Utilities – Natural Gas. Actual costs were below the amended budget by $66,000 and
exceeded the 2016 revised estimates by $3,000. Natural gas costs continue to be low, but the
budget anticipates these costs to trend upward in the coming years.
City Administration. Expenditures for personnel services were $11,000 under budget
estimates as a result of the transitional saving after the retirement of the Administrative
Assistant.
Inspections. Expenditures for two building demolitions exceeded budget estimates by
$46,000. City staff is currently pursuing whether the City can assess these costs back to the
properties.
Information Systems. Other charges and services were under budget estimates by $36,000 as
the department continues to review its current software and related annual maintenance
costs.
Human Resources. Appropriations for city-wide training were not utilized in 2016.
Police Department. The Police Department is the largest General Fund department.
Personnel services exceeded budget estimates by $72,000 as a result of unanticipated
overtime. This overage was offset by $50,000 savings in the other charges and services due in
part by savings in attorney fees, utilities and rental of the shooting range.
Engineering Department. Personnel services are trailing budget as a result of transitions
within the department staff. Other charges and services within the Engineering Department
were $21,000 below budget estimates as a result of traffic studies and the CR 70 arterial
study not completed in 2016.
Streets. As a result of the fewer snow events during 2016 which impacts both personnel
services and commodities, the department was $256,000 under budget and $91,000 under
the 2015 budget estimates.
iv
General Fund - Fund Balance
Fund Balance. During the adoption of the 2017 Budget, the 2016 Fund balance was projected
to be $14,121,000. The actual fund balance is anticipated to be $14,768,000. That is a
$647,000 increase resulting from the previous discussions above. The estimated fund balance
ratio is 55.9% which exceeds the 40-50% range established by City policy. After taking into
account the $1,478,522 planned use of reserves for the 2017 budget, the fund balance ratio
could be recalculated to be 50.3%.
Unaudited
2016 2016 Variance from 12/31/2016
Adopted Amended 12/31/2016 Amended Budget Actual Budget 12/31/2016 Change From
Budget Budget Actual Positive (Negative)Percent Estimate Actual Budget Estimate
Revenues
General property taxes 18,553,538$ 18,553,538$ 18,479,360$ (74,178)$ 99.6% 18,558,250$ 18,479,360$ (78,890)$
Licenses and permits 1,855,528 1,905,528 3,008,050 1,102,522 157.9% 2,714,492 3,008,050 293,558
Intergovernmental 988,816 998,216 1,019,297 21,081 102.1% 996,652 1,019,297 22,645
Charges for services 3,149,629 3,199,629 3,576,429 376,800 111.8% 3,421,571 3,576,429 154,858
Court fines 315,000 315,000 406,269 91,269 129.0% 466,000 406,269 (59,731)
Investment income 40,376 40,376 71,327 30,951 176.7% 40,000 71,327 31,327
Miscellaneous 41,645 57,806 71,673 13,867 124.0%38,145 71,673 33,528
Total revenues 24,944,532 25,070,093 26,632,405 1,562,312 106.2%26,235,110 26,632,405 397,295
Expenditures
Mayor and Council 99,866 99,866 97,000 2,866 97.1% 98,983 97,000 1,983
Committees and Commissions 71,284 84,784 83,944 840 99.0% 84,840 83,944 896
City Administration 413,336 432,341 414,386 17,955 95.8% 425,602 414,386 11,216
City Clerk 195,441 197,752 193,838 3,914 98.0% 193,826 193,838 (12)
Legal Counsel 78,178 78,178 56,533 21,645 72.3% 55,340 56,533 (1,193)
Planning 458,036 466,731 452,197 14,534 96.9% 465,616 452,197 13,419
Community and Econ. Development 297,952 303,857 292,608 11,249 96.3% 304,927 292,608 12,319
Inspections 1,000,761 1,121,013 1,156,350 (35,337) 103.2% 1,110,440 1,156,350 (45,910)
General Government Facilities 427,117 483,178 479,465 3,713 99.2% 482,236 479,465 2,771
Finance 718,826 735,662 681,109 54,553 92.6% 690,181 681,109 9,072
Information Systems 543,979 602,583 565,594 36,989 93.9% 601,749 565,594 36,155
Human Resources 490,511 534,845 502,406 32,439 93.9% 528,370 502,406 25,964
Insurance 182,180 182,180 182,180 - 100.0% 182,180 182,180 -
Police 9,693,385 9,820,907 9,824,512 (3,605) 100.0% 9,805,833 9,824,512 (18,679)
Fire 1,753,089 1,751,383 1,714,102 37,281 97.9% 1,722,947 1,714,102 8,845
Engineering 785,343 799,876 673,021 126,855 84.1% 735,030 673,021 62,009
Operations and Maintenance 652,545 662,012 479,352 182,660 72.4% 489,201 479,352 9,849
Streets 3,321,247 3,352,649 3,096,853 255,796 92.4% 3,187,886 3,096,853 91,033
Parks 2,442,197 2,462,056 2,310,224 151,832 93.8%2,319,631 2,310,224 9,407
Recreation 622,974 636,654 598,885 37,769 94.1% 629,951 598,885 31,066
Heritage Center 98,770 110,777 96,594 14,183 87.2% 85,399 96,594 (11,195)
Arts Center 479,173 499,614 499,436 178 100.0% 499,599 499,436 163
Other 562,501 119,771 - 119,771 0.0%- - -
Total expenditures 25,388,691 25,538,669 24,450,589 1,088,080 95.7%24,699,767 24,450,589 249,178
Excess (deficiency) of revenues
over expenditures (444,159) (468,576) 2,181,816 2,650,392 1,535,343 2,181,816 148,117
Other financing sources (uses)
Transfer from other funds 806,513 806,513 806,513 - 100.0% 806,513 806,513 -
Transfer to other funds (50,000) (595,000) (595,000) - 100.0%(595,000) (595,000) -
Total other financing sources (uses) 756,513 211,513 211,513 - 211,513 211,513 -
Net change in fund balance 312,354 (257,063) 2,393,329 2,650,392 1,746,856 2,393,329 646,473
Beginning fund balance 11,406,277 12,374,928 12,374,928 - 12,374,928 12,374,928 -
Ending fund balance 11,718,631$ 12,117,865$ 14,768,257$ 2,650,392$ 14,121,784$ 14,768,257$ 646,473$
Net change in fund balance percentage 2.7%(2.1%)19.3%
Ratio: Fund balance to CY expenditures 46.2%47.4%60.4%57.2%
Ratio: Fund balance to NY expenditures 55.9%53.4%
Ratio: Fund balance after NY use of reserves 50.3%47.8%
General Fund
Summary Statement of Revenues, Expenditures and Changes in Fund Balances
For the Twelve Month Period Ended December 31, 2016
Comparative
1
Unaudited
General Fund
Schedule of Expenditures
2016 2016 Variance from 12/31/2016
Adopted Amended 12/31/2016 Amended Budget Actual Budget 12/31/2016 Change From
Expenditures Budget Budget Actual Positive (Negative)Percent Estimate Actual Budget Estimate
Mayor and Council
Personnel services 49,139$ 49,139$ 48,428$ 711$ 99% 48,502 48,428 74
Commodities 50 50 33 17 66% 50 33 17
Other charges and services 50,677 50,677 48,539 2,138 96%50,431 48,539 1,892
Total 99,866 99,866 97,000 2,866 97%98,983 97,000 1,983
Committees/Commissions
Personnel services 57,592 64,592 64,019 573 99% 64,437 64,019 418
Commodities 1,530 1,530 1,342 188 88% 1,530 1,342 188
Other charges and services 12,162 18,662 18,583 79 100%18,873 18,583 290
Total 71,284 84,784 83,944 840 99%84,840 83,944 896
City Administration
Personnel services 388,023 407,028 390,508 16,520 96% 401,087 390,508 10,579
Commodities 800 800 2,464 (1,664) 308% 2,550 2,464 86
Other charges and services 17,513 17,513 14,598 2,915 83% 17,513 14,598 2,915
Capital outlay 7,000 7,000 6,816 184 97%4,452 6,816 (2,364)
Total 413,336 432,341 414,386 17,955 96%425,602 414,386 11,216
City Clerk
Personnel services 108,929 111,240 114,487 (3,247) 103% 117,247 114,487 2,760
Commodities 2,282 2,282 965 1,317 42% 1,500 965 535
Other charges and services 76,230 76,230 78,386 (2,156) 103% 75,079 78,386 (3,307)
Capital outlay 8,000 8,000 - 8,000 0%- - -
Total 195,441 197,752 193,838 3,914 98%193,826 193,838 (12)
Legal Counsel
Other charges and services 78,178 78,178 56,533 21,645 72%55,340 56,533 (1,193)
Planning
Personnel services 396,771 405,466 403,698 1,768 100% 406,927 403,698 3,229
Commodities 3,230 3,230 1,754 1,476 54% 3,378 1,754 1,624
Other charges and services 56,857 56,857 46,745 10,112 82% 55,311 46,745 8,566
Capital outlay 1,178 1,178 - 1,178 0%- - -
Total 458,036 466,731 452,197 14,534 97%465,616 452,197 13,419
Community and Economic Development
Personnel services 265,372 271,277 275,908 (4,631) 102% 272,347 275,908 (3,561)
Commodities 250 250 473 (223) 189% 830 473 357
Other charges and services 31,750 31,750 15,895 15,855 50% 31,750 15,895 15,855
Capital outlay 580 580 332 248 57%- 332 (332)
Total 297,952 303,857 292,608 11,249 96%304,927 292,608 12,319
Inspection
Personnel services 792,349 822,601 822,567 34 100% 826,989 822,567 4,422
Commodities 10,834 10,834 8,545 2,289 79% 10,206 8,545 1,661
Other charges and services 196,328 286,328 324,317 (37,989) 113% 271,995 324,317 (52,322)
Capital outlay 1,250 1,250 921 329 74%1,250 921 329
Total 1,000,761 1,121,013 1,156,350 (35,337) 103%1,110,440 1,156,350 (45,910)
(continued)
Comparative
2
Unaudited
General Fund
Schedule of Expenditures
2016 2016 Variance from 12/31/2016
Adopted Amended 12/31/2016 Amended Budget Actual Budget 12/31/2016 Change From
Expenditures (continued)Budget Budget Actual Positive (Negative)Percent Estimate Actual Budget Estimate
General Government Facilities
Personnel services 209,098$ 288,830$ 299,273$ (10,443)$ 104% 286,033 299,273 (13,240)
Commodities 22,728 22,728 11,791 10,937 52% 23,262 11,791 11,471
Other charges and services 195,291 171,620 168,401 3,219 98% 172,941 168,401 4,540
Capital outlay - - - - 0%- - -
Total 427,117 483,178 479,465 3,713 99%482,236 479,465 2,771
Finance
Personnel services 635,701 652,537 606,841 45,696 93% 607,737 606,841 896
Commodities 4,958 4,958 2,456 2,502 50% 4,355 2,456 1,899
Other charges and services 78,167 78,167 70,464 7,703 90% 76,741 70,464 6,277
Capital outlay - - 1,348 (1,348) 0%1,348 1,348 -
Total 718,826 735,662 681,109 54,553 93%690,181 681,109 9,072
Information Systems
Personnel services 323,655 382,259 379,543 2,716 99% 381,321 379,543 1,778
Commodities 5,196 5,196 6,585 (1,389) 127% 5,293 6,585 (1,292)
Other charges and services 215,128 215,128 179,466 35,662 83% 215,135 179,466 35,669
Capital outlay - - - - 0%- - -
Total 543,979 602,583 565,594 36,989 94%601,749 565,594 36,155
Human Resources
Personnel services 379,455 423,789 426,729 (2,940) 101% 438,833 426,729 12,104
Commodities 1,340 1,340 2,106 (766) 157% 1,340 2,106 (766)
Other charges and services 109,716 109,716 72,223 37,493 66% 86,849 72,223 14,626
Capital outlay - - 1,348 (1,348) 0%1,348 1,348 -
Total 490,511 534,845 502,406 32,439 94%528,370 502,406 25,964
Insurance
Other charges and services 182,180 182,180 182,180 - 100%182,180 182,180 -
Police
Personnel services 7,592,958 7,712,219 7,782,173 (69,954) 101% 7,710,620 7,782,173 (71,553)
Commodities 346,623 347,779 320,457 27,322 92% 323,780 320,457 3,323
Other charges and services 1,753,804 1,740,358 1,696,439 43,919 97% 1,746,914 1,696,439 50,475
Capital outlay - 20,551 25,443 (4,892) 124%24,519 25,443 (924)
Total 9,693,385 9,820,907 9,824,512 (3,605) 100%9,805,833 9,824,512 (18,679)
Fire
Personnel services 998,930 1,007,843 957,245 50,598 95% 962,965 957,245 5,720
Fire Relief Contribution/State Aid 316,515 316,515 345,276 (28,761) 109% 345,276 345,276 -
Commodities 139,128 139,128 133,151 5,977 96% 137,956 133,151 4,805
Other charges and services 298,516 287,897 278,430 9,467 97%276,750 278,430 (1,680)
Capital outlay - - - - 0%- - -
Total 1,753,089 1,751,383 1,714,102 37,281 98%1,722,947 1,714,102 8,845
(continued)
Comparative
3
Unaudited
General Fund
Schedule of Expenditures
2016 2016 Variance from 12/31/2016
Adopted Amended 12/31/2016 Amended Budget Actual Budget 12/31/2016 Change From
Expenditures (continued)Budget Budget Actual Positive (Negative)Percent Estimate Actual Budget Estimate
Engineering
Personnel services 642,916$ 657,449$ 629,849$ 27,600$ 96% 659,940 629,849 30,091
Commodities 8,924 8,924 7,100 1,824 80% 8,163 7,100 1,063
Other charges and services 122,171 122,171 34,930 87,241 29% 55,785 34,930 20,855
Capital outlay 11,332 11,332 1,142 10,190 10%11,142 1,142 10,000
Total 785,343 799,876 673,021 126,855 84%735,030 673,021 62,009
Operations and Maintenance
Personnel services 594,248 603,715 461,795 141,920 76% 466,086 461,795 4,291
Commodities 7,283 7,283 5,421 1,862 74% 6,317 5,421 896
Other charges and services 15,141 15,141 9,125 6,016 60% 13,787 9,125 4,662
Capital outlay 35,873 35,873 3,011 32,862 8%3,011 3,011 -
Total 652,545 662,012 479,352 182,660 72%489,201 479,352 9,849
Streets
Personnel services 1,915,919 1,954,340 1,883,420 70,920 96% 1,914,796 1,883,420 31,376
Commodities 1,037,288 1,037,288 934,468 102,820 90% 970,176 934,468 35,708
Other charges and services 368,040 361,021 278,965 82,056 77%302,914 278,965 23,949
Capital outlay - - - - 0%- - -
Total 3,321,247 3,352,649 3,096,853 255,796 92%3,187,886 3,096,853 91,033
Parks
Personnel services 1,648,678 1,675,556 1,579,523 96,033 94% 1,580,203 1,579,523 680
Commodities 277,377 277,377 240,988 36,389 87% 243,642 240,988 2,654
Other charges and services 511,767 504,748 489,372 15,376 97% 492,696 489,372 3,324
Capital outlay 4,375 4,375 341 4,034 8%3,090 341 2,749
Total 2,442,197 2,462,056 2,310,224 151,832 94%2,319,631 2,310,224 9,407
Recreation
Personnel services 370,418 364,098 339,295 24,803 93% 345,512 339,295 6,217
Commodities 27,572 27,572 28,399 (827) 103% 32,644 28,399 4,245
Other charges and services 224,206 244,206 227,913 16,293 93% 242,037 227,913 14,124
Capital outlay 778 778 3,278 (2,500) 421%9,758 3,278 6,480
Total 622,974 636,654 598,885 37,769 94%629,951 598,885 31,066
Heritage Center
Personnel services 33,752 45,759 47,893 (2,134) 105% 34,170 47,893 (13,723)
Commodities 12,627 12,627 3,576 9,051 28% 5,888 3,576 2,312
Other charges and services 52,391 52,391 45,125 7,266 86% 45,341 45,125 216
Capital outlay - - - - 0%- - -
Total 98,770 110,777 96,594 14,183 87%85,399 96,594 (11,195)
Arts Center
Personnel services 258,719 264,160 257,632 6,528 98% 257,164 257,632 (468)
Commodities 23,410 23,410 34,019 (10,609) 145% 26,428 34,019 (7,591)
Other charges and services 195,864 210,864 203,307 7,557 96% 210,552 203,307 7,245
Capital outlay 1,180 1,180 4,478 (3,298) 379%5,455 4,478 977
Total 479,173 499,614 499,436 178 100%499,599 499,436 163
Comparative
4