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

OPERATING CALCULATIONS - M-200 GROWTH ADJUSTMENTS
[NAME] |  | 1992 Actual | 1993 Add'l | 1993 Actual | 1994 Add'l | 1994 Actual | 1995 Actual | 1996 Add'l | 1996 Actual | 1997 Actual | 1998 Actual | 1999 Actual | 2000 Actual
FOOTAGE PER |  | Sq Ft | Sq Ft | Sq Ft | Sq Ft | Sq Ft | Sq Ft | Sq Ft | Sq Ft | Sq Ft | Sq Ft | Sq Ft | Sq Ft | Sq Ft | Sq Ft | Sq Ft | Sq Ft | Sq Ft | Sq Ft | Sq Ft
 |  | 7247657 | 121544 | 7369201 | 925768 | 8294969 | 8676500 | 227639 | 8904139 | 9173936 | 9891512 | 10518428 | 11015402
 |  | 4550811 | 249981 | 4800792 | 232460 | 5033252 | 5205648 | 238770 | 5444418 | 5542278 | 6056303 | 6580378 | 6770495
 |  | 9489184 | 560106 | 10049290 | 450821 | 10500111 | 10795697 | -219343 | 10576354 | 11477744 | 12237749 | 13007029 | 13543573
 |  | 367658 | 18907 | 386565 | 0 | 386565 | 386565 | 84743 | 471308 | 472748 | 481892 | 477265 | 435564
 |  | 836012 | 29981 | 865993 | 6500 | 872493 | 872493 | -22856 | 849637 | 906342 | 874666 | 810790 | 939893
 |  | 22491322 | 980519 | 23471841 | 1615549 | 25087390 | 25936903 | 308953 | 26245856 | 27573048 | 29542122 | 31393890 | 32704927
BUILDING | 1992 Actual | 1992 Cost | 1993 Actual | 1993 Cost | 1994 Actual | 1994 Cost | 1995 Actual | 1995 Cost | 1996 Cost | 1997 Actual | 1998 Cost | 1999 Cost | 2000 Cost | 2010 Actual | 2010 Cost | 2011 Annual | 2012 Add'l | 2012 Cost | 2012 Annual | 2013 Add'l | 2013 Cost
DRIVEN COST | Cost | Per Sq Ft | Cost | Per Sq Ft | Cost | Per Sq Ft | Cost | Per Sq Ft | Per Sq Ft | Cost | Per Sq Ft | Per Sq Ft | Per Sq Ft | Cost * | Per Sq Ft | Cost | Cost | Per Sq Ft | Cost | Cost | Per Sq Ft
Heat | 3166807 | 0.1408012832682757 | 3546205 | 0.15108337688552 | 3765474 | 0.1500942903984831 | 4043666 | 0.1559039643244994 | 0.117 | 4030593 | 0.164 | 0.155 | 0.141
Electricity | 14598682 | 0.6490806543074702 | 15535256 | 0.6618678100281951 | 17341109 | 0.6912281030430029 | 18686182 | 0.720447695702143 | 0.712 | 20195540 | 0.703 | 0.661 | 0.83
Water,sewer,garbage | 6312546 | 0.2806658496997197 | 6576015 | 0.2801661360947358 | 8056235 | 0.3211268689170137 | 8908413 | 0.3434647922305913 | 0.375 | 11063663 | 0.374 | 0.352 | 0.44
Property Insurance | 1501429 | 0.0667559247962392 | 1110434 | 0.04730919913780943 | 885169 | 0.03528342326563266 | 837499 | 0.03228986128374695 | 0.034 | 546170 | 0.011 | 0.011 | 0.01
Maint/Repair | 2180215 | 0.09693583151759598 | 2670046 | 0.1137552866006548 | 2934985 | 0.1169904481893095 | 2949015 | 0.1136995808636058 | 0.163 | 5143470 | 0.175 | 0.164 | 0.445
 | 27759679 |  | 29437956 |  | 32982972 |  | 35424775 |  |  | 40979436 | 1.427 | 1.343 | 1.866
SCHOOL WEIGHTED |  | 1992 |  | 1993 |  | 1994 |  | 1995 | 1996 |  | 1998 |  | 1999 |  |  | 2012 |  |  | 2013
ENROLLMENTS |  | Actual |  | Actual |  | Actual |  | Actual | Actual |  | Actual |  | Actual | Actual |  | Projected |  |  | Projected
 |  | 204207 |  | 214997 |  | 227302 |  | 227302 | 255215.4 |  | 285990 |  | 300115.4
