Spreadsheet: 59cfa7af-ae67-48df-9cfb-04c418d0de3a
Sheet: Sheet1

MESQUITE  POLICE DEPARTMENT | 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
MORE COPS Revenues and [NAME]
Inception to March 31, 2013
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Inception to Date     Total
Commitment Item | FY 2006 Audited | FY 2007 Audited | FY 2008 Audited | FY 2009  Audited | FY 2010 Audited | July - Sept 2010 | Oct - Dec 2010 | Jan - Mar 2011 | Apr - June 2011 | FY 2011 Audited | July - Sept 2011 | Oct - Dec 2011 | Jan - Mar 2012 | Apr - June 2012 | FY 2012 Audited | July - Sept 2012 | Oct - Dec 2012 | Jan - Mar 2013 | FYTD
585000  1/4% Sales Tax Revenue *** | 612102 | 738487 | 813669.44 | 728029.35 | 733072 | 165429.06 | 180781.87 | 188388.15 | 211942.5600000001 | 746541.64 | 172715.94 | 187247.14 | 200622.22 | 220134.21 | 780719.51 | 165320.1 | 176420.72 |  | 341740.82 | 5494361.76
590200  Interest*** | 3632 | 19847 | 26400.54 | 16312.89 | 2234 | 25.39 | 81.27 | 56.44 | 546.76 | 709.86 | 43.95 | 52.29000000000001 | 39.88 | 206.74 | 342.86 | 37.06 | 23.6 |  | 60.66 | 69539.81
585000  1/4% Sales Tax Revenue (Audit Adjustment) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7715.94 | 7715.94 | 7715.94
Other Grants | 0 | 0 | 0 | 0 | 12978 |  |  |  | 12480.8 | 12480.8 |  |  |  | 10667.27 | 10667.27 |  |  | 0 | 0 | 36126.07
TOTAL REVENUES | 615734 | 758334 | 840069.98 | 744342.24 | 748284 | 165454.45 | 180863.14 | 188444.59 | 224970.1200000001 | 759732.3 | 172759.89 | 187299.43 | 200662.1 | 231008.22 | 791729.64 | 165357.16 | 176444.32 | 7715.94 | 349517.42 | 5607743.58
 |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 | 0
611000 Salaries | 17027 | 247190 | 410474.44 | 418056.37 | 418511.56 | 97530.5 | 82403.73999999999 | 81853.03 | 107186.7 | 368973.97 | 90475.22 | 98476.92000000001 | 86235.52 | 118088.3 | 393275.96 | 86405.29 | 123642.42 | 102018.79 | 312066.5 | 2585575.8
611200  Shift Differential |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 | 0
611260  Court Pay |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 | 0
611280  Uniform/Clothing Allowance/Physicals | 10570 | 26908 | 4853.49 | 11200 | 12233.04 | 6125 | 141.96 | 0 | 5250 | 11516.96 |  | 6125 |  | 6687.5 | 12812.5 |  | 6175 |  | 6175 | 96268.98999999999
611310 Comp time |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 | 0
611320  Leave Sellback |  |  |  |  | 1336.61 |  |  |  |  | 0 | 5371.32 |  |  | 2091.56 | 7462.879999999999 | 2888.35 |  | 8979.4 | 11867.75 | 20667.24
611330  Longevity |  |  |  |  |  |  |  |  | 1531 | 1531 | 2344 | 250 | 875 | 750 | 4219 | 3125 |  | 1000 | 4125 | 9875
611340  Severance |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  | 0 | 0 | 0
613100  Overtime | 315 | 29347 | 30063 | 37007.59 | 40709.41 | 11288.08 | 8878.01 | 8373.61 | 12203.1 | 40742.8 | 10468 | 17694.99 | 13883.97 | 17642.63 | 59689.59000000001 | 14507.2 | 20538.06 | 21455.48 | 56500.74 | 294375.13
613116  Education Assistance |  |  |  | 5080 | 5500 | 1320 | 1100 | 1320 | 1419 | 5159 | 1181 | 1080 | 1180 | 1476.6 | 4917.6 | 1033.4 | 1360 | 1380 | 3773.4 | 24430
613120  Call Back |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 | 0
621000  Employee Benefits ** | 11143 | 156428 | 255063 | 267008.22 | 272060 | 67745.66 | 61213.87 | 61583.36000000002 | 65220.35999999999 | 255763.25 | 64936.57 | 70831.00999999998 | 63640.09000000003 | 79050.75 | 278458.42 | 69035.53 | 84856.87999999999 | 75782.29000000001 | 229674.7 | 1725598.59
622100  FICA-Medicare |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 | 0
623000  Retirement Contributions |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 | 0
624000  Unemployment Compensation |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 | 0
625000  Industrial Insurance |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 | 0
634000  Pro Svcs-Medical |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 | 0
640340  R&M Vehicles |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 | 0
644200  Medical |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 | 0
644210  Physicals-Employment |  |  |  | 1825 | 1190 | 1720 | 95 | 350 | 670 | 2835 | 1350 | 368 | 425 | 425 | 2568 | 1975 |  |  | 1975 | 10393
645000  Travel/Training | 1991 | 13941 | 16709.36 | 11376.35 | 851.3 |  |  |  |  | 0 | 3142 | 411.1100000000001 | 45 | 100 | 3698.11 |  |  | 1396.2 | 1396.2 | 49963.32
648100  Printing/Reproduction |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 | 0
649000  Other Travel |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 | 0
662100  Ammunition |  |  | 19624.98 | 13365.41 |  |  |  |  |  | 0 |  |  | 1206.89 | 443.19 | 1650.08 |  | -318.75 |  | -318.75 | 34321.72
662200  Police Equipment |  |  |  |  | 756 |  |  |  |  | 0 |  | 1000 | -1425 |  | -425 | 1483.23 |  |  | 1483.23 | 1814.23
663000  Operating Supplies | 1129 | 8147 | 5086.06 | 3116.64 | 1102.74 |  | 252.9 | 1551.74 | 697.3399999999999 | 2501.98 | 853.7 | 1931.33 | 3485.97 | 2304.11 | 8575.11 | 19529.96 | 0 |  | 19529.96 | 49188.49000000001
663500  [NAME] |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 | 0
663600  Minor Equipment |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 | 0
663810  Fuel |  |  | 23879.31 | 16783.8 | 24958.44 | 8449.35 | 8428.449999999999 | 7366.86 | 13146.42 | 37391.08 | 16681.3 | 10527.96 | 11495.51 | 13878.79 | 52583.56 | 15513.98 | 11406.49 | 9498.629999999997 | 36419.1 | 192015.29
663900  Depreciation |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 | 0
673510  Int-Sec Lend Exp |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 | 0
679200  License & Taxes |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 | 0
679220  Software Licenses |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 | 0
680400  CO Equipment | 136768 | 97141 | 132316 | 59911.78 | 215352.94 |  |  | 1692 | 0 | 1692 | 12922 |  | 4008.15 |  | 16930.15 |  |  |  | 0 | 660111.87
680470  CO-Furn & Fixtures |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 | 0
TOTAL EXPENDITURES | 178943 | 579102 | 898069.64 | 844731.16 | 994562.04 | 194178.59 | 162513.93 | 164090.6 | 207323.92 | 728107.0399999999 | 209725.11 | 208696.3199999999 | 185056.1 | 242938.43 | 846415.9600000001 | 215496.94 | 247660.1 | 221510.79 | 684667.8299999998 | 5754598.670000001
FUND BALANCE | 436791 | 616023 | 558023.34 | 457634.42 | 211356.3799999999 | 182632.2399999999 | 200981.4499999999 | 225335.4399999999 | 242981.6399999999 | 242981.64 | 206016.42 | 184619.5300000001 | 200225.5300000001 | 188295.3200000001 | 188295.3199999999 | 138155.54 | 66939.76000000001 | -146855.09 | -146855.0899999999 | -146855.0900000008
 | FY 2005-06 | FY 2006-07 | FY 2007-08 | FY 2008-09 | FY 2009-10 | FY 2010-11 | FY 2010-11 | FY 2010-11 | FY 2010-11 | FY 2010-11 | FY 2011-12 | FY 2011-12 | FY 2011-12 | FY 2011-12 | FY 2011-12 | FY 2012-13 | FY 2012-13 | FY 2012-13 | FY 2012-13 | Total Officers to Date*
