Public Works Committee Packet 9-16-13
Page 1 of 1
CITY OF MUSKEGO
PUBLIC WORKS COMMITTEE AGENDA
DATE: September 16, 2013
TIME: 6:00 P.M.
LOCATION: Aldermen’s Room – Upper Level of City Hall
W182 S8200 Racine Avenue
Muskego, WI 53150
CALL TO ORDER
PLEDGE OF ALLEGIANCE
ROLL CALL
STATEMENT OF PUBLIC NOTICE
APPROVAL OF MINUTES OF MEETING HELD August 19, 2013
STATUS OF PROJECTS
Discussion update. No formal action may be taken on any of the following:
1. Janesville Road Reconstruction
2. Racine Avenue Recreational Trail
3. 2013 Road Program
4. Gold Drive Storm Sewer
5. Horn Park Drive Storm Sewer
6. Misc. Drainage Projects
UNFINISHED BUSINESS
Discussion update and possible action may be taken on any or all of the following:
NEW BUSINESS
Discussion update and possible action may be taken on any or all the following:
1. Review Request by Inpro Corporation for Paving of Apollo Drive Shoulder
2. Update Regarding Curbside Recycling Collection
3. 2013 Leaf Collection Schedule
4. Present Draft Sewer and Water Budget
]
NEW BUSINESS PLACED ON FILE
(The following items have been placed on file for staff review. Upon completion of review, staff will submit a supplement
detailing options and possible course of action to committee members.)
COMMUNICATIONS AND MISCELLANEOUS BUSINESS AS AUTHORIZED BY LAW
ADJOURNMENT
PLEASE NOTE: It is possible that members of and possibly a quorum of members of other governmental bodies of the municipality may be
in attendance at the above-stated meeting to gather information; no action will be taken by any governmental body at the above-stated
meeting other than the governmental body specifically referred to above in this notice.
Also, upon reasonable notice, efforts will be made to accommodate the needs of disabled individuals through appropriate aids and services.
For additional information or to request this service, contact Muskego City Hall, (262) 679-4100.
Unapproved
CITY OF MUSKEGO
PUBLIC WORKS COMMITTEE MINUTES
August 19, 2013
6:00 PM
Aldermen’s Room – Upper Level of City Hall,
W182 S8200 Racine Avenue
CALL TO ORDER
Ald. Dan Soltysiak called the meeting to order at 6:01 PM.
PLEDGE OF ALLEGIANCE
Ald. Soltysiak led those present in the Pledge of Allegiance.
ROLL CALL
Also present were Ald. Neil Borgman, Ald. Bob Hammel and Public Works Director David
Simpson.
STATEMENT OF PUBLIC NOTICE
The meeting was noticed in accordance with the Open Meeting Laws on August 19, 2013.
APPROVAL OF MINUTES FROM JULY 15, 2013
Alderman Borgman made a motion to approve minutes from July 15, 2013.
Alderman Hammel seconded.
Motion Passed 3 in favor.
STATUS OF PROJECTS
Janesville Road Reconstruction
Racine Avenue Recreational Trail
2013 Road Program
Gold Drive Storm Sewer
Horn Park Drive Storm Sewer
Misc. Drainage Projects
NEW BUSINESS
Discuss potential road improvement project for Laura Lane.
Ald. Borgman made a motion to recommend to Common Council staff
recommendation #2- to install a sign at the end of the gravel drive to prohibit non-
farm vehicles past the sign. Ald. Hammel seconded.
Motion Passed 3 in favor.
Approval of construction plans for the Willow Glen development.
Alderman Borgman made a motion to approve construction plans for the Willow Glen
development. Alderman Hammel seconded.
Motion Passed 3 in favor.
Approval of right-of-way vacation for Willow Glen Drive and an unnamed right-of-way off of
Clearbrook Drive.
Alderman Hammel made a motion to approve the right-of-way vacation for Willow
Glen Drive and an unnamed right-of-way off of Clearbrook Drive. Alderman Borgman
seconded.
Motion Passed 3 in favor.
Update regarding Molybdenum.
Alderman Borgman made a motion to update the residents with the new advisory
limits of Molybdenum to 90ug/I by a letter as well as putting on the website.
Alderman Hammel seconded.
Motion Passed 3 in favor.
2013 Capital Budget Item Review
2014 Capital Budget Item Discussion
COMMUNICATIONS AND MISCELLANEOUS BUSINESS AS AUTHORIZED BY LAW
ADJOURNMENT
Alderman Borgman made a motion to adjourn at 7:05 PM. Alderman Hammel
seconded.
Motion Passed 3 in favor.
Respectfully submitted,
Kellie McMullen,
Recording Secretary
Page 1 of 1
CITY OF MUSKEGO
Staff Report to Public Works Committee
To: Public Works Committee
From: David Simpson, P.E., Director of Public Works/City Engineer
Subject: Apollo Drive Shoulder Paving
Date: September 11, 2013
Background Information:
InPro Corporation has requested that the City consider paving the existing gravel
shoulder/s along Apollo Drive so that their employees can walk from various
company owned parking lots and buildings along Apollo Drive. The south side of
Apollo Drive currently has a shoulder approximately 4 feet in width, while the north
side has only 2 feet. The ditches in this area will not allow for any additional
widening of the roadway or installation of a trail unless a storm sewer system were
to be installed.
The attached map shows the location of the proposed shoulder paving. This would
be approximately 700’ of 4’ wide paving. The cost for this work would be
approximately $13,000. This could be completed in conjunction with the 2014
annual paving program should the committee wish to move forward.
Recommendation for Action by Committee:
Install a 4’ paved shoulder in conjunction with the annual road program in 2014 in
the approximate location as shown on the attached exhibit on the south side of
Apollo Drive.
0 125 250Feet
9/11/2013CREATED BY mapMUSKEGO:
City of Muskego Newsletter
August 2013
Recycling Collection Every Other Week:
Please place ALL ITEMS IN THE RECYCLE cart:
MIXED CONTAINERS
• Aluminum cans & clean aluminum foil
• Tin cans, steel cans, aerosol cans, empty/dried paint cans
• Glass bottles & jars
• #1-7 plastic
• Milk cartons, juice boxes, soup cartons
MIXED PAPER
• Newspaper, magazines, books, mail, school/office paper
• Brown corrugated cardboard
• Gray chipboard (cereal & shoe boxes)
• Brown paper bags
• Shredded paper (bagged in clear plastic)
DO NOT put the following items in the recycling cart:
• Styrofoam of any kind • Yard waste
• Trash • Household hazardous waste
• Construction materials • Electronics
• Clothing
Questions? Call Customer Service
262.679.0860
ADVANCED DISPOSAL SERVICES
2014
Recycling/Refuse Calendar
will be printed in the
Winter/Spring 2014 Guide.
Watch for this issue to be
distributed in late No-
vember.5
City Leaf Collection Program
The City of Muskego Public Works Department will again be picking up leaves starting
the fourth week of October. The pickup will begin on the north side of the City, working
to the south side.
We encourage residents to rake their leaves to the roadside as soon as possible,
since an early snowfall could disrupt the leaf collection program completely
Public Works personnel will be making several passes to accommodate residents who
may miss the first pickup. Leaves should be placed on the edge of the blacktop road
(NOT in the ditch) or if there is curb and gutter, please place leaves immediately behind
the curb. Leaves should NOT be bagged.
.
ABSOLUTELY no tree branches, garden plants, or vines may be mixed with the leaves.
City crews will stop leaf collection when a leaf pile is contaminated with such items
because it will cause damage to the leaf collection machine.
The last pickup date for ONLY leaves and grass clippings will be November 30th.
Public Works personnel will be making one more pass thru the City. Return trips for leaf
pickup will not be made after the final pass thru is made.
Property owners are responsible for leaf disposal after collection is completed by
DPW.
Please be advised there will be NO spring leaf collection.
There are two drop off sites where your yard debris may be dropped off. They are:
Advanced Disposal Service
W143 S6400 College Court
Saturdays – 7:00 a.m. – Noon
262-679-0860
Advanced Disposal ES Emerald Park Landfill
W124 S10629 South 124th Street
Fridays – 9:00 .m. – 4:00 p.m.
Saturdays – 8:00 a.m. – Noon
414-529-1360
.
If you have questions, please contact the Public Works Department at 262-679-4128.
2014
Period 0
2013
Period 14
2013 YTD -
Aug
2013 BudgetActual 2012Actual 2011Actual 2010Actual 2009Account NumberAccount Name
$7,331,007.02$6,905,682.00$4,524,628$7,006,065$6,556,148$6,343,438$6,386,239$5,773,596601.00.00.00.0000SEWER FUND
$6,950,584.02$6,752,779.00$4,473,391$6,860,662$6,325,449$6,161,070$6,209,616$5,563,450601.61.00.00.0000OPERATING EXPENSES
$5,263,892.94$5,142,694.00$4,201,106$5,161,313$4,756,516$4,662,022$4,638,233$3,977,463601.61.61.00.0000OPERATIONS & MAINTENANCE
$0.00$0.00$0$0$0$0$0$0601.61.61.00.5102SALARIES & WAGES - OVERTIME
$0.00$0.00$0$0$0$0$0$0601.61.61.01.0000MMSD CONTRACT AMORTIZATION
$0.00$0.00$0$0$0$0$0$0601.61.61.01.6405AMRTIZATN '83 MMSD CONTR CST
$0.00$0.00$0$0$0$0$0$0601.61.61.01.6406AMORTIZATN 1990 CONTR COSTS
$0.00$0.00$0$0$0$0$0$0601.61.61.01.6407AMORT 1996 CONSTRCTN COSTS
$3,066,376.00$3,035,550.00$3,035,550$3,002,403$2,707,803$2,741,485$2,638,540$2,080,421601.61.61.02.0000MMSD CAPITAL CHARGE
$3,066,376.00$3,035,550.00$3,035,550$3,002,403$2,707,803$2,741,485$2,638,540$2,080,421601.61.61.02.6071NON-INCREASE DESIGN CAPACITY
$1,067,575.00$1,046,644.00$523,322$1,070,000$1,033,852$1,016,921$996,998$962,876601.61.61.03.0000MMSD USER CHARGE
$1,067,575.00$1,046,644.00$523,322$1,070,000$1,033,852$1,016,921$996,998$962,876601.61.61.03.6072MMSD QUARTERLY PAYMENTS
$0.00$0.00$0$0$0$0$0$0601.61.61.07.0000ELECTRICITY
$0.00$0.00$0$0$0$0$0$0601.61.61.07.5910UTILITIES
$225,000.00$220,000.00$132,745$225,000$203,999$177,899$171,853$183,030601.61.61.10.0000TOWN OF NORWAY CHARGES
$225,000.00$220,000.00$132,745$225,000$203,999$177,899$171,853$183,030601.61.61.10.6068TOWN OF NORWAY
$0.00$0.00$0$0$0$0$0$0601.61.61.10.6069TOWN OF NORWAY CAPITAL CHARGES
$452,769.94$441,000.00$281,767$450,488$435,283$417,095$434,892$413,232601.61.61.11.0000SUPERVISION & LABOR
$427,505.50$425,000.00$271,384$424,723$423,685$407,190$412,838$400,423601.61.61.11.5101SALARIES & WAGES
$25,264.44$16,000.00$10,382$25,765$11,598$9,905$22,054$12,809601.61.61.11.5102OVERTIME
$0.00$0.00$0$0$0$0$0$0601.61.61.11.5150AUTO ALLOWANCE
$0.00$0.00$0$0$0$0$0$0601.61.61.11.5201FICA
$0.00$0.00$0$0$0$0$0$0601.61.61.11.5202PENSION
$0.00$0.00$0$0$0$0$0$0601.61.61.11.5203HEALTH
$0.00$0.00$0$0$0$0$0$0601.61.61.11.5204LIFE
$0.00$0.00$0$0$0$0$0$0601.61.61.11.5229HEALTH ALLOWANCE
$20,172.00$19,500.00$11,800$20,172$18,302$23,083$18,655$15,400601.61.61.12.0000SUPPLIES & EXPENSES
$3,172.00$2,500.00$451$3,172$969$4,589$1,300$1,940601.61.61.12.5228SAFETY GLASSES/CDL LIC/CONF SP
$3,000.00$3,000.00$2,573$3,000$3,649$4,001$4,807$2,318601.61.61.12.5702OPER SUPPLIES/CLOTHING EXP
$14,000.00$14,000.00$8,776$14,000$13,684$14,492$12,549$11,142601.61.61.12.5750CHEMICAL EXPENSE
DRAFT-Sanitary Sewer Budget (Expenses)-9-12-13
2014
Period 0
2013
Period 14
2013 YTD -
Aug
2013 BudgetActual 2012Actual 2011Actual 2010Actual 2009Account NumberAccount Name
$24,000.00$21,500.00$18,544$20,000$20,121$11,655$13,273$18,626601.61.61.15.0000MAINT SUPPLIES & EXPENSES
$14,000.00$14,000.00$13,692$10,000$13,282$7,648$9,412$8,549601.61.61.15.5415MAINT. OF BLDGS. & GROUNDS
$10,000.00$7,500.00$4,852$10,000$6,839$4,007$3,861$10,076601.61.61.15.5425MAINTENANCE OF SAFETY EQUIP
$247,500.00$203,000.00$81,487$218,000$206,386$120,272$207,774$169,738601.61.61.16.0000MAINT SEWAGE COLLECTION SYSTEM
$125,000.00$100,000.00$47,782$100,000$101,655$53,573$85,936$61,959601.61.61.16.5411MAINT. OF SEWAGE COLL. EQUIP
$22,500.00$18,000.00$10,455$18,000$23,089$22,189$20,475$10,913601.61.61.16.5426ODOR CONTROL
$100,000.00$85,000.00$23,250$100,000$81,642$44,509$57,133$52,636601.61.61.16.5427I & I REDUCTION
$0.00$0.00$0$0$0$0$44,231$44,231601.61.61.16.5428AMORTZ ODER CONTROL/MANWHOLE
$0.00$0.00$0$0$0$0$0$0601.61.61.16.5429FAC PLAN 2020 AMORT
$135,000.00$130,000.00$95,798$130,000$105,311$128,607$130,945$113,38460161612000006016161200000
$135,000.00$130,000.00$95,798$130,000$105,311$128,607$130,945$113,384601.61.61.20.5910GAS & ELECTRIC
$18,500.00$18,500.00$13,092$18,250$18,460$18,007$18,301$13,757601.61.61.21.0000TRANSPORTATION EXPENSES
$500.00$500.00$417$250$728$0$0$176601.61.61.21.5302MILEAGE
$18,000.00$18,000.00$12,675$18,000$17,732$18,007$18,301$13,581601.61.61.21.5306TRANSPORTATION EXPENSE
$7,000.00$7,000.00$7,000$7,000$7,000$7,000$7,000$7,000601.61.61.22.0000WATER EXPENSE
$7,000.00$7,000.00$7,000$7,000$7,000$7,000$7,000$7,000601.61.61.22.5915WATER EXPENSE
$0.00$0.00$0$0$0$0$0$060161614200006016161420000
$0.00$0.00$0$0$0$0$0$0601.61.61.42.5915WATER EXPENSE
$0.00$0.00$0$0$0$0$0$0601.61.62.00.0000CUSTOMER ACCOUNT EXPENSES
$0.00$0.00$0$0$0$0$0$0601.61.62.30.0000MISC EXPENSES
$0.00$0.00$0$0$0$0$0$0601.61.62.30.5101SALARIES AND WAGES
$0.00$0.00$0$0$0$0$0$0601.61.62.30.6060COLLECTION EXPENSE
$551,691.08$496,351.00$272,285$524,349$473,876$434,408$436,395$469,763601.61.63.00.0000GENERAL EXPENSES
$0.00$0.00$0$0$0$0$0$0601.61.63.00.5101SALARIES AND WAGES-OTHER
$0.00$0.00$0$0$0$0$0$0601.61.63.00.5201FICA
$0.00$0.00$0$0$0$0$0$0601.61.63.00.5202PENSION
$0.00$0.00$0$0$0$0$0$0601.61.63.00.5203HEALTH INSURANCE
$0.00$0.00$0$0$0$0$0$0601.61.63.00.5204LIFE INSURANCE
$0.00$0.00$0$0$0$0$0$0601.61.63.00.5229HEALTH INS. ALLOWANCE
$0.00$0.00$0$0$0$0$0$0601.61.63.00.5801OUTSIDE SERVICES
2014
Period 0
2013
Period 14
2013 YTD -
Aug
2013 BudgetActual 2012Actual 2011Actual 2010Actual 2009Account NumberAccount Name
$150,005.59$142,984.00$69,258$145,761$142,194$133,928$127,941$147,276601.61.63.40.0000OFFICE SALARIES
$120,505.59$113,484.00$69,258$116,011$113,448$106,462$100,796$120,444601.61.63.40.5101SALARIES & WAGES
$0.00$0.00$0$250$0$0$0$0601.61.63.40.5102OVERTIME
$0.00$0.00$0$0$0$0$0$0601.61.63.40.5201FICA
$0.00$0.00$0$0$0$0$0$0601.61.63.40.5202PENSION
$0.00$0.00$0$0$0$0$0$0601.61.63.40.5203HEALTH
$0.00$0.00$0$0$0$0$0$0601.61.63.40.5204LIFE
$29,500.00$29,500.00$0$29,500$28,746$27,466$27,145$26,832601.61.63.40.6056METER EXPENSE
$250,915.49$227,087.00$147,835$229,012$212,089$205,920$205,379$205,650601.61.63.41.0000EMPLOYEES' PENSION & BENEFITS
$44,700.44$43,394.00$26,258$44,131$41,649$40,056$40,631$40,360601.61.63.41.5201FICA
$37,366.20$35,428.00$22,278$35,020$31,012$41,367$56,616$53,073601.61.63.41.5202PENSION
$159,315.93$139,699.00$94,963$141,286$130,563$116,684$100,274$103,960601.61.63.41.5203HEALTH
$1,466.52$1,172.00$789$1,181$1,125$1,031$975$1,147601.61.63.41.5204LIFE
$194.40$194.00$95$194$160$117$98$91601.61.63.41.5205FSA FEE EXPENSE
$7,872.00$7,200.00$3,453$7,200$7,580$6,664$6,785$7,020601.61.63.41.5229HEALTH ALLOWANCE
$66,440.00$62,580.00$33,800$65,080$70,065$53,231$57,355$50,453601.61.63.42.0000OFFICE SUPPLIES & EXPENSE
$0.00$0.00$0$0$0$0$0$0601.61.63.42.5102INSURANCE
$6,500.00$6,500.00$2,020$6,500$9,840$6,888$5,185$451601.61.63.42.5430ALARMS & ALARM MAINTENANCE
$9,500.00$9,500.00$5,244$9,500$9,748$2,849$3,150$4,965601.61.63.42.5509COMPUTER SERVICES
$960.00$1,380.00$704$1,380$3,862$2,923$5,061$2,472601.61.63.42.5606TELEPHONE
$7,000.00$7,000.00$6,767$6,000$8,933$6,671$11,359$9,965601.61.63.42.5701GENERAL OFFICE SUPPLIES
$2,000.00$0.00$0$2,000$0$0$0$0601.61.63.42.6020UNEMPLOYMENT COMPENSATION
$3,000.00$1,500.00$566$3,000$1,484$0$0$0601.61.63.42.6056OTHER ADMIN TRAINING/CONF
$10,200.00$10,000.00$5,000$10,000$10,000$10,000$10,000$10,000601.61.63.42.6101WORKERS'S COMPENSATION
$18,360.00$18,000.00$9,000$18,000$17,600$15,500$15,000$15,000601.61.63.42.6102LIAB INSURANCE-SWR BACKUP
$7,900.00$7,700.00$4,000$7,700$7,600$7,100$6,600$6,600601.61.63.42.6103PROPERTY INSURANCE
$1,020.00$1,000.00$500$1,000$1,000$1,300$1,000$1,000601.61.63.42.6104AUTO INSURANCE
$84,330.00$63,700.00$21,392$84,496$49,528$41,329$45,720$66,385601.61.63.43.0000OUTSIDE SERVICES
$5,000.00$5,000.00$0$5,000$671$1,350$1,022$0601.61.63.43.5509COMPUTER CHARGES/SEWER
$5,000.00$5,000.00$3,162$5,000$4,044$3,440$3,011$3,134601.61.63.43.5801PROFESSIONAL SERVICES
2014
Period 0
2013
Period 14
2013 YTD -
Aug
2013 BudgetActual 2012Actual 2011Actual 2010Actual 2009Account NumberAccount Name
$8,000.00$4,000.00$294$8,000$2,334$1,485$2,733$3,234601.61.63.43.5805LEGAL FEES
$12,000.00$12,000.00$2,300$12,000$11,440$8,000$11,220$11,000601.61.63.43.5810ACCOUNTING & COLLECTION
$25,000.00$10,000.00$1,786$25,000$5,355$1,554$5,012$24,809601.61.63.43.5815ENGINEERING FEES
$0.00$0.00$0$0$0$0$0$0601.61.63.43.5824AMORTIZATION MAPPING
$0.00$0.00$0$0$0$0$0$0601.61.63.43.5840PROGRAMMING & CONSULTING
$0.00$0.00$0$0$0$0$0$603601.61.63.43.6056OTHER EXPENSE
$29,330.00$27,700.00$13,850$28,046$25,684$25,499$22,723$22,723601.61.63.43.6057ADMINISTRATIVE CHARGE
$0.00$0.00$0$1,450$0$0$0$883601.61.63.43.6505COMPUTER REPLACEMENT
$1,135,000.00$1,113,734.00$0$1,175,000$1,095,057$1,064,640$1,134,988$1,116,223601.61.64.00.0000DEPRECIATION EXPENSE
$1,135,000.00$1,113,734.00$0$1,175,000$1,095,057$1,064,640$1,134,988$1,116,223601.61.64.50.0000DEPRECIATION
$1,135,000.00$1,113,734.00$0$1,175,000$1,095,057$1,064,640$1,134,988$1,116,223601.61.64.50.6705DEPRECIATION
$84,590.00$96,570.00$49,368$96,570$107,828$117,219$126,437$135,419601.62.00.00.0000NON-OPERATING EXPENSES
$84,590.00$96,570.00$49,368$96,570$107,828$117,219$126,437$135,41960162650000006016265000000
$78,647.00$90,627.00$49,368$90,627$101,885$111,277$120,494$129,476601.62.65.60.0000INTEREST EXPENSE
$78,647.00$90,627.00$49,368$90,627$101,885$111,277$120,494$129,476601.62.65.60.7010INTEREST EXPENSE
$5,943.00$5,943.00$0$5,943$5,943$5,943$5,943$5,943601.62.65.61.0000AMORTIZATION OF DEBT DISCOUNT
$5,943.00$5,943.00$0$5,943$5,943$5,943$5,943$5,943601.62.65.61.7015AMORTIZATION OF BOND DISCOUN
$0.00$0.00$0$0$0$0$0$0601.62.65.62.0000AMORTIZATION OF PROPERTY LOSS
$0.00$0.00$0$0$0$0$0$0601.62.65.62.6401AMORTIZATION OF PROPERTY LOS
$45,333.00$45,333.00$0$45,333$45,333$45,333$45,333$45,333601.63.00.00.0000EXTRAORDINARY LOSS
$45,333.00$45,333.00$0$45,333$45,333$45,333$45,333$45,33360163660000006016366000000
$45,333.00$45,333.00$0$45,333$45,333$45,333$45,333$45,333601.63.66.70.0000EXTRAORDINARY LOSS
$45,333.00$45,333.00$0$45,333$45,333$45,333$45,333$45,333601.63.66.70.7020EXTRAORDINARY LOSS/DEBT DISC
$0.00$0.00$0$0$0$0$0$0601.64.00.00.0000CONTINGENCY
$0.00$0.00$0$0$0$0$0$060164670000006016467000000
$0.00$0.00$0$0$0$0$0$0601.64.67.00.6601CONTINGENCY
$250,500.00$11,000.00$1,870$3,500$77,539$19,816$4,853$29,395601.65.00.00.0000CAPITAL SEWER PROJECTS
$0.00$0.00$0$0$0$0$0$0601.65.00.00.6201RYANCREEK INTERCEPTOR-FRANKLIN
$0.00$0.00$0$0$0$0$0$0601.65.00.00.6202RYAN CREEK INTERCEPTOR-MUSKEGO
$0.00$0.00$0$0$0$0$0$0601.65.00.00.6203MCSHANE LIFT STATION
2014
Period 0
2013
Period 14
2013 YTD -
Aug
2013 BudgetActual 2012Actual 2011Actual 2010Actual 2009Account NumberAccount Name
$0.00$0.00$0$0$0$0$0$0601.65.00.00.6204JANESVILLE RECONSTRUCTION
$0.00$0.00$0$0$0$14,571$0$0601.65.00.00.6205LAKE LORE LIFT STATION
$0.00$0.00$0$0$0$0$0$0601.65.00.00.6206JANESVILLE RD SWR MSS-02-02
$0.00$0.00$0$0$0$0$0$0601.65.00.00.6207DURHAM DRIVE SANI SWR EXT
$0.00$0.00$0$0$0$0$0$0601.65.00.00.6208WOODS RD FORCEMAIN EXT PROJECT
$0.00$0.00$0$0$0$0$0$0601.65.00.00.6209SCADA RENOVATION (RADIO STUDY)
$0.00$0.00$0$0$0$0$0$26,719601.65.00.00.6210MUSKEGO'S FACILITY PLAN
$0.00$0.00$0$0$0$0$0$0601.65.00.00.6211SOUTHEAST SEWER PROJ EXPENSE
$0.00$0.00$0$0$0$0$0$0601.65.00.00.6212BOXHORN/GROVEWAY/RYAN MSS193
$500.00$1,000.00$291$3,500$1,634$3,510$4,853$2,676601.65.00.00.6213MMSD FACILITY PLAN-MUSKEGO'S %
$0.00$0.00$0$0$0$0$0$0601.65.00.00.6214WOODS RD. (RACINE/BROOKE LN)
$0.00$0.00$0$0$0$0$0$0601.65.00.00.6215GIS
$0.00$0.00$0$0$0$0$0$0601.65.00.00.6216WDS RD/KURTZE/BAY LN MSS3-99
$0.00$0.00$0$0$0$0$0$0601.65.00.00.62172000 MUSK SANITARY MANHOLE
$0.00$0.00$0$0$0$0$0$0601.65.00.00.6218WOODS RD FORCEMAIN S. BEACH
$0.00$0.00$0$0$0$0$0$0601.65.00.00.6219SUPERIOR EPI LIFTSTAT MSS201
$0.00$0.00$0$0$0$0$0$0601.65.00.00.6220RYAN ROAD RELAY
$0.00$0.00$0$0$0$0$0$0601.65.00.00.6275FORCED HOOK UPS
$250,000.00$10,000.00$1,579$0$75,905$1,735$0$0601.65.00.00.6516PRIVATE PROP I&I MMSD PROGRAM
2014
Period 0
2013
Period 14
2013 YTD -
Aug
2013 BudgetActual 2012Actual 2011Actual 2010Actual 2009Account NumberAccount Name
$5,944,805.84$5,914,194.82$2,999,301$5,986,695$6,079,271$6,311,907$6,011,280$6,347,400601.00.00.00.0000SEWER FUND
-
$5,807,366.00
-
$5,781,300.00
$2,987,202$5,949,200$5,997,967$5,957,463$5,966,537$5,969,123601.48.00.00.0000OPERATING REVENUE
$5,891,866.00$5,865,000.00$2,954,787$5,865,000$5,913,885$5,872,278$5,868,107$5,881,915601.48.00.00.4801SEWER SERVICE CHARGES
$75,000.00$74,000.00$27,611$75,000$73,575$74,922$75,805$68,469601.48.00.00.4810CUSTOMER PENALTIES
$0.00$0.00$0$0$0$555$13,175$10,100601.48.00.00.4820MISCELLANEOUS SEWER REVENUES
$2,500.00$2,200.00$0$2,200$3,000$2,205$2,520$1,950601.48.00.00.4822CLOSING STATEMENTS
$0.00$0.00$0$0$0$0$0$360601.48.00.00.4823CAMERA TRUCK FEE
$7,000.00$7,500.00$4,804$7,000$7,506$7,503$6,930$6,328601.48.00.00.4824LOCATE SERVICE REVENUE
-$14,439.84-$15,494.82$12,099$37,495$81,304$354,444$44,743$378,277601.49.00.00.0000NON-OPERATING REVENUE
$23,000.00$25,000.00$3,594$25,000$29,451$25,552$40,716$88,979601.49.00.00.4531INTEREST FROM INVESTMENTS
$7,560.16$8,505.18$8,505$11,495$14,433$1,627$379$1,213601.49.00.00.4910INTEREST SPECIAL ASSMTS
$1,000.00$1,000.00$0$1,000$3,397$3,624$3,648$5,970601.49.00.00.4920MISC REVENUE
$0.00$0.00$0$0$0$0$0$0601.49.00.00.4950CITY SUBSIDIES FOR MMSD CAPI
$0.00$0.00$0$0$34,023$323,640$0$282,115601.49.00.00.4960CAPITAL CONTRIBUTIONS
$0.00$0.00$0$0$0$0$0$0601.49.00.00.8101TRANSFER FROM CITY
DRAFT-Sanitary Sewer Budget (Revenues)- 9-12-13
2014
Period 0
2013
Period 14
2013 YTD -
Aug
2013 BudgetActual 2012Actual 2011Actual 2010Actual 2009Account NumberAccount Name
$2,256,288.91$2,200,247.19$599,550$2,228,749$2,156,544$2,258,224$2,212,084$2,076,027605.00.00.00.0000WATER FUND
$1,298.17$1,291.00$666$1,303$0$0$0$0605.50.00.00.0000SALES REVENUE
$1,298.17$1,291.00$666$1,303$0$0$0$0605.50.00.00.5101SALARIES/WAGES METER INSTALL
$0.00$0.00$0$0$0$0$0$0605.50.00.00.5201FICA
$0.00$0.00$0$0$0$0$0$0605.50.00.00.5202PENSION
$0.00$0.00$0$0$0$0$0$0605.50.00.00.5203HEALTH
$0.00$0.00$0$0$0$0$0$0605.50.00.00.5204LIFE
$12,775.84$11,690.00$7,096$12,648$6,589$2,310$5,388$3,151605.51.00.00.0000SOURCE OF SUPPLY
$12,775.84$11,690.00$7,096$12,648$6,589$2,310$5,388$3,151605.51.06.00.0000OPERATION LABOR
$1,925.84$1,890.00$669$1,898$783$979$981$845605.51.06.00.5101WELL - LABOR
$0.00$0.00$0$0$0$0$0$0605.51.06.00.5102OVERTIME
$0.00$0.00$0$0$0$0$0$0605.51.06.00.5201FICA
$0.00$0.00$0$0$0$0$0$0605.51.06.00.5202PENSION
$0.00$0.00$0$0$0$0$0$0605.51.06.00.5203HEALTH
$0.00$0.00$0$0$0$0$0$0605.51.06.00.5204LIFE
$0.00$0.00$0$0$0$0$0$0605.51.06.00.5229HEALTH ALLOWANCE
$850.00$800.00$433$750$4,575$324$516$0605.51.06.02.0000OPERATING SUPPLIES & EXPENSE
$0.00$0.00$0$0$0$0$0$0605.51.06.02.5302MILEAGE
$0.00$0.00$0$0$0$0$0$0605.51.06.02.5410OTHER EQUIP MAINT & RENTAL
$750.00$750.00$433$750$4,575$284$516$0605.51.06.02.5702WELL-OPRTIN SUPPLIES/EXPENSE
$100.00$50.00$0$0$0$40$0$0605.51.06.02.5731SMALL TOOLS & MINOR EQUIPMEN
$0.00$0.00$0$0$0$0$0$0605.51.06.02.5910GAS & ELECTRIC
$10,000.00$9,000.00$5,995$10,000$1,231$1,006$3,891$2,306605.51.06.05.0000MAINT OF WATER SOURCE PLANT
$10,000.00$9,000.00$5,995$10,000$1,231$1,006$3,891$2,306605.51.06.05.5702WELL MAINTENANCE
$167,838.54$152,175.00$99,680$151,124$160,036$158,274$146,288$124,904605.52.00.00.0000PUMPING EXPENSES
$167,838.54$152,175.00$99,680$151,124$160,036$158,274$146,288$124,90460552060000006055206000000
$69,850.97$67,000.00$45,148$63,097$64,708$62,327$63,740$42,917605.52.06.20.0000OPERATION LABOR
$65,659.84$65,000.00$44,486$60,823$64,178$61,157$62,172$41,583605.52.06.20.5101PUMPING - LABOR
$4,191.13$2,000.00$663$2,274$530$1,169$1,568$1,334605.52.06.20.5102OVERTIME
$0.00$0.00$0$0$0$0$0$0605.52.06.20.5201FICA
DRAFT-Water Budget (Expenses)- 9-12-13
2014
Period 0
2013
Period 14
2013 YTD -
Aug
2013 BudgetActual 2012Actual 2011Actual 2010Actual 2009Account NumberAccount Name
$0.00$0.00$0$0$0$0$0$0605.52.06.20.5202PENSION
$0.00$0.00$0$0$0$0$0$0605.52.06.20.5203HEALTH
$0.00$0.00$0$0$0$0$0$0605.52.06.20.5204LIFE
$85,000.00$75,000.00$49,800$75,000$91,652$87,546$73,976$76,634605.52.06.22.0000POWER FOR PUMPING
$0.00$0.00$0$0$0$0$0$0605.52.06.22.5735GASOLINE, OIL, GREASE, TIRES
$85,000.00$75,000.00$49,800$75,000$91,652$87,546$73,976$76,634605.52.06.22.5910PUMPING/FUEL OR POWR PURCHSD
$800.00$500.00$0$800$21$206$518$52605.52.06.23.0000OPERATION SUPPLIES & EXPENSE
$0.00$0.00$0$0$0$0$0$0605.52.06.23.5410OTHER EQUIP MAINT & RENTAL
$800.00$500.00$0$800$21$194$518$41605.52.06.23.5702PUMPING SUPPLIES & EXPENSES
$0.00$0.00$0$0$0$0$0$11605.52.06.23.5731SMALL TOOLS & MINOR EQUIPMEN
$0.00$0.00$0$0$0$12$0$0605.52.06.23.5749BUILDING SUPPLIES
$0.00$0.00$0$0$0$0$0$0605.52.06.23.5910GAS & ELECTRIC
$12,187.57$9,675.00$4,732$12,227$3,656$8,196$8,054$5,301605.52.06.25.0000MAINT OF PUMPING PLANT
$5,719.96$5,675.00$3,962$5,730$1,403$3,136$5,190$4,997605.52.06.25.5101PUMPING - MAINTENANCE
$1,467.61$0.00$0$1,497$0$0$0$0605.52.06.25.5102OVERTIME
$0.00$0.00$0$0$0$0$0$0605.52.06.25.5201FICA
$0.00$0.00$0$0$0$0$0$0605.52.06.25.5202PENSION
$0.00$0.00$0$0$0$0$0$0605.52.06.25.5203HEALTH
$0.00$0.00$0$0$0$0$0$0605.52.06.25.5204LIFE
$0.00$0.00$0$0$0$0$0$0605.52.06.25.5410PUMPING - MAINTENANCE
$5,000.00$4,000.00$769$5,000$2,253$5,060$2,864$305605.52.06.25.5702OPERATING SUPPLIES
$30,338.46$9,180.00$22,335$31,351$22,859$21,670$26,186$38,399605.53.00.00.0000WATER TREATMENT EXPENSES
$30,338.46$9,180.00$22,335$31,351$22,859$21,670$26,186$38,39960553060000006055306000000
$7,405.74$6,500.00$3,935$8,417$4,222$4,906$5,470$15,018605.53.06.30.0000OPERATION LABOR
$7,405.74$6,500.00$3,935$8,417$4,222$4,887$5,470$15,018605.53.06.30.5101WATER TREATMENT LABOR
$0.00$0.00$0$0$0$19$0$0605.53.06.30.5102OVERTIME
$0.00$0.00$0$0$0$0$0$0605.53.06.30.5201FICA
$0.00$0.00$0$0$0$0$0$0605.53.06.30.5202PENSION
$0.00$0.00$0$0$0$0$0$0605.53.06.30.5203HEALTH
$0.00$0.00$0$0$0$0$0$0605.53.06.30.5204LIFE
2014
Period 0
2013
Period 14
2013 YTD -
Aug
2013 BudgetActual 2012Actual 2011Actual 2010Actual 2009Account NumberAccount Name
$21,000.00$1,000.00$17,133$20,000$17,454$16,269$19,662$22,181605.53.06.31.0000CHEMICALS
$1,000.00$1,000.00$773$0$393$629$0$0605.53.06.31.5702OPERATING SUPPLIES
$20,000.00$0.00$16,360$20,000$17,061$15,640$19,662$22,181605.53.06.31.5750CHEMICALS
$1,000.00$1,000.00$862$1,000$285$0$0$400605.53.06.32.0000OPERATION SUPPLIES & EXPENSE
$1,000.00$1,000.00$862$1,000$285$0$0$400605.53.06.32.5702WTR TREATMENT SUPPLIES/EXP.
$932.72$680.00$405$1,934$898$495$1,053$800605.53.06.35.0000MAINT OF WATER TREATMENT PLANT
$432.72$430.00$405$434$898$495$114$800605.53.06.35.5101WATER TREATMENT-MAINTENANCE
$0.00$0.00$0$0$0$0$0$0605.53.06.35.5102OVERTIME
$0.00$0.00$0$0$0$0$0$0605.53.06.35.5201FICA
$0.00$0.00$0$0$0$0$0$0605.53.06.35.5202PENSION
$0.00$0.00$0$0$0$0$0$0605.53.06.35.5203HEALTH
$0.00$0.00$0$0$0$0$0$0605.53.06.35.5204LIFE
$0.00$0.00$0$0$0$0$0$0605.53.06.35.5410WATER TREATMENT-MAINTENANCE
$500.00$250.00$0$1,500$0$0$939$0605.53.06.35.5702OPERATING SUPPLIES
$116,283.21$128,153.00$84,461$114,641$102,790$167,005$106,484$90,577605.54.00.00.0000TRANSMISSION & DISTRIBUTION
$116,283.21$128,153.00$84,461$114,641$102,790$167,005$106,484$90,57760554060000006055406000000
$60,128.25$57,840.00$29,873$58,760$52,006$52,277$56,415$56,749605.54.06.40.0000OPERATION LABOR
$59,769.82$57,740.00$29,873$58,394$51,949$52,277$56,302$56,592605.54.06.40.5101T & D LABOR
$358.43$100.00$0$366$57$0$113$157605.54.06.40.5102OVERTIME
$0.00$0.00$0$0$0$0$0$0605.54.06.40.5201FICA
$0.00$0.00$0$0$0$0$0$0605.54.06.40.5202PENSION
$0.00$0.00$0$0$0$0$0$0605.54.06.40.5203HEALTH
$0.00$0.00$0$0$0$0$0$0605.54.06.40.5204LIFE
$8,750.00$8,500.00$7,356$8,500$5,996$8,022$6,465$8,054605.54.06.41.0000OPERATION SUPPLIES & EXPENSE
$500.00$500.00$345$500$303$1,645$237$0605.54.06.41.5415T & D SUPPLIES & EXPENSES
$5,000.00$5,000.00$4,337$5,000$2,483$3,269$3,307$5,131605.54.06.41.5702OPERATING SUPPLIES
$3,250.00$3,000.00$2,674$3,000$3,210$3,108$2,922$2,923605.54.06.41.5870LOCATES
$6,057.80$9,000.00$7,736$4,064$4,104$792$7,551$2,801605.54.06.50.0000MAINT OF DISTRIB RESERVIORS
$1,557.80$1,000.00$499$1,564$264$792$1,506$2,801605.54.06.50.5101T&D MAINT/RESVRS & STANDPIPE
$0.00$0.00$0$0$0$0$0$0605.54.06.50.5102OVERTIME
2014
Period 0
2013
Period 14
2013 YTD -
Aug
2013 BudgetActual 2012Actual 2011Actual 2010Actual 2009Account NumberAccount Name
$0.00$0.00$0$0$0$0$0$0605.54.06.50.5201FICA
$0.00$0.00$0$0$0$0$0$0605.54.06.50.5202PENSION
$4,500.00$8,000.00$7,237$2,500$3,840$0$6,045$0605.54.06.50.5702T&D MAINT/RESVRS & STANDPIPE
$17,963.66$28,706.00$23,876$17,987$13,780$72,416$11,710$8,505605.54.06.51.0000MAINTENANCE OF MAINS
$5,759.94$5,000.00$2,730$5,779$2,621$10,936$4,850$5,143605.54.06.51.5101T & D MAINTENANCE OF MAINS
$203.72$206.00$39$208$227$1,138$0$253605.54.06.51.5102OVERTIME
$0.00$0.00$0$0$0$0$0$0605.54.06.51.5201FICA
$0.00$0.00$0$0$0$0$0$0605.54.06.51.5202PENSION
$0.00$0.00$0$0$0$0$0$0605.54.06.51.5203HEALTH
$0.00$0.00$0$0$0$0$0$0605.54.06.51.5204LIFE
$10,000.00$22,000.00$21,108$10,000$8,617$58,223$6,842$3,102605.54.06.51.5410T & D MAINTENANCE OF MAINS
$2,000.00$1,500.00$0$2,000$2,315$2,119$18$7605.54.06.51.5702OPERATING SUPPLIES
$1,798.17$3,100.00$2,589$2,803$2,078$2,999$1,129$2,926605.54.06.52.0000MAINTENANCE OF SERVICES
$1,298.17$2,500.00$2,208$2,303$2,061$2,216$1,125$2,551605.54.06.52.5101T&D MAINTENANCE OF SERVICES
$0.00$100.00$59$0$0$0$0$0605.54.06.52.5102OVERTIME
$0.00$0.00$0$0$0$0$0$0605.54.06.52.5201FICA
$0.00$0.00$0$0$0$0$0$0605.54.06.52.5202PENSION
$0.00$0.00$0$0$0$0$0$0605.54.06.52.5203HEALTH
$0.00$0.00$0$0$0$0$0$0605.54.06.52.5204LIFE
$0.00$0.00$0$0$0$0$0$0605.54.06.52.5410T&D MAINTENANCE OF SERVICES
$500.00$500.00$322$500$17$783$4$375605.54.06.52.5702OPERATING SUPPLIES
$3,298.17$2,500.00$1,623$2,303$3,090$5,068$1,160$1,789605.54.06.53.0000MAINTENANCE OF METERS
$2,298.17$2,000.00$1,519$1,303$2,702$1,689$1,115$1,476605.54.06.53.5101T & D MAINTENANCE OF METERS
$0.00$0.00$0$0$0$0$0$0605.54.06.53.5102OVERTIME
$0.00$0.00$0$0$0$0$0$0605.54.06.53.5201FICA
$0.00$0.00$0$0$0$0$0$0605.54.06.53.5202PENSION
$0.00$0.00$0$0$0$0$0$0605.54.06.53.5203HEALTH
$0.00$0.00$0$0$0$0$0$0605.54.06.53.5204LIFE
$0.00$0.00$0$0$0$0$0$0605.54.06.53.5410T & D MAINTENANCE OF METERS
$1,000.00$500.00$104$1,000$388$3,379$45$313605.54.06.53.5702OPERATING SUPPLIES
2014
Period 0
2013
Period 14
2013 YTD -
Aug
2013 BudgetActual 2012Actual 2011Actual 2010Actual 2009Account NumberAccount Name
$17,654.44$17,607.00$10,694$19,690$20,612$25,328$21,715$9,323605.54.06.54.0000MAINTENANCE OF HYDRANTS
$10,654.44$10,607.00$6,920$12,690$11,971$15,302$14,578$6,687605.54.06.54.5101T & D MAINT OF HYDRANTS
$0.00$0.00$0$0$0$50$0$0605.54.06.54.5102OVERTIME
$0.00$0.00$0$0$0$0$0$0605.54.06.54.5201FICA
$0.00$0.00$0$0$0$0$0$0605.54.06.54.5202PENSION
$0.00$0.00$0$0$0$0$0$0605.54.06.54.5203HEALTH
$0.00$0.00$0$0$0$0$0$0605.54.06.54.5204LIFE
$0.00$0.00$0$0$0$0$0$0605.54.06.54.5410T & D MAINT OF HYDRANTS
$7,000.00$7,000.00$3,774$7,000$8,641$9,976$7,137$2,636605.54.06.54.5702OPERATING SUPPLIES
$632.72$900.00$714$534$1,124$103$340$429605.54.06.55.0000MAINTENANCE OF OTHER PLANT
$432.72$300.00$116$434$1,063$0$327$429605.54.06.55.5101T&D MAINT OF OTHER PLANT
$0.00$0.00$0$0$0$0$0$0605.54.06.55.5102OVERTIME
$0.00$0.00$0$0$0$0$0$0605.54.06.55.5201FICA
$0.00$0.00$0$0$0$0$0$0605.54.06.55.5202PENSION
$0.00$0.00$0$0$0$0$0$0605.54.06.55.5203HEALTH
$0.00$0.00$0$0$0$0$0$0605.54.06.55.5204LIFE
$0.00$0.00$0$0$0$3$0$0605.54.06.55.5410T&D MAINT OF OTHER PLANT
$200.00$600.00$598$100$61$100$13$0605.54.06.55.5702OPERATING SUPPLIES
$32,938.43$31,688.00$19,182$29,490$25,572$23,787$31,642$37,378605.55.00.00.0000CUSTOMER ACCOUNTS EXPENSES
$32,938.43$31,688.00$19,182$29,490$25,572$23,787$31,642$37,37860555090000006055509000000
$2,980.44$3,400.00$2,181$2,930$1,628$1,980$2,088$1,503605.55.09.01.0000METER READING LABOR
$2,980.44$3,400.00$2,181$2,930$1,628$1,980$2,088$1,503605.55.09.01.5101METER READING - LABOR
$0.00$0.00$0$0$0$0$0$0605.55.09.01.5102OVERTIME
$0.00$0.00$0$0$0$0$0$0605.55.09.01.5201FICA
$0.00$0.00$0$0$0$0$0$0605.55.09.01.5202PENSION
$0.00$0.00$0$0$0$0$0$0605.55.09.01.5203HEALTH
$0.00$0.00$0$0$0$0$0$0605.55.09.01.5204LIFE
$16,707.99$16,488.00$7,558$13,560$12,891$12,784$14,079$22,296605.55.09.02.0000ACCOUNTING & COLLECTION LABOR
$16,707.99$16,488.00$7,558$13,560$12,891$12,784$14,079$22,296605.55.09.02.5101METER - COLLECTN & ACCOUNTNG
$0.00$0.00$0$0$0$0$0$0605.55.09.02.5102OVERTIME
2014
Period 0
2013
Period 14
2013 YTD -
Aug
2013 BudgetActual 2012Actual 2011Actual 2010Actual 2009Account NumberAccount Name
$0.00$0.00$0$0$0$0$0$0605.55.09.02.5201FICA
$0.00$0.00$0$0$0$0$0$0605.55.09.02.5202PENSION
$0.00$0.00$0$0$0$0$0$0605.55.09.02.5203HEALTH
$0.00$0.00$0$0$0$0$0$0605.55.09.02.5204LIFE
$13,250.00$11,800.00$9,442$13,000$11,053$9,022$15,475$13,578605.55.09.03.0000SUPPLIES & EXPENSES
$1,000.00$800.00$502$1,000$0$0$2,415$1,502605.55.09.03.5410METER SUPPLIES & EXPENSES
$3,000.00$2,500.00$1,536$3,000$2,692$2,573$2,793$3,832605.55.09.03.5702OPERATING SUPPLIES
$9,250.00$8,500.00$7,404$9,000$8,360$6,449$10,268$8,244605.55.09.03.5710POSTAGE & BILLING
$0.00$0.00$0$0$0$0$0$0605.55.09.03.6070OVERS/SHORTS
$0.00$0.00$0$0$0$0$0$0605.55.09.03.6090BANK SERVICE CHARGES
$390,285.73$351,799.00$243,218$349,669$314,146$311,019$327,135$306,703605.56.00.00.0000ADMINISTRATIVE & GENERAL EXPS
$390,285.73$351,799.00$243,218$349,669$314,146$311,019$327,135$306,70360556090000006055609000000
$0.00$0.00$0$0$0$0$0$0605.56.09.02.0000GENERAL EXPENSES
$0.00$0.00$0$0$0$0$0$0605.56.09.02.5101CLEARING/SICK LEAVE/VAC/HOL
$0.00$0.00$0$0$0$0$0$0605.56.09.02.5102SALARIES & WAGES - OVERTIME
$0.00$0.00$0$0$0$0$0$0605.56.09.02.5201FICA
$0.00$0.00$0$0$0$0$0$0605.56.09.02.5202PENSION
$0.00$0.00$0$0$0$0$0$0605.56.09.02.5203HEALTH
$0.00$0.00$0$0$0$0$0$0605.56.09.02.5204LIFE
$142,414.04$130,299.00$101,289$125,390$126,871$118,061$114,576$113,846605.56.09.20.0000ADMIN & GENERAL SALARIES
$142,414.04$130,299.00$101,289$125,390$126,871$118,061$114,305$113,836605.56.09.20.5101ADMIN & GENERAL SALARIES
$0.00$0.00$0$0$0$0$271$9605.56.09.20.5102OVERTIME
$0.00$0.00$0$0$0$0$0$0605.56.09.20.5201FICA
$0.00$0.00$0$0$0$0$0$0605.56.09.20.5202PENSION
$0.00$0.00$0$0$0$0$0$0605.56.09.20.5203HEALTH
$0.00$0.00$0$0$0$0$0$0605.56.09.20.5204LIFE
$30,960.00$30,125.00$19,850$30,100$21,196$21,236$24,398$17,992605.56.09.21.0000OFFICE SUPPLIES & EXPENSE
$1,000.00$800.00$490$500$1,815$0$641$222605.56.09.21.5301TRAINING
$0.00$0.00$0$0$0$0$0$0605.56.09.21.5302MILEAGE
$1,500.00$1,400.00$1,475$1,000$195$1,087$1,059$170605.56.09.21.5303CONFERENCES & SPECIAL EVENTS
2014
Period 0
2013
Period 14
2013 YTD -
Aug
2013 BudgetActual 2012Actual 2011Actual 2010Actual 2009Account NumberAccount Name
$50.00$25.00$0$50$0$0$36$0605.56.09.21.5305MEMBERSHIPS & DUES
$0.00$0.00$0$0$0$0$0$0605.56.09.21.5306TRANSPORTATION EXPENSE
$100.00$100.00$61$100$118$85$37$5605.56.09.21.5401COPIER MAINTENANCE
$1,450.00$1,450.00$0$1,450$0$0$0$0605.56.09.21.5510COMPUTER CHARGES/WATER
$960.00$1,200.00$607$1,200$886$733$1,011$1,106605.56.09.21.5607TELEPHONE/PAGERS/RADIOS
$1,000.00$1,000.00$831$1,000$446$463$1,037$757605.56.09.21.5712OFFICE SUPPLIES & EXPENSES
$900.00$800.00$555$800$973$953$780$744605.56.09.21.5835UNIFORM RENTAL
$11,000.00$10,500.00$5,323$11,000$6,651$8,281$7,653$13,698605.56.09.21.5910GAS & ELECTRIC
$12,000.00$12,000.00$10,207$12,000$8,460$8,996$11,668$862605.56.09.21.5915SEWER & WATER
$1,000.00$850.00$300$1,000$1,652$637$476$428605.56.09.21.6056OTHER EXPENSE
$0.00$0.00$7,138$0$0$0$0$0605.56.09.22.0000ADMINISTRATIVE CLEARNING ACCT
$0.00$0.00$7,138$0$0$0$0$0605.56.09.22.5101PAYROLL CLEARING SICK/VAC/HL
$0.00$0.00$0$0$0$0$0$0605.56.09.22.5201FICA
$0.00$0.00$0$0$0$0$0$0605.56.09.22.5202PENSION
$0.00$0.00$0$0$0$0$0$0605.56.09.22.5203HEALTH
$0.00$0.00$0$0$0$0$0$0605.56.09.22.5204LIFE
$56,508.00$48,500.00$23,936$56,508$42,097$45,514$53,788$52,996605.56.09.23.0000OUTSIDE SERVICES
$10,508.00$8,000.00$3,919$10,508$5,526$5,149$4,122$3,460605.56.09.23.5510COMPUTER CHARGES/WATER
$9,500.00$7,500.00$4,694$9,500$14,057$568$5,354$4,242605.56.09.23.5620SCADA/WATER
$8,000.00$6,000.00$3,605$8,000$5,092$9,495$10,560$13,614605.56.09.23.5805ATTORNEY
$13,500.00$12,000.00$3,000$13,500$9,000$11,000$12,550$13,089605.56.09.23.5810AUDIT & SPECIAL A/C SERVICES
$10,000.00$10,000.00$7,297$10,000$5,199$193$12,071$11,987605.56.09.23.5815OUTSIDE SERVIES EMPLOYED
$5,000.00$5,000.00$1,420$5,000$3,223$19,108$6,131$3,604605.56.09.23.5865WATER TESTING
$0.00$0.00$0$0$0$0$0$0605.56.09.23.6001MISC LAKE BILL
$0.00$0.00$0$0$0$0$3,000$3,000605.56.09.23.6057ADMINISTRATIVE CHARGES
$0.00$0.00$0$0$0$0$0$0605.56.09.24.0000PROPERTY INSURANCE
$0.00$0.00$0$0$0$0$0$0605.56.09.24.6103PROPERTY INSURANCE
$16,250.00$15,500.00$8,200$15,500$15,460$15,100$15,300$15,708605.56.09.25.0000INJURIES & DAMAGES
$9,900.00$9,600.00$5,100$9,600$9,600$9,100$9,600$9,494605.56.09.25.6101INJURIES AND DAMAGES
$3,900.00$3,700.00$1,900$3,700$3,700$3,500$3,300$4,080605.56.09.25.6102LIABILITY INSURANCE
2014
Period 0
2013
Period 14
2013 YTD -
Aug
2013 BudgetActual 2012Actual 2011Actual 2010Actual 2009Account NumberAccount Name
$1,500.00$1,300.00$750$1,300$1,300$1,400$1,500$1,534605.56.09.25.6103PROPERTY INSURANCE
$950.00$900.00$450$900$860$1,100$900$600605.56.09.25.6104AUTO INSURANCE
$0.00$0.00$0$0$0$0$0$0605.56.09.25.6106INJURIES & DAMAGES-OTHER PROP
$122,153.69$106,575.00$69,773$100,785$85,779$87,779$94,512$87,382605.56.09.26.0000EMPLOYEE PENSION & BENEFITS
$0.00$0.00$0$0$0$0$0$0605.56.09.26.5201EMPLOYEE PENSION & BENEFITS
$22,372.53$21,024.00$14,404$20,906$17,025$24,375$31,661$30,529605.56.09.26.5202PENSION
$94,096.58$80,000.00$50,887$74,415$68,155$62,822$62,272$56,216605.56.09.26.5203HEALTH INSURANCE
$788.58$655.00$511$664$598$582$579$637605.56.09.26.5204LIFE INSURANCE
$4,896.00$4,896.00$3,971$4,800$0$0$0$0605.56.09.26.5229HEALTH INS. ALLOWANCE
$0.00$0.00$0$0$0$0$0$0605.56.09.28.0000REGULATORY COMMISSION EXPENSE
$0.00$0.00$0$0$0$0$0$0605.56.09.28.6066REGULATORY COMMISSION EXPNSE
$6,000.00$5,450.00$3,374$5,800$6,050$5,410$4,320$6,197605.56.09.30.0000MISC GENERAL EXPENSE
$0.00$0.00$0$0$0$0$0$0605.56.09.30.5101SALARIES AND WAGES
$2,200.00$1,800.00$817$2,000$2,469$2,367$2,197$2,524605.56.09.30.5228CLOTHING/SAFETY GLASSES/SHOES
$1,500.00$1,400.00$897$1,500$1,389$1,349$491$1,985605.56.09.30.5305DUES, MEMBERSHIPS & TESTING
$300.00$250.00$124$300$200$198$210$123605.56.09.30.5620SCADA TELEPHONE/WATER
$2,000.00$2,000.00$1,536$2,000$1,993$1,497$1,422$1,565605.56.09.30.6001NOTICES AND PUBLICATIONS
$0.00$0.00$0$0$0$0$0$0605.56.09.30.6056OTHER EXPENSE
$0.00$0.00$0$0$0$0$0$0605.56.09.30.6070BANK SERVICE CHARGE
$16,000.00$15,350.00$9,658$15,586$16,691$17,919$15,863$12,583605.56.09.33.0000TRANSPORTATION EXPENSE
$0.00$0.00$0$86$0$175$0$0605.56.09.33.5101TRANSPORTATION EXPENSE
$0.00$0.00$0$0$0$0$0$0605.56.09.33.5102OVERTIME
$0.00$0.00$0$0$0$0$0$0605.56.09.33.5201FICA
$0.00$0.00$0$0$0$0$0$0605.56.09.33.5202PENSION
$0.00$0.00$0$0$0$0$0$0605.56.09.33.5203HEALTH
$0.00$0.00$0$0$0$0$0$0605.56.09.33.5204LIFE
$500.00$350.00$171$500$382$3,012$509$0605.56.09.33.5405TRANSPORTATION EXPENSE
$0.00$0.00$0$0$0$0$0$0605.56.09.33.5421VEHICLE LEASE
$15,500.00$15,000.00$9,487$15,000$16,310$14,732$15,354$12,583605.56.09.33.5735GASOLINE, OIL, GREASE, TIRES
$0.00$0.00$0$0$0$0$0$0605.56.09.33.6104AUTO INSURANCE
2014
Period 0
2013
Period 14
2013 YTD -
Aug
2013 BudgetActual 2012Actual 2011Actual 2010Actual 2009Account NumberAccount Name
$0.00$0.00$0$0$0$0$4,378$0605.56.09.35.0000MAINT OF GENERAL PLANT
$0.00$0.00$0$0$0$0$4,378$0605.56.09.35.6067MISC. GENERAL PLANT
$770,000.00$765,000.00$0$790,000$761,861$768,089$749,038$672,657605.57.00.00.0000DEPRECIATION
$770,000.00$765,000.00$0$790,000$761,861$768,089$749,038$672,65760557040000006055704000000
$770,000.00$765,000.00$0$790,000$761,861$768,089$749,038$672,65760557040300006055704030000
$770,000.00$765,000.00$0$790,000$761,861$768,089$749,038$672,657605.57.04.03.6705DEPRECIATION EXPENSE
$610,613.93$604,510.00$16,445$605,178$601,186$580,058$568,431$507,059605.58.00.00.0000TAXES
$610,613.93$604,510.00$16,445$605,178$601,186$580,058$568,431$507,05960558040000006055804000000
$610,613.93$604,510.00$16,445$605,178$601,186$580,058$568,431$507,05960558040800006055804080000
$25,520.33$24,510.00$16,359$25,084$21,806$22,179$22,034$21,553605.58.04.08.5201FICA
$93.60$0.00$86$94$128$73$86$71605.58.04.08.5205FSA FEE EXPENSE
$0.00$0.00$0$0$0$0$0$0605.58.04.08.6701PSC ASSESSMENT
$585,000.00$580,000.00$0$580,000$579,252$557,805$546,311$485,436605.58.04.08.6805TAXES
$123,916.60$144,761.19$106,467$143,345$161,506$226,012$251,492$295,199605.59.00.00.0000NON-OPERATING EXPENSES
$123,916.60$144,761.19$106,467$143,345$161,506$226,012$251,492$295,19960559040000006055904000000
$185,000.00$198,685.00$106,467$210,000$214,059$289,030$312,848$355,012605.59.04.27.0000INTEREST ON LONG TERM DEBT
$0.00$0.00$0$0$0$0$0$0605.59.04.27.7004DEBT DISCOUNT
$0.00$0.00$0$0$0$0$0$0605.59.04.27.7005ISSUANCE COSTS
$185,000.00$198,685.00$106,467$210,000$214,059$289,030$312,848$355,012605.59.04.27.7010INTEREST EXPENSE
$61,083.40$53,923.81$0($66,655)($52,553)($63,018)($61,356)($59,813)605.59.04.28.0000AMORTIZATION OF DEBT DISCOUNT
$10,571.60$17,731.19$0$5,000$19,102$8,638$10,299$11,842605.59.04.28.7015AMORTIZATION
-$71,655.00-$71,655.00$0($71,655)($71,655)($71,655)($71,655)($71,655)605.59.04.28.7016MISC AMORTIZATION
2014
Period 0
2013
Period 14
2013 YTD -
Aug
2013 BudgetActual 2012Actual 2011Actual 2010Actual 2009Account NumberAccount Name
$1,720,631.31$1,719,752.31$844,399$2,014,544$2,247,767$2,144,998$2,396,262$2,958,528605.00.00.00.0000WATER FUND
-
$1,894,866.00
-
$1,939,444.00
$752,453$1,876,944$1,983,195$1,859,384$1,775,628$1,828,980605.48.00.00.0000OPERATING REVENUE
-$105,134.00-$160,556.00$752,453$1,876,944$1,983,195$1,859,384$1,775,628$1,828,98060548040000006054804000000
-
$1,000,000.00
-
$1,050,000.00
$472,163$990,000$1,082,875$985,813$937,378$969,67160548045700006054804570000
$1,000,000.00$1,050,000.00$472,163$990,000$1,082,875$985,813$937,378$969,671605.48.04.57.4803METERED SALES/RESIDENTIAL
-$171,000.00-$170,500.00$80,492$170,000$173,081$170,807$153,182$167,11060548045800006054804580000
$171,000.00$170,500.00$80,492$170,000$173,081$170,807$153,182$167,110605.48.04.58.4804METERED SALES/COMMERCIAL
-$58,000.00-$57,500.00$28,549$58,000$57,990$58,734$58,764$68,14560548045900006054804590000
$58,000.00$57,500.00$28,549$58,000$57,990$58,734$58,764$68,145605.48.04.59.4805METERED SALES/INDUSTRIAL
$0.00$0.00$0$0$0$0$0$060548046000006054804600000
$0.00$0.00$0$0$0$0$0$0605.48.04.60.4806UNMTRED SLES/GENERAL CUSTMRS
-$40,000.00-$40,000.00$20,214$39,500$40,069$39,757$38,482$38,00260548046200006054804620000
$40,000.00$40,000.00$20,214$39,500$40,069$39,757$38,482$38,002605.48.04.62.4815PRIVATE FIRE PROTECTION
-$448,000.00-$448,000.00$70,644$448,000$448,498$437,376$432,551$431,11560548046300006054804630000
$448,000.00$448,000.00$70,644$448,000$448,498$437,376$432,551$431,115605.48.04.63.4816PUBLIC FIRE PROTECTION
-$49,000.00-$50,000.00$20,317$48,000$54,847$52,092$45,734$48,59460548046400006054804640000
$49,000.00$50,000.00$20,317$48,000$54,847$52,092$45,734$48,594605.48.04.64.4807OTHER SALES PUBLIC AUTHORITIES
-$13,000.00-$13,000.00$5,236$13,000$13,617$13,879$12,804$11,90960548047000006054804700000
$13,000.00$13,000.00$5,236$13,000$13,617$13,879$12,804$11,909605.48.04.70.4821FORFEITED DISCOUNTS
-$113,866.00-$108,444.00$54,838$108,444$103,587$98,721$94,086$93,15960548047200006054804720000
$113,866.00$108,444.00$54,838$108,444$103,587$98,721$94,086$93,159605.48.04.72.4825RENTL WTR PROP TOWER LEASE
-$2,000.00-$2,000.00$0$2,000$8,632$2,205$2,647$1,27560548047400006054804740000
$2,000.00$2,000.00$0$2,000$8,632$2,205$2,647$1,275605.48.04.74.4820OTHER WATER REVENUE
-$174,234.69-$219,691.69$91,946$137,600$264,572$285,614$620,633$1,129,548605.49.00.00.0000NON-OPERATING REVENUE
-$153,765.31-$181,816.31$91,946$137,600$264,572$285,614$620,633$1,129,548605.49.04.00.0000INT ON SPECIAL ASSESSMENTS
$7,734.69$18,937.69$0$0$18,938$0$0$0605.49.04.00.4537BOND PREMIUM
$10,000.00$12,754.00$12,754$25,000$13,712$21,552$21,521$27,793605.49.04.00.4910INTEREST SPECIAL ASSESSMENTS
-$2,500.00-$3,000.00$670$3,000$3,918$2,755$3,551$13,864605.49.04.19.0000INTEREST & DIVIDENT INCOME
$2,500.00$3,000.00$670$3,000$3,918$2,755$3,551$13,864605.49.04.19.4531INTEREST & DIVIDENDS
DRAFT-Water Budget (Revenues)- 9-12-13
2014
Period 0
2013
Period 14
2013 YTD -
Aug
2013 BudgetActual 2012Actual 2011Actual 2010Actual 2009Account NumberAccount Name
-$146,000.00-$175,000.00$78,521$109,600$228,004$261,307$595,561$1,087,890605.49.04.21.0000MISC NON-OPERATING INCOME
$4,000.00$5,000.00$2,921$5,000$4,387$4,385$4,053$3,676605.49.04.21.4920MISC NON OPERATIONAL REVENUE
$0.00$0.00$0$0$3,630$9,029$9,113$25,143605.49.04.21.4921NON-OPER REV-ENG & ATTY REIMB
$0.00$0.00$0$4,600$0$0$137,860$316,114605.49.04.21.4922CLEAN WATER FUND
$150,000.00$180,000.00$75,600$100,000$219,988$247,894$444,536$742,956605.49.04.21.4960CAPITAL CONTRIBUTIONS
$0.00$0.00$0$0$0$0$0$0605.50.00.00.0000SALES REVENUE
$0.00$0.00$0$0$0$0$0$0605.50.00.00.4802WATER SALES