| INCOME as of | 30-Nov-11 | ||||||||||||||||||
| Line | Item | Budget | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | % Rcvd | $ Rcvd | $ Remain | ||
| 1 | Assessment | 102,414.00 | 45,700.00 | 3,545.10 | 1,961.90 | 1,211.85 | 303.00 | 403.15 | 44,843.70 | 808.00 | 707.00 | 1,829.71 | 1,031.30 | 100% | ######### | 69.29 | |||
| 2 | Other Fees | 0.00 | 120.18 | 131.30 | 12.00 | 125.00 | 25.00 | N/A | 413.48 | (413.48) | |||||||||
| 4 | Interest - Savings | 0.00 | 37.85 | 34.50 | 31.21 | 22.37 | 20.97 | 20.28 | 26.16 | 27.38 | 24.24 | 16.71 | 8.25 | N/A | 269.92 | (269.92) | |||
| 5 | Interest - Investment | 0.00 | N/A | 0.00 | 0.00 | ||||||||||||||
| 6 | Refunds/Rebates | 0.00 | N/A | 0.00 | 0.00 | ||||||||||||||
| 7 | Other Income | 0.00 | N/A | 0.00 | 0.00 | ||||||||||||||
| Monthly Total | 45,737.85 | 3,699.78 | 2,124.41 | 1,234.22 | 323.97 | 423.43 | 44,881.86 | 835.38 | 731.24 | 1,971.42 | 1,064.55 | 101% | ######### | (614.11) | |||||
| Running Total | 45,737.85 | 49,437.63 | 51,562.04 | 52,796.26 | 53,120.23 | 53,543.66 | 98,425.52 | 99,260.90 | 99,992.14 | ######### | ######### | ######### | |||||||
| Target Total | 51,207.00 | 51,207.00 | 51,207.00 | 51,207.00 | 51,207.00 | 51,207.00 | ######### | ######### | ######### | ######### | ######### | ######### | |||||||
| EXPENSES as of | 30-Nov-11 | ||||||||||||||||||
| Line | Item | Budget | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | % Exp | $ Expend | $ Remain | ||
| 1 | Postage | 300.00 | 44.00 | 44.00 | 40.86 | 56.66 | 88.00 | 91% | 273.52 | 26.48 | |||||||||
| 2 | Printing/Paper | 50.00 | 0.30 | 15.27 | 46.69 | 125% | 62.26 | (12.26) | |||||||||||
| 3 | Safety Deposit | 45.00 | 0% | 0.00 | 45.00 | ||||||||||||||
| 4 | Letter head/Envelopes | 50.00 | 0.35 | 9.88 | 55.10 | 131% | 65.33 | (15.33) | |||||||||||
| 5 | Office Supplies | 100.00 | 0% | 0.00 | 100.00 | ||||||||||||||
| 6 | Accounting/Tax Prep | 0.00 | 5.00 | N/A | 5.00 | (5.00) | |||||||||||||
| 7 | Income Tax - State | 0.00 | N/A | 0.00 | 0.00 | ||||||||||||||
| 7 | Income Tax - Federal | 0.00 | N/A | 0.00 | 0.00 | ||||||||||||||
| 8 | Insurance | 1,450.00 | 1,430.00 | 99% | 1,430.00 | 20.00 | |||||||||||||
| 9 | Legal Fees | 500.00 | 0% | 0.00 | 500.00 | ||||||||||||||
| 10 | Checking System | 75.00 | 75.00 | 100% | 75.00 | 0.00 | |||||||||||||
| 11 | Lawn Care/Landscape | 23,500.00 | 1,752.00 | 1,752.00 | 1,752.00 | 1,752.00 | 1,752.00 | 1,752.00 | 1,752.00 | 1,752.00 | 1,752.00 | 1,752.00 | 1,752.00 | 82% | 19,272.00 | 4,228.00 | |||
| 12 | Spring Clean/Storm | 800.00 | 19.00 | 600.00 | 100.00 | 325.00 | 550.00 | 2,340.00 | 492% | 3,934.00 | (3,134.00) | ||||||||
| 13 | Facility Rental | 160.00 | 180.00 | 113% | 180.00 | (20.00) | |||||||||||||
| 14 | Trash Removal | 48,300.00 | 3,920.50 | 3,920.50 | 3,920.50 | 3,920.50 | 3,920.50 | 3,920.50 | 3,920.50 | 3,920.50 | 3,920.50 | 3,920.50 | 3,920.50 | 89% | 43,125.50 | 5,174.50 | |||
| 15 | Utilities (SMECO) | 5,750.00 | 518.62 | 542.63 | 525.55 | 451.51 | 457.35 | 417.56 | 434.17 | 373.47 | 392.57 | 524.02 | 485.67 | 89% | 5,123.12 | 626.88 | |||
| 16 | Mosquito Control | 300.00 | 472.71 | 158% | 472.71 | (172.71) | |||||||||||||
| 17 | Social Committee | 200.00 | 0% | 0.00 | 200.00 | ||||||||||||||
| 18 | Miscellaneous | 200.00 | 47.00 | 24% | 47.00 | 153.00 | |||||||||||||
| 19 | Seal Coating | 7,617.00 | 4,684.00 | 425.00 | 67% | 5,109.00 | 2,508.00 | ||||||||||||
| 20 | Street Signs | 100.00 | 135.00 | 85.33 | 220% | 220.33 | (120.33) | ||||||||||||
| 21 | Light Posts - Painted | 100.00 | 0% | 0.00 | 100.00 | ||||||||||||||
| 22 | Mailboxes | 100.00 | 0% | 0.00 | 100.00 | ||||||||||||||
| 23 | Playground | 100.00 | 500.00 | 129.84 | 330.44 | 960% | 960.28 | (860.28) | |||||||||||
| 24 | Electrical Repair | 1,000.00 | 385.00 | 485.00 | 87% | 870.00 | 130.00 | ||||||||||||
| 25 | Street Repair | 7,617.00 | 19,550.00 | 257% | 19,550.00 | ######### | |||||||||||||
| 26 | Side-walk Repair | 0.00 | N/A | 0.00 | 0.00 | ||||||||||||||
| 27 | Snow Removal | 1,500.00 | 637.50 | 43% | 637.50 | 862.50 | |||||||||||||
| 28 | Tree Removal | 2,500.00 | 950.00 | 4,850.00 | 232% | 5,800.00 | (3,300.00) | ||||||||||||
| Monthly Total | 7,957.62 | 6,220.13 | 8,100.76 | 6,643.01 | 6,173.85 | 10,774.06 | 6,706.67 | 7,014.65 | 6,830.34 | 12,600.19 | 28,191.27 | 105% | ######### | (4,798.55) | |||||
| Running Total | 7,957.62 | 14,177.75 | 22,278.51 | 28,921.52 | 35,095.37 | 45,869.43 | 52,576.10 | 59,590.75 | 66,421.09 | 79,021.28 | ######### | ######### | |||||||
| Target Total | 8,534.50 | 17,069.00 | 25,603.50 | 34,138.00 | 42,672.50 | 51,207.00 | 59,741.50 | 68,276.00 | 76,810.50 | 85,345.00 | 93,879.50 | ######### | |||||||