Additional Officers | 4 | 2 | 2 | -1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | -1 | 0 | -1 | 1 | -1 | -1 | 7
**Includes City paid Retirement, Insurance, Workers Comp, Medicare
 | Audited |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Budget
Percentage to G/F | FY 05-06 | FY 06-07 | FY 07-08 | FY 08-09 | FY 09-10 | FY 10-11 |  |  |  | FY 10-11 |  |  |  |  | FY 11-12 | FY 12-13
General Fund Expenditures (B/4 [NAME]) | 13725586 | 16015657 | 18004409 | 19996228 | 20007416 | 18778330.98 |  |  |  | 18778330.98 |  |  |  |  | 18121220 | 18885791
Public Safety | 5734246 | 7388170 | 8911409 | 9582433 | 10039418 | 9453155 |  |  |  | 8938870 |  |  |  |  | 8585375 | 9357081.17
 | 0.4177778639105099 | 0.4613092051109736 | 0.494957040800395 | 0.4792120293887427 | 0.5017848381820021 | 0.50340762499437 |  |  |  | 0.4760204732529429 |  |  |  |  | 0.4737746685929535 | 0.4954561431925197
Police | 3555330 | 4331596 | 4818212 | 5234681 | 5577401 | 5161835 |  |  |  | 4996987 |  |  |  |  | 4840944 | 5126386.53
 | 0.2590293776892295 | 0.2704600879002341 | 0.26761289415276 | 0.2617834223534559 | 0.2787666833138273 | 0.2748825231325218 |  |  |  | 0.2661038941811217 |  |  |  |  | 0.2671422785000127 | 0.2714414519360084
More Cops | 178943 | 579102 | 898069 | 844731 | 994561 | 765330 |  |  |  | 728107 |  |  |  |  | 846416 | 934140
 | 0.01303718471473641 | 0.03615849165600887 | 0.04988050426981525 | 0.04224451731596579 | 0.04970961767376657 | 0.040756018243321 |  |  |  | 0.0387737866999722 |  |  |  |  | 0.04670855494276875 | 0.04946258274276148
Police/More Cops Combined | 3734273 | 4910698 | 5716281 | 6079412 | 6571962 | 5927165 |  |  |  | 5725094 |  |  |  |  | 5687360 | 6060526.53
 | 0.2720665624039659 | 0.306618579556243 | 0.3174933984225753 | 0.3040279396694217 | 0.3284763009875938 | 0.3156385413758427 |  |  |  | 0.3048776808810939 |  |  |  |  | 0.3138508334427815 | 0.3209040346787699