051214 acc support docs

24
TENTATIVE AGENDA CITY OF AUBURN MONTHLY COUNCIL MEETINGMay 12, 2014 COUNCIL ROOM-City Hall-- 6:00 p.m. Meeting is Open to the Public 1. Open and Roll Call 2. Approval of Agenda 3. Approval of the Consent Agenda a. Minutes of the April 14 2014 Council meeting b. Treasurer’s Report, Monthly Financial Report c. Claims and Payroll d. Sheriff’s Reports 4. Public Hearing- FY2014 Budget Amendment Action Items 5. Consider/Approve Public Works Summer Projects a. Alley gravel b. Approve Cost of Tree removal-110 E. Second St. 6. Consider Fire Station use policy 7. Resolution Approving Budget Amendment 8. Nuisance Abatement-junk, junk vehicle or other abatement survey 9. Consider Children Playing Signage 10. Approve Street Closing- 11. Approve Purchase of stove 12. Public Forum: This is an opportunity for any citizen to come forward and discuss any item that is not listed on the Agenda. Please limit comment to no more than 5 minutes. 13. Discussion Items and Reports Public Works City Clerk Sac Co. Solid Waste Board Sheriff Department Mayor and Council 14.) Adjourn- Next Council Meeting will be June 9, 2014 at 6:00 PM in City Hall.

Upload: thesacnews

Post on 28-Apr-2017

217 views

Category:

Documents


2 download

TRANSCRIPT

Page 1: 051214 ACC Support Docs

TENTATIVE AGENDA

CITY OF AUBURN MONTHLY COUNCIL MEETING—May 12, 2014

COUNCIL ROOM-City Hall-- 6:00 p.m. Meeting is Open to the Public

1. Open and Roll Call 2. Approval of Agenda 3. Approval of the Consent Agenda a. Minutes of the April 14 2014 Council meeting b. Treasurer’s Report, Monthly Financial Report c. Claims and Payroll d. Sheriff’s Reports 4. Public Hearing- FY2014 Budget Amendment

Action Items 5. Consider/Approve Public Works Summer Projects

a. Alley gravel b. Approve Cost of Tree removal-110 E. Second St.

6. Consider Fire Station use policy 7. Resolution Approving Budget Amendment 8. Nuisance Abatement-junk, junk vehicle or other abatement survey 9. Consider Children Playing Signage 10. Approve Street Closing- 11. Approve Purchase of stove 12. Public Forum: This is an opportunity for any citizen to come forward and discuss any item that is not listed

on the Agenda. Please limit comment to no more than 5 minutes.

13. Discussion Items and Reports

Public Works City Clerk Sac Co. Solid Waste Board Sheriff Department Mayor and Council

14.) Adjourn- Next Council Meeting will be June 9, 2014 at 6:00 PM in City Hall.

Page 2: 051214 ACC Support Docs

Attached is the information needed for the Council meeting on Monday

night. The sheriff’s report was sent to you last week. There are not a

lot of bills at this time, so look for updates. If you have additional

items for the agenda, I need them right away.

Alley Gravel- I have attached pricing for that project. It is estimated

that it will take about 30 tons per alley for a depth of 3”. We have 14

alleys, 300’ in length. Total cost of delivered road gravel from Mohr’s

concrete at this depth will be approximately $4400.00. I was hoping we

could do the entire town for under $5000 and it looks like we can.

Tree removal- there is a very dangerous tree on the Hale property on E.

Second St. Drive by and you can see daylight thru the crack that runs to

the ground. It is NOT our tree, but this is abandoned property and we

have no choice but to take care of it. We are attempting to get prices

from 3 companies, but this MUST be authorized on Monday. We will then

assess the cost to the property and hope someday to get our money. (tree

is located just SE of the house)

I have attached the copy of the fire station policy that came back from

the Fire department. You will note that they desire to take all control

away from the City Council on a building the city owns.

Budget amendment- this is the second and is necessary to keep us legal.

Larger projects earlier in the budget year have made significant changes

and the additional costs of the power line re-build need to be added to

this amendment. Also, this is the last chance to do it legally. We may

not need this, but I don’t want to find out later that we did.

Nuisance Abatement- I am not proposing that we have any issues, I am

asking if you want to canvas the town for any that need to be abated. If

so, then decide what our procedure will be.

A resident on Spruce street has asked that the city put up “children

playing” signage.

The Green family is requesting permission to close Walnut St from Third

to Fourth on May 31st for their auction.

The old, non-working stove in the basement went on the recycling truck.

Do we want to place a new one there or leave a whole in the kitchen.

Cost estimate is around $350-$400.

Page 3: 051214 ACC Support Docs

Minutes Auburn City Council City Hall April 14, 2014 Mayor Verdi Maunu called the regular monthly meeting of the City Council to order at 6:00 PM with council members Jane Barto, Janelle King, Cindy Finley, Randy Schulte and Justin Potthoff present. Employees: Gerry Blessington and Nancy Janssen. Motion by Barto, seconded by Potthoff to approve the agenda. All voted Aye. Motion by King, seconded by Finley to approve the consent agenda which included the minutes of the March 10, 2014 meeting, Treasurer’s, Sheriff’s and financial reports and the following claims and payroll. Voting Aye: King, Potthoff, Barto, Finley and Schulte. Al's Corner propane $433.98

Sac Co. Solid Waste Landfill $1,771.00

Auburn Feed snow $12.75

Sac Co Ambulance Fire Dept. $84.00

Baker & Taylor Library $110.78

Stewart, Donetta library $41.62

Barco Sign $124.54

Taste of Home library $30.98

Center Point Books library $44.34

The Hartford Fire Dept. $187.50

Cornbelt Power transmission $647.20

Tiefenthaler Ag Lime Rock $133.96

CRS Hauling garbage pick up $1,000.00

Tiefenthaler Bldg comm bldg $131.85

Echo Group Electrical $590.64

Tri-County Special publishing $67.08

EFTPS 941 Tax $1,511.36

US Cellular cell phone $44.41

Fleet Fueling Shop/Fire $314.23

USTI Office supplies $374.95

Gaylord Historical $170.42

Utility Service Co. water tower $661.65

Haley Equipment shop $57.25

Wal Mart library $55.25

Hawkins chlorine $177.80

WAPA power $1,978.52

IA Dept of Revenue Sales Tax $906.00

Windstream Phone $143.05

IA Dept of Revenue Withholding $721.00

WECC energy effic. $50.00

IPERS employ benefits $1,028.94

Total Claims

$33,393.99

Janssen, Nancy Mileage $210.64

March Payroll

$7,249.54

Jr Library Guild Library $183.00 LC Flowers Donation $42.80

Rec Mangold Envir. water $56.00

Artworx Soccer $1,463.00

Martins Welding shop equip 3245.75

Uptown Sporting Soccer $890.95

Maunu, Verdi Mileage $100.75

Ludwig, Jason Santa $52.01

Presto X Company pest control $36.26

Walmart Soccer $198.77

Raccoon Valley REC power $12,898.02

Oriental Trading Easter $222.03

Reiling Electric electric $60.00

IA Savings Conc. Change $200.00

Sac Co. Sheriff contract $2,953.72

Rec Total

$3,026.76

Motion by Barto, seconded by Schulte to leave the existing fence in place at the yard waste site, post the rules and revisit the issue if the rules are not followed. All voted Aye. Motion by Schulte, seconded by Finley to approve the purchase of necessary landscaping supplies at the best price possible. All voted Aye. Motion by Barto, seconded by King to obtain quotes for road gravel to repair and maintain the alleys. All voted Aye. Motion by Barto, seconded by King to approve up to $10000 to have The Pavement Doctor make repairs to the most needed streets. Voting Aye: King, Barto, Finley, Potthoff and Schulte. Motion by Barto, seconded by Potthoff to extend the lease on the City-owned property with Martin’s Welding to December 31, 2014 with an added clause specifying that all items in his care or possession be kept from the right-of-way adjacent to his property. Voting Aye: Barto, Potthoff, Finley and Schulte. Abstain: King. Motion by Schulte, seconded by Barto to allow the City Clerk to work with Midwest Recovery to address recycling issues with the City-wide Clean Up day. All voted Aye. Library will begin their new hours on June 1. Staff, Board and Council reports were heard. Motion to adjourn by Barto at 7:17 PM.

