Loading...
Revenue - Enterprise Funds - Second Quarter 01/16/2018 11:10 |City of Northampton |P 1 1281swri |REVENUE |glytdbud ENTERPRISE FUNDS FOR 2018 06 ORIGINAL ESTIM REV REVISED ACTUAL YTD REMAINING PCT ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL____________________________________________________________________________________________________________________________________ 6000 SEWER ENTERPRISE _________________________________________ 60004 SEWER REVENUE _________________________________________ 414200 TAX TITLE REVENUE 0 0 0 -5,707.50 5,707.50 100.0% 417030 INTEREST ON TAX TITLES 0 0 0 -1,038.42 1,038.42 100.0% 424040 SEWER RATES -6,030,000 0 -6,030,000 -3,073,777.67 -2,956,222.33 51.0% 424041 SEWER LIENS -200,000 0 -200,000 -26,621.60 -173,378.40 13.3% 424042 INTEREST EARNED -40,000 0 -40,000 -14,608.14 -25,391.86 36.5% 424043 SEWER MISC. INCOME 0 0 0 -10,275.00 10,275.00 100.0% 424046 SEWER INTEREST INCOME 0 0 0 -20,631.93 20,631.93 100.0% 437027 DEPT REV - DPW BID DOCUMENTS 0 0 0 -150.00 150.00 100.0% TOTAL SEWER REVENUE -6,270,000 0 -6,270,000 -3,152,810.26 -3,117,189.74 50.3% TOTAL SEWER ENTERPRISE -6,270,000 0 -6,270,000 -3,152,810.26 -3,117,189.74 50.3% 6100 WATER ENTERPRISE _________________________________________ 61004 WATER REVENUE _________________________________________ 414200 TAX TITLE REVENUE 0 0 0 -6,001.92 6,001.92 100.0% 417030 INTEREST ON TAX TITLES 0 0 0 -1,009.57 1,009.57 100.0% 422040 WATER RATES -6,030,000 0 -6,030,000 -2,996,216.68 -3,033,783.32 49.7% 422041 WATER LIENS -100,000 0 -100,000 -27,376.54 -72,623.46 27.4% 422042 WATER INTEREST EARNED -60,000 0 -60,000 -13,878.11 -46,121.89 23.1% 422043 WATER MISC. INCOME 0 0 0 -22,365.00 22,365.00 100.0% 422044 WATER METER FEES -600,000 0 -600,000 -307,126.47 -292,873.53 51.2% 422045 WATER CROSS CONNECTION -40,000 0 -40,000 -26,671.01 -13,328.99 66.7% 422046 WATER INTEREST INCOME 0 0 0 -20,263.36 20,263.36 100.0% 424035 SALE OF SCRAP METAL 0 0 0 -2,076.45 2,076.45 100.0% 481001 SALE OF LUMBER 0 0 0 -4,655.00 4,655.00 100.0% TOTAL WATER REVENUE -6,830,000 0 -6,830,000 -3,427,640.11 -3,402,359.89 50.2% TOTAL WATER ENTERPRISE -6,830,000 0 -6,830,000 -3,427,640.11 -3,402,359.89 50.2% 6200 STORMWATER ENTERPRISE _________________________________________ 62004 STORMWATER REVENUE _________________________________________ 01/16/2018 11:10 |City of Northampton |P 2 1281swri |REVENUE |glytdbud ENTERPRISE FUNDS FOR 2018 06 ORIGINAL ESTIM REV REVISED ACTUAL YTD REMAINING PCT ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL____________________________________________________________________________________________________________________________________ 414200 TAX TITLE REVENUE 0 0 0 -855.48 855.48 100.0% 417030 INTEREST ON TAX TITLES 0 0 0 -141.01 141.01 100.0% 423040 STORMWATER RATES -1,957,558 0 -1,957,558 -973,798.30 -983,759.70 49.7% 423041 STORMWATER LIENS 0 0 0 -11,527.24 11,527.24 100.0% 423042 STORMWATER INTEREST EARNED 0 0 0 -5,551.89 5,551.89 100.0% 423043 STORMWATER MISC. INCOME 0 0 0 -13,948.00 13,948.00 100.0% 423046 STORMWATER INTEREST INCOME 0 0 0 -6,069.48 6,069.48 100.0% TOTAL STORMWATER REVENUE -1,957,558 0 -1,957,558 -1,011,891.40 -945,666.60 51.7% TOTAL STORMWATER ENTERPRISE -1,957,558 0 -1,957,558 -1,011,891.40 -945,666.60 51.7% 6400 SOLID WASTE ENTERPRISE _________________________________________ 64004 SOLID WASTE ENTERPRISE _________________________________________ 424031 REFUSE FEES 0 0 0 -562.00 562.00 100.0% 424032 LANDFILL STICKERS -90,000 0 -90,000 -63,338.00 -26,662.00 70.4% 424033 RECYCLING PROGRAM REVENUES -10,000 0 -10,000 -8,369.02 -1,630.98 83.7% 424035 SALE OF SCRAP METAL -10,000 0 -10,000 -4,822.11 -5,177.89 48.2% 424036 COMPOST MEMBERSHIP -4,000 0 -4,000 -2,342.60 -1,657.40 58.6% 424037 TRASH BAG SALES -227,500 0 -227,500 -98,951.13 -128,548.87 43.5% 424038 TRASH BIN SALES 0 0 0 -2,997.00 2,997.00 100.0% 424042 INTEREST EARNED 0 0 0 -3,268.78 3,268.78 100.0% 424045 GAS REVENUE -30,000 0 -30,000 -730.15 -29,269.85 2.4% 436012 LEASES - LANDFILL CELL TOWER -90,000 0 -90,000 -45,151.11 -44,848.89 50.2% 484000 MISCELLANEOUS RECEIPTS -10,000 0 -10,000 .00 -10,000.00 .0% TOTAL SOLID WASTE ENTERPRISE -471,500 0 -471,500 -230,531.90 -240,968.10 48.9% TOTAL SOLID WASTE ENTERPRISE -471,500 0 -471,500 -230,531.90 -240,968.10 48.9% GRAND TOTAL -15,529,058 0 -15,529,058 -7,822,873.67 -7,706,184.33 50.4% ** END OF REPORT - Generated by Susan Wright ** 01/16/2018 11:10 |City of Northampton |P 3 1281swri |REVENUE |glytdbud ENTERPRISE FUNDS REPORT OPTIONS ____________________________________________________________________________________________________________________________________ Field # Total Page Break Sequence 1 1 Y N Sequence 2 9 Y N Sequence 3 11 Y N Sequence 4 0 N N Report title: REVENUE Includes accounts exceeding 0% of budget. Print totals only: Y Year/Period: 2018/ 6 Print Full or Short description: F Print MTD Version: N Print full GL account: N Format type: 1 Roll projects to object: N Double space: N Carry forward code: 1 Suppress zero bal accts: Y Include requisition amount: N Print Revenues-Version headings: Y Print revenue as credit: Y Print revenue budgets as zero: N Include Fund Balance: N Print journal detail: N From Yr/Per: 2016/ 9 To Yr/Per: 2016/ 9 Include budget entries: Y Incl encumb/liq entries: Y Sort by JE # or PO #: J Detail format option: 1 Include additional JE comments: N Multiyear view: D Amounts/totals exceed 999 million dollars: N Find Criteria Field Name Field Value Fund 6* FUNCTION DEPARTMENT DOE BUDGET CAT LOCATION CURR/GRANT GRADE Character Code Org Object Project Account type Revenue 01/16/2018 11:10 |City of Northampton |P 4 1281swri |REVENUE |glytdbud ENTERPRISE FUNDS REPORT OPTIONS ____________________________________________________________________________________________________________________________________ Account status Rollup Code