Spreadsheet: 728569d1618513876-index-multiple-tables-from-multiple-sheets-same-workbook-into-master-table-sample-21-22-budget-proposed-2-
Sheet: 100 - General Fund

RESOURCES
GENERAL FUND
 |  | ACTUAL |  | ADOPTED |  | FY 2021-2022
Account | Account Description | FY 18/19 | FY 19/20 | FY 20/21 |  | Proposed | Approved | Adopted
100.0000.1111.000.000 | Current Year Taxes | 2054618.78 | 2051751.9 | 2000000 |  | 2050000
100.0000.1112.000.000 | Prior Year Taxes | 136199.55 | 84443 | 130000 |  | 90000
100.0000.1510.000.000 | Earnings On Investments | 62051.2 | 53744.94 | 15000 |  | 15000
100.0000.1910.000.000 | Rentals | 1575 | 4500 | 1200 |  | 1200
100.0000.1941.000.000 | Contracted Services | 50600 | 47000 | 47000
100.0000.1942.000.000 | Internet/Wireless Services | 525 | 300 | 500 |  | 500
100.0000.1943.000.000 | Technology Services | 0 |  | 500 |  | 500
100.0000.1990.000.000 | Misc Revenue Non-Profits | 13282.56 | 23209.09 | 10000 |  | 10000
100.0000.2900.000.000 | Restricted Grant - County | 54300 | 54300 | 54300 |  | 54300
100.0000.5200.000.000 | Transfer from CCF Excess Fund | 0 | 0 | 0 |  | 2551
100.0000.5400.000.000 | Beginning Fund Balance | 1444047.64 | 1477813.41 | 1400000 |  | 1400000
 | General Fund Totals
EXPENDITURES
GENERAL FUND - Special Education
 |  |  |  | ADOPTED
 |  |  |  |  | # of Emp
100.1250.0111.888.320 | Certified Salaries | 28457.84 | 29924.29 | 32252.18131578947
100.1250.0112.888.320 | Classified Salaries | 40156.3 | 45716.67 | 51082.418848
100.1250.0121.888.320 | Substitutes-Licensed | 0 | 0 | 1500 |  | 1500
100.1250.0122.888.320 | Substitutes-Classified | 140.7 | 0 | 1500 |  | 1500
100.1250.0211.888.320 | Employer Contribution | 21139.17 | 6332.35 | 11541.84212268484
100.1250.0213.888.320 | PERS UAL |  | 10574.89 | 15150.23030977692
100.1250.0220.888.320 | Social Security | 6264.48 | 5639 | 6375.096912529894
100.1250.0231.888.320 | Worker's Compensation | 393.72 | 422.68 | 1666.692003275789
100.1250.0232.888.320 | Unemployment Compensation | 81.87 | 56.65 | 1666.692003275789
100.1250.0233.888.320 | Paid Family Medical Leave Insurance
100.1250.0241.888.320 | Health Insurance | 27605.08 | 19510.26 | 21018
100.1250.0244.888.320 | Tuition Reimbursement | 0 |  | 10000 |  | 10000
100.1250.0310.888.320 | Instr, Prof, & Tech Svcs. | 103.75 | 800 | 40000 |  | 1000
100.1250.0322.888.320 | Equipment Repair/Maintenance | 822.02 | 1646.84 | 1200 |  | 1200
100.1250.0341.888.320 | Travel, Local In District | 3410.56 | 2529.98 | 4000 |  | 4000
100.1250.0342.888.320 | Travel, Out of District | 1147.59 | 707.44 | 2000 |  | 2000
100.1250.0351.888.320 | Telephone | 1904.22 | 3002.36 | 3000 |  | 3000
100.1250.0353.888.320 | Postage | 19.25 | 221.46 | 500 |  | 500
100.1250.0354.888.320 | Advertising | 0 | 0 | 200 |  | 200
100.1250.0380.888.320 | Non-Instr. Prof. & Tech. Servi | 0 | 0 | 100 |  | 100
100.1250.0382.888.320 | Legal Services | 2250 | 0 | 0 |  | 0
100.1250.0410.888.320 | Consumable Supplies & Material | 1838.5 | 1964.8 | 3000 |  | 3000
100.1250.0460.888.320 | Non.Consumable Items | 299 | 1784 | 1000 |  | 1000
100.1250.0470.888.320 | Computer Software | 593.4 | 176.4 | 2200 |  | 2200
100.1250.0480.888.320 | Computer Hardware | 0 | 299 | 1600 |  | 1600
100.1250.0590.888.320 | Depreciable Capital Outlay | 5979.75 |  | 0 |  | 0
Totals - Special Education
TOTAL - Instructional Services
EXPENDITURES
GENERAL FUND - Attendance/Social Work Services
 |  | ACTUAL |  | ADOPTED
