OAK Creek 2008
Revenue Budget
2008
 
  Budget YTD Jan. Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Income                            
Assessments  $ 64,800.00  $    64,800.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 $5,400.00 $5,400.00
Club House Rental  $      600.00  $         855.00      $        100.00  $         190.00    $           85.00  $         100.00 $100.00 $50.00     $130.00 $100.00
Interest  $   1,500.00  $      1,685.95    $          70.18  $             5.64  $          21.52  $           23.63  $           24.53 $17.39 $1,116.17   $20.54   $386.35
Other  $      500.00  $           95.00  $           75.00  $        (50.00)      $           25.00         $45.00    
YTD    $    67,435.95                        
Total Income  $ 67,400.00  $    67,435.95  $      5,475.00  $     5,520.18  $      5,595.64  $     5,421.52  $      5,533.63  $      5,524.53 $5,517.39 $6,566.17 $5,400.00 $5,465.54 $5,530.00 $5,886.35
Accts Receivable                            
Expense
Admininstration  $ 13,710.00  $    13,625.88  $         972.52  $        671.85  $      1,044.06  $     1,011.92  $         745.89  $         810.69  $      3,963.95  $         729.65  $      1,028.76  $      1,116.61  $         782.23  $         747.75
Pool  $ 18,745.00  $    17,548.01              $      2,295.49  $      4,232.26  $      5,360.80  $      2,475.84  $      2,234.34  $         949.28  $                -      
Grounds  $ 17,860.00  $    19,024.46  $         647.44    $      1,462.50      $      1,357.50  $      1,357.50  $      3,085.50  $      1,726.50  $      5,021.00  $      1,497.11  $      1,511.91  $      1,357.50
Clubhouse  $ 13,400.00  $    11,485.18  $         826.01  $     1,663.38  $      1,505.78  $        618.28  $         809.85  $      1,048.83  $       (952.81)  $      1,503.20  $      1,612.28  $         885.56  $         629.31  $      1,335.51
Other                            
YTD    $    61,683.53                        
Total Expense  $ 63,715.00  $    61,683.53  $      2,445.97  $     2,335.23  $      4,012.34  $     1,630.20  $      5,208.73  $      7,449.28  $    11,457.44  $      6,435.19  $      9,896.38  $      4,448.56  $      2,923.45  $      3,440.76
Net Income  $   3,685.00  $      5,752.42  $      3,029.03  $     3,184.95  $      1,583.30  $     3,791.32  $         324.90  $    (1,924.75)  $    (5,940.05)  $         130.98  $    (4,496.38)  $      1,016.98  $      2,606.55  $      2,445.59
     
     
2007
CURRENT  ASSETS  year end 
Checking    $      5,724.74  $      9,253.77  $   15,327.07  $    23,945.87  $   28,744.17  $      5,004.10  $      5,112.90  $      1,597.80  $         (60.29)  $         187.42  $      1,464.92  $      3,696.47  $      5,988.38
Money Market    $    18,300.19  $    18,300.19  $   18,364.34  $    18,364.34  $   18,385.86  $    18,402.33  $    18,418.78  $    18,433.83  $    18,461.85  $      5,861.85  $      5,881.33  $      5,881.33  $      5,890.75
CD    $    27,250.84  $    27,250.84  $   27,250.84  $    27,250.84  $   27,250.84  $    27,250.84  $    27,250.84  $    27,250.84  $    28,336.89  $    28,336.89  $    28,336.89  $    28,336.89  $    28,711.15
A/R Assessments    $      3,175.00  $      1,850.00  $        135.00  $         660.00  $        525.00  $         100.00  $         125.00  $       (100.00)  $         850.00  $         550.00  $         450.00  $         825.00  $         595.00
a/r non current                                        
Special Assess.      $       825.00  $        75.00  $ 16,660.00  $   9,617.50  $   5,315.00  $   3,240.00  $   1,000.00  $       750.00  $       700.00  $       475.00  $       475.00  $       475.00
Late Fee/ NSF                  $         25.00      $         45.00  $         45.00  $         45.00
Total  Assets  $ 58,135.77  $ 54,450.77  $ 57,479.80  $61,152.25  $ 86,881.05  $84,523.37  $ 56,072.27  $ 54,147.52  $ 48,207.47  $ 48,338.45  $ 35,636.16  $ 36,653.14  $ 39,259.69  $ 41,705.28
     
Admin. Budget
2008
 
  Budget YTD Jan. Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
                             
