BUDGET - - PDF document
2012 2013 BUDGET Board of Education Approval Requested August 28, 2012
¡
¡
¡
¡ ¡
¡ ¡ ¡ ¡ ¡ ¡ ¡ ¡ ¡ ¡ ¡ ¡ ¡ ¡ ¡ ¡ ¡ ¡ ¡ ¡ Board ¡of ¡Education ¡Approval ¡Requested ¡ ¡August ¡28, ¡2012 ¡
¡ ¡
North ¡Kansas ¡City ¡Schools ¡ ¡
2000 ¡NE ¡46th ¡Street ¡ ¡ Kansas ¡City, ¡Missouri ¡64116 ¡ ¡ (816) ¡413-‑5000 ¡ ¡ www.nkcschools.org ¡ ¡
Achieve excellence. Embrace change. Forge new traditions. 2000 NE 46 t h St. Kansas City, MO 64116-2042 816.413.5000 fax 816.413.5005 www.nkcschools.org Office of the Superintendent – Todd E. White, Ed.D. – Superintendent
June 2012 District Patrons and Colleagues, On behalf of North Kansas City Schools, I submit for your review the district budget for the fiscal year ending June 30, 2013. The District Administration and Board of Education continue to manage your tax dollars. By implementing purposeful, cost effective strategies, we have been successful in maintaining quality educational programs and facilities for each and every student we serve. And we have done so in a fiscally challenging economic climate. Our total assessed valuation (the basis for determining local tax revenues), fell to levels not seen since 2004. At the same time, our resident student enrollment grew by 1,700 since 2004. Furthermore, the economy has been challenging for our patrons and families, as well. That is why the NKC Schools Board of Education chose to freeze the school tax rate last year, even though they had the legal authority to increase it. As a “service-based” organization, the largest single expense in our operating budget is salaries. That investment in people directly impacts the quality of services we provide. By striving to keep
leaders and support staff. However, only once in five years have we been able to increase the base pay on our teachers’ salary schedule. We hope to be able to do so for a second time this coming year. NKC Schools will receive an increase in state funding for the 2012-13 school fiscal
and nurture our students. Another critical component of quality education is the learning environment. Schools that are clean, safe, secure, climate-controlled and well-maintained enable student achievement. We are mindful that many of our schools are approaching or already at capacity. We have managed the population growth by adding classrooms to our most crowded schools the last three summers. We are monitoring the situation with the help of a community-based “Focus on Facilities” committee, and we will keep you informed as we determine future facility needs. Reflected in the pages of this annual budget are revenues and expenditures that maintain a fund balance within the parameters set by the Board of Education. In short, NKC Schools is healthy, but not wealthy. We are working to get the most out of your tax dollars to ensure extraordinary educational experiences for each and every student. Thank you for your support and your trust. Sincerely, Todd White, Ed. D. Superintendent
Page 1 of 287 August 2012 Final Budget
North Kansas City Schools 2012-2013 Budget
2012-2013 Budget Proposal Executive Summary By Paul Harrell, Chief Financial Officer
This budget represents the financial plan of North Kansas City Schools for the 2012-13 fiscal
present and projected financial status of the District as well as to facilitate financial discussions that support our strategic plan. The budget is designed to meet the expectations of the Board of Education and the strategic initiatives included in the Comprehensive School Improvement Plan (CSIP). It provides the funding to attract and retain an outstanding workforce; to maintain, expand and improve facilities; and to provide required operating funds to sustain our existing campuses. REVENUE PROJECTIONS: The district’s largest sources of revenue are: Assessed Valuation (Local county property taxes based on assessed valuation and tax levy) State Aid (Missouri Education funding formula) Proposition “C” Sales Tax (Statewide) Sale of Bonds (NKC Schools bonds issued for capital improvements) Assessed Valuation: The district’s total assessed value as certified by Clay and Platte Counties in August 2012 is $1,871,506,546. This is 0.6 percent above the August 2011 value. Since 2007, our base values have declined by 10 percent, so any positive percentage increase is good news. The percentage declines in prior years are directly related to the overall slowdown in the national, state and local economies. The one-year change in the consumer price index for the period ending December 2011 was 3%. This index, in tandem with changes in assessed values are components of setting the district’s tax rate which must be filed with the Clay County Clerk by September 1, 2012. The district’s final tax rate will be set by the Board of Education at the August 28, 2012
State Auditor’s office for compliance. Current Taxes: Current taxes are budgeted at $105,301,408 based on an estimated collection rate of 96 percent and total tax rate of $5.8898 per $100 of assessed valuation. State Aid: 2012-13 is the seventh and final year of implementation of the Missouri Foundation Formula known as SB 287. The formula has been phased in over time since 2005. As SB 287 becomes fully implemented, the District will see an increase in total State funding of $2.5 million.
Page 2 of 287 August 2012 Final Budget
North Kansas City Schools 2012-2013 Budget The formula calculation calls for more state dollars than were appropriated by the Missouri legislature, leaving an estimated state funding shortfall of $251 million. Therefore, the Department of Elementary and Secondary Education (DESE) is going to modify components within the formula. The State Adequacy Target will be frozen at $6,131 per pupil until the funding shortfall is eliminated, and DESE will prorate the remaining shortfall equally at the bottom of the formula. DESE estimates the proration to be 92 percent for 2012-13. Proposition “C” Sales Tax: Sales tax allocation per eligible pupil is projected to increase by 1.8% or $294,044 due to an increase in the number of student contact hours generated in the 2011-12 school year. The prior year per pupil amount is $834 per hour of attendance and is expected to fall to $832 for 2012-13. Total sales tax revenues are budgeted at $16,035,968. Sale of Bonds: The District has fully issued all bonds approved by voters with the last bond sale in October
continue to watch the market for any possible debt refinancing to lower interest payments on
savings was applied to the 2012-13 fiscal year. Therefore, the Debt Service Fund levy will remain at $1.02 per $100 of assessed valuation. EXPENDITURE PROJECTIONS: The district’s largest areas of expense are: Salaries Benefits Purchased Services Supplies Capital Outlay Salaries: Salaries and employee benefits make up approximately 80 percent of the operating budget and thus have a large impact when changes are made. For 2012-13, the base salary within the Teacher’s Salary Schedule was increased 1.5 percent. This is only the second time in five years the District has been able to add funding to the base. The beginning teacher salary is now $36,978. Classified and Administrator’s salaries also were increased proportionally. Benefits: Health insurance premiums are expected to increase 5.8 percent effective October 1, 2012. All employees who work 30 or more hours per week qualify to participate in the health insurance plan. The Public School Retirement System (PSRS) contribution rate for certified teachers will remain at 14.5 percent. For classified staff in the Public Education Employees Retirement System (PEERS), it will remain at 6.86 percent. This is the first time in six years that the contribution rate remains unchanged. Employees must work 17 or more hours per week on a regular basis to be members of PSRS and 20 hours or more to be members of PEERS.
Page 3 of 287 August 2012 Final Budget
North Kansas City Schools 2012-2013 Budget Purchased Services: Property, liability and workers’ compensation insurance premiums account for a large part of this category. The District is currently evaluating the liability coverage with the broker for policies renewing on October 1, 2012. The overall Purchased Service category accounts for 7.5 percent of the total operating budget. Supplies: Through a zero-based budgeting approach, each building and department budget has been rebuilt and reprioritized. Overall, supplies account for $17.6 million or 7.5 percent of the total
Capital Outlay: $11.2 million has been placed in the capital outlay budget. This will allow the District to finish adding new classrooms to existing middle schools to help manage student growth and class
service serving lines, and work to complete a wireless network to better utilize technology within our school buildings.
Page 4 of 287 August 2012 Final Budget
Page 24 of 287 August 2012 Final Budget
Page 25 of 287 August 2012 Final Budget
Statement of Budget Receipts, Expenditures, and Fund Balances July 1, 2011 to June 30, 2012
Actual Actual Fund Actual Actual Balance Receipts Transfer Expenditures Balance July 1, 2011 June 30, 2012 General Fund - 10 43,597,545 80,822,233 (2,958,359) 78,461,704 42,999,714 Special Revenue Fund - 20 2,075,442 110,976,641
744,762 Sub Total Operating Funds 24.83% 45,672,987 191,798,874 (2,958,359) 190,769,025 43,744,477 22.93% Debt Service Fund - 30 23,613,100 72,310,205 70,911,342 25,011,963 Capital Projects Fund - 40 18,118,860 5,017,570 2,958,359 10,067,033 16,027,756 RESTRICTED FUND BALANCE Capital Projects - Bond Issue 48 7,299,416 3,433 3,362,042 3,940,807 Sub Total Bond Funds 7,299,416 3,433 3,362,042 3,940,807 Total 94,704,363 269,130,082
88,725,003
Page 26 of 287 August 2012 Final Budget
Statement of Budget Receipts, Expenditures, and Fund Balances July 1, 2012 to June 30, 2013
Actual Estimated Fund Estimated Estimated Balance Receipts Transfer Expenditures Balance July 1, 2012 ***** June 30, 2013 General Fund - 10 42,999,715 80,784,606 (1,857,357) 86,141,647 35,785,317 Special Revenue Fund - 20 744,762 116,424,532
816,233 Sub Total Operating Funds 22.93% 43,744,477 197,209,138 (1,857,357) 202,494,708 36,601,550 18.08% Debt Service Fund - 30 25,011,963 20,589,636 19,735,000 25,866,599 Capital Projects Fund - 40 16,027,756 2,822,064 1,857,357 7,319,881 13,387,296 RESTRICTED FUND BALANCE Capital Projects Fund 48 3,940,807 1,000 3,941,807 Sub Total Bond Funds 3,940,807 1,000
Total 88,725,003 220,621,838
75,855,445
***** See "Expanded Transfer Detail" on next page Page 27 of 287 August 2012 Final Budget
Page 29 of 287 August 2012 Final Budget
North Kansas City Schools 2012-2013 Budget
REVENUE BUDGET
Total Revenue for FY2012-13 is projected to be $220,621,838. The below chart shows the distribution
to support its operations, as evidenced by the fact that 66% of its total revenue comes from local sources. Revenue 2008/2009 Actual 2009/2010 Actual 2010/2011 Actual 2011/2012 Actual 2012/2013 Budget Local 158,656,752 152,157,670 149,277,857 152,013,808 145,018,280 County 2,790,535 2,501,801 2,918,666 3,316,434 3,808,871 State 40,247,607 43,131,434 44,612,478 53,862,025 57,354,442 Federal 11,017,372 21,803,110 19,874,499 14,524,103 14,289,245 Other (Bonds) 10,092,920 103,491 14,983,517 45,413,712 151,000 Total 222,805,186 219,697,506 231,667,017 269,130,082 220,621,838
66% 2% 26% 6% 0%
Revenue 2012-13
Local County State Federal Other
Page 30 of 287 August 2012 Final Budget
Assessed Valuation
History of Assessed Valuation
as reported in August of each year Real Estate Real Estate Real Estate Property Classification Total (Net) New Construction TIF Value Residental Agriculture Commerical less TIF Total Real Estate Personal Railroad & Utility Assessed Value % Growth Included in Total Deducted from AV 1992-93
693,020,840 299,024,601 2,809,355 994,854,796 4.91% 11,394,660
1993-94
707,441,780 296,493,424 5,485,797 1,009,421,001 Re-assess 1.46% 16,726,030
1994-95
717,079,420 314,376,079 3,083,923 1,034,539,422 2.49% 11,793,440
1995-96
765,767,640 364,288,957 2,958,230 1,133,014,827 Re-assess 9.52% 34,088,275
1996-97
809,195,960 413,287,736 3,658,436 1,226,142,132 8.22% 36,121,090
1997-98
886,747,480 455,758,273 2,962,541 1,345,468,294 Re-assess 9.73% 43,296,960
1998-99
898,476,880 477,256,758 3,587,572 1,379,321,210 2.52% 19,381,210
1999-2000
1,020,646,440 472,236,312 4,124,715 1,497,007,467 Re-assess 8.53% 16,771,080 6,984,931
2000-2001
1,034,362,790 503,536,974 4,045,178 1,541,944,942 3.00% 30,317,380 10,677,440
2001-2002
1,129,293,209 518,155,323 4,270,469 1,651,719,001 Re-assess 7.12% 53,072,090 18,138,680
2002-2003 (Aug 2002)
1,162,933,640 514,282,114 4,320,323 1,681,536,077 1.81% 31,792,550 24,456,820
2003-2004 (Aug 2003)
896,465,462 1,577,873 340,003,990 1,238,047,325 524,979,100 3,849,552 1,766,875,977 Re-assess 5.08% 40,974,860 72,730,400
2004-2005 (Aug 2004)
920,884,782 1,558,713 381,563,000 1,304,006,495 553,984,085 3,302,163 1,861,292,743 5.34% 37,149,450 36,697,360
2005-2006 (Aug 2005)
1,009,297,022 1,520,043 407,675,350 1,418,492,415 591,289,283 3,715,689 2,013,497,387 Re-assess 8.18% 35,133,730 38,495,210
2006-2007 (Aug 2006)
1,048,716,568 1,901,583 413,469,170 1,464,087,321 596,005,098 3,931,532 2,064,023,951 2.51% 52,336,576 50,807,920
2007-2008 (Aug 2007)
1,122,615,947 3,277,963 412,761,720 1,538,655,630 511,822,089 4,453,986 2,054,931,705 Re-assess
43,526,014 92,894,480
2008-2009 (Aug 2008)
1,150,773,612 5,841,453 415,971,350 1,572,586,415 510,794,985 5,156,502 2,088,537,902 1.64% 36,474,960 94,316,350
2009-2010 (Aug 2009)
1,138,353,792 7,822,663 401,117,380 1,547,293,835 445,330,454 4,303,912 1,996,928,201 Re-assess
18,263,130 104,690,530
2010-2011 (Aug 2010)
1,151,786,002 7,732,503 395,680,720 1,555,199,225 374,834,038 4,212,854 1,934,246,117
14,367,520 109,683,180
2011-12 (Aug 2011)
1,124,526,702 7,009,563 352,834,350 1,484,370,615 371,231,518 4,478,035 1,860,080,168 Re-assess
10,438,634 106,481,260
2012-13 (Aug 2012)
1,128,692,532 6,491,043 349,394,930 1,484,578,505 371,455,004 15,473,037 1,871,506,546 0.61% 8,842,302 107,385,980
1,000,000,000 1,500,000,000 2,000,000,000 2,500,000,000 02-03 03-04 04-05 05-06 06-07 07-08 08-09 09-10 10-11 11-12 12-13 Assessed Valuation
02-03 03-04 04-05 05-06 06-07 07-08 08-09 09-10 10-11 11-12 12-13 Series1 1.81% 5.08% 5.34% 8.18% 2.51%
1.64%
0.61%
0.00% 2.00% 4.00% 6.00% 8.00% 10.00% Percent of Change
Page 31 of 287 August 2012 Final Budget
North Kansas City Schools
8/20/2012
Changes in Assessed Valuation / Current Tax Revenue
August AV % Change 2003 1,766,875,977 5.0% 2004 1,861,292,743 5.3% 2005 2,013,497,387 8.2% 2006 2,064,023,951 2.5% 2007 2,054,931,705
2008 2,088,537,902 1.6% 2009 1,996,928,201
2010 1,934,246,117
2011 1,860,080,168
2012 1,871,506,546 0.6% Fiscal Yr Current Tax Levy 2003-04 79,906,344.17 4.9398 2004-05 84,727,356.97 5.0498 2005-06 101,821,839.26 5.6198 2006-07 109,745,869.63 5.6198 2007-08 116,549,686.60 5.8898 2008-09 117,632,848.04 5.8898 2009-10 113,488,214.40 5.8898 2010-11 109,247,494.74 5.8898 2011-12 105,588,554.00 5.8898 2012-13 Bgt 105,301,408.00 5.8898 (12,331,440.04) Loss FY'09 to FY13 0.95 Increased levy 1,700,000,000 1,750,000,000 1,800,000,000 1,850,000,000 1,900,000,000 1,950,000,000 2,000,000,000 2,050,000,000 2,100,000,000 2,150,000,000 2004 2005 2006 2007 2008 2009 2010 2011 2012
Assessed Valuation
40,000,000.00 60,000,000.00 80,000,000.00 100,000,000.00 120,000,000.00 140,000,000.00 2004-05 2005-06 2006-07 2007-08 2008-09 2009-10 2010-11 2011-12 2012-13 Bgt
Current Tax Revenue
Page 32 of 287 August 2012 Final Budget
Prop C Sales Tax
Revenue Code 5113: One-Cent sales tax collection distributed by the State on the basis of a weighted count of average daily attendance (WADA),
History of Prop C Sales Tax
Revenues Percent Eligible Dollars Per Year Collected Growth Pupils Pupil 1993-94 9,042,244 7.26% $600 EP 1994-95 9,563,404 5.76% $648 EP 1995-96 9,767,391 2.13% $663 EP 1996-97 10,032,721 2.72% $672 EP 1997-98 10,679,150 6.44% $705 EP 1998-99 10,977,027 2.79% $717 EP 1999-2000 11,550,888 5.23% $742 EP 2000-2001 12,085,396 4.63% $776 EP 2001-2002 12,014,484
15,418 $779 EP 2002-2003 12,400,778 3.22% 16,210 $758 EP 2003-2004 12,896,672 4.00% 16,276 $792 EP 2004-2005 12,997,398 0.78% 16,041 $810 EP 2005-2006 14,131,930 8.73% 16,490 $857 EP 2006-2007 14,461,875 2.33% 16,875 $857 WADA 2007-2008 14,409,785
17,053 $845 WADA 2008-2009 13,956,007
17,599 $793 WADA 2009-2010 13,817,477
18,157 $761 WADA 2010-2011 14,841,995 7.41% 18,907 $785 WADA 2011-2012 15,741,924 6.06% 18,870 $834 WADA 2012-2013 Est 16,035,968 1.87% 19,274 $832 WADA
10,000,000 15,000,000 20,000,000
02- 03 03-0 4 04-0 5 05- 06 06- 07 07- 08 08-0 9 09-1 10-1 1 11- 12 12- 13 Est
Revenues Collected
02-03 03-04 04-05 05-06 06-07 07-08 08-09 09-10 10-11 11-12 12-13 Est Series1 3.22% 4.00% 0.78% 8.73% 2.33%
7.41% 6.06% 1.87%
0.00% 2.00% 4.00% 6.00% 8.00% 10.00%
Percent of Change
Page 33 of 287 August 2012 Final Budget
State of Missouri – K-12 Education Foundation Formula
In 2005, the Missouri State Legislature passed a new funding formula for public
380 to a student needs based formula under Senate Bill 287. The 2012-2013 fiscal year is the 7th and final year of implementation of SB 287.
SB 287
Attendance
Less Local Effort
2005-06 SB 380 Calculation SB 287 Formula 2006-07 85% 15% 2007-08 70% 30% 2008-09 56% 44% 2009-10 42% 58% 2010-11 28% 72% 2011-12 14% 86% 2012-13 0% 100%
Page 34 of 287 August 2012 Final Budget
WEIGHTED ADA CALCULATION ESTIMATE
Paul Harrell NKC Schools Budget - August 2012 for 2012-2013 District Name: District Code: 024-093 Date:
August 2012 Budget
actual actual actual actual actual actual actual
actual
+179 RSP Line 2004-05 2005-06 2006-07 2007-08 2008-09 2009-10 2010-11 2011-12 2012-13 1. Regular Year ADA 15,709.2200 15,891.9488 15,913.7984 16,189.3990 16,656.3273 17,116.4800 17,204.1297 17,400.9148 17,579.0000 actual actual actual actual actual actual actual actual estimate 2. Summer School ADA 210.0400 203.5628 218.0718 337.6800 396.5091 493.5387 434.9303 493.6917 549.9088 actual actual actual actual actual actual actual actual estimate 3. Total ADA (1+2) 15,919.2600 16,095.5116 16,131.8702 16,527.0790 17,052.8364 17,610.0187 17,639.0600 17,894.6065 18,128.9088 4. Free and Reduced Weighting Jan 2005 Jan 2006 Jan 2007 Jan 2008 Jan 2009 Jan 2010 Jan 2011 Jan 2012 Estimate January Count 5,602.00 6,191.00 6,322.00 6,714.00 7,265.00 7,987.94 8,376.02 8,761.90 8,761.00 26.6% of ADA (Line 3) 4,234.5232 4,281.4061 4,291.0775 4,396.2030 27.3% of ADA (Line 3) 4,655.4243 4,807.5351 Weights 32.0% of ADA (Line 3) 5,644.4992 5,726.2741 7,034.0166 year 7 38.8% Add-on (25%) 341.8692 477.3985 507.7306 579.4493 652.3939 795.1012 682.8802 758.9065 431.7459 (sp ed count) 5. Special Education Weighting Dec 2007 Dec 2008 "Dec 2009 "Dec 2010 Dec 2011 Estimate December Count 2,348 2,201 2,106 1,906 1,912 1,886 1,826 1,711 1,711 14.9% of ADA (Line 3) 2,371.9697 2,398.2312 2,403.6487 2,462.5348 14.3% of ADA (Line 3) 2,438.5556 2,518.2327 13.7 % of ADA (Line 3) 2,416.5512 2,451.5611 2,393.0160 year 7 13.2% Add-on (75%) 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 6. LEP Weighting Oct 2007 Oct 2008 Oct 2009 Oct 2010 Estimate October Count 557 681 867 1,004 976 1,067 1,072 1,196 1,196 1.1% of ADA (Line 3) 175.1119 177.0506 177.4506 181.7979 1.3% of ADA (Line 3) 221.6869 228.9302 .90% of ADA (Line 3) 158.7515 161.0515 326.3204 year 7 1.8% Add-on (60%) 229.1329 302.3696 413.7296 493.3213 452.5879 502.8419 547.9491 620.9691 521.8078 7a. Weighted ADA (3+4+5+6) 16,490.2621 16,875.2797 17,053.3304 17,599.8496 18,157.8182 18,907.9618 18,869.8893 19,274.4821 19,082.4625 (Use Prior Year for Prop. C) 7b. WADA less Summer School 16,280.2221 16,671.7169 16,835.2586 17,262.1696 17,761.3091 18,414.4231 18,434.9590 18,780.7904 18,532.5537 (Line 7a - Line 2) 8. Formula Weighted ADA 17,053.3304 17,599.8496 18,157.8182 18,907.9618 18,869.8893 19,274.4821 19,330.6992 (Highest 3yr ADA + Current SS) North Kansas City Schools
Page 35 of 287 August 2012 Final Budget
Local Effort 2004-05
District Name: District Code: 024-093 Date: August 2012 Budget FORMULA YR 2006-07 2007-08 2008-09 2009-2010 2010-2011 2011-2012 2012-2013
2004-2005 Assessed Valuation*
$1,861,292,743 $1,861,292,743 $1,861,292,743 $1,861,292,743 $1,861,292,743 $1,861,292,743 $1,861,292,743 (Divided by 100 x 3.43) $63,842,341.08 $63,842,341.08 $63,842,341.08 $63,842,341.08 $63,842,341.08 $63,842,341.08 $63,842,341.08 2004-05 County Assessor & Collector Fee Rate 1.64% 1.64% 1.64% 1.64% 1.64% 1.64% 1.64% 2004-05 County Assessor & Collector Fees** $1,047,014.39 $1,047,014.39 $1,047,014.39 $1,047,014.39 $1,047,014.39 $1,047,014.39 $1,047,014.39 Net Local Tax Revenue $62,795,326.69 $62,795,326.69 $62,795,326.69 $62,795,326.69 $62,795,326.69 $62,795,326.69 $62,795,326.69
2004-2005 Incidental and Teachers Fund Revenues
School District Trust Fund (Prop C) x 1/2 $6,498,699.21 $6,498,699.21 $6,498,699.21 $6,498,699.21 $6,498,699.21 $6,498,699.21 $6,498,699.21 Financial Institution Tax $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Merchant's and Manufacturer's Tax $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 In Lieu Of Tax $206,876.38 $206,876.38 $206,876.38 $206,876.38 $206,876.38 $206,876.38 $206,876.38 Fines, Escheats, etc. Fines*** $269,239.00 $358,917.61 $408,926.20 $389,959.65 $389,959.65 $377,696.87 $377,696.87 State Assessed Utilities $1,912,581.44 $1,912,581.44 $1,912,581.44 $1,912,581.44 $1,912,581.44 $1,912,581.44 $1,912,581.44 Federal Properties $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Local Earnings and Income Taxes $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Total Receipts
$71,682,722.72 $71,772,401.33 $71,822,409.92 $71,803,443.37 $71,803,443.37 $71,791,180.59 $71,791,180.59 * enter 2004-05 amount in first column, then enter lower of 2004-05 or prior year December 31st AV thereafter ** fees prorated to equivalent $3.43 levy (not actual) *** enter 2004-05 amount in first column, then enter higher of 2004-05 or prior year therafter This section will only be needed when the district's prior year All districts complete this section. ADA is less than or equal to 350.
State Funding For 2004-05 State Funding For 2005-06
Recalculated Basic Formula $0.00 Recalculated Basic Formula $11,444,833.00 Recalculated Line 14 $0.00 Recalculated Line 14 $7,035,982.00 Exceptional Pupil Aid $0.00 Exceptional Pupil Aid $2,564,047.00 Gifted Aid $0.00 Gifted Aid $745,802.00 Remedial Reading $0.00 Remedial Reading $292,602.00 Fair Share $0.00 Fair Share $440,792.25 Free Textbook $0.00 Free Textbook $1,598,702.08
2004-2005 State Funding Total
$0.00
2005-2006 State Funding Total
$24,122,760.33 Note: The hold harmless calculation for districts with ADA ≤ 350 will use the higher of 2004-05 or 2005-06 state revenue. North Kansas City Schools
Page 36 of 287 August 2012 Final Budget
SB 287 FORMULA CALCULATION ESTIMATE USED IN 2012-2013 (August) BUDGET
District Name: District Code: 024-093 Date: August 2012 Budget
Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7
LINE
2006-07 2007-08 2008-09 2009-2010 2010-2011 2011-2012 2012-2013
1. Formula Payment Weighted ADA 17,053.3304 17,599.8496 18,157.8182 18,907.9618 18,869.8893 19,274.4821 19,330.6992 2. State Adequacy Target (SAT) $6,117 $6,117 $6,117 $6,117 $6,124 $6,131 $6,131 3. Payment Weighted ADA x SAT = District Total $104,315,222.06 $107,658,280.00 $111,071,373.93 $115,660,002.33 $115,559,202.07 $118,171,849.76 $118,516,516.80 4. District Dollar Value Modifer (DVM) 1.0900 1.0900 1.0900 1.0900 1.0900 1.0900 1.0820 5. District Total Modified $113,703,592.04 $117,347,525.20 $121,067,797.58 $126,069,402.54 $125,959,530.26 $128,807,316.23 $128,234,871.17 6. Local Effort (2004-05 or as Adjusted) $71,682,722.72 $71,772,401.33 $71,822,409.92 $71,803,443.37 $71,803,443.37 $71,791,180.59 $71,791,180.59 7. State Funding Estimate Before Phase-in or Hold Harmless $42,020,869.32 $45,575,123.87 $49,245,387.66 $54,265,959.17 $54,156,086.88 $57,016,135.64 $56,443,690.58 8. 2005-2006 State Funding Total $24,122,760.33 $24,122,760 $24,122,760 $24,122,760 $24,122,760 $24,122,760 $24,122,760 Phase-In Estimate: New / 2005-06
15%/85% 30%/70% 44%/56% 58%/42% 72%/28% 86%/14% 100%
9. SB 287 Formula Phase Amount (Line 7 x %) $6,303,130.40 $13,672,537.16 $21,667,970.57 $31,474,256.32 $38,992,382.56 $49,033,876.65 $56,443,690.58 10. 2005-2006 State Funding Phase Amount (Line 8 x %) $20,504,346.28 $16,885,932.23 $13,508,745.78 $10,131,559.34 $6,754,372.89 $3,377,186.45 $0.00 11. Estimated Formula Phase Total (before Hold Harmless) $26,807,476.68 $30,558,469.39 $35,176,716.35 $41,605,815.66 $45,746,755.45 $52,411,063.10 $56,443,690.58 Hold Harmless Calculation (Prior Year ADA > 350)
1+(1/3 DVM>1) 1+(2/3 DVM>1) Full DVM Full DVM Full DVM Full DVM Full DVM
12. DVM Calculation 1.0300 1.0600 1.0900 1.0900 1.0900 1.0900 1.0820 13. 2005-2006 State Funding Modified by DVM $24,846,443.14 $25,570,125.95 $26,293,808.76 $26,293,808.76 $26,293,808.76 $26,293,808.76 $26,100,826.68 14. FY06 Modified (Line 13) Per 2005-06 Weighted ADA $1,472.3574 $1,515.2416 $1,558.1258 $1,558.1258 $1,558.1258 $1,558.1258 $1,546.6900 15.
$1,571.9790 $1,736.29 $1,937.28 $2,200.44 $2,424.33 $2,719.19 $2,919.90 "On Formula/Hold Harmless" Determination
On Formula On Formula On Formula On Formula On Formula On Formula On Formula
Hold Harmless Calculation (Prior Year ADA ≤ 350)
1+(1/3 DVM>1) 1+(2/3 DVM>1) Full DVM Full DVM Full DVM Full DVM Full DVM
N/A N/A N/A N/A N/A N/A N/A
N/A N/A N/A N/A N/A N/A N/A
N/A N/A N/A N/A N/A N/A N/A "On Formula/Hold Harmless" Determination
N/A N/A N/A N/A N/A N/A N/A
16. ESTIMATED STATE FORMULA PAYMENT $26,807,477 $30,558,469 $35,176,716 $41,605,816 $45,746,755 $52,411,063 $56,443,691 Revenue Sources: Classroom Trust Fund - Per ADA (DESE) $345.00 $345.00 $360.00 $358.00 $442.00 $402.31 $379.00 Basic Formula - Classroom Trust Fund Total $5,552,952 $5,565,495 $5,949,748 $6,104,915 $7,783,628 $7,096,370 $6,782,056 Basic Formula - State Monies Total $21,254,525 $24,992,974 $29,226,968 $35,500,900 $37,963,127 $45,314,693 $49,661,635 17. Small School Allocation $0 $0 $0 $0 $0 $0 $0 18. TOTAL SB 287 PAYMENT $26,807,477 $30,558,469 $35,176,716 $41,605,816 $45,746,755 $52,411,063 $56,443,691 Estimated Increase (Prior Year Comparison) $2,684,716.35 $3,750,992.71 $4,618,246.96 $6,429,099.31 $4,140,939.79 $6,664,307.65 $4,032,627.48 Fund Placement: Minimum Fund 2 (75% of Basic Formula-State Monies) $15,940,893.75 $18,744,730.50 $21,920,226.00 $26,625,675.00 $28,472,345.25 $33,986,019.75 $37,246,226.25 Maximum Fund 1 (25% of Basic Formula-State Monies) $5,313,631.25 $6,248,243.50 $7,306,742.00 $8,875,225.00 $9,490,781.75 $11,328,673.25 $12,415,408.75 7% Capital Projects Transfer Maximum $7,225,826 $7,302,066 $7,536,080 $7,774,996 $8,105,465 $8,098,390 $8,272,029 OR 5% Designated Levy Transfer Maximum $5,161,304 $5,215,761 $5,382,914 $5,553,569 $5,789,618 $5,784,565 $5,908,592 1% Professional Development Committee Calculation $212,545 $249,930 $292,270 $355,009 $379,631 $453,147 $496,616 Proraton Factor ---
0.98661002
0.97 0.942 0.92 $41,048,715 $44,364,865 $49,345,524 $51,928,195 $2,582,672 June 2012 Pmt $49,588,444 Prior Year Corr
$49,345,524 Budget FY'13 Classroom Trust $7,096,370 $6,782,056 $6,782,055.86 Basic Formula 42,249,154 45,146,139
$44,903,219.25 49,345,524 51,928,195 $51,685,275.11 North Kansas City Schools
Page 37 of 287 August 2012 Final Budget
Note: The actual tax rate will be set in August 2012 after the final assessed valuation figures are reported by the Clay County Assessor.
The 27 cent levy approved by voters April 2001 is is incorporated into the levy calculation as follows:
Maximum Authorized Operating Levy Approved by Voters April 3, 2007 4.8698
Incidental Fund Technology personnel and software
0.03 Current Year Rate State will allow NKCSD to Collect 4.8698
Additional Utility Expense for HVAC
0.06 Less Voluntary Rollback by Board of Education
All day kindergarten staff
0.06 Tax rate to be levied for Operations 4.8698
Capital Projects Fund Preventive Maintenance
0.03 Tax rate to be levied for Debt Service 1.02
Computer Replacement
0.09 Total tax rate to be levied - All Funds 5.8898
Total approved April 2001
0.27 Incidental Fund 2.4998 Teachers Fund 2.2400 Capital Projects Fund 0.1300 Subtotal 4.8698
The 39 cent levy approved by voters April 2005 is incorporated into the levy calculation as follows:
Debt Service Fund 1.0200 Total Levy 5.8898
Incidental Fund Textbooks, Library, Classroom furnishings
0.04
Competitive salaries - classified
0.07 Estimated annual tax by school district per $100,000 of home value 1,119 $
Teachers Fund New staff to manage class size
0.04
Competitive salaries - certified
0.21 Current Tax Budget Computation August 2012 - Final AV
Estimated Assessed Valuation - Gross Base 2011
1,966,213,626 Less TIF:
Capital Projects Fund
GROSS TIF Values
(107,385,980) Preventive Maintenance (O & M Dept)
0.03
Add Back Briarcliff TIF Project 1, 2, 3 (Single Homes)
12,678,900
Net TIF Reduction
(94,707,080)
Total approved April 2005
0.39 Assessed Valuation - Adjusted 1,871,506,546 Protests to State Tax Commission 0.00 1,871,506,546
The 27 cent levy approved by voters in April 2007 is incorporated into the levy calculation as follows:
Less State Assessed RR&U - Personal (11,089,791) 1,860,416,755
Teachers Fund
Tax Rate 5.8898
Staley High Start Up
0.22 Theoretical Yield 109,574,826
Early Childhood Teachers
0.02 Less:
K-8 Class sizes
0.02 Collection fees 1.60% (1,753,197) Uncollectible 2.30% 3.90% (2,520,221)
Capital Projects Fund
Current Tax Budgeted 105,301,408
Preventive Maintenance (O & M Dept)
0.01
Total approved April 2007
0.27
Page 38 of 287 August 2012 Final Budget
Tax Levy by Fund Rates Per $100 of Assessed Valuation 2010-2011 Actual 2011-2012 Actual 2012-2013 Estimate Change Tax Rate Adjusted Tax Rate Adjusted Tax Rate Adjusted From Ceiling Tax Rate Ceiling Tax Rate Ceiling Tax Rate Prior Year General Fund 2.4998 2.4998 2.4998 2.4998 2.4998 2.4998 0.0000 Special Revenue Fund 2.2400 2.2400 2.2400 2.2400 2.2400 2.2400 0.0000 (Teachers Fund) Capital Projects Fund 0.1300 0.1300 0.1300 0.1300 0.1300 0.1300 0.0000 Subtotal Operating Funds 4.8698 4.8698 4.8698 4.8698 4.8698 4.8698 0.0000 Debt Service Fund 1.0200 1.0200 1.0200 1.0200 1.0200 1.0200 0.0000 Total 5.8898 5.8898 5.8898 5.8898 5.8898 5.8898 0.0000
Section 137.115, R.S.Mo sets out the percentage of true value of money to be assessed for each subclass of real property: 1 Residental property (subclass 1) 19% 2 Agricultural and horticultural (subclass 2) 12% 3 Utility, industrial, commercial, railroad and other real property (subclass 3) 32% 4 Taxable tangible personal property 33.33% Clay County Sur-Tax Levy on Commerical Property 1.5900
Page 39 of 287 August 2012 Final Budget
Proposed Budget Actual - YTD Actual Actual Budget % Change Change 2012-2013 2011-2012 2011-2012 2010-2011 2009-2010
North Kansas City School District Comparative Schedule of Receipts
Local Revenue
(287,146.31) 105,301,408.00 105,588,554.31 105,999,995.00 109,247,494.74 113,488,214.40 5111 Taxes- Current
(171,015.16) 3,850,000.00 4,021,015.16 3,700,000.00 3,380,039.70 3,899,019.88 5112 Taxes- Delinquent 1.86 294,044.22 16,035,968.00 15,741,923.78 15,430,752.00 14,703,833.62 13,863,794.18 5113 Sales Tax-Prop C
(21,917.83) 200,000.00 221,917.83 175,000.00 166,522.98 232,336.87 5114 Financial Institution Tax
(82,530.83) 4,950,000.00 5,032,530.83 4,950,000.00 5,011,945.63 4,951,272.14 5115 Sur Tax
(140,907.01) 3,000,000.00 3,140,907.01 2,860,000.00 2,861,294.95 2,968,495.58 5116 In Lieu of & TIFS
(1,672.80) 15,310.00 16,982.80 9,860.00 8,217.43 0.00 5121 Tuition-Out of District 19.93 27,429.00 165,000.00 137,571.00 150,000.00 99,246.35 150,365.46 5123 Adult/Cont Ed Tuition
(1,325.92) 6,000.00 7,325.92 6,000.00 5,870.08 6,964.00 5132 Transportation < Mile
(32,815.19) 330,000.00 362,815.19 325,000.00 346,037.04 362,134.73 5133 Field Trip Revenue
(242,095.52) 200,000.00 442,095.52 281,000.00 501,999.52 597,748.76 5141 Earnings/Temp Deposit
(5,920,014.50) 0.00 5,920,014.50 5,920,016.00 796,601.10 0.00 5143 Premium on Bonds Sold
(251,204.92) 930,000.00 1,181,204.92 800,000.00 1,003,576.38 1,084,992.69 5145 Interest-County 2.37 48,621.39 2,100,000.00 2,051,378.61 2,149,998.00 2,094,152.16 2,105,797.82 5151 Lunch Sales-Students 2.14 2,622.75 125,000.00 122,377.25 137,001.00 135,859.15 131,908.50 5153 Breakfast Sales-Students 1.88 2,697.24 146,000.00 143,302.76 134,997.00 133,785.20 138,253.85 5161 Sales to Adults-Food Svc
(3,367.46) 475,000.00 478,367.46 400,157.00 771,519.76 449,077.84 5165 Food Svc-Nonprogram 2.37 30,105.78 1,300,000.00 1,269,894.22 1,300,000.00 1,332,575.29 1,392,365.53 5166 Ala Carte Food Sale 5.34 121,710.03 2,400,000.00 2,278,289.97 2,221,817.00 2,090,833.72 2,697,203.79 5170 Activity Revenue
(20,706.04) 158,350.00 179,056.04 157,190.00 156,877.92 0.00 5171 Gate Receipts
(14,407.24) 88,000.00 102,407.24 88,000.00 110,973.11 0.00 5173 Participation Fees
(5,717.71) 45,300.00 51,017.71 42,100.00 46,670.00 0.00 5174 Student Athletic Tickets
(5,705.47) 21,000.00 26,705.47 18,500.00 20,095.00 0.00 5175 Adult Athletic Tickets 2.95 78,289.82 2,727,265.00 2,648,975.18 2,669,665.00 2,525,531.67 2,443,430.52 5180 School Age Child Care
(2,043.58) 45,000.00 47,043.58 45,000.00 47,932.10 44,235.57 5181 Middle Sch After Sch Prog Fees 14.66 179.00 1,400.00 1,221.00 1,400.00 1,250.00 20,012.22 5183 Infant Care Rev-Teen Ctrs 2.90 2,114.00 75,000.00 72,886.00 70,000.00 78,978.00 72,718.75 5184 Preschool Fees 0.00 0.00 0.00 0.00 0.00 425.00 1,660.00 5185 Sports Clinic Fees
(7,508.50) 95,000.00 102,508.50 97,029.00 99,605.75 117,564.00 5191 Rentals/Building Use
(4,293.00) 9,312.00 13,605.00 17,404.00 23,637.75 9,487.65 5192 Gifts/Donations
(373.23) 1,300.00 1,673.23 1,000.00 1,241.81 802.56 5193 Cobra Surcharge
(177,777.77) 6,000.00 183,777.77 142,751.00 33,688.13 58,160.39 5195 Prior Period Adjustments 14.37 10,617.00 84,500.00 73,883.00 73,480.00 90,950.00 37,140.00 5198 Misc Local Revenue
(219,412.49) 131,167.00 350,579.49 448,328.00 1,348,596.20 832,511.99 5199 Misc Local Revenue User: Report: Page: Date: Time: 1 08/17/2012 20:52:17 PHARRELL - Paul G Harrell BU2225 - BU2225: Revenue Summary by Object Mu
Page 40 of 287 August 2012 Final Budget
Proposed Budget Actual - YTD Actual Actual Budget % Change Change 2012-2013 2011-2012 2011-2012 2010-2011 2009-2010
North Kansas City School District Comparative Schedule of Receipts
145,018,280.00 152,013,808.25 150,823,440.00 149,277,857.24 152,157,669.67 Local - Subtotal 5100 County Revenue
(2,299.32) 390,000.00 392,299.32 440,000.00 453,440.53 377,696.87 5211 Fines, Forfeitures, Escheats 16.91 494,737.68 3,418,871.00 2,924,133.32 2,465,000.00 2,465,225.65 2,124,104.23 5221 State Assessed Utilities Tax 14.84 492,438.36 3,808,871.00 3,316,432.64 2,905,000.00 2,918,666.18 2,501,801.10 County - Subtotal 5200 State Revenue 9.49 3,892,658.00 44,903,219.00 41,010,561.00 40,271,239.00 32,091,138.00 30,885,645.00 5311 SB 287-Basic Formula
(99,752.00) 2,100,000.00 2,199,752.00 2,196,803.00 1,903,249.00 2,903,230.00 5312 Transportation
(120,032.83) 2,623,744.00 2,743,776.83 2,786,113.00 2,426,816.45 2,314,422.54 5314 Early Childhood Spec Ed
(274,136.00) 6,782,056.00 7,056,192.00 7,632,468.00 7,423,628.00 6,133,197.00 5319 Classroom Trust Fund 9.52 17,387.00 200,000.00 182,613.00 180,851.00 172,145.00 309,368.92 5324 Parents As Teachers 5.65 2,141.00 40,000.00 37,859.00 40,000.00 55,569.00 79,042.00 5332 Voc/Tech Aid
(9,866.30) 50,000.00 59,866.30 50,002.00 54,554.25 42,744.23 5333 State Reimb-Food Svc 46.06 29,823.16 94,566.00 64,742.84 69,943.00 90,066.56 165,886.64 5337 Adult Educ Lit-State 130.33 37,399.00 66,094.00 28,695.00 28,695.00 0.00 0.00 5359 Voc/Tech Enhancement Grant 0.00 0.49 354,637.00 354,636.51 354,637.00 272,429.19 177,682.18 5381 High Needs-Spec Ed 9.90 585.00 6,490.00 5,905.00 9,410.00 5,996.88 6,952.49 5398 Other State Rev 13.80 16,210.21 133,636.00 117,425.79 126,424.00 116,885.75 113,262.61 5399 DFS Child Care Svcs 6.48 3,492,416.73 57,354,442.00 53,862,025.27 53,746,585.00 44,612,478.08 43,131,433.61 State - Subtotal 5300 Federal Revenue
(30,632.88) 148,000.00 178,632.88 225,000.00 125,494.29 430,195.44 5412 Medicaid
(968,007.00) 0.00 968,007.00 968,007.00 1,584,152.00 4,896,213.00 5422 Basic Formula-SFSF Ed ARRA 0.00 0.00 0.00 0.00 0.00 0.00 338,042.00 5423 Transportation-ARRA
(53,752.00) 0.00 53,752.00 53,752.00 968,524.00 0.00 5424 Basic Formula-SFSF Govt ARRA 0.00 0.00 0.00 0.00 0.00 366,727.00 0.00 5425 Classrm Trust-Jobs Bill
(40,523.00) 0.00 40,523.00 40,523.00 0.00 0.00 5426 Jobs Funds-Classroom Trust
(9,671.00) 237,855.00 247,526.00 247,526.00 208,901.00 252,416.00 5427 Perkins-Voc Ed 0.00 0.00 0.00 0.00 0.00 1,555,771.00 0.00 5428 Basic Form-Job Bills-St Sch 0.00 0.00 0.00 0.00 0.00 999,977.00 0.00 5429 Basic Form-Job Bills-Fed Stab
(15,759.55) 238,468.00 254,227.55 254,231.00 216,743.80 105,369.70 5436 Adult Ed Lit-Federal 123.03 48,660.39 88,209.00 39,548.61 99,604.00 0.00 0.00 5437 IDEA Grants(non entitlement) 0.00 0.00 0.00 0.00 0.00 0.00 55,495.26 5439 High Needs-ARRA-Spec Ed 1.02 34,831.65 3,422,380.00 3,387,548.35 3,397,680.00 3,412,370.96 3,390,347.91 5441 Spec Ed-IDEA User: Report: Page: Date: Time: 2 08/17/2012 20:52:17 PHARRELL - Paul G Harrell BU2225 - BU2225: Revenue Summary by Object Mu
Page 41 of 287 August 2012 Final Budget
Proposed Budget Actual - YTD Actual Actual Budget % Change Change 2012-2013 2011-2012 2011-2012 2010-2011 2009-2010
North Kansas City School District Comparative Schedule of Receipts
168.02 506,087.61 807,279.00 301,191.39 406,485.00 283,884.40 240,539.58 5442 Early Childhood Spec Ed 0.53 21,212.69 3,950,000.00 3,928,787.31 3,720,001.00 3,628,803.02 3,434,957.74 5445 Fed-Food Svc Lunch 0.00 114.79 1,420,000.00 1,419,885.21 1,299,997.00 1,212,695.20 1,148,253.56 5446 Fed-Breakfast Rev
(2,050.48) 0.00 2,050.48 2,000.00 2,313.24 13,510.18 5448 After School Snack Program 7.93 215,694.54 2,934,001.00 2,718,306.46 2,930,322.00 2,410,539.42 2,006,612.22 5451 Title I 0.00 0.00 0.00 0.00 0.00 811,975.13 675,338.87 5456 Title I,A- Ed Disadv-ARRA 0.00 0.00 0.00 0.00 0.00 50,679.00 26,898.00 5461 Title IV-Drug Free 80.65 185,515.52 415,515.00 229,999.48 366,732.00 70,687.39 218,668.00 5462 Title III-ESL
(17,386.40) 617,120.00 634,506.40 680,313.00 684,529.10 358,539.00 5465 Title IIA 0.00 0.00 0.00 0.00 0.00 124,960.61 1,610.81 5466 Title II.D 0.00 0.00 0.00 0.00 0.00 29,435.55 45,649.45 5467 Homeless-ARRA-Title VII B 0.00 0.00 0.00 0.00 0.00 6,862.87 426,264.13 5468 Title II.D Ed Tech-ARRA 0.00 0.00 0.00 0.00 0.00 851,596.59 3,601,015.41 5493 IDEA, Part B- ARRA 0.00 0.00 0.00 0.00 0.00 132,387.59 1,842.41 5494 ECSE-ARRA-IDEA Part B (619) 58.02 3,825.22 10,418.00 6,592.78 8,896.00 11,027.01 3,914.32 5495 Indian Ed Grant 0.00 0.00 0.00 0.00 0.00 0.00 17,531.00 5496 Other Fed-WIA Incentive
(113,018.34) 0.00 113,018.34 113,246.00 119,436.65 109,861.78 5498 Other Fed-EXCELL Grant 0.00 0.00 0.00 0.00 0.00 4,024.00 4,024.00 5499 Other Fed
14,289,245.00 14,524,103.24 14,814,315.00 19,874,497.82 21,803,109.77 Federal - Subtotal 5400 Other Revenue
(37.59) 25,000.00 25,037.59 20,000.00 53,893.28 32,735.17 5651 Sale of Property
(45,265,000.00) 0.00 45,265,000.00 45,265,000.00 14,795,000.00 0.00 5692 Refunding of Bonds 3.22 1,435.00 46,000.00 44,565.00 46,885.00 27,465.00 0.00 5811 Tuition from Other LEAs 0.00 0.00 0.00 0.00 0.00 0.00 21,240.00 5831 Contr Ed Svcs-Other LEA 1.12 890.21 80,000.00 79,109.79 35,000.00 107,159.10 49,516.51 5841 Nonhandic Transp Fr Other LEA
151,000.00 45,413,712.38 45,366,885.00 14,983,517.38 103,491.68 Other - Subtotal 5600 219,697,505.83 231,667,016.70 267,656,225.00 269,130,081.78 Grand Total
220,621,838.00
Page 42 of 287 August 2012 Final Budget
Page 46 of 287 August 2012 Final Budget
North Kansas City Schools 2012-2013 Budget
EXPENDITURE BUDGET
The 2012-13 budget has estimated annual expenditures of $233,491,396. The chart below shows expenditures by fund. Expenditures 2008/2009 Actual 2009/2010 Actual 2010/2011 Actual 2011/2012 Actual 2012/2013 Budget
General Fund 71,849,511 76,724,076 75,036,887 78,461,704 86,141,647 Teachers 108,213,253 110,966,633 108,892,038 112,307,321 116,353,061 Total Operational 180,062,764 187,690,709 183,928,925 190,769,025 202,494,708 Capital Proj Fund 34,664,537 10,657,691 9,019,442 13,429,076 11,261,688 Debt Service Fund 21,458,461 22,160,378 35,739,723 70,911,342 19,735,000 Total Other 56,122,998 32,818,069 44,759,165 84,340,418 30,996,688 Total Expenditures 236,185,762 220,508,777 228,688,090 275,109,442 233,491,396 37% 50% 5% 8%
Expenditures
General Fund Teachers Capital Projects Fund Debt Service Fund
Page 47 of 287 August 2012 Final Budget
Schedule of Comparative Expenditures - Operating Funds Only
Actual Percentage Actual Percentage Budgeted Percentage Expenditures
Expenditures
Expenditures
2010-2011 Total 2011-2012 Total 2012-2013 Total
All Funds:
Salaries 122,109,292 64.17% 124,026,694 61.76% 129,553,364 61.75% Employee Benefits 31,851,364 16.74% 35,096,254 17.48% 37,771,190 18.00% Sub total 153,960,656 80.91% 159,122,948 79.24% 167,324,554 79.75% Purchased Services 13,508,587 7.10% 15,289,638 7.61% 17,487,198 8.33% Supplies 16,473,432 8.66% 16,356,439 8.14% 17,682,956 8.43% Capital Assets - Equip 6,341,585 3.33% 10,067,033 5.01% 7,319,881 3.49% Total 190,284,260 100.00% 200,836,058 100.00% 209,814,589 100.00%
Salary & Benefits 80% Purchased Services 8% Supplies & Equip 12%
Budgeted Expenditures $209,814,589 (Operating Funds Only)
Page 48 of 287 August 2012 Final Budget
Schedule of Comparative Expenditures
Actual Percentage Actual Percentage Budgeted Percentage Expenditures
Expenditures
Expenditures
2010-2011 Total 2011-2012 Total 2012-2013 Total
All Funds:
Salaries 122,109,292 53.40% 124,026,694 45.08% 129,553,364 55.49% Employee Benefits 31,851,364 13.93% 35,096,254 12.76% 37,771,190 16.18% Purchased Services 13,508,587 5.91% 15,289,638 5.56% 17,487,198 7.49% Supplies 16,473,432 7.20% 16,356,439 5.95% 17,682,956 7.57% Capital Outlay 9,005,692 3.94% 13,429,076 4.88% 11,261,688 4.82% Debt and Interest 35,739,723 15.63% 70,911,341 25.78% 19,735,000 8.45% Total 228,688,090 100.00% 275,109,442 100.00% 233,491,396 100.00%
Salary & Benefits 72% Purchased Services 7% Supplies 8% Capital Outlay 3% Capital Outlay- Bond 2% Debt Service 8%
Total Budgeted Expenditures $233,491,396 (All Funds)
Page 49 of 287 August 2012 Final Budget