Page 4: 051214 ACC Support Docs

Current Change Operating Amounts Held

FUND Previous Received Disbursed Fund from Prev Funds In Long-Term

Balance Balance Month Investment(CD)

GENERAL -$6,307.08 $5,085.17 $7,036.22 -$8,258.13 -$1,951.05 -$23,679.23 $15,421.10

Historical Comm. $18,167.26 $18,167.26 $18,167.26 $0.00

Library Trust $7,654.81 $806.12 $8,460.93 $806.12 $3,609.14 $4,851.79

Rec Committee $12,613.88 $540.06 $1,285.50 $11,868.44 -$745.44 $6,765.00 $5,103.44

Event Comm $0.00 $0.00

LOST $24,570.46 $1,690.29 $26,260.75 $1,690.29 $26,260.75

EMPLY BEN LEVY $526.21 $224.15 $750.36 $224.15 $750.36

EMERGENCY LEVY $759.77 $34.04 $793.81 $34.04 $793.81

ROAD USE TAX $25,086.94 $3,021.24 $1,339.87 $26,768.31 $1,681.37 $26,768.31

WATER UTILITY $13,290.81 $5,158.59 $3,358.05 $15,091.35 $1,800.54 $15,091.35

SEWER Operating $3,523.10 $2,396.86 $1,028.82 $4,891.14 $1,368.04 $4,891.14

ELECTRIC UTILITY $192,948.07 $22,089.42 $63,598.13 $151,439.36 -$41,508.71 -$7,842.02 $159,281.38

GARBAGE/RECYCL. -$1,571.92 $1,590.08 $1,009.25 -$991.09 $580.83 -$991.09

TOTAL CASH $291,262.31 $42,636.02 $78,655.84 $255,242.49 -$36,019.82 $70,584.78 $184,657.71

YARD WASTE SITE RULES

1. The City yard waste site is for use by Auburn residents only and only yard waste from properties within the City limits may be taken to the yard waste site.

2. Keys for the yard waste site must be checked out at city hall during regular business hours. 3. Keys may be checked out for a maximum of 24 hours and may be returned to the utility

payment drop box. 4. Persons in possession of a key to the site are responsible for any or all dumping that may

occur during their possession and will be held accountable for the same fine as those caught performing an illegal act at this site.

5. Only yard waste such as grass clippings, weeds, flowers, mulch, garden waste, leaves, small brush and branches no larger than 12” in diameter may be left at the site. A site will be available for larger tree debris if needed.

6. All yard waste must be removed from transport containers, including plastic bags and the containers/bags must be removed from the site.

7. The City reserves the right to refuse use of the yard waste site to any resident abusing use of the site and/or for breaking the afore mentioned rules.

8. A fine in the amount of $250.00 plus the cost of cleanup, removal and disposal of the illegal material will be required from anyone caught dumping non-yard waste items at this site.

Page 5: 051214 ACC Support Docs

City of Auburn Statement of Revenue and Expenditures5/8/2014 9:08am Page 1 Revised Budget For General Fund (001) For the Fiscal Period 2014-10 Ending April 30, 2014

Current Current Annual YTD Remaining Account Number Budget Actual Budget Actual Budget %

Revenues

Taxes Revenues

General Revenues 001-100-004-0001 Property Tax 2,934.17 $ 11,130.78 $ 35,210.00 $ $ 33,511.23 4.82% 001-100-004-0003 Ag Land Tax 40.92 207.33 491.00 490.54 0.09% 001-100-004-0005 Utility Replacement Tax 356.75 0.00 4,281.00 1,757.09 58.96% 001-100-004-0006 FICA /Ipers/Empl Benefit Levy 0.00 1,318.80 0.00 6,381.68 0.00% 001-100-004-0007 Liab Ins Levy 661.58 2,509.73 7,939.00 7,537.39 5.06% 001-100-004-1000 Local Option Sales Tax 0.00 0.00 0.00 0.00 0.00% 001-100-004-1006 Cable Franchise 83.33 264.01 1,000.00 1,070.86 (7.09%) Total General Revenues 4,076.75 15,430.65 48,921.00 50,748.79 (3.74%)

Total Taxes Revenues 4,076.75 15,430.65 48,921.00 50,748.79 (3.74%)

Licenses/Permits Revenues

General Revenues 001-200-004-1005 Cigarette Permits 0.00 0.00 75.00 0.00 100.00% 001-200-004-1100 Beer & Liquor Permits 0.00 0.00 500.00 465.00 7.00% 001-200-004-1200 Pet License 0.00 0.00 400.00 205.00 48.75% Total General Revenues 0.00 0.00 975.00 670.00 31.28%

Total Licenses/Permits Revenues 0.00 0.00 975.00 670.00 31.28%

Use of Money/Property Revenues

General Revenues 001-300-004-1310 Park Rent 62.50 80.00 750.00 440.00 41.33% 001-300-004-1311 Community Bldg Rent 100.00 140.00 1,200.00 1,118.00 6.83% 001-300-004-4800 Interest- Checking/ CD 12.50 9.80 150.00 218.02 (45.35%) Total General Revenues 175.00 229.80 2,100.00 1,776.02 15.43%

Total Use of Money/Property Revenues 175.00 229.80 2,100.00 1,776.02 15.43%

Intergovernmental Revenues

General Revenues 001-400-004-1340 Reimbursements 41.67 0.00 500.00 2,645.41 (429.08%) 001-400-004-1341 Township Fire Dept Reimbursement 250.00 80.94 3,000.00 2,695.86 10.14% 001-400-004-1342 Other Misc. Revenue 41.67 7.50 500.00 98.99 80.20% 001-400-004-1343 Donations 0.00 0.00 0.00 0.00 0.00% 001-400-004-1501 Project Grant Revenue 0.00 0.00 0.00 0.00 0.00% Total General Revenues 333.34 88.44 4,000.00 5,440.26 (36.01%)

Total Intergovernmental Revenues 333.34 88.44 4,000.00 5,440.26 (36.01%)

Culture/Recreation Revenues

Library Trust Revenues 001-401-400-1476 Library Trust Revenue 208.33 55.15 2,500.00 1,831.89 26.72% Total Library Trust Revenues 208.33 55.15 2,500.00 1,831.89 26.72%

Page 6: 051214 ACC Support Docs

City of Auburn Statement of Revenue and Expenditures5/8/2014 9:08am Page 2 Revised Budget For General Fund (001) For the Fiscal Period 2014-10 Ending April 30, 2014

Current Current Annual YTD Remaining Account Number Budget Actual Budget Actual Budget %

Library Revenues 001-401-401-1470 Library-County Funding 0.00 0.00 14,250.00 10,694.25 24.95% 001-401-401-1472 Library-other State Funds 58.33 0.00 700.00 957.88 (36.84%) 001-401-401-1475 Grants 0.00 0.00 0.00 0.00 0.00% 001-401-401-1476 Library-Misc Revenue 3.33 0.00 40.00 4.40 89.00% Total Library Revenues 61.66 0.00 14,990.00 11,656.53 22.24%

Recreation Committee Revenues 001-401-404-1343 Rec CD Interest 0.00 0.00 100.00 8.99 91.01% 001-401-404-4500 Soccer 1,066.66 40.00 3,200.00 4,401.00 (37.53%) 001-401-404-4530 Other Donations/Fund Raising 8.33 0.00 100.00 0.00 100.00% 001-401-404-4540 Concession Revenue 666.67 833.00 2,000.00 1,103.00 44.85% 001-401-404-4700 Other Revenue/Activites 8.33 0.00 100.00 0.03 99.97% 001-401-404-4800 Interest on Checking Account 0.00 0.05 0.00 0.36 0.00% Total Recreation Committee Revenues 1,749.99 873.05 5,500.00 5,513.38 (0.24%)

Historical Committee Revenues 001-401-405-4530 Historical Revenue 696.67 100.00 8,360.00 7,890.00 5.62% Total Historical Committee Revenues 696.67 100.00 8,360.00 7,890.00 5.62%

