Spreadsheet: 0c1f4102-6b35-44f4-852b-428f6e0a9765
Sheet: DSASUMM

 |  |  |  |  |  |  |  | Enrollment Change |  |  |  | Benefit Change |  | 2.5% Salary Reduction |  | Merit/Longevity |  | PERS Equalization |  |  |  | Per Pupil Budget Reduction |  | New Equipment |  |  |  | Transfer RPDP$ to BA 2615 |  | [NAME] to DSA |  | Revenue Adjustments
DISTRIBUTIVE SCHOOL ACCOUNT MAIN WORK SHEET - 2011-13 BIENNIUM
 | 2009-10 |  |  | 2010-11 | % | DSABASE | DSABASE | DSAM200 | DSAM200 | DSAM101 |  | DSAM300 | DSAM300 | DSAE670 |  | DSAE671 |  | DSAE601 |  | DSAE300 |  | DSAE600 |  | DSAE710 |  | DSAE602 |  | DSAE904 |  | DSAE130 |  | [NAME] |  | [NAME] | % CHG | [NAME] | % CHG
 | WK PROGRAM | ACTUAL | % CHG | WK PROGRAM | CHG | 2011-12 | 2012-13
SALARIES | 1813834741 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
SUBSTITUTE PAY | 39306246 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
EXTRA DUTY MISCELLANEOUS | 25416599 | 19265375 |  | 23348803 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
FRINGES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
RETIREMENT | 387981279 | 381217472 |  | 384499471 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
WORKER'S COMP | 14085077 | 7794417 |  | 9375209 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
UNEMPLOYMENT COMP | 1499168 | 6869299 |  | 6488035 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
MEDICARE | 24848431 | 24924833 |  | 26283600 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
MEDICAL INSURANCE | 255724363 | 251025893 |  | 260273017 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
OTHER | 9998816 | 8233092 |  | 8594046 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
TOTAL FRINGES
Sub-Total - Salaries and [NAME]
FULL DAY KINDERGARTEN - 22 | 0 | 0 |  | 0
RETIRED EMPOYEES GROUP INS | 36645582 | 27980315 |  |  |  | 27062825 | 27118499 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
TOTAL SALARY AND FRINGE
BENEFIT/SALARY
OPERATING:
Heat | 15147689 | 12057552 |  | 12626587 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Electricity | 72409307 | 65089232 |  | 70760567 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Pupil Transportation | 25014207 | 16707325 |  | 16907458 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | Total Txtbook, Software, Hardware, Instructional Supplies
Textbooks | 28420804 | 23810368 |  | 36559619 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Library | 2389288 | 2397912 |  | 2674356 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Maintenance/Repair | 37797695 | 25553696 |  | 29366243 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Professional Services | 60276021 | 47269193 |  | 44995473 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Water/Sewer/Garbage | 26434884 | 26757018 |  | 28806985 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Liability Insurance | 14869666 | 5925229 |  | 11103735 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Property Insurance | 2110090 | 1981658 |  | 2096411 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Postage/Communications | 9132685 | 13152322 |  | 15645874 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Printing/Binding | 4744863 | 3217410 |  | 3570599 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Instructional Supplies | 50790482 | 70944435 |  | 43758545 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Instructional Computer Software | 4542022 | 7384984 |  | 12090009 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Other Supplies | 17719581 | 16515016 |  | 12943249 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Other Fuel | 3147423 | 2531857 |  | 2598274 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Staff Travel/Training | 5086485 | 3539980 |  | 3252815 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
All Other | 12417407 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Facility Leasing/Rental | 7564852 | 8531546 |  | 8889492 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
26th Special Session Reduction/ 2011-13 Bud Reduction | -27626901 | 0 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
To balance to district expend | 0 | 0 |  | 11513368 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Charter School Fees/Management Fees | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Nat'l School Lunch Prog State Match | 588732 | 588732 |  | 588732 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
TOTAL OPERATING
EQUIPMENT
Pupil Transportation | 5255992 | 12421609 |  | 2773528 |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Pupil Transportation-Capital Lease | 1995000 | 870000 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Instructional Equipment | 3053548 | 2095024 |  | 5176561 |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Instructional Hardware | 1020155 | 46734 |  | 212200 |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Computer Hardware |  | 1411876 |  | 6247090 |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Computer hardware - Capital Lease |  | 117889 |  | 121612 |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
All Other Equipment | 5809066 | 3582606 |  | 3311490 |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
All Other Equipment-Capital Lease | 298516 | 130074 |  | 41880 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
TOTAL EQUIPMENT
SUBTOTAL EXP
ADJUSTMENTS
Transfer of Funds to State [NAME] | 23415652
Adult Education Expense | 21170456 | 21170456 |  | 22673833
Special Education Adjustment | 0
charter school fees | 0 | 398722
prior year adjustments | 0 |  |  |  |  | 0
NRS Conversion | 3615476 |  |  | 7988911 |  | 0
Other Obligations | 0 |  |  |  |  | 0
TOTAL ADJUSTMENTS
SUBTOTAL EXP
ENDING FUND BAL | 249763067 | 162650614 |  | 81986721
TOTAL EXPENDITURES
LESS
OPENING BALANCE | -251791688
FEDERAL REVENUE | -7863361 | -8499450 |  | -7863361
OTHER LOCAL REVENUE | -94520861 |  |  | -94520861
PSOPT 2/3 (PREVIOUSLY $.50) | -506393209
GOVT SERVICES TAX | -81402633 |  |  | -81402633
FRANCHISE TAX | -4113359 | -3451000 |  | -4236760
OBLIGATIONS |  |  |  |  |  | 0
CHARTER SCHOOL ADJ
[NAME] |  |  |  |  |  | 0
CERTIFIED COUNSELOR STIPEND |  |  |  |  |  | 0
GROUP INS SPEC APPROP
RETIRED EMPL GROUP INS |  |  |  |  |  | 0 | 0
PRIOR FY SHORTFALL IN CURRENT FY |  | -76582
OTHER STATE SUPPORT | -879943 |  |  | -879943
STATE RESPONSIBILITY
LESS:
ADULT EDUCATION | -21170456 | -21170456 |  | -22673833 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
SPECIAL EDUCATION | -121252632 | -121252632 |  | -121252632 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
SPECIAL TRANSPORTATION | -170908 | -128541 |  | -170908
SCHOOL LUNCH PROG MATCH | -588732 | -588732 |  | -588732
GROWTH INCREMENT | 0 | -631134
NON-TRADITIONAL STUDENT | 0 | -182317
NET PROCEEDS FROM MINES | 0
TOTAL BASIC SUPP
WEIGHTED ENROLLMENT | 425270.2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
BASIC SUPPORT PER PUPIL
CLASS SIZE REDUCTION-16* | 142682929 |  |  | 144348993 |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
SPECIAL EDUCATION-15 | 121252632 | 121252632 |  | 121252632 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
SPEC UNITS/GIFTED & TALENT-33 | 162571 | 162566 |  | 167459 |  |  |  |  |  | 0 | 0
ADULT HIGH SCHOOL DIPLOMA-78 | 21170456 | 21170456 |  | 22673833 |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
SCHOOL LUNCH PROG MATCH-17 | 588732 | 588732 |  | 588732 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NRS ADJUSTMENT | 0 |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
SCHOOL IMPROVEMENT:
Remediation Programs-34/35 | 0
RPDP, NELIP & LEAD-36 | 7897804 | 7897804 |  | 7897804 |  |  |  | 0 | 0 | 0 | 0 | 42273 | 42273 |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0
SPECIAL FUNDING:
Early Childhood Education-45 | 3338875 | 3304982 |  |  |  |  |  | 0 | 0
Library Media Specialist - 47 | 18798 | 18798 |  | 18798 |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
High Impact Position Stipends-51 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Retired Employee Ins Subsidy-55 |  |  |  |  |  | 0 | 0
Special Elementary Counseling-46 | 850000 | 850000 |  | 850000
CSR At Risk Kindergarten Teachers - 18 | 1580391 | 1580390 |  | 1586508 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  | 0 | 0
Special Transportation - 80 | 170908 | 128541 |  | 170908 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Adjustment to Balance to 387.303 | 0 | -39739 |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
TOTAL SUPPORT
LESS:
LOCAL SCHOOL SUPPORT TAX - 2.60% | -905809371
1/3 PUBLIC SCHOOLS OPERATING PROPERTY TAX | -253196604
SCHOOL DISTRICT DEBT SERVICE RESERVES | 0 | 0 |  | 0
CAPITAL CONSTRUCTION FUNDS | -10000000 | -10000000 |  | -35000000 |  | 0 | 0
TRANSFER FROM CLOSURE OF CC RDA | -6000000 | -6000000 |  | -5400000 |  | 0 | 0
STATE SHARE
STATE SHARE ELEMENTS
GENERAL FUND | 1173542690 | 1173542690
GENERAL FUND TRANSFER FY 2010 TO FY 2009 |  | -18917900
GENERAL FUND TRANSFER FY 2011 TO FY 2010 | 0 | 69080821 |  |  |  | 0
DSA SHARE OF SLOT TAX | 35888197 | 33712074
PERMANENT SCHOOL FUND | 13100000 | 9173420 |  | 6700000 |  | 6600000 | 6800000
FEDERAL MINERAL LEASE REVENUE | 10706000 | 8116846 |  | 8000000 |  | 8000000
OUT OF STATE LSST - 2.60% | 98037864 | 86190829
IP1 (2009)  ROOM TAX REVENUE TRANSFER
REAL PROPERTY TAX | 1000000 |  |  |  |  | 0 | 0
ESTATE TAX | 100 |  |  |  |  | 0 | 0
PRIOR YEAR REFUNDS |  | 816539
GENERAL FUND SUPPLEMENTAL APPROPRIATION |  |  |  | 140833874 |  | 0 | 0
REVERSION TO STATE GENERAL FUND |  | -42371
OTHER STATE FUNDING
BALANCE FORWARD TO NEXT FISCAL YEAR |  | -33893 |  |  |  | 0 | 0
TOTAL
DSABASE ADJUSTMENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
GRAND TOTALS:
 |  |  |  |  |  |  |  | ok | ok | ok | ok | ok | ok | ok | ok | ok | ok | ok | ok | ok | ok | ok | ok | ok | ok | ok | ok