Spreadsheet: 05d1e80e-4f0a-4be7-9574-048d526bdae8
Sheet: Sheet1

UTAH STATE OFFICE OF EDUCATION | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20
SCHOOL FINANCE & STATISTICS
[NAME] OF LOCAL EFFORT
FY07 PRE-FINAL
USBE RULE R277-911-4
Pre-final |  |  |  | Current as of  26-February-07
 | FY06  Preliminary | FY07 | FY07 NON- | FY07 MINIMUM
 | ADD-ON ADM | WPU VALUE | RESTRICTED | QUALIFYING
DISTRICT | GRADE 9-12 | @ | INDIRECT | EXPENDITURE*
 |  | 2417 | COST FACTOR | (COL 2 X COL 3)
 | (1) | (2) | (3) | (4) |  | 07 NR IC |  |  | [NAME]
01 ALPINE | 2461.464 | 5949358.488 | 0.8872 | 5278270.8505536 |  | 0.1128 |  |  | 0.8872
02 BEAVER | 78.102 | 188772.534 | 0.7602 | 143504.8803468 |  | 0.2398 |  |  | 0.7602
03 BOX ELDER | 461.293 | 1114945.181 | 0.8729 | 973235.6484949001 |  | 0.1271 |  |  | 0.8729
04 CACHE | 594.082 | 1435896.194 | 0.8778 | 1260429.6790932 |  | 0.1222 |  |  | 0.8778
05 CARBON | 218.541 | 528213.597 | 0.8521 | 450090.8060037 |  | 0.1479 |  |  | 0.8521
06 DAGGETT | 7.474 | 18064.658 | 0.8202 | 14816.6324916 |  | 0.1798 |  |  | 0.8202
07 DAVIS | 2840.199 | 6864760.983 | 0.8674999999999999 | 5955180.1527525 |  | 0.1325 |  |  | 0.8674999999999999
08 DUCHESNE | 149.96 | 362453.32 | 0.8497 | 307976.586004 |  | 0.1503 |  |  | 0.8497
09 EMERY | 86.763 | 209706.171 | 0.8622 | 180808.6606362 |  | 0.1378 |  |  | 0.8622
10 GARFIELD | 87.982 | 212652.494 | 0.8113 | 172524.9683822 |  | 0.1887 |  |  | 0.8113
11 GRAND | 69.027 | 166838.259 | 0.8264 | 137875.1372376 |  | 0.1736 |  |  | 0.8264
12 GRANITE | 2978.285 | 7198514.845 | 0.8699 | 6261988.0636655 |  | 0.1301 |  |  | 0.8699
13 IRON | 260.499 | 629626.0830000001 | 0.8629 | 543304.3470207001 |  | 0.1371 |  |  | 0.8629
14 JORDAN | 3613.69 | 8734288.73 | 0.8607 | 7517602.309911001 |  | 0.1393 |  |  | 0.8607
15 [NAME] | 70.042 | 169291.514 | 0.8959 | 151668.2673926 |  | 0.1041 |  |  | 0.8959
16 KANE | 77.012 | 186138.004 | 0.8459 | 157454.1375836 |  | 0.1541 |  |  | 0.8459
17 MILLARD | 179.282 | 433324.594 | 0.847 | 367025.931118 |  | 0.153 |  |  | 0.847
18 MORGAN | 96.206 | 232529.902 | 0.8805000000000001 | 204742.578711 |  | 0.1195 |  |  | 0.8805000000000001
19 NEBO | 1132.345 | 2736877.865 | 0.8548 | 2339483.199002 |  | 0.1452 |  |  | 0.8548
20 N SANPETE | 112.639 | 272248.463 | 0.866 | 235767.168958 |  | 0.134 |  |  | 0.866
21 N SUMMIT | 59.668 | 144217.556 | 0.9082 | 130978.3843592 |  | 0.0918 |  |  | 0.9082
22 PARK CITY | 131.619 | 318123.123 | 0.8227 | 261719.8932921 |  | 0.1773 |  |  | 0.8227
23 PIUTE | 14.05 | 33958.85 | 0.8567 | 29092.546795 |  | 0.1433 |  |  | 0.8567
24 RICH | 17.471 | 42227.407 | 0.8617 | 36387.3566119 |  | 0.1383 |  |  | 0.8617
25 SAN JUAN | 171.017 | 413348.089 | 0.8048 | 332662.5420272 |  | 0.1952 |  |  | 0.8048
26 SEVIER | 247.25 | 597603.25 | 0.8954 | 535093.95005 |  | 0.1046 |  |  | 0.8954
27 S SANPETE | 94.104 | 227449.368 | 0.9075 | 206410.30146 |  | 0.0925 |  |  | 0.9075
28 S SUMMIT | 52.213 | 126198.821 | 0.8847 | 111648.0969387 |  | 0.1153 |  |  | 0.8847
29 TINTIC | 7.993 | 19319.081 | 0.8916 | 17224.8926196 |  | 0.1084 |  |  | 0.8916
30 TOOELE | 565.055 | 1365737.935 | 0.8428 | 1151043.931618 |  | 0.1572 |  |  | 0.8428
31 UINTAH | 262.116 | 633534.372 | 0.8799 | 557446.8939228 |  | 0.1201 |  |  | 0.8799
32 WASATCH | 246.782 | 596472.094 | 0.8915 | 531754.871801 |  | 0.1085 |  |  | 0.8915
33 WASHINGTON | 1094.357 | 2645060.869 | 0.8901 | 2354368.6794969 |  | 0.1099 |  |  | 0.8901
34 WAYNE | 40.133 | 97001.46100000001 | 0.837 | 81190.222857 |  | 0.163 |  |  | 0.837
35 WEBER | 1769.562 | 4277031.353999999 | 0.8699 | 3720589.574844599 |  | 0.1301 |  |  | 0.8699
36 SALT LAKE | 1019.657 | 2464510.969 | 0.8775 | 2162608.3752975 |  | 0.1225 |  |  | 0.8775
37 OGDEN | 538.229 | 1300899.493 | 0.8571 | 1115000.9554503 |  | 0.1429 |  |  | 0.8571
38 PROVO | 799.258 | 1931806.586 | 0.9234 | 1783830.2015124 |  | 0.0766 |  |  | 0.9234
39 LOGAN | 158.468 | 383017.156 | 0.9232 | 353601.4384192 |  | 0.0768 |  |  | 0.9232
40 MURRAY | 386.047 | 933075.599 | 0.8536 | 796473.3313064 |  | 0.1464 |  |  | 0.8536
CHARTER SCHOOLS:
[NAME] | 8.351 | 20184.367 | 0.5429999999999999 | 10960.111281 |  | 0.457 |  |  | 0.5429999999999999
A3  DAVINCI ACADEMY | 7.892 | 19074.964 | 0.8462000000000001 | 16141.2345368 |  | 0.1538 |  |  | 0.8462000000000001
1B  UCAS | 15.928 | 38497.976 | 1 | 38497.976 |  | 0 |  |  | 1
90  TUACAHN HS | 12.59 | 30430.03 | 0.7767999999999999 | 23638.047304 |  | 0.2232 |  |  | 0.7767999999999999
TOTAL | 23294.697 | 56303282.64900003 | 0.8705018874424504 | 49012113.81516029
*The amount in column 4 must be expended in order to earn State [NAME] funds.  All State CTE Funds are
RESTRICTED funds.  For calculation purposes, the  amount in column 4 shall not include State Add-On, State
Set-Aside, and Federal funds.
USOE:  School Finance and Statistics - Kelly |  |  |  | I:\data\excel\kelly\07 Pre-Final.xls
UTAH STATE OFFICE OF EDUCATION
SCHOOL FINANCE & STATISTICS
[NAME] OF LOCAL EFFORT
FY07 FINAL
USBE RULE R277-911-4
Final
 | FY06  Preliminary | FY07 | FY07 NON- | FY07 MINIMUM | FY07 ACTUAL
 | ADD-ON ADM | WPU VALUE | RESTRICTED | QUALIFYING | INSTRUCTIONAL
