Spreadsheet: 611464a5-e789-44ce-8b85-3dc74825a10c
Sheet: Sheet1

MESQUITE  POLICE DEPARTMENT | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
MORE COPS Revenues and [NAME]
Inception to December 30, 2008
Commitment Item | Fiscal Year 2006 Actual | Fiscal Year 2007 Actual | Fiscal Year 2008 Actual | Fiscal Year 2009             July-September 2008 | Fiscal Year 2009   Oct - Dec 2008 | Fiscal Year 2009   January-March 2009 | Fiscal Year 2009          April-June 2009 | Fiscal Year 2009 Actual Year to Date | Inception to Date     Total
585000  1/4% Sales Tax Revenue *** | 612102 | 738487 | 813669.44 | 68366.18 | 194198.93 |  |  | 262565.11 | 2426823.55
590200  Interest*** | 3632 | 19847 | 26400.54 | 365.72 | 9680 |  |  | 10045.72 | 59925.26
TOTAL REVENUES | 615734 | 758334 | 840069.98 | 68731.9 | 203878.93 |  |  | 272610.83 | 2486748.81
 |  |  | 0 |  |  |  |  | 0 | 0
611000 Salaries | 17027 | 247190 | 410474.44 | 128626.12 | 135089.46 |  |  | 263715.58 | 938407.0199999999
611200  Shift Differential |  |  | 0 |  |  |  |  | 0 | 0
611260  Court Pay |  |  | 0 |  |  |  |  | 0 | 0
611280  Uniform/Clothing Allowance/Physicals | 10570 | 26908 | 4853.49 | 0 | 5600 |  |  | 5600 | 47931.49
611310 Comp time |  |  | 0 |  |  |  |  | 0 | 0
611320  Leave Sellback |  |  | 0 |  |  |  |  | 0 | 0
611330  Longevity |  |  | 0 |  |  |  |  | 0 | 0
611340  Severance |  |  | 0 |  |  |  |  | 0 | 0
613100  Overtime | 315 | 29347 | 30063 | 7013.71 | 8006.79 |  |  | 15020.5 | 74745.5
613116  Education Assistance |  |  |  | 1220 | 1260 |  |  | 2480 | 2480
613120  Call Back |  |  | 0 |  |  |  |  | 0 | 0
621000  Employee Benefits ** | 11143 | 156428 | 255063 | 75167.87 | 79098.82 |  |  | 154266.69 | 576900.69
622100  FICA-Medicare |  |  | 0 |  |  |  |  | 0 | 0
623000  Retirement Contributions |  |  | 0 |  |  |  |  | 0 | 0
624000  Unemployment Compensation |  |  | 0 |  |  |  |  | 0 | 0
625000  Industrial Insurance |  |  | 0 |  |  |  |  | 0 | 0
634000  Pro Svcs-Medical |  |  | 0 |  |  |  |  | 0 | 0
640340  R&M Vehicles |  |  | 0 |  |  |  |  | 0 | 0
644200  Medical |  |  | 0 |  |  |  |  | 0 | 0
644210  Physicals-Employment |  |  | 0 |  |  |  |  | 0 | 0
645000  Travel/Training | 1991 | 13941 | 16709.36 | 1976.62 | 2739.22 |  |  | 4715.84 | 37357.2
648100  Printing/Reproduction |  |  | 0 |  |  |  |  | 0 | 0
649000  Other Travel |  |  | 0 |  |  |  |  | 0 | 0
662100  Ammunition |  |  | 19624.98 |  | 13365.41 |  |  | 13365.41 | 32990.39
662200  Police Equipment |  |  | 0 |  |  |  |  | 0 | 0
663000  Operating Supplies | 1129 | 8147 | 5086.06 | 156.77 | 284.03 |  |  | 440.8000000000001 | 14802.86
663500  [NAME] |  |  | 0 |  |  |  |  | 0 | 0
663600  Minor Equipment |  |  | 0 |  |  |  |  | 0 | 0
663810  Fuel |  |  | 23879.31 | 5141.34 | 0 |  |  | 5141.34 | 29020.65
663900  Depreciation |  |  | 0 |  |  |  |  | 0 | 0
673510  Int-Sec Lend Exp |  |  | 0 |  |  |  |  | 0 | 0
679200  License & Taxes |  |  | 0 |  |  |  |  | 0 | 0
679220  Software Licenses |  |  | 0 |  |  |  |  | 0 | 0
680400  CO Equipment | 136768 | 97141 | 132316 | 0 |  |  |  | 0 | 366225
680470  CO-Furn & Fixtures |  |  | 0 |  |  |  |  | 0 | 0
 |  |  | 0 |  |  |  |  | 0 | 0
TOTAL EXPENDITURES | 178943 | 579102 | 898069.64 | 219302.43 | 245443.73 | 0 | 0 | 464746.16 | 2120860.8
FUND BALANCE | 436791 | 616023 | 558023.34 | 407452.8100000001 | 365888.01 | 365888.01 | 365888.01 | 173752.68 | 539640.69
 | FY 2005-06 | FY 2006-07 | FY 2007-08 | FY 2008-09 |  |  |  | FY 2008-09 | Total Officers to Date*
Additional Officers | 4 | 2 | 2 | 0 | 0 | 0 |  |  | 8
[NAME] | FY2006 over FY2005 | FY2007 over FY2006 | FY 2008 over FY 2007 |  |  |  |  | FY 2009 over FY 2008
Percentage Increase in City/County Contribution For Mesquite Operating Budget
**Includes City paid Retirement, Insurance, Workers Comp, Medicare
 | Per Audit
Percentage to G/F | FY 05-06 | FY 06-07 | FY 07-08 | FY 08-09
General Fund Expenditures (B/4 [NAME]) | 13725586 | 16015657 | 18004409 | 25750506
Public Safety | 5734246 | 7388170 | 8911409 | 10962446
 | 0.4177778639105099 | 0.4613092051109736 | 0.494957040800395 | 0.4257176926931067
Police | 3555330 | 4331596 | 4818212 | 6260200
 | 0.2590293776892295 | 0.2704600879002341 | 0.26761289415276 | 0.2431097858814891
More Cops | 178943 | 579102 | 898069 | 464746.16
 | 0.01303718471473641 | 0.03615849165600887 | 0.04988050426981525 | 0.01804803991036137
Police/More Cops Combined | 3734273 | 4910698 | 5716281 | 6724946.16
 | 0.2720665624039659 | 0.306618579556243 | 0.3174933984225753 | 0.2611578257918505