Account | Account Description |  |  |  | # of Emp.
100.2110.0111.888.000 | Certified Salaries |  |  | 10170.351
100.2110.0111.888.001 | Classified Salaries |  |  | 2889.394
100.2110.0211.888.000 | Employer Contribution |  |  | 1808.7746825
100.2110.0213.888.000 | PERS UAL |  |  | 2374.261641
100.2110.0220.888.000 | Social Security |  |  | 778.0318515
100.2110.0231.888.000 | Worker's Compensation |  |  | 203.40702
100.2110.0232.888.000 | Unemployment Compensation |  |  | 203.40702
100.2110.0233.888.000 | Paid Family Medical Leave Insurance
100.2110.0241.888.000 | Health Insurance |  |  | 2790
100.2110.0351.888.000 | Telephone |  |  | 500 |  | 500
100.2110.0353.888.000 | Postage |  | 13.7 | 150 |  | 150
100.2110.0410.888.000 | Consumable Supplies |  | 89.7 | 500 |  | 500
Totals - Attendance & Social Work Services
EXPENDITURES
GENERAL FUND - Speech
 |  | ACTUAL |  | ADOPTED
Account | Account Description |  |  |  | # of Emp.
100.2150.0111.888.320 | Certified Salaries | 62305.5 | 65457.52 | 68769.56
100.2150.0112.888.320 | Classified Salaries | 57664.5 | 74240.6 | 88060.516
100.2150.0211.888.320 | Employer Contribution | 28786.22 | 14862.84 | 19722.576726
100.2150.0213.888.320 | PERS UAL | 0 | 20050.23 | 28511.7078168
100.2150.0220.888.320 | Social Security | 8911.79 | 10656.78 | 11997.500814
100.2150.0231.888.320 | Worker's Compensation | 550.5 | 606.62 | 3136.60152
100.2150.0232.888.320 | Unemployment Compensation | 116.46 | 106.3 | 3136.60152
100.2150.0233.888.320 | Paid Family Medical Leave Insurance
100.2150.0241.888.320 | Health Insurance | 48904.93 | 47689.42 | 47430.00000000001
100.2150.0242.888.320 | Dental Insurance |  | 1383.48
100.2150.0244.888.320 | Tuition Reimbursement | 0 | 499.8 | 20000 |  | 20000
100.2150.0310.888.320 | Instr, Prof, & Tech Svcs. | 499 | 600 | 500 |  | 500
100.2150.0322.888.320 | Equip Repair/Maintenance | 307.27 | 1324 | 1200 |  | 1200
100.2150.0341.888.320 | Travel, Local in District | 3859.95 | 6074.81 | 5000 |  | 5000
100.2150.0342.888.320 | Travel, Out of District | 0 |  | 1000 |  | 1000
100.2150.0351.888.320 | Telephone | 695.71 | 320.86 | 1500 |  | 1500
100.2150.0353.888.320 | Postage | 0 | 210.47 | 500 |  | 500
100.2150.0354.888.320 | Advertising | 215.1 |  | 200 |  | 200
100.2150.0410.888.320 | Consumable Supplies & Material | 640.01 | 890.04 | 2000 |  | 2000
100.2150.0460.888.320 | Non-Consumable Items | 0 | 3816.16 | 2000 |  | 2000
100.2150.0470.888.320 | Computer Software | 176.4 | 176.4 | 1000 |  | 1000
100.2150.0480.888.320 | Computer Hardware | 0 | 0 | 1000 |  | 1000
100.2150.0590.888.320 | Depreciable Capital Outlay | 5979.75 | 0 | 0 |  | 0
Totals - Speech Pathology & Audiology Services
EXPENDITURES
GENERAL FUND - Special Education
 |  | ACTUAL |  | ADOPTED
