FY2023-Budget

CITY OF WAUPACA REVENUES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 100 - GENERAL FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 10:41AM PAGE: 1 TAXES 100-41110-000-000 TAXES: GENERAL PROPERTY TAXES .00 .00 3,639,218.00 ( 3,639,218.00) .00 100-41140-000-000 TAXES: MOBILE HOME PARKING FEE .00 .00 10,500.00 ( 10,500.00) .00 100-41310-000-000 TAXES: WATER TAX EQUIVALENT .00 .00 200,000.00 ( 200,000.00) .00 100-41320-000-000 TAXES: SEWER TAX EQUIVALENT .00 .00 250,000.00 ( 250,000.00) .00 100-41325-000-000 TAXES: PAYMENT IN LIEU OF TAX .00 .00 53,220.00 ( 53,220.00) .00 100-41330-000-000 TAXES: STATE IN LIEU OF TAX .00 .00 7.00 ( 7.00) .00 TOTAL TAXES .00 .00 4,152,945.00 ( 4,152,945.00) .00 INTERGOVERNMENTAL REVENUES 100-43410-000-000 STATE AID: SHARED REVENUE .00 .00 908,577.51 ( 908,577.51) .00 100-43415-000-000 STATE AID: EXPEND RESTRAINT .00 .00 120,057.00 ( 120,057.00) .00 100-43420-000-000 STATE AID: COMPUTER AID .00 .00 36,020.00 ( 36,020.00) .00 100-43425-000-000 STATE AID: 2% FIRE DUES .00 .00 19,362.00 ( 19,362.00) .00 100-43430-000-000 STATE AID: CABLE FRANCHISE FEE .00 .00 14,343.00 ( 14,343.00) .00 100-43440-000-000 STATE AID: PERSONAL PROP TAX .00 .00 29,925.18 ( 29,925.18) .00 100-43520-000-000 STATE AID: POLICE TRAINING .00 .00 2,400.00 ( 2,400.00) .00 100-43523-000-000 STATE AID: POLICE OTHER .00 .00 15,000.00 ( 15,000.00) .00 100-43530-000-000 STATE AID: GEN TRANSPORTATION .00 .00 487,189.00 ( 487,189.00) .00 100-43535-000-000 STATE AID: CONNECTING STREETS .00 .00 21,065.00 ( 21,065.00) .00 100-43610-000-000 STATE AID: MUNICIPAL SERVICES .00 .00 8,039.00 ( 8,039.00) .00 TOTAL INTERGOVERNMENTAL REVENUES .00 .00 1,661,977.69 ( 1,661,977.69) .00 LICENSES & PERMITS 100-44110-000-000 LICENSES: LIQUOR & MALT BEV .00 .00 14,400.00 ( 14,400.00) .00 100-44115-000-000 LICENSES: OPERATORS .00 .00 6,000.00 ( 6,000.00) .00 100-44120-100-000 LICENSES: AMUSEMENT DEVICE .00 .00 6,750.00 ( 6,750.00) .00 100-44120-110-000 LICENSES: CIGARETTE .00 .00 1,600.00 ( 1,600.00) .00 100-44130-000-000 LICENSES: GARBAGE PICKUP .00 .00 750.00 ( 750.00) .00 100-44220-000-000 LICENSES: DOG: CITY SHARE .00 .00 1,700.00 ( 1,700.00) .00 100-44225-000-000 LICENSES: CATS .00 .00 290.00 ( 290.00) .00 100-44240-000-000 LICENSES: OTHER MISC. .00 .00 2,000.00 ( 2,000.00) .00 100-44305-000-000 PERMITS: OTHER DANCE/PARADE .00 .00 350.00 ( 350.00) .00 100-44310-000-000 PERMITS: BUILDING .00 .00 240,000.00 ( 240,000.00) .00 100-44325-000-000 PERMITS: STREET EXCAVATION .00 .00 11,611.00 ( 11,611.00) .00 100-44920-000-000 PERMITS: CABLE FRANCHISE .00 .00 56,000.00 ( 56,000.00) .00 TOTAL LICENSES & PERMITS .00 .00 341,451.00 ( 341,451.00) .00 CITY OF WAUPACA REVENUES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 100 - GENERAL FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 10:41AM PAGE: 2 COURT FINES & PENALTIES 100-45110-000-000 COURT: TRAFFIC FINES/PENALTIES .00 .00 44,500.00 ( 44,500.00) .00 100-45130-000-000 POLICE: PARKING VIOLATIONS .00 .00 24,000.00 ( 24,000.00) .00 TOTAL COURT FINES & PENALTIES .00 .00 68,500.00 ( 68,500.00) .00 PUBLIC CHARGES FOR SERVICE 100-46110-000-000 FEES: WEIGHTS & MEASURE .00 .00 11,100.00 ( 11,100.00) .00 100-46115-000-000 FEES: LICENSE PUBLICATIONS .00 .00 100.00 ( 100.00) .00 100-46120-000-000 FEES: SPECIAL ASSESSMENT LTRS .00 .00 5,000.00 ( 5,000.00) .00 100-46125-000-000 FEES: COPIES/BACKGROUND CHECKS .00 .00 4,400.00 ( 4,400.00) .00 100-46210-000-000 FEES: POLICE DEPARTMENT .00 .00 3,000.00 ( 3,000.00) .00 100-46310-000-000 FEES: SNOW & ICE CONTROL .00 .00 3,500.00 ( 3,500.00) .00 100-46315-000-000 FEES: MACHINERY & EQUIPMENT .00 .00 15,000.00 ( 15,000.00) .00 100-46330-000-000 FEES: PARKING PERMITS .00 .00 5,000.00 ( 5,000.00) .00 100-46440-000-000 FEES: WEED CONTROL .00 .00 500.00 ( 500.00) .00 100-46540-100-000 FEES: CEMETERY BURIALS .00 .00 15,000.00 ( 15,000.00) .00 100-46715-000-000 FEES: PARK BEER PERMITS .00 .00 500.00 ( 500.00) .00 100-46720-000-000 FEES: PARK SHELTER HOUSES .00 .00 8,000.00 ( 8,000.00) .00 100-46725-000-000 FEES: CONCESSIONS SWAN PARK .00 .00 30,000.00 ( 30,000.00) .00 100-46745-000-000 FEES: CONCESSIONS REC CENTER .00 .00 3,000.00 ( 3,000.00) .00 100-46750-100-000 FEES: SENIOR MEMBERSHIP .00 .00 10,000.00 ( 10,000.00) .00 100-46750-110-000 FEES: SENIOR TRAVEL .00 .00 5,000.00 ( 5,000.00) .00 100-46750-120-000 FEES: SENIOR PROGRAMS .00 .00 2,000.00 ( 2,000.00) .00 TOTAL PUBLIC CHARGES FOR SERVICE .00 .00 121,100.00 ( 121,100.00) .00 INTERGOVT CHARGES FOR SERVICE 100-47220-000-000 INTERGOVT CHRG:SCHOOL LIAISON .00 .00 123,876.01 ( 123,876.01) .00 100-47225-000-000 INTERGOVT CHRG:CROSSING GUARDS .00 .00 6,962.50 ( 6,962.50) .00 100-47230-000-000 INTERGOVT CHRG: FIRE DEPT .00 .00 5,000.00 ( 5,000.00) .00 100-47255-000-000 INTERGOVT CHRG: FARM MARKET .00 .00 2,000.00 ( 2,000.00) .00 TOTAL INTERGOVT CHARGES FOR SERVIC .00 .00 137,838.51 ( 137,838.51) .00 CITY OF WAUPACA REVENUES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 100 - GENERAL FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 10:41AM PAGE: 3 MISCELANEOUS REVENUE 100-48110-000-000 INTEREST: INTEREST GENERAL .00 .00 25,000.00 ( 25,000.00) .00 100-48150-000-000 REBATES .00 .00 25,000.00 ( 25,000.00) .00 100-48211-000-000 RENT: CITY PROPERTY .00 .00 6,200.00 ( 6,200.00) .00 100-48214-000-000 RENT: CITY PROPERTY: FIRE .00 .00 14,105.00 ( 14,105.00) .00 100-48220-000-000 RENT: 219 W FULTON .00 .00 21,000.00 ( 21,000.00) .00 100-48250-000-000 RENT: REC CENTER .00 .00 10,000.00 ( 10,000.00) .00 100-48260-000-000 RENT: UTILITY PAYMENTS .00 .00 33,000.00 ( 33,000.00) .00 100-48405-000-000 INSURANCE DIVIDENDS .00 .00 13,000.00 ( 13,000.00) .00 TOTAL MISCELANEOUS REVENUE .00 .00 147,305.00 ( 147,305.00) .00 OTHER FINANCING SOURCES 100-49920-100-000 TRANSFER IN: HOTEL/MOTEL .00 .00 75,500.00 ( 75,500.00) .00 100-49964-000-000 TRANSFER IN(OUT) TIF DISTRICTS .00 .00 157,163.00 ( 157,163.00) .00 100-49965-000-000 TRANSFER IN(OUT) WATER UTILITY .00 .00 216,500.00 ( 216,500.00) .00 100-49966-000-000 TRANSFER IN(OUT) SEWER UTILITY .00 .00 215,000.00 ( 215,000.00) .00 100-49967-000-000 TRANSFER IN(OUT) WAUP ONLINE .00 .00 15,000.00 ( 15,000.00) .00 TOTAL OTHER FINANCING SOURCES .00 .00 679,163.00 ( 679,163.00) .00 TOTAL FUND REVENUE .00 .00 7,310,280.20 ( 7,310,280.20) .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 100 - GENERAL FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 10:41AM PAGE: 4 COUNCIL 100-51111-104-000 COUNCIL: PT WAGES .00 .00 48,500.00 48,500.00 .00 100-51111-118-000 COUNCIL: SOCIAL SECURITY .00 .00 3,710.00 3,710.00 .00 100-51111-202-000 COUNCIL: TRAINING .00 .00 1,000.00 1,000.00 .00 100-51111-215-000 COUNCIL: ADVERTISING .00 .00 8,000.00 8,000.00 .00 100-51111-217-000 COUNCIL: MEMBERSHIP & DUES .00 .00 2,420.00 2,420.00 .00 100-51111-219-000 COUNCIL: EXPENSES .00 .00 1,500.00 1,500.00 .00 TOTAL COUNCIL .00 .00 65,130.00 65,130.00 .00 ADMINISTRATION 100-51211-102-000 ADMIN: WAGES .00 .00 98,079.00 98,079.00 .00 100-51211-118-000 ADMIN: SOCIAL SECURITY .00 .00 7,503.00 7,503.00 .00 100-51211-119-000 ADMIN: RETIREMENT (R) .00 .00 6,669.00 6,669.00 .00 100-51211-121-000 ADMIN: GRP HLTH INS .00 .00 18,661.00 18,661.00 .00 100-51211-122-000 ADMIN: LIFE INS .00 .00 154.00 154.00 .00 100-51211-123-000 ADMIN: INC PROTECT .00 .00 588.00 588.00 .00 100-51211-202-000 ADMIN: TRAINING .00 .00 2,000.00 2,000.00 .00 100-51211-210-000 ADMIN: PROF SERVICES .00 .00 3,000.00 3,000.00 .00 100-51211-211-000 ADMIN: CONTRACT SERVICES .00 .00 17,500.00 17,500.00 .00 100-51211-217-000 ADMIN: MEMBERSHIP & DUES .00 .00 1,500.00 1,500.00 .00 100-51211-268-000 ADMIN: CAR/CELL PHONE EXP .00 .00 3,300.00 3,300.00 .00 100-51211-301-000 ADMIN: SUPPLIES .00 .00 500.00 500.00 .00 TOTAL ADMINISTRATION .00 .00 159,454.00 159,454.00 .00 MAYOR 100-51311-104-000 MAYOR: PT WAGES .00 .00 12,250.00 12,250.00 .00 100-51311-118-000 MAYOR: SOCIAL SECURITY .00 .00 937.00 937.00 .00 100-51311-219-000 MAYOR: EXPENSES .00 .00 400.00 400.00 .00 TOTAL MAYOR .00 .00 13,587.00 13,587.00 .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 100 - GENERAL FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 10:41AM PAGE: 5 CITY CLERK 100-51411-102-000 CLERK: WAGES .00 .00 113,789.00 113,789.00 .00 100-51411-103-000 CLERK: OVERTIME .00 .00 500.00 500.00 .00 100-51411-118-000 CLERK: SOCIAL SECURITY .00 .00 8,743.00 8,743.00 .00 100-51411-119-000 CLERK: RETIREMENT (R) .00 .00 7,772.00 7,772.00 .00 100-51411-121-000 CLERK: GRP HLTH INS .00 .00 10,080.00 10,080.00 .00 100-51411-122-000 CLERK: LIFE INS .00 .00 1,055.00 1,055.00 .00 100-51411-123-000 CLERK: INC PROTECT .00 .00 375.00 375.00 .00 100-51411-202-000 CLERK: TRAINING .00 .00 2,500.00 2,500.00 .00 100-51411-210-000 CLERK: PROF SERVICES .00 .00 2,500.00 2,500.00 .00 100-51411-217-000 CLERK: MEMBERSHIP & DUES .00 .00 420.00 420.00 .00 100-51411-219-000 CLERK: EXPENSES .00 .00 3,500.00 3,500.00 .00 100-51411-268-000 CLERK: CAR/CELL PHONE EXP .00 .00 1,200.00 1,200.00 .00 100-51411-301-000 CLERK: SUPPLIES .00 .00 810.00 810.00 .00 TOTAL CITY CLERK .00 .00 153,244.00 153,244.00 .00 CITY CLERK - ELECTIONS 100-51412-102-000 ELECTIONS: WAGES .00 .00 7,500.00 7,500.00 .00 100-51412-103-000 ELECTIONS: OVERTIME .00 .00 1,500.00 1,500.00 .00 100-51412-104-000 ELECTIONS: PT WAGES .00 .00 9,000.00 9,000.00 .00 100-51412-118-000 ELECTIONS: SOCIAL SECURITY .00 .00 689.00 689.00 .00 100-51412-119-000 ELECTIONS: RETIREMENT (R) .00 .00 608.00 608.00 .00 100-51412-121-000 ELECTIONS: GRP HLTH INS .00 .00 1,577.00 1,577.00 .00 100-51412-122-000 ELECTIONS: LIFE INS .00 .00 75.00 75.00 .00 100-51412-123-000 ELECTIONS: INC PROTECT .00 .00 75.00 75.00 .00 100-51412-202-000 ELECTIONS: TRAINING .00 .00 100.00 100.00 .00 100-51412-207-000 ELECTIONS: MAINT OF EQUIP .00 .00 2,300.00 2,300.00 .00 100-51412-215-000 ELECTIONS: ADVERTISING .00 .00 500.00 500.00 .00 100-51412-216-000 ELECTIONS: POSTAGE .00 .00 3,000.00 3,000.00 .00 100-51412-301-000 ELECTIONS: SUPPLIES .00 .00 5,500.00 5,500.00 .00 TOTAL CITY CLERK - ELECTIONS .00 .00 32,424.00 32,424.00 .00 CITY CLERK - WEIGHTS & MEASURE 100-51420-238-000 CLERK - WEIGHTS & MEASURES .00 .00 9,662.00 9,662.00 .00 TOTAL CITY CLERK - WEIGHTS & MEASURE .00 .00 9,662.00 9,662.00 .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 100 - GENERAL FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 10:42AM PAGE: 6 COMMUNITY DEVELOPMENT 100-51521-102-000 COMM DEV: WAGES .00 .00 190,149.00 190,149.00 .00 100-51521-104-000 COMM DEV : PT WAGES .00 .00 27,000.00 27,000.00 .00 100-51521-118-000 COMM DEV : SOCIAL SECURITY .00 .00 16,612.00 16,612.00 .00 100-51521-119-000 COMM DEV : RETIREMENT (R) .00 .00 12,930.00 12,930.00 .00 100-51521-121-000 COMM DEV : GRP HLTH INS .00 .00 26,629.00 26,629.00 .00 100-51521-122-000 COMM DEV : LIFE INS .00 .00 771.00 771.00 .00 100-51521-123-000 COMM DEV : INC PROTECT .00 .00 400.00 400.00 .00 100-51521-202-000 COMM DEV: TRAINING .00 .00 10,000.00 10,000.00 .00 100-51521-206-000 COMM DEV: TELEPHONE .00 .00 480.00 480.00 .00 100-51521-207-000 COMM DEV : MAINT OF EQUIP .00 .00 750.00 750.00 .00 100-51521-210-000 COMM DEV: PROF SERVICES .00 .00 14,000.00 14,000.00 .00 100-51521-211-000 COMM DEV: CONTRACT SERVICES .00 .00 25,000.00 25,000.00 .00 100-51521-217-000 COMM DEV: MEMBERSHIP & DUES .00 .00 10,500.00 10,500.00 .00 100-51521-239-000 COMM DEV-MANUFACTURING FEE .00 .00 3,417.00 3,417.00 .00 100-51521-268-000 COMM DEV: CAR/CELL PHONE .00 .00 6,600.00 6,600.00 .00 100-51521-272-000 COMM DEV: MAINT OF VEHICLES .00 .00 400.00 400.00 .00 100-51521-286-000 COMM DEV: SOFTWARE .00 .00 15,000.00 15,000.00 .00 100-51521-301-000 COMM DEV: SUPPLIES .00 .00 3,000.00 3,000.00 .00 100-51521-312-000 COMM DEV: GASOLINE .00 .00 2,000.00 2,000.00 .00 TOTAL COMMUNITY DEVELOPMENT .00 .00 365,638.00 365,638.00 .00 FINANCE 100-51551-102-000 FINANCE: WAGES .00 .00 88,580.00 88,580.00 .00 100-51551-118-000 FINANCE: SOCIAL SECURITY .00 .00 6,776.00 6,776.00 .00 100-51551-119-000 FINANCE: RETIREMENT (R) .00 .00 6,023.00 6,023.00 .00 100-51551-121-000 FINANCE: GRP HLTH INS .00 .00 15,000.00 15,000.00 .00 100-51551-122-000 FINANCE: LIFE INS .00 .00 600.00 600.00 .00 100-51551-123-000 FINANCE: INC PROTECT .00 .00 768.00 768.00 .00 100-51551-202-000 FINANCE: TRAINING .00 .00 10,000.00 10,000.00 .00 100-51551-210-000 FINANCE: PROF SERVICES .00 .00 20,000.00 20,000.00 .00 100-51551-211-000 FINANCE: CONTRACT SERVICES .00 .00 15,000.00 15,000.00 .00 100-51551-217-000 FINANCE: MEMBERSHIP & DUES .00 .00 1,005.00 1,005.00 .00 100-51551-219-000 FINANCE: EXPENSES .00 .00 3,600.00 3,600.00 .00 100-51551-301-000 FINANCE: SUPPLIES .00 .00 1,500.00 1,500.00 .00 TOTAL FINANCE .00 .00 168,852.00 168,852.00 .00 LEGAL - CITY ATTORNEY 100-51611-210-000 CITY ATTORNEY: PROF SERVICES .00 .00 20,000.00 20,000.00 .00 TOTAL LEGAL - CITY ATTORNEY .00 .00 20,000.00 20,000.00 .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 100 - GENERAL FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 10:42AM PAGE: 7 LEGAL - PROSECUTION 100-51612-210-000 PROSECUTION: PROF SERVICES .00 .00 13,000.00 13,000.00 .00 TOTAL LEGAL - PROSECUTION .00 .00 13,000.00 13,000.00 .00 LEGAL - LABOR/PERSONNEL 100-51613-210-000 LABOR REL: PROF SERVICES .00 .00 4,000.00 4,000.00 .00 TOTAL LEGAL - LABOR/PERSONNEL .00 .00 4,000.00 4,000.00 .00 BLDGS - CITY HALL/LIBRARY 100-51711-102-000 CH/LIB: WAGES .00 .00 30,111.00 30,111.00 .00 100-51711-104-000 CH/LIB: PT WAGES .00 .00 13,452.00 13,452.00 .00 100-51711-112-000 CH/LIB: UNIFORMS .00 .00 150.00 150.00 .00 100-51711-118-000 CH/LIB: SOCIAL SECURITY .00 .00 3,333.00 3,333.00 .00 100-51711-119-000 CH/LIB: RETIREMENT (R) .00 .00 2,048.00 2,048.00 .00 100-51711-121-000 CH/LIB: GRP HLTH INS .00 .00 3,329.00 3,329.00 .00 100-51711-122-000 CH/LIB: LIFE INS .00 .00 173.00 173.00 .00 100-51711-123-000 CH/LIB: INC PROTECT .00 .00 177.00 177.00 .00 100-51711-202-000 CH/LIB: TRAINING .00 .00 1,000.00 1,000.00 .00 100-51711-203-000 CH/LIB: HEAT .00 .00 9,000.00 9,000.00 .00 100-51711-204-000 CH/LIB: ELECTRICITY .00 .00 30,000.00 30,000.00 .00 100-51711-205-000 CH/LIB: WATER SEWER .00 .00 5,000.00 5,000.00 .00 100-51711-206-000 CH/LIB: TELEPHONE .00 .00 4,950.00 4,950.00 .00 100-51711-207-000 CH/LIB: MAINT OF EQUIP .00 .00 3,000.00 3,000.00 .00 100-51711-208-000 CH/LIB: MAINT OF FACILITIES .00 .00 13,835.00 13,835.00 .00 100-51711-211-000 CH/LIB: CONTRACT SERVICES .00 .00 1,000.00 1,000.00 .00 100-51711-217-000 CITY HALL: MEMBERSHIP & DUES .00 .00 500.00 500.00 .00 100-51711-243-000 CH/LIB: SECURITY .00 .00 1,500.00 1,500.00 .00 100-51711-244-000 CH/LIB: ELEVATOR .00 .00 4,500.00 4,500.00 .00 100-51711-245-000 CH/LIB: FIRE ALARM .00 .00 400.00 400.00 .00 100-51711-246-000 CH/LIB: AUTOMATIC DOORS .00 .00 1,000.00 1,000.00 .00 100-51711-247-000 CH/LIB: SPRINKLER SYSTEM .00 .00 500.00 500.00 .00 100-51711-248-000 CH/LIB: AIR SYSTEM HVAC .00 .00 1,000.00 1,000.00 .00 100-51711-272-000 CH/LIB: MAINT OF VEHICLES .00 .00 500.00 500.00 .00 100-51711-301-000 CH/LIB: SUPPLIES .00 .00 7,000.00 7,000.00 .00 100-51711-312-000 CH/LIB: GASOLINE .00 .00 1,500.00 1,500.00 .00 TOTAL BLDGS - CITY HALL/LIBRARY .00 .00 138,958.00 138,958.00 .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 100 - GENERAL FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 10:42AM PAGE: 8 BLDGS - POLICE STATION 100-51714-102-000 POLICE STATION: WAGES .00 .00 18,067.00 18,067.00 .00 100-51714-104-000 POLICE STATION: PT WAGES .00 .00 8,367.00 8,367.00 .00 100-51714-116-000 POLICE STATION: PT RETIRE .00 .00 145.00 145.00 .00 100-51714-118-000 POLICE STATION: SOCIAL SECURIT .00 .00 1,979.00 1,979.00 .00 100-51714-119-000 POLICE STATION: RETIREMENT (R) .00 .00 1,229.00 1,229.00 .00 100-51714-121-000 POLICE STATION: GRP HLTH INS .00 .00 1,997.00 1,997.00 .00 100-51714-122-000 POLICE STATION: LIFE INS .00 .00 179.00 179.00 .00 100-51714-123-000 POLICE STATION: INC PROTECT .00 .00 72.00 72.00 .00 100-51714-204-000 POLICE STATION: ELECTRICITY .00 .00 27,000.00 27,000.00 .00 100-51714-205-000 POLICE STATION: WATER SEWER .00 .00 2,900.00 2,900.00 .00 100-51714-206-000 POLICE ST: TELEPHONE .00 .00 1,500.00 1,500.00 .00 100-51714-208-000 POLICE STATION: MAINT OF FACIL .00 .00 15,000.00 15,000.00 .00 100-51714-248-000 POLICE ST: AIR SYSTEM HVAC .00 .00 6,000.00 6,000.00 .00 100-51714-301-000 POLICE STATION: SUPPLIES .00 .00 1,000.00 1,000.00 .00 TOTAL BLDGS - POLICE STATION .00 .00 85,435.00 85,435.00 .00 OTHER GEN GOVT - POSTAGE/SUPLY 100-51910-216-000 OTHER GEN GOVT: POSTAGE .00 .00 8,000.00 8,000.00 .00 100-51910-218-000 OTHER GEN GOVT: DELQ PP TAX .00 .00 2,000.00 2,000.00 .00 100-51910-301-000 OTHER GEN GOVT: SUPPLIES .00 .00 2,000.00 2,000.00 .00 TOTAL OTHER GEN GOVT - POSTAGE/SUPL .00 .00 12,000.00 12,000.00 .00 OTHER GEN GOVT - HUMAN RES 100-51915-125-000 OTHER GEN GOVT: HEALTH REIMB .00 .00 7,500.00 7,500.00 .00 100-51915-215-000 OTHER GEN GOVT: EMPLOYEE RET .00 .00 36,843.00 36,843.00 .00 100-51915-220-000 OTHER GEN GOVT: WELLNESS PROG .00 .00 20,000.00 20,000.00 .00 TOTAL OTHER GEN GOVT - HUMAN RES .00 .00 64,343.00 64,343.00 .00 OTHER GEN GOVT - REPRODUCTION 100-51920-212-000 OTHER GEN GOVT: RENT & LEASES .00 .00 10,500.00 10,500.00 .00 TOTAL OTHER GEN GOVT - REPRODUCTIO .00 .00 10,500.00 10,500.00 .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 100 - GENERAL FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 10:42AM PAGE: 9 OTHER GEN GOVT - INSURANCE 100-51930-209-110 OTHER GEN GOVT: LIAB/AUTO INS .00 .00 28,000.00 28,000.00 .00 100-51930-209-120 OTHER GEN GOVT: PROPERTY INS .00 .00 24,750.00 24,750.00 .00 100-51930-209-130 OTHER GEN GOVT: WORK COMP INS .00 .00 52,000.00 52,000.00 .00 TOTAL OTHER GEN GOVT - INSURANCE .00 .00 104,750.00 104,750.00 .00 POLICE DEPT - ADMIN 100-52111-102-000 POLICE ADMIN : WAGES .00 .00 174,541.00 174,541.00 .00 100-52111-112-000 POLICE ADMIN : UNIFORMS .00 .00 1,000.00 1,000.00 .00 100-52111-118-000 POLICE ADMIN : SOCIAL SECURITY .00 .00 14,443.00 14,443.00 .00 100-52111-120-000 POLICE ADMIN : RETIREMENT (P) .00 .00 37,799.00 37,799.00 .00 100-52111-121-000 POLICE ADMIN : GRP HLTH INS .00 .00 10,000.00 10,000.00 .00 100-52111-122-000 POLICE ADMIN : LIFE INS .00 .00 1,051.00 1,051.00 .00 100-52111-123-000 POLICE ADMIN : INC PROTECT .00 .00 850.00 850.00 .00 100-52111-206-000 POLICE ADMIN : TELEPHONE .00 .00 10,480.00 10,480.00 .00 100-52111-210-000 POLICE ADMIN : PROF SERVICES .00 .00 1,500.00 1,500.00 .00 100-52111-211-000 POLICE ADMI: CONTRACT SERVICES .00 .00 19,100.00 19,100.00 .00 100-52111-217-000 POLICE ADMI: MEMBERSHIP & DUES .00 .00 2,100.00 2,100.00 .00 100-52111-301-000 POLICE ADMIN : SUPPLIES .00 .00 1,000.00 1,000.00 .00 TOTAL POLICE DEPT - ADMIN .00 .00 273,864.00 273,864.00 .00 POLICE DEPT - PATROL 100-52112-102-000 POL PATROL: WAGES .00 .00 871,611.00 871,611.00 .00 100-52112-103-000 POL PATROL: OVERTIME .00 .00 50,000.00 50,000.00 .00 100-52112-105-000 POL PATROL: CALL-IN PAY .00 .00 5,000.00 5,000.00 .00 100-52112-111-000 POL PATROL: MEALS .00 .00 1,100.00 1,100.00 .00 100-52112-112-000 POL PATROL: UNIFORMS .00 .00 9,000.00 9,000.00 .00 100-52112-118-000 POL PATROL: SOCIAL SECURITY .00 .00 74,328.00 74,328.00 .00 100-52112-120-000 POL PATROL: RETIREMENT (P) .00 .00 148,253.00 148,253.00 .00 100-52112-121-000 POL PATROL: GRP HLTH INS .00 .00 132,529.00 132,529.00 .00 100-52112-122-000 POL PATROL: LIFE INS .00 .00 1,749.00 1,749.00 .00 100-52112-123-000 POL PATROL: INC PROTECT .00 .00 3,120.00 3,120.00 .00 100-52112-128-000 PATROL: POST EMPLOY. HEALTH PL .00 .00 2,520.00 2,520.00 .00 100-52112-202-000 POL PATROL: TRAINING .00 .00 9,725.00 9,725.00 .00 100-52112-219-000 POL PATROL: EXPENSES .00 .00 750.00 750.00 .00 100-52112-225-000 POL PATROL: INVESTIGATIONS .00 .00 2,000.00 2,000.00 .00 100-52112-231-000 POL PATROL: EQUIP .00 .00 28,500.00 28,500.00 .00 100-52112-272-000 POL PATROL: MAINT OF VEHICLES .00 .00 14,800.00 14,800.00 .00 100-52112-301-000 POL PATROL: SUPPLIES .00 .00 3,000.00 3,000.00 .00 100-52112-312-000 POL PATROL: GASOLINE .00 .00 40,000.00 40,000.00 .00 TOTAL POLICE DEPT - PATROL .00 .00 1,397,985.00 1,397,985.00 .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 100 - GENERAL FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 10:42AM PAGE: 10 POLICE DEPT - CLERICAL 100-52113-102-000 POL CLERICAL: WAGES .00 .00 53,440.00 53,440.00 .00 100-52113-103-000 POL CLERICAL: OVERTIME .00 .00 500.00 500.00 .00 100-52113-118-000 POL CLERICAL: SOCIAL SECURITY .00 .00 5,145.00 5,145.00 .00 100-52113-119-000 POL CLERICAL: RETIREMENT (R) .00 .00 4,573.00 4,573.00 .00 100-52113-121-000 POL CLERICAL: GRP HLTH INS .00 .00 13,315.00 13,315.00 .00 100-52113-122-000 POL CLERICAL: LIFE INS .00 .00 525.00 525.00 .00 100-52113-123-000 POL CLERICAL: INC PROTECT .00 .00 240.00 240.00 .00 100-52113-202-000 POL CLERICAL: TRAINING .00 .00 450.00 450.00 .00 100-52113-301-000 POL CLERICAL: SUPPLIES .00 .00 6,700.00 6,700.00 .00 TOTAL POLICE DEPT - CLERICAL .00 .00 84,888.00 84,888.00 .00 POLICE DEPT - MEG GRANTS 100-52115-103-000 MEG DUTIES: OVERTIME .00 .00 5,000.00 5,000.00 .00 TOTAL POLICE DEPT - MEG GRANTS .00 .00 5,000.00 5,000.00 .00 POLICE DEPT - SCHOOL LIAISON 100-52117-102-000 PTRL SCHL LIAIS: WAGES .00 .00 94,825.00 94,825.00 .00 100-52117-118-000 PTRL SCHL LIAIS: SOCIAL SECURI .00 .00 7,254.00 7,254.00 .00 100-52117-120-000 PTRL SCHL LIAIS: RETIREMENT (P .00 .00 12,517.00 12,517.00 .00 100-52117-121-000 PTRL SCHL LIAIS: GRP HLTH INS .00 .00 8,743.00 8,743.00 .00 100-52117-122-000 PTRL SCHL LIAIS: LIFE INS .00 .00 177.00 177.00 .00 100-52117-128-000 PTRL SHCL LIAIS: POST EMPLOY H .00 .00 360.00 360.00 .00 TOTAL POLICE DEPT - SCHOOL LIAISON .00 .00 123,876.00 123,876.00 .00 POLICE DEPT - SCHOOL X-GUARDS 100-52161-104-000 SCHOOL PATROL: PT WAGES .00 .00 12,774.00 12,774.00 .00 100-52161-112-000 SCHOOL PATROL: UNIFORMS .00 .00 190.00 190.00 .00 100-52161-118-000 SCHOOL PATROL: SOCIAL SECURITY .00 .00 977.00 977.00 .00 TOTAL POLICE DEPT - SCHOOL X-GUARDS .00 .00 13,941.00 13,941.00 .00 AMBULANCE 100-52310-211-000 AMBULANCE: CONTRACT SERVICES .00 .00 82,458.00 82,458.00 .00 TOTAL AMBULANCE .00 .00 82,458.00 82,458.00 .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 100 - GENERAL FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 10:42AM PAGE: 11 FIRE DISTRICT 100-52311-204-000 FIRE STATION: ELECTRICITY .00 .00 4,100.00 4,100.00 .00 100-52311-208-000 FIRE DEPT: MAINT OF FACIL .00 .00 2,200.00 2,200.00 .00 100-52311-211-000 FIRE DEPT: CONTRACT SERVICES .00 .00 116,683.00 116,683.00 .00 100-52311-224-000 FIRE DEPT: FIRE DEPT 2% DUES .00 .00 19,362.00 19,362.00 .00 TOTAL FIRE DISTRICT .00 .00 142,345.00 142,345.00 .00 EMERGENCY OPERATIONS 100-52611-204-000 EMGY OPS: ELECTRICITY .00 .00 1,500.00 1,500.00 .00 100-52611-206-000 EMGY OPS: TELEPHONE .00 .00 500.00 500.00 .00 100-52611-301-000 EMGY OPS: SUPPLIES .00 .00 2,000.00 2,000.00 .00 TOTAL EMERGENCY OPERATIONS .00 .00 4,000.00 4,000.00 .00 HUMANE SOCIETY 100-53431-211-000 ANIMAL POUND: CONTRACT SERVICE .00 .00 5,000.00 5,000.00 .00 TOTAL HUMANE SOCIETY .00 .00 5,000.00 5,000.00 .00 PUBLIC WORKS-MACHINERY & EQUIP 100-54111-102-000 MACH & EQUIP: WAGES .00 .00 56,877.00 56,877.00 .00 100-54111-112-000 MACH & EQUIP: UNIFORMS .00 .00 300.00 300.00 .00 100-54111-118-000 MACH & EQUIP: SOCIAL SECURITY .00 .00 4,734.00 4,734.00 .00 100-54111-119-000 MACH & EQUIP: RETIREMENT (R) .00 .00 4,208.00 4,208.00 .00 100-54111-121-000 MACH & EQUIP: GRP HLTH INS .00 .00 5,000.00 5,000.00 .00 100-54111-122-000 MACH & EQUIP: LIFE INS .00 .00 129.00 129.00 .00 100-54111-123-000 MACH & EQUIP: INC PROTECT .00 .00 240.00 240.00 .00 100-54111-202-000 MACH & EQUIP: TRAINING .00 .00 250.00 250.00 .00 100-54111-268-000 MACH & EQUIP: CAR/CELL PHONE .00 .00 720.00 720.00 .00 100-54111-270-000 MACH & EQUIP: MAINT OF EQUIP .00 .00 35,000.00 35,000.00 .00 100-54111-298-000 MACH & EQUIP: TOOLS .00 .00 400.00 400.00 .00 100-54111-301-000 MACH & EQUIP: SUPPLIES .00 .00 3,000.00 3,000.00 .00 100-54111-312-000 MACH & EQUIP: GASOLINE .00 .00 12,000.00 12,000.00 .00 100-54111-313-000 MACH & EQUIP: DIESEL FUEL .00 .00 9,000.00 9,000.00 .00 100-54111-314-000 MACH & EQUIP: OIL .00 .00 4,000.00 4,000.00 .00 TOTAL PUBLIC WORKS-MACHINERY & EQUI .00 .00 135,858.00 135,858.00 .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 100 - GENERAL FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 10:42AM PAGE: 12 PUBLIC WORKS-GARAGE 100-54121-102-000 GARAGE: WAGES .00 .00 10,082.00 10,082.00 .00 100-54121-118-000 GARAGE: SOCIAL SECURITY .00 .00 771.00 771.00 .00 100-54121-119-000 GARAGE: RETIREMENT (R) .00 .00 686.00 686.00 .00 100-54121-121-000 GARAGE: GRP HLTH INS .00 .00 1,649.00 1,649.00 .00 100-54121-122-000 GARAGE: LIFE INS .00 .00 60.00 60.00 .00 100-54121-123-000 GARAGE: INC PROTECT .00 .00 46.00 46.00 .00 100-54121-203-000 GARAGE: HEAT .00 .00 8,500.00 8,500.00 .00 100-54121-204-000 GARAGE: ELECTRICITY .00 .00 2,500.00 2,500.00 .00 100-54121-205-000 GARAGE: WATER SEWER .00 .00 3,500.00 3,500.00 .00 100-54121-206-000 GARAGE: TELEPHONE .00 .00 500.00 500.00 .00 100-54121-208-000 GARAGE: MAINT OF FACILITIES .00 .00 6,000.00 6,000.00 .00 100-54121-210-000 GARAGE: PROF SERVICES .00 .00 1,000.00 1,000.00 .00 100-54121-301-000 GARAGE: SUPPLIES .00 .00 750.00 750.00 .00 TOTAL PUBLIC WORKS-GARAGE .00 .00 36,044.00 36,044.00 .00 PUBLIC WORKS-ADMINISTRATION 100-54211-102-000 ENG & ADMIN: WAGES .00 .00 166,386.00 166,386.00 .00 100-54211-118-000 ENG & ADMIN: SOCIAL SECURITY .00 .00 13,494.00 13,494.00 .00 100-54211-119-000 ENG & ADMIN: RETIREMENT (R) .00 .00 11,994.00 11,994.00 .00 100-54211-121-000 ENG & ADMIN: GRP HLTH INS .00 .00 10,000.00 10,000.00 .00 100-54211-122-000 ENG & ADMIN: LIFE INS .00 .00 634.00 634.00 .00 100-54211-123-000 ENG & ADMIN: INC PROTECT .00 .00 480.00 480.00 .00 100-54211-202-000 ENG & ADMIN: TRAINING .00 .00 2,000.00 2,000.00 .00 100-54211-206-000 ENG & ADMIN: TELEPHONE .00 .00 1,400.00 1,400.00 .00 100-54211-207-000 ENG & ADMIN: MAINT OF EQUIP .00 .00 100.00 100.00 .00 100-54211-210-000 ENG & ADMIN: PROF SERVICES .00 .00 850.00 850.00 .00 100-54211-217-000 ENG & ADMIN: MEMBERSHIP & DUES .00 .00 700.00 700.00 .00 100-54211-268-000 ENG & ADMIN: CAR/CELL PHONE .00 .00 2,850.00 2,850.00 .00 100-54211-301-000 ENG & ADMIN: SUPPLIES .00 .00 750.00 750.00 .00 TOTAL PUBLIC WORKS-ADMINISTRATION .00 .00 211,638.00 211,638.00 .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 100 - GENERAL FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 10:42AM PAGE: 13 PUBLIC WORKS-STREET MAINT 100-54311-102-000 STREETS: WAGES .00 .00 190,692.00 190,692.00 .00 100-54311-103-000 STREETS: OVERTIME .00 .00 1,000.00 1,000.00 .00 100-54311-104-000 STREETS: PT WAGES .00 .00 2,000.00 2,000.00 .00 100-54311-112-000 STREETS: UNIFORMS .00 .00 2,000.00 2,000.00 .00 100-54311-118-000 STREETS: SOCIAL SECURITY .00 .00 14,970.00 14,970.00 .00 100-54311-119-000 STREETS: RETIREMENT (R) .00 .00 13,556.00 13,556.00 .00 100-54311-121-000 STREETS: GRP HLTH INS .00 .00 38,462.00 38,462.00 .00 100-54311-122-000 STREETS: LIFE INS .00 .00 577.00 577.00 .00 100-54311-123-000 STREETS: INC PROTECT .00 .00 874.00 874.00 .00 100-54311-202-000 STREETS: TRAINING .00 .00 2,000.00 2,000.00 .00 100-54311-210-000 STREETS: PROF SERVICES .00 .00 2,000.00 2,000.00 .00 100-54311-301-000 STREETS: SUPPLIES .00 .00 3,000.00 3,000.00 .00 100-54311-303-000 STREETS: MATERIALS .00 .00 37,000.00 37,000.00 .00 100-54311-305-000 STREETS: CROSSING MAINT .00 .00 20,000.00 20,000.00 .00 TOTAL PUBLIC WORKS-STREET MAINT .00 .00 328,131.00 328,131.00 .00 PUBLIC WORKS-STREET CLEANING 100-54341-102-000 STR CLEAN: WAGES .00 .00 14,556.00 14,556.00 .00 100-54341-111-000 STR CLEAN: MEALS .00 .00 150.00 150.00 .00 100-54341-118-000 STR CLEAN: SOCIAL SECURITY .00 .00 1,496.00 1,496.00 .00 100-54341-119-000 STR CLEAN: RETIREMENT (R) .00 .00 1,035.00 1,035.00 .00 100-54341-121-000 STR CLEAN: GRP HLTH INS .00 .00 2,936.00 2,936.00 .00 100-54341-122-000 STR CLEAN: LIFE INS .00 .00 44.00 44.00 .00 100-54341-123-000 STR CLEAN: INC PROTECT .00 .00 67.00 67.00 .00 100-54341-205-000 STR CLEAN: WATER SEWER .00 .00 1,000.00 1,000.00 .00 100-54341-272-000 STR CLEAN: MAINT OF VEHICLES .00 .00 7,000.00 7,000.00 .00 100-54341-313-000 STR CLEAN: DIESEL FUEL .00 .00 6,000.00 6,000.00 .00 TOTAL PUBLIC WORKS-STREET CLEANING .00 .00 34,284.00 34,284.00 .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 100 - GENERAL FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 10:42AM PAGE: 14 PUBLIC WORKS-SNOW & ICE CONTRL 100-54351-102-000 SNOW & ICE: WAGES .00 .00 58,846.00 58,846.00 .00 100-54351-103-000 SNOW & ICE: OVERTIME .00 .00 4,800.00 4,800.00 .00 100-54351-105-000 SNOW & ICE: CALL-IN PAY .00 .00 1,600.00 1,600.00 .00 100-54351-111-000 SNOW & ICE: MEALS .00 .00 2,000.00 2,000.00 .00 100-54351-118-000 SNOW & ICE: SOCIAL SECURITY .00 .00 5,196.00 5,196.00 .00 100-54351-119-000 SNOW & ICE: RETIREMENT (R) .00 .00 4,618.00 4,618.00 .00 100-54351-121-000 SNOW & ICE: GRP HLTH INS .00 .00 13,882.00 13,882.00 .00 100-54351-122-000 SNOW & ICE: LIFE INS .00 .00 178.00 178.00 .00 100-54351-123-000 SNOW & ICE: INC PROTECT .00 .00 343.00 343.00 .00 100-54351-211-000 SNOW & ICE: CONTRACT SERVICES .00 .00 11,000.00 11,000.00 .00 100-54351-272-000 SNOW & ICE: MAINT OF VEHICLES .00 .00 15,000.00 15,000.00 .00 100-54351-305-000 SNOW & ICE: SALT & S&-SNOW REM .00 .00 45,000.00 45,000.00 .00 100-54351-313-000 SNOW & ICE: DIESEL FUEL .00 .00 15,000.00 15,000.00 .00 TOTAL PUBLIC WORKS-SNOW & ICE CONTR .00 .00 177,463.00 177,463.00 .00 PUBLIC WORKS-TRAFFIC CONTROL 100-54411-102-000 TRAF CONT: WAGES .00 .00 22,292.00 22,292.00 .00 100-54411-118-000 TRAF CONT: SOCIAL SECURITY .00 .00 1,783.00 1,783.00 .00 100-54411-119-000 TRAF CONT: RETIREMENT (R) .00 .00 1,585.00 1,585.00 .00 100-54411-121-000 TRAF CONT: GRP HLTH INS .00 .00 4,496.00 4,496.00 .00 100-54411-122-000 TRAF CONT: LIFE INS .00 .00 67.00 67.00 .00 100-54411-123-000 TRAF CONT: INC PROTECT .00 .00 102.00 102.00 .00 100-54411-204-000 TRAF CONT: ELECTRICITY .00 .00 125,000.00 125,000.00 .00 100-54411-208-000 TRAF CONT: MAINT OF FACILITIES .00 .00 3,000.00 3,000.00 .00 100-54411-210-000 TRAF CONT: PROF SERVICES .00 .00 1,500.00 1,500.00 .00 100-54411-301-000 TRAF CONT: SUPPLIES .00 .00 20,000.00 20,000.00 .00 TOTAL PUBLIC WORKS-TRAFFIC CONTROL .00 .00 179,825.00 179,825.00 .00 PUBLIC WORKS-TREE & BRUSH CNTR 100-54431-102-000 TREE & BRUSH: WAGES .00 .00 25,005.00 25,005.00 .00 100-54431-118-000 TREE & BRUSH: SOCIAL SECURITY .00 .00 2,000.00 2,000.00 .00 100-54431-119-000 TREE & BRUSH: RETIREMENT (R) .00 .00 1,778.00 1,778.00 .00 100-54431-121-000 TREE & BRUSH: GRP HLTH INS .00 .00 5,043.00 5,043.00 .00 100-54431-122-000 TREE & BRUSH: LIFE INS .00 .00 76.00 76.00 .00 100-54431-123-000 TREE & BRUSH: INC PROTECT .00 .00 115.00 115.00 .00 100-54431-208-000 TREE & BRUSH: MAINT FACILITIES .00 .00 3,000.00 3,000.00 .00 100-54431-211-000 TREE & BRUSH: CONTRACT SERVICE .00 .00 3,500.00 3,500.00 .00 TOTAL PUBLIC WORKS-TREE & BRUSH CNT .00 .00 40,517.00 40,517.00 .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 100 - GENERAL FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 10:42AM PAGE: 15 PUBLIC WORKS-STORM SEWERS 100-54451-102-000 STRM SEWER: WAGES .00 .00 22,255.00 22,255.00 .00 100-54451-118-000 STRM SEWER: SOCIAL SECURITY .00 .00 2,085.00 2,085.00 .00 100-54451-119-000 STRM SEWER: RETIREMENT (R) .00 .00 1,582.00 1,582.00 .00 100-54451-121-000 STRM SEWER: GRP HLTH INS .00 .00 4,489.00 4,489.00 .00 100-54451-122-000 STRM SEWER: LIFE INS .00 .00 67.00 67.00 .00 100-54451-123-000 STRM SEWER: INC PROTECT .00 .00 120.00 120.00 .00 100-54451-211-000 STRM SEWER: CONTRACT SERVICES .00 .00 20,000.00 20,000.00 .00 100-54451-301-000 STRM SEWER: SUPPLIES .00 .00 5,000.00 5,000.00 .00 TOTAL PUBLIC WORKS-STORM SEWERS .00 .00 55,598.00 55,598.00 .00 PUBLIC WORKS-LEAF PICKUP 100-54461-102-000 LEAF PICKUP: WAGES .00 .00 22,145.00 22,145.00 .00 100-54461-118-000 LEAF PICKUP: SOCIAL SECURITY .00 .00 1,771.00 1,771.00 .00 100-54461-119-000 LEAF PICKUP: RETIREMENT (R) .00 .00 1,574.00 1,574.00 .00 100-54461-121-000 LEAF PICKUP: GRP HLTH INS .00 .00 4,467.00 4,467.00 .00 100-54461-122-000 LEAF PICKUP: LIFE INS .00 .00 67.00 67.00 .00 100-54461-123-000 LEAF PICKUP: INC PROTECT .00 .00 101.00 101.00 .00 100-54461-272-000 LEAF PICKUP: MAINT OF VEHICLES .00 .00 3,000.00 3,000.00 .00 100-54461-313-000 LEAF PICKUP - DIESEL .00 .00 3,000.00 3,000.00 .00 TOTAL PUBLIC WORKS-LEAF PICKUP .00 .00 36,125.00 36,125.00 .00 PUBLIC WORKS-REFUSE/RECYCLING 100-54711-102-000 REFUSE/RECYCL: WAGES .00 .00 4,986.00 4,986.00 .00 100-54711-118-000 REFUSE/RECYCL: SOCIAL SECURITY .00 .00 399.00 399.00 .00 100-54711-119-000 REFUSE/RECYCL: RETIREMENT (R) .00 .00 354.00 354.00 .00 100-54711-121-000 REFUSE/RECYCL: GRP HLTH INS .00 .00 1,006.00 1,006.00 .00 100-54711-122-000 REFUSE/RECYCL: LIFE INS .00 .00 15.00 15.00 .00 100-54711-123-000 REFUSE/RECYCL: INC PROTECT .00 .00 27.00 27.00 .00 100-54711-210-000 LANDFILL: PROF SERVICES .00 .00 3,100.00 3,100.00 .00 100-54711-211-000 RECYCLING: CONTRACT SERVICES .00 .00 11,975.00 11,975.00 .00 100-54711-301-000 REFUSE/RECYCL: SUPPLIES .00 .00 500.00 500.00 .00 TOTAL PUBLIC WORKS- REFUSE/RECYCLIN .00 .00 22,362.00 22,362.00 .00 HISTORICAL SOCIETY 100-55121-203-000 MUSEUM: HEAT .00 .00 1,000.00 1,000.00 .00 100-55121-208-000 MUSEUM: MAINT OF FACILITIES .00 .00 16,000.00 16,000.00 .00 TOTAL HISTORICAL SOCIETY .00 .00 17,000.00 17,000.00 .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 100 - GENERAL FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 10:42AM PAGE: 16 PARK & REC-SENIOR PROGRAMS 100-55131-102-000 SR CITIZENS: WAGES .00 .00 45,312.00 45,312.00 .00 100-55131-104-000 SR CITIZENS: PT WAGES .00 .00 28,026.00 28,026.00 .00 100-55131-118-000 SR CITIZENS: SOCIAL SECURITY .00 .00 5,993.00 5,993.00 .00 100-55131-119-000 SR CITIZENS: RETIREMENT (R) .00 .00 3,421.00 3,421.00 .00 100-55131-121-000 SR CITIZENS: GRP HLTH INS .00 .00 5,000.00 5,000.00 .00 100-55131-122-000 SR CITIZENS: LIFE INS .00 .00 93.00 93.00 .00 100-55131-123-000 SR CITIZENS: INC PROTECT .00 .00 240.00 240.00 .00 100-55131-202-000 SR CITIZENS: TRAINING .00 .00 1,300.00 1,300.00 .00 100-55131-216-000 SR CITIZENS: POSTAGE .00 .00 2,000.00 2,000.00 .00 100-55131-217-000 SR CITIZENS: MEMBERSHIP & DUES .00 .00 150.00 150.00 .00 100-55131-230-000 SR CITIZENS: AWARDS .00 .00 200.00 200.00 .00 100-55131-231-000 SR CITIZENS: EQUIP .00 .00 1,500.00 1,500.00 .00 100-55131-253-000 SENIOR: PROMOTIONAL MATERIA .00 .00 1,100.00 1,100.00 .00 100-55131-254-000 SENIOR: TRIPS .00 .00 8,000.00 8,000.00 .00 100-55131-301-000 SR CITIZENS: SUPPLIES .00 .00 5,500.00 5,500.00 .00 TOTAL PARK & REC-SENIOR PROGRAMS .00 .00 107,835.00 107,835.00 .00 PARK & REC-ADMINISTRATION 100-55211-102-000 REC ADMIN: WAGES .00 .00 77,671.00 77,671.00 .00 100-55211-118-000 REC ADMIN: SOCIAL SECURITY .00 .00 7,038.00 7,038.00 .00 100-55211-119-000 REC ADMIN: RETIREMENT (R) .00 .00 6,256.00 6,256.00 .00 100-55211-121-000 REC ADMIN: GRP HLTH INS .00 .00 14,330.00 14,330.00 .00 100-55211-122-000 REC ADMIN: LIFE INS .00 .00 341.00 341.00 .00 100-55211-123-000 REC ADMIN: INC PROTECT .00 .00 457.00 457.00 .00 100-55211-202-000 REC ADMIN: TRAINING .00 .00 2,000.00 2,000.00 .00 100-55211-206-000 REC ADMIN: TELEPHONE .00 .00 900.00 900.00 .00 100-55211-215-000 REC ADMIN: ADVERTISING .00 .00 1,850.00 1,850.00 .00 100-55211-217-000 REC ADMIN: MEMBERSHIP & DUES .00 .00 500.00 500.00 .00 100-55211-228-000 REC ADMIN:RECRUITE PERSONNEL .00 .00 450.00 450.00 .00 100-55211-268-000 REC ADMIN: CAR /CELL PHONE .00 .00 3,600.00 3,600.00 .00 100-55211-301-000 REC ADMIN: SUPPLIES .00 .00 1,650.00 1,650.00 .00 TOTAL PARK & REC-ADMINISTRATION .00 .00 117,043.00 117,043.00 .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 100 - GENERAL FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 10:42AM PAGE: 17 PARK & REC-RECREATION BLDG 100-55216-104-000 REC BLDG :PARTTIME .00 .00 22,500.00 22,500.00 .00 100-55216-118-000 REC BLDG : SOCIAL SECURITY .00 .00 1,721.00 1,721.00 .00 100-55216-203-000 REC BLDG: HEAT .00 .00 17,000.00 17,000.00 .00 100-55216-204-000 REC BLDG: ELECTRICITY .00 .00 20,000.00 20,000.00 .00 100-55216-205-000 REC BLDG: WATER SEWER .00 .00 7,000.00 7,000.00 .00 100-55216-206-000 REC BLDGCENTER: TELEPHONE .00 .00 1,500.00 1,500.00 .00 100-55216-207-000 REC BLDG: MAINT OF EQUIP .00 .00 4,000.00 4,000.00 .00 100-55216-208-000 REC BLDG: MAINT OF FACILITIES .00 .00 12,500.00 12,500.00 .00 100-55216-211-000 REC BLDG: CONTRACT SERVICES .00 .00 1,400.00 1,400.00 .00 100-55216-231-000 REC BLDG: EQUIP .00 .00 2,000.00 2,000.00 .00 100-55216-244-000 REC BLDG: ELEVATOR .00 .00 2,000.00 2,000.00 .00 100-55216-245-000 REC BLDG: FIRE ALARM .00 .00 750.00 750.00 .00 100-55216-247-000 REC BLDG: SPRINKLER SYSTEM .00 .00 250.00 250.00 .00 100-55216-248-000 REC BLDG: AIR SYSTEM HVAC .00 .00 7,000.00 7,000.00 .00 100-55216-253-000 REC BLDG: CONCESSIONS .00 .00 1,500.00 1,500.00 .00 100-55216-301-000 REC BLDG: SUPPLIES .00 .00 4,550.00 4,550.00 .00 TOTAL PARK & REC-RECREATION BLDG .00 .00 105,671.00 105,671.00 .00 PARK & REC-BEACHES 100-55221-104-000 BEACHES: PT WAGES .00 .00 44,250.00 44,250.00 .00 100-55221-118-000 BEACHES: SOCIAL SECURITY .00 .00 3,385.00 3,385.00 .00 100-55221-205-000 BEACHES: WATER SEWER .00 .00 1,500.00 1,500.00 .00 100-55221-206-000 BEACHES: TELEPHONE .00 .00 585.00 585.00 .00 100-55221-208-000 BEACHES: MAINT OF FACILITIES .00 .00 500.00 500.00 .00 100-55221-301-000 BEACHES: SUPPLIES .00 .00 2,225.00 2,225.00 .00 TOTAL PARK & REC-BEACHES .00 .00 52,445.00 52,445.00 .00 CIVIC PROMOTIONS 100-55341-255-000 CIVIC PROMOS: SISTER CITY .00 .00 800.00 800.00 .00 100-55341-260-000 CIVIC PROMO: CITY BAND .00 .00 5,000.00 5,000.00 .00 100-55341-262-000 CIVIC PROMOS: FIREWORKS .00 .00 2,500.00 2,500.00 .00 100-55341-301-000 CIVIC PROMOS: SUPPLIES .00 .00 3,540.00 3,540.00 .00 TOTAL CIVIC PROMOTIONS .00 .00 11,840.00 11,840.00 .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 100 - GENERAL FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 10:42AM PAGE: 18 IT/COMMUNICATIONS 100-55345-102-000 IT/COMMUNCATIONS: WAGES .00 .00 78,754.00 78,754.00 .00 100-55345-104-000 IT/COMMUNICATION: PT WAGES .00 .00 5,950.00 5,950.00 .00 100-55345-118-000 IT/COMMUNICAT: SOCIAL SECURITY .00 .00 6,480.00 6,480.00 .00 100-55345-119-000 IT/COMMUNICATI: RETIREMENT (R) .00 .00 5,355.00 5,355.00 .00 100-55345-121-000 IT/COMMUNICATION: GRP HLTH INS .00 .00 7,705.00 7,705.00 .00 100-55345-122-000 IT/COMMUNICATION: LIFE INS .00 .00 101.00 101.00 .00 100-55345-123-000 IT/COMMUNICATION: INC PROTECT .00 .00 366.00 366.00 .00 100-55345-202-000 IT/COMMUNICATION: TRAINING .00 .00 700.00 700.00 .00 100-55345-206-000 IT/COMMUNICATION: TELEPHONE .00 .00 2,585.00 2,585.00 .00 100-55345-207-000 IT/COMMUNICATI: MAINT OF EQUIP .00 .00 5,000.00 5,000.00 .00 100-55345-208-000 IT/COMMUN: MAINT OF FACILITIES .00 .00 400.00 400.00 .00 100-55345-210-000 IT/COMMUNICATIO: PROF SERVICES .00 .00 1,500.00 1,500.00 .00 100-55345-215-000 IT/COMMUNICATION: ADVERTISING .00 .00 250.00 250.00 .00 100-55345-217-000 IT/COMM: MEMBERSHIP & DUES .00 .00 275.00 275.00 .00 100-55345-268-000 IT/COMMUNICATION: CAR/CELL PHO .00 .00 2,700.00 2,700.00 .00 100-55345-286-000 IT/COMMUNICATION: IT SOFTWARE .00 .00 3,000.00 3,000.00 .00 100-55345-295-000 IT/COMMUNICATION: ANNUAL FEES .00 .00 12,000.00 12,000.00 .00 100-55345-296-000 IT/COMMUNICATION: TV EQUIP/ETC .00 .00 1,000.00 1,000.00 .00 100-55345-301-000 IT/COMMUNICATION: SUPPLIES .00 .00 2,400.00 2,400.00 .00 TOTAL IT/COMMUNICATIONS .00 .00 136,521.00 136,521.00 .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 100 - GENERAL FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 10:42AM PAGE: 19 PARK & REC-PARKS 100-55411-102-000 PARKS: WAGES .00 .00 59,843.00 59,843.00 .00 100-55411-103-000 PARKS: OVERTIME .00 .00 1,100.00 1,100.00 .00 100-55411-104-000 PARKS: PT WAGES .00 .00 7,400.00 7,400.00 .00 100-55411-112-000 PARKS: UNIFORMS .00 .00 700.00 700.00 .00 100-55411-118-000 PARKS: SOCIAL SECURITY .00 .00 5,228.00 5,228.00 .00 100-55411-119-000 PARKS: RETIREMENT (R) .00 .00 4,144.00 4,144.00 .00 100-55411-121-000 PARKS: GRP HLTH INS .00 .00 18,661.00 18,661.00 .00 100-55411-122-000 PARKS: LIFE INS .00 .00 123.00 123.00 .00 100-55411-123-000 PARKS: INC PROTECT .00 .00 305.00 305.00 .00 100-55411-202-000 PARKS: TRAINING .00 .00 500.00 500.00 .00 100-55411-203-000 PARKS: HEAT .00 .00 1,000.00 1,000.00 .00 100-55411-204-000 PARKS: ELECTRICITY .00 .00 17,000.00 17,000.00 .00 100-55411-205-000 PARKS: WATER SEWER .00 .00 15,000.00 15,000.00 .00 100-55411-206-000 PARKS: TELEPHONE .00 .00 2,500.00 2,500.00 .00 100-55411-207-000 PARKS: MAINT OF EQUIP .00 .00 2,000.00 2,000.00 .00 100-55411-208-000 PARKS: MAINT OF FACILITIES .00 .00 17,100.00 17,100.00 .00 100-55411-211-000 PARKS: CONTRACT SERVICES .00 .00 4,500.00 4,500.00 .00 100-55411-231-000 PARKS: MOWING EQUIP .00 .00 7,000.00 7,000.00 .00 100-55411-253-000 PARKS: CONCESSIONS .00 .00 20,000.00 20,000.00 .00 100-55411-272-000 PARKS: MAINT OF VEHICLES .00 .00 4,200.00 4,200.00 .00 100-55411-301-000 PARKS: SUPPLIES .00 .00 16,970.00 16,970.00 .00 100-55411-312-000 PARKS: GASOLINE .00 .00 7,000.00 7,000.00 .00 100-55411-313-000 PARKS: DIESEL FUEL .00 .00 2,000.00 2,000.00 .00 TOTAL PARK & REC-PARKS .00 .00 214,274.00 214,274.00 .00 CEMETERY 100-57711-102-000 CEM: WAGES .00 .00 51,984.00 51,984.00 .00 100-57711-112-000 CEM: UNIFORMS .00 .00 150.00 150.00 .00 100-57711-118-000 CEM: SOCIAL SECURITY .00 .00 4,359.00 4,359.00 .00 100-57711-119-000 CEM: RETIREMENT (R) .00 .00 3,875.00 3,875.00 .00 100-57711-121-000 CEM: GRP HLTH INS .00 .00 5,000.00 5,000.00 .00 100-57711-122-000 CEM: LIFE INS .00 .00 86.00 86.00 .00 100-57711-123-000 CEM: INC PROTECT .00 .00 240.00 240.00 .00 100-57711-202-000 CEM: TRAINING .00 .00 250.00 250.00 .00 100-57711-203-000 CEM: HEAT .00 .00 600.00 600.00 .00 100-57711-204-000 CEM: ELECTRICITY .00 .00 425.00 425.00 .00 100-57711-205-000 CEM: WATER SEWER .00 .00 675.00 675.00 .00 100-57711-207-000 CEM: MAINT OF EQUIP .00 .00 3,000.00 3,000.00 .00 100-57711-268-000 CEM: CAR/CELL PHONE .00 .00 480.00 480.00 .00 100-57711-272-000 CEM: MAINT OF VEHICLES .00 .00 1,000.00 1,000.00 .00 100-57711-301-000 CEM: SUPPLIES .00 .00 750.00 750.00 .00 TOTAL CEMETERY .00 .00 72,874.00 72,874.00 .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 100 - GENERAL FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 10:42AM PAGE: 20 TRANSFERS TO OTHER FUNDS 100-59220-220-000 TRANSFER TO AIRPORT FUND .00 .00 60,000.00 60,000.00 .00 100-59220-225-000 TRANSFER TO TRANSIT FUND .00 .00 10,000.00 10,000.00 .00 100-59220-251-000 TRANSFER TO LIBRARY FUND .00 .00 346,554.00 346,554.00 .00 100-59220-254-000 TRANSFER TO YOUTH PROGRAM FUND .00 .00 101,698.00 101,698.00 .00 100-59220-300-000 TRANSFER TO DEBT SERVICE FUND .00 .00 1,165,500.00 1,165,500.00 .00 TOTAL TRANSFERS TO OTHER FUNDS .00 .00 1,683,752.00 1,683,752.00 .00 TOTAL FUND EXPENDITURES .00 .00 7,331,434.00 7,331,434.00 .00 NET REVENUES OVER EXPENDITURES .00 .00 ( 21,153.80) 21,153.80 .00 CITY OF WAUPACA REVENUES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 215 - HOTEL/MOTEL TAX REVENUE FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 11:15AM PAGE: 1 TAXES 215-41241-000-000 ROOM TAX 8%-CITY .00 .00 227,500.00 ( 227,500.00) .00 215-41242-000-000 ROOM TAX 8%-TOWNS .00 .00 48,000.00 ( 48,000.00) .00 TOTAL TAXES .00 .00 275,500.00 ( 275,500.00) .00 TOTAL FUND REVENUE .00 .00 275,500.00 ( 275,500.00) .00 CONVENTION & VISITORS BUREAU 215-51580-295-000 ROOM TAX: TOWNS DISTRIBUTION .00 .00 200,000.00 200,000.00 .00 TOTAL CONVENTION & VISITORS BUREAU .00 .00 200,000.00 200,000.00 .00 OTHER FINANCING USES 215-59220-100-000 TRANSFER TO GEN FUND .00 .00 75,500.00 75,500.00 .00 TOTAL OTHER FINANCING USES .00 .00 75,500.00 75,500.00 .00 TOTAL FUND EXPENDITURES .00 .00 275,500.00 275,500.00 .00 NET REVENUES OVER EXPENDITURES .00 .00 .00 .00 .00 CITY OF WAUPACA REVENUES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 220 - WAUPACA AIRPORT FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 11:17AM PAGE: 1 PUBLIC CHARGES FOR SERVICES 220-46340-000-000 FEES: AIRPORT FUEL CARD SYSTEM .00 .00 81,460.00 ( 81,460.00) .00 220-46345-000-000 FEES: AIRPORT FUEL-PROP CARD .00 .00 81,840.00 ( 81,840.00) .00 220-46350-000-000 FEES: SNOW REMOVAL .00 .00 2,200.00 ( 2,200.00) .00 TOTAL PUBLIC CHARGES FOR SERVICES .00 .00 165,500.00 ( 165,500.00) .00 MISCELLANEOUS REVENUE 220-48215-000-000 RENT: CITY PROPERTY: HANGAR .00 .00 25,000.00 ( 25,000.00) .00 220-48510-000-000 DONATIONS: MISC .00 .00 1,000.00 ( 1,000.00) .00 TOTAL MISCELLANEOUS REVENUE .00 .00 26,000.00 ( 26,000.00) .00 OTHER FINANCING SOURCES 220-49210-000-000 TRANSFER FROM GENERAL FUND .00 .00 60,000.00 ( 60,000.00) .00 TOTAL OTHER FINANCING SOURCES .00 .00 60,000.00 ( 60,000.00) .00 TOTAL FUND REVENUE .00 .00 251,500.00 ( 251,500.00) .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 220 - WAUPACA AIRPORT FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 11:17AM PAGE: 2 MUNICIPAL AIRPORT 220-53510-202-000 AIRPORT: TRAINING .00 .00 6,000.00 6,000.00 .00 220-53510-203-000 AIRPORT: HEAT .00 .00 800.00 800.00 .00 220-53510-204-000 AIRPORT: ELECTRICITY .00 .00 10,500.00 10,500.00 .00 220-53510-205-000 AIRPORT: WATER SEWER .00 .00 1,000.00 1,000.00 .00 220-53510-206-000 AIRPORT: COMMUNICATIONS .00 .00 1,000.00 1,000.00 .00 220-53510-207-000 AIRPORT: MAINT OF EQUIP .00 .00 7,500.00 7,500.00 .00 220-53510-208-000 AIRPORT: MAINT OF FACILITIES .00 .00 8,000.00 8,000.00 .00 220-53510-209-000 AIRPORT: INS & BONDING .00 .00 4,000.00 4,000.00 .00 220-53510-210-000 AIRPORT: PROF SERVICES .00 .00 2,000.00 2,000.00 .00 220-53510-211-000 AIRPORT: CONTRACT SERVICES .00 .00 80,000.00 80,000.00 .00 220-53510-301-000 AIRPORT: SUPPLIES .00 .00 200.00 200.00 .00 220-53510-305-000 AIRPORT: SNOW REMOVAL .00 .00 15,000.00 15,000.00 .00 220-53510-313-000 AIRPORT: DIESEL FUEL .00 .00 2,500.00 2,500.00 .00 220-53510-315-000 AIRPORT: FUEL .00 .00 113,000.00 113,000.00 .00 TOTAL MUNICIPAL AIRPORT .00 .00 251,500.00 251,500.00 .00 TOTAL FUND EXPENDITURES .00 .00 251,500.00 251,500.00 .00 NET REVENUES OVER EXPENDITURES .00 .00 .00 .00 .00 CITY OF WAUPACA REVENUES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 236 - REFUSE/RECYCLING FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 11:30AM PAGE: 1 PUBLIC CHARGES FOR SERVICE 236-46420-000-000 PUBLIC CHARGES - REFUSE/RECYCL .00 .00 287,040.00 ( 287,040.00) .00 TOTAL PUBLIC CHARGES FOR SERVICE .00 .00 287,040.00 ( 287,040.00) .00 TOTAL FUND REVENUE .00 .00 287,040.00 ( 287,040.00) .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 236 - REFUSE/RECYCLING FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 11:30AM PAGE: 2 DEPARTMENT 620 236-53620-102-000 REFUSE/RECYCLE: WAGES .00 .00 15,000.00 15,000.00 .00 236-53620-118-000 REFUSE/RECYCL: SOCIAL SECURITY .00 .00 1,147.00 1,147.00 .00 236-53620-119-000 REFUSE/RECYCLE: RETIREMENT (R) .00 .00 975.00 975.00 .00 236-53620-121-000 REFUSE/RECYCLE: GRP HLTH INS .00 .00 1,235.00 1,235.00 .00 236-53620-122-000 REFUSE/RECYCLE: LIFE INS .00 .00 45.00 45.00 .00 236-53620-123-000 REFUSE/RECYCLE: INC PROTECT .00 .00 50.00 50.00 .00 236-53620-211-000 REFUSE/RECYCL:CONTRACT SERVICE .00 .00 261,000.00 261,000.00 .00 236-53620-216-000 REFUSE/RECYCLE: POSTAGE .00 .00 7,588.00 7,588.00 .00 TOTAL DEPARTMENT 620 .00 .00 287,040.00 287,040.00 .00 TOTAL FUND EXPENDITURES .00 .00 287,040.00 287,040.00 .00 NET REVENUES OVER EXPENDITURES .00 .00 .00 .00 .00 CITY OF WAUPACA REVENUES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 240 - INLAND LAKES FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 11:25AM PAGE: 1 SOURCE 41 240-41110-000-000 TAXES: GENERAL PROPERTY TAXES .00 .00 10,000.00 ( 10,000.00) .00 TOTAL SOURCE 41 .00 .00 10,000.00 ( 10,000.00) .00 TOTAL FUND REVENUE .00 .00 10,000.00 ( 10,000.00) .00 INLAND LAKES 240-56615-210-000 INL LAKES: PROF SERVICES .00 .00 2,500.00 2,500.00 .00 240-56615-215-000 INL LAKES: ADVERTISING .00 .00 200.00 200.00 .00 240-56615-299-000 INL LAKES: MISCELLANEOUS .00 .00 100.00 100.00 .00 240-56615-301-000 INL LAKES: SUPPLIES .00 .00 800.00 800.00 .00 TOTAL INLAND LAKES .00 .00 3,600.00 3,600.00 .00 TOTAL FUND EXPENDITURES .00 .00 3,600.00 3,600.00 .00 NET REVENUES OVER EXPENDITURES .00 .00 6,400.00 ( 6,400.00) .00 CITY OF WAUPACA REVENUES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 251 - LIBRARY FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 11:34AM PAGE: 1 INTERGOVERNMENTAL REVENUES 251-43720-000-000 COUNTY AID: LIBRARY WAUPACA CO .00 .00 408,286.00 ( 408,286.00) .00 251-43725-000-000 COUNTY AID: LIBRARY WAUSHARA .00 .00 14,466.00 ( 14,466.00) .00 251-43730-000-000 COUNTY AID: LIBRARY PORTAGE .00 .00 1,960.00 ( 1,960.00) .00 TOTAL INTERGOVERNMENTAL REVENUES .00 .00 424,712.00 ( 424,712.00) .00 PUBLIC CHARGES FOR SERVICE 251-46710-000-000 FEES: LIBRARY COPIES .00 .00 6,000.00 ( 6,000.00) .00 251-46730-000-000 FEES: LIBRARY COLLECTION AGCY .00 .00 100.00 ( 100.00) .00 251-46735-000-000 FEES: LIBRARY MATERIAL REPLACE .00 .00 3,500.00 ( 3,500.00) .00 TOTAL PUBLIC CHARGES FOR SERVICE .00 .00 9,600.00 ( 9,600.00) .00 MISCELANEOUS REVENUE 251-48215-000-000 RENT: MEETING ROOMS .00 .00 500.00 ( 500.00) .00 251-48310-000-000 SALES: SALE OF PROPERTY/EQUIP .00 .00 100.00 ( 100.00) .00 251-48550-000-000 DONATIONS: LIBRARY .00 .00 42,650.00 ( 42,650.00) .00 TOTAL MISCELANEOUS REVENUE .00 .00 43,250.00 ( 43,250.00) .00 OTHER FINANCING SOURCES 251-49210-000-000 TRANSFER FROM GENERAL FUND .00 .00 346,554.00 ( 346,554.00) .00 TOTAL OTHER FINANCING SOURCES .00 .00 346,554.00 ( 346,554.00) .00 TOTAL FUND REVENUE .00 .00 824,116.00 ( 824,116.00) .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 251 - LIBRARY FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 11:34AM PAGE: 2 LIBRARY - FULL-TIME PERSONNEL 251-55111-102-000 LIBRARY: WAGES .00 .00 380,957.00 380,957.00 .00 251-55111-118-000 LIBRARY: SOCIAL SECURITY .00 .00 24,823.00 24,823.00 .00 251-55111-119-000 LIBRARY: RETIREMENT (R) .00 .00 23,337.00 23,337.00 .00 251-55111-121-000 LIBRARY: GRP HLTH INS .00 .00 70,261.00 70,261.00 .00 251-55111-122-000 LIBRARY: LIFE INS .00 .00 1,255.40 1,255.40 .00 251-55111-123-000 LIBRARY: INC PROTECT .00 .00 1,931.00 1,931.00 .00 251-55111-124-000 LIBRARY: WORK COMP .00 .00 1,035.86 1,035.86 .00 251-55111-125-000 LIBRARY: HLTH INS DEDUCTIB .00 .00 6,000.00 6,000.00 .00 251-55111-130-000 LIBRARY: WELLNESS/EAP PROGRAM .00 .00 748.00 748.00 .00 TOTAL LIBRARY - FULL-TIME PERSONNEL .00 .00 510,348.26 510,348.26 .00 LIBRARY - PART-TIME PERSONNEL 251-55112-104-000 LIBRARY: PT WAGES .00 .00 121,788.00 121,788.00 .00 251-55112-116-000 LIBRARY: PT RETIRE .00 .00 4,932.00 4,932.00 .00 251-55112-118-000 LIBRARY: SOCIAL SECURITY .00 .00 10,362.00 10,362.00 .00 251-55112-122-000 LIBRARY: LIFE INS .00 .00 600.00 600.00 .00 TOTAL LIBRARY - PART-TIME PERSONNEL .00 .00 137,682.00 137,682.00 .00 LIBRARY - OPERATIONS 251-55115-201-000 LIBRARY: TRAVEL .00 .00 4,000.00 4,000.00 .00 251-55115-207-000 LIBRARY: MAINT OF EQUIP .00 .00 6,000.00 6,000.00 .00 251-55115-209-000 LIBRARY: INS & BONDING .00 .00 1,000.00 1,000.00 .00 251-55115-211-000 LIBRARY: CONTRACT SERVICES .00 .00 6,500.00 6,500.00 .00 251-55115-216-000 LIBRARY: POSTAGE .00 .00 1,000.00 1,000.00 .00 251-55115-217-000 LIBRARY: MEMBERSHIP & DUES .00 .00 1,200.00 1,200.00 .00 251-55115-218-000 LIBRARY: OWLS MEMBERSHIP .00 .00 27,591.00 27,591.00 .00 251-55115-253-000 LIBRARY: PROMOTIONAL MATERIALS .00 .00 650.00 650.00 .00 251-55115-282-000 LIBRARY: TECHNOLOGY .00 .00 11,974.00 11,974.00 .00 251-55115-301-000 LIBRARY: SUPPLIES .00 .00 7,500.00 7,500.00 .00 TOTAL LIBRARY - OPERATIONS .00 .00 67,415.00 67,415.00 .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 251 - LIBRARY FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 11:34AM PAGE: 3 LIBRARY - DONATION EXPENSES 251-55120-104-000 LIBRARY: DONATIONS PT WAGES .00 .00 8,000.00 8,000.00 .00 251-55120-118-000 LIBRARY: DONATIONS SOCIAL SEC .00 .00 650.00 650.00 .00 251-55120-250-000 LIBRARY: DONATIONS MATERIALS .00 .00 2,000.00 2,000.00 .00 251-55120-255-000 LIBRARY: DONATIONS PROGRAMS .00 .00 18,000.00 18,000.00 .00 251-55120-282-000 LIBRARY: DONATIONS TECHNOLOGY .00 .00 10,000.00 10,000.00 .00 251-55120-290-000 LIBRARY: DONATIONS AUDIO VISUA .00 .00 2,000.00 2,000.00 .00 251-55120-301-000 LIBRARY: DONATIONS SUPPLIES .00 .00 2,000.00 2,000.00 .00 TOTAL LIBRARY - DONATION EXPENSES .00 .00 42,650.00 42,650.00 .00 LIBRARY - PROGRAMS 251-55125-255-110 LIBRARY: PROGRAMS - ADULT .00 .00 1,500.00 1,500.00 .00 251-55125-255-210 LIBRARY: PROGRAMS - CHILDREN'S .00 .00 3,000.00 3,000.00 .00 251-55125-255-310 LIBRARY: PROGRAMS - TEEN .00 .00 1,000.00 1,000.00 .00 TOTAL LIBRARY - PROGRAMS .00 .00 5,500.00 5,500.00 .00 LIBRARY - MATERIALS 251-55130-250-115 LIBRARY: BOOKS - ADULT .00 .00 17,000.00 17,000.00 .00 251-55130-250-120 LIBRARY: BOOKS - ADULT LG PRNT .00 .00 3,420.00 3,420.00 .00 251-55130-250-215 LIBRARY: BOOKS - CHILDRENS .00 .00 16,000.00 16,000.00 .00 251-55130-250-315 LIBRARY: BOOKS - TEEN .00 .00 3,175.00 3,175.00 .00 251-55130-250-410 LIBRARY: BOOKS - MAG & NEWSPAP .00 .00 4,750.00 4,750.00 .00 TOTAL LIBRARY - MATERIALS .00 .00 44,345.00 44,345.00 .00 LIBRARY - AUDIO VISUAL 251-55135-290-125 LIBRARY: A/V - ADULT MOVIES .00 .00 2,500.00 2,500.00 .00 251-55135-290-130 LIBRARY: A/V - ADULT AUDIO BKS .00 .00 500.00 500.00 .00 251-55135-290-135 LIBRARY: A/V - ADULT MUSIC .00 .00 750.00 750.00 .00 251-55135-290-220 LIBRARY: A/V - CHILDRENS MOVIE .00 .00 1,701.00 1,701.00 .00 251-55135-290-225 LIBRARY: A/V - CHILD AUDIO BKS .00 .00 854.00 854.00 .00 251-55135-290-320 LIBRARY: A/V - TEEN MOVIES .00 .00 468.00 468.00 .00 251-55135-290-420 LIBRARY: A/V - VIDEO GAMES .00 .00 900.00 900.00 .00 251-55135-290-510 LIBRARY: A/V - E-BOOKS/E-RESRC .00 .00 8,503.00 8,503.00 .00 TOTAL LIBRARY - AUDIO VISUAL .00 .00 16,176.00 16,176.00 .00 TOTAL FUND EXPENDITURES .00 .00 824,116.26 824,116.26 .00 NET REVENUES OVER EXPENDITURES .00 .00 ( .26) .26 .00 CITY OF WAUPACA REVENUES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 252 - ADULT RECREATION PROGRAM FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 11:37AM PAGE: 1 PUBLIC CHARGES FOR SERVICES 252-44621-000-000 REC DEPT: BASKETBAL .00 .00 2,000.00 ( 2,000.00) .00 252-44622-000-000 REC DEPT: BASEBALL .00 .00 4,000.00 ( 4,000.00) .00 252-44623-000-000 REC DEPT: VOLLEYBAL .00 .00 10,000.00 ( 10,000.00) .00 252-44624-000-000 REC DEPT:KICKBALL/PIKLBALL .00 .00 2,000.00 ( 2,000.00) .00 TOTAL PUBLIC CHARGES FOR SERVICES .00 .00 18,000.00 ( 18,000.00) .00 TOTAL FUND REVENUE .00 .00 18,000.00 ( 18,000.00) .00 ADULT VOLLEYBALL 252-55217-231-000 ADULT VOLLEYBALL: EQUIP .00 .00 500.00 500.00 .00 252-55217-232-000 ADULT VOLLEYBAL: REFEREES, ETC .00 .00 4,300.00 4,300.00 .00 TOTAL ADULT VOLLEYBALL .00 .00 4,800.00 4,800.00 .00 ADULT BASKETBALL 252-55218-104-000 ADULT BASKETBALL: PT WAGES .00 .00 1,000.00 1,000.00 .00 252-55218-118-000 ADULT BASKETBALL: SOC SEC .00 .00 77.00 77.00 .00 252-55218-231-000 ADULT BASKETBALL: EQUIPMENT .00 .00 400.00 400.00 .00 252-55218-232-000 ADULT BASKETBAL: REFEREES, ETC .00 .00 2,000.00 2,000.00 .00 TOTAL ADULT BASKETBALL .00 .00 3,477.00 3,477.00 .00 ADULT SOFTBALL 252-55219-231-000 ADULT SOFTBALL: EQUIP .00 .00 1,500.00 1,500.00 .00 252-55219-232-000 ADULT SOFTBALL: UMPS, ETC .00 .00 5,000.00 5,000.00 .00 TOTAL ADULT SOFTBALL .00 .00 6,500.00 6,500.00 .00 ADULT KICKBALL 252-55220-231-000 ADULT KICKBALL/PIKLBALL: EQUIP .00 .00 200.00 200.00 .00 252-55220-232-000 ADULT KICKB: REFEREE,UMPS, ETC .00 .00 500.00 500.00 .00 TOTAL ADULT KICKBALL .00 .00 700.00 700.00 .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 252 - ADULT RECREATION PROGRAM FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 11:37AM PAGE: 2 ADULT PROGRAMS OTHER 252-55225-233-000 ADULT PROG: PROGRAM EXPENSES .00 .00 500.00 500.00 .00 TOTAL ADULT PROGRAMS OTHER .00 .00 500.00 500.00 .00 OTHER FINANCING USES 252-59910-000-000 TRANSFER TO GEN FUND .00 .00 2,800.00 2,800.00 .00 TOTAL OTHER FINANCING USES .00 .00 2,800.00 2,800.00 .00 TOTAL FUND EXPENDITURES .00 .00 18,777.00 18,777.00 .00 NET REVENUES OVER EXPENDITURES .00 .00 ( 777.00) 777.00 .00 CITY OF WAUPACA REVENUES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 254 - YOUTH PROGRAMS FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 12:26PM PAGE: 1 PUBLIC CHARGES FOR SERVICE 254-46730-000-000 FEES: REC DEPT: MEMBERSHIP .00 .00 1,200.00 ( 1,200.00) .00 254-46735-000-000 FEES: REC DEPT: SWIMMING .00 .00 5,000.00 ( 5,000.00) .00 254-46740-000-000 FEES: REC DEPT: YOUTH PROGRAMS .00 .00 35,000.00 ( 35,000.00) .00 TOTAL PUBLIC CHARGES FOR SERVICE .00 .00 41,200.00 ( 41,200.00) .00 INTERGOVT CHARGES FOR SERVICE 254-47350-100-000 TOWNSHIPS: CONTRIBUTION DAYTON .00 .00 44,864.00 ( 44,864.00) .00 254-47350-105-000 TOWNSHIPS: CONTRIBUTION FARM .00 .00 63,343.00 ( 63,343.00) .00 254-47350-110-000 TOWNSHIPS: CONTRIBUTION WAUP .00 .00 20,215.00 ( 20,215.00) .00 254-47350-200-000 INTERGOVT CHRG: SCHOOL SWIM .00 .00 5,000.00 ( 5,000.00) .00 TOTAL INTERGOVT CHARGES FOR SERVIC .00 .00 133,422.00 ( 133,422.00) .00 OTHER FINANCING SOURCES 254-49210-000-000 TRANSFER FROM GENERAL FUND .00 .00 101,698.00 ( 101,698.00) .00 TOTAL OTHER FINANCING SOURCES .00 .00 101,698.00 ( 101,698.00) .00 TOTAL FUND REVENUE .00 .00 276,320.00 ( 276,320.00) .00 PARK & REC-ADMINISTRATION 254-55211-102-000 REC ADMIN: WAGES .00 .00 68,562.00 68,562.00 .00 254-55211-118-000 REC ADMIN: SOCIAL SECURITY .00 .00 5,245.00 5,245.00 .00 254-55211-119-000 REC ADMIN: RETIREMENT (R) .00 .00 4,457.00 4,457.00 .00 254-55211-121-000 REC ADMIN: GRP HLTH INS .00 .00 8,462.00 8,462.00 .00 254-55211-122-000 REC ADMIN: LIFE INS .00 .00 283.00 283.00 .00 254-55211-123-000 REC ADMIN: INC PROTECT .00 .00 299.00 299.00 .00 254-55211-124-000 REC ADMIN: WORK COMP .00 .00 2,857.00 2,857.00 .00 254-55211-206-000 REC ADMIN: TELEPHONE .00 .00 500.00 500.00 .00 254-55211-207-000 REC ADMIN: MAINT OF EQUIP .00 .00 50.00 50.00 .00 254-55211-217-000 REC ADMIN: MEMBERSHIP & DUES .00 .00 150.00 150.00 .00 254-55211-268-000 REC ADMIN: CAR /CELL PHONE .00 .00 800.00 800.00 .00 254-55211-301-000 REC ADMIN: SUPPLIES .00 .00 350.00 350.00 .00 TOTAL PARK & REC-ADMINISTRATION .00 .00 92,015.00 92,015.00 .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 254 - YOUTH PROGRAMS FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 12:26PM PAGE: 2 PARK & REC-YOUTH PROGRAMS 254-55212-104-000 YOUTH PROGS: PT WAGES .00 .00 12,607.00 12,607.00 .00 254-55212-118-000 YOUTH PROGS: SOCIAL SECURITY .00 .00 964.00 964.00 .00 254-55212-124-000 YOUTH PROGS: WORK COMP .00 .00 537.00 537.00 .00 254-55212-209-000 YOUTH PROGS: INS & BONDING .00 .00 133.00 133.00 .00 254-55212-217-000 YOUTH PROGS: MEMBERSHIP & DUES .00 .00 1,915.00 1,915.00 .00 254-55212-232-000 YOUTH PROGS: REFEREE,UMPS, ETC .00 .00 18,531.00 18,531.00 .00 254-55212-301-000 YOUTH PROGS: SUPPLIES .00 .00 14,728.00 14,728.00 .00 TOTAL PARK & REC-YOUTH PROGRAMS .00 .00 49,415.00 49,415.00 .00 PARK & REC-YOUTH CENTER 254-55215-104-000 YOUTH CTR: PT WAGES .00 .00 43,287.00 43,287.00 .00 254-55215-116-000 YOUTH CTR: PT RETIRE .00 .00 1,517.00 1,517.00 .00 254-55215-118-000 YOUTH CTR: SOCIAL SECURIT .00 .00 3,311.00 3,311.00 .00 254-55215-122-000 YOUTH CTR: LIFE INS .00 .00 310.00 310.00 .00 254-55215-124-000 YOUTH CTR: WORK COMP .00 .00 1,840.00 1,840.00 .00 254-55215-301-000 YOUTH CTR: SUPPLIES .00 .00 1,500.00 1,500.00 .00 TOTAL PARK & REC-YOUTH CENTER .00 .00 51,765.00 51,765.00 .00 PARK & REC-RECREATION BLDG 254-55216-104-000 REC BLDG :PARTTIME .00 .00 2,500.00 2,500.00 .00 254-55216-116-000 REC BLDG : PT RETIRE .00 .00 209.00 209.00 .00 254-55216-118-000 REC BLDG : SOCIAL SECURITY .00 .00 236.00 236.00 .00 254-55216-124-000 REC BLDG: WORK COMP .00 .00 131.00 131.00 .00 254-55216-203-000 REC BLDG: UTILITIES .00 .00 5,750.00 5,750.00 .00 254-55216-208-000 REC BLDG: MAINT OF FACILITIES .00 .00 3,390.00 3,390.00 .00 254-55216-301-000 REC BLDG: SUPPLIES .00 .00 450.00 450.00 .00 TOTAL PARK & REC-RECREATION BLDG .00 .00 12,666.00 12,666.00 .00 PARK & REC-BEACHES 254-55221-104-000 BEACHES: PT WAGES .00 .00 17,750.00 17,750.00 .00 254-55221-118-000 BEACHES: SOCIAL SECURITY .00 .00 1,358.00 1,358.00 .00 254-55221-124-000 BEACHES: WORK COMP .00 .00 723.00 723.00 .00 254-55221-301-000 BEACHES: SUPPLIES .00 .00 775.00 775.00 .00 TOTAL PARK & REC-BEACHES .00 .00 20,606.00 20,606.00 .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 254 - YOUTH PROGRAMS FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 12:26PM PAGE: 3 PARK & REC-PARKS 254-55411-104-000 PARKS: PT WAGES .00 .00 30,600.00 30,600.00 .00 254-55411-118-000 PARKS: SOCIAL SECURITY .00 .00 2,341.00 2,341.00 .00 254-55411-124-000 PARKS: WORK COMP .00 .00 1,300.00 1,300.00 .00 254-55411-203-000 PARKS: UTILITIES .00 .00 4,300.00 4,300.00 .00 254-55411-207-000 PARKS: MAINT OF EQUIP .00 .00 500.00 500.00 .00 254-55411-208-000 PARKS: MAINT OF FACILITIES .00 .00 700.00 700.00 .00 254-55411-211-000 PARKS: CONTRACT SERVICES .00 .00 200.00 200.00 .00 254-55411-231-000 PARKS: MOWING EQUIP .00 .00 1,900.00 1,900.00 .00 254-55411-272-000 PARKS: MAINT OF VEHICLES .00 .00 1,300.00 1,300.00 .00 254-55411-301-000 PARKS: SUPPLIES .00 .00 1,930.00 1,930.00 .00 TOTAL PARK & REC-PARKS .00 .00 45,071.00 45,071.00 .00 TOTAL FUND EXPENDITURES .00 .00 271,538.00 271,538.00 .00 NET REVENUES OVER EXPENDITURES .00 .00 4,782.00 ( 4,782.00) .00 CITY OF WAUPACA REVENUES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 300 - DEBT SERVICE FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 12:27PM PAGE: 1 OTHER FINANCING SOURCES 300-49210-000-000 TRANSFER IN: GENERAL FUND .00 .00 1,165,500.00 ( 1,165,500.00) .00 TOTAL OTHER FINANCING SOURCES .00 .00 1,165,500.00 ( 1,165,500.00) .00 TOTAL FUND REVENUE .00 .00 1,165,500.00 ( 1,165,500.00) .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 300 - DEBT SERVICE FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 12:27PM PAGE: 2 PRINCIPAL 300-58100-400-118 PRINCIPAL: 2018 GO REFUND BOND .00 .00 570,000.00 570,000.00 .00 300-58100-400-119 PRINCIPAL: 2019 GO BOND .00 .00 140,000.00 140,000.00 .00 300-58100-400-120 PRINCIPAL: 2020 GO BOND .00 .00 405,000.00 405,000.00 .00 300-58100-400-121 PRINCIPAL:2022A GO REFUND BOND .00 .00 25,000.00 25,000.00 .00 300-58100-400-122 PRINCIPAL:2022B GO REFUND BOND .00 .00 310,000.00 310,000.00 .00 TOTAL PRINCIPAL .00 .00 1,450,000.00 1,450,000.00 .00 INTEREST 300-58200-400-118 INTEREST: 2018 GO REFUND BOND .00 .00 37,200.00 37,200.00 .00 300-58200-400-119 INTEREST: 2019 GO BOND .00 .00 34,100.00 34,100.00 .00 300-58200-400-120 INTEREST: 2020 GO BOND .00 .00 84,175.00 84,175.00 .00 300-58200-400-121 INTEREST: GO 2022A (PW GARAGE) .00 .00 287,413.00 287,413.00 .00 300-58200-400-122 INTEREST: GO 2022B (CIP) .00 .00 65,276.00 65,276.00 .00 TOTAL INTEREST .00 .00 508,164.00 508,164.00 .00 DEBT SERVICE COSTS 300-58210-210-000 DEBT SERVICING: MISC .00 .00 1,340.00 1,340.00 .00 TOTAL DEBT SERVICE COSTS .00 .00 1,340.00 1,340.00 .00 TOTAL FUND EXPENDITURES .00 .00 1,959,504.00 1,959,504.00 .00 NET REVENUES OVER EXPENDITURES .00 .00 ( 794,004.00) 794,004.00 .00 CITY OF WAUPACA REVENUES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 400 - CAPITAL PROJECTS FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 12:28PM PAGE: 1 OTHER FINANCING SOURCES 400-49211-000-000 DEBT PROCEEDS .00 .00 1,500,000.00 ( 1,500,000.00) .00 TOTAL OTHER FINANCING SOURCES .00 .00 1,500,000.00 ( 1,500,000.00) .00 TOTAL FUND REVENUE .00 .00 1,500,000.00 ( 1,500,000.00) .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 400 - CAPITAL PROJECTS FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 12:28PM PAGE: 2 C/O IT/COMMUNICATIONS 400-71552-502-000 C/O IT-COMM: EQUIPMENT .00 .00 191,000.00 191,000.00 .00 TOTAL C/O IT/COMMUNICATIONS .00 .00 191,000.00 191,000.00 .00 C/O CITY HALL/LIBRARY BLDG 400-71711-503-000 C/O CITY HALL: BUILDINGS .00 .00 342,250.00 342,250.00 .00 TOTAL C/O CITY HALL/LIBRARY BLDG .00 .00 342,250.00 342,250.00 .00 C/O POLICE PATROL 400-72112-502-000 C/O POLICE PATROL: EQUIPMENT .00 .00 110,000.00 110,000.00 .00 TOTAL C/O POLICE PATROL .00 .00 110,000.00 110,000.00 .00 C/O MACHINERY & EQUIPMENT 400-74111-502-000 C/O MACH & EQUIP: EQUIPMENT .00 .00 90,000.00 90,000.00 .00 TOTAL C/O MACHINERY & EQUIPMENT .00 .00 90,000.00 90,000.00 .00 C/O PUBLIC WORKS GARAGE 400-74121-503-000 C/O GARAGE: LAND & IMPRVMTS .00 .00 9,318,180.00 9,318,180.00 .00 TOTAL C/O PUBLIC WORKS GARAGE .00 .00 9,318,180.00 9,318,180.00 .00 C/O MAIN STREET RECONSTRUCTION 400-74318-505-100 C/O STREETS: MAIN ST ENG .00 .00 95,000.00 95,000.00 .00 TOTAL C/O MAIN STREET RECONSTRUCTIO .00 .00 95,000.00 95,000.00 .00 C/O MUNICIPAL AIRPORT 400-74531-503-000 C/O AIRPORT: IMPROVEMENTS .00 .00 1,250,000.00 1,250,000.00 .00 TOTAL C/O MUNICIPAL AIRPORT .00 .00 1,250,000.00 1,250,000.00 .00 TOTAL FUND EXPENDITURES .00 .00 11,396,430.00 11,396,430.00 .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 400 - CAPITAL PROJECTS FUND PERIOD BUDGET % OF PERIOD YTD ACTUAL AMOUNT BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 12:28PM PAGE: 3 NET REVENUES OVER EXPENDITURES .00 .00 ( 9,896,430.00) 9,896,430.00 .00 CITY OF WAUPACA REVENUES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 404 - TIF #4 FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 12:30PM PAGE: 1 TAXES 404-41111-000-000 GENERAL PROPERTY TAXES .00 .00 ( 666,831.04) 666,831.04 .00 404-41490-000-000 COMPUTER AID .00 .00 ( 4,545.00) 4,545.00 .00 TOTAL TAXES .00 .00 ( 671,376.04) 671,376.04 .00 TOTAL FUND REVENUE .00 .00 ( 671,376.04) 671,376.04 .00 ADMINISTRATIVE COSTS 404-51440-210-000 TIF 4: PROFESSIONAL SERVICES .00 .00 3,600.00 3,600.00 .00 TOTAL ADMINISTRATIVE COSTS .00 .00 3,600.00 3,600.00 .00 DEBT SERVICE PRINCIPAL 404-58100-420-000 PRINCIPAL: TIF 4 .00 .00 70,000.00 70,000.00 .00 TOTAL DEBT SERVICE PRINCIPAL .00 .00 70,000.00 70,000.00 .00 DEBT SERVICE INTEREST 404-58200-420-000 INTEREST: TIF 4 .00 .00 802.00 802.00 .00 TOTAL DEBT SERVICE INTEREST .00 .00 802.00 802.00 .00 TOTAL FUND EXPENDITURES .00 .00 74,402.00 74,402.00 .00 NET REVENUES OVER EXPENDITURES .00 .00 ( 745,778.04) 745,778.04 .00 CITY OF WAUPACA REVENUES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 408 - TIF #8 FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 12:30PM PAGE: 2 TAXES 408-41111-000-000 GENERAL PROPERTY TAXES .00 .00 ( 348,687.46) 348,687.46 .00 408-41490-000-000 COMPUTER AID .00 .00 ( 4,255.00) 4,255.00 .00 TOTAL TAXES .00 .00 ( 352,942.46) 352,942.46 .00 OTHER FINANCING SOURCES 408-49440-000-000 TRANFERS FROM TIF 4 .00 .00 ( 305,162.00) 305,162.00 .00 TOTAL OTHER FINANCING SOURCES .00 .00 ( 305,162.00) 305,162.00 .00 TOTAL FUND REVENUE .00 .00 ( 658,104.46) 658,104.46 .00 ADMINISTRATIVE COSTS 408-51478-210-000 TIF 8: PROF SERVICES .00 .00 2,500.00 2,500.00 .00 408-51478-211-703 TIF 8 - PREMIER WAUPACA LLC .00 .00 87,435.00 87,435.00 .00 TOTAL ADMINISTRATIVE COSTS .00 .00 89,935.00 89,935.00 .00 DEBT SERVICE PRINCIPAL 408-58100-420-000 PRINCIPAL: BONDS: TIF: PRINCIP .00 .00 470,000.00 470,000.00 .00 TOTAL DEBT SERVICE PRINCIPAL .00 .00 470,000.00 470,000.00 .00 DEBT SERVICE INTEREST 408-58200-420-000 INTEREST: BONDS: TIF: INTEREST .00 .00 37,350.00 37,350.00 .00 TOTAL DEBT SERVICE INTEREST .00 .00 37,350.00 37,350.00 .00 OTHER FINANCING USES 408-59210-000-000 TRANSFER TO GENERAL FUND .00 .00 37,009.00 37,009.00 .00 TOTAL OTHER FINANCING USES .00 .00 37,009.00 37,009.00 .00 TOTAL FUND EXPENDITURES .00 .00 634,294.00 634,294.00 .00 NET REVENUES OVER EXPENDITURES .00 .00 ( 1,292,398.46) 1,292,398.46 .00 CITY OF WAUPACA REVENUES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 410 - TIF #10 FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 12:30PM PAGE: 3 TAXES 410-41111-000-000 GENERAL PROPERTY TAXES .00 .00 ( 57,606.00) 57,606.00 .00 410-41490-000-000 COMPUTER AID .00 .00 ( 1,304.00) 1,304.00 .00 TOTAL TAXES .00 .00 ( 58,910.00) 58,910.00 .00 OTHER FINANCING SOURCES 410-49404-000-000 TRANSFER FROM TIF #4 .00 .00 ( 175,637.00) 175,637.00 .00 TOTAL OTHER FINANCING SOURCES .00 .00 ( 175,637.00) 175,637.00 .00 TOTAL FUND REVENUE .00 .00 ( 234,547.00) 234,547.00 .00 ADMINISTRATIVE COSTS 410-51480-210-000 TIF 10: PROF SERVICES .00 .00 5,000.00 5,000.00 .00 410-51480-501-000 TIF 10: C/O LAND & LAND IMPROV .00 .00 336,000.00 336,000.00 .00 TOTAL ADMINISTRATIVE COSTS .00 .00 341,000.00 341,000.00 .00 OTHER FINANCING USES 410-59210-000-000 TRANSFER TO GENERAL FUND .00 .00 10,250.00 10,250.00 .00 TOTAL OTHER FINANCING USES .00 .00 10,250.00 10,250.00 .00 TOTAL FUND EXPENDITURES .00 .00 351,250.00 351,250.00 .00 NET REVENUES OVER EXPENDITURES .00 .00 ( 585,797.00) 585,797.00 .00 CITY OF WAUPACA REVENUES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 610 - WATER UTILITY FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 12:46PM PAGE: 1 APROPRIATIONS 610-43901-000-000 APPROPRIATIONS TO SEWER .00 .00 ( 7,676.00) 7,676.00 .00 TOTAL APROPRIATIONS .00 .00 ( 7,676.00) 7,676.00 .00 WATER SALES REVENUE 610-46110-000-000 SALES OF WATER: RESIDENTIA .00 .00 391,875.00 ( 391,875.00) .00 610-46120-000-000 SALE OF WATER COMMERCIAL .00 .00 161,452.50 ( 161,452.50) .00 610-46130-000-000 SALES OF WATER: PUBLIC .00 .00 39,966.02 ( 39,966.02) .00 610-46140-000-000 SALES OF WATER: INDUSTRIAL .00 .00 287,375.00 ( 287,375.00) .00 610-46150-000-000 SALES OF WATER:MULTIFAMILY .00 .00 47,025.00 ( 47,025.00) .00 610-46210-000-000 SALES OF WATER: PRIVATE FI .00 .00 31,595.58 ( 31,595.58) .00 610-46310-000-000 SALES OF WATER: PUBLIC FIR .00 .00 371,361.65 ( 371,361.65) .00 TOTAL WATER SALES REVENUE .00 .00 1,330,650.75 ( 1,330,650.75) .00 MISCELLANEOUS REVENUE 610-47010-000-000 CUSTOMER PENALTIES .00 .00 2,500.00 ( 2,500.00) .00 610-47110-000-000 MISC SERVICE REV .00 .00 2,000.00 ( 2,000.00) .00 610-47430-000-000 WATER REVENUES: CELLULINK .00 .00 20,000.00 ( 20,000.00) .00 610-47510-000-000 INTEREST ON INVESTMENTS .00 .00 30,000.00 ( 30,000.00) .00 TOTAL MISCELLANEOUS REVENUE .00 .00 54,500.00 ( 54,500.00) .00 OTHER FINANCING SOURCES 610-49100-000-000 OTHER FIN: BOND PROCEEDS .00 .00 172,000.00 ( 172,000.00) .00 TOTAL OTHER FINANCING SOURCES .00 .00 172,000.00 ( 172,000.00) .00 TOTAL FUND REVENUE .00 .00 1,549,474.75 ( 1,549,474.75) .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 610 - WATER UTILITY FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 12:46PM PAGE: 2 DEPRECIATION EXP 610-50310-399-000 DEPRECIATION .00 .00 217,500.00 217,500.00 .00 TOTAL DEPRECIATION EXP .00 .00 217,500.00 217,500.00 .00 TAX EXPENSE 610-50810-399-000 TAXES .00 .00 200,000.00 200,000.00 .00 TOTAL TAX EXPENSE .00 .00 200,000.00 200,000.00 .00 WELLHEAD PROTECTION 610-60300-210-000 WLHD PROT: PROF SERVICES .00 .00 2,500.00 2,500.00 .00 610-60300-211-000 WLHD PROT: CONTRACT SERVICES .00 .00 10,000.00 10,000.00 .00 TOTAL WELLHEAD PROTECTION .00 .00 12,500.00 12,500.00 .00 MAINTENANCE OF WELLS 610-61400-102-000 WELLS: WAGES .00 .00 500.00 500.00 .00 610-61400-118-000 WELLS: SOCIAL SECURITY .00 .00 38.00 38.00 .00 610-61400-119-000 WELLS: RETIREMENT (R) .00 .00 34.00 34.00 .00 610-61400-207-000 WELLS: MAINT OF EQUIP .00 .00 300.00 300.00 .00 610-61400-210-000 WELLS: PROF SERVICES .00 .00 200.00 200.00 .00 TOTAL MAINTENANCE OF WELLS .00 .00 1,072.00 1,072.00 .00 MAINTENANCE OF SUPPLY 610-61600-102-000 SUPPLY: WAGES .00 .00 5,692.50 5,692.50 .00 610-61600-118-000 SUPPLY: SOCIAL SECURITY .00 .00 435.00 435.00 .00 610-61600-119-000 SUPPLY: RETIREMENT (R) .00 .00 373.00 373.00 .00 610-61600-208-000 SUPPLY: MAINT OF FACILITIES .00 .00 6,000.00 6,000.00 .00 TOTAL MAINTENANCE OF SUPPLY .00 .00 12,500.50 12,500.50 .00 FUEL FOR POWER 610-62300-203-000 FUEL: HEAT .00 .00 2,500.00 2,500.00 .00 610-62300-204-000 FUEL: ELECTRICITY .00 .00 100,000.00 100,000.00 .00 TOTAL FUEL FOR POWER .00 .00 102,500.00 102,500.00 .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 610 - WATER UTILITY FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 12:46PM PAGE: 3 PUMPING 610-62400-102-000 PUMPING: WAGES .00 .00 8,280.00 8,280.00 .00 610-62400-118-000 PUMPING: SOCIAL SECURITY .00 .00 633.42 633.42 .00 610-62400-119-000 PUMPING: RETIREMENT (R) .00 .00 542.34 542.34 .00 610-62400-207-000 PUMPING: MAINT OF EQUIP .00 .00 2,500.00 2,500.00 .00 TOTAL PUMPING .00 .00 11,955.76 11,955.76 .00 OPERATIONS MISCELLANEOUS 610-62600-102-000 OPS MISC: WAGES .00 .00 11,385.00 11,385.00 .00 610-62600-118-000 OPS MISC: SOCIAL SECURITY .00 .00 871.00 871.00 .00 610-62600-119-000 OPS MISC: RETIREMENT (R) .00 .00 746.00 746.00 .00 610-62600-207-000 OPS MISC: MAINT OF EQUIP .00 .00 500.00 500.00 .00 610-62600-208-000 OPS MISC: MAINT OF FACILITIES .00 .00 2,000.00 2,000.00 .00 610-62600-301-000 OPS MISC: SUPPLIES .00 .00 750.00 750.00 .00 TOTAL OPERATIONS MISCELLANEOUS .00 .00 16,252.00 16,252.00 .00 MAINTENANCE OF STRUCTURES 610-63100-101-000 STRUCT: SALARIES .00 .00 2,949.75 2,949.75 .00 610-63100-118-000 STRUCT: SOCIAL SECURITY .00 .00 226.00 226.00 .00 610-63100-119-000 STRUCT: RETIREMENT (R) .00 .00 191.00 191.00 .00 610-63100-121-000 STRUCT: GRP HLTH INS .00 .00 300.00 300.00 .00 610-63100-208-000 STRUCT: MAINT OF FACILITIES .00 .00 8,000.00 8,000.00 .00 610-63100-211-000 STRUCT: CONTRACT SERVICES .00 .00 500.00 500.00 .00 TOTAL MAINTENANCE OF STRUCTURES .00 .00 12,166.75 12,166.75 .00 MAINTENANCE OF POWER PROD 610-63200-207-000 PWR PROD: MAINT OF EQUIP .00 .00 1,000.00 1,000.00 .00 TOTAL MAINTENANCE OF POWER PROD .00 .00 1,000.00 1,000.00 .00 MAINT OF PUMPING EQUIP 610-63300-102-000 PUMP EQU: WAGES .00 .00 1,552.50 1,552.50 .00 610-63300-118-000 PUMP EQU: SOCIAL SECURITY .00 .00 119.00 119.00 .00 610-63300-119-000 PUMP EQU: RETIREMENT (R) .00 .00 102.00 102.00 .00 610-63300-207-000 PUMP EQU: MAINT OF EQUIP .00 .00 4,000.00 4,000.00 .00 TOTAL MAINT OF PUMPING EQUIP .00 .00 5,773.50 5,773.50 .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 610 - WATER UTILITY FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 12:46PM PAGE: 4 CHEMICALS 610-64100-307-000 CHEMICALS: CHEMICALS .00 .00 20,000.00 20,000.00 .00 TOTAL CHEMICALS .00 .00 20,000.00 20,000.00 .00 LABOR EXPENSE 610-64200-102-000 LABOR: WAGES .00 .00 9,315.00 9,315.00 .00 610-64200-118-000 LABOR: SOCIAL SECURITY .00 .00 713.00 713.00 .00 610-64200-119-000 LABOR: RETIREMENT (R) .00 .00 610.00 610.00 .00 TOTAL LABOR EXPENSE .00 .00 10,638.00 10,638.00 .00 MAINTENANCE OF WTR TRMT 610-65200-102-000 WTR TRMT: WAGES .00 .00 1,552.50 1,552.50 .00 TOTAL MAINTENANCE OF WTR TRMT .00 .00 1,552.50 1,552.50 .00 OPERATIONS STORAGE FACILITY 610-66100-102-000 STORAGE FAC: WAGES .00 .00 2,070.00 2,070.00 .00 610-66100-118-000 STORAGE FAC: SOCIAL SECURITY .00 .00 158.00 158.00 .00 610-66100-119-000 STORAGE FAC: RETIREMENT (R) .00 .00 136.00 136.00 .00 610-66100-207-000 STORAGE FAC: MAINT OF EQUIP .00 .00 2,000.00 2,000.00 .00 610-66100-208-000 STORAGE FAC: MAINT OF FACILITI .00 .00 5,000.00 5,000.00 .00 610-66100-210-000 STORAGE FAC: PROF SERVICES .00 .00 2,500.00 2,500.00 .00 TOTAL OPERATIONS STORAGE FACILITY .00 .00 11,864.00 11,864.00 .00 OPERATIONS METER EXPENSE 610-66300-102-000 METER EXP: WAGES .00 .00 63,450.68 63,450.68 .00 610-66300-118-000 METER EXP: SOCIAL SECURITY .00 .00 4,854.00 4,854.00 .00 610-66300-119-000 METER EXP: RETIREMENT (R) .00 .00 4,156.00 4,156.00 .00 610-66300-207-000 METER EXP: MAINT OF EQUIP .00 .00 10,000.00 10,000.00 .00 610-66300-208-000 METER EXP: MAINT OF FACILITIES .00 .00 12,500.00 12,500.00 .00 610-66300-301-000 METER EXP: SUPPLIES .00 .00 6,000.00 6,000.00 .00 610-66300-304-000 METER EXP: PARTS .00 .00 5,000.00 5,000.00 .00 TOTAL OPERATIONS METER EXPENSE .00 .00 105,960.68 105,960.68 .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 610 - WATER UTILITY FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 12:46PM PAGE: 5 CUSTOMER INSTALLATIONS 610-66400-102-000 CUST INSTALL: WAGES .00 .00 3,622.50 3,622.50 .00 610-66400-118-000 CUST INSTALL: SOCIAL SECURITY .00 .00 277.00 277.00 .00 610-66400-119-000 CUST INSTALL: RETIREMENT (R) .00 .00 237.00 237.00 .00 610-66400-301-000 CUST INSTALL: SUPPLIES .00 .00 250.00 250.00 .00 TOTAL CUSTOMER INSTALLATIONS .00 .00 4,386.50 4,386.50 .00 OPERATIONS MISCELLANEOUS 610-66500-102-000 OPS MISC: WAGES .00 .00 14,490.00 14,490.00 .00 610-66500-118-000 OPS MISC: SOCIAL SECURITY .00 .00 1,108.00 1,108.00 .00 610-66500-119-000 OPS MISC: RETIREMENT (R) .00 .00 949.00 949.00 .00 610-66500-210-000 OPS MISC: PROF SERVICES .00 .00 5,000.00 5,000.00 .00 610-66500-231-000 OPS MISC: EQUIP .00 .00 5,000.00 5,000.00 .00 610-66500-301-000 OPS MISC: SUPPLIES .00 .00 500.00 500.00 .00 TOTAL OPERATIONS MISCELLANEOUS .00 .00 27,047.00 27,047.00 .00 TRANSMISSION & DISTRIBUTION 610-67300-102-000 T&D: WAGES .00 .00 8,500.00 8,500.00 .00 610-67300-118-000 T&D: SOCIAL SECURITY .00 .00 650.00 650.00 .00 610-67300-119-000 T&D: RETIREMENT (R) .00 .00 557.00 557.00 .00 610-67300-208-000 T&D: MAINT OF FACILITIES .00 .00 36,000.00 36,000.00 .00 610-67300-210-000 T&D: PROF SERVICES .00 .00 35,000.00 35,000.00 .00 610-67300-301-000 T&D: SUPPLIES .00 .00 5,000.00 5,000.00 .00 TOTAL TRANSMISSION & DISTRIBUTION .00 .00 85,707.00 85,707.00 .00 MAINTENANCE OF SERVICES 610-67500-102-000 SERVICES: WAGES .00 .00 17,077.50 17,077.50 .00 610-67500-118-000 SERVICES: SOCIAL SECURITY .00 .00 1,306.00 1,306.00 .00 610-67500-119-000 SERVICES: RETIREMENT (R) .00 .00 1,119.00 1,119.00 .00 610-67500-208-000 SERVICES: MAINT OF FACILITIES .00 .00 15,000.00 15,000.00 .00 610-67500-301-000 SERVICES: SUPPLIES .00 .00 3,000.00 3,000.00 .00 TOTAL MAINTENANCE OF SERVICES .00 .00 37,502.50 37,502.50 .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 610 - WATER UTILITY FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 12:46PM PAGE: 6 MAINTENANCE OF HYDRANTS 610-67700-102-000 HYDRANTS: WAGES .00 .00 7,245.00 7,245.00 .00 610-67700-118-000 HYDRANTS: SOCIAL SECURITY .00 .00 554.00 554.00 .00 610-67700-119-000 HYDRANTS: RETIREMENT (R) .00 .00 475.00 475.00 .00 610-67700-208-000 HYDRANTS: MAINT OF FACILITIES .00 .00 10,500.00 10,500.00 .00 610-67700-301-000 HYDRANTS: SUPPLIES .00 .00 2,000.00 2,000.00 .00 TOTAL MAINTENANCE OF HYDRANTS .00 .00 20,774.00 20,774.00 .00 METER READING 610-90200-102-000 METER RDG: WAGES .00 .00 5,278.50 5,278.50 .00 610-90200-118-000 METER RDG: SOCIAL SECURITY .00 .00 404.00 404.00 .00 610-90200-119-000 METER RDG: RETIREMENT (R) .00 .00 334.00 334.00 .00 TOTAL METER READING .00 .00 6,016.50 6,016.50 .00 RECORDS & COLLECTIONS 610-90300-102-000 R&C: WAGES .00 .00 47,977.42 47,977.42 .00 610-90300-104-000 R&C: PART-TIME HOURS .00 .00 3,546.00 3,546.00 .00 610-90300-118-000 R&C: SOCIAL SECURITY .00 .00 3,670.27 3,670.27 .00 610-90300-119-000 R&C: RETIREMENT (R) .00 .00 5,739.00 5,739.00 .00 610-90300-212-000 R&C: RENT .00 .00 16,500.00 16,500.00 .00 610-90300-216-000 R&C: POSTAGE .00 .00 12,000.00 12,000.00 .00 610-90300-286-000 R&C: SOFTWARE .00 .00 9,000.00 9,000.00 .00 610-90300-301-000 R&C: SUPPLIES .00 .00 1,000.00 1,000.00 .00 TOTAL RECORDS & COLLECTIONS .00 .00 99,432.69 99,432.69 .00 UNCOLLECTIBLE CUST ACCT 610-90410-299-000 UNC CUST ACCT: MISC .00 .00 15,000.00 15,000.00 .00 TOTAL UNCOLLECTIBLE CUST ACCT .00 .00 15,000.00 15,000.00 .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 610 - WATER UTILITY FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 12:46PM PAGE: 7 ADMINISTRATION & GENERAL 610-92000-102-000 ADM & GEN: WAGES .00 .00 89,927.01 89,927.01 .00 610-92000-118-000 ADM & GEN: SOCIAL SECURITY .00 .00 3,323.00 3,323.00 .00 610-92000-119-000 ADM & GEN: RETIREMENT (R) .00 .00 3,500.00 3,500.00 .00 610-92000-121-000 ADM & GEN: GRP HLTH INS .00 .00 6,839.00 6,839.00 .00 610-92000-122-000 ADM & GEN: LIFE INS .00 .00 66.00 66.00 .00 610-92000-123-000 ADM & GEN: INC PROTECT .00 .00 287.00 287.00 .00 610-92000-130-000 ADM & GEN: ADMIN. CHARGE WATER .00 .00 45,000.00 45,000.00 .00 610-92000-217-000 ADM & GEN: MEMBERSHIP AND DUES .00 .00 250.00 250.00 .00 610-92000-219-000 ADM & GEN: EXPENSES .00 .00 500.00 500.00 .00 610-92000-268-000 ADM & GEN: CAR EXPENSE .00 .00 600.00 600.00 .00 610-92000-299-000 ADM & GEN: MISCELLANEOUS .00 .00 750.00 750.00 .00 TOTAL ADMINISTRATION & GENERAL .00 .00 151,042.01 151,042.01 .00 OFFICE SUPPLIES & EXPENSE 610-92100-206-000 OFFICE S&E: TELEPHONE .00 .00 1,500.00 1,500.00 .00 610-92100-213-000 OFFICE S&E: PRINTING .00 .00 500.00 500.00 .00 610-92100-215-000 OFFICE S&E: ADVERTISING .00 .00 500.00 500.00 .00 610-92100-284-000 OFFICE S&E: MAINT .00 .00 350.00 350.00 .00 610-92100-302-000 OFFICE S&E: OFFICE SUPPLIES .00 .00 500.00 500.00 .00 TOTAL OFFICE SUPPLIES & EXPENSE .00 .00 3,350.00 3,350.00 .00 OUTSIDE SERVICES 610-92300-210-000 OSIDE SVCS: PROF SERVICES .00 .00 15,000.00 15,000.00 .00 TOTAL OUTSIDE SERVICES .00 .00 15,000.00 15,000.00 .00 PROPERTY INSURANCE 610-92400-209-000 PROP INS: INS &: INS & BOND .00 .00 10,000.00 10,000.00 .00 TOTAL PROPERTY INSURANCE .00 .00 10,000.00 10,000.00 .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 610 - WATER UTILITY FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 12:46PM PAGE: 8 FRINGE BENEFITS 610-92600-102-000 FRINGE: WAGES .00 .00 24,840.00 24,840.00 .00 610-92600-112-000 FRINGE: UNIFORMS .00 .00 1,500.00 1,500.00 .00 610-92600-118-000 FRINGE: SOCIAL SECURITY .00 .00 1,900.00 1,900.00 .00 610-92600-119-000 FRINGE: RETIREMENT (R) .00 .00 1,627.00 1,627.00 .00 610-92600-121-000 FRINGE: GRP HLTH INS .00 .00 29,146.00 29,146.00 .00 610-92600-123-000 FRINGE: INC PROTECT .00 .00 343.00 343.00 .00 610-92600-124-000 FRINGE: WORKERS COMPENSATION .00 .00 9,632.00 9,632.00 .00 610-92600-125-000 FRINGE: HEALTH INSURANCE DEDUC .00 .00 3,250.00 3,250.00 .00 610-92600-220-000 FRINGE: WELLNESS PROGRAM .00 .00 750.00 750.00 .00 TOTAL FRINGE BENEFITS .00 .00 72,988.00 72,988.00 .00 MISC GENERAL EXPENSE 610-93000-102-000 MISC GEN EXP: WAGES .00 .00 23,000.00 23,000.00 .00 610-93000-118-000 MISC GEN EXP: SOCIAL SECURITY .00 .00 1,760.00 1,760.00 .00 610-93000-119-000 MISC GEN EXP: RETIREMENT (R) .00 .00 1,507.00 1,507.00 .00 610-93000-202-000 MISC GEN EXP: TRAINING .00 .00 5,750.00 5,750.00 .00 610-93000-205-000 MISC GEN EXP: WATER SEWER .00 .00 3,700.00 3,700.00 .00 610-93000-299-000 MISC GEN EXP: MISCELLANEOUS .00 .00 500.00 500.00 .00 610-93000-301-000 MISC GEN EXP: SUPPLIES .00 .00 300.00 300.00 .00 TOTAL MISC GENERAL EXPENSE .00 .00 36,517.00 36,517.00 .00 TRANSPORTATION EXPENSE 610-93100-207-000 TRANSP EXP: MAINT OF EQUIP .00 .00 1,500.00 1,500.00 .00 610-93100-312-000 TRANSP EXP: GASOLINE .00 .00 7,000.00 7,000.00 .00 610-93100-313-000 TRANSP EXP: DIESEL FUEL .00 .00 1,000.00 1,000.00 .00 TOTAL TRANSPORTATION EXPENSE .00 .00 9,500.00 9,500.00 .00 WATER CAPITAL OUTLAY 610-93500-604-000 WTR C/O: HYDRANTS .00 .00 12,000.00 12,000.00 .00 610-93500-605-000 WTR C/O: TREATMENT AND DISTRIB .00 .00 150,000.00 150,000.00 .00 610-93500-614-000 WTR C/O: LEAK LOCATION STUDY .00 .00 10,000.00 10,000.00 .00 TOTAL WATER CAPITAL OUTLAY .00 .00 172,000.00 172,000.00 .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 610 - WATER UTILITY FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 12:46PM PAGE: 9 LONG TERM DEBT 610-94100-299-000 LTD: PRINCIPAL: MISCELLANEOUS .00 .00 500.00 500.00 .00 610-94100-404-000 LTD: PRINCIPAL: INTEREST .00 .00 60,035.00 60,035.00 .00 TOTAL LONG TERM DEBT .00 .00 60,535.00 60,535.00 .00 TOTAL FUND EXPENDITURES .00 .00 1,570,033.89 1,570,033.89 .00 NET REVENUES OVER EXPENDITURES .00 .00 ( 20,559.14) 20,559.14 .00 CITY OF WAUPACA REVENUES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 620 - SEWER FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 12:48PM PAGE: 1 INTERDEPARTMENTAL REVENUE 620-47010-000-000 CUSTOMER PENALTIES .00 .00 ( 4,000.00) 4,000.00 .00 TOTAL INTERDEPARTMENTAL REVENUE .00 .00 ( 4,000.00) 4,000.00 .00 MISCELLANEOUS REVENUE 620-48111-000-000 INTEREST .00 .00 ( 10,000.00) 10,000.00 .00 TOTAL MISCELLANEOUS REVENUE .00 .00 ( 10,000.00) 10,000.00 .00 SEWER SALES REVENUE 620-62101-000-000 SEWER CHARGES: RESIDENTIAL .00 .00 ( 920,000.00) 920,000.00 .00 620-62102-000-000 SEWER CHARGES:MULTIFAMILY .00 .00 ( 112,800.00) 112,800.00 .00 620-62201-000-000 SEWER CHARGES: COMMERCIAL .00 .00 ( 363,000.00) 363,000.00 .00 620-62301-000-000 SEWER CHARGE: PUBLIC .00 .00 ( 85,500.00) 85,500.00 .00 620-62302-000-000 CHAIN: OTHER MUM. REV. .00 .00 ( 155,500.00) 155,500.00 .00 620-62401-000-000 SEWER: INDUSTRIAL .00 .00 ( 380,000.00) 380,000.00 .00 TOTAL SEWER SALES REVENUE .00 .00 ( 2,016,800.00) 2,016,800.00 .00 MISC CUSTOMER REVENUE 620-63301-000-000 MISC CUSTOMER RE .00 .00 ( 64,000.00) 64,000.00 .00 TOTAL MISC CUSTOMER REVENUE .00 .00 ( 64,000.00) 64,000.00 .00 TOTAL FUND REVENUE .00 .00 ( 2,094,800.00) 2,094,800.00 .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 620 - SEWER FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 12:48PM PAGE: 2 DEPRECIATION EXPENSE 620-50310-299-000 DEPRECIATION .00 .00 705,000.00 705,000.00 .00 TOTAL DEPRECIATION EXPENSE .00 .00 705,000.00 705,000.00 .00 TAX EXPENSE 620-50810-299-000 TAXES .00 .00 250,000.00 250,000.00 .00 TOTAL TAX EXPENSE .00 .00 250,000.00 250,000.00 .00 OPERATION PLANT 620-82110-102-000 OP PLANT: WAGES .00 .00 40,069.00 40,069.00 .00 620-82110-105-000 OP PLANT: CALL-IN PAY .00 .00 500.00 500.00 .00 620-82110-118-000 OP PLANT: SOCIAL SECURITY .00 .00 3,065.00 3,065.00 .00 620-82110-119-000 OP PLANT: RETIREMENT (R) .00 .00 2,725.00 2,725.00 .00 620-82110-121-000 OP PLANT: GRP HLTH INS .00 .00 6,065.00 6,065.00 .00 620-82110-122-000 OP PLANT: LIFE INS .00 .00 76.00 76.00 .00 620-82110-123-000 OP PLANT: INC PROTECT .00 .00 198.00 198.00 .00 620-82110-203-000 OP PLANT: HEAT .00 .00 2,500.00 2,500.00 .00 620-82110-204-000 OP PLANT: ELECTRICITY .00 .00 60,000.00 60,000.00 .00 620-82110-205-000 OP PLANT: WATER SEWER .00 .00 5,500.00 5,500.00 .00 620-82110-207-000 OP PLANT: MAINT OF EQUIP .00 .00 1,500.00 1,500.00 .00 620-82110-210-000 OP PLANT: PROF SERVICES .00 .00 12,000.00 12,000.00 .00 620-82110-301-000 OP PLANT: SUPPLIES .00 .00 3,000.00 3,000.00 .00 620-82110-307-000 OP PLANT: CHEMICALS .00 .00 25,000.00 25,000.00 .00 TOTAL OPERATION PLANT .00 .00 162,198.00 162,198.00 .00 PROCESS CONTROL 620-82120-102-000 PROC CNTL: WAGES .00 .00 54,207.00 54,207.00 .00 620-82120-118-000 PROC CNTL: SOCIAL SECURITY .00 .00 4,147.00 4,147.00 .00 620-82120-119-000 PROC CNTL: RETIREMENT (R) .00 .00 3,551.00 3,551.00 .00 620-82120-121-000 PROC CNTL: GRP HLTH INS .00 .00 8,205.00 8,205.00 .00 620-82120-122-000 PROC CNTL: LIFE INS .00 .00 102.00 102.00 .00 620-82120-123-000 PROC CNTL: INC PROTECT .00 .00 267.00 267.00 .00 620-82120-207-000 PROC CNTL: MAINT OF EQUIP .00 .00 3,000.00 3,000.00 .00 620-82120-210-000 PROC CNTL: PROF SERVICES .00 .00 6,000.00 6,000.00 .00 620-82120-301-000 PROC CNTL: SUPPLIES .00 .00 2,000.00 2,000.00 .00 620-82120-307-000 PROC CNTL: CHEMICALS .00 .00 1,500.00 1,500.00 .00 TOTAL PROCESS CONTROL .00 .00 82,979.00 82,979.00 .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 620 - SEWER FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 12:48PM PAGE: 3 SLUDGE DISPOSAL 620-82130-207-000 SLUDGE DIS: MAINT OF EQUIP .00 .00 250.00 250.00 .00 620-82130-210-000 SLUDGE DIS: PROF SERVICES .00 .00 63,000.00 63,000.00 .00 TOTAL SLUDGE DISPOSAL .00 .00 63,250.00 63,250.00 .00 COLLECTION SYSTEM 620-82210-207-000 COLL SYS: MAINT OF EQUIP .00 .00 6,500.00 6,500.00 .00 TOTAL COLLECTION SYSTEM .00 .00 6,500.00 6,500.00 .00 LIFT STATION 620-82220-203-000 LIFT STN: HEAT .00 .00 2,200.00 2,200.00 .00 620-82220-204-000 LIFT STN: ELECTRICITY .00 .00 25,000.00 25,000.00 .00 620-82220-205-000 LIFT STN: WATER SEWER .00 .00 830.00 830.00 .00 620-82220-301-000 LIFT STN: SUPPLIES .00 .00 150.00 150.00 .00 TOTAL LIFT STATION .00 .00 28,180.00 28,180.00 .00 TRANSPORTATION EQUIPMENT 620-82310-207-000 TRANSP EQU: MAINT OF EQUIP .00 .00 1,500.00 1,500.00 .00 620-82310-312-000 TRANSP EQU: GASOLINE .00 .00 3,500.00 3,500.00 .00 620-82310-313-000 TRANSP EQU: DIESEL FUEL .00 .00 3,000.00 3,000.00 .00 TOTAL TRANSPORTATION EQUIPMENT .00 .00 8,000.00 8,000.00 .00 MAINT OF BUILDINGS & GROUNDS 620-82410-102-000 BLDG & GRND: WAGES .00 .00 6,625.00 6,625.00 .00 620-82410-104-000 BLDG & GRND: PART-TIME HOURS .00 .00 750.00 750.00 .00 620-82410-118-000 BLDG & GRND: SOCIAL SECURITY .00 .00 473.00 473.00 .00 620-82410-119-000 BLDG & GRND: RETIREMENT (R) .00 .00 417.00 417.00 .00 620-82410-121-000 BLDG & GRND: GRP HLTH INS .00 .00 678.00 678.00 .00 620-82410-122-000 BLDG & GRND: LIFE INS .00 .00 19.00 19.00 .00 620-82410-123-000 BLDG & GRND: INC PROTECT .00 .00 39.00 39.00 .00 620-82410-208-000 BLDG & GRND: MAINT OF FACILITI .00 .00 5,000.00 5,000.00 .00 620-82410-301-000 BLDG & GRND: SUPPLIES .00 .00 2,500.00 2,500.00 .00 TOTAL MAINT OF BUILDINGS & GROUNDS .00 .00 16,501.00 16,501.00 .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 620 - SEWER FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 12:49PM PAGE: 4 MAINT OF PLANT EQUIPMENT 620-82510-102-000 MAINT PL EQU: WAGES .00 .00 69,723.00 69,723.00 .00 620-82510-118-000 MAINT PL EQU: SOCIAL SECURITY .00 .00 4,898.00 4,898.00 .00 620-82510-119-000 MAINT PL EQU: RETIREMENT (R) .00 .00 4,741.00 4,741.00 .00 620-82510-121-000 MAINT PL EQU: GRP HLTH INS .00 .00 13,662.00 13,662.00 .00 620-82510-122-000 MAINT PL EQU: LIFE INS .00 .00 108.00 108.00 .00 620-82510-123-000 MAINT PL EQU: INC PROTECT .00 .00 344.00 344.00 .00 620-82510-207-000 MAINT PL EQU: MAINT OF EQUIP .00 .00 15,000.00 15,000.00 .00 620-82510-298-000 MAINT PL EQU: HAND TOOLS .00 .00 1,000.00 1,000.00 .00 620-82510-301-000 MAINT PL EQU: SUPPLIES .00 .00 8,000.00 8,000.00 .00 TOTAL MAINT OF PLANT EQUIPMENT .00 .00 117,476.00 117,476.00 .00 MAINT OF COLLECTION SYSTEM 620-82610-102-000 MAINT COLL SYS: WAGES .00 .00 28,660.00 28,660.00 .00 620-82610-103-000 MAINT COLL SYS: OVERTIME .00 .00 500.00 500.00 .00 620-82610-105-000 MAINT COLL SYS: CALL-IN PAY .00 .00 500.00 500.00 .00 620-82610-118-000 MAINT COLL SYS: SOCIAL SECURIT .00 .00 2,269.00 2,269.00 .00 620-82610-119-000 MAINT COLL SYS: RETIREMENT (R) .00 .00 2,017.00 2,017.00 .00 620-82610-121-000 MAINT COLL SYS: GRP HLTH INS .00 .00 5,616.00 5,616.00 .00 620-82610-122-000 MAINT COLL SYS: LIFE INS .00 .00 44.00 44.00 .00 620-82610-123-000 MAINT COLL SYS: INC PROTECT .00 .00 141.00 141.00 .00 620-82610-207-000 MAINT COLL SYS: MAINT OF EQUIP .00 .00 1,300.00 1,300.00 .00 620-82610-208-000 MAINT COLL SYS: MAINT OF FACIL .00 .00 5,000.00 5,000.00 .00 620-82610-210-000 MAINT COLL SYS: PROF SERVICES .00 .00 25,000.00 25,000.00 .00 620-82610-301-000 MAINT COLL SYS: SUPPLIES .00 .00 4,500.00 4,500.00 .00 TOTAL MAINT OF COLLECTION SYSTEM .00 .00 75,547.00 75,547.00 .00 MAINT OF LIFT STATIONS 620-82620-102-000 MAINT LIFT: WAGES .00 .00 18,300.00 18,300.00 .00 620-82620-118-000 MAINT LIFT: SOCIAL SECURITY .00 .00 1,400.00 1,400.00 .00 620-82620-119-000 MAINT LIFT: RETIREMENT (R) .00 .00 1,189.00 1,189.00 .00 620-82620-121-000 MAINT LIFT: GRP HLTH INS .00 .00 3,586.00 3,586.00 .00 620-82620-122-000 MAINT LIFT: LIFE INS .00 .00 28.00 28.00 .00 620-82620-123-000 MAINT LIFT: INC PROTECT .00 .00 90.00 90.00 .00 620-82620-207-000 MAINT LIFT: MAINT OF EQUIP .00 .00 15,000.00 15,000.00 .00 620-82620-208-000 MAINT LIFT: MAINT OF FACILITIE .00 .00 5,000.00 5,000.00 .00 620-82620-304-000 MAINT LIFT: PARTS .00 .00 2,000.00 2,000.00 .00 TOTAL MAINT OF LIFT STATIONS .00 .00 46,593.00 46,593.00 .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 620 - SEWER FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 12:49PM PAGE: 5 MAINT OF METERS 620-82630-102-000 MAINT MTRS: WAGES .00 .00 17,440.00 17,440.00 .00 620-82630-118-000 MAINT MTRS: SOCIAL SECURITY .00 .00 1,334.00 1,334.00 .00 620-82630-119-000 MAINT MTRS: RETIREMENT (R) .00 .00 1,142.00 1,142.00 .00 620-82630-121-000 MAINT MTRS: GRP HLTH INS .00 .00 3,500.00 3,500.00 .00 620-82630-122-000 MAINT MTRS: LIFE INS .00 .00 100.00 100.00 .00 620-82630-123-000 MAINT MTRS: INC PROTECT .00 .00 150.00 150.00 .00 620-82630-207-000 MAINT MTRS: MAINT OF EQUIP .00 .00 5,000.00 5,000.00 .00 TOTAL MAINT OF METERS .00 .00 28,666.00 28,666.00 .00 ACCOUNTING & COLLECTION 620-82710-102-000 ACTG & COLL: WAGES .00 .00 37,800.00 37,800.00 .00 620-82710-118-000 ACTG & COLL: SOCIAL SECURITY .00 .00 2,892.00 2,892.00 .00 620-82710-119-000 ACTG & COLL: RETIREMENT (R) .00 .00 2,570.00 2,570.00 .00 620-82710-121-000 ACTG & COLL: GRP HLTH INS .00 .00 7,154.00 7,154.00 .00 620-82710-122-000 ACTG & COLL: LIFE INS .00 .00 385.00 385.00 .00 620-82710-123-000 ACTG & COLL: INC PROTECT .00 .00 250.00 250.00 .00 620-82710-212-000 ACTG & COLL: RENT & LEASES .00 .00 16,500.00 16,500.00 .00 620-82710-216-000 ACTG & COLL: POSTAGE .00 .00 15,000.00 15,000.00 .00 620-82710-286-000 ACTG & COLL: SOFTWARE .00 .00 11,000.00 11,000.00 .00 620-82710-301-000 ACTG & COLL: SUPPLIES .00 .00 2,500.00 2,500.00 .00 TOTAL ACCOUNTING & COLLECTION .00 .00 96,051.00 96,051.00 .00 METER READING 620-82720-102-000 MTR RDG: WAGES .00 .00 4,000.00 4,000.00 .00 620-82720-118-000 MTR RDG: SOCIAL SECURITY .00 .00 306.00 306.00 .00 620-82720-119-000 MTR RDG: RETIREMENT (R) .00 .00 21.00 21.00 .00 620-82720-121-000 MTR RDG: GRP HLTH INS .00 .00 500.00 500.00 .00 620-82720-122-000 MTR RDG: LIFE INS .00 .00 10.00 10.00 .00 620-82720-123-000 MTR RDG: INC PROTECT .00 .00 30.00 30.00 .00 TOTAL METER READING .00 .00 4,867.00 4,867.00 .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 620 - SEWER FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 12:49PM PAGE: 6 GEN SUPERVISION & ENGINEERING 620-82910-102-000 GEN SUP & ENG: WAGES .00 .00 49,460.00 49,460.00 .00 620-82910-118-000 GEN SUP & ENG: SOCIAL SECURITY .00 .00 3,784.00 3,784.00 .00 620-82910-119-000 GEN SUP & ENG: RETIREMENT (R) .00 .00 3,363.00 3,363.00 .00 620-82910-121-000 GEN SUP & ENG: GRP HLTH INS .00 .00 3,000.00 3,000.00 .00 620-82910-122-000 GEN SUP & ENG: LIFE INS .00 .00 188.00 188.00 .00 620-82910-123-000 GEN SUP & ENG: INC PROTECT .00 .00 668.00 668.00 .00 620-82910-268-000 CAR EXPENSE .00 .00 810.00 810.00 .00 620-82910-299-000 GEN SUP & ENG: MISCELLANEOUS .00 .00 750.00 750.00 .00 TOTAL GEN SUPERVISION & ENGINEERING .00 .00 62,023.00 62,023.00 .00 OTHER GENERAL EXPENSE 620-83210-102-000 OTHER GEN EXP: WAGES .00 .00 5,100.00 5,100.00 .00 620-83210-118-000 OTHER GEN EXP: SOCIAL SECURITY .00 .00 390.00 390.00 .00 620-83210-119-000 OTHER GEN EXP: RETIREMENT (R) .00 .00 334.00 334.00 .00 620-83210-121-000 OTHER GEN EXP: GRP HLTH INS .00 .00 900.00 900.00 .00 620-83210-122-000 OTHER GEN EXP: LIFE INS .00 .00 10.00 10.00 .00 620-83210-123-000 OTHER GEN EXP: INC PROTECT .00 .00 30.00 30.00 .00 620-83210-202-000 OTHER GEN EXP: TRAINING .00 .00 4,500.00 4,500.00 .00 620-83210-206-000 OTHER GEN EXP: PHONE .00 .00 750.00 750.00 .00 620-83210-207-000 OTHER GEN EXP: MNT EQUIP .00 .00 400.00 400.00 .00 620-83210-210-000 OTHER GEN EXP: PROF SERVICES .00 .00 15,000.00 15,000.00 .00 620-83210-214-000 OTHER GEN EXP: REPRODUCTION .00 .00 250.00 250.00 .00 620-83210-215-000 OTHER GEN EXP: ADVERTISING .00 .00 100.00 100.00 .00 620-83210-217-000 OTHER GEN EXP: MEMBERSHIP AND .00 .00 750.00 750.00 .00 620-83210-301-000 OTHER GEN EXP: SUPPLIES .00 .00 850.00 850.00 .00 TOTAL OTHER GENERAL EXPENSE .00 .00 29,364.00 29,364.00 .00 PROPERTY & LIABILITY 620-83220-209-000 PROP & LIAB: INS & BOND .00 .00 34,960.00 34,960.00 .00 TOTAL PROPERTY & LIABILITY .00 .00 34,960.00 34,960.00 .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 620 - SEWER FUND PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 12:49PM PAGE: 7 FRINGE BENEFITS 620-83310-102-000 FRINGE: WAGES .00 .00 22,230.00 22,230.00 .00 620-83310-112-000 FRINGE: UNIFORMS .00 .00 2,500.00 2,500.00 .00 620-83310-118-000 FRINGE: SOCIAL SECURITY .00 .00 1,701.00 1,701.00 .00 620-83310-119-000 FRINGE: RETIREMENT (R) .00 .00 1,512.00 1,512.00 .00 620-83310-121-000 FRINGE: GRP HLTH INS .00 .00 3,365.00 3,365.00 .00 620-83310-122-000 FRINGE: LIFE INS .00 .00 34.00 34.00 .00 620-83310-123-000 FRINGE: INC PROTECT .00 .00 110.00 110.00 .00 620-83310-124-000 FRINGE: WORKERS COMPENSATION .00 .00 11,062.00 11,062.00 .00 620-83310-125-000 FRINGE: HEALTH INSURANCE DEDUC .00 .00 3,750.00 3,750.00 .00 620-83310-220-000 FRINGE: WELLNESS PROG .00 .00 628.00 628.00 .00 TOTAL FRINGE BENEFITS .00 .00 46,892.00 46,892.00 .00 UNCOLLECTIBLE CUSTOMER ACCT 620-90410-299-000 UNC CUST ACCT: MISC .00 .00 500.00 500.00 .00 TOTAL UNCOLLECTIBLE CUSTOMER ACCT .00 .00 500.00 500.00 .00 LONG TERM DEBT 620-94100-404-000 LTD: PRINCIPAL: INTEREST .00 .00 74,902.00 74,902.00 .00 TOTAL LONG TERM DEBT .00 .00 74,902.00 74,902.00 .00 DEBT SERVICE COSTS 620-94200-294-000 DS COSTS: PAYING AGENT FEES .00 .00 500.00 500.00 .00 TOTAL DEBT SERVICE COSTS .00 .00 500.00 500.00 .00 SEWER CAPITAL OUTLAY 620-95000-604-000 SEWER C/O: PROCESS CONTROL/PUM .00 .00 80,000.00 80,000.00 .00 620-95000-606-000 SEWER C/O: TRANSPORTATION EQUI .00 .00 60,000.00 60,000.00 .00 620-95000-608-000 SEWER C/O: PUMPING/LIFT STATIO .00 .00 200,000.00 200,000.00 .00 620-95000-609-000 SEWER C/O: REPLACEMT FUND CONT .00 .00 85,500.00 85,500.00 .00 620-95000-610-000 SEWER C/O: MAINT PROJ CONTRIB .00 .00 146,000.00 146,000.00 .00 TOTAL SEWER CAPITAL OUTLAY .00 .00 571,500.00 571,500.00 .00 TOTAL FUND EXPENDITURES .00 .00 2,512,449.00 2,512,449.00 .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 620 - SEWER FUND PERIOD BUDGET % OF PERIOD YTD ACTUAL AMOUNT BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 12:49PM PAGE: 8 NET REVENUES OVER EXPENDITURES .00 .00 ( 4,607,249.00) 4,607,249.00 .00 CITY OF WAUPACA REVENUES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 650 - COMMUNICATIONS UTILITY PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 12:50PM PAGE: 1 COMMUNICATIONS - WAUPACA 650-41020-000-000 SUBSCRIBER - RESIDENTIAL .00 .00 265,000.00 ( 265,000.00) .00 650-41025-000-000 TOWER RENT/SBA GROUND LEASE .00 .00 2,952.00 ( 2,952.00) .00 650-41031-000-000 PENALTY .00 .00 600.00 ( 600.00) .00 650-41040-000-000 INSTALL .00 .00 6,000.00 ( 6,000.00) .00 650-41043-000-000 MISC. PARTS .00 .00 4,000.00 ( 4,000.00) .00 TOTAL COMMUNICATIONS - WAUPACA .00 .00 278,552.00 ( 278,552.00) .00 TOTAL FUND REVENUE .00 .00 278,552.00 ( 278,552.00) .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 650 - COMMUNICATIONS UTILITY PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 12:50PM PAGE: 2 TELECOMM. 650-51120-280-000 TELECOMM.-CHARTER .00 .00 32,800.00 32,800.00 .00 TOTAL TELECOMM. .00 .00 32,800.00 32,800.00 .00 END POINT INSTALL 650-51600-104-000 END POINT: PARTTIME .00 .00 60,000.00 60,000.00 .00 650-51600-118-000 END POINT: SOCIAL SECURITY .00 .00 3,762.00 3,762.00 .00 650-51600-119-000 END POINT: RETIREMENT (R) .00 .00 1,677.00 1,677.00 .00 650-51600-121-000 END POINT: GROUP HEALTH .00 .00 2,470.00 2,470.00 .00 650-51600-122-000 END POINT: LIFE INS. .00 .00 30.00 30.00 .00 650-51600-123-000 END POINT: INCOME PROT .00 .00 60.00 60.00 .00 650-51600-124-000 END POINT: WORK COMP .00 .00 1,000.00 1,000.00 .00 650-51600-299-000 END POINT: DEPRECIATION EXP .00 .00 500.00 500.00 .00 650-51600-312-000 END POINT: GASOLINE .00 .00 3,800.00 3,800.00 .00 TOTAL END POINT INSTALL .00 .00 73,299.00 73,299.00 .00 CUSTOMER ACCOUNTS 650-90410-299-000 UNCOLLECTABLE ACCTS .00 .00 250.00 250.00 .00 TOTAL CUSTOMER ACCOUNTS .00 .00 250.00 250.00 .00 SALES EXPENSES 650-91300-215-000 SALES EXP: ADVERTISING .00 .00 1,000.00 1,000.00 .00 TOTAL SALES EXPENSES .00 .00 1,000.00 1,000.00 .00 ADMINISTRATION 650-92000-102-000 ADMIN - WAGES .00 .00 25,797.00 25,797.00 .00 650-92000-118-000 ADMIN - SOCIAL SECURITY .00 .00 1,973.00 1,973.00 .00 650-92000-119-000 ADMIN - RETIREMENT (R) .00 .00 1,677.00 1,677.00 .00 650-92000-121-000 ADMIN - GROUP HEALTH INS. .00 .00 2,470.00 2,470.00 .00 650-92000-122-000 ADMIN - LIFE INS. .00 .00 30.00 30.00 .00 650-92000-123-000 ADMIN - INCOME PROTECTION .00 .00 60.00 60.00 .00 TOTAL ADMINISTRATION .00 .00 32,007.00 32,007.00 .00 CITY OF WAUPACA EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JANUARY 01, 2023 FUND 650 - COMMUNICATIONS UTILITY PERIOD BUDGET % OF ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET FOR ADMINISTRATION USE ONLY 0 % OF THE FISCAL YEAR HAS ELAPSED 05/26/2023 12:50PM PAGE: 3 OFFICE EXPENSE 650-92100-206-000 OFFICE: TELEPHONE .00 .00 600.00 600.00 .00 650-92100-210-000 OFFICE: PROF SERVICES .00 .00 750.00 750.00 .00 650-92100-216-000 OFFICE: POSTAGE .00 .00 3,250.00 3,250.00 .00 650-92100-286-000 OFFICE: SOFTWARE .00 .00 3,145.00 3,145.00 .00 650-92100-301-000 OFFICE: BILLING SUPPLIES .00 .00 150.00 150.00 .00 TOTAL OFFICE EXPENSE .00 .00 7,895.00 7,895.00 .00 OUTSIDE SERVICES 650-92300-204-000 OUTSIDE SERVICE: ELECTRICITY .00 .00 3,600.00 3,600.00 .00 650-92300-210-000 OUTSIDE SERVICE: PROF SERVICES .00 .00 51,335.00 51,335.00 .00 650-92300-212-000 OUTSIDE SERVICES: RENTS/LEASES .00 .00 5,815.00 5,815.00 .00 TOTAL OUTSIDE SERVICES .00 .00 60,750.00 60,750.00 .00 INSURANCE 650-92400-209-000 INSURANCE : INSURANCE .00 .00 1,200.00 1,200.00 .00 TOTAL INSURANCE .00 .00 1,200.00 1,200.00 .00 ONLINE CAPITAL OUTLAY 650-93500-610-000 ONLINE: MISCELLANEOUS EQUIP .00 .00 40,000.00 40,000.00 .00 TOTAL ONLINE CAPITAL OUTLAY .00 .00 40,000.00 40,000.00 .00 TOTAL FUND EXPENDITURES .00 .00 249,201.00 249,201.00 .00 NET REVENUES OVER EXPENDITURES .00 .00 29,351.00 ( 29,351.00) .00