Budget report
2020-12 December
Capital School District, December 2020.
This text was pulled from the district file by a computer and may have mistakes, especially in tables. The district file is the official version.
Page 1
CAPITAL
SCHOOL DISTRICT
Monthly Financial Reports
December 31, 2020
Operating Expenses
Monthly Report of Revenues
Board Budget (99900000)
Contingency Budget (99940100)
Major Cap Balances
Federal Funds
Page 2
1/4/2021 Operating Unit Expenditure Summary as of 12/31/2020 Page: 1
Division - 13 Capital School District Percent of Fiscal Year days included: 50.3%
| Operating Unit | Budget | Encumbered | Pct Enc | Expended | Pct Exp | Total Exp./Enc. | Percent Obligated | Unencumbered Balance |
|---|---|---|---|---|---|---|---|---|
| 9130632A - East Dover Elementary School | $45,312.00 | $0.00 | 0.00% | $10,265.31 | 22.65% | $10,265.31 | 22.65% | $35,046.69 |
| 9130634A - South Dover Elementary School | $72,704.00 | $0.00 | 0.00% | $14,989.74 | 20.62% | $14,989.74 | 20.62% | $57,714.26 |
| 9130635A - North Dover Elementary School | $44,288.00 | $0.00 | 0.00% | $11,124.23 | 25.12% | $11,124.23 | 25.12% | $33,163.77 |
| 9130636A - Booker T. Washington Es | $35,328.00 | $0.00 | 0.00% | $16,865.14 | 47.74% | $16,865.14 | 47.74% | $18,462.86 |
| 9130638A - Fairview Elementary School | $36,736.00 | $0.00 | 0.00% | $7,065.89 | 19.23% | $7,065.89 | 19.23% | $29,670.11 |
| 9130640A - Hartly Elementary School | $37,376.00 | $0.00 | 0.00% | $17,264.72 | 46.19% | $17,264.72 | 46.19% | $20,111.28 |
| 9130642A - Towne Point Elementary School | $36,864.00 | $0.00 | 0.00% | $17,309.39 | 46.95% | $17,309.39 | 46.95% | $19,554.61 |
| 9130644A - Central Middle School | $135,493.00 | $0.00 | 0.00% | $33,476.35 | 24.71% | $33,476.35 | 24.71% | $102,016.65 |
| 9130645A - Capital Early Childhood Center | $237,900.00 | $11,653.28 | 4.90% | $205,436.88 | 86.35% | $217,090.16 | 91.25% | $20,809.84 |
| 9130646A - William Henry Middle School | $135,300.00 | $2,236.50 | 1.65% | $24,565.58 | 18.16% | $26,802.08 | 19.81% | $108,497.92 |
| 9130648A - Dover High School | $393,600.00 | $5,367.00 | 1.36% | $175,748.95 | 44.65% | $181,115.95 | 46.02% | $212,484.05 |
| 9130650A - Kent County Community School | $529,830.00 | $66,582.80 | 12.57% | $268,680.99 | 50.71% | $335,263.79 | 63.28% | $194,566.21 |
| 9130655A - Kent County Secondary Ilc | $632,300.00 | $3,978.00 | 0.63% | $263,027.63 | 41.60% | $267,005.63 | 42.23% | $365,294.37 |
| 99900000 - Board Of Ed/District Expenses | $75,000.00 | $0.00 | 0.00% | $7,199.60 | 9.60% | $7,199.60 | 9.60% | $67,800.40 |
| 99900100 - Legal Services | $79,000.00 | $8,215.26 | 10.40% | $80,368.58 | 101.73% | $88,583.84 | 112.13% | ($9,583.84) |
| 99900300 - District Expenditures | $25,975,372.00 | $100.00 | 0.00% | $15,925,181.52 | 61.31% | $15,925,281.52 | 61.31% | $10,050,090.48 |
| 99910010 - District Office | $46,676.00 | $0.00 | 0.00% | $23,752.38 | 50.89% | $23,752.38 | 50.89% | $22,923.62 |
| 99910100 - Superintendent | $102,597.00 | $0.00 | 0.00% | $25,946.85 | 25.29% | $25,946.85 | 25.29% | $76,650.15 |
| 99920000 - Curriculum/Instructional | $403,261.00 | $9,564.94 | 2.37% | $143,858.67 | 35.67% | $153,423.61 | 38.05% | $249,837.39 |
| 99920600 - Technology (Instructional) | $421,600.00 | $0.00 | 0.00% | $68,541.68 | 16.26% | $68,541.68 | 16.26% | $353,058.32 |
| 99920700 - Athletics | $300,600.00 | $0.00 | 0.00% | $247,959.02 | 82.49% | $247,959.02 | 82.49% | $52,640.98 |
| 99921000 - Support Services | $400,430.00 | $0.00 | 0.00% | $170,297.08 | 42.53% | $170,297.08 | 42.53% | $230,132.92 |
| 99930200 - Special School Tuition Payment | $226,939.00 | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $226,939.00 |
| 99930300 - Special Services | $50,723.00 | $48.01 | 0.09% | $20,128.21 | 39.68% | $20,176.22 | 39.78% | $30,546.78 |
| 99940000 - Business Office/Finance | $171,636.00 | $60,000.00 | 34.96% | $69,645.61 | 40.58% | $129,645.61 | 75.54% | $41,990.39 |
| 99940050 - Facilities Management | $0.00 | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 |
| 99940100 - Contingency | $110,000.00 | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $110,000.00 |
| 99940200 - Division I Sal/Other State Prg | $59,474,025.00 | $0.00 | 0.00% | $27,568,345.01 | 46.35% | $27,568,345.01 | 46.35% | $31,905,679.99 |
| 99940300 - Division Ii Vocational | $130,480.00 | $0.00 | 0.00% | $179,242.72 | 137.37% | $179,242.72 | 137.37% | ($48,762.72) |
| 99940600 - Insurance | $134,045.00 | $30,549.18 | 22.79% | $112,199.62 | 83.70% | $142,748.80 | 106.49% | ($8,703.80) |
| 99940700 - Private Grants/Donations | $729,572.00 | $100.00 | 0.01% | $495,926.58 | 67.98% | $496,026.58 | 67.99% | $233,545.42 |
| 99940900 - Tuition Reimbursement | $72,000.00 | $0.00 | 0.00% | $40,883.36 | 56.78% | $40,883.36 | 56.78% | $31,116.64 |
| 99950000 - Personnel/Hr | $50,000.00 | $0.00 | 0.00% | $36,723.23 | 73.45% | $36,723.23 | 73.45% | $13,276.77 |
| 99960000 - Child Nutrition Operations | $5,800,000.00 | $0.00 | 0.00% | $1,879,475.77 | 32.40% | $1,879,475.77 | 32.40% | $3,920,524.23 |
| 99960100 - Maintenance | $541,265.00 | $1,840.15 | 0.34% | $268,946.68 | 49.69% | $270,786.83 | 50.03% | $270,478.17 |
| 99960200 - Operations/Utilities | $1,554,468.00 | $496,660.07 | 31.95% | $300,455.63 | 19.33% | $797,115.70 | 51.28% | $757,352.30 |
| 99960300 - State Transportation | $5,067,063.00 | $0.00 | 0.00% | $1,785,260.03 | 35.23% | $1,785,260.03 | 35.23% | $3,281,802.97 |
| 99960400 - Local Transportation | $510,563.00 | $0.00 | 0.00% | $106,151.17 | 20.79% | $106,151.17 | 20.79% | $404,411.83 |
| 99960500 - Fleet Vehicles | $52,000.00 | $0.00 | 0.00% | $18,332.75 | 35.26% | $18,332.75 | 35.26% | $33,667.25 |
| 99970000 - Local Debt Service | $6,199,614.00 | $0.00 | 0.00% | $3,997,446.26 | 64.48% | $3,997,446.26 | 64.48% | $2,202,167.74 |
| Data Service Center | ||||||||
Page 3
1/4/2021 Operating Unit Expenditure Summary as of 12/31/2020 Page: 2
Division - 13 Capital School District Percent of Fiscal Year days included: 50.3%
| Operating Unit | Budget | Encumbered | Pct Enc | Expended | Pct Exp | Total Exp./Enc. | Percent Obligated | Unencumbered Balance |
|---|---|---|---|---|---|---|---|---|
| 99970040 - LOCAL TECHNOLOGY MATCH TAX | $422,041.00 | $0.00 | 0.00% | $92,866.40 | 22.00% | $92,866.40 | 22.00% | $329,174.60 |
| 99970200 - Minor Cap | $944,989.00 | $72,641.00 | 7.69% | $346,291.09 | 36.64% | $418,932.09 | 44.33% | $526,056.91 |
| 99970680 - School Supervision | $942,332.00 | $0.00 | 0.00% | $496,376.22 | 52.68% | $496,376.22 | 52.68% | $445,955.78 |
| 99980000 - Summer School | $20,000.00 | $0.00 | 0.00% | $11,164.30 | 55.82% | $11,164.30 | 55.82% | $8,835.70 |
| 99990500 - Copy Center/Copiers | $128,752.00 | $0.00 | 0.00% | $32,370.30 | 25.14% | $32,370.30 | 25.14% | $96,381.70 |
| 99990600 - Homebound | $440,974.00 | $0.00 | 0.00% | $128,215.81 | 29.08% | $128,215.81 | 29.08% | $312,758.19 |
| 99990700 - Autism Program | $352,322.00 | $28,009.15 | 7.95% | $229,908.87 | 65.26% | $257,918.02 | 73.21% | $94,403.98 |
| Budget Totals | $114,303,370.00 | $797,545.34 | 0.70% | $55,975,281.80 | 48.97% | $56,772,827.14 | 49.67% | $57,530,542.86 |
| Current Year Unassigned Expenses | $235,840.70 | $3,238,154.89 | $3,473,995.59 | |||||
| Previous Budget Year Expenses | $7,699,730.26 | $7,558,883.99 | $15,258,614.25 | |||||
| Total Expenses | $8,733,116.30 | $66,772,320.68 | $75,505,436.98 | |||||
| Data Service Center | ||||||||
Page 4
Capital School District Financial Report - Revenue
As of December 31, 2020
| Budget | Received | Anticipated Receipts | Percent Received | |
|---|---|---|---|---|
| STATE FUNDS | ||||
| Formula Salaries & OEC's | 59,474,025.00 | 52,792,957.00 | 6,681,068.00 | 88.8% |
| Cafeteria Salaries | 950,000.00 | 1,045,103.00 | 0.00 | 110.0% |
| Division II, AOC | 296,107.00 | 296,107.00 | 0.00 | 100.0% |
| Division II, AOC - Voc | 130,485.00 | 130,485.00 | 0.00 | 100.0% |
| Division II, Energy | 1,341,743.00 | 1,432,654.00 | 0.00 | 106.8% |
| Division III, Equalization | 9,671,745.00 | 8,711,300.00 | 960,445.00 | 90.1% |
| State Transportation | 4,947,630.00 | 4,048,785.81 | 898,844.19 | 81.8% |
| Related Services | 196,448.00 | 196,448.00 | 0.00 | 100.0% |
| Drivers Ed. | 23,818.00 | 26,464.00 | 0.00 | 111.1% |
| Unique Alternative | 114,520.00 | 501,884.39 | 0.00 | 438.3% |
| Professional Development | 39,791.00 | 79,581.00 | 0.00 | 200.0% |
| Minor Capital Improvements | 581,758.00 | 581,758.00 | 0.00 | 100.0% |
| Major Capital Improvements | 18,762,525.00 | 39,506,325.00 | 0.00 | 210.6% |
| Educational Sustainment Fund | 1,381,998.00 | 1,381,998.00 | 0.00 | 100.0% |
| Technology Block Grant | 117,000.00 | 199,339.00 | 0.00 | 170.4% |
| Other State Revenue | 1,100,000.00 | 1,442,216.98 | 0.00 | 131.1% |
| Total State Funds | 99,129,593.00 | 112,373,406.18 | 0.00 | 113.4% |
| LOCAL FUNDS | ||||
| Current Expense Tax Receipts | 14,981,554.00 | 14,278,616.29 | 702,937.71 | 95.3% |
| Debt Service Tax Receipts | 6,903,554.00 | 6,587,305.28 | 316,248.72 | 95.4% |
| Debt Service - Impact Fee | 0.00 | 91,248.54 | 0.00 | 0.0% |
| Tuition Tax Receipts | 5,684,965.00 | 5,421,076.38 | 263,888.62 | 95.4% |
| Minor Capital Tax Receipts | 363,231.00 | 385,352.24 | 0.00 | 106.1% |
| Technology Maintenance Match | 240,775.00 | 222,881.03 | 17,893.97 | 92.6% |
| Interest | 157,119.00 | 241,602.12 | 0.00 | 153.8% |
| CSCRP | 5,000.00 | 25,780.87 | 0.00 | 515.6% |
| Indirect Costs | 285,371.00 | 327,151.34 | 0.00 | 114.6% |
| Cafeteria | 3,000,000.00 | 924,399.45 | 2,075,600.55 | 30.8% |
| Donations | 0.00 | 36,976.00 | 0.00 | 0.0% |
| Building Rental | 62,733.00 | 69,460.00 | 0.00 | 110.7% |
| Erate | 10,000.00 | 0.00 | 10,000.00 | 0.0% |
| Other Match Tax Receipts | 465,000.00 | 408,726.51 | 56,273.49 | 87.9% |
| Charter | -1,730,772.00 | -492,745.09 | -1,238,026.91 | 28.5% |
| Choice | -848,649.00 | 0.00 | -848,649.00 | 0.0% |
| Other Local Revenue | 562,477.00 | 660,836.19 | 0.00 | 117.5% |
| Total Local Funds | 30,142,358.00 | 29,188,667.15 | 953,690.85 | 96.8% |
| Data Service Center | ||||
| Printed: 1/4/2021 | Finance Budgeting & Reporting | |||
Page 5
Capital School District Financial Report - Revenue
As of December 31, 2020
| Budget | Received | Anticipated Receipts | Percent Received | |
|---|---|---|---|---|
| FEDERAL FUNDS | ||||
| IDEA Part B | 1,742,021.00 | 1,812,559.00 | 0.00 | 104.0% |
| Title I | 3,650,404.00 | 3,647,529.00 | 2,875.00 | 99.9% |
| Title II | 662,737.00 | 662,737.00 | 0.00 | 100.0% |
| Title III | 43,266.00 | 45,504.00 | 0.00 | 105.2% |
| Perkins | 222,649.00 | 222,649.00 | 0.00 | 100.0% |
| Other Federal Revenue | 463,008.00 | 734,378.47 | 0.00 | 158.6% |
| Total Federal Funds | 6,784,085.00 | 7,125,356.47 | 0.00 | 105.0% |
| Grand Total All Funds | 136,056,036.00 | 148,687,429.80 | 0.00 | 109.3% |
| Data Service Center | ||||
| Printed: 1/4/2021 | Finance Budgeting & Reporting | |||
Page 6
Budget Page 1 of 1 Budget List Division: 13 - Capital School District Budget Year/Budget Ref: 2021 Option: Current BudgetRef Operating Unit: 99900000 - Board Of Ed/District Expenses Option: Show Expended Payroll Transactions. (This column is a subset of Total Expended transactions) Run Report Percent of Fiscal Year days included: 54.0% Percent of Payrolls included in FY: 53.8% (14 of 26)
| Program | Description | Budget | Encumbered | Encumbered Pct | Expended | Expended Pct | Balance | Total Pct |
|---|---|---|---|---|---|---|---|---|
| 99999 | Default Program Code | $75,000.00 | $0.00 | 0.0% | $727.16 | 1.0% | $74,272.84 | 1.0% |
| 95000 | General | $0.00 | $0.00 | - | $1,614.60 | - | ($1,614.60) | - |
| 95092 | Production Center | $0.00 | $0.00 | - | $4,250.00 | - | ($4,250.00) | - |
| 95408 | Conferences | $0.00 | $0.00 | - | $5,734.00 | - | ($5,734.00) | - |
| 95457 | Professional Services | $0.00 | $0.00 | - | $911.66 | - | ($911.66) | - |
| 95493 | Supplies | $0.00 | $0.00 | - | $327.28 | - | ($327.28) | - |
| Total: $75,000.00 | Total: $0.00 | 0.0% | Total: $13,564.70 | 18.1% | Total: $61,435.30 | 18.1% | ||
| https://secure.dataservice.org/finance2/budget.aspx | 1/13/2021 |
Page 7
Budget Page 1 of 1 Budget List Division: 13 - Capital School District Budget Year/Budget Ref: 2021 Option: Current BudgetRef Operating Unit: 99940100 - Contingency Option: Show Expended Payroll Transactions. (This column is a subset of Total Expended transactions) Run Report Percent of Fiscal Year days included: 54.0% Percent of Payrolls included in FY: 53.8% (14 of 26)
| Program | Description | Budget | Encumbered | Encumbered Pct | Expended | Expended Pct | Balance | Total Pct |
|---|---|---|---|---|---|---|---|---|
| 99999 | Default Program Code | $110,000.00 | $0.00 | 0.0% | $0.00 | 0.0% | $110,000.00 | 0.0% |
| 95452 | Printing | $0.00 | $0.00 | - | $0.00 | - | $0.00 | - |
| Total: $110,000.00 | Total: $0.00 | 0.0% | Total: $0.00 | 0.0% | Total: $110,000.00 | 0.0% | ||
| https://secure.dataservice.org/finance2/budget.aspx | 1/13/2021 |
Page 8
CAPITAL SCHOOL DISTRICT MAJOR CAPITAL EXPENDITURE 12/31/20
| FYB | APPR | Title | End Date | Budget | Encumbered | Current Year Expended | Prior Year Expense | Available | % Spent |
|---|---|---|---|---|---|---|---|---|---|
| 2020 | 50345 | Capital, Construct 800 | 06/30/22 | 18,359,375.00 | 7,383,696.43 | 1,716,820.89 | 1,983,263.49 | 7,275,594.19 | 60% |
| 2021 | 50345 | Capital, Construct 800 | 06/30/23 | 36,642,125.00 | - | - | - | 36,642,125.00 | 0% |
| 2014 | 50409 | Capital Ren Cntrl MS K | 06/30/20 | 845,189.00 | - | - | 845,188.45 | 0.55 | 100% |
| 2021 | 50498 | Capital, Construct Ken | 06/30/23 | 2,864,200.00 | - | - | - | 2,864,200.00 | 0% |
| 58,710,889.00 | 7,383,696.43 | 1,716,820.89 | 2,828,451.94 | 46,781,919.74 | 20% |
Page 9
CAPITAL SCHOOL DISTRICT FEDERAL REPORT 12/31/20
| FYB | APPR | Title | End Date | Budget | Encumbered | Current Year Expended | Prior Year Expense | Available | % Spent |
|---|---|---|---|---|---|---|---|---|---|
| 2019 | 40114 | Iasa Title Ii: Prof D | 11/30/20 | 645,141.00 | - | - | 645,141.00 | - | 100% |
| 2020 | 40114 | Iasa Title Ii: Prof D | 11/30/21 | 641,014.00 | - | 342,589.27 | 132,541.60 | 165,883.13 | 74% |
| 2021 | 40114 | Iasa Title Ii: Prof D | 11/30/22 | 662,737.00 | - | - | - | 662,737.00 | 0% |
| 2019 | 40240 | 21St Century Learning | 11/30/20 | 1,048,335.95 | - | 245,107.04 | 803,228.31 | 0.60 | 100% |
| 2020 | 40240 | 21St Century Learning | 11/30/21 | 1,503,291.38 | - | 381,893.88 | 208,052.58 | 913,344.92 | 39% |
| 2021 | 40240 | 21St Century Learning | 11/30/21 | 302,499.67 | - | 40,511.84 | - | 261,987.83 | 13% |
| 2019 | 40419 | SPF Partnership for Su | 09/29/20 | 30,000.00 | - | 28,999.60 | 668.10 | 332.30 | 99% |
| 2019 | 40532 | Title IV | 11/30/20 | 353,815.00 | - | 8,858.29 | 344,956.71 | - | 100% |
| 2020 | 40532 | Title IV | 11/30/21 | 381,801.00 | - | 166,382.60 | - | 215,418.40 | 44% |
| 2021 | 40532 | Title IV | 11/30/22 | 392,470.00 | - | - | - | 392,470.00 | 0% |
| 2019 | 40554 | Title I | 11/30/20 | 3,343,847.56 | - | 7,399.21 | 3,336,448.35 | - | 100% |
| 2020 | 40554 | Title I | 11/30/21 | 3,456,320.00 | - | 158,263.70 | 3,298,353.58 | (297.28) | 100% |
| 2021 | 40554 | Title I | 11/30/22 | 3,647,529.00 | 35,492.91 | 1,599,709.99 | - | 2,012,326.10 | 45% |
| 2019 | 40560 | English Acquisition | 11/30/20 | 35,992.00 | - | 518.46 | 35,473.54 | - | 100% |
| 2020 | 40560 | English Acquisition | 11/30/21 | 34,829.00 | - | 9,024.06 | 25,804.94 | - | 100% |
| 2021 | 40560 | English Acquisition | 11/30/22 | 45,504.00 | - | 5,421.10 | - | 40,082.90 | 12% |
| 2019 | 40564 | Idea-B | 11/30/21 | 1,682,358.06 | - | 704.22 | 1,681,653.84 | - | 100% |
| 2020 | 40564 | Idea-B | 11/30/21 | 1,683,719.00 | - | 270,504.62 | 1,413,712.35 | (497.97) | 100% |
| 2021 | 40564 | Idea-B | 11/30/22 | 1,742,021.00 | 6,480.00 | 605,743.47 | - | 1,129,797.53 | 35% |
| 2019 | 40565 | Idea Preschool | 11/30/20 | 57,009.00 | - | - | 57,009.00 | - | 100% |
| 2020 | 40565 | Idea Preschool | 11/30/21 | 67,409.00 | - | - | 67,409.00 | - | 100% |
| 2021 | 40565 | Idea Preschool | 11/30/22 | 70,538.00 | - | - | - | 70,538.00 | 0% |
| 2019 | 40570 | Homeless | 11/30/20 | 24,992.90 | - | - | 24,992.90 | - | 100% |
| 2020 | 40570 | Homeless | 11/30/21 | 63,131.76 | - | 33,353.96 | 21,908.89 | 7,868.91 | 88% |
| 2019 | 40590 | Project AWARE | 10/29/20 | 133,684.68 | - | 36,139.83 | 43,684.68 | 53,860.17 | 60% |
| 2020 | 40590 | Project AWARE | 10/29/20 | 38,000.00 | - | 4,772.92 | 11,237.44 | 21,989.64 | 42% |
| 2019 | 41015 | Career Tech | 11/30/21 | 249,695.39 | 2,508.39 | - | 247,187.00 | - | 100% |
| 2020 | 41015 | Career Tech | 11/30/21 | 248,639.00 | 5,055.61 | 35,736.77 | 126,195.03 | 81,651.59 | 67% |
| 2020 | 40730 | School Emergency Relie | 11/30/22 | 2,979,542.00 | 5,285.00 | 2,408,499.47 | - | 565,757.53 | 81% |
| 2020 | 40768 | Gov Emrg Ed Rel Fund C | 12/30/22 | 334,615.00 | 53,900.00 | - | - | 280,715.00 | 16% |
| 2017 | 41076 | School Improvement | 06/30/21 | 312,418.97 | - | 102,237.46 | - | 210,181.51 | 33% |
| 26,212,900.32 | 108,721.91 | 6,492,371.76 | 12,525,658.84 | 7,086,147.81 | 73% |