Loading...
HomeMy Public PortalAboutDecember 2016 Preliminary JFF Financial StatementsTOWN OF FRASER - JOINT FACILITIES BALANCE SHEET DECEMBER 31, 2016 JOINT FACILITIES FUND ASSETS 40-10100 CASH ALLOCATED TO OTHER FUNDS 24,294.33 40-10210 JFOC CHECKING-GMB 0318047507 90,120.34 40-10215 GMB MONEY MARKET-O&M RESERVE 31,077.88 40-11550 A/R - WPR 15,861.04 40-11560 A/R - GC#1 24,727.79 40-11570 A/R - TOF 14,484.21 TOTAL ASSETS 200,565.59 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,175.70 BALANCE - CURRENT DATE 2,175.70 TOTAL FUND EQUITY 2,175.70 TOTAL LIABILITIES AND EQUITY 200,565.59 TOWN OF FRASER - JOINT FACILITIES REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2016 JOINT FACILITIES FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT REVENUE 40-30-100 INTEREST - O&M ACCOUNTS 26.69 354.20 300.00 ( 54.20)118.1 40-30-200 O&M REIMBURSEMENT - WPR 15,861.04 164,840.66 209,803.00 44,962.34 78.6 40-30-210 O&M REIMBURSEMENT - GC#1 24,727.79 268,926.66 330,313.00 61,386.34 81.4 40-30-220 O&M REIMBURSEMENT - TOF 14,484.21 164,889.76 185,846.00 20,956.24 88.7 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 55,099.73 600,832.78 928,436.00 327,603.22 64.7 TOTAL FUND REVENUE 55,099.73 600,832.78 928,436.00 327,603.22 64.7 TOWN OF FRASER - JOINT FACILITIES EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2016 JOINT FACILITIES FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT PLANT EXPENDITURES 40-85-110 SALARIES 14,090.82 179,531.53 175,000.00 ( 4,531.53)102.6 40-85-210 HEALTH INSURANCE 3,493.90 40,503.00 37,000.00 ( 3,503.00)109.5 40-85-220 FICA TAX 1,000.12 12,402.05 13,388.00 985.95 92.6 40-85-230 RETIREMENT 426.20 5,127.49 7,000.00 1,872.51 73.3 40-85-250 UNEMPLOYMENT TAX 43.64 541.35 525.00 ( 16.35)103.1 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 990.00 4,035.00 15,000.00 10,965.00 26.9 40-85-350 SLUDGE REMOVAL 4,962.47 41,636.46 55,000.00 13,363.54 75.7 40-85-370 PROFESSIONAL SERVICES 267.96 3,568.84 10,000.00 6,431.16 35.7 40-85-430 INSURANCE - PLANT .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 3,344.51 23,592.85 50,000.00 26,407.15 47.2 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 .00 450.00 500.00 50.00 90.0 40-85-500 OPERATING SUPPLIES 276.69 4,559.93 15,000.00 10,440.07 30.4 40-85-506 OPERATING SUPPLIES - CHEMICALS 1,523.48 25,854.44 50,000.00 24,145.56 51.7 40-85-510 EQUIPMENT PURCHASE AND REPAIR .00 202.45 15,000.00 14,797.55 1.4 40-85-520 TESTING 6,830.99 49,541.05 65,000.00 15,458.95 76.2 40-85-560 UTILITIES - TELEPHONE 284.91 3,394.13 4,200.00 805.87 80.8 40-85-562 UTILITIES - ELECTRICITY 15,838.06 164,957.59 150,000.00 ( 14,957.59)110.0 40-85-565 UTILITIES - NATURAL GAS 333.00 1,775.47 5,000.00 3,224.53 35.5 40-85-567 UTILITIES - PLANT GENERATOR .00 .00 500.00 500.00 .0 40-85-569 UTILITIES - TRASH REMOVAL 188.42 2,140.32 2,500.00 359.68 85.6 40-85-650 VEHICLE EXPENSES 764.23 3,797.05 7,500.00 3,702.95 50.6 40-85-690 MISCELLANEOUS EXPENSE 413.64 413.64 1,000.00 586.36 41.4 TOTAL PLANT EXPENDITURES 55,073.04 598,657.08 725,963.00 127,305.92 82.5 TOTAL FUND EXPENDITURES 55,073.04 598,657.08 725,963.00 127,305.92 82.5 NET REVENUE OVER EXPENDITURES 26.69 2,175.70 202,473.00 200,297.30 1.1 TOWN OF FRASER - JOINT FACILITIES BALANCE SHEET DECEMBER 31, 2016 JFF - CRR/CIP FUND ASSETS 47-10100 CASH - COMBINED FUND ( 24,294.33) 47-10220 COLOTRUST 8006 - CRR 779,120.43 47-10310 CB MONEY MARKET - CRR 90,564.34 47-10410 GMB MONEY MARKET - CRR 3,506.44 47-10527 CDARS - 1017868876 - CRR 301,458.62 47-10528 CDARS - 1018437569 - CRR 389,133.38 47-10529 CDARS - 1018459163 - CRR 389,092.33 TOTAL ASSETS 1,928,581.21 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 ( 166,673.76) BALANCE - CURRENT DATE ( 166,673.76) TOTAL FUND EQUITY ( 166,673.76) TOTAL LIABILITIES AND EQUITY 1,928,581.21 TOWN OF FRASER - JOINT FACILITIES REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2016 JFF - CRR/CIP FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT CRR AND CIP FUND REVENUES 47-30-100 INTEREST INCOME - CRR ACCOUNTS 1,058.68 11,173.65 12,000.00 826.35 93.1 47-30-990 CRR CARRYOVER BALANCE .00 .00 2,288,058.00 2,288,058.00 .0 TOTAL CRR AND CIP FUND REVENUES 1,058.68 11,173.65 2,300,058.00 2,288,884.35 .5 TOTAL FUND REVENUE 1,058.68 11,173.65 2,300,058.00 2,288,884.35 .5 TOWN OF FRASER - JOINT FACILITIES EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2016 JFF - CRR/CIP FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT CAPITAL RPLMNTRESERVE PROJECTS 47-60-370 ENG, LEGAL & OTHER PROF SRVCS 3,350.00 26,161.38 .00 ( 26,161.38).0 47-60-730 CRR PROJECTS .00 43,495.15 115,000.00 71,504.85 37.8 TOTAL CAPITAL RPLMNTRESERVE PROJEC 3,350.00 69,656.53 115,000.00 45,343.47 60.6 CAPITAL IMPROVEMENT PROJECTS 47-65-370 ENG, LEGAL & OTHER PROF SRVCS 8,586.75 76,729.88 150,000.00 73,270.12 51.2 47-65-730 CIP PROJECTS .00 105.00 146,000.00 145,895.00 .1 TOTAL CAPITAL IMPROVEMENT PROJECTS 8,586.75 76,834.88 296,000.00 219,165.12 26.0 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 11,936.75 177,847.41 451,000.00 273,152.59 39.4 NET REVENUE OVER EXPENDITURES ( 10,878.07)( 166,673.76)1,849,058.00 2,015,731.76 ( 9.0)