Budget report
November 2019
Capital School District, November 2019.
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
November 30, 2019
Operating Expenses
Monthly Report of Revenues
Detail Board Budget (99900000)
Detail Contingency Budget (99940100)
Internal Account Summary*
Major Cap Balances
Major Cap Change Orders
Federal Funds
Tax Exempt Requests
- •November's Information will be provided with December's Report.
Page 2
12/5/2019 Operating Unit Expenditure Summary as of 11/30/2019 Page: 1
Division - 13 Capital School District Percent of Fiscal Year days included: 41.9%
| 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% | $29,726.02 | 65.60% | $29,726.02 | 65.60% | $15,585.98 |
| 9130634A - South Dover Elementary School | $72,704.00 | $0.00 | 0.00% | $21,419.30 | 29.46% | $21,419.30 | 29.46% | $51,284.70 |
| 9130635A - North Dover Elementary School | $44,288.00 | $0.00 | 0.00% | $33,348.53 | 75.30% | $33,348.53 | 75.30% | $10,939.47 |
| 9130636A - Booker T. Washington Es | $35,328.00 | $0.00 | 0.00% | $9,994.79 | 28.29% | $9,994.79 | 28.29% | $25,333.21 |
| 9130638A - Fairview Elementary School | $36,736.00 | $0.00 | 0.00% | $17,547.24 | 47.77% | $17,547.24 | 47.77% | $19,188.76 |
| 9130640A - Hartly Elementary School | $37,376.00 | $0.00 | 0.00% | $18,810.06 | 50.33% | $18,810.06 | 50.33% | $18,565.94 |
| 9130642A - Towne Point Elementary School | $36,864.00 | $0.00 | 0.00% | $12,880.64 | 34.94% | $12,880.64 | 34.94% | $23,983.36 |
| 9130644A - Central Middle School | $135,767.00 | $2,500.00 | 1.84% | $40,967.53 | 30.17% | $43,467.53 | 32.02% | $92,299.47 |
| 9130646A - William Henry Middle School | $135,300.00 | $165.83 | 0.12% | $59,471.19 | 43.96% | $59,637.02 | 44.08% | $75,662.98 |
| 9130648A - Dover High School | $293,600.00 | $0.00 | 0.00% | $168,686.70 | 57.45% | $168,686.70 | 57.45% | $124,913.30 |
| 9130650A - Kent County Community School | $592,000.00 | $22,858.47 | 3.86% | $296,834.90 | 50.14% | $319,693.37 | 54.00% | $272,306.63 |
| 9130655A - Kent County Secondary Ilc | $632,300.00 | $1,065.55 | 0.17% | $291,695.03 | 46.13% | $292,760.58 | 46.30% | $339,539.42 |
| 99900000 - Board Of Ed/District Expenses | $61,460.00 | $0.00 | 0.00% | $21,962.08 | 35.73% | $21,962.08 | 35.73% | $39,497.92 |
| 99900100 - Legal Services | $69,000.00 | $0.00 | 0.00% | $36,293.14 | 52.60% | $36,293.14 | 52.60% | $32,706.86 |
| 99900300 - District Expenditures | $24,973,917.00 | $0.00 | 0.00% | $12,406,472.25 | 49.68% | $12,406,472.25 | 49.68% | $12,567,444.75 |
| 99910010 - District Office | $46,676.00 | $0.00 | 0.00% | $20,310.71 | 43.51% | $20,310.71 | 43.51% | $26,365.29 |
| 99910100 - Superintendent | $106,597.00 | $0.00 | 0.00% | $17,494.29 | 16.41% | $17,494.29 | 16.41% | $89,102.71 |
| 99920000 - Curriculum/Instructional | $403,261.00 | $86,621.05 | 21.48% | $223,315.35 | 55.38% | $309,936.40 | 76.86% | $93,324.60 |
| 99920600 - Technology (Instructional) | $171,600.00 | $303,270.32 | 176.73% | $72,529.34 | 42.27% | $375,799.66 | 219.00% | ($204,199.66) |
| 99920700 - Athletics | $268,600.00 | $0.00 | 0.00% | $115,391.03 | 42.96% | $115,391.03 | 42.96% | $153,208.97 |
| 99921000 - Support Services | $536,958.00 | $0.00 | 0.00% | $249,893.76 | 46.54% | $249,893.76 | 46.54% | $287,064.24 |
| 99921050 - Special Education | $532,754.00 | $19,263.90 | 3.62% | $86,896.21 | 16.31% | $106,160.11 | 19.93% | $426,593.89 |
| 99930200 - Special School Tuition Payment | $725,124.00 | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $725,124.00 |
| 99930300 - Special Services | $50,723.00 | $0.00 | 0.00% | $42,824.68 | 84.43% | $42,824.68 | 84.43% | $7,898.32 |
| 99940000 - Business Office/Finance | $176,636.00 | $23,583.46 | 13.35% | $59,241.64 | 33.54% | $82,825.10 | 46.89% | $93,810.90 |
| 99940050 - Facilities Management | $51,408.00 | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $51,408.00 |
| 99940100 - Contingency | $109,191.00 | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $109,191.00 |
| 99940200 - Division I Sal/Other State Prg | $60,199,065.00 | $0.00 | 0.00% | $21,347,735.74 | 35.46% | $21,347,735.74 | 35.46% | $38,851,329.26 |
| 99940600 - Insurance | $120,822.00 | $40,536.40 | 33.55% | $85,560.60 | 70.82% | $126,097.00 | 104.37% | ($5,275.00) |
| 99940700 - Private Grants/Donations | $438,304.00 | $0.00 | 0.00% | $172,125.57 | 39.27% | $172,125.57 | 39.27% | $266,178.43 |
| 99940900 - Tuition Reimbursement | $72,000.00 | $0.00 | 0.00% | $23,975.08 | 33.30% | $23,975.08 | 33.30% | $48,024.92 |
| 99950000 - Personnel/Hr | $50,000.00 | $0.00 | 0.00% | $36,163.74 | 72.33% | $36,163.74 | 72.33% | $13,836.26 |
| 99960000 - Child Nutrition Operations | $5,200,000.00 | $35,335.00 | 0.68% | $2,205,673.66 | 42.42% | $2,241,008.66 | 43.10% | $2,958,991.34 |
| 99960100 - Maintenance | $541,265.00 | $48,289.13 | 8.92% | $276,594.89 | 51.10% | $324,884.02 | 60.02% | $216,380.98 |
| 99960200 - Operations/Utilities | $1,954,468.00 | $281,988.60 | 14.43% | $544,195.00 | 27.84% | $826,183.60 | 42.27% | $1,128,284.40 |
| 99960300 - State Transportation | $4,544,698.00 | $9,391.26 | 0.21% | $1,643,443.36 | 36.16% | $1,652,834.62 | 36.37% | $2,891,863.38 |
| 99960400 - Local Transportation | $458,326.00 | $0.00 | 0.00% | $119,775.33 | 26.13% | $119,775.33 | 26.13% | $338,550.67 |
| 99960500 - Fleet Vehicles | $81,058.00 | $0.00 | 0.00% | $17,479.26 | 21.56% | $17,479.26 | 21.56% | $63,578.74 |
| 99970000 - Local Debt Service | $6,761,698.12 | $0.00 | 0.00% | $4,023,329.64 | 59.50% | $4,023,329.64 | 59.50% | $2,738,368.48 |
| 99970040 - LOCAL TECHNOLOGY MATCH TAX | $598,548.00 | $95,727.00 | 15.99% | $119,543.06 | 19.97% | $215,270.06 | 35.97% | $383,277.94 |
Data Service Center
Page 3
12/5/2019 Operating Unit Expenditure Summary as of 11/30/2019 Page: 2
Division - 13 Capital School District Percent of Fiscal Year days included: 41.9%
| Operating Unit | Budget | Encumbered | Pct Enc | Expended | Pct Exp | Total Exp./Enc. | Percent Obligated | Unencumbered Balance |
|---|---|---|---|---|---|---|---|---|
| 99970200 - Minor Cap | $1,013,830.00 | $46,101.58 | 4.55% | $613,679.52 | 60.53% | $659,781.10 | 65.08% | $354,048.90 |
| 99970600 - Parent Early Education | $237,900.00 | $0.00 | 0.00% | $18,993.85 | 7.98% | $18,993.85 | 7.98% | $218,906.15 |
| 99970680 - School Supervision | $842,232.00 | $0.00 | 0.00% | $430,439.73 | 51.11% | $430,439.73 | 51.11% | $411,792.27 |
| 99980000 - Summer School | $20,000.00 | $0.00 | 0.00% | $7,421.14 | 37.11% | $7,421.14 | 37.11% | $12,578.86 |
| 99990500 - Copy Center/Copiers | $128,752.00 | $0.00 | 0.00% | $65,465.98 | 50.85% | $65,465.98 | 50.85% | $63,286.02 |
| 99990600 - Homebound | $290,000.00 | $0.00 | 0.00% | $266,456.20 | 91.88% | $266,456.20 | 91.88% | $23,543.80 |
| 99990700 - AUSTISTIC PROGRAM | $352,322.00 | $19,954.04 | 5.66% | $266,201.36 | 75.56% | $286,155.40 | 81.22% | $66,166.60 |
| Budget Totals | $114,286,768.12 | $1,036,651.59 | 0.91% | $46,638,259.12 | 40.81% | $47,674,910.71 | 41.72% | $66,611,857.41 |
| Current Year Unassigned Expenses | $229,572.41 | $2,566,813.04 | $2,796,385.45 | |||||
| Previous Budget Year Expenses | $174,948.94 | $3,007,448.44 | $3,182,397.38 | |||||
| Total Expenses | $1,441,172.94 | $52,212,520.60 | $53,653,693.54 |
Data Service Center
Page 4
Capital School District Financial Report - Revenue
As of November 30, 2019
| Budget | Received | Anticipated Receipts | Percent Received | |
|---|---|---|---|---|
| STATE FUNDS | ||||
| Formula Salaries & OEC's | 60,994,784.00 | 48,890,050.55 | 12,104,733.45 | 80.2% |
| Cafeteria Salaries | 914,630.00 | 862,028.00 | 52,602.00 | 94.2% |
| Division II, AOC | 200,000.00 | 1,271,623.59 | 0.00 | 635.8% |
| Division II, AOC - Voc | 157,953.00 | 173,980.00 | 0.00 | 110.1% |
| Division II, Energy | 1,368,897.00 | 1,490,825.00 | 0.00 | 108.9% |
| Division III, Equalization | 8,840,319.00 | 9,629,162.00 | 0.00 | 108.9% |
| State Transportation | 4,640,000.00 | 2,613,382.23 | 2,026,617.77 | 56.3% |
| Related Services | 150,000.00 | 167,554.00 | 0.00 | 111.7% |
| Drivers Ed. | 20,756.00 | 26,464.00 | 0.00 | 127.5% |
| Unique Alternative | 65,257.00 | 65,257.00 | 0.00 | 100.0% |
| Professional Development | 70,000.00 | 79,767.00 | 0.00 | 114.0% |
| Minor Capital Improvements | 646,982.00 | 646,982.00 | 0.00 | 100.0% |
| Major Capital Improvements | 11,750,000.00 | 0.00 | 11,750,000.00 | 0.0% |
| Educational Sustainment Fund | 1,472,784.00 | 1,357,983.00 | 114,801.00 | 92.2% |
| Technology Block Grant | 117,714.00 | 205,831.00 | 0.00 | 174.9% |
| Other State Revenue | 993,277.00 | 996,237.24 | 0.00 | 100.3% |
| Total State Funds | 92,403,353.00 | 68,477,126.61 | 23,926,226.39 | 74.1% |
| LOCAL FUNDS | ||||
| Current Expense Tax Receipts | 13,295,498.00 | 12,501,738.44 | 793,759.56 | 94.0% |
| Debt Service Tax Receipts | 7,026,472.00 | 6,453,414.24 | 573,057.76 | 91.8% |
| Debt Service - Impact Fee | 0.00 | 73,024.22 | 0.00 | 0.0% |
| Tuition Tax Receipts | 5,185,244.00 | 5,001,192.54 | 184,051.46 | 96.5% |
| Minor Capital Tax Receipts | 404,949.00 | 370,843.69 | 34,105.31 | 91.6% |
| Technology Maintenance Match | 233,928.00 | 218,221.07 | 15,706.93 | 93.3% |
| Interest | 100,000.00 | 154,541.90 | 0.00 | 154.5% |
| Athletics | 0.00 | 24,934.00 | 0.00 | 0.0% |
| CSCRP | 5,000.00 | 26,121.84 | 0.00 | 522.4% |
| Indirect Costs | 250,000.00 | 82,073.90 | 167,926.10 | 32.8% |
| Cafeteria | 3,000,000.00 | 1,377,740.60 | 1,622,259.40 | 45.9% |
| Donations | 0.00 | 24,930.77 | 0.00 | 0.0% |
| Building Rental | 100,000.00 | 75,530.50 | 24,469.50 | 75.5% |
| Erate | 10,000.00 | 10,138.99 | 0.00 | 101.4% |
| Other Match Tax Receipts | 400,000.00 | 450,659.00 | 0.00 | 112.7% |
| Charter | -1,567,776.00 | -567,874.75 | -999,901.25 | 36.2% |
| Choice | -760,077.00 | 10,033.36 | -770,110.36 | -1.3% |
| Other Local Revenue | 100,000.00 | 748,204.78 | 0.00 | 748.2% |
| Total Local Funds | 27,783,238.00 | 27,035,469.09 | 747,768.91 | 97.3% |
Data Service Center
Printed: 12/5/2019 Finance Budgeting & Reporting
Page 5
Capital School District Financial Report - Revenue
As of November 30, 2019
| Budget | Received | Anticipated Receipts | Percent Received | |
|---|---|---|---|---|
| FEDERAL FUNDS | ||||
| IDEA Part B | 1,740,648.00 | 1,752,151.00 | 0.00 | 100.7% |
| Title I | 3,433,914.00 | 3,449,023.00 | 0.00 | 100.4% |
| Title II | 639,290.00 | 639,290.00 | 0.00 | 100.0% |
| Title III | 33,567.00 | 34,829.00 | 0.00 | 103.8% |
| Perkins | 234,858.00 | 246,942.00 | 0.00 | 105.1% |
| Other Federal Revenue | 1,389,346.00 | 411,592.86 | 977,753.14 | 29.6% |
| Total Federal Funds | 7,471,623.00 | 6,533,827.86 | 937,795.14 | 87.4% |
Grand Total All Funds 127,658,214.00 102,046,423.56 25,611,790.44 79.9%
Data Service Center
Printed: 12/5/2019 Finance Budgeting & Reporting
Page 6
Budget Page 1 of 1
Budget List
Division: 13 - Capital School District
Budget Year/Budget Ref: 2020
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: 43.3% Percent of Payrolls included in FY: 42.3% (11 of 26)
| Program | Description | Budget | Encumbered | Encumbered Pct | Expended | Expended Pct | Balance | Total Pct |
|---|---|---|---|---|---|---|---|---|
| 99999 | Default Program Code | $61,460.00 | $0.00 | 0.0% | $915.68 | 1.5% | $60,544.32 | 1.5% |
| 95000 | General | $0.00 | $0.00 | - | $1,401.97 | - | ($1,401.97) | - |
| 95092 | Production Center | $0.00 | $0.00 | - | $4,250.00 | - | ($4,250.00) | - |
| 95235 | Computer Software | $0.00 | $0.00 | - | $50.60 | - | ($50.60) | - |
| 95408 | Conferences | $0.00 | $0.00 | - | $11,649.00 | - | ($11,649.00) | - |
| 95451 | Postage | $0.00 | $0.00 | - | $63.20 | - | ($63.20) | - |
| 95457 | Professional Services | $0.00 | $0.00 | - | $2,156.95 | - | ($2,156.95) | - |
| 95493 | Supplies | $0.00 | $0.00 | - | $1,146.70 | - | ($1,146.70) | - |
| 99533 | Contracted Services | $0.00 | $0.00 | - | $35.00 | - | ($35.00) | - |
| 99598 | Computers | $0.00 | $0.00 | - | $870.48 | - | ($870.48) | - |
| Total: $61,460.00 | Total: $0.00 | 0.0% | Total: $22,539.58 | 36.7% | Total: $38,920.42 | 36.7% |
https://secure.dataservice.org/finance2/budget.aspx 12/5/2019
Page 7
Budget Transactions Page 5 of 5
Program Appr Account Fund Code Location Trans ID Accounting Date Trans Type Trans Line Num Trans Schd Line Num Trans Distrib Line Num Ref Trans ID Ref Line Num Ref Schd Line Num Ref Distrib Line Num Vendor ID Vendor Name Description Amount Total: $22,539.58
Return to Budget Screen
https://secure.dataservice.org/finance2/BudgetTrans.aspx?Div=13&BudgetYear=2020&OperatingUnit=99900000&TransTypeI... 12/5/2019
Page 8
Budget Page 1 of 1
Budget List Division: 13 - Capital School District Budget Year/Budget Ref: 2020 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: 43.3% Percent of Payrolls included in FY: 42.3% (11 of 26)
| Program | Description | Budget | Encumbered | Encumbered Pct | Expended | Expended Pct | Balance | Total Pct |
|---|---|---|---|---|---|---|---|---|
| 99999 | Default Program Code | $109,191.00 | $0.00 | 0.0% | $0.00 | 0.0% | $109,191.00 | 0.0% |
| Total: $109,191.00 | Total: $0.00 | 0.0% | Total: $0.00 | 0.0% | Total: $109,191.00 | 0.0% |
https://secure.dataservice.org/finance2/budget.aspx 12/5/2019
Page 9
CAPITAL SCHOOL DISTRICT MAJOR CAPITAL EXPENDITURE 11/29/19
| FYB | APPR | Title | End Date | Budget | Encumbered | Expended | Available | Prior Year Expense | % Spent |
|---|---|---|---|---|---|---|---|---|---|
| 2013 | 50285 | High School | 06/30/20 | 34,732,300.00 | 21,388.71 | 34,707,542.82 | 3,368.47 | 34,707,542.82 | 100% |
| 2014 | 50409 | Central Middle School | 06/30/20 | 845,189.00 | - | 845,188.45 | 0.55 | 845,188.45 | 100% |
| 2015 | 50410 | KCCS - BTW | 06/30/19 | 7,639,137.00 | - | 7,639,127.00 | 10.00 | 7,639,127.00 | 100% |
| Total | 43,216,626.00 | 21,388.71 | 43,191,858.27 | 3,379.02 | 43,191,858.27 | 100% |
Page 10
CAPITAL SCHOOL DISTRICT FEDERAL REPORT 11/29/19
| FYB | APPR | Title | End Date | Budget | Encumbered | Current Year Expended | Prior Year Expense | Available | % Spent |
|---|---|---|---|---|---|---|---|---|---|
| 2018 | 40114 | Title II - Teacher Quality | 11/30/19 | 611,947.00 | - | 270,516.16 | 341,430.84 | - | 100% |
| 2019 | 40114 | Title II - Teacher Quality | 11/30/20 | 645,107.00 | - | 208,510.60 | 296,774.28 | 139,822.12 | 78% |
| 2020 | 40114 | Title II - Teacher Quality | 11/30/21 | 639,290.00 | - | - | - | 639,290.00 | 0% |
| 2018 | 40240 | 21St Century Learning | 11/30/19 | 970,000.00 | - | 72,185.80 | 897,814.20 | - | 100% |
| 2019 | 40240 | 21St Century Learning | 09/30/20 | 1,010,000.00 | - | 369,272.03 | 20,943.68 | 619,784.29 | 39% |
| 2019 | 40530 | Impact Aid Displaced S | 02/28/19 | 24,500.00 | - | - | 24,500.00 | - | 100% |
| 2018 | 40532 | Title IV | 11/30/19 | 120,496.00 | - | - | 120,496.00 | - | 100% |
| 2019 | 40532 | Title IV | 11/30/20 | 353,005.00 | - | 98,091.21 | 127,750.38 | 127,163.41 | 64% |
| 2020 | 40532 | Title IV | 11/30/21 | 380,242.00 | - | - | - | 380,242.00 | 0% |
| 2018 | 40554 | Title I | 11/30/19 | 3,382,967.00 | - | 6,928.89 | 3,376,038.11 | - | 100% |
| 2019 | 40554 | Title I | 11/30/20 | 3,341,787.00 | 9,376.20 | 1,105.91 | 3,331,182.38 | 122.51 | 100% |
| 2020 | 40554 | Title I | 11/30/21 | 3,449,023.00 | 27,399.00 | 1,597,553.48 | - | 1,824,070.52 | 47% |
| 2018 | 40560 | English Acquisition | 11/30/19 | 38,058.00 | - | - | 38,058.00 | - | 100% |
| 2019 | 40560 | English Acquisition | 11/30/20 | 35,992.00 | - | 12,125.23 | 23,139.18 | 727.59 | 98% |
| 2020 | 40560 | English Acquisition | 11/30/21 | 34,829.00 | - | 14,224.10 | - | 20,604.90 | 41% |
| 2018 | 40564 | Idea-B (3-21) | 11/30/19 | 1,646,667.00 | - | 5,300.00 | 1,641,367.00 | - | 100% |
| 2019 | 40564 | Idea-B (3-21) | 11/30/20 | 1,674,871.00 | 534.00 | 934,683.35 | 519,837.10 | 219,816.55 | 87% |
| 2020 | 40564 | Idea-B (3-21) | 11/30/21 | 1,684,713.00 | - | - | - | 1,684,713.00 | 0% |
| 2018 | 40565 | Idea Preschool | 11/30/19 | 55,074.00 | - | - | 55,074.00 | - | 100% |
| 2019 | 40565 | Idea Preschool | 11/30/20 | 57,009.00 | - | 7,708.90 | 49,300.10 | - | 100% |
| 2020 | 40565 | Idea Preschool | 11/30/21 | 67,438.00 | - | 28,773.34 | - | 38,664.66 | 43% |
| 2018 | 40570 | Homeless | 11/30/19 | 22,965.41 | - | - | 22,965.41 | - | 100% |
| 2019 | 40570 | Homeless | 11/30/20 | 24,992.90 | - | 15,952.54 | 9,040.36 | - | 100% |
| 2020 | 40570 | Homeless | 11/30/21 | 31,350.86 | - | 9,118.38 | - | 22,232.48 | 29% |
| 2019 | 40590 | Project AWARE | 11/22/19 | 43,684.68 | - | 41,339.15 | 2,345.53 | - | 100% |
| 2018 | 41015 | Perkins: Vocational Education | 11/30/19 | 240,207.13 | - | 10,042.88 | 230,164.25 | - | 100% |
| 2019 | 41015 | Perkins: Vocational Education | 11/30/19 | 246,847.00 | - | 93,175.67 | 153,671.33 | - | 100% |
| 2020 | 41015 | Perkins: Vocational Education | 11/30/20 | 246,942.00 | 81,247.67 | 19,560.44 | - | 146,133.89 | 41% |
| Total | 21,080,004.98 | 118,556.87 | 3,816,168.06 | 11,281,892.13 | 5,863,387.92 | 72% |