125th Celebration Revenues 001-401-406-4530 Event Comm- Car Show Revenue 0.00 0.00 0.00 4,490.22 0.00% Total 125th Celebration Revenues 0.00 0.00 0.00 4,490.22 0.00%

Total Culture/Recreation Revenues 2,716.65 1,028.20 31,350.00 31,382.02 (0.10%)

Total General Fund Revenues 7,301.74 $ 16,777.09 $ 87,346.00 $ $ 90,017.09 (3.06%)

Expenditures

Public Safety Expenditures

General Expenditures 001-101-004-6310 Fire-Building Maint/Repair 20.83 $ 0.00 $ 250.00 $ $ 0.00 100.00% 001-101-004-6406 Fire- Liability Insurance 0.00 0.00 750.00 0.00 100.00% 001-101-004-6407 Fire-Work Comp Insurance 0.00 187.50 3,500.00 187.50 94.64% 001-101-004-6408 Fire Dept-Property Insurance 0.00 0.00 1,200.00 0.00 100.00% 001-101-004-6409 Janitorial Expense 29.17 29.09 350.00 125.93 64.02% 001-101-004-6410 Fire-Vehicle Insurance 0.00 0.00 1,750.00 1,016.50 41.91% Total General Expenditures 50.00 216.59 7,800.00 1,329.93 82.95%

Fire Expenditures 001-101-101-6230 Fire-Training 83.33 0.00 1,000.00 150.00 85.00% 001-101-101-6331 Fire-Vehicle Operations 125.00 0.00 1,500.00 676.42 54.91% 001-101-101-6332 Fire-Vehicle Repairs 41.67 0.00 500.00 1,842.04 (268.41%) 001-101-101-6350 Fire-Operational Equipment Repair 41.67 0.00 500.00 851.00 (70.20%) 001-101-101-6351 Fire Equipment- New 166.67 0.00 2,000.00 24.00 98.80% 001-101-101-6352 Fire- Misc. Exp 41.67 84.00 500.00 84.00 83.20% Total Fire Expenditures 500.01 84.00 6,000.00 3,627.46 39.54%

Page 7: 051214 ACC Support Docs

City of Auburn Statement of Revenue and Expenditures5/8/2014 9:08am Page 3 Revised Budget For General Fund (001) For the Fiscal Period 2014-10 Ending April 30, 2014

Current Current Annual YTD Remaining Account Number Budget Actual Budget Actual Budget %

Police Expenditures 001-101-102-6406 Police-Liability Insurance 0.00 0.00 150.00 0.00 100.00% 001-101-102-6413 Police 28E agreement 3,600.00 2,953.72 14,400.00 12,461.16 13.46% Total Police Expenditures 3,600.00 2,953.72 14,550.00 12,461.16 14.36%

Pet Ordinance Expenditures 001-101-103-6402 Pet License 29.17 0.00 350.00 357.39 (2.11%) 001-101-103-6403 Pet Ordinance Enforcement 16.67 0.00 200.00 0.00 100.00% Total Pet Ordinance Expenditures 45.84 0.00 550.00 357.39 35.02%

Total Public Safety Expenditures 4,195.85 3,254.31 28,900.00 17,775.94 38.49%

Pubilc Works Expenditures

General Expenditures 001-201-004-6379 Storm Sewer 41.67 0.00 500.00 0.00 100.00% 001-201-004-6399 Vegetation Management 125.00 0.00 1,500.00 1,360.00 9.33% 001-201-004-6417 Street Maintenance Expense 0.00 0.00 0.00 0.00 0.00% Total General Expenditures 166.67 0.00 2,000.00 1,360.00 32.00%

Shop Expenditures 001-201-201-6310 Shop-Building Maint/Repair 41.67 0.00 500.00 0.00 100.00% 001-201-201-6331 Shop-Vehicle Operations 250.00 314.23 3,000.00 1,976.41 34.12% 001-201-201-6332 Shop-Vehicle Repairs 250.00 57.25 3,000.00 1,589.87 47.00% 001-201-201-6408 Shop-Insurance Expense 0.00 0.00 2,400.00 0.00 100.00% 001-201-201-6499 Shop-Cell Phone 58.33 44.41 700.00 434.31 37.96% 001-201-201-6505 Shop Misc. 8.33 0.00 100.00 454.95 (354.95%) 001-201-201-6507 Shop-Operating Supplies 250.00 95.75 3,000.00 740.85 75.31% 001-201-201-6511 Equipment Purchase 1,166.67 3,150.00 14,000.00 3,150.00 77.50% Total Shop Expenditures 2,025.00 3,661.64 26,700.00 8,346.39 68.74%

Total Pubilc Works Expenditures 2,191.67 3,661.64 28,700.00 9,706.39 66.18%

Health/Social Services Expenditures

General Expenditures 001-301-004-6499 Mosquito Control 0.00 0.00 1,000.00 800.00 20.00% Total General Expenditures 0.00 0.00 1,000.00 800.00 20.00%

Total Health/Social Services Expenditures 0.00 0.00 1,000.00 800.00 20.00%

Culture/Recreation Expenditures

General Expenditures 001-401-000-6310 Rec-Building Maint/Repair 0.00 0.00 0.00 0.00 0.00% 001-401-000-6320 Rec-Grounds Maint/Repair 0.00 0.00 0.00 245.00 0.00% 001-401-000-6371 Rec-Gas/Elect Expense 0.00 8.96 0.00 8.96 0.00% 001-401-000-6406 Rec-Liability Insurance 0.00 0.00 100.00 0.00 100.00% 001-401-000-6408 Rec-Property Insurance 0.00 0.00 350.00 0.00 100.00% 001-401-000-6499 Rec-Annual Payment 0.00 0.00 200.00 0.00 100.00% 001-401-000-6599 Supplies 0.00 0.00 0.00 0.00 0.00%

Page 8: 051214 ACC Support Docs

City of Auburn Statement of Revenue and Expenditures5/8/2014 9:08am Page 4 Revised Budget For General Fund (001) For the Fiscal Period 2014-10 Ending April 30, 2014

Current Current Annual YTD Remaining Account Number Budget Actual Budget Actual Budget %

Total General Expenditures 0.00 8.96 650.00 253.96 60.93%

General Expenditures 001-401-004-6310 Library-Building Maint/Repair 41.67 0.00 500.00 543.48 (8.70%) 001-401-004-6371 Library-Gas/Elect Expense 100.00 144.66 1,200.00 1,213.54 (1.13%) 001-401-004-6373 Library-Telecommunications Expense 70.83 67.16 850.00 657.87 22.60% 001-401-004-6406 Library-Liability Insurance 0.00 0.00 300.00 0.00 100.00% 001-401-004-6408 Library-Property Insurance Expense 0.00 0.00 1,400.00 0.00 100.00% 001-401-004-6409 Janitorial Expense- 29.17 0.00 350.00 224.60 35.83% Total General Expenditures 241.67 211.82 4,600.00 2,639.49 42.62%

General Expenditures 001-401-005-6310 Historical-Bldg 41.67 0.00 500.00 0.00 100.00% 001-401-005-6371 Historical-Utility Expense 104.17 144.66 1,250.00 1,168.87 6.49% 001-401-005-6406 Historical-Liability Insurance 0.00 0.00 100.00 0.00 100.00% 001-401-005-6408 Historical-Property Insurance Expense 0.00 0.00 650.00 0.00 100.00% Total General Expenditures 145.84 144.66 2,500.00 1,168.87 53.25%

Library Trust Expenditures 001-401-400-6505 Library Trust Expense 208.33 0.00 2,500.00 0.00 100.00% Total Library Trust Expenditures 208.33 0.00 2,500.00 0.00 100.00%