Mgt. Fee $7,560.00 $7,560.00 $630.00 $630.00 $630.00 $630.00 $630.00 $630.00 $630.00 $630.00 $630.00 $630.00 $630.00 $630.00
Off. Expense $1,100.00 $964.04 $150.00 $40.00 $324.58   $39.94 $30.00 $5.00   $294.58   $54.94 $25.00
Copies $300.00 $224.55 $66.30 $30.75 $15.30 $10.20   $20.40 $10.20 $10.20 $10.20 $10.20 $20.40 $20.40
Legal $400.00 $575.00   -$75.00   $300.00           $350.00    
Phone $350.00 $421.89 $67.75 $2.04 $28.86 $28.86 $29.06 $29.40 $42.65 $40.86 $47.32 $47.15 $28.97 $28.97
Bank Chrge $0.00 $9.00   $4.50       $9.00   -$4.50        
Postage $650.00 $589.53 $58.47 $39.56 $45.32 $42.86 $46.89 $39.53 $59.59 $53.09 $46.66 $66.26 $47.92 $43.38
Insurance $3,300.00 $3,216.51             $3,216.51          
RE Taxes $50.00 $52.36           $52.36            
Capital $0.00 $0.00                        
Other $0.00 $13.00                   $13.00    
Total YTD   $13,625.88                        
Total $13,710.00 $13,625.88 $972.52 $671.85 $1,044.06 $1,011.92 $745.89 $810.69 $3,963.95 $729.65 $1,028.76 $1,116.61 $782.23 $747.75
Club House Budget
2008
  Budget YTD Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
                             
Exterminator  $      500.00  $         375.44    $        375.44                      
Gas  $   7,500.00  $      5,047.71  $         497.95  $        665.34  $         695.11  $        343.70  $         379.92  $         541.24  $         472.95  $         443.25  $         398.68  $           78.90  $         345.68  $         184.99
Electric    $      4,562.98  $         193.06  $        165.34  $         177.20  $        139.58  $         164.55  $         283.74  $         673.89  $         890.71  $         711.65  $         671.66  $           58.60  $         433.00
Janitorial  $   1,400.00  $      1,170.00  $           90.00  $          90.00  $           90.00  $          90.00  $         180.00  $           90.00  $           90.00  $           90.00  $           90.00  $           90.00  $           90.00  $           90.00
Maintenance  $   3,000.00  $       (437.73)  $           45.00  $        105.00  $           68.47  $          45.00  $           85.38  $         133.85  $    (2,189.65)  $           79.24  $         411.95  $           45.00  $         135.03  $         598.00
Painting    $                -                            
Improvmnts  $   1,000.00  $         591.18    $        116.18  $         475.00                    
Capital    $                -                              
Other  $              -    $         175.60      $        146.08                        $           29.52
YTD Total    $    11,485.18                        
Total  $ 13,400.00  $    11,485.18  $         826.01  $     1,663.38  $      1,505.78  $        618.28  $         809.85  $      1,048.83  $       (952.81)  $      1,503.20  $      1,612.28  $         885.56  $         629.31  $      1,335.51
Grounds Budget
2008
  Budget YTD Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
                             
Landscape  $ 10,860.00  $    10,860.00    $                -        $      1,357.50  $      1,357.50  $      1,357.50  $      1,357.50  $      1,357.50  $      1,357.50  $      1,357.50  $      1,357.50
Improvemnts  $   5,500.00  $      3,405.50    $                -                    $      3,405.50      
playground.  $              -    $                -      $                -                        
Snow  $   1,500.00  $      2,080.00  $         617.50  $                -    $      1,462.50                  
Tennis Court  $              -        $                -                      
Misc.    $      2,678.96  $           29.94  $                -            $      1,728.00  $         369.00  $         258.00  $         139.61  $         154.41  
YTD Total    $    19,024.46    $                -                      
Total  $ 17,860.00  $    19,024.46  $         647.44  $                -    $      1,462.50    $      1,357.50  $      1,357.50  $      3,085.50  $      1,726.50  $      5,021.00  $      1,497.11  $      1,511.91  $      1,357.50
Pool Budget
2008
  Budget YTD Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
                             
Payroll  $ 10,000.00  $    11,217.51              $      3,125.44  $      4,237.24  $      2,235.38  $      1,560.32  $           59.13  $                -    
Payroll Tax  $   1,100.00  $         942.44            $       (419.88)  $         335.56  $         137.08  $         574.02  $         315.66    
Maintenance  $   1,000.00  $      2,789.04          $         685.75  $      1,526.70  $         323.72  $         103.38  $         100.00  $           49.49    
Open/Close  $   1,300.00  $      1,295.00          $         770.00            $         525.00    
Improvmnts  $   5,345.00            $         839.74              
Scavenger  $              -                            
Repairs  $              -                  $         464.28            
YTD Total    $    16,243.99                        
Total  $ 18,745.00  $    17,548.01  $                -        $                -    $      2,295.49  $      4,232.26  $      5,360.80  $      2,475.84  $      2,234.34  $         949.28  $                -    $                -  
 
 
  Cap. Budget
2008
  Budget YTD Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
                             
Income  $ 32,400.00  $    38,107.50  $         750.00  $          75.00  $    16,660.00  $     9,617.50  $      5,315.00  $      3,240.00  $      1,000.00  $         750.00  $         700.00        
                             
Well    $      3,049.00        $     3,049.00                    
Fence    $      8,800.00        $     3,100.00  $      5,700.00                
Pool    $                -                                  
Tennis    $    38,973.91      $      7,692.00    $    23,076.00        $      8,205.91      
Clubhouse    $                -                                
                             
Total Exp.    $    50,822.91        $      7,692.00  $     6,149.00  $    28,776.00            $      8,205.91