Account | Account Description |  |  |  | # of Emp.
100.2190.0111.888.320 | Certified Salaries | 29473.17 | 29924.51 | 32252.18131578947
100.2190.0112.888.320 | Classified Salaries | 11478.5 | 13422.07 | 13300.8312
100.2190.0211.888.320 | Employer Contribution | 9289.31 | 4711.25 | 6309.092233436842
100.2190.0213.888.320 | PERS UAL | 0 | 7056.89 | 8281.537675370526
100.2190.0220.888.320 | Social Security | 3089.79 | 3271.58 | 3484.805457457895
100.2190.0231.888.320 | Worker's Compensation | 185.47 | 197.68 | 911.0602503157895
100.2190.0232.888.320 | Unemployment Compensation | 40.36 | 32.68 | 911.0602503157895
100.2190.0233.888.320 | Paid Family Medical Leave Insurance
100.2190.0241.888.320 | Health Insurance | 12576.24 | 12871.23 | 13392
100.2190.0244.888.320 | Tuition Reimbursement | 0 | 0 | 10000 |  | 10000
100.2190.0322.888.320 | Equipment Repair/Maintenance | 0 | 0 | 1200 |  | 1200
100.2190.0341.888.320 | Travel, Local in District | 0 | 801.36 | 1000 |  | 1000
100.2190.0342.888.320 | Travel, Out of District | 142.93 | 1147.68 | 2000 |  | 2000
100.2190.0351.888.320 | Telephone | 0 | 0 | 1000 |  | 1000
100.2190.0354.888.320 | Advertising | 0 | 0 | 200 |  | 200
100.2190.0410.888.320 | Consumable Supplies & Material | 0 |  | 500 |  | 500
100.2190.0590.888.320 | Depreciable Capital Outlay | 5979.75 | 0 | 0 |  | 0
100.2190.0653.888.320 | Property Insurance | 0 | 816 | 0 |  | 900
Totals - Special Education
EXPENDITURES
GENERAL FUND - School Improvement Services
 |  | ACTUAL |  | ADOPTED
Account | Account Description |  |  |  | # of Emp.
100.2210.0111.888.000 | Certified Salaries | 12708 | 16950.58 | 45904.30131900001
100.2210.0112.888.000 | Classified Salaries | 5440.9 | 6982.97 | 5267.174
100.2210.0211.888.000 | Employer Contribution | 4916.23 | 3273.78 | 7087.249331681502
100.2210.0213.888.000 | PERS UAL | 0 | 4218.76 | 9302.9742129942
100.2210.0220.888.000 | Social Security | 1373.54 | 1811.66 | 3914.6178619035
100.2210.0231.888.000 | Worker's Compensation | 80.35 | 88.12 | 1023.42950638
100.2210.0232.888.000 | Unemployment Compensation | 18 | 19.33 | 1023.42950638
100.2210.0233.888.000 | Paid Family Medical Leave Insurance
100.2210.0241.888.000 | Health Insurance | 4059.79 | 4977.06 | 19158
100.2210.0310.888.000 | Inst, Prof & Tech Services | 8299.88 | 4690 | 10000 |  | 10000
100.2210.0341.888.000 | Travel, Local in District | 0 |  | 5000 |  | 5000
100.2210.0342.888.000 | Travel, Out of District | 0 |  | 5000 |  | 5000
100.2210.0351.888.000 | Telephone | 0 |  | 500 |  | 500
100.2210.0410.888.000 | Consumable Supplies & Material | 359.6 | 997.14 | 500 |  | 500
Totals - School Improvement Services
EXPENDITURES
GENERAL FUND - Board of Education Services
 |  | ACTUAL |  | ADOPTED
Account | Account Description |  |  |  | # of Emp.
100.2310.0340.888.000 | Travel | 1462.52 | 3762.23 | 1000 |  | 1000
100.2310.0354.888.000 | Advertising | 840.13 | 400.33 | 1200 |  | 1200
100.2310.0381.888.000 | Audit & Filing Fee | 10663.63 | 10830.9 | 10570 |  | 10570
100.2310.0382.888.000 | Legal Services | 0 | 400 | 3000 |  | 3000
100.2310.0388.888.000 | Elections | 1153.52 | 0 | 1200 |  | 1200
100.2310.0389.888.000 | Other Professional Services | 9999.96 | 9999.96 | 10000 |  | 10000
100.2310.0410.888.000 | Consumable Supplies | 1290.97 | 294.45 | 500 |  | 500
100.2310.0640.888.000 | Dues & Fees | 3290.87 | 8552.62 | 6000 |  | 10000
100.2310.0651.888.000 | Liability Insurance | 5415 | 5495 | 6500 |  | 6500
Totals - Board of Education Services
EXPENDITURES
GENERAL FUND - Executive Administration
 |  | ACTUAL |  | ADOPTED