STUDENT | 1992 Actual | 1992 Cost | 1993 Actual | 1993 Cost | 1994 Actual | 1994 Cost | 1995 Actual | 1995 Cost | 1996 Cost | 1997 Actual | 1998 Cost | 1999 Cost | 2000 Cost
DRIVEN COST | Cost | Per Student | Cost | Per Student | Cost | Per Student | Cost | Per Student | Per Student | Cost | Per Student | Per Student | Per Student | Cost | Per Student | Cost | Cost | Per Student | Cost | Cost | Per Student
Pupil Transportation | 6410321 | 31.39128923102538 | 6149230 | 28.60146885770499 | 7888311 | 34.70409851211164 | 7317118 | 32.19117297692057 | 50.96 | 9462961 | 35.1 | 31.2 | 40.07
Textbooks | 8226072 | 40.28300694883134 | 8534733 | 39.69698646957865 | 9274867 | 40.80415922429191 | 9993340 | 43.96503330371048 | 36.64 | 11750179 | 49.54 | 52.71 | 43.43
Library | 1363322 | 6.676176624699447 | 1044344 | 4.857481732303241 | 1567481 | 6.896028191568926 | 1351462 | 5.945666998090646 | 6.43 | 1853767 | 7.59 | 8.01 | 6.46
Instruction Supplies | 10650126 | 52.15357945614009 | 10031838 | 46.66036270273538 | 13887603 | 61.09758383120254 | 14228829 | 62.59878487650791 | 54.27 | 15120627 | 59.36 | 60 | 61.61
Instruction Software |  |  |  |  |  | n/a | 1010617 | 4.446142136892768 | 3.19 | 2745463 | 7.17 | 7.96 | 3.94
Other Supplies | 10444298 | 51.14564143246803 | 8033202 | 37.36425159420829 | 10518106 | 46.27370634662255 | 10503038 | 46.20741568485979 | 35.59 | 11692320 | 43.88 | 16.46 | 18.35
 | 37094139 |  | 33793347 |  | 43136368 |  | 44404404 |  |  | 52625317 | 202.64 | 176.34 | 173.86
SCHOOL GENERAL |  | 1992 |  | 1993 |  | 1994 |  | 1995 | 1996 |  | 1998 |  | 1999
TOTAL STAFF |  | Actual |  | Actual |  | Actual |  | Actual | Actual |  | Actual |  | Actual | Actual |  | Projected |  |  | Projected
 |  | 18758.9 |  | 19566.2 |  | 20374 |  | 20374 | 21933.7 |  | 25421 |  | 26851.6
STAFF | 1992 Actual | 1992 Cost | 1993 Actual | 1993 Cost | 1994 Actual | 1994 Cost | 1995 Actual | 1995 Cost | 1996 Cost | 1997 Actual | 1998 Cost | 1999 Cost | 2000 Cost
DRIVEN COST | Cost | Per Staff | Cost | Per Staff | Cost | Per Staff | Cost | Per Staff | Per Staff | Cost | Per Staff | Per Staff | Per Staff | Cost | Per Staff | Cost | Cost | Per Sq Ft | Cost | Cost | Per Sq Ft
Prof Service | 4588671 | 244.6130103577502 | 4057187 | 207.3569216301581 | 4224654 | 207.3551585353882 | 5569499 | 273.3630607637185 | 268.23 | 10221123 | 424.4 | 452.34 | 397.09
Liability Insurance | 2262928 | 120.6322332332919 | 2353400 | 120.2788482178451 | 2951811 | 144.8812702463925 | 2889601 | 141.827868852459 | 249.46 | 2733417 | 61.56 | 59.28 | 194.25
Postage/Comm | 3244336 | 172.9491601319907 | 3265363 | 166.8879496274187 | 3841730 | 188.5604201433199 | 4407402 | 216.3248257583194 | 195.33 | 5184830 | 229.89 | 242.49 | 270.02
Printing/Binding | 1074234 | 57.26529807184856 | 1346604 | 68.82297022416208 | 1718898 | 84.36723274761951 | 1990302 | 97.68832826150977 | 91.54 | 2073473 | 108.14 | 122.74 | 132.63
Other Fuel | 333980 | 17.80381578877226 | 378061 | 19.32214737659842 | 292111 | 14.33743987434966 | 266047 | 13.058162363797 | 14.94 | 381414 | 19.36 | 19.4 | 25.92
Staff Travel | 1380013 | 73.56577411255456 | 1422066 | 72.67972319612393 | 1708117 | 83.8380779424757 | 1655142 | 81.2379503288505 | 77.36 | 2232645 | 89.12 | 89.8 | 88.24
All Other | 7646527 | 407.6212890947763 | 17288242 | 883.5768825832303 | 6686660 | 328.1957396682046 | 8200377 | 402.4922450181604 | 384.13 | 9704400 | 253.57 | 330.62 | 331.84
 | 13679090 |  | 23700336 |  | 21423981 |  | 24978370 |  |  | 32531302 | 1186.04 | 1316.67 | 1439.99
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL GROWTH ADJUSTMENTS
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Operating | 2010 Actual | 2012 | Net | 2013 | Net
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Unit | Cost | Adj | Diff | Adj | Diff
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Heat
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Electricity
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Water/Sewer/Garbage
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Property Insurance
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Maint/Repair
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Pupil Transportation
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Textbooks
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Library
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Instruction Supplies
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Instruct Software
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Other Supplies
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Prof Service
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Liability Insurance
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Postage/Comm
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Printing/Binding
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Other Fuel
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Staff Travel
 |  |  |  |  |  |  |  |  |  |  |  |  |  | All Other