Library Expenditures 001-401-401-5500 Computer Grant 0.00 0.00 0.00 1,107.98 0.00% 001-401-401-6020 Library-Wages-Part Time 904.42 825.53 10,853.00 8,481.34 21.85% 001-401-401-6110 Library-FICA 60.42 64.09 725.00 627.68 13.42% 001-401-401-6130 Library-IPERS 62.50 74.79 750.00 730.25 2.63% 001-401-401-6407 Library-Work Comp Insurance 0.00 0.00 50.00 0.00 100.00% 001-401-401-6500 Computer Expense 19.17 0.00 230.00 311.92 (35.62%) 001-401-401-6501 Programming 83.33 7.23 1,000.00 352.47 64.75% 001-401-401-6502 Library-Books 181.83 369.10 2,182.00 2,744.05 (25.76%) 001-401-401-6503 Library-Magazines/Newspaper 41.67 0.00 500.00 468.96 6.21% 001-401-401-6504 Library-Video 58.33 48.02 700.00 412.40 41.09% 001-401-401-6505 Library-Other Materials-Supplies 25.00 42.90 300.00 306.20 (2.07%) 001-401-401-6508 Postage/Shipping 8.33 41.62 100.00 346.38 (246.38%) 001-401-401-6510 Training-Mileage 8.33 0.00 100.00 57.12 42.88% Total Library Expenditures 1,453.33 1,473.28 17,490.00 15,946.75 8.82%

Parks Expenditures 001-401-402-6020 Parks Wages-Part Time 357.14 12.46 2,500.00 1,007.78 59.69% 001-401-402-6110 Parks FICA 16.25 0.00 195.00 115.32 40.86% 001-401-402-6320 Parks-Grounds Maint/Repair 291.67 0.00 3,500.00 54.19 98.45% 001-401-402-6371 Parks-Gas/Elect Expense 83.33 0.00 1,000.00 149.82 85.02% 001-401-402-6406 Parks-Liability Insurance 0.00 0.00 150.00 0.00 100.00% 001-401-402-6407 Parks-Work Comp Insurance 0.00 0.00 150.00 0.00 100.00% 001-401-402-6408 Parks-Property Insurance Expense 0.00 0.00 600.00 0.00 100.00% 001-401-402-6505 Parks- Equipment 83.33 0.00 1,000.00 62.87 93.71% 001-401-402-6599 Parks-Supplies 25.00 0.00 300.00 0.00 100.00%

Page 9: 051214 ACC Support Docs

City of Auburn Statement of Revenue and Expenditures5/8/2014 9:08am Page 5 Revised Budget For General Fund (001) For the Fiscal Period 2014-10 Ending April 30, 2014

Current Current Annual YTD Remaining Account Number Budget Actual Budget Actual Budget %

Total Parks Expenditures 856.72 12.46 9,395.00 1,389.98 85.21%

Community Bldg Expenditures 001-401-403-6020 Comm Bldg-Wages-Part Time 100.00 85.80 1,200.00 814.14 32.16% 001-401-403-6110 Comm Bldg-FICA 8.33 6.71 100.00 103.52 (3.52%) 001-401-403-6130 IPERS 9.17 7.84 110.00 117.71 (7.01%) 001-401-403-6310 Comm Building Maint/Repair 333.33 144.60 4,000.00 1,427.61 64.31% 001-401-403-6371 Comm Bldg Gas/Elect Expense 100.00 144.66 1,200.00 1,520.12 (26.68%) 001-401-403-6406 Comm Bldg-Liability Insurance 0.00 0.00 275.00 0.00 100.00% 001-401-403-6407 Comm Bldg-Work Comp Insurance 0.00 0.00 100.00 0.00 100.00% 001-401-403-6408 Comm Bldg-Property Insurance Expense 0.00 0.00 450.00 0.00 100.00% 001-401-403-6499 Comm Bldg- pest control- Contractural 37.50 36.26 450.00 365.17 18.85% 001-401-403-6599 Comm Bldg -Supplies 29.17 0.00 350.00 175.83 49.76% Total Community Bldg Expenditures 617.50 425.87 8,235.00 4,524.10 45.06%

Recreation Committee Expenditures 001-401-404-6401 Soccer 250.00 2,552.72 1,000.00 3,833.22 (283.32%) 001-401-404-6403 Donations 8.33 0.00 100.00 25.00 75.00% 001-401-404-6410 Postage 0.00 0.00 15.00 9.80 34.67% 001-401-404-6414 Easter Expense 250.00 222.03 500.00 271.53 45.69% 001-401-404-6506 Concession Supplies 166.67 200.00 2,000.00 707.50 64.63% 001-401-404-6599 Rec-Supplies 4.17 52.01 50.00 52.01 (4.02%) Total Recreation Committee Expenditures 679.17 3,026.76 3,665.00 4,899.06 (33.67%)

Historical Committee Expenditures 001-401-405-6310 Historical-Building Renovation 1,470.83 0.00 17,650.00 3,179.53 81.99% 001-401-405-6599 Supplies 41.67 170.42 500.00 170.42 65.92% Total Historical Committee Expenditures 1,512.50 170.42 18,150.00 3,349.95 81.54%

125th Celebration Expenditures 001-401-406-6403 Event Comm- Car Show Expense 0.00 0.00 0.00 5,031.22 0.00% Total 125th Celebration Expenditures 0.00 0.00 0.00 5,031.22 0.00%

Total Culture/Recreation Expenditures 5,715.06 5,474.23 67,185.00 39,203.38 41.65%

Community/Economic Develeopment Expenditures

General Expenditures 001-500-004-6320 Beautification--Grounds Maint/Repair 208.33 0.00 2,500.00 166.53 93.34% 001-500-004-7000 Capitol Projects 0.00 0.00 0.00 0.00 0.00% 001-500-004-8000 Economic Development 208.33 0.00 2,500.00 483.00 80.68% Total General Expenditures 416.66 0.00 5,000.00 649.53 87.01%

Total Community/Economic Develeopment Expenditures 416.66 0.00 5,000.00 649.53 87.01%

General Government Expenditures

General Expenditures 001-600-004-6240 Banking Mileage & Fees 66.67 78.56 800.00 565.17 29.35% 001-600-004-6373 Telecommunications Expense 83.33 59.69 1,000.00 628.48 37.15% 001-600-004-6405 Court & Recording Expense 4.17 0.00 50.00 34.60 30.80%

Page 10: 051214 ACC Support Docs

City of Auburn Statement of Revenue and Expenditures5/8/2014 9:08am Page 6 Revised Budget For General Fund (001) For the Fiscal Period 2014-10 Ending April 30, 2014

Current Current Annual YTD Remaining Account Number Budget Actual Budget Actual Budget %

001-600-004-6406 Liability Insurance 0.00 0.00 1,200.00 0.00 100.00% 001-600-004-6408 Bond-Misc. Insurance 29.17 0.00 350.00 185.00 47.14% 001-600-004-6411 Legal Expense 291.67 0.00 3,500.00 50.00 98.57% 001-600-004-6413 Annual Audit Fee 0.00 0.00 1,200.00 1,200.00 0.00% 001-600-004-6414 Publishing Expense 83.33 24.18 1,000.00 426.06 57.39% 001-600-004-6490 Elections 0.00 0.00 1,800.00 1,210.25 32.76% 001-600-004-6499 Donations/Contributions 25.00 42.80 300.00 290.85 3.05% 001-600-004-6505 Other Equipment 41.67 0.00 500.00 1,753.60 (250.72%) 001-600-004-6506 Office Supplies 291.67 274.95 3,500.00 1,603.17 54.20% 001-600-004-6508 Postage/Shipping 50.00 0.00 600.00 185.72 69.05% 001-600-004-6699 Other Gen Govt Exp 625.00 0.00 7,500.00 3,256.67 56.58% Total General Expenditures 1,591.68 480.18 23,300.00 11,389.57 51.12%

Clerk Expenditures 001-600-601-6010 Clerk Wages 841.67 751.15 10,100.00 7,654.58 24.21% 001-600-601-6110 Clerk-FICA 64.58 53.52 775.00 601.51 22.39% 001-600-601-6130 Clerk-IPERS 75.00 62.45 900.00 700.12 22.21% 001-600-601-6140 Pmt in Lieu of Health Ins 70.83 70.00 850.00 700.00 17.65% 001-600-601-6210 Clerk-Association Dues 4.17 0.00 50.00 40.00 20.00% 001-600-601-6230 Clerk-Training 41.67 121.40 500.00 715.40 (43.08%) 001-600-601-6240 Clerk-Meetings & Conferences 104.17 44.80 1,250.00 360.94 71.12% 001-600-601-6407 Clerk-Work Comp Insurance 0.00 0.00 100.00 0.00 100.00% Total Clerk Expenditures 1,202.09 1,103.32 14,525.00 10,772.55 25.83%

