| ALEXANDER CITY BOARD OF EDUCATION | |||||||||||||||
| COMBINED BALANCE SHEET - ALL FUND TYPES AND ACCOUNT GROUPS | |||||||||||||||
| FISCAL PERIOD ENDING AUGUST 2011 | |||||||||||||||
| EXHIBIT F-I-A | |||||||||||||||
| Fund Types and Account Groups | Governmental | Fiduciary | Account Groups | ||||||||||||
| General | Special Revenue | Debt Service | Capital Projects | Trust | F/A & L/T Debt | ||||||||||
| Assets and Other Debits | |||||||||||||||
| Cash | $ 2,494,353.14 | $ 979,424.21 | $ 14,530.00 | $ 98,193.00 | $ 382,233.89 | $ - | |||||||||
| Investments | - | 123,861.46 | - | - | 1,375.12 | - | |||||||||
| Receivables: | |||||||||||||||
| Interfund | - | - | - | - | - | - | |||||||||
| Other | - | 81,491.37 | - | - | - | - | |||||||||
| Inventories | - | 53,270.18 | - | - | - | - | |||||||||
| Other Assets | - | - | - | - | - | - | |||||||||
| Fixed Assets | - | - | - | - | - | 32,212,278.60 | |||||||||
| Other Debits: | |||||||||||||||
| Long-Term Debt | - | - | - | - | - | 4,258,336.94 | |||||||||
| Total Assets and Other Debits | $ 2,494,353.14 | $ 1,238,047.22 | $ 14,530.00 | $ 98,193.00 | $ 383,609.01 | $ 36,470,615.54 | |||||||||
| Liabilities and Fund Equity | |||||||||||||||
| Liabilities | |||||||||||||||
| Salaries and Benefits | 4,304.29 | 924.26 | - | - | - | - | |||||||||
| Payroll Taxes | - | - | - | - | 1,939.14 | - | |||||||||
| Interfund | - | - | - | - | - | - | |||||||||
| Accounts Payable | 120,749.94 | 297,236.03 | - | - | 31,453.97 | - | |||||||||
| Long-Term Liabilities | - | - | - | - | - | 4,258,336.94 | |||||||||
| Total Liabilities | $ 125,054.23 | $ 298,160.29 | $ - | $ - | $ 33,393.11 | $ 4,258,336.94 | |||||||||
| Fund Equity | |||||||||||||||
| Investment in Gen. Fixed Assets | - | - | - | - | - | 32,212,278.60 | |||||||||
| Reserved Fund Balance | - | 53,270.18 | - | - | - | - | |||||||||
| Unreserved Fund Balance | 2,369,298.91 | 886,616.75 | 14,530.00 | 98,193.00 | 350,215.90 | - | |||||||||
| Total Fund Equity | $ 2,369,298.91 | $ 939,886.93 | $ 14,530.00 | $ 98,193.00 | $ 350,215.90 | $ 32,212,278.60 | |||||||||
| Total Liabilities and Fund Equity | $ 2,494,353.14 | $ 1,238,047.22 | $ 14,530.00 | $ 98,193.00 | $ 383,609.01 | $ 36,470,615.54 | |||||||||
| ALEXANDER CITY BOARD OF EDUCATION | |||||||||||||||
| COMBINED STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES | |||||||||||||||
| ALL GOVERNMENTAL FUND TYPES AND EXPENDABLE TRUST FUNDS | |||||||||||||||
| FISCAL PERIOD ENDING AUGUST 2011 | |||||||||||||||
| EXHIBIT F-II-A | |||||||||||||||
| FUND TYPE | Governmental | Fiduciary | Total | ||||||||||||
| DESCRIPTION | General | Special Revenue | Debt Service | Capital Projects | Expendable Trust | (Memorandum Only | |||||||||
| REVENUES: | |||||||||||||||
| STATE REVENUES | 14,695,529.19 | 600.00 | 646,270.00 | 66,310.71 | - | 15,408,709.90 | |||||||||
| FEDERAL REVENUES | 28,749.21 | 4,339,930.14 | - | - | - | 4,368,679.35 | |||||||||
| LOCAL REVENUES | 6,074,411.80 | 1,104,504.25 | - | - | 536,731.02 | 7,715,647.07 | |||||||||
| OTHER SOURCES | 75,116.93 | 25,644.01 | 698,692.39 | - | - | 799,453.33 | |||||||||
| TOTAL REVENUES | $ 20,873,807.13 | $ 5,470,678.40 | $ 1,344,962.39 | $ 66,310.71 | $ 536,731.02 | $ 28,292,489.65 | |||||||||
| EXPENDITURES: | |||||||||||||||
| INSTRUCTIONAL SERVICES | 12,606,805.31 | 2,687,039.76 | - | - | 478,569.81 | 15,772,414.88 | |||||||||
| INSTRUCTIONAL SUPPORT SERVICES | 2,953,418.88 | 841,849.01 | - | - | 36,345.45 | 3,831,613.34 | |||||||||
| OPERATION & MAINTENANCE | 1,579,187.61 | 90,696.56 | - | 50,371.61 | - | 1,720,255.78 | |||||||||
| AUXILIARY SERVICES | 773,647.47 | 1,576,081.42 | - | - | 6,259.87 | 2,355,988.76 | |||||||||
| GENERAL ADMINISTRATIVE SERVICES | 607,759.54 | 330,752.72 | - | 216,382.97 | - | 1,154,895.23 | |||||||||
| CAPITAL OUTLAY | 769,446.78 | - | - | - | 8,167.77 | 777,614.55 | |||||||||
| DEBT SERVICES | - | - | 874,789.39 | 186,270.05 | - | 1,061,059.44 | |||||||||
| OTHER EXPENDITURES | 96,005.40 | 215,942.39 | - | - | 24,661.78 | 336,609.57 | |||||||||
| TOTAL EXPENDITURES | $ 19,386,270.99 | $ 5,742,361.86 | $ 874,789.39 | $ 453,024.63 | $ 554,004.68 | $ 27,010,451.55 | |||||||||
| OTHER FUND SOURCES (USES): | |||||||||||||||
| TRANSFERS IN & OTHER FUND SOURCES | 316,108.58 | 363,423.31 | - | 455,643.00 | 13,098.70 | 1,148,273.59 | |||||||||
| TRANSFERS OUT | (180,538.67) | (369,651.15) | (455,643.00) | - | (70,954.80) | (1,076,787.62) | |||||||||
| TOTAL OTHER FUND SOURCES (USES) | $ 135,569.91 | $ (6,227.84) | $ (455,643.00) | $ 455,643.00 | $ (57,856.10) | $ 71,485.97 | |||||||||
| EXCESS REVENUES & OTHER SOURCES OVER(UNDER) EXPENDITURES & OTHER FUND USES | $ 1,623,106.05 | $ (277,911.30) | $ 14,530.00 | $ 68,929.08 | $ (75,129.76) | $ 1,353,524.07 | |||||||||
| BEGINNING FUND BALANCE - OCT 1 | $ 746,192.86 | $ 1,217,798.23 | $ - | $ 29,263.92 | $ 425,345.66 | $ 2,418,600.67 | |||||||||
| ENDING FUND BALANCE - OCT 31 | $ 2,369,298.91 | $ 939,886.93 | $ 14,530.00 | $ 98,193.00 | $ 350,215.90 | $ 3,772,124.74 | |||||||||
| ALEXANDER CITY BOARD OF EDUCATION | |||||||||||||||
| COMBINED STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES | |||||||||||||||
| BUDGET AND ACTUAL | |||||||||||||||
| FISCAL PERIOD ENDING AUGUST 2011 | |||||||||||||||
| EXHIBIT F-III-A | |||||||||||||||
| FUND TYPE | GENERAL | SPECIAL | |||||||||||||
| DESCRIPTION | BUDGET | ACTUAL | VARIANCE | BUDGET | ACTUAL | VARIANCE | |||||||||
| REVENUES: | |||||||||||||||
| STATE REVENUES | 16,019,151.00 | 14,695,529.19 | (1,323,621.81) | 100.00 | 600.00 | 500.00 | |||||||||
| FEDERAL REVENUES | 27,529.00 | 28,749.21 | 1,220.21 | 5,092,572.87 | 4,339,930.14 | (752,642.73) | |||||||||
| LOCAL REVENUES | 5,745,437.40 | 6,074,411.80 | 328,974.40 | 1,289,423.00 | 1,104,504.25 | (184,918.75) | |||||||||
| OTHER SOURCES | 134,402.00 | 75,116.93 | (59,285.07) | 50,000.00 | 25,644.01 | (24,355.99) | |||||||||
| TOTAL REVENUES | 21,926,519.40 | 20,873,807.13 | (1,052,712.27) | 6,432,095.87 | 5,470,678.40 | (961,417.47) | |||||||||
| EXPENDITURES: | |||||||||||||||
| INSTRUCTIONAL SERVICES | 14,372,288.75 | 12,606,805.31 | (1,765,483.44) | 2,760,569.50 | 2,687,039.76 | (73,529.74) | |||||||||
| INSTRUCTIONAL SUPPORT SERVICES | 3,244,137.00 | 2,953,418.88 | (290,718.12) | 874,371.30 | 841,849.01 | (32,522.29) | |||||||||
| OPERATION & MAINTENANCE | 2,030,365.20 | 1,579,187.61 | (451,177.59) | 59,974.00 | 90,696.56 | 30,722.56 | |||||||||
| AUXILIARY SERVICES | 825,750.50 | 773,647.47 | (52,103.03) | 1,961,216.04 | 1,576,081.42 | (385,134.62) | |||||||||
| GENERAL ADMINISTRATIVE SERVICES | 720,326.24 | 607,759.54 | (112,566.70) | 438,015.29 | 330,752.72 | (107,262.57) | |||||||||
| CAPITAL OUTLAY | - | 769,446.78 | 769,446.78 | - | - | - | |||||||||
| DEBT SERVICES | - | - | - | - | - | - | |||||||||
| PRINCIPAL | |||||||||||||||
| INTEREST | |||||||||||||||
| OTHER EXPENDITURES | 103,704.00 | 96,005.40 | (7,698.60) | 271,840.06 | 215,942.39 | (55,897.67) | |||||||||
| TOTAL EXPENDITURES | 21,296,571.69 | 19,386,270.99 | (1,910,300.70) | 6,365,986.19 | 5,742,361.86 | (623,624.33) | |||||||||
| OTHER FUND SOURCES (USES): | |||||||||||||||
| TRANSFERS IN | 473,696.40 | 242,621.08 | (231,075.32) | 176,895.00 | 363,423.31 | 186,528.31 | |||||||||
| OTHER FUND SOURCES | 170,722.50 | 73,487.50 | (97,235.00) | - | - | - | |||||||||
| OTHER FUND USES | (415,736.40) | (180,538.67) | 235,197.73 | (161,105.00) | (369,651.15) | (208,546.15) | |||||||||
| TOTAL OTHER FUND SOURCES (USES) | 228,682.50 | 135,569.91 | (93,112.59) | 15,790.00 | (6,227.84) | (22,017.84) | |||||||||
| EXCESS REVENUES & OTHER SOURCES OVER(UNDER) EXPENDITURES & OTHER FUND USES | 858,630.21 | 1,623,106.05 | 764,475.84 | 81,899.68 | (277,911.30) | (359,810.98) | |||||||||
| BEGINNING FUND BALANCE | 746,192.86 | 746,192.86 | - | 1,217,798.23 | 1,217,798.23 | - | |||||||||
| ENDING FUND BALANCE | 1,604,823.07 | 2,369,298.91 | 764,475.84 | 1,299,697.91 | 939,886.93 | (359,810.98) | |||||||||
| ALEXANDER CITY BOARD OF EDUCATION | |||||||||||||||
| COMBINED STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES | |||||||||||||||
| BUDGET AND ACTUAL | |||||||||||||||
| FISCAL PERIOD ENDING AUGUST 2011 | |||||||||||||||
| EXHIBIT F-III-B | |||||||||||||||
| FUND TYPE | DEBT SERVICE | CAPITAL PROJECTS | |||||||||||||
| DESCRIPTION | BUDGET | ACTUAL | VARIANCE | BUDGET | ACTUAL | VARIANCE | |||||||||
| REVENUES: | |||||||||||||||
| STATE REVENUES | 807,837.00 | 646,270.00 | (161,567.00) | 111,528.00 | 66,310.71 | (45,217.29) | |||||||||
| FEDERAL REVENUES | - | - | - | - | - | - | |||||||||
| LOCAL REVENUES | - | - | - | - | - | - | |||||||||
| OTHER SOURCES | 1,397,384.76 | 698,692.39 | (698,692.37) | - | - | - | |||||||||
| TOTAL REVENUES | 2,205,221.76 | 1,344,962.39 | (860,259.37) | 111,528.00 | 66,310.71 | (45,217.29) | |||||||||
| EXPENDITURES: | |||||||||||||||
| INSTRUCTIONAL SERVICES | - | - | - | - | - | - | |||||||||
| INSTRUCTIONAL SUPPORT SERVICES | - | - | - | 2,447.36 | - | (2,447.36) | |||||||||
| OPERATION & MAINTENANCE | - | - | - | 92,998.61 | 50,371.61 | (42,627.00) | |||||||||
| AUXILIARY SERVICES | - | - | - | - | - | - | |||||||||
| GENERAL ADMINISTRATIVE SERVICES | - | - | - | 243,141.40 | 216,382.97 | (26,758.43) | |||||||||
| CAPITAL OUTLAY | - | - | - | 45,450.76 | - | (45,450.76) | |||||||||
| DEBT SERVICES | 1,749,578.76 | 874,789.39 | (874,789.37) | 186,270.05 | 186,270.05 | - | |||||||||
| PRINCIPAL | |||||||||||||||
| INTEREST | |||||||||||||||
| OTHER EXPENDITURES | - | - | - | - | - | - | |||||||||
| TOTAL EXPENDITURES | 1,749,578.76 | 874,789.39 | (874,789.37) | 570,308.18 | 453,024.63 | (117,283.55) | |||||||||
| OTHER FUND SOURCES (USES): | |||||||||||||||
| TRANSFERS IN | - | - | - | 455,643.00 | 455,643.00 | - | |||||||||
| OTHER FUND SOURCES | - | - | - | - | - | - | |||||||||
| OTHER FUND USES | (455,643.00) | (455,643.00) | - | - | - | - | |||||||||
| TOTAL OTHER FUND SOURCES (USES) | (455,643.00) | (455,643.00) | - | 455,643.00 | 455,643.00 | - | |||||||||
| EXCESS REVENUES & OTHER SOURCES OVER(UNDER) EXPENDITURES & OTHER FUND USES | - | 14,530.00 | 14,530.00 | (3,137.18) | 68,929.08 | 72,066.26 | |||||||||
| BEGINNING FUND BALANCE | - | - | - | 29,263.92 | 29,263.92 | - | |||||||||
| ENDING FUND BALANCE | - | 14,530.00 | 14,530.00 | 26,126.74 | 98,193.00 | 72,066.26 | |||||||||
| ALEXANDER CITY BOARD OF EDUCATION | |||||||||||||||
| COMBINED STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES | |||||||||||||||
| BUDGET AND ACTUAL | |||||||||||||||
| FISCAL PERIOD ENDING AUGUST 2011 | |||||||||||||||
| EXHIBIT F-III-C | |||||||||||||||
| FUND TYPE | EXPENDABLE TRUST | TOTAL GOVERNMENT & EXPENDABLE TRUST FUNDS | |||||||||||||
| DESCRIPTION | BUDGET | ACTUAL | VARIANCE | BUDGET | ACTUAL | VARIANCE | |||||||||
| REVENUES: | |||||||||||||||
| STATE REVENUES | - | - | - | 16,938,616.00 | 15,408,709.90 | (1,529,906.10) | |||||||||
| FEDERAL REVENUES | - | - | - | 5,120,101.87 | 4,368,679.35 | (751,422.52) | |||||||||
| LOCAL REVENUES | 565,390.00 | 536,731.02 | (28,658.98) | 7,600,250.40 | 7,715,647.07 | 115,396.67 | |||||||||
| OTHER SOURCES | - | - | - | 1,581,786.76 | 799,453.33 | (782,333.43) | |||||||||
| TOTAL REVENUES | 565,390.00 | 536,731.02 | (28,658.98) | 31,240,755.03 | 28,292,489.65 | (2,948,265.38) | |||||||||
| EXPENDITURES: | |||||||||||||||
| INSTRUCTIONAL SERVICES | 371,750.00 | 478,569.81 | 106,819.81 | 17,504,608.25 | 15,772,414.88 | (1,732,193.37) | |||||||||
| INSTRUCTIONAL SUPPORT SERVICES | 28,874.00 | 36,345.45 | 7,471.45 | 4,149,829.66 | 3,831,613.34 | (318,216.32) | |||||||||
| OPERATION & MAINTENANCE | 700.00 | - | (700.00) | 2,184,037.81 | 1,720,255.78 | (463,782.03) | |||||||||
| AUXILIARY SERVICES | 6,400.00 | 6,259.87 | (140.13) | 2,793,366.54 | 2,355,988.76 | (437,377.78) | |||||||||
| GENERAL ADMINISTRATIVE SERVICES | - | - | - | 1,401,482.93 | 1,154,895.23 | (246,587.70) | |||||||||
| CAPITAL OUTLAY | - | 8,167.77 | 8,167.77 | 45,450.76 | 777,614.55 | 732,163.79 | |||||||||
| DEBT SERVICES | - | - | - | 1,935,848.81 | 1,061,059.44 | (874,789.37) | |||||||||
| PRINCIPAL | |||||||||||||||
| INTEREST | |||||||||||||||
| OTHER EXPENDITURES | 33,050.00 | 24,661.78 | (8,388.22) | 408,594.06 | 336,609.57 | (71,984.49) | |||||||||
| TOTAL EXPENDITURES | 440,774.00 | 554,004.68 | 113,230.68 | 30,423,218.82 | 27,010,451.55 | (3,412,767.27) | |||||||||
| OTHER FUND SOURCES (USES): | |||||||||||||||
| TRANSFERS IN | 2,000.00 | 13,098.70 | 11,098.70 | 1,108,234.40 | 1,074,786.09 | (33,448.31) | |||||||||
| OTHER FUND SOURCES | - | - | - | 170,722.50 | 73,487.50 | (97,235.00) | |||||||||
| OTHER FUND USES | (75,750.00) | (70,954.80) | 4,795.20 | (1,108,234.40) | (1,076,787.62) | 31,446.78 | |||||||||
| TOTAL OTHER FUND SOURCES (USES) | (73,750.00) | (57,856.10) | 15,893.90 | 170,722.50 | 71,485.97 | (99,236.53) | |||||||||
| EXCESS REVENUES & OTHER SOURCES OVER(UNDER) EXPENDITURES & OTHER FUND USES | 50,866.00 | (75,129.76) | (125,995.76) | 988,258.71 | 1,353,524.07 | 365,265.36 | |||||||||
| BEGINNING FUND BALANCE | 425,345.66 | 425,345.66 | - | 2,418,600.67 | 2,418,600.67 | - | |||||||||
| ENDING FUND BALANCE | 476,211.66 | 350,215.90 | (125,995.76) | 3,406,859.38 | 3,772,124.74 | 365,265.36 | |||||||||