Spreadsheet: 2ef4ac21-afa2-460f-bacc-17c39a476ce3
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
MORE COPS Revenues and [NAME]
Inception to June 30, 2010
Commitment Item | FY 2006 Audited | FY 2007 Audited | FY 2008 Audited | FY 2009  Audited | FY 2010                    July-Sept 2009 | FY 2010                    Oct-Dec 2009 | FY 2010                    Jan-Mar 2010 | FY 2010                    Apr-June 2010 | FY 2010 Un Audited | FY 2011                    July-Sept 2009 | Inception to Date     Total
585000  1/4% Sales Tax Revenue *** | 612102 | 738487 | 813669.44 | 728029.35 | 57050.33 | 164900.24 | 175268.98 | 340306.82 | 737526.3700000001 | 59429.06 | 3629814.16
590200  Interest*** | 3632 | 19847 | 26400.54 | 16312.89 | 125.73 | 194.7 | 127.44 | 1786.43 | 2234.3 | 25.39 | 68426.73
Other Grants | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12977.78 | 12977.78 |  | 12977.78
TOTAL REVENUES | 615734 | 758334 | 840069.98 | 744342.24 | 57176.06 | 165094.94 | 175396.42 | 355071.03 | 752738.4500000002 | 59454.45 | 3711218.67
 |  |  |  |  |  |  |  |  | 0 |  | 0
611000 Salaries | 17027 | 247190 | 410474.44 | 418056.37 | 100144.48 | 117753.24 | 96784.93 | 89384.73 | 404067.38 | 97530.5 | 1496815.19
611200  Shift Differential |  |  |  |  |  |  |  |  | 0 |  | 0
611260  Court Pay |  |  |  |  |  |  |  |  | 0 |  | 0
611280  Uniform/Clothing Allowance/Physicals | 10570 | 26908 | 4853.49 | 11200 |  | 6600 |  |  | 6600 | 6125 | 60131.49
611310 Comp time |  |  |  |  |  |  |  |  | 0 |  | 0
611320  Leave Sellback |  |  |  |  |  | 1336.61 |  |  | 1336.61 |  | 1336.61
611330  Longevity |  |  |  |  |  |  |  |  | 0 |  | 0
611340  Severance |  |  |  |  |  |  |  |  | 0 |  | 0
613100  Overtime | 315 | 29347 | 30063 | 37007.59 | 12826.37 | 14344.65 | 5759.58 | 7138.163 | 40068.763 | 11288.08 | 136801.353
613116  Education Assistance |  |  |  | 5080 | 1320 | 1320 | 1320 | 1320 | 5280 | 1320 | 10360
613120  Call Back |  |  |  |  |  |  |  |  | 0 |  | 0
621000  Employee Benefits ** | 11143 | 156428 | 255063 | 267008.22 | 64757 | 74532.61 | 70080.49 | 60994.9 | 270365 | 67745.66 | 960007.22
622100  FICA-Medicare |  |  |  |  |  |  |  |  | 0 |  | 0
623000  Retirement Contributions |  |  |  |  |  |  |  |  | 0 |  | 0
624000  Unemployment Compensation |  |  |  |  |  |  |  |  | 0 |  | 0
625000  Industrial Insurance |  |  |  |  |  |  |  |  | 0 |  | 0
634000  Pro Svcs-Medical |  |  |  |  |  |  |  |  | 0 |  | 0
640340  R&M Vehicles |  |  |  |  |  |  |  |  | 0 |  | 0
644200  Medical |  |  |  |  |  |  |  |  | 0 |  | 0
644210  Physicals-Employment |  |  |  | 1825 | 1190 |  |  |  | 1190 | 1720 | 3015
645000  Travel/Training | 1991 | 13941 | 16709.36 | 11376.35 |  | 540 | 311.3 |  | 851.3 |  | 44869.01
648100  Printing/Reproduction |  |  |  |  |  |  |  |  | 0 |  | 0
649000  Other Travel |  |  |  |  |  |  |  |  | 0 |  | 0
662100  Ammunition |  |  | 19624.98 | 13365.41 |  |  |  |  | 0 |  | 32990.39
662200  Police Equipment |  |  |  |  |  | 756 |  |  | 756 |  | 756
663000  Operating Supplies | 1129 | 8147 | 5086.06 | 3116.64 | 50.58 | 252.9 | 101.16 | 698.1 | 1102.74 |  | 18581.44
663500  [NAME] |  |  |  |  |  |  |  |  | 0 |  | 0
663600  Minor Equipment |  |  |  |  |  |  |  |  | 0 |  | 0
663810  Fuel |  |  | 23879.31 | 16783.8 | 0 |  |  | 24958.44 | 24958.44 | 8449.35 | 65621.55
663900  Depreciation |  |  |  |  |  |  |  |  | 0 |  | 0
673510  Int-Sec Lend Exp |  |  |  |  |  |  |  |  | 0 |  | 0
679200  License & Taxes |  |  |  |  |  |  |  |  | 0 |  | 0
679220  Software Licenses |  |  |  |  |  |  |  |  | 0 |  | 0
680400  CO Equipment | 136768 | 97141 | 132316 | 59911.78 | 106950.54 | 100410.4 | 7992 | 0 | 215352.94 |  | 641489.72
680470  CO-Furn & Fixtures |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  | 0 |  | 0
TOTAL EXPENDITURES | 178943 | 579102 | 898069.64 | 844731.16 | 287238.97 | 317846.41 | 182349.46 | 184494.333 | 971929.173 | 194178.59 | 3472774.972999999
FUND BALANCE | 436791 | 616023 | 558023.34 | 457634.42 | 227571.5100000001 | 74820.0400000001 | 67867.00000000012 | 238443.6970000001 | 238443.6970000002 | 103719.5570000002 | 238443.6970000006
 | FY 2005-06 | FY 2006-07 | FY 2007-08 | FY 2008-09 | FY 2009-10 | FY 2009-10 | FY 2009-10 | FY 2009-10 | FY 2009-10 | FY 2010-11 | Total Officers to Date*
Additional Officers | 4 | 2 | 2 | 2 | 2 | 0 | -1 | 0 | 7 | 7 | 7
**Includes City paid Retirement, Insurance, Workers Comp, Medicare
 | Audited
Percentage to G/F | FY 05-06 | FY 06-07 | FY 07-08 | FY 08-09 | FY 09-10 | FY 10-11
General Fund Expenditures (B/4 [NAME]) | 13725586 | 16015657 | 18004409 | 19996228 | 19917081.14 | 19917081.14
Public Safety | 5734246 | 7388170 | 8911409 | 9582433 | 9965143.790000001 | 9965143.790000001
 | 0.4177778639105099 | 0.4613092051109736 | 0.494957040800395 | 0.4792120293887427 | 0.5003315355273991 | 0.5003315355273991
Police | 3555330 | 4331596 | 4818212 | 5234681 | 5520001.420000001 | 5520001.420000001
 | 0.2590293776892295 | 0.2704600879002341 | 0.26761289415276 | 0.2617834223534559 | 0.2771491154350944 | 0.2771491154350944
More Cops | 178943 | 579102 | 898069 | 844731 | 971929 | 194179
 | 0.01303718471473641 | 0.03615849165600887 | 0.04988050426981525 | 0.04224451731596579 | 0.04879876690606282 | 0.009749370333689366
Police/More Cops Combined | 3734273 | 4910698 | 5716281 | 6079412 | 6491930.420000001 | 5714180.420000001
 | 0.2720665624039659 | 0.306618579556243 | 0.3174933984225753 | 0.3040279396694217 | 0.3259478823411572 | 0.2868984857687837