Mayor/Council Expenditures 001-600-602-6020 Mayor/Council-Wages 250.00 60.50 3,000.00 1,944.61 35.18% 001-600-602-6110 Mayor/Council-FICA 20.83 53.36 250.00 197.36 21.06% 001-600-602-6130 Mayor/Council-IPERS 8.33 10.72 100.00 37.33 62.67% 001-600-602-6210 Mayor/Council-Association Dues 25.00 0.00 300.00 262.00 12.67% 001-600-602-6240 Mayor/Council-Meetings & Conferences 54.17 167.00 650.00 812.79 (25.04%) 001-600-602-6407 Mayor/Council-Work Comp Insurance 0.00 0.00 20.00 0.00 100.00% Total Mayor/Council Expenditures 358.33 291.58 4,320.00 3,254.09 24.67%

Total General Government Expenditures 3,152.10 1,875.08 42,145.00 25,416.21 39.69%

Total General Fund Expenditures 15,671.34 $ 14,265.26 $ 172,930.00 $ $ 93,551.45 45.90%

General Fund Excess of Revenues Over Expenditures $ (8,369.60) 2,511.83 $ (85,584.00) $ (3,534.36) $ 95.87%

Page 11: 051214 ACC Support Docs

City of Auburn Statement of Revenue and Expenditures5/8/2014 9:08am Page 7 Revised Budget For Local Option Sales Tax Fund (002) For the Fiscal Period 2014-10 Ending April 30, 2014

Current Current Annual YTD Remaining Account Number Budget Actual Budget Actual Budget %

Revenues

Taxes Revenues

General Revenues 002-100-004-1000 Local Option Sales Tax 2,000.00 $ 1,690.29 $ 24,000.00 $ $ 17,885.23 25.48% Total General Revenues 2,000.00 1,690.29 24,000.00 17,885.23 25.48%

Total Taxes Revenues 2,000.00 1,690.29 24,000.00 17,885.23 25.48%

Total Local Option Sales Tax Fund Revenues 2,000.00 $ 1,690.29 $ 24,000.00 $ $ 17,885.23 25.48%

Expenditures

Taxes Expenditures

General Expenditures 002-100-004-9002 Transfer to General Fund 0.00 $ 0.00 $ 0.00 $ $ 0.00 0.00% Total General Expenditures 0.00 0.00 0.00 0.00 0.00%

Total Taxes Expenditures 0.00 0.00 0.00 0.00 0.00%

Total Local Option Sales Tax Fund Expenditures 0.00 $ 0.00 $ 0.00 $ $ 0.00 0.00%

Local Option Sales Tax Fund Excess of Revenues Over $ 2,000.00 1,690.29 $ 24,000.00 $ 17,885.23 $ 25.48%

Page 12: 051214 ACC Support Docs

City of Auburn Statement of Revenue and Expenditures5/8/2014 9:08am Page 8 Revised Budget For Employee Benefits Levy (003) For the Fiscal Period 2014-10 Ending April 30, 2014

Current Current Annual YTD Remaining Account Number Budget Actual Budget Actual Budget %

Revenues

Taxes Revenues

General Revenues 003-100-004-0006 FICA/Ipers/Emply Benefit Levy 644.08 $ 2,443.44 $ 7,729.00 $ $ 7,666.28 0.81% Total General Revenues 644.08 2,443.44 7,729.00 7,666.28 0.81%

Total Taxes Revenues 644.08 2,443.44 7,729.00 7,666.28 0.81%

Total Employee Benefits Levy Revenues 644.08 $ 2,443.44 $ 7,729.00 $ $ 7,666.28 0.81%

Expenditures

Pubilc Works Expenditures

General Expenditures 003-201-004-9002 Transfer to General- PW 0.00 $ 553.28 $ 0.00 $ $ 2,570.53 0.00% Total General Expenditures 0.00 553.28 0.00 2,570.53 0.00%

Total Pubilc Works Expenditures 0.00 553.28 0.00 2,570.53 0.00%

Culture/Recreation Expenditures

General Expenditures 003-401-004-9002 Transfer to General-Culture/Rec. 0.00 334.13 0.00 1,686.54 0.00% Total General Expenditures 0.00 334.13 0.00 1,686.54 0.00%

Total Culture/Recreation Expenditures 0.00 334.13 0.00 1,686.54 0.00%

General Government Expenditures

General Expenditures 003-601-004-9002 Transfer to General-Gen Govt 0.00 431.39 0.00 2,124.61 0.00% Total General Expenditures 0.00 431.39 0.00 2,124.61 0.00%

Total General Government Expenditures 0.00 431.39 0.00 2,124.61 0.00%

Total Employee Benefits Levy Expenditures 0.00 $ 1,318.80 $ 0.00 $ $ 6,381.68 0.00%

Employee Benefits Levy Excess of Revenues Over $ 644.08 1,124.64 $ 7,729.00 $ 1,284.60 $ 83.38%

Page 13: 051214 ACC Support Docs

City of Auburn Statement of Revenue and Expenditures5/8/2014 9:08am Page 9 Revised Budget For Emergency Levy (004) For the Fiscal Period 2014-10 Ending April 30, 2014

Current Current Annual YTD Remaining Account Number Budget Actual Budget Actual Budget %

Revenues

Taxes Revenues

General Revenues 004-100-004-0008 Emergency Levy 97.83 $ 371.02 $ 1,174.00 $ $ 1,164.83 0.78% Total General Revenues 97.83 371.02 1,174.00 1,164.83 0.78%

Total Taxes Revenues 97.83 371.02 1,174.00 1,164.83 0.78%

Total Emergency Levy Revenues 97.83 $ 371.02 $ 1,174.00 $ $ 1,164.83 0.78%

Expenditures

Taxes Expenditures

General Expenditures 004-100-004-9002 Transfer to General Fund 0.00 $ 0.00 $ 0.00 $ $ 0.00 0.00% Total General Expenditures 0.00 0.00 0.00 0.00 0.00%

Total Taxes Expenditures 0.00 0.00 0.00 0.00 0.00%

Total Emergency Levy Expenditures 0.00 $ 0.00 $ 0.00 $ $ 0.00 0.00%

Emergency Levy Excess of Revenues Over Expenditures $ 97.83 371.02 $ 1,174.00 $ 1,164.83 $ 0.78%

Page 14: 051214 ACC Support Docs

City of Auburn Statement of Revenue and Expenditures5/8/2014 9:08am Page 10 Revised Budget For Road Use Tax (110) For the Fiscal Period 2014-10 Ending April 30, 2014

Current Current Annual YTD Remaining Account Number Budget Actual Budget Actual Budget %

Revenues

Intergovernmental Revenues

General Revenues 110-400-004-1430 Road Use Tax 2,589.42 $ 2,048.69 $ 31,073.00 $ $ 27,679.07 10.92% Total General Revenues 2,589.42 2,048.69 31,073.00 27,679.07 10.92%

Total Intergovernmental Revenues 2,589.42 2,048.69 31,073.00 27,679.07 10.92%

Total Road Use Tax Revenues 2,589.42 $ 2,048.69 $ 31,073.00 $ $ 27,679.07 10.92%

Expenditures

Pubilc Works Expenditures

General Expenditures 110-201-004-6010 Road Use-Wages 1,083.33 $ 1,113.98 $ 13,000.00 $ $ 11,598.01 10.78% 110-201-004-6110 FICA 83.33 74.88 1,000.00 907.67 9.23% 110-201-004-6130 IPERS 100.00 87.39 1,200.00 1,055.71 12.02% 110-201-004-6140 Pmt in Lieu of Health Ins. 75.00 60.00 900.00 600.00 33.33% 110-201-004-6379 Road Use-Storm Sewer 41.67 0.00 500.00 0.00 100.00% 110-201-004-6380 Road Use Tax-Street Lights 250.00 0.00 3,000.00 1,550.00 48.33% 110-201-004-6399 Engineering 0.00 0.00 0.00 0.00 0.00% 110-201-004-6407 Road Use-Work Comp Insurance 0.00 0.00 1,500.00 0.00 100.00% 110-201-004-6417 Street Maintenance Expense 1,250.00 217.96 15,000.00 967.96 93.55% 110-201-004-6599 Supplies 20.83 0.00 250.00 0.00 100.00% Total General Expenditures 2,904.16 1,554.21 36,350.00 16,679.35 54.11%

