Loading...
HomeMy Public PortalAbout08 October 2016 JFF Financial StatementsTOWN OF FRASER - JOINT FACILITIES BALANCE SHEET OCTOBER 31, 2016 JOINT FACILITIES FUND ASSETS 40-10100 CASH ALLOCATED TO OTHER FUNDS 8,053.58 40-10210 JFOC CHECKING-GMB 0318047507 123,489.36 40-10215 GMB MONEY MARKET-O&M RESERVE 31,072.79 40-11550 A/R - WPR 10,912.48 40-11560 A/R - GC#1 17,012.85 40-11570 A/R - TOF 9,965.21 TOTAL ASSETS 200,506.27 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,116.38 BALANCE - CURRENT DATE 2,116.38 TOTAL FUND EQUITY 2,116.38 TOTAL LIABILITIES AND EQUITY 200,506.27 TOWN OF FRASER - JOINT FACILITIES REVENUES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING OCTOBER 31, 2016 JOINT FACILITIES FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT REVENUE 40-30-100 INTEREST - O&M ACCOUNTS 34.55 294.88 300.00 5.12 98.3 40-30-200 O&M REIMBURSEMENT - WPR 10,912.48 130,430.03 209,803.00 79,372.97 62.2 40-30-210 O&M REIMBURSEMENT - GC#1 17,012.85 215,279.55 330,313.00 115,033.45 65.2 40-30-220 O&M REIMBURSEMENT - TOF 9,965.21 133,466.17 185,846.00 52,379.83 71.8 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 37,925.09 481,292.13 928,436.00 447,143.87 51.8 TOTAL FUND REVENUE 37,925.09 481,292.13 928,436.00 447,143.87 51.8 TOWN OF FRASER - JOINT FACILITIES EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING OCTOBER 31, 2016 JOINT FACILITIES FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT PLANT EXPENDITURES 40-85-110 SALARIES 12,945.28 151,291.97 175,000.00 23,708.03 86.5 40-85-210 HEALTH INSURANCE 3,493.90 33,515.20 37,000.00 3,484.80 90.6 40-85-220 FICA TAX 880.83 10,429.04 13,388.00 2,958.96 77.9 40-85-230 RETIREMENT 384.20 4,276.15 7,000.00 2,723.85 61.1 40-85-250 UNEMPLOYMENT TAX 38.96 455.14 525.00 69.86 86.7 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 57.34 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 900.00 3,045.00 15,000.00 11,955.00 20.3 40-85-350 SLUDGE REMOVAL 1,409.56 33,876.55 55,000.00 21,123.45 61.6 40-85-370 PROFESSIONAL SERVICES 267.96 2,679.60 10,000.00 7,320.40 26.8 40-85-430 INSURANCE - PLANT 90.00 4,908.85 30,000.00 25,091.15 16.4 40-85-440 ADVERTISING .00 .00 500.00 500.00 .0 40-85-460 PLANT MAINTENANCE AND REPAIR .00 19,460.84 50,000.00 30,539.16 38.9 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 190.00 390.00 500.00 110.00 78.0 40-85-500 OPERATING SUPPLIES 97.31 4,098.21 15,000.00 10,901.79 27.3 40-85-506 OPERATING SUPPLIES - CHEMICALS 1,523.48 22,807.48 50,000.00 27,192.52 45.6 40-85-510 EQUIPMENT PURCHASE AND REPAIR .00 202.45 15,000.00 14,797.55 1.4 40-85-520 TESTING .00 38,265.24 65,000.00 26,734.76 58.9 40-85-560 UTILITIES - TELEPHONE 285.51 2,824.31 4,200.00 1,375.69 67.3 40-85-562 UTILITIES - ELECTRICITY 14,813.05 134,245.59 150,000.00 15,754.41 89.5 40-85-565 UTILITIES - NATURAL GAS 85.64 1,344.37 5,000.00 3,655.63 26.9 40-85-567 UTILITIES - PLANT GENERATOR .00 .00 500.00 500.00 .0 40-85-569 UTILITIES - TRASH REMOVAL 176.90 1,775.00 2,500.00 725.00 71.0 40-85-650 VEHICLE EXPENSES 250.62 2,819.17 7,500.00 4,680.83 37.6 40-85-690 MISCELLANEOUS EXPENSE .00 .00 1,000.00 1,000.00 .0 TOTAL PLANT EXPENDITURES 37,890.54 479,175.75 725,963.00 246,787.25 66.0 TOTAL FUND EXPENDITURES 37,890.54 479,175.75 725,963.00 246,787.25 66.0 NET REVENUE OVER EXPENDITURES 34.55 2,116.38 202,473.00 200,356.62 1.1 TOWN OF FRASER - JOINT FACILITIES BALANCE SHEET OCTOBER 31, 2016 JFF - CRR/CIP FUND ASSETS 47-10100 CASH - COMBINED FUND ( 8,053.58) 47-10220 COLOTRUST 8006 - CRR 778,007.94 47-10310 CB MONEY MARKET - CRR 90,488.91 47-10410 GMB MONEY MARKET - CRR 3,504.43 47-10527 CDARS - 1017868876 - CRR 301,307.74 47-10528 CDARS - 1018437569 - CRR 388,776.84 47-10529 CDARS - 1018459163 - CRR 388,735.81 TOTAL ASSETS 1,942,768.09 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 ( 152,486.88) BALANCE - CURRENT DATE ( 152,486.88) TOTAL FUND EQUITY ( 152,486.88) TOTAL LIABILITIES AND EQUITY 1,942,768.09 TOWN OF FRASER - JOINT FACILITIES REVENUES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING OCTOBER 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,018.21 9,119.78 12,000.00 2,880.22 76.0 47-30-990 CRR CARRYOVER BALANCE .00 .00 2,288,058.00 2,288,058.00 .0 TOTAL CRR AND CIP FUND REVENUES 1,018.21 9,119.78 2,300,058.00 2,290,938.22 .4 TOTAL FUND REVENUE 1,018.21 9,119.78 2,300,058.00 2,290,938.22 .4 TOWN OF FRASER - JOINT FACILITIES EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING OCTOBER 31, 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 8,053.58 63,839.13 150,000.00 86,160.87 42.6 47-65-730 CIP PROJECTS .00 105.00 146,000.00 145,895.00 .1 TOTAL CAPITAL IMPROVEMENT PROJECTS 8,053.58 63,944.13 296,000.00 232,055.87 21.6 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 8,053.58 161,606.66 451,000.00 289,393.34 35.8 NET REVENUE OVER EXPENDITURES ( 7,035.37)( 152,486.88)1,849,058.00 2,001,544.88 ( 8.3)