Loading...
HomeMy Public PortalAbout070_010_Summary of Revenues Expenses-RECG-EntFnd River's End Campground&RV Park Monthly Anticipated Revenues&Expense Report -FY 2009 River's End Revenues: an-`" Feb Mar-09 Apr-09 May-09 Jun-09 ANNUAL Camping 68,737.65 39,580.50 28,998.20 38,867.21 28,913.59 27,763.22 18,170.53 26,364.80 56,271.60 70,304.51 60,422.61 74,409.51 538,803.93 Cabin Revenues N/A N/A N/A N/A N/A N/A 518.00 975.00 2,585.00 4,689.00 5,904.00 13,455.00 28,126.00 Cabin Reservations N/A N/A N/A N/A N/A N/A 575.00 525.00 2,215.00 750.00 495.60 -627.00 3,933.60 Monthly/Tents 9,890.60 3,861.04 1,426.60 1,506.00 286.00 68.00 398.00 996.00 3,936.30 5,800.47 5,708.30 6,892.54 40,769.85 Campsite Reservations 15,433.10 8,880.50 6,723.53 7,659.50 6,004.00 6,453.60 10,955.10 16,385.50 20,222.80 20,447.50 19,372.10 14,696.55 153,233.78 Store Revenues 8,273.87 4,317.80 2,892.13 3,668.17 4,022.39 3,441.11 3,440.18 3,397.50 7,017.06 6,987.79 5,500.11 7,849.41 60,807.52 Misc.Revenues 1,535.64 928.18 577.97 127.79 293.92 761.28 607.29 281.42 545.16 922.97 845.10 1,432.61 8,859.33 Total Actual Revenues: 103,870.86 568.02 40,618.43 51,828.67 39,519.90 38,487.21 34,664.1048,925.22 92,792.9209,902.24 98,247.82 118,108.62 834,534.01 Misc.-Paid-Outs,+/(-) -443.98 -62.00 -596.54 -302.00 -49.72 -47.24 -184.99 -397.21 -154.69 -40.00 -10.00 -138.34 -2,426.71 832,107.4 River's End Expenditures: 39,630.00 40,763.00 39,692.00 39,722.00 39,753.00 39,783.00 39,814.00 39,845.00 39,873.00 39,904.00 39,934.00 39,965.00 ANNUAL Total Personnel 21,432.00 18,638.00 22,083.00 22,377.00 22,321.00 31,710.00 23,855.00 24,869.00 24,144.00 22,666.00 24,390.00 29,637.00 288,122.00 Total Services 15,536.00 11,760.00 7,639.00 5,872.00 6,316.00 3,981.00 6,751.00 9,065.00 27,291.00 10,532.00 8,492.00 9,201.00 122,436.00 Total Supplies 16,512.00 11,286.00 10,657.00 15,917.00 9,557.00 11,241.00 5,962.00 5,301.00 15,649.00 17,852.00 7,630.00 21,145.00 148,709.00 Total Capital Outlay 14,557.00 35,276.00 10,511.00 9,143.00 639.00 -880.00 69,246.00 Total Depreciation 0.00 Total Debt Service Expense 258,817.00 30,374.00 33,564.00 29,346.00 29,346.00 33,484.00 29,346.00 29,346.00 29,346.00 29,346.00 29,346.00 37,752.00 599,413.00 Total Actual Expenses: 328,354.00 108,834.00 85,954.00 84,154.00 69,040.00 81,917.00 67,413.00 70,081.00 97,930.00 81,896.00 71,997.00 98,356.00 1,245,926.00 Profit/(Loss) -224,483.14 -51,265.98 -45,335.57 -32,325.33 -29,520.10 -43,429.79 -32,748.90 -21,155.78 -5,137.08 28,006.24 26,250.82 19,752.62 River's End Campground&RV Park Monthly Revenues&Expense Report - FY 2010 River's End Revenues: Jul-09 Sep-09 Oct-09 Nov-09 Dec-09 I Jan-10 Feb-10 Mar-10 Apr-10 May-10 Jun-10 ANNUAL Camping 84,004.73 39,919.31 41,429.00 44,426.85 33,919.95 22,940.20 18,481.10 20,146.91 51,632.12 59,660.60 62,460.20 74,987.76 554,008.73 Cabin Revenues 15,018.00 6,210.00 5,460.00 6,543.75 2,205.00 2,595.00 635.00 2,160.00 8,332.00 9,200.00 9,269.00 14,124.33 81,752.08 Cabin Reservations -2,113.00 375.71 762.00 -745.46 -405.00 -105.00 1,235.00 1,620.00 4,381.00 2,115.00 -231.00 -3,395.00 3,494.25 Tents 10,236.49 3,185.00 3,362.00 2,136.00 764.40 0.00 413.00 102.00 5,615.40 8,485.20 8,418.53 6,622.99 49,341.01 Campsite Reservations 16,717.40 10,960.00 10,858.00 8,003.60 6,929.50 4,757.00 12,263.70 17,034.10 23,654.58 21,954.10 20,153.50 22,422.20 175,707.68 Store Revenues 9,819.08 5,091.70 4,700.50 4,640.83 3,560.61 2,983.46 3,635.94 3,966.53 5,742.06 7,293.79 6,545.75 6,403.10 64,383.35 Misc. Revenues 2,600.17 1,186.15 773.83 894.89 166.60 792.73 527.61 597.68 387.50 837.30 922.54 584.65 10,271.65 Sub-Total Revenues: 136,282.87 66,927.87 67,345.33 65,900.46 47,141.06 33,963.39 37,191.35 45,627.22 99,744.66 109,545.99 107,538.52 121,750.03 938,958.75 Misc.-Paid-Outs,+/ (-) -60.00 -113.57 -53.83 -82.91 -114.08 -71.60 -23.96 -22.12 -78.75 0.00 0.00 0.00 -620.82 River's End Expenditures: Jul-09 Aug-09 Sep-09 Oct-09 Nov-09 Dec-09 Jan-10 Total Personnel 29,307.55 21,957.00 25,494.00 25,185.47 18,599.28 41,995.59 19,266.45 18,163.44 16,408.66 18,523.89 22,658.49 22,208.35 279,768.17 Total Services 27,028.99 12,115.00 20,631.00 12,662.55 24,801.52 44,175.48 41,712.26 13,071.93 5,643.79 7,582.37 7,214.61 10,725.91 227,365.41 Total Supplies 18,339.67 15,521.00 13,024.00 6,036.66 7,614.31 19,548.92 8,724.80 11,250.10 10,417.06 9,544.23 9,831.60 11,735.04 141,587.39 Total Capital Outlay 6,415.38 3,774.13 0.00 10,189.51 Total Depreciation 861.00 861.00 861.00 861.00 861.00 861.00 861.00 861.00 861.00 861.00 861.00 861.00 10,332.00 Total Debt Service Expense 47,448.32 47,448.32 47,448.32 47,448.32 47,448.32 47,448.32 47,448.32 47,448.32 47,448.32 47,448.32 47,448.32 47,448.32 569,379.79 Total Actual Expenses: 122,985.53 97,902.32 107,458.32 98,609.38 103,098.56 154,029.31 118,012.83 90,794.79 80,778.83 83,959.81 88,014.02 92,978.62 1,238,622.27 Profit/(Loss) 13,297.34 -30,974.45 -40,112.99 -32,708.92 -55,957.50 -120,065.92 -80,821.48 -45,167.57 18,965.83 25,586.18 19,524.50 28,771.41 River's End Campground&RV Park Monthly Anticipated Revenues&Expense Report -FY 2011 River's End Revenues: Nov-10 Dec-10 Jan-11 Feb-11 Mar-11 Apr-11 May-11 Jun-11 ANNUAL Camping 87,133.24 40,995.43 49,225.96 49,017.57 30,539.37 23,244.69 14,839.88 22,379.61 52,421.93 64,540.78 65,087.51 82,708.52 582,134.49 Cabin Revenues 14,746.05 10,135.00 8,867.88 10,672.00 3,459.00 3,838.50 1,245.00 2,653.00 10,962.50 13,138.07 11,950.25 17,671.50 109,338.75 Cabin Reservations -1,580.80 -492.50 895.00 -865.30 -75.00 -282.50 2,115.00 5,310.00 1,690.50 269.00 290.55 -3,184.41 4,089.54 Tents 8,894.00 3,854.90 7,073.40 4,731.85 1,062.90 388.00 281.00 837.00 8,872.41 8,301.60 10,944.40 9,273.30 64,514.76 Campsite Reservations 17,602.25 12,689.80 12,727.24 12,722.20 8,796.20 7,757.73 12,733.40 21,757.96 20,456.35 18,716.10 16,981.50 16,369.90 179,310.63 Store Revenues 7,860.99 4,643.05 4,047.18 4,261.47 3,665.69 5,453.58 4,002.50 3,137.69 6,109.46 8,621.14 5,893.84 8,902.66 66,599.25 Misc.Revenues 1,644.64 532.50 460.62 713.80 478.34 547.33 593.86 1,022.96 654.09 2,702.60 1,023.00 1,496.42 11,870.16 Sub-Total Revenues: 136,300.37 72,358.18 83,297.28 81,253.59 47,926.50 40,947.33 35,810.64 57,098.22 101,167.24 116,289.29 112,171.05 133,237.89 1,017,857.58 Misc.-Paid-Outs,+/(-) 0.00 0.00 0.00 0.00 0.00 0.00 -1.00 -48.99 0.00 -289.80 0.00 0.00 -339.79 River's End Expenditures: Total Personnel 17,786.98 31,235.53 19,036.59 19,466.07 24,609.17 23,810.50 14,294.38 21,645.18 18,853.38 19,427.27 24,515.58 17,908.88 252,589.51 Total Services 9,598.44 22,663.96 36,542.91 12,613.04 10,401.28 16,645.70 23,584.35 3,753.50 13,031.00 4,832.45 7,988.31 11,976.24 173,631.18 Total Supplies 4,514.06 24,007.26 11,697.17 12,609.83 12,073.24 13,993.04 9,226.51 15,130.35 20,567.64 12,801.90 17,294.60 28,049.50 181,965.10 Total Capital Outlay Total Depreciation 861.00 861.00 861.00 861.00 861.00 861.00 861.00 861.00 861.00 861.00 861.00 861.00 10,332.00 Total Debt Service Expense 47,150.00 47,150.00 47,150.00 47,150.00 47,150.00 47,150.00 47,150.00 47,150.00 47,150.00 47,150.00 47,150.00 47,150.00 565,800.00 Total Anticipated Expenses: 79,910.48 125,917.75 115,287.67 92,699.94 95,094.69 102,460.24 95,116.24 88,540.03 100,463.02 85,072.62 97,809.49 105,945.62 1,184,317.79 Profit/(Loss) 56,389.89 -53,559.57 -31,990.39 -11,446.35 -47,168.19 -61,512.91 -59,305.60 -31,441.81 704.22 33,866.00 14,361.56 27,292.27 River's End Guest Survey Time Period:7.28.10-7.28.11 Rating Range: 1-5 Composite; Grade #of Res. Average Overall Rating 4.5 A- 225 Average Service Rating 4.7 A 217 Average Facility Rating 4.4 B+ 218 Average Site Rating 4.4 A- 186 Average Cabin Rating 4.4 B+ 30 Average Restroom Rating 4.3 B+ 176 Total Rating: 4.5 A- River's End Campground&RV Park Monthly Anticipated Revenues&Expense Report - FY 2012 River's End Revenues: Jun-12 ANNUAL Camping 92,325.77 34,305.14 43,149.52 40,919.21 35,794.13 22,029.28 24,182.90 31,945.37 54,276.75 64,924.54 53,795.84 82,231.08 579,879.53 Cabin Revenues 19,660.25 8,440.00 8,111.40 9,236.15 4,984.00 1,830.00 1,246.00 2,467.50 10,909.25 13,465.00 13,543.75 18,833.00 112,726.30 Cabin Reservations -3,691.45 330.50 -1,326.65 -1,730.00 -663.81 939.10 1,201.00 4,370.00 2,320.00 752.00 -414.50 -2,468.00 -381.81 Tents 10,059.89 3,035.20 4,754.40 3,636.38 1,173.26 676.00 947.30 707.60 9,843.89 7,735.09 7,840.35 8,364.75 58,774.11 Campsite Reservations 14,205.54 8,106.85 10,417.97 9,000.15 5,613.30 9,384.29 13,092.50 19,596.04 21,343.75 21,101.43 20,579.25 16,850.35 169,291.42 Store Revenues 10,041.67 3,940.54 3,805.95 4,195.77 4,392.10 3,460.56 3,704.59 4,337.80 7,365.93 8,684.00 6,331.06 8,620.51 68,880.48 Misc.Revenues 1,205.42 1,405.21 999.78 693.15 433.06 909.57 756.52 1,250.08 1,248.04 685.87 2,350.00 1,047.93 12,984.63 MIPSub-Total Revenues: 143,807.09 59,563.44 69,912.37 65,950.81 51,726.04 39,228.80 45,130.81 64,674.39 107,307. f17,347.93 104,025.75 133,479.62 1,002,154.66 Misc.-Paid-Outs,+/ (-) River's End Expenditures: Total Personnel 22,086.73 18,877.58 26,912.37 13,513.05 27,615.46 22,136.21 19,763.29 18,629.86 18,959.33 21,285.95 28,039.59 17,708.40 255,527.82 Total Services 27,055.46 8,100.84 20,687.59 3,932.82 4,645.69 8,323.97 13,881.47 4,463.44 9,278.86 3,915.61 6,147.64 11,781.00 122,214.39 Total Supplies 5,450.13 16,395.30 12,702.32 18,183.23 18,322.40 11,020.01 10,838.93 9,867.63 15,726.81 15,125.76 17,681.49 36,963.89 188,277.90 Total Capital Outlay Total Depreciation 861.00 861.00 861.00 861.00 861.00 861.00 861.00 861.00 861.00 861.00 861.00 861.00 10,332.00 Total Debt Service Expense 47,150.00 47,150.00 47,150.00 47,150.00 47,150.00 47,150.00 47,150.00 47,150.00 47,150.00 47,150.00 47,150.00 47,150.00 565,800.00 Total Expenses: 102,603.32 91,384.72 108,313.28 83,640.10 98,594.55 89,491.19 92,494.69 80,971.93 91,976.00 88,338.32 99,879.72 114,464.29 1,142,152.11 Profit/(Loss) 41,203.77 -31,821.28 -38,400.91 -17,689.29 -46,868.51 -50,262.39 -47,363.88 -16,297.54 15,331.61 29,009.61 4,146.03 19,015.33 River's End Guest Survey Time Period:8.14.11 -8.14,12 Rating Range: 1-5 Composite: Grade #of Res. Average Overall Rating 4.4 B+ 214 Average Service Rating 4.6 A- 190 Average Facility Rating 4.3 B+ 190 Average Site Rating 4.4 B+ 148 Average Cabin Rating 4.7 A 17 Average Restroom Rating 4.4 A- 155 River's End Campground& RV Park Monthly Anticipated Revenues&Expense Report -FY 2013 River's End Revenues: Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 ANNUAL Camping 80,496.11 43,351.32 46,004.42 50,395.80 35,233.86 22,299.41 28,835.15 31,410.02 65,187.18 174,964.26 88,683.82 666,861.35 Cabin Revenues 17,275.50 11,642.50 6,870.07 8,317.75 5,146.00 3,932.02 2,529.00 3,990.60 8,082.85 12,177.60 11,890.50 91,854.39 Tents 8,099.30 5,636.40 4,684.22 4,524.99 1,040.95 321.40 304.50 507.50 1,663.90 3,566.30 7,882.65 38,232.11 Store Revenues 9,494.62 5,141.74 4,541.85 4,178.57 4,542.36 4,454.48 4,138.88 4,002.73 9,140.88 9,165.44 8,738.35 67,539.90 Misc. Revenues 3,015.95 2,436.09 1,397.45 739.38 1,241.96 991.19 911.74 1,579.10 1,607.49 1,422.00 2,079.73 17,422.08 Sub-Total Revenues: 118,381.48 68,208.05 78,026.22 68,156.49 47,205.13 31,998.50 36,719.27 41,489.95 85,682.30 201,295.60 119,275.05 0.00 896,438.04 Misc.-Paid-Outs,+/ (-) 0.00 0.00 0.00 0.00 0.00 48 68,1=11111MISL205.13 31,998.50 36,719.27 41,489.95 85,682.30 201,295.60 119,275.05 0.00 896,438.04 River's End Expenditures: Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 ANNUAL Total Personnel 21,419.38 22,369.80 24,306.63 31,963.83 23,312.99 22,051.12 21,029.69 23,698.89 26,496.99 31,681.90 23,723.83 272,055.05 Total Services 30,469.44 8,886.24 28,1 1 1.00 17,397.15 6,488.65 12,597.11 10,943.23 5,266.86 12,1 13.91 7,598.26 9,945.89 149,817.74 Total Supplies 11,762.90 23,163.16 13,570.57 11,498.91 6,657.68 6,719.33 29,599.46 16,531.23 19,286.49 13,532.86 26,439.21 178,761.80 Total Capital Outlay 27,991.00 11,599.00 11,599.00 51,189.00 Depreciation 541.66 541.66 1,083.32 Total Debt Service Expense 47,150.00 46,735.00 46,735.00 46,735.00 46,735.00 46,735.00 46,735.00 46,735.00 46,735.00 46,735.00 46,735.00 514,500.00 Total Expenses: 110,801.72 101,154.20 112,723.20 107,594.89 83,194.32 88,102.56 136,298.38 92,231.98 104,632.39 111,688.68 118,984.59 0.00 1,167,406.91 Profit/(Loss) 7,579.76 -32,946.15 -34,696.98 -39,438.40 -35,989.19 -56,104.06 -99,579.11 -50,742.03 -18,950.09 89,606.92 290.46 0.00 *high amount in Camping fees APR-13 due to transition to enterprise fund. Reservations are now a 'liability account'. Amount includes redeemed reservations Jul - Mar of FY13. River's End Guest Survey Time Period:7.1.12-7.1.13 Rating Range: 1-5 Composite: Grade #of Res. Average Overall Rating 4.3 B+ 151 Average Service Rating 4.7 A 95 Average Facility Rating 4.3 B+ 127 Average Site Rating 4.4 A- 94 Average Cabin Rating 4.6 A- 9 Average Restroom Rating 4.5 A- 77