Snow Expenditures 110-201-202-6030 Snow-Hourly Wages 0.00 0.00 2,000.00 0.00 100.00% 110-201-202-6110 Snow-FICA 30.00 0.00 150.00 0.00 100.00% 110-201-202-6331 Vehicle Operations 0.00 0.00 1,000.00 159.62 84.04% 110-201-202-6350 Operational Equipment Repair 83.33 0.00 1,000.00 0.00 100.00% 110-201-202-6407 Snow-Work Comp Insurance 0.00 0.00 250.00 0.00 100.00% Total Snow Expenditures 113.33 0.00 4,400.00 159.62 96.37%

Total Pubilc Works Expenditures 3,017.49 1,554.21 40,750.00 16,838.97 58.68%

Total Road Use Tax Expenditures 3,017.49 $ 1,554.21 $ 40,750.00 $ $ 16,838.97 58.68%

Road Use Tax Excess of Revenues Over Expenditures $ (428.07) 494.48 $ (9,677.00) $ 10,840.10 $ 212.02%

Page 15: 051214 ACC Support Docs

City of Auburn Statement of Revenue and Expenditures5/8/2014 9:08am Page 11 Revised Budget For Water Fund (600) For the Fiscal Period 2014-10 Ending April 30, 2014

Current Current Annual YTD Remaining Account Number Budget Actual Budget Actual Budget %

Revenues

Enterprise-Water Revenues

Charges for Servic Revenues 600-810-001-1001 Metered Water Sales/Sales Tax 5,833.33 $ 5,163.36 $ 70,000.00 $ $ 62,072.62 11.32% 600-810-001-1002 Utility Deposits 62.50 0.00 750.00 700.00 6.67% 600-810-001-1340 Recovered & Misc Revenue 0.00 0.00 0.00 1,120.05 0.00% 600-810-001-9000 Transfer In- Electric Fund Loan 0.00 0.00 0.00 37,000.00 0.00% Total Charges for Servic Revenues 5,895.83 5,163.36 70,750.00 100,892.67 (42.60%)

Total Enterprise-Water Revenues 5,895.83 5,163.36 70,750.00 100,892.67 (42.60%)

Total Water Fund Revenues 5,895.83 $ 5,163.36 $ 70,750.00 $ $ 100,892.67 (42.60%)

Expenditures

Enterprise-Water Expenditures

Charges for Servic Expenditures 600-810-001-6010 Water Wages-Full Time 1,716.67 $ 1,518.59 $ 20,600.00 $ $ 16,559.86 19.61% 600-810-001-6110 FICA 133.33 144.33 1,600.00 1,311.07 18.06% 600-810-001-6130 IPERS 166.67 168.44 2,000.00 1,524.39 23.78% 600-810-001-6140 pmt in Lieu of Health ins. 100.00 90.00 1,200.00 900.00 25.00% 600-810-001-6230 Water-Training 41.67 0.00 500.00 200.00 60.00% 600-810-001-6350 Operational Equipment Repair 3,666.67 0.00 44,000.00 41,209.93 6.34% 600-810-001-6399 Other Maintenance & Repair 250.00 16.20 3,000.00 4,571.63 (52.39%) 600-810-001-6406 Liability Insurance 0.00 0.00 350.00 0.00 100.00% 600-810-001-6407 Water-Work Comp Insurance 0.00 0.00 800.00 0.00 100.00% 600-810-001-6408 Property Insurance Expense 0.00 0.00 750.00 0.00 100.00% 600-810-001-6416 Meter Loan Payment 0.00 0.00 0.00 0.00 0.00% 600-810-001-6418 Tax Expense 416.67 370.60 5,000.00 4,037.62 19.25% 600-810-001-6490 Water-Testing 125.00 56.00 1,500.00 971.31 35.25% 600-810-001-6499 Water Tower Contract 596.08 661.65 7,153.00 6,026.37 15.75% 600-810-001-6501 Chemicals/Salt/Chlorine 833.33 177.80 10,000.00 5,655.24 43.45% 600-810-001-6508 Billing/Postage/Shipping 62.50 28.75 750.00 734.71 2.04% 600-810-001-6700 Utility Deposit Refund 62.50 0.00 750.00 408.08 45.59% Total Charges for Servic Expenditures 8,171.09 3,232.36 99,953.00 84,110.21 15.85%

Total Enterprise-Water Expenditures 8,171.09 3,232.36 99,953.00 84,110.21 15.85%

Total Water Fund Expenditures 8,171.09 $ 3,232.36 $ 99,953.00 $ $ 84,110.21 15.85%

Water Fund Excess of Revenues Over Expenditures $ (2,275.26) 1,931.00 $ (29,203.00) $ 16,782.46 $ 157.47%

Page 16: 051214 ACC Support Docs

City of Auburn Statement of Revenue and Expenditures5/8/2014 9:08am Page 12 Revised Budget For Sewer Fund (610) For the Fiscal Period 2014-10 Ending April 30, 2014

Current Current Annual YTD Remaining Account Number Budget Actual Budget Actual Budget %

Revenues

Enterprise-Sewer Revenues

Charges for Servic Revenues 610-815-001-1001 Sewer Rent Collections 2,291.67 $ 2,301.74 $ 27,500.00 $ $ 23,406.43 14.89% 610-815-001-1002 Utility Deposits 37.50 0.00 450.00 420.00 6.67% 610-815-001-1340 Misc Revenue 25.00 0.00 300.00 300.00 0.00% Total Charges for Servic Revenues 2,354.17 2,301.74 28,250.00 24,126.43 14.60%

Total Enterprise-Sewer Revenues 2,354.17 2,301.74 28,250.00 24,126.43 14.60%

Total Sewer Fund Revenues 2,354.17 $ 2,301.74 $ 28,250.00 $ $ 24,126.43 14.60%

Expenditures

Enterprise-Sewer Expenditures

Charges for Servic Expenditures 610-815-001-6010 Wages-Full Time 1,041.67 $ 928.32 $ 12,500.00 $ $ 9,664.99 22.68% 610-815-001-6110 FICA 79.17 62.40 950.00 756.41 20.38% 610-815-001-6130 IPERS 93.75 72.83 1,125.00 879.53 21.82% 610-815-001-6140 Pmt in Lieu of Health Ins. 62.50 50.00 750.00 500.00 33.33% 610-815-001-6320 Grounds Maint/Repair 12.50 0.00 150.00 0.00 100.00% 610-815-001-6406 Sewer-Liability Insurance 0.00 0.00 200.00 0.00 100.00% 610-815-001-6407 Sewer-Work Comp Insurance 0.00 0.00 550.00 0.00 100.00% 610-815-001-6408 Sewer-Property Insurance Expense 0.00 0.00 50.00 0.00 100.00% 610-815-001-6416 Loan payment 0.00 0.00 12,600.00 0.00 100.00% 610-815-001-6418 Tax Expense 16.67 22.24 200.00 201.95 (0.98%) 610-815-001-6490 Sewer-Testing-DNR 83.33 0.00 1,000.00 210.00 79.00% 610-815-001-6499 Sewer-Maint 41.67 0.00 500.00 150.00 70.00% 610-815-001-6508 Billing Fees 62.50 28.75 750.00 680.75 9.23% 610-815-001-6700 Utility Deposit Refund 37.50 0.00 450.00 256.72 42.95% Total Charges for Servic Expenditures 1,531.26 1,164.54 31,775.00 13,300.35 58.14%

Total Enterprise-Sewer Expenditures 1,531.26 1,164.54 31,775.00 13,300.35 58.14%

Total Sewer Fund Expenditures 1,531.26 $ 1,164.54 $ 31,775.00 $ $ 13,300.35 58.14%

