| Operating Fund - Detail | February 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 (Cash) | 13514.19 | 7500.00 | 6014.19 | 180.19% | 80.19% | 42972.57 | 15000.00 | 27972.57 | 286.48% | 186.48% | 42972.57 | 150000.00 | -107027.43 | 28.65% | -71.35% | ||||
| Clubhouse Rental | 225.00 | 250.00 | -25.00 | 90.00% | -10.00% | 345.00 | 500.00 | -155.00 | 69.00% | -31.00% | 345.00 | 3000.00 | -2655.00 | 11.50% | -88.50% | ||||
| Miscellaneous Income | 147.98 | 16.67 | 131.31 | 887.88% | 787.88% | 319.71 | 33.33 | 286.38 | 959.13% | 859.13% | 319.71 | 200.00 | 119.71 | 159.86% | 59.86% | ||||
| Carryover Expense from 2003 | |||||||||||||||||||
| TOTAL REVENUE | 13887.17 | 7766.67 | 6120.50 | 178.80% | 78.80% | 43637.28 | 15533.33 | 28103.95 | 280.93% | 180.93% | 43637.28 | 153200.00 | -109562.72 | 28.48% | -71.52% | ||||
| Expenses | |||||||||||||||||||
| Administrative | |||||||||||||||||||
| Postage | 18.03 | 125.00 | 106.97 | 14.42% | -85.58% | 80.32 | 250.00 | 169.68 | 32.13% | -67.87% | 80.32 | 1500.00 | 1419.68 | 5.35% | -94.65% | ||||
| Printing | 116.70 | 250.00 | 133.30 | 46.68% | -53.32% | 700.26 | 500.00 | -200.26 | 140.05% | 40.05% | 700.26 | 3000.00 | 2299.74 | 23.34% | -76.66% | ||||
| Dues & License Fees | 0.00 | 29.17 | 29.17 | 0.00% | -100.00% | 0.00 | 58.33 | 58.33 | 0.00% | -100.00% | 0.00 | 350.00 | 350.00 | 0.00% | -100.00% | ||||
| Misc / Admin | 13.64 | 16.67 | 3.03 | 81.84% | -18.16% | 93.98 | 33.33 | -60.65 | 281.94% | 181.94% | 93.98 | 200.00 | 106.02 | 46.99% | -53.01% | ||||
| Annual/Monthly Meetings | 0.00 | 16.67 | 16.67 | 0.00% | -100.00% | 0.00 | 33.33 | 33.33 | 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 | 166.67 | 166.67 | 0.00% | -100.00% | 0.00 | 1000.00 | 1000.00 | 0.00% | -100.00% | ||||
| Total Administrative | 148.37 | 520.83 | 372.46 | 28.49% | -71.51% | 874.56 | 1041.67 | 167.11 | 83.96% | -16.04% | 874.56 | 6250.00 | 5375.44 | 13.99% | -86.01% | ||||
| Professional | |||||||||||||||||||
| Audit & Accounting | 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% | ||||
| Legal | 156.00 | 250.00 | 94.00 | 62.40% | -37.60% | 556.00 | 500.00 | -56.00 | 111.20% | 11.20% | 556.00 | 3000.00 | 2444.00 | 18.53% | -81.47% | ||||
| Management | 800.00 | 800.00 | 0.00 | 100.00% | 0.00% | 1600.00 | 1600.00 | 0.00 | 100.00% | 0.00% | 1600.00 | 9600.00 | 8000.00 | 16.67% | -83.33% | ||||
| Total Professional | 956.00 | 1050.00 | 94.00 | 91.05% | -8.95% | 2156.00 | 2100.00 | -56.00 | 102.67% | 2.67% | 2156.00 | 12850.00 | 10694.00 | 16.78% | -83.22% | ||||
| 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 | 450.00 | 500.00 | 50.00 | 90.00% | -10.00% | 900.00 | 1000.00 | 100.00 | 90.00% | -10.00% | 900.00 | 6000.00 | 5100.00 | 15.00% | -85.00% | ||||
| 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 | 50.00 | 50.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 | 66.67 | 66.67 | 0.00% | -100.00% | 0.00 | 400.00 | 400.00 | 0.00% | -100.00% | ||||
| Snow Removal Plow | 0.00 | 450.00 | 450.00 | 0.00% | -100.00% | 302.81 | 1050.00 | 747.19 | 28.84% | -71.16% | 302.81 | 1500.00 | 1197.19 | 20.19% | -79.81% | ||||
| Trash Removal | 70.96 | 70.00 | -0.96 | 101.37% | 1.37% | 70.96 | 140.00 | 69.04 | 50.69% | -49.31% | 70.96 | 840.00 | 769.04 | 8.45% | -91.55% | ||||
| Total Contracted Services | 520.96 | 1078.33 | 557.37 | 48.31% | -51.69% | 2273.77 | 2306.67 | 32.90 | 98.57% | -1.43% | 2273.77 | 55590.00 | 53316.23 | 4.09% | -95.91% | ||||
| Maintenance & Repair | |||||||||||||||||||
| Electrical | 0.00 | 83.33 | 83.33 | 0.00% | -100.00% | 0.00 | 166.67 | 166.67 | 0.00% | -100.00% | 0.00 | 1000.00 | 1000.00 | 0.00% | -100.00% | ||||
| Miscellaneous | 0.00 | 83.33 | 83.33 | 0.00% | -100.00% | 0.00 | 166.67 | 166.67 | 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 | 136.81 | 0.00 | -136.81 | #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 | 25.00 | 25.00 | 0.00% | -100.00% | 0.00 | 150.00 | 150.00 | 0.00% | -100.00% | ||||
| Supplies/Housekeeping | 40.25 | 25.00 | -15.25 | 161.00% | 61.00% | 40.25 | 50.00 | 9.75 | 80.50% | -19.50% | 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 | 177.06 | 204.17 | 27.11 | 86.72% | -13.28% | 177.06 | 408.33 | 231.27 | 43.36% | -56.64% | 177.06 | 23300.00 | 23122.94 | 0.76% | -99.24% | ||||
| Utility | |||||||||||||||||||
| Gas | 482.73 | 416.67 | -66.06 | 115.86% | 15.86% | 482.73 | 833.33 | 350.60 | 57.93% | -42.07% | 482.73 | 5000.00 | 4517.27 | 9.65% | -90.35% | ||||
| Electricity | 226.20 | 300.00 | 73.80 | 75.40% | -24.60% | 382.52 | 600.00 | 217.48 | 63.75% | -36.25% | 382.52 | 3600.00 | 3217.48 | 10.63% | -89.37% | ||||
| Telephone | 42.08 | 41.67 | -0.41 | 100.99% | 0.99% | 84.16 | 83.33 | -0.83 | 100.99% | 0.99% | 84.16 | 500.00 | 415.84 | 16.83% | -83.17% | ||||
| Water | 42.09 | 250.00 | 207.91 | 16.84% | -83.16% | 84.18 | 500.00 | 415.82 | 16.84% | -83.16% | 84.18 | 3000.00 | 2915.82 | 2.81% | -97.19% | ||||
| Water/Sewer | 77.73 | 41.67 | -36.06 | 186.55% | 86.55% | 155.46 | 83.33 | -72.13 | 186.55% | 86.55% | 155.46 | 500.00 | 344.54 | 31.09% | -68.91% | ||||
| Total Utility | 870.83 | 1050.00 | 179.17 | 82.94% | -17.06% | 1189.05 | 2100.00 | 910.95 | 56.62% | -43.38% | 1189.05 | 12600.00 | 11410.95 | 9.44% | -90.56% | ||||
| Other | |||||||||||||||||||
| Insurance | 764.25 | 950.00 | 185.75 | 80.45% | -19.55% | 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% | ||||
| Total Other | 764.25 | 950.00 | 185.75 | 80.45% | -19.55% | 3704.91 | 4200.00 | 495.09 | 88.21% | -11.79% | 3704.91 | 10300.00 | 6595.09 | 35.97% | -64.03% | ||||
| TOTAL EXPENSE | 3437.47 | 4853.33 | 1415.86 | 4.18 | -1.82 | 10375.35 | 12156.67 | 1781.32 | 4.73 | -1.27 | 10375.35 | 120890.00 | 110514.65 | 0.81 | -5.19 | ||||
| CURRENT REVENUE - EXPENSE | 10449.70 | 2913.33 | 7536.37 | 33261.93 | 3376.67 | 29885.26 | 33261.93 | 32310.00 | 951.93 | ||||||||||