| Operating Fund - Detail | March 2006 | ||||||||||||||||||
| Current Period | Year to Date | Annual Budget | |||||||||||||||||
| Revenue | Actual | Budget | $$ Variance | % Variance | Over/Under | Actual | Budget | $$ Variance | % Variance | Over/Under | Actual | Budget | $$ Variance | % Variance | Over/Under | ||||
| Annual Assessments | 58691.04 | 15000.00 | 43691.04 | 391.27% | 291.27% | 101663.61 | 30000.00 | 71663.61 | 338.88% | 238.88% | 101663.61 | 150000.00 | -48336.39 | 67.78% | -32.22% | ||||
| Clubhouse Rental | 390.00 | 250.00 | 140.00 | 156.00% | 56.00% | 735.00 | 750.00 | -15.00 | 98.00% | -2.00% | 735.00 | 3000.00 | -2265.00 | 24.50% | -75.50% | ||||
| Miscellaneous Income | 171.29 | 16.67 | 154.62 | 1027.74% | 927.74% | 491.00 | 50.00 | 441.00 | 982.00% | 882.00% | 491.00 | 200.00 | 291.00 | 245.50% | 145.50% | ||||
| Carryover Expense from 2005 | |||||||||||||||||||
| TOTAL REVENUE | 59252.33 | 15266.67 | 43985.66 | 388.12% | 288.12% | 102889.61 | 30800.00 | 72089.61 | 334.06% | 234.06% | 102889.61 | 153200.00 | -50310.39 | 67.16% | -32.84% | ||||
| Expenses | |||||||||||||||||||
| Administrative | |||||||||||||||||||
| Postage | 424.77 | 125.00 | -299.77 | 339.82% | 239.82% | 505.09 | 375.00 | -130.09 | 134.69% | 34.69% | 505.09 | 1500.00 | 994.91 | 33.67% | -66.33% | ||||
| Printing | 500.76 | 250.00 | -250.76 | 200.30% | 100.30% | 1201.02 | 750.00 | -451.02 | 160.14% | 60.14% | 1201.02 | 3000.00 | 1798.98 | 40.03% | -59.97% | ||||
| Dues & License Fees | 0.00 | 29.17 | 29.17 | 0.00% | -100.00% | 0.00 | 87.50 | 87.50 | 0.00% | -100.00% | 0.00 | 350.00 | 350.00 | 0.00% | -100.00% | ||||
| Misc / Admin | -64.70 | 16.67 | 81.37 | -388.20% | -488.20% | 29.28 | 50.00 | 20.72 | 58.56% | -41.44% | 29.28 | 200.00 | 170.72 | 14.64% | -85.36% | ||||
| Annual/Monthly Meetings | 0.00 | 16.67 | 16.67 | 0.00% | -100.00% | 0.00 | 50.00 | 50.00 | 0.00% | -100.00% | 0.00 | 200.00 | 200.00 | 0.00% | -100.00% | ||||
| Social Activities | 0.00 | 83.33 | 83.33 | 0.00% | -100.00% | 0.00 | 250.00 | 250.00 | 0.00% | -100.00% | 0.00 | 1000.00 | 1000.00 | 0.00% | -100.00% | ||||
| Total Administrative | 860.83 | 520.83 | -340.00 | 165.28% | 65.28% | 1735.39 | 1562.50 | -172.89 | 111.06% | 11.06% | 1735.39 | 6250.00 | 4514.61 | 27.77% | -72.23% | ||||
| Professional | |||||||||||||||||||
| Audit & Accounting | 200.00 | 250.00 | 50.00 | 80.00% | -20.00% | 200.00 | 250.00 | 50.00 | 80.00% | -20.00% | 200.00 | 250.00 | 50.00 | 80.00% | -20.00% | ||||
| Legal | 770.00 | 250.00 | -520.00 | 308.00% | 208.00% | 1326.00 | 750.00 | -576.00 | 176.80% | 76.80% | 1326.00 | 3000.00 | 1674.00 | 44.20% | -55.80% | ||||
| Management | 800.00 | 800.00 | 0.00 | 100.00% | 0.00% | 2400.00 | 2400.00 | 0.00 | 100.00% | 0.00% | 2400.00 | 9600.00 | 7200.00 | 25.00% | -75.00% | ||||
| Total Professional | 1770.00 | 1300.00 | -470.00 | 136.15% | 36.15% | 3926.00 | 3400.00 | -526.00 | 115.47% | 15.47% | 3926.00 | 12850.00 | 8924.00 | 30.55% | -69.45% | ||||
| Contracted Services | |||||||||||||||||||
| Landscape Mow/Trim | 0.00 | 0.00 | 0.00 | #DIV/0! | #DIV/0! | 1000.00 | 0.00 | -1000.00 | #DIV/0! | #DIV/0! | 1000.00 | 37500.00 | 36500.00 | 2.67% | -97.33% | ||||
| Landscape Mulch | 0.00 | 0.00 | 0.00 | #DIV/0! | #DIV/0! | 0.00 | 0.00 | 0.00 | #DIV/0! | #DIV/0! | 0.00 | 6800.00 | 6800.00 | 0.00% | -100.00% | ||||
| Landscape Tree/Shrub | 0.00 | 0.00 | 0.00 | #DIV/0! | #DIV/0! | 0.00 | 0.00 | 0.00 | #DIV/0! | #DIV/0! | 0.00 | 1400.00 | 1400.00 | 0.00% | -100.00% | ||||
| Landscape Irrigation | 0.00 | 0.00 | 0.00 | #DIV/0! | #DIV/0! | 0.00 | 0.00 | 0.00 | #DIV/0! | #DIV/0! | 0.00 | 600.00 | 600.00 | 0.00% | -100.00% | ||||
| Cleaning Contract | 375.00 | 500.00 | 125.00 | 75.00% | -25.00% | 1275.00 | 1500.00 | 225.00 | 85.00% | -15.00% | 1275.00 | 6000.00 | 4725.00 | 21.25% | -78.75% | ||||
| Exterminator | 0.00 | 0.00 | 0.00 | #DIV/0! | #DIV/0! | 0.00 | 0.00 | 0.00 | #DIV/0! | #DIV/0! | 0.00 | 250.00 | 250.00 | 0.00% | -100.00% | ||||
| Fire Protection | 0.00 | 25.00 | 25.00 | 0.00% | -100.00% | 0.00 | 75.00 | 75.00 | 0.00% | -100.00% | 0.00 | 300.00 | 300.00 | 0.00% | -100.00% | ||||
| Security Service | 0.00 | 33.33 | 33.33 | 0.00% | -100.00% | 0.00 | 100.00 | 100.00 | 0.00% | -100.00% | 0.00 | 400.00 | 400.00 | 0.00% | -100.00% | ||||
| Snow Removal Plow | 159.38 | 300.00 | 140.62 | 53.13% | -46.87% | 462.19 | 1350.00 | 887.81 | 34.24% | -65.76% | 462.19 | 1500.00 | 1037.81 | 30.81% | -69.19% | ||||
| Trash Removal | 70.96 | 70.00 | -0.96 | 101.37% | 1.37% | 141.92 | 210.00 | 68.08 | 67.58% | -32.42% | 141.92 | 840.00 | 698.08 | 16.90% | -83.10% | ||||
| Total Contracted Services | 605.34 | 928.33 | 322.99 | 65.21% | -34.79% | 2879.11 | 3235.00 | 355.89 | 89.00% | -11.00% | 2879.11 | 55590.00 | 52710.89 | 5.18% | -94.82% | ||||
| Maintenance & Repair | |||||||||||||||||||
| Electrical | 500.00 | 83.33 | -416.67 | 600.00% | 500.00% | 500.00 | 250.00 | -250.00 | 200.00% | 100.00% | 500.00 | 1000.00 | 500.00 | 50.00% | -50.00% | ||||
| Miscellaneous | 0.00 | 83.33 | 83.33 | 0.00% | -100.00% | 0.00 | 250.00 | 250.00 | 0.00% | -100.00% | 0.00 | 1000.00 | 1000.00 | 0.00% | -100.00% | ||||
| Lock & Keys | 0.00 | 0.00 | 0.00 | #DIV/0! | #DIV/0! | 0.00 | 0.00 | 0.00 | #DIV/0! | #DIV/0! | 0.00 | 500.00 | 500.00 | 0.00% | -100.00% | ||||
| Pond | 0.00 | 0.00 | 0.00 | #DIV/0! | #DIV/0! | 0.00 | 0.00 | 0.00 | #DIV/0! | #DIV/0! | 0.00 | 500.00 | 500.00 | 0.00% | -100.00% | ||||
| Pool | 0.00 | 0.00 | 0.00 | #DIV/0! | #DIV/0! | 0.00 | 0.00 | 0.00 | #DIV/0! | #DIV/0! | 0.00 | 17000.00 | 17000.00 | 0.00% | -100.00% | ||||
| Recreation Area | 0.00 | 0.00 | 0.00 | #DIV/0! | #DIV/0! | 136.81 | 0.00 | -136.81 | #DIV/0! | #DIV/0! | 136.81 | 2500.00 | 2363.19 | 5.47% | -94.53% | ||||
| Signage | 0.00 | 12.50 | 12.50 | 0.00% | -100.00% | 0.00 | 37.50 | 37.50 | 0.00% | -100.00% | 0.00 | 150.00 | 150.00 | 0.00% | -100.00% | ||||
| Supplies/Housekeeping | 0.00 | 25.00 | 25.00 | 0.00% | -100.00% | 40.25 | 75.00 | 34.75 | 53.67% | -46.33% | 40.25 | 300.00 | 259.75 | 13.42% | -86.58% | ||||
| Carpet Cleaning | 0.00 | 0.00 | 0.00 | #DIV/0! | #DIV/0! | 0.00 | 0.00 | 0.00 | #DIV/0! | #DIV/0! | 0.00 | 350.00 | 350.00 | 0.00% | -100.00% | ||||
| Total Maintenance & Repair | 500.00 | 204.17 | -295.83 | 244.90% | 144.90% | 677.06 | 612.50 | -64.56 | 110.54% | 10.54% | 677.06 | 23300.00 | 22622.94 | 2.91% | -97.09% | ||||
| Utility | |||||||||||||||||||
| Gas | 0.00 | 416.67 | 416.67 | 0.00% | -100.00% | 482.73 | 1250.00 | 767.27 | 38.62% | -61.38% | 482.73 | 5000.00 | 4517.27 | 9.65% | -90.35% | ||||
| Electricity | 113.27 | 300.00 | 186.73 | 37.76% | -62.24% | 495.79 | 900.00 | 404.21 | 55.09% | -44.91% | 495.79 | 3600.00 | 3104.21 | 13.77% | -86.23% | ||||
| Telephone | 42.08 | 41.67 | -0.41 | 100.99% | 0.99% | 126.24 | 125.00 | -1.24 | 100.99% | 0.99% | 126.24 | 500.00 | 373.76 | 25.25% | -74.75% | ||||
| Water | 15.72 | 250.00 | 234.28 | 6.29% | -93.71% | 99.90 | 750.00 | 650.10 | 13.32% | -86.68% | 99.90 | 3000.00 | 2900.10 | 3.33% | -96.67% | ||||
| Water/Sewer | 0.00 | 41.67 | 41.67 | 0.00% | -100.00% | 155.46 | 125.00 | -30.46 | 124.37% | 24.37% | 155.46 | 500.00 | 344.54 | 31.09% | -68.91% | ||||
| Total Utility | 171.07 | 1050.00 | 878.93 | 16.29% | -83.71% | 1360.12 | 3150.00 | 1789.88 | 43.18% | -56.82% | 1360.12 | 12600.00 | 11239.88 | 10.79% | -89.21% | ||||
| Other | |||||||||||||||||||
| Insurance | 0.00 | 0.00 | 0.00 | #DIV/0! | #DIV/0! | 764.25 | 950.00 | 185.75 | 80.45% | -19.55% | 764.25 | 3800.00 | 3035.75 | 20.11% | -79.89% | ||||
| Real Estate Tax | 0.00 | 0.00 | 0.00 | #DIV/0! | #DIV/0! | 2940.66 | 3250.00 | 309.34 | 90.48% | -9.52% | 2940.66 | 6500.00 | 3559.34 | 45.24% | -54.76% | ||||
| Income Tax | 273.00 | 270.00 | -3.00 | 101.11% | 1.11% | 273.00 | 270.00 | -3.00 | 101.11% | 1.11% | 273.00 | 275.00 | 2.00 | 99.27% | -0.73% | ||||
| Total Other | 273.00 | 270.00 | -3.00 | 101.11% | 1.11% | 3977.91 | 4470.00 | 492.09 | 88.99% | -11.01% | 3704.91 | 10300.00 | 6595.09 | 35.97% | -64.03% | ||||
| TOTAL EXPENSE | 4180.24 | 4273.33 | 93.09 | 7.29 | 1.29 | 14555.59 | 16430.00 | 1874.41 | 5.58 | -0.42 | 14282.59 | 120890.00 | 106607.41 | 1.13 | -4.87 | ||||
| CURRENT REVENUE - EXPENSE | 55072.09 | 10993.33 | 44078.76 | 88334.02 | 14370.00 | 73964.02 | 88607.02 | 32310.00 | 56297.02 | ||||||||||