Account | Account Description |  |  |  | # of Emp.
100.2320.0113.888.000 | Administrator | 23461.07 | 19941.86 | 20340.702
100.2320.0211.888.000 | Employer Contribution | 6381.47 | 2761.94 | 2817.187227
100.2320.0213.888.000 | PERS UAL | 0 | 3625.46 | 3697.9396236
100.2320.0220.888.000 | Social Security | 1780.08 | 1512.41 | 1556.063703
100.2320.0231.888.000 | Worker's Compensation | 102.21 | 109.24 | 406.81404
100.2320.0232.888.000 | Unemployment Compensation | 23.25 | 14.06 | 406.81404
100.2320.0233.888.000 | Paid Family Medical Leave Insurance
100.2320.0241.888.000 | Health Insurance | 4745.74 | 3774.4 | 3720
100.2320.0318.888.000 | Prof & Improv Costs-Non-Instr. | 404 | 219 | 1000 |  | 1000
100.2320.0340.888.000 | Travel |  | 53.94
100.2320.0341.888.000 | Travel, Local in District |  |  | 1000 |  | 1000
100.2320.0342.888.000 | Travel, Out of District | 984.79 | 313.15 | 2000 |  | 2000
100.2320.0351.888.000 | Telephone | 0 |  | 200 |  | 200
100.2320.0353.888.000 | Postage | 19.01 |  | 200 |  | 200
100.2320.0410.888.000 | Consumable Supplies & Material | 738.81 | 333.59 | 1000 |  | 1000
100.2320.0640.888.000 | Dues & Fees | 803 | 764 | 1000 |  | 1000
Totals - Executive Administration Services
EXPENDITURES
GENERAL FUND - Fiscal Services
 |  | ACTUAL |  | ADOPTED
Account | Account Description |  |  |  | # of Emp.
100.2520.0112.888.000 | Classified Salaries | 61155.18 | 59580.19 | 68588.354 | 0.7
100.2520.0211.888.000 | Employer Contribution | 16593.82 | 8561.14 | 9499.487029000002
100.2520.0213.888.000 | PERS UAL | 0 | 11701.86 | 12469.3627572
100.2520.0220.888.000 | Social Security | 4601.41 | 4484.2 | 5247.009081
100.2520.0231.888.000 | Worker's Compensation | 277.1 | 285.55 | 1371.76708
100.2520.0232.888.000 | Unemployment Compensation | 68.76 | 43.58 | 1371.76708
100.2520.0233.888.000 | Paid Family Medical Leave Insurance
100.2520.0241.888.000 | Health Insurance | 16361.94 | 15624 | 11160
100.2520.0318.888.000 | Prof & Improv Costs- Non Instructional | 315 | 930.5 | 3000 |  | 3000
100.2520.0322.888.000 | Equip. Repair/Maintenance | 0 | 411.11 | 500 |  | 500
100.2520.0340.888.000 | Travel | 1728.5 | 1259.25 | 2500 |  | 2500
100.2520.0410.888.000 | Consumable Supplies & Material | 447.48 | 1286.4 | 2000 |  | 2000
100.2520.0460.888.000 | Non-Consumable Items | 1415 |  | 1000 |  | 1000
100.2520.0470.888.000 | Computer Software | 5878.2 | 5783.62 | 7000 |  | 7000
100.2520.0480.888.000 | Computer Hardware | 0 |  | 0 |  | 1500
100.2520.0640.888.000 | Dues & Fees | 540 | 430 | 1000 |  | 1000
Totals - Fiscal Services
EXPENDITURES
GENERAL FUND - O&M
 |  | ACTUAL |  | ADOPTED
Account | Account Description
100.2540.0321.888.000 | Cleaning Services | 7550 | 8705 | 8000 |  | 9000
100.2540.0322.888.000 | Equip. Repair/Maintenance | 5805.78 | 1173.2 | 2500 |  | 2500
100.2540.0325.888.000 | Electricity | 5720.63 | 5127.85 | 6000 |  | 6000
100.2540.0327.888.000 | Water & Sewage | 2106.04 | 2264.34 | 2000 |  | 2500
100.2540.0328.888.000 | Garbage | 935 | 1053.6 | 1200 |  | 1200
100.2540.0410.888.000 | Consumable Supplies & Material | 821.24 |  | 1000 |  | 1000
100.2540.0653.888.000 | Property Insurance & Premiums | 3394 | 2887 | 4130
Totals - O & M
EXPENDITURES
GENERAL FUND - Finger Printing
 |  | ACTUAL |  | ADOPTED
