Henry County Board of Commissioners
Cotton Fields Financials 2009
Jan-09 Feb-09 Mar-09 Apr-09 May-09 Jun-09 Jul-09 Aug-09 Sep-09 Oct-09 Nov-09 Dec-09 Totals 09
Income
401 Sales - Green Fees    20,377.23     30,824.37     47,626.54    55,637.00      36,002.10      72,925.02      83,656.70      81,800.02     53,242.67    48,737.07    48,682.26     14,422.86     593,933.84
402 Sales - Cart Rental          136.41           532.44        1,507.41      2,544.40        2,395.50        4,261.89        3,641.15        3,744.02        1,885.52      1,509.21      1,709.41           479.82        24,347.18
403 Sales - Pro Shop          881.48        1,523.11        2,577.51      4,094.34        4,062.75        7,389.90        4,980.00        3,727.67        2,741.88      4,622.60      2,023.07        1,199.17        39,823.48
404 Sales - Grill Sales      1,622.84        3,616.72        5,068.31      8,430.73      10,969.82      13,062.24      13,254.10      10,620.01        7,172.75      5,667.59      5,007.33        1,311.98        85,804.42
405 Sales - Driving Range Fees      1,616.94        2,135.37        2,562.03      3,614.98      43,381.46        3,155.66        3,313.90        3,042.50        2,414.34      2,261.30      2,158.67           941.44        70,598.59
407 Pavillion Rental Income      1,000.00        3,450.00        2,025.00      4,727.75        6,982.00        5,354.17        3,150.00        4,790.00        1,518.00      2,545.00      3,508.00        3,251.00        42,300.92
485 Over/Short            24.91              33.30              79.85            (9.26)              (1.32)              39.12            (64.52)                 1.11              (1.87)          (20.01)            (5.38)                0.77                76.70
Total Income    25,659.81     42,115.31     61,446.65    79,039.94    103,792.31    106,188.00    111,931.33    107,725.33     68,973.29    65,322.76    63,083.36     21,607.04     856,885.13
Cost of Goods Sold
500 COS - Pro Shop          707.75        1,244.26        1,414.96      3,885.82        7,279.65        4,782.59      11,411.25        6,985.80     14,910.40      2,046.61      5,306.32        3,459.14        63,434.55
501 COS - Grill Purchase          669.32        1,278.12        2,132.86      4,630.70        3,013.36        6,049.26        5,662.83        4,333.32        2,634.11      3,926.23      1,199.57        1,135.23        36,664.91
502 COS - Labor Grill            172.00                     -                     -              37.96           271.56              481.52
505 COS - Grounds Keepers                           144.91                   -                     -                       -                144.91
Total COS      1,377.07        2,522.38        3,547.82      8,516.52      10,293.01      10,831.85      17,074.08      11,491.12     17,689.42      5,972.84      6,543.85        4,865.93     100,725.89
Gross Profit    24,282.74     39,592.93     57,898.83    70,523.42      93,499.30      95,356.15      94,857.25      96,234.21     51,283.87    59,349.92    56,539.51     16,741.11     756,159.24
Expenses
600 Advertising            87.50                     -              175.00                     -                       -            100.00                   -                       -                362.50
616 Bad Debt              85.00                   -                       -          1,450.00          1,535.00
620 Bank Charges            10.78              14.59           144.39                   -                19.65                     -                47.09                     -                       -                3.00              0.24                0.98              240.72
636 Contract Services                   -             130.00           120.00          120.00            195.00            120.00            687.45        1,272.78           240.00              6.76          564.01                     -            3,456.00
638 Credit Card Fee          409.84           371.85        1,039.18          799.78        1,129.40        1,439.78        2,048.10        1,571.60        1,450.92      1,061.42          890.96           890.27        13,103.10
648 Dues & Subscriptions          128.07           812.48        2,420.28                   -                       -                       -              284.96            142.49           142.49          142.49          142.49           142.61          4,358.36
656 Employee Morale                     -                     -                       -                       -                       -                       -                       -        1,016.72                   -                       -            1,016.72
6560 Payroll Expense    15,321.28     16,510.84     17,953.54    30,965.32      24,845.80      29,204.07      27,850.11      28,161.20     27,550.66    35,712.59    20,053.82     16,764.07     290,893.30
660 Fuel/Oil - Grounds Equipment                   -          1,044.87           515.00      1,034.61            781.45        1,558.61                     -          2,618.63                     -        1,290.40      1,372.27                     -          10,215.84
668.1 Insurance - Prop and Casualty                   -             665.83           665.83      1,464.66                     -          2,719.99                     -                       -          1,565.00          747.67          747.67                     -            8,576.65
676 Licenses & Permits          250.00                     -                21.95            21.95              21.95              21.95                     -                21.95              50.00                   -                     -             750.00          1,159.75
678 Maint & Repairs - Building            82.00                     -             691.00          697.50            150.60                     -          2,464.91                     -             555.42      2,319.00      4,040.16           120.00        11,120.59
679 Maint & Repairs - Grounds/Equip          918.39        8,737.25        2,537.69    18,415.28      13,034.07      10,818.08      10,661.23        8,248.06        4,633.06      8,787.71      7,327.30        1,228.28        95,346.40
680 Maint & Repairs - Golf Carts                   -          2,409.60                     -        2,982.00        1,464.00                     -                       -              197.47        2,033.00                   -                     -                       -            9,086.07
682 Janitorial & Cleaning                   -                       -                       -                     -                       -                       -                       -                       -                       -                     -                     -                       -                         -  
686 Meetings and Seminars                   -                       -                       -                     -                       -                       -                       -                       -                       -                     -                     -                       -                         -  
690 Office Expense and Supplies            25.89           379.14           638.05          491.80            574.03              59.02            186.83            255.04           920.07          163.14            59.89                     -            3,752.90
694 Postage Expense                   -                       -                       -              42.00                     -                44.00                     -                92.97                     -              44.00            39.60           100.00              362.57
707 Rent - Equipemnt                   -                       -                       -                     -                       -              262.15                     -                       -                       -                     -              64.20                     -                326.35
722 Security Expense            12.05              30.00              30.00            30.00              30.00              30.00              30.00              30.00              30.00            30.00            93.03              30.00              405.08
730 Supplies                   -             411.13           253.22          202.51            331.71            154.56            254.10            776.88           282.06          320.22          198.31        1,664.13          4,848.83
738.6 Taxes - Other            17.38         (329.28)                     -                     -                       -          5,141.21            304.40                     -                       -                     -                     -                       -            5,133.71
742.1 Telephone Reg Services          282.88              64.55           797.88      1,152.96                     -                   1.15            280.57            282.73           283.16          667.98            23.64           286.51          4,124.01
754 Utilities      4,986.80        3,148.50        2,485.34      5,700.19            631.83            199.06            519.91            328.80           248.96          229.00          282.40           213.27        18,974.06
Total Expenses    22,445.36     34,486.35     30,313.35    64,208.06      43,209.49      51,773.63      47,244.66      44,000.60     39,984.80    52,642.10    35,899.99     22,190.12     488,398.51
Net Ordinary Income      1,837.38        5,106.58     27,585.48      6,315.36      50,289.81      43,582.52      47,612.59      52,233.61     11,299.07      6,707.82    20,639.52     (5,449.01)     267,760.73
Other Income/Expenses
803 Henry County - Month end check       (380.27)   (11,976.16)   (16,945.31)                     -      (44,540.56)    (75,161.78)    (20,036.63)   (65,852.43)                   -                     -                       -     (234,893.14)
810 Sales Tax Commission          122.49                     -                       -                         -                       -              163.80                     -                       -            172.73                   -                       -                459.02
Total Other Income       (257.78)   (11,976.16)   (16,945.31)                   -                       -      (44,540.56)    (74,997.98)    (20,036.63)   (65,852.43)          172.73                   -                       -     (234,434.12)
Net Other Income      1,579.60     (6,869.58)     10,640.17      6,315.36      50,289.81          (958.04)    (27,385.39)      32,196.98   (54,553.36)      6,880.55    20,639.52     (5,449.01)        33,326.61
Net Income      3,416.98     (1,763.00)     38,225.65    12,630.72    100,579.62      42,624.48      20,227.20      84,430.59   (43,254.29)    13,588.37    41,279.04   (10,898.02)     301,087.34