Loading...
HomeMy Public PortalAbout20140821Approved Capmground FY15 Budget.xlsxRIVER'S END RV PARK FUND 555 Fund REVENUES 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 Fund EXPENSES 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 Dept 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 Dept 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 9000 Object 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 Total 39 39 Total Grand Total Object 51 51 51 51 51 51 51 51 51 51 51 51 Total 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 Total 53 53 53 53 53 53 53 53 53 53 53 53 53 53 Total 54 54 54 54 54 54 Total 55 55 55 55 Total 56 56 56 Total 58 58 58 58 58 58 Total 61 61 Total Grand Total 7520 7521 7522 7523 7524 7525 7527 7528 7529 7530 7531 7532 7533 7534 7535 7536 7537 7538 1201 1100 1111 1200 1300 1400 2100 2200 2300 2400 2600 2700 2110 2130 2135 2200 2201 2202 2203 2205 3100 3202 3220 3300 3400 3500 3600 3700 3800 3850 3901 3950 1100 1102 1130 1210 1220 1230 1270 1520 1595 1596 1600 1703 1720 1100 2100 2200 1005 1008 1010 1000 2000 2100 2202 3000 4000 Account Description Camping Fees Camp Tent Site Cabin Rental Taxable (13%) Cabin All Taxes Exempt Cabin GA Sales Tax Exempt Camp Site Reservations Ice Revenues Propane Revenues RV Supplies Revenue Store Revenue Electricity Fees Vending Machine Revenue Trolley Ticket Revenue Miscellaneous Revenue Other Revenues In House Event Cabin Reservations Cabin Damage Deposit Campground Sales- Parking Pas Transfers from General Fund Account Description Salaries & Wages Accrued Vacation Adjustme Part Time/Seasonal Wages Overtime Employee Benefits Health Insurance Benefits Social Security Contribut Medicare Contributions Retirement Contributions Unemployment Ins Workers Compensation Cola and\or merit and\or bonus Garbage Service Custodial Services Pool Cleaning Service Pest Control Repair & Maint - Equipmen Repair & Maintain - Vehic Repair & Maintain - Bldgs Repair & Maintain - Infra Property & Liablility Ins Cable, Data & Fax Lines Postage & Freight Advertising Printing & Binding Travel & Related Dues & Fees Education & Training Permits, Regulatory Fees Contract Labor Credit Card Charges Lodging Compensation Supplies & Materials Flags Pool Cleaning Supplies Water/Sewer Charges Propane Electricity Gasoline & Diesel Propane RV Park-COGS Camp Store Groceries-COGS Camp Store-RV Supplies CO Small Equipment Over/Short Uniforms Capital Improvements Infrastructure Capital Equipment Buildings Vehicles Indirect Allocation - A Indirect Allocation - P Indirect Allocation - Acc Depreciation Amortization Int Exp Rev Bond RE Gen Fund Note - Interest Custodian Fees & Charges Issuance Costs Amortizati Principle Bond Contingency NET 1.5% Cola FY15 Budget 930000 33600 125000 500 0 0 7500 17500 9540 65000 2600 16000 0 3000 500 300 100 6250 1217390 135442 135442 1352832 1.5% Cola FY15 Budget 228555 4656 39971 5000 4050 50976 17210 4025 24205 0 4655 3638 386941 6408 2700 3600 2569 3500 500 13000 28000 7908 13200 1500 69000 0 5880 18800 3970 600 10000 22000 0 213135 45720 0 3500 18000 2300 83000 900 12000 40000 12000 23855 50 1700 243025 0 42000 23000 90000 17008 172008 5643 2409 18924 26976 50850 0 50850 252563.75 0 550 0 0 253113.75 6783 6783 1352831.75 0.25 1.5% Cola & 1.5% Merit FY15 Budget 930000 33600 125000 500 0 0 7500 17500 9540 65000 2600 16000 0 3000 500 300 100 6250 1217390 135442 135442 1352832 1.5% Cola & 1.5% Merit FY15 Budget 228555 4656 39971 5000 4050 50976 17210 4025 24205 0 4655 7276 390579 6408 2700 3600 2569 3500 500 13000 28000 7908 13200 1500 69000 0 5880 18800 3970 600 10000 22000 0 213135 45720 0 3500 18000 2300 83000 900 12000 40000 12000 23855 50 1700 243025 0 42000 23000 90000 17008 172008 5643 2409 18924 26976 50850 0 50850 252563.75 0 550 0 0 253113.75 3145 3145 1352831.75 0.25 1.5% Cola & 2.5% Merit FY15 Budget 930000 33600 125000 500 0 0 7500 17500 9540 65000 2600 16000 0 3000 500 300 100 6250 1217390 135442 135442 1352832 1.5% Cola & 2.5% Merit FY15 Budget 228555 4656 39971 5000 4050 50976 17210 4025 24205 0 4655 5849 389152 6408 2700 3600 2569 3500 500 13000 28000 7908 13200 1500 69000 0 5880 18800 3970 600 10000 22000 0 213135 45720 0 3500 18000 2300 83000 900 12000 40000 12000 23855 50 1700 243025 0 42000 23000 90000 17008 172008 5643 2409 18924 26976 50850 0 50850 252563.75 0 550 0 0 253113.75 4572 4572 1352831.75 0.25 1.5% Cola & Bonus FY15 Budget 930000 33600 125000 500 0 0 7500 17500 9540 65000 2600 16000 0 3000 500 300 100 6250 1217390 135442 135442 1352832 1.5% Cola & Bonus FY15 Budget 228555 4656 39971 5000 4050 50976 17210 4025 24205 0 4655 10421 393724 6408 2700 3600 2569 3500 500 13000 28000 7908 13200 1500 69000 0 5880 18800 3970 600 10000 22000 0 213135 45720 0 3500 18000 2300 83000 900 12000 40000 12000 23855 50 1700 243025 0 42000 23000 90000 17008 172008 5643 2409 18924 26976 50850 0 50850 252563.75 0 550 0 0 253113.75 0 0 1352831.75 0.25 Variance between FY15 vs FY14 170000 -26400 25000 0 0 0 500 1500 -7460 25000 -400 10500 -50 -31800 0 0 0 5950 172340 -235134 -235134 -62794 Variance between FY15 vs FY14 8803 4656 5000 -1000 1800 15446 1340 314 5505 0 34 10421 52319 0 0 0 -354 0 0 -2000 5000 0 0 300 0 0 304.76 0 2032.31 0 0 0 0 5283.07 1729.48 0 500 0 0 0 0 0 14400 0 16855 30 806.42 34320.9 -48495.97 42000 23000 90000 17008 123512.03 0 0 0 0 30850 -4650 26200 -14429.25 0 0 0 -290000 -304429.25 0 0 -62794.25 0.25 FY14 Budget 760000 60000 100000 500 0 0 7000 16000 17000 40000 3000 5500 50 34800 500 300 100 300 1045050 370576 370576 1415626 FY14 Budget 219752 0 34971 6000 2250 35530 15870 3711 18700 0 4621 0 341405 6408 2700 3600 2923 3500 500 15000 23000 7908 13200 1200 69000 0 5575.24 18800 1937.69 600 10000 22000 0 207851.93 43990.52 0 3000 18000 2300 83000 900 12000 25600 12000 7000 20 893.58 208704.1 48495.97 0 0 0 0 48495.97 5643 2409 18924 26976 20000 4650 24650 266993 0 550 0 290000 557543 0 0 1415626 0 FY14 Actual 6-3-14 766875.55 68143.18 112866.48 0 0 0 6123.72 19717.78 8770.94 53731.47 2484.44 8873.23 0 4917.9 0 0 0 5685 1058189.69 0 0 1058189.69 FY14 Actual 3-31-14 185557.79 0 22202.25 777.88 1377.58 33464.36 12824.67 2999.41 17125.68 0 4538.81 0 280868.43 5400 2175 3600 2659.5 3998.5 -11.55 23979.24 17841.29 4279.05 11282.88 1058.78 52912.7 0 5575.24 16918.65 1937.69 200 7050 23165.82 0 184022.79 26729.18 0 2965.2 13054.24 2038.49 69596.38 1240.95 10842.04 27447.8 10564.06 8825.66 20.24 893.58 174217.82 48495.97 0 0 0 0 48495.97 5642.64 2409 18924.12 26975.76 0 0 0 152815.42 0 458.34 0 0 153273.76 0 0 867854.53 190335.16 FY14 Encumbrance 0 0 0 FY14 Encumbrance 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 FY14 Budget Balance -6875.55000000005 -8143.17999999999 -12866.48 500 0 0 876.28 -3717.78 8229.06 -13731.47 515.56 -3373.23 50 29882.1 500 300 100 -5385 -13139.69 370576 370576 357436.31 FY14 Budget Balance 34194.21 0 12768.75 5222.12 872.42 2065.64 3045.33 711.59 1574.32 0 82.1899999999996 0 60536.57 1008 525 0 263.5 -498.5 511.55 -8979.24 5158.71 3628.95 1917.12 141.22 16087.3 0 0 1881.35 0 400 2950 -1165.82 0 23829.14 17261.34 0 34.8000000000002 4945.76 261.51 13403.62 -340.95 1157.96 -1847.8 1435.94 -1825.66 -0.239999999999998 0 34486.28 0 0 0 0 0 0 0.359999999999673 0 -0.119999999998981 0.240000000000691 20000 4650 24650 114177.58 0 91.66 0 290000 114269.24 0 0 257771.47 99664.84 FY13 Actual 815670.14 48729.97 111254.72 0 0 0 6358.19 18904.23 8098.93 44371.56 2367.17 7337.36 52 4358.59 225 0 25 2100 1069852.86 11447.13 11447.13 1081299.99 FY13 Actual 181140.66 -38.97 35811.5 3925.52 1500 25140.18 13637.74 3259.49 25371.24 3300 4146.14 297193.5 5940 825 3600 3098 -1793.46 488.84 12569.22 11926.55 6922.96 11341.79 453.28 56813.22 0 2767.75 5552.49 1789 0 5688.23 22944.61 641.85 151569.33 42794.03 0 3221.85 25758.63 1658.71 68446.64 1121.47 8265.25 3067.47 1329.52 29155.81 -4.43 603.05 185418 56138.5 0 0 0 0 56138.5 0 0 0 0 21820.06 0 21820.06 269801.46 0 541.67 108302 0 378645.13 269801.46 269801.46 1090784.52 Variance between FY15 vs FY13 114329.86 -15129.97 13745.28 500 0 0 1141.81 -1404.23 1441.07 20628.44 232.83 8662.64 -52 -1358.59 275 300 75 4150 147537.14 123994.87 123994.87 271532.01 Variance between FY15 vs FY13 47414.34 4694.97 4159.5 1074.48 2550 25835.82 3572.26 765.51 -1166.24 -3300 508.86 86109.5 468 1875 0 -529 5293.46 11.16 430.780000000001 16073.45 985.04 1858.21 1046.72 12186.78 0 3112.25 13247.51 2181 600 4311.77 -944.610000000001 -641.85 61565.67 2925.97 0 278.15 -7758.63 641.29 14553.36 -221.47 3734.75 36932.53 10670.48 -5300.81 54.43 1096.95 57607 -56138.5 42000 23000 90000 17008 115869.5 5643 2409 18924 26976 29029.94 0 29029.94 -17237.71 0 8.33000000000004 -108302 0 -125531.38 -269801.46 -269801.46 251626.23 FY12 Actual 578825.93 58774.11 112726.3 0 0 169291.42 5674.61 17293.22 7066.1 38846.55 1884.74 4861.82 304 5433.03 475 -381.81 0 0 1001075.02 207498.18 207498.18 1208573.2 FY12 Actual 172935.15 0 33031.93 266.16 1062.5 28851.82 12293.78 2805.45 15333.12 0 3303.51 269883.42 6480 0 3600 3152 2875.35 397.83 17927.49 13266.22 6015.69 11228.97 1109.21 65642.77 65 1337.6 2823.73 685 600 7941.6 18121.36 0 163269.82 44661.13 708 2984.8 18301.33 2277.07 77533.52 1809.76 11140.99 29088.94 7126.02 31950.7 54.31 522.65 228159.22 0 0 0 0 -13624.26 -13624.26 0 0 0 0 18974.56 4650 23624.56 294030.88 0 458.33 0 0 294489.21 294030.88 294030.88 965801.97 Variance between FY15 vs FY12 351174.07 -25174.11 12273.7 500 0 -169291.42 1825.39 206.779999999999 2473.9 26153.45 715.26 11138.18 -304 -2433.03 25 681.81 100 6250 216314.98 -72056.18 -72056.18 144258.8 Variance between FY15 vs FY12 55619.85 4656 6939.07 4733.84 2987.5 22124.18 4916.22 1219.55 8871.88 0 1351.49 113419.58 -72 2700 0 -583 624.65 102.17 -4927.49 14733.78 1892.31 1971.03 390.79 3357.23 -65 4542.4 15976.27 3285 0 2058.4 3878.64 0 49865.18 1058.87 -708 515.2 -301.330000000002 22.9299999999998 5466.48 -909.76 859.01 10911.06 4873.98 -8095.7 -4.31 1177.35 14865.78 0 42000 23000 0 30632.26 95632.26 5643 2409 18924 26976 18974.56 4650 23624.56 -41467.13 0 91.67 0 0 -41375.46 -294030.88 -294030.88 283007.9 RIVER'S END RV PARK FUND 555 Fund REVENUES 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 Fund EXPENSES 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 555 Dept 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 Dept 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 6180 9000 Object 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 Total 39 39 Total Grand Total Object 51 51 51 51 51 51 51 51 51 51 51 Total 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 Total 53 53 53 53 53 53 53 53 53 53 53 53 53 Total 54 54 54 54 54 Total 55 55 55 55 Total 56 56 Total 58 58 58 Total 61 61 Total Grand Total 7520 7521 7522 7523 7527 7528 7529 7530 7531 7532 7534 7535 7536 7537 7538 1201 1100 1111 1200 1300 1400 2100 2200 2300 2400 2700 2110 2130 2135 2200 2201 2202 2203 2205 3100 3202 3220 3300 3500 3600 3700 3800 3850 3901 1100 1130 1210 1220 1230 1270 1520 1595 1596 1600 1703 1720 1400 2100 1310 2200 1005 1008 1010 1000 2100 3000 Account Description Camping Fees Camp Tent Site Cabin Rental Taxable (13%) Cabin All Taxes Exempt Ice Revenues Propane Revenues RV Supplies Revenue Store Revenue Electricity Fees Vending Machine Revenue Miscellaneous Revenue Other Revenues In House Event Cabin Reservations Cabin Damage Deposit Campground Sales- Parking Pas Transfers from General Fund Account Description Salaries & Wages Accrued Vacation Adjustme Part Time/Seasonal Wages Overtime Employee Benefits Health Insurance Benefits Social Security Contribut Medicare Contributions Retirement Contributions Workers Compensation Cola and\or merit and\or bonus Garbage Service Custodial Services Pool Cleaning Service Pest Control Repair & Maint - Equipmen Repair & Maintain - Vehic Repair & Maintain - Bldgs Repair & Maintain - Infra Property & Liablility Ins Cable, Data & Fax Lines Postage & Freight Advertising Travel & Related Dues & Fees Education & Training Permits, Regulatory Fees Contract Labor Credit Card Charges Supplies & Materials Pool Cleaning Supplies Water/Sewer Charges Propane Electricity Gasoline & Diesel Propane RV Park-COGS Camp Store Groceries-COGS Camp Store-RV Supplies CO Small Equipment Over/Short Uniforms Infrastructure Capital Equipment Buildings Vehicles Indirect Allocation - A Indirect Allocation - P Indirect Allocation - Acc Depreciation Int Exp Rev Bond RE Custodian Fees & Charges Contingency NET FY15 Approved Budget 930000 33600 125000 500 7500 17500 9540 65000 2600 16000 3000 500 300 100 6250 1217390 135442 135442 1352832 FY15 Approved Budget 228555 4656 39971 5000 4050 50976 17210 4025 24205 4655 7276 390579 6408 2700 3600 2569 3500 500 13000 28000 7908 13200 1500 69000 5880 18800 3970 600 10000 22000 213135 45720 3500 18000 2300 83000 900 12000 40000 12000 23855 50 1700 243025 42000 23000 90000 17008 172008 5643 2409 18924 26976 50850 50850 252563.75 550 253113.75 3145 3145 1352831.75 0.25