Account | Account Description
100.2640.0319.888.320 | Other Inst, Prof & Tech Serv | 0 |  | 100 |  | 0
Totals - Staff Services-Finger Printing
EXPENDITURES
GENERAL FUND - Technology
 |  | ACTUAL |  | ADOPTED
Account | Account Description |  |  |  | # of Emp.
100.2660.0111.888.000 | Certified Salaries | 61585.17 | 62816.88 | 57971.00069999999
100.2660.0112.888.000 | Classified Salaries | 93054.36 | 94618.03 | 102531.604
100.2660.0211.888.000 | Employer Contribution | 31266.33 | 17872.87 | 22229.61075095
100.2660.0213.888.000 | PERS UAL | 0 | 24404.88 | 29179.37353445999
100.2660.0220.888.000 | Social Security | 11659.83 | 11871.3 | 12278.44925955
100.2660.0231.888.000 | Worker's Compensation | 699.05 | 749.65 | 3210.052093999999
100.2660.0232.888.000 | Unemployment Compensation | 283.67 | 117.5 | 3210.052093999999
100.2660.0233.888.000 | Paid Family Medical Leave Insurance
100.2660.0241.888.000 | Health Insurance | 47060.89 | 46456.81 | 57474
100.2660.0310.888.000 | Inst, Prof & Tech Services | 0 | 455.18 | 1500 |  | 1500
100.2660.0322.888.000 | Equip. Repair/Maintenance | 12378.8 | 9194.44 | 10000 |  | 10000
100.2660.0340.888.000 | Travel | 913.05 | 1328.3 | 3000 |  | 3000
100.2660.0351.888.000 | Telephone | 1261.65 | 90.73 | 1000 |  | 1000
100.2660.0353.888.000 | Postage | 40.09 | 232.07 | 500 |  | 500
100.2660.0410.888.000 | Consumable Supplies & Material | 3947.51 | 1790.85 | 5000 |  | 5000
100.2660.0411.888.000 | Fuel | 886.03 | 1201.91 | 5000 |  | 5000
100.2660.0460.888.000 | Non-Consumable Items | 5278.75 | 2186.91 | 8000 |  | 8000
100.2660.0470.888.000 | Computer Software | 21683.18 | 35091.52 | 20000 |  | 20000
100.2660.0480.888.000 | Computer Hardware | 16416.89 | 12229.2 | 5000 |  | 5000
100.2660.0550.888.000 | Depreciable Technology | 0 | 0 | 0 |  | 0
100.2660.0590.888.000 | Depreciable Capital Outlay | 5979.75 | 0 | 0 |  | 0
100.2660.0640.888.000 | Dues and Fees | 0 | 0 | 1000 |  | 1000
100.2660.0653.888.000 | Property Insurance | 738 | 463 | 2500 |  | 2500
100.2669.0325.888.000 | Electricity - Towers | 0 | 0 | 0 |  | 1200
100.2669.0351.888.000 | T-1 Lines | 13179.2 | 16904.4 | 41000 |  | 30000
Totals - Technology Services
TOTAL - Support Services
EXPENDITURES
GENERAL FUND - Apportionment of Funds by ESD
 |  | ACTUAL |  | ADOPTED
Account | Account Description |  |  |  | # of Emp.
100.5200.0710.888.320 | Transfer to YTP |  | 17100.45 |  |  | 0
100.5300.0720.888.000 | Resolutions to Schools | 1330046.91 |  | 1160587.9
100.5400.0680.888.000 | PERS EIF |  | 250000
Totals - Apportionment of Funds by ESD
EXPENDITURES
GENERAL FUND - Operating Contingencies
 |  | ACTUAL |  | ADOPTED
Account | Account Description |  |  |  | # of Emp.
100.6110.0810.888.000 | Planned Reserve | 0 |  | 150000 |  | 150000
100.6110.0811.888.000 | Contingency - PERS/Ins/Emp | 106586.64 | 106587 | 150000 |  | 110000
100.6110.0812.888.000 | Contingency - Distance Education | 11782.39 | 11782 | 12000 |  | 12000
Totals - Operating Contingencies
EXPENDITURES
GENERAL FUND - Unappropriated Ending Fund Balance
 |  | ACTUAL |  | ADOPTED
Account | Account Description |  |  |  | # of Emp.
100.7000.0820.888.000 | Unappropriated Ending Fund Balance | 0 |  | 813365 |  | 640107
Totals - Unappropriated Ending Fund Balance
 | GENERAL FUND TOTALS