| 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 | |||