Loading...
HomeMy Public PortalAbout2 November 2016 - JFF Financial StatementsTOWN OF FRASER - JOINT FACILITIES BALANCE SHEET NOVEMBER 30, 2016 JOINT FACILITIES FUND ASSETS 40-10100 CASH ALLOCATED TO OTHER FUNDS 12,357.58 40-10210 JFOC CHECKING-GMB 0318047507 92,697.61 40-10215 GMB MONEY MARKET-O&M RESERVE 31,075.42 40-11550 A/R - WPR 18,549.59 40-11560 A/R - GC#1 28,919.32 40-11570 A/R - TOF 16,939.38 TOTAL ASSETS 200,538.90 LIABILITIES AND EQUITY LIABILITIES 40-20920 JFOC O&M RESERVE 198,389.89 TOTAL LIABILITIES 198,389.89 FUND EQUITY UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 2,149.01 BALANCE - CURRENT DATE 2,149.01 TOTAL FUND EQUITY 2,149.01 TOTAL LIABILITIES AND EQUITY 200,538.90 TOWN OF FRASER - JOINT FACILITIES REVENUES WITH COMPARISON TO BUDGET FOR THE 11 MONTHS ENDING NOVEMBER 30, 2016 JOINT FACILITIES FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT REVENUE 40-30-100 INTEREST - O&M ACCOUNTS 32.63 327.51 300.00 ( 27.51)109.2 40-30-200 O&M REIMBURSEMENT - WPR 18,549.59 148,979.62 209,803.00 60,823.38 71.0 40-30-210 O&M REIMBURSEMENT - GC#1 28,919.32 244,198.87 330,313.00 86,114.13 73.9 40-30-220 O&M REIMBURSEMENT - TOF 16,939.38 150,405.55 185,846.00 35,440.45 80.9 40-30-900 MISCELLANEOUS REVENUE .00 1,821.50 1,500.00 ( 321.50)121.4 40-30-999 CARRYOVER BALANCE .00 .00 200,674.00 200,674.00 .0 TOTAL REVENUE 64,440.92 545,733.05 928,436.00 382,702.95 58.8 TOTAL FUND REVENUE 64,440.92 545,733.05 928,436.00 382,702.95 58.8 TOWN OF FRASER - JOINT FACILITIES EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 11 MONTHS ENDING NOVEMBER 30, 2016 JOINT FACILITIES FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT PLANT EXPENDITURES 40-85-110 SALARIES 14,148.74 165,440.71 175,000.00 9,559.29 94.5 40-85-210 HEALTH INSURANCE 3,493.90 37,009.10 37,000.00 ( 9.10)100.0 40-85-220 FICA TAX 972.89 11,401.93 13,388.00 1,986.07 85.2 40-85-230 RETIREMENT 425.14 4,701.29 7,000.00 2,298.71 67.2 40-85-250 UNEMPLOYMENT TAX 42.57 497.71 525.00 27.29 94.8 40-85-280 TRAINING PROGRAMS .00 1,435.00 2,000.00 565.00 71.8 40-85-290 TRAVEL - MEALS AND LODGING .00 574.88 2,500.00 1,925.12 23.0 40-85-295 MEALS - LOCAL BUSINESS .00 255.71 100.00 ( 155.71)255.7 40-85-310 LEGAL FEES .00 .00 5,000.00 5,000.00 .0 40-85-320 AUDIT FEE .00 4,200.00 4,750.00 550.00 88.4 40-85-330 ENGINEERING FEES .00 3,045.00 15,000.00 11,955.00 20.3 40-85-350 SLUDGE REMOVAL 2,797.44 36,673.99 55,000.00 18,326.01 66.7 40-85-370 PROFESSIONAL SERVICES 621.28 3,300.88 10,000.00 6,699.12 33.0 40-85-430 INSURANCE - PLANT 19,258.00 24,166.85 30,000.00 5,833.15 80.6 40-85-440 ADVERTISING .00 .00 500.00 500.00 .0 40-85-460 PLANT MAINTENANCE AND REPAIR 787.50 20,248.34 50,000.00 29,751.66 40.5 40-85-475 GROUNDS MAINTENANCE .00 .00 1,500.00 1,500.00 .0 40-85-480 EQUIPMENT RENTAL .00 .00 500.00 500.00 .0 40-85-490 PROFESSIONAL MEMBERSHIPS 60.00 450.00 500.00 50.00 90.0 40-85-500 OPERATING SUPPLIES 185.03 4,283.24 15,000.00 10,716.76 28.6 40-85-506 OPERATING SUPPLIES - CHEMICALS 1,523.48 24,330.96 50,000.00 25,669.04 48.7 40-85-510 EQUIPMENT PURCHASE AND REPAIR .00 202.45 15,000.00 14,797.55 1.4 40-85-520 TESTING 4,444.82 42,710.06 65,000.00 22,289.94 65.7 40-85-560 UTILITIES - TELEPHONE 284.91 3,109.22 4,200.00 1,090.78 74.0 40-85-562 UTILITIES - ELECTRICITY 14,873.94 149,119.53 150,000.00 880.47 99.4 40-85-565 UTILITIES - NATURAL GAS 98.10 1,442.47 5,000.00 3,557.53 28.9 40-85-567 UTILITIES - PLANT GENERATOR .00 .00 500.00 500.00 .0 40-85-569 UTILITIES - TRASH REMOVAL 176.90 1,951.90 2,500.00 548.10 78.1 40-85-650 VEHICLE EXPENSES 213.65 3,032.82 7,500.00 4,467.18 40.4 40-85-690 MISCELLANEOUS EXPENSE .00 .00 1,000.00 1,000.00 .0 TOTAL PLANT EXPENDITURES 64,408.29 543,584.04 725,963.00 182,378.96 74.9 TOTAL FUND EXPENDITURES 64,408.29 543,584.04 725,963.00 182,378.96 74.9 NET REVENUE OVER EXPENDITURES 32.63 2,149.01 202,473.00 200,323.99 1.1 TOWN OF FRASER - JOINT FACILITIES BALANCE SHEET NOVEMBER 30, 2016 JFF - CRR/CIP FUND ASSETS 47-10100 CASH - COMBINED FUND ( 12,357.58) 47-10220 COLOTRUST 8006 - CRR 778,540.22 47-10310 CB MONEY MARKET - CRR 90,526.00 47-10410 GMB MONEY MARKET - CRR 3,505.47 47-10527 CDARS - 1017868876 - CRR 301,381.93 47-10528 CDARS - 1018437569 - CRR 388,952.14 47-10529 CDARS - 1018459163 - CRR 388,911.10 TOTAL ASSETS 1,939,459.28 LIABILITIES AND EQUITY LIABILITIES 47-20910 JFOC - CRR FUNDS 2,095,254.97 TOTAL LIABILITIES 2,095,254.97 FUND EQUITY UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 155,795.69) BALANCE - CURRENT DATE ( 155,795.69) TOTAL FUND EQUITY ( 155,795.69) TOTAL LIABILITIES AND EQUITY 1,939,459.28 TOWN OF FRASER - JOINT FACILITIES REVENUES WITH COMPARISON TO BUDGET FOR THE 11 MONTHS ENDING NOVEMBER 30, 2016 JFF - CRR/CIP FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT CRR AND CIP FUND REVENUES 47-30-100 INTEREST INCOME - CRR ACCOUNTS 995.19 10,114.97 12,000.00 1,885.03 84.3 47-30-990 CRR CARRYOVER BALANCE .00 .00 2,288,058.00 2,288,058.00 .0 TOTAL CRR AND CIP FUND REVENUES 995.19 10,114.97 2,300,058.00 2,289,943.03 .4 TOTAL FUND REVENUE 995.19 10,114.97 2,300,058.00 2,289,943.03 .4 TOWN OF FRASER - JOINT FACILITIES EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 11 MONTHS ENDING NOVEMBER 30, 2016 JFF - CRR/CIP FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT CAPITAL RPLMNTRESERVE PROJECTS 47-60-370 ENG, LEGAL & OTHER PROF SRVCS .00 22,811.38 .00 ( 22,811.38).0 47-60-730 CRR PROJECTS .00 43,495.15 115,000.00 71,504.85 37.8 TOTAL CAPITAL RPLMNTRESERVE PROJEC .00 66,306.53 115,000.00 48,693.47 57.7 CAPITAL IMPROVEMENT PROJECTS 47-65-370 ENG, LEGAL & OTHER PROF SRVCS 4,304.00 68,143.13 150,000.00 81,856.87 45.4 47-65-730 CIP PROJECTS .00 105.00 146,000.00 145,895.00 .1 TOTAL CAPITAL IMPROVEMENT PROJECTS 4,304.00 68,248.13 296,000.00 227,751.87 23.1 CAPITAL PURCHASES 47-69-740 CAPITAL PURCHASES .00 31,356.00 40,000.00 8,644.00 78.4 TOTAL CAPITAL PURCHASES .00 31,356.00 40,000.00 8,644.00 78.4 TOTAL FUND EXPENDITURES 4,304.00 165,910.66 451,000.00 285,089.34 36.8 NET REVENUE OVER EXPENDITURES ( 3,308.81)( 155,795.69)1,849,058.00 2,004,853.69 ( 8.4)