| Oak Creek Homeowners Association - 2005 budget with YTD actual amounts | ||||||||||||||
| Revenue Budget | ||||||||||||||
| 2005 | ||||||||||||||
| Budget | YTD | Jan. | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Income | ||||||||||||||
| Assessments | $64,800.00 | $54,000.00 | $5,400.00 | $5,400.00 | $5,400.00 | $5,400.00 | $5,400.00 | $5,400.00 | $5,400.00 | $5,400.00 | $5,400.00 | $5,400.00 | ||
| Club House Rental | $600.00 | $655.00 | $35.00 | $35.00 | $70.00 | $60.00 | $140.00 | $70.00 | $105.00 | $105.00 | $35.00 | $0.00 | ||
| Interest | $300.00 | $535.95 | $29.31 | $31.76 | $38.79 | $0.00 | $41.31 | $57.00 | $33.53 | $52.84 | $251.41 | $0.00 | ||
| Other | $150.00 | $605.00 | $0.00 | $555.00 | $25.00 | $0.00 | $25.00 | $0.00 | ||||||
| Total Income | $65,850.00 | $55,795.95 | $5,464.31 | $6,021.76 | $5,533.79 | $5,460.00 | $5,581.31 | $5,527.00 | $5,538.53 | $5,557.84 | $5,711.41 | $5,400.00 | $0.00 | $0.00 |
| Accts Receivable | $800.00 | $0.00 | ||||||||||||
| Expense | ||||||||||||||
| Admininstration | $ 19,344.00 | $ 12,186.12 | $ 726.10 | $ 767.76 | $ 729.52 | $ 1,057.79 | $ 709.88 | $ 1,004.50 | $ 4,773.85 | $ 711.56 | $ 996.95 | $ 708.21 | ||
| Pool | $ 14,750.00 | $ 12,063.08 | $ 2,035.06 | $ 4,218.90 | $ 3,391.95 | $ 1,825.35 | $ 591.82 | |||||||
| Grounds | $ 13,710.00 | $12,960.73 | $1,542.00 | $ 5,584.00 | $ 2,679.13 | $ 1,220.00 | $ 1,935.60 | $ - | ||||||
| Clubhouse | $ 13,900.00 | $ 13,925.47 | $ 980.51 | $ 887.28 | $ 785.01 | $ 636.16 | $ 1,254.26 | $ 1,870.53 | $ 2,483.43 | $ 2,521.73 | $ 1,160.66 | $ 1,345.90 | ||
| Other | $ - | |||||||||||||
| Total Expense | $ 61,704.00 | $ 51,135.40 | $ 1,706.61 | $ 3,197.04 | $ 1,514.53 | $ 1,693.95 | $ 1,964.14 | $ 10,494.09 | $ 14,155.31 | $ 7,845.24 | $ 5,918.56 | $ 2,645.93 | ||
| Net Income | $ 4,146.00 | $ 4,660.55 | $ 3,757.70 | $ 2,824.72 | $ 4,019.26 | $ 3,766.05 | $ 3,617.17 | $ (4,967.09) | $ (8,616.78) | $ (2,287.40) | $ (207.15) | $ 2,754.07 | ||
| plus $5k reserve | ||||||||||||||
| built into Admin. | ||||||||||||||
| $555 in Feb. Income =late charges/nsf Income | ||||||||||||||
| Admin. Budget | ||||||||||||||
| 2005 | ||||||||||||||
| Budget | YTD | Jan. | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Mgt. Fee | $7,560.00 | $6,247.50 | $577.50 | $630.00 | $630.00 | $630.00 | $630.00 | $630.00 | $630.00 | $630.00 | $630.00 | $630.00 | ||
| Off. Expense | $1,000.00 | $1,002.39 | $35.00 | $50.00 | $360.57 | $5.50 | $241.74 | $25.00 | $284.58 | |||||
| Copies | $350.00 | $163.20 | $40.80 | $25.50 | $25.50 | $10.20 | $10.20 | $10.20 | $10.20 | $10.20 | $10.20 | $10.20 | ||
| Legal | $350.00 | $5.00 | $5.00 | |||||||||||
| Phone | $300.00 | $239.43 | $20.33 | $21.31 | $20.03 | $20.88 | $20.22 | $20.06 | $27.01 | $29.39 | $31.82 | $28.38 | ||
| Bank Chrge | $50.00 | $0.00 | ||||||||||||
| Postage | $600.00 | $440.96 | $52.47 | $40.95 | $53.99 | $36.14 | $38.96 | $52.84 | $41.83 | $41.97 | $40.35 | $41.46 | ||
| Insurance | $4,000.00 | $4,037.98 | $4,039.81 | -$1.83 | ||||||||||
| RE Taxes | $50.00 | $49.66 | $49.66 | |||||||||||
| Reserve | $5,000.00 | $0.00 | ||||||||||||
| Total YTD | $12,186.12 | |||||||||||||
| Total | $19,260.00 | $12,186.12 | $726.10 | $767.76 | $729.52 | $1,057.79 | $709.88 | $1,004.50 | $4,773.85 | $711.56 | $996.95 | $708.21 | $0.00 | $0.00 |
| Club House Budget | ||||||||||||||
| 2005 | ||||||||||||||
| Budget | YTD | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Exterminator | $ 500.00 | $ - | ||||||||||||
| Gas | $ 8,100.00 | $ 3,238.70 | $ 592.37 | $ 587.48 | $ 481.57 | $ 219.99 | $ 307.41 | $ 189.70 | $ 252.53 | $ - | $ 166.78 | $ 440.87 | ||
| Electric | $ 4,121.07 | $ 171.14 | $ 167.80 | $ 171.44 | $ 134.17 | $ 115.61 | $ 261.72 | $ 794.36 | $ 781.73 | $ 793.13 | $ 729.97 | |||
| Janitorial | $ 1,300.00 | $ 1,290.00 | $ 90.00 | $ 90.00 | $ 90.00 | $ 90.00 | $ 390.00 | $ 90.00 | $ 180.00 | $ 90.00 | $ 90.00 | $ 90.00 | ||
| Maintenance | $ 1,500.00 | $ 1,679.29 | $ 127.00 | $ 42.00 | $ 42.00 | $ 192.00 | $ 441.24 | $ 232.70 | $ 156.54 | $ 250.00 | $ 110.75 | $ 85.06 | ||
| Painting | $ 1,000.00 | $ 1,400.00 | $ 1,400.00 | |||||||||||
| Improvmnts | $ 1,500.00 | $ 2,196.41 | $ 1,096.41 | $ 1,100.00 | ||||||||||
| Other | $ - | $ - | ||||||||||||
| YTD Total | $ 13,925.47 | |||||||||||||
| Total | $ 13,900.00 | $ 13,925.47 | $ 980.51 | $ 887.28 | $ 785.01 | $ 636.16 | $ 1,254.26 | $ 1,870.53 | $ 2,483.43 | $ 2,521.73 | $ 1,160.66 | $ 1,345.90 | $ - | $ - |
| Grounds Budget | ||||||||||||||
| 2005 | ||||||||||||||
| Budget | YTD | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Landscape | $ 8,540.00 | $ 6,104.13 | $ 1,185.00 | $ 1,220.00 | $ 1,259.13 | $ 1,220.00 | $ 1,220.00 | $ - | ||||||
| Improvemnts | $ 5,470.00 | $ 6,499.60 | $ 4,364.00 | $ 1,420.00 | $ 715.60 | |||||||||
| Pond Maint. | $ - | $ - | ||||||||||||
| Snow | $ 300.00 | $ 357.00 | $ 357.00 | |||||||||||
| Tennis Court | $ - | $ - | ||||||||||||
| YTD Total | $ 12,960.73 | |||||||||||||
| Total | $ 14,310.00 | $ 12,960.73 | $ - | $ 1,542.00 | $ - | $ - | $ - | $ 5,584.00 | $ 2,679.13 | $ 1,220.00 | $ 1,935.60 | $ - | $ - | $ - |
| $5470 improvements is $3500 re-gravel, $1370 sealcoat. | ||||||||||||||
| actual= $4364 re-gravel, $1420 sealcoat | ||||||||||||||
| Pool Budget | ||||||||||||||
| 2005 | ||||||||||||||
| Budget | YTD | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Payroll | $ 7,500.00 | $ 8,446.05 | $ 2,313.89 | $ 2,328.01 | $ 2,235.88 | $ 1,568.27 | ||||||||
| Payroll Tax | $ 750.00 | $ 807.31 | $ (352.43) | $ 244.77 | $ 106.07 | $ 217.08 | $ 591.82 | |||||||
| Maintenance | $ 1,000.00 | $ 73.60 | $ 73.60 | |||||||||||
| Open/Close | $ 1,000.00 | $ 1,090.00 | $ 1,050.00 | $ 40.00 | ||||||||||
| Improvmnts | $ 500.00 | $ - | ||||||||||||
| Scavenger | $ - | |||||||||||||
| Repar/supply | $ 4,000.00 | $ 1,646.12 | $ 1,646.12 | |||||||||||
| YTD Total | $ 12,063.08 | |||||||||||||
| Total | $ 14,750.00 | $ 12,063.08 | $ - | $ - | $ - | $ - | $ - | $ 2,035.06 | $ 4,218.90 | $ 3,391.95 | $ 1,825.35 | $ 591.82 | $ - | $ - |