Spreadsheet: 32938dfb-f539-45f0-8c86-444cb73eb278
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 June 30, 2008
Commitment Item | Fiscal Year 2006 Actual | Fiscal Year 2007 Actual | Fiscal Year 2008             July-September 2007 | Fiscal Year 2008   October- December 2007 | Fiscal Year 2008   January-March 2008 | Fiscal Year 2008          April-June 2008 | Fiscal Year 2008 Actual Year to Date | Inception to Date     Total
585000  1/4% Sales Tax Revenue | 612102 | 738487 | 71901 | 200688 | 213397 | 327683 | 813669 | 2164258
590200  Interest | 3632 | 19847 | 127 | 19365 | 308 | 658 | 20458 | 43937
TOTAL REVENUES | 615734 | 758334 | 72028 | 220053 | 213705 | 328341 | 834127 | 2208195
 |  |  |  |  |  |  | 0
611000 Salaries | 17027 | 247190 | 84730 | 99577 | 126418 | 99749 | 410474 | 674691
611200  Shift Differential |  |  |  |  |  |  | 0 | 0
611260  Court Pay |  |  |  |  |  |  | 0 | 0
611280  Uniform/Clothing Allowance/Physicals | 10570 | 26908 | 3859 | 773 | 0 |  | 4632 | 42110
611310 Comp time |  |  |  |  |  |  | 0 | 0
611320  Leave Sellback |  |  |  |  |  |  | 0 | 0
611330  Longevity |  |  |  |  |  |  | 0 | 0
611340  Severance |  |  |  |  |  |  | 0 | 0
613100  Overtime | 315 | 29347 | 11736 | 7864 | 6158 | 4305 | 30063 | 59725
613120  Call Back |  |  |  |  |  |  | 0 | 0
621000  Employee Benefits ** | 11143 | 156428 | 53330 | 58829 | 76184 | 66720 | 255063 | 422634
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 |  |  |  |  | 16449 | 7430 | 23879 | 23879
644200  Medical |  |  |  |  |  |  | 0 | 0
644210  Physicals-Employment |  |  |  |  |  |  | 0 | 0
645000  Travel/Training | 1991 | 13941 | 2338 | 5429 | 5892 | 3050 | 16709 | 32641
648100  Printing/Reproduction |  |  |  |  |  |  | 0 | 0
649000  Other Travel |  |  |  |  |  |  | 0 | 0
662100  Ammunition |  |  |  |  |  | 19625 | 19625 | 19625
662200  Police Equipment |  |  |  |  |  |  | 0 | 0
663000  Operating Supplies | 1129 | 8147 | 1302 | 803 | 667 | 785 | 3557 | 12833
663500  [NAME] |  |  |  |  |  |  | 0 | 0
663600  Minor Equipment |  |  |  |  |  |  | 0 | 0
663810  Fuel |  |  |  |  |  |  | 0 | 0
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 | 16510 | 46775 | 16499 | 52532 | 132316 | 366225
680470  CO-Furn & Fixtures |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0
TOTAL EXPENDITURES | 178943 | 579102 | 173805 | 220050 | 248267 | 254196 | 896318 | 1654363
FUND BALANCE | 436791 | 616023 | 496428 | 496431 | 479685 |  | -62191 | 553832
 |  |  |  |  |  |  |  |  | 0
 | FY 2005-06 | FY 2006-07 | FY 2007-08 |  |  |  | FY 2007-08 | Total Officers to Date*
Additional Officers | 4 | 2 | 2 | 0 | 0 |  |  | 8
[NAME] | FY2006 over FY2005 | FY2007 over FY2006 |  |  |  |  | FY 2008 over FY 2007
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 | FYTD @ 6/30/08
General Fund Expenditures (B/4 [NAME]) | 13725586 | 16015657 | 18471060
Public Safety | 5734246 | 7388170 | 7995256
 | 0.4177778639105099 | 0.4613092051109736 | 0.4328531226686503
Police | 3555330 | 4331596 | 4816005
 | 0.2590293776892295 | 0.2704600879002341 | 0.2607324647313148
More Cops | 178943 | 579102 | 896318
 | 0.01303718471473641 | 0.03615849165600887 | 0.04852553129057022
Police/More Cops Combined | 3734273 | 4910698 | 5712323
 | 0.2720665624039659 | 0.306618579556243 | 0.309257996021885