DISTRICT | GRADE 9-12 | @ | INDIRECT | EXPENDITURE* | EXPENDITURE**
 |  | 2417 | COST FACTOR | (COL 2 X COL 3) | PROGRAM |  | DIFFERENCE |  | TOTAL EXPENDITURES | Minus TLC | Minus Comp Guidance | Minus Federal Revenue | Minus Set-Aside | Minus Add-On | Add TLC and Comp Guid Revenue | Subtract Beginning Balance | Add Ending Balance
 |  |  |  |  | REPORT |  | BETWEEN |  | FY07
 | (1) | (2) | (3) | (4) | (5) |  | Col. 4 & Col. 5 |  | Total ATE | TLC | Comp Guidance | Fed ATE | Set Aside | Add-on | Add TLC & Comp Guid Revenue | Beginning Balance | Ending Balance | Total-fed-MSP | Diff | Diff
01 ALPINE | 2461.464 | 5949358.488 | 0.8872 | 5278270.8505536 | 6119595 |  | 841324.1494463999 |  | 13173774 | 93633 | 838056 | 616078 | 144788 | 6154004 | 792380 | 0 | 0 | 6119595 | 0 | 841324.1494463999
02 BEAVER | 78.102 | 188772.534 | 0.7602 | 143504.8803468 | 250952 |  | 107447.1196532 |  | 558328.12 | 0 | 36462 | 18141 | 14145 | 327524 | 41999 | 16531 | 63427.88 | 250952 | 0 | 107447.1196532
03 BOX ELDER | 461.293 | 1114945.181 | 0.8729 | 973235.6484949001 | 1132837 |  | 159601.3515050999 |  | 2370562 | 18282 | 191008 | 10625 | 118023 | 1319023 | 196711 | 311417 | 533942 | 1132837 | 0 | 159601.3515050999
04 CACHE | 594.082 | 1435896.194 | 0.8778 | 1260429.6790932 | 1522981 |  | 262551.3209068 |  | 3583326 | 12330 | 382854 | 160967 | 66627 | 1689919 | 252352 | 0 | 0 | 1522981 | 0 | 262551.3209068
05 CARBON | 218.541 | 528213.597 | 0.8521 | 450090.8060037 | 848987 |  | 398896.1939963 |  | 1447405 | 17151 | 96292 | 60772 | 22813 | 477426 | 76036 | 0 | 0 | 848987 | 0 | 398896.1939963
06 DAGGETT | 7.474 | 18064.658 | 0.8202 | 14816.6324916 | 57765.39000000001 |  | 42948.75750840001 |  | 176456.25 | 0 | 12228.43 | 2964 | 12410 | 116128 | 18634 | 8657.5 | 15063.07000000001 | 57765.39000000001 | 0 | 42948.75750840001
07 DAVIS | 2840.199 | 6864760.983 | 0.8674999999999999 | 5955180.1527525 | 8648826 |  | 2693645.8472475 |  | 16658447 | 122600 | 868441 | 844335 | 171370 | 6892908 | 890033 | 0 | 0 | 8648826 | 0 | 2693645.8472475
08 DUCHESNE | 149.96 | 362453.32 | 0.8497 | 307976.586004 | 503877 |  | 195900.413996 |  | 1268804 | 23400 | 133673 | 69546 | 19522 | 651064 | 121244 | 35216 | 46250 | 503877 | 0 | 195900.413996
09 EMERY | 86.763 | 209706.171 | 0.8622 | 180808.6606362 | 603918 |  | 423109.3393638 |  | 1090823 | 0 | 93959 | 44439 | 56136 | 378319 | 76276 | 71970 | 81642 | 603918 | 0 | 423109.3393638
10 GARFIELD | 87.982 | 212652.494 | 0.8113 | 172524.9683822 | 329848 |  | 157323.0316178 |  | 818149 | 22004 | 144837 | 45995 | 14048 | 371811 | 70723 | 96529 | 136200 | 329848 | 0 | 157323.0316178
11 GRAND | 69.027 | 166838.259 | 0.8264 | 137875.1372376 | -66747 |  | -204622.1372376 |  | 441901 | 5670 | 76407 | 0 | 98864 | 230512 | 36715 | -127161 | -261071 | -66747 | 0 | -204622.1372376
12 GRANITE | 2978.285 | 7198514.845 | 0.8699 | 6261988.0636655 | 7948579 |  | 1686590.9363345 |  | 14208210 | 134174 | 805509 | 1181756 | 248680 | 7029586 | 1046296 | 4531015 | 6624793 | 7948579 | 0 | 1686590.9363345
13 IRON | 260.499 | 629626.0830000001 | 0.8629 | 543304.3470207001 | 1018153 |  | 474848.6529792999 |  | 1862897 | 11424 | 0 | 127559 | 27685 | 834056 | 155980 | 0 | 0 | 1018153 | 0 | 474848.6529792999
14 JORDAN | 3613.69 | 8734288.73 | 0.8607 | 7517602.309911001 | 14518009 |  | 7000406.690088999 |  | 23553815 | 91000 | 837971 | 684172 | 218170 | 8486729 | 1069590 | 1040257 | 1252903 | 14518009 | 0 | 7000406.690088999
15 [NAME] | 70.042 | 169291.514 | 0.8959 | 151668.2673926 | 254834 |  | 103165.7326074 |  | 541199 | 10394 | 76754 | 23920 | 34238 | 275982 | 25609 | 0 | 109314 | 254834 | 0 | 103165.7326074
16 KANE | 77.012 | 186138.004 | 0.8459 | 157454.1375836 | 304439 |  | 146984.8624164 |  | 782823 | 0 | 0 | 15327 | 179325 | 355217 | 56507 | 64022 | 79000 | 304439 | 0 | 146984.8624164
17 MILLARD | 179.282 | 433324.594 | 0.847 | 367025.931118 | 767540 |  | 400514.068882 |  | 1543561 | 32782 | 163725 | 47664 | 19771 | 608637 | 96558 | 0 | 0 | 767540 | 0 | 400514.068882
18 MORGAN | 96.206 | 232529.902 | 0.8805000000000001 | 204742.578711 | 217404 |  | 12661.42128899999 |  | 719266 | 131580 | 60433 | 14902 | 16352 | 339059 | 43775 | 33183 | 49872 | 217404 | 0 | 12661.42128899999
19 NEBO | 1132.345 | 2736877.865 | 0.8548 | 2339483.199002 | 2388322 |  | 48838.80099799996 |  | 5718368 | 121250 | 385721 | 304842 | 95746 | 2791931 | 369444 | 0 | 0 | 2388322 | 0 | 48838.80099799996
20 N SANPETE | 112.639 | 272248.463 | 0.866 | 235767.168958 | 213536 |  | -22231.16895799999 |  | 790874 | 8693 | 144074 | 36349 | 36796 | 376051 | 45551 | 59438 | 38512 | 213536 | 0 | -22231.16895799999
21 N SUMMIT | 59.668 | 144217.556 | 0.9082 | 130978.3843592 | 140430 |  | 9451.615640799995 |  | 450540 | 1285 | 29004 | 12639 | 33239 | 266255 | 33741 | 57485 | 56056 | 140430 | 0 | 9451.615640799995
22 PARK CITY | 131.619 | 318123.123 | 0.8227 | 261719.8932921 | 271812 |  | 10092.10670789998 |  | 748531 | 54852 | 15699 | 44645 | 19764 | 422401 | 80642 | 0 | 0 | 271812 | 0 | 10092.10670789998
23 PIUTE | 14.05 | 33958.85 | 0.8567 | 29092.546795 | 71154 |  | 42061.453205 |  | 283118 | 4000 | 37190 | 6600 | 30092 | 133889 | 18766 | 74104 | 55145 | 71154 | 0 | 42061.453205
24 RICH | 17.471 | 42227.407 | 0.8617 | 36387.3566119 | 56292 |  | 19904.6433881 |  | 149383 | 4021 | 7682 | 10147 | 22057 | 131627 | 33323 | 0.9999999999987494 | 49121 | 56292 | 0 | 19904.6433881
25 SAN JUAN | 171.017 | 413348.089 | 0.8048 | 332662.5420272 | 645530 |  | 312867.4579728 |  | 1513941 | 20479 | 112727 | 103419 | 65973 | 671684 | 105871 | 0 | 0 | 645530 | 0 | 312867.4579728
26 SEVIER | 247.25 | 597603.25 | 0.8954 | 535093.95005 | 627581 |  | 92487.04995000002 |  | 1508340 | 19407 | 148971 | 73531 | 53790 | 708884 | 123824 | 0 | 0 | 627581 | 0 | 92487.04995000002
27 S SANPETE | 94.104 | 227449.368 | 0.9075 | 206410.30146 | 227158 |  | 20747.69854000001 |  | 781935 | 16254 | 134785 | 40181 | 36809 | 432245 | 72972 | 0 | 32525 | 227158 | 0 | 20747.69854000001
28 S SUMMIT | 52.213 | 126198.821 | 0.8847 | 111648.0969387 | 200200 |  | 88551.90306129999 |  | 407503.6 | 5142 | 14336 | 43173 | 14138 | 201789 | 19839 | 99456 | 150891.4 | 200200 | 0 | 88551.90306129999
29 TINTIC | 7.993 | 19319.081 | 0.8916 | 17224.8926196 | 91132 |  | 73907.1073804 |  | 219309 | 5701 | 18439 | 4700 | 16664 | 127340 | 33147 | 140056 | 151576 | 91132 | 0 | 73907.1073804
30 TOOELE | 565.055 | 1365737.935 | 0.8428 | 1151043.931618 | 1141446.69 |  | -9597.241617999971 |  | 2824271 | 28120 | 115684 | 123754 | 104099 | 1520749 | 209582 | 0.25 | -0.06000000005587935 | 1141446.69 | 0 | -9597.241617999971
31 UINTAH | 262.116 | 633534.372 | 0.8799 | 557446.8939228 | 591102 |  | 33655.10607720003 |  | 1499833 | 84015 | 153939 | 88990 | 26167 | 664063 | 108443 | 0 | 0 | 591102 | 0 | 33655.10607720003
32 WASATCH | 246.782 | 596472.094 | 0.8915 | 531754.871801 | 659463 |  | 127708.128199 |  | 1486935 | 7309 | 187877 | 44291 | 22715 | 700820 | 90916 | 251400 | 296024 | 659463 | 0 | 127708.128199
33 WASHINGTON | 1094.357 | 2645060.869 | 0.8901 | 2354368.6794969 | 3862368.77 |  | 1508000.0905031 |  | 5827600.76 | 29559.14 | 429454.33 | 342672 | 68993 | 2542802 | 409286 | 3282238.94 | 4321201.42 | 3862368.77 | 0 | 1508000.0905031
34 WAYNE | 40.133 | 97001.46100000001 | 0.837 | 81190.222857 | 140544 |  | 59353.777143 |  | 467362 | 63630 | 60725 | 5006 | 11913 | 220920 | 33433 | 0 | 1943 | 140544 | 0 | 59353.777143
35 WEBER | 1769.562 | 4277031.353999999 | 0.8699 | 3720589.574844599 | 4191603 |  | 471013.4251554008 |  | 8261798 | 40694 | 500173 | 282830 | 99431 | 4205604 | 475064 | 1818136 | 2401609 | 4191603 | 0 | 471013.4251554008
36 SALT LAKE | 1019.657 | 2464510.969 | 0.8775 | 2162608.3752975 | 3269299 |  | 1106690.6247025 |  | 6396938 | 29115 | 250115 | 643302 | 117877 | 2385241 | 298011 | 1369099 | 1369099 | 3269299 | 0 | 1106690.6247025
37 OGDEN | 538.229 | 1300899.493 | 0.8571 | 1115000.9554503 | 1325302.64 |  | 210301.6845497002 |  | 2552244.66 | 25814.05 | 147479.75 | 284358 | 40339 | 1386461 | 190086 | 906038.9010000002 | 1373462.681 | 1325302.64 | 0 | 210301.6845497002
38 PROVO | 799.258 | 1931806.586 | 0.9234 | 1783830.2015124 | 1984273 |  | 200442.7984875999 |  | 4605288 | 60815 | 526463 | 293041 | 63463 | 1859856 | 182621 | -2 | 0 | 1984273 | 0 | 200442.7984875999
39 LOGAN | 158.468 | 383017.156 | 0.9232 | 353601.4384192 | 323512 |  | -30089.43841919996 |  | 823353 | 8914 | 0 | 103479 | 22434 | 460845 | 94159 | -78597 | -76925 | 323512 | 0 | -30089.43841919996
40 MURRAY | 386.047 | 933075.599 | 0.8536 | 796473.3313064 | 1409712 |  | 613238.6686936 |  | 2167906.54 | 13724 | 103457 | 111385 | 43554 | 1008454 | 108650 | 362263 | 775992.46 | 1409712 | 0 | 613238.6686936
CHARTER SCHOOLS: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | 8.351 | 20184.367 | 0.5429999999999999 | 10960.111281 | 1502 |  | -9458.111281 |  | 40699 |  |  |  | 11000 | 29699 | 1502 | 0 | 0 | 1502 | 0 | -9458.111281
A3  DAVINCI ACADEMY | 7.892 | 19074.964 | 0.8462000000000001 | 16141.2345368 | -28555 |  | -44696.2345368 |  |  |  |  |  | 14000 | 14555 | 0 | 0 | 0 | -28555 | 0 | -44696.2345368
1B  UCAS | 15.928 | 38497.976 | 1 | 38497.976 | 14502 |  | -23995.976 |  | 59877 |  |  |  | 7000 | 52877 | 14502 | 0 | 0 | 14502 | 0 | -23995.976
90  TUACAHN HS | 12.59 | 30430.03 | 0.7767999999999999 | 23638.047304 | 0 |  | -23638.047304 |  | 20935 |  |  |  | 1000 | 19935 | 0 | 0 | 0 | 0 | 0 | -23638.047304
TOTAL | 23294.697 | 56303282.64900003 | 0.8705018874424504 | 49012113.81516029 | 68801019.49000001 |  | 19788905.6748397 |  | 134406629.93 | 1379217.19 | 8342604.51 | 6972496 | 2562020 | 59874881 | 8220793 | 14422753.591 | 19727568.851 | 68801019.49000001 | 0 | 19788905.6748397
*The amount in column 4 must be expended in order to earn State [NAME] funds.  All State CTE Funds are
RESTRICTED funds.  For calculation purposes, the  amount in column 4 shall not include State Add-On, State
Set-Aside, and Federal funds.