Sewer Fund Excess of Revenues Over Expenditures $ 822.91 1,137.20 $ (3,525.00) $ 10,826.08 $ 407.12%

Page 17: 051214 ACC Support Docs

City of Auburn Statement of Revenue and Expenditures5/8/2014 9:08am Page 13 Revised Budget For Electric Fund (630) For the Fiscal Period 2014-10 Ending April 30, 2014

Current Current Annual YTD Remaining Account Number Budget Actual Budget Actual Budget %

Revenues

Enterprise-Electric Revenues

Charges for Servic Revenues 630-820-001-1001 Sales & Sales Tax Collections 20,387.50 $ 19,123.56 $ 244,650.00 $ $ 214,048.28 12.51% 630-820-001-1002 Utility Deposits 250.00 0.00 3,000.00 11,370.39 (279.01%) 630-820-001-1340 Sewer Loan Proceeds 0.00 0.00 12,600.00 0.00 100.00% 630-820-001-1341 Recovered & Misc. Revenue 0.00 299.73 0.00 1,789.73 0.00% 630-820-001-1342 Transmission Investment Revenue 0.00 0.00 0.00 0.00 0.00% 630-820-001-1343 CD Investment Interest 66.67 0.00 800.00 574.51 28.19% 630-820-001-1345 Water Loan Proceeds 0.00 0.00 0.00 0.00 0.00% 630-820-001-4550 Elect Pole Rent 0.00 0.00 700.00 707.00 (1.00%) Total Charges for Servic Revenues 20,704.17 19,423.29 261,750.00 228,489.91 12.71%

Total Enterprise-Electric Revenues 20,704.17 19,423.29 261,750.00 228,489.91 12.71%

Total Electric Fund Revenues 20,704.17 $ 19,423.29 $ 261,750.00 $ $ 228,489.91 12.71%

Expenditures

Enterprise-Electric Expenditures

Charges for Servic Expenditures 630-820-001-6010 Wages-Full Time 1,750.00 $ 1,630.12 $ 21,000.00 $ $ 17,163.93 18.27% 630-820-001-6110 FICA 135.42 113.89 1,625.00 1,312.98 19.20% 630-820-001-6130 IPERS 158.33 132.92 1,900.00 1,527.80 19.59% 630-820-001-6140 Pmt in Lieu of Health Ins. 162.50 130.00 1,950.00 1,300.00 33.33% 630-820-001-6210 Dues & Assessments 83.33 0.00 1,000.00 1,797.53 (79.75%) 630-820-001-6310 Electrical Distribution costs 1,416.67 0.00 17,000.00 27,834.41 (63.73%) 630-820-001-6352 Misc. Exp 33.33 40.54 400.00 92.19 76.95% 630-820-001-6371 Wholesale Electric 16,625.00 15,223.74 199,500.00 150,324.83 24.65% 630-820-001-6380 Street Lights 416.67 950.64 5,000.00 4,505.34 9.89% 630-820-001-6399 Electrical Maintenance & Repair 3,333.33 0.00 40,000.00 72,745.90 (81.86%) 630-820-001-6406 Liability Insurance 0.00 0.00 800.00 0.00 100.00% 630-820-001-6407 Work Comp Insurance 0.00 0.00 400.00 0.00 100.00% 630-820-001-6408 Property Insurance Expense 0.00 0.00 1,000.00 0.00 100.00% 630-820-001-6418 Tax Expense 500.00 510.71 6,000.00 5,209.51 13.17% 630-820-001-6490 Energy Efficiency Expense 333.33 50.00 4,000.00 1,459.38 63.52% 630-820-001-6508 Postage-Billing Expense 62.50 28.75 750.00 1,057.21 (40.96%) 630-820-001-6700 Utility Deposit Refund 250.00 0.00 3,000.00 1,699.42 43.35% 630-820-001-7000 Wind Investment 0.00 0.00 0.00 117.60 0.00% 630-820-001-7001 Power Supply Development 2,083.33 0.00 25,000.00 6,335.99 74.66% 630-820-001-9004 Transfer Loan to Water Fund 0.00 0.00 0.00 37,000.00 0.00% Total Charges for Servic Expenditures 27,343.74 18,811.31 330,325.00 331,484.02 (0.35%)

Total Enterprise-Electric Expenditures 27,343.74 18,811.31 330,325.00 331,484.02 (0.35%)

Total Electric Fund Expenditures 27,343.74 $ 18,811.31 $ 330,325.00 $ $ 331,484.02 (0.35%)

Electric Fund Excess of Revenues Over Expenditures $ (6,639.57) 611.98 $ (68,575.00) $ (102,994.11) $ (50.19%)

Page 18: 051214 ACC Support Docs

City of Auburn Statement of Revenue and Expenditures5/8/2014 9:08am Page 14 Revised Budget For Garbage-recycling Fund (670) For the Fiscal Period 2014-10 Ending April 30, 2014

Current Current Annual YTD Remaining Account Number Budget Actual Budget Actual Budget %

Revenues

Enterprise-Garbage Revenues

Charges for Servic Revenues 670-840-001-1001 Base Fee Collections 1,250.00 $ 1,143.33 $ 15,000.00 $ $ 11,541.85 23.05% 670-840-001-1002 Utility Deposits 25.00 0.00 300.00 287.00 4.33% 670-840-001-1003 Sales Tax-Bags 8.33 4.20 100.00 30.55 69.45% 670-840-001-1004 Garbage Bag Sales 479.17 460.00 5,750.00 4,266.00 25.81% 670-840-001-1341 Recovered & Misc. Revenue 0.00 0.00 0.00 30.00 0.00% Total Charges for Servic Revenues 1,762.50 1,607.53 21,150.00 16,155.40 23.62%

Total Enterprise-Garbage Revenues 1,762.50 1,607.53 21,150.00 16,155.40 23.62%

Total Garbage-recycling Fund Revenues 1,762.50 $ 1,607.53 $ 21,150.00 $ $ 16,155.40 23.62%

Expenditures

Enterprise-Garbage Expenditures

Charges for Servic Expenditures 670-840-001-6418 Tax Expense 6.25 $ 2.45 $ 75.00 $ $ 31.22 58.37% 670-840-001-6490 Landfill Fees 1,775.00 1,771.00 7,100.00 7,084.00 0.23% 670-840-001-6499 Gargabe Contract 1,000.00 1,000.00 12,000.00 10,000.00 16.67% 670-840-001-6508 Billing-Postage-Shipping 50.00 28.75 600.00 275.75 54.04% 670-840-001-6599 Supplies-Bags 166.67 0.00 2,000.00 0.00 100.00% 670-840-001-6700 Utility Deposit Refund 25.00 0.00 300.00 176.10 41.30% Total Charges for Servic Expenditures 3,022.92 2,802.20 22,075.00 17,567.07 20.42%

Total Enterprise-Garbage Expenditures 3,022.92 2,802.20 22,075.00 17,567.07 20.42%

Total Garbage-recycling Fund Expenditures 3,022.92 $ 2,802.20 $ 22,075.00 $ $ 17,567.07 20.42%

Garbage-recycling Fund Excess of Revenues Over $ (1,260.42) (1,194.67) $ (925.00) $ (1,411.67) $ (52.61%)

Page 19: 051214 ACC Support Docs

City of Auburn Statement of Revenue and Expenditures5/8/2014 9:08am Page 15 Revised Budget

For the Fiscal Period 2014-10 Ending April 30, 2014

Current Current Annual YTD Remaining Account Number Budget Actual Budget Actual Budget %

Total Revenues 43,349.74 $ 51,826.45 $ 533,222.00 $ 514,076.91 $ 3.59% Total Expenditures 58,757.84 $ 43,148.68 $ 697,808.00 $ 563,233.75 $ 19.29% Total Excess of Revenues Over Expenditures (15,408.10) $ 8,677.77 $ (164,586.00) $ (49,156.84) $ 70.13%

Page 20: 051214 ACC Support Docs

HALLETT MATERNLS220 West 1st StreetP.O. Box 487Wall Lake, lowa 51466(712) 664-2732. FAX: (712) 664-2799(800) 838-2615

IAKE VIEWBOYER -OL262BOARD PRICES: EFFECTIVE 2-3-20l4

,{/ 6[ v,:-4U'JOIfraut

daltrnwl

[1,00 l4.oa

7,fl lo '90

AL'[ PRoDucrs -?d;'"dm I tTdail'rHour

NoncE

Producers of Quality Sand & Gravel An Equal Opportunity Employer

Page 21: 051214 ACC Support Docs
Page 22: 051214 ACC Support Docs

Aaeh'na, Auou

Fire station usaehoabf 'hb" cJief1. Building may only be used for non-fire operations purposes with permission of the €itrylCotucil'

2. Personal use of the building is prohibited, including.family gatheringi,and other events held by

membersofthefiredepartment,citystaff,orelectedqtfici,t'' I'-ille-vee7fP46F fyqrfetg

3. Fire Department may use the building for the purpose of oep$nefi fund raising events'

(Legionanda||othereventsmusthavepermissionofthsg*tJ-+'4,Fundraisingevents@o,ttreefti+r*eAuburnFireFighte/s

Associationg, Tl,o r*c('ii"f;;i ir-:'iri" o | 4 e t'thqn'4r6'r"/ F;"F;2'trar*

Congregate Meal Site usage guidelines

t. Group will hold lunches in building Monday - Friday year round. 60+ Director oNLY will have a

key to the building and will be wholly responsible for use of the key and any issues that may

arise due to improper use of the key'

Z. Doors to the truck bay will remain unlocked due to the necessity of access to alternative exits in

case of emergency.

3. persons attending the lunches are to remain in the meeting room/kitchen area and only enter

4.

the truck baY in case of emergency.

60 + will keep the area neat and clean and keep their items, dishes, food, etc' only in the

designated area. upon reaving, the meeting room wiil be avairabre to the fire department as

needed.

Sixty + will supply their own dishes, utensils, coffee pot, cleaning products' etc' Fire Department

will supply required space in refrigerator and make the stove available for use' (several cups,

glasses,'small bowls & plates will be moved from the community Building)

Bathroom supplies will be provided by: H'1 ^ . ,

Garbage Bags and paper towels provided by: 4ft1 ./I; .

Maintenance items identified should be reported to: CJ\tcFa. APPliances

1e80)

11. City employed janitor will clean as normal - L ti^"tper month' In between times' each entity

should make sure that the building is ready for use by the next entity'

6.

7,

8.

Page 23: 051214 ACC Support Docs

CITY BUDGET AMENDMENT AND CERTIFICATION RESOLUTION

To the Auditor of County, lowa:

The City Council of Auburn in said County/Counties met on May 12,2014

,at the place and hour set in the notice, a copy of which accompanies this certificate and is certified as topublication. Upon taking up the proposed amendment, it was considered and taxpayers were heard for and against

the amendment.

The Council, after hearing all taxpayers wishing to be heard and considering the statements made by them, gave

final consideration to the proposed amendment(s) to the budget and modifications proposed at the hearing, if any.

thereupon, the following resolution was introduced.RESOLUTION No. 14-07

A RESOLUTION AMENDING THE CURRENT BUDGET FOR THE FISCAL YEAR ENDING JUNE 30 20'14(As AMENDED LAST ON _.)

Be it Resolved by the Gouncil of the Gity of AuburnSection 1. Following notice published

-ilT=6'i?-and the public hearing held, May 12,2014 the current budget (as previously amended) is amended as set oul

herein and in the detail by fund type and activity that supports this resolution which was considered at that hearing:

Passed this day of(Monthtfear)(Dav)

81 -761

Signature

MayorSignature

City ClerldFinance Omcer

Total Budgetas certified

or last amendedCurrent

Amendment

Total Budgetafter CurrentAmendment

Revenues & Other Financinq Sources52.543

':,:,:0Taxes Levied on Prooertv 1

-ess: Uncollectted Property Taxes-Levy Year 2 tl 0

Net Current Property Taxss 52.543 0 52,544

)elinouent ProDertv Taxes 4 U

ilF Revenues c

)ther Citv Taxes 29.281 29,281

-icenses & Permits 974 97!Jse of Monev and Propertv 2.10( 2,10C

nterqovernmental 52.56: 52,564

lharqes for Services 'l C 381,90( 17.00( 398,90C

11

Vliscellaneous 12 8,00( 8,00c

fther Financino Sources 1 3 50,00( 15.00c 65,00c

fotal Revenuos and Other Sources 14 577.362 JZ.UUL 609,362

=xpenditures & Other Financing Uses

28,90C L 28,90C)ublic Safetv 15tublic Works 1 69,45C 69,450

lealth and Social Services 1 1.00c c 1,000

lulture and Recreation 1 55,43€ c 55,435

lommunitv and Economic Development 1 5.00c c 5.00c

3eneral Government 2( 42.144 0 42.145

)ebt Service 21 L L c

laoital Proiects 2t c c 0

Total Government Activities Expenditures 2! 201,93C c 201,930

lusiness Tvoe / EnterDrises 21 450.128 47, 497.12tfotal Gov Activities & Buginess Expenditures ZI' o52,u5b 47,004 699,05f

Transfers Out 2E 5U,UUU 15.00( 65,00(

fotal Expenditurss/Transfers Out zl 702,058 62,00( 764,05€

ixcees Revenuee & Other Sources Over

Underl Exoenditures/Transfers Out Fiscal Year 28' -124,696 -30,00( 154,69€

Continuino Aporopriation 2 NiA

leqinninq Fund Balance July 1 3C,lA7 7Al 167.76e

indinq Fund Balance June 30 31 43.07C -30,00c 13,07C

Page 24: 051214 ACC Support Docs

Current Change Operating

Amounts Held

FUND Previous Received Disbursed Fund from Prev Funds In Long-Term

Balance Balance Month Investment

GENERAL -$8,258.13 $15,748.89 $11,068.08 -$3,577.32 $4,680.81 -$18,998.42 $15,421.10

Historical Comm. $18,167.26 $100.00 $170.42 $18,096.84 -$70.42 $18,096.84 $0.00

Library Trust $8,460.93 $55.15 $8,516.08 $55.15 $3,664.29 $4,851.79

Rec Committee $11,868.44 $873.05 $3,026.76 $9,714.73 -$2,153.71 $4,611.29 $5,103.44

Event Comm $0.00 $0.00

LOST $26,260.75 $1,690.29 $27,951.04 $1,690.29 $27,951.04

EMPLY BEN LEVY $750.36 $2,443.44 $1,318.80 $1,875.00 $1,124.64 $1,875.00

EMERGENCY LEVY $793.81 $371.02 $1,164.83 $371.02 $1,164.83

ROAD USE TAX $26,768.31 $2,048.69 $1,554.21 $27,262.79 $494.48 $27,262.79

WATER UTILITY $15,091.35 $5,163.36 $3,232.36 $17,022.35 $1,931.00 $17,022.35

SEWER Operating $4,891.14 $2,301.74 $1,164.54 $6,028.34 $1,137.20 $6,028.34

ELECTRIC UTILITY $151,439.36 $19,423.29 $18,811.31 $152,051.34 $611.98 -$7,230.04 $159,281.38

GARBAGE/RECYCL. -$991.09 $1,607.53 $2,802.20 -$2,185.76 -$1,194.67 -$2,185.76

TOTAL CASH $255,242.49 $51,826.45 $43,148.68 $263,920.26 $8,677.77 $79,262.55 $184,657.71

Checking Acct Checking Acct Rec Chg Acct Library Trust

Ckg

Utility Billing $27,580.46 Statement Balance $73,836.04 $4,663.30 $3,664.29

Utility A/R $15,498.85

Less Outstanding Checks -$2,849.07 -$52.01

Other A/R Current Balance $70,986.97 $4,611.29 $3,664.29 $79,262.55

Investment-CD Elect-94 $37,177.14 CD Elect-43 $60,553.51 CD Elect-63 $25,568.21 CD-Rec-62

$5,103.44

$184,657.71

CD Elect-050 $35,982.52 CD- LibraryTrust

$4,851.79

CD General-49 $15,421.10

Total All Accounts $245,689.45 $9,714.73 $8,516.08 $263,920.26