| Operating Fund - Detail | January 2006 | ||||||||||||||||||
| Current Feriod | 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 | 29458.38 | 7500.00 | 21958.38 | 392.78% | 292.78% | 29458.38 | 7500.00 | 21958.38 | 392.78% | 292.78% | 29458.38 | 150000.00 | -120541.62 | 19.64% | -80.36% | ||||
| Clubhouse Rental | 120.00 | 250.00 | -130.00 | 48.00% | -52.00% | 120.00 | 250.00 | -130.00 | 48.00% | -52.00% | 120.00 | 3000.00 | -2880.00 | 4.00% | -96.00% | ||||
| Miscellaneous Income | 171.73 | 16.67 | 155.06 | 1030.38% | 930.38% | 171.73 | 16.67 | 155.06 | 1030.38% | 930.38% | 171.73 | 200.00 | -28.27 | 85.87% | -14.14% | ||||
| Carryover Expense from 2003 | |||||||||||||||||||
| TOTAL REVENUE | 29750.11 | 7766.67 | 21983.44 | 383.05% | 283.05% | 29750.11 | 7766.67 | 21983.44 | 383.05% | 283.05% | 29750.11 | 153200.00 | -123449.89 | 19.42% | -80.58% | ||||
| Expenses | |||||||||||||||||||
| Administrative | |||||||||||||||||||
| Postage | 62.29 | 125.00 | 62.71 | 49.83% | -50.17% | 62.29 | 125.00 | 62.71 | 49.83% | -50.17% | 62.29 | 1500.00 | 1437.71 | 4.15% | -95.85% | ||||
| Printing | 583.56 | 250.00 | -333.56 | 233.42% | 133.42% | 583.56 | 250.00 | -333.56 | 233.42% | 133.42% | 583.56 | 3000.00 | 2416.44 | 19.45% | -80.55% | ||||
| Dues & License Fees | 0.00 | 29.17 | 29.17 | 0.00% | -100.00% | 0.00 | 29.17 | 29.17 | 0.00% | -100.00% | 0.00 | 350.00 | 350.00 | 0.00% | -100.00% | ||||
| Misc / Admin | 80.34 | 16.67 | -63.67 | 482.04% | 382.04% | 80.34 | 16.67 | -63.67 | 482.04% | 382.04% | 80.34 | 200.00 | 119.66 | 40.17% | -59.83% | ||||
| Annual/Monthly Meetings | 0.00 | 16.67 | 16.67 | 0.00% | -100.00% | 0.00 | 16.67 | 16.67 | 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 | 83.33 | 83.33 | 0.00% | -100.00% | 0.00 | 1000.00 | 1000.00 | 0.00% | -100.00% | ||||
| Total Administrative | 726.19 | 520.83 | -205.36 | 139.43% | 39.43% | 726.19 | 520.83 | -205.36 | 139.43% | 39.43% | 726.19 | 6250.00 | 5523.81 | 11.62% | -88.38% | ||||
| 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 | 400.00 | 250.00 | -150.00 | 160.00% | 60.00% | 400.00 | 250.00 | -150.00 | 160.00% | 60.00% | 400.00 | 3000.00 | 2600.00 | 13.33% | -86.67% | ||||
| Management | 800.00 | 800.00 | 0.00 | 100.00% | 0.00% | 800.00 | 800.00 | 0.00 | 100.00% | 0.00% | 800.00 | 9600.00 | 8800.00 | 8.33% | -91.67% | ||||
| Total Professional | 1200.00 | 1050.00 | -150.00 | 114.29% | 14.29% | 1200.00 | 1050.00 | -150.00 | 114.29% | 14.29% | 1200.00 | 12850.00 | 11650.00 | 9.34% | -90.66% | ||||
| Contracted Services | |||||||||||||||||||
| Landscape Mow/Trim | 1000.00 | 0.00 | -1000.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% | 450.00 | 500.00 | 50.00 | 90.00% | -10.00% | 450.00 | 6000.00 | 5550.00 | 7.50% | -92.50% | ||||
| 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 | 25.00 | 25.00 | 0.00% | -100.00% | 0.00 | 300.00 | 300.00 | 0.00% | -100.00% | ||||
| Security Services | 0.00 | 33.33 | 33.33 | 0.00% | -100.00% | 0.00 | 33.33 | 33.33 | 0.00% | -100.00% | 0.00 | 400.00 | 400.00 | 0.00% | -100.00% | ||||
| Snow Removal Plow | 302.81 | 600.00 | 297.19 | 50.47% | -49.53% | 302.81 | 600.00 | 297.19 | 50.47% | -49.53% | 302.81 | 1500.00 | 1197.19 | 20.19% | -79.81% | ||||
| Trash Removal | 0.00 | 70.00 | 70.00 | 0.00% | -100.00% | 0.00 | 70.00 | 70.00 | 0.00% | -100.00% | 0.00 | 840.00 | 840.00 | 0.00% | -100.00% | ||||
| Total Contracted Services | 1752.81 | 1228.33 | -524.48 | 142.70% | 42.70% | 1752.81 | 1228.33 | -524.48 | 142.70% | 42.70% | 1752.81 | 55590.00 | 53837.19 | 3.15% | -96.85% | ||||
| Maintenance & Repair | |||||||||||||||||||
| Electrical | 0.00 | 83.33 | 83.33 | 0.00% | -100.00% | 0.00 | 83.33 | 83.33 | 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 | 83.33 | 83.33 | 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! | 0.00 | 0.00 | 0.00 | #DIV/0! | #DIV/0! | 0.00 | 2500.00 | 2500.00 | 0.00% | -100.00% | ||||
| Signage | 0.00 | 12.50 | 12.50 | 0.00% | -100.00% | 0.00 | 12.50 | 12.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% | 0.00 | 25.00 | 25.00 | 0.00% | -100.00% | 0.00 | 300.00 | 300.00 | 0.00% | -100.00% | ||||
| 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 | 0.00 | 204.17 | 204.17 | 0.00% | -100.00% | 0.00 | 204.17 | 204.17 | 0.00% | -100.00% | 0.00 | 23300.00 | 23300.00 | 0.00% | -100.00% | ||||
| Utility | |||||||||||||||||||
| Gas | 0.00 | 416.67 | 416.67 | 0.00% | -100.00% | 0.00 | 416.67 | 416.67 | 0.00% | -100.00% | 0.00 | 5000.00 | 5000.00 | 0.00% | -100.00% | ||||
| Electricity | 156.32 | 300.00 | 143.68 | 52.11% | -47.89% | 156.32 | 300.00 | 143.68 | 52.11% | -47.89% | 156.32 | 3600.00 | 3443.68 | 4.34% | -95.66% | ||||
| Telephone | 42.08 | 41.67 | -0.41 | 100.99% | 0.99% | 42.08 | 41.67 | -0.41 | 100.99% | 0.99% | 42.08 | 500.00 | 457.92 | 8.42% | -91.58% | ||||
| Water | 42.09 | 250.00 | 207.91 | 16.84% | -83.16% | 42.09 | 250.00 | 207.91 | 16.84% | -83.16% | 42.09 | 3000.00 | 2957.91 | 1.40% | -98.60% | ||||
| Water/Sewer | 77.73 | 41.67 | -36.06 | 186.55% | 86.55% | 77.73 | 41.67 | -36.06 | 186.55% | 86.55% | 77.73 | 500.00 | 422.27 | 15.55% | -84.45% | ||||
| Total Utility | 318.22 | 1050.00 | 731.78 | 30.31% | -69.69% | 318.22 | 1050.00 | 731.78 | 30.31% | -69.69% | 318.22 | 12600.00 | 12281.78 | 2.53% | -97.47% | ||||
| Other | |||||||||||||||||||
| Insurance | 0.00 | 0.00 | 0.00 | #DIV/0! | #DIV/0! | 0.00 | 0.00 | 0.00 | #DIV/0! | #DIV/0! | 0.00 | 3800.00 | 3800.00 | 0.00% | -100.00% | ||||
| Real Estate Tax | 2940.66 | 3250.00 | 309.34 | 90.48% | -9.52% | 2940.66 | 3250.00 | 309.34 | 90.48% | -9.52% | 2940.66 | 6500.00 | 3559.34 | 45.24% | -54.76% | ||||
| Total Other | 2940.66 | 3250.00 | 309.34 | 90.48% | -9.52% | 2940.66 | 3250.00 | 309.34 | 90.48% | -9.52% | 2940.66 | 10300.00 | 7359.34 | 28.55% | -71.45% | ||||
| TOTAL EXPENSE | 6937.88 | 7303.33 | 365.45 | 5.17 | -0.83 | 6937.88 | 7303.33 | 365.45 | 5.17 | -0.83 | 6937.88 | 120890.00 | 113952.12 | 0.55 | -5.45 | ||||
| CURRENT REVENUE - EXPENSE | 22812.23 | 463.33 | 22348.90 | 22812.23 | 463.33 | 22348.90 | 22812.23 | 32310.00 | -9497.77 | ||||||||||