HomeMy WebLinkAboutBudget Detail Worksheets 2BUDGET DETAIL WORKSHEETS OMB Control Number: 1103-0097
Expiration Date: 5/31/2011
Applicant Legal Name: ORI M
City of Miami, Florida FLO1306
COPS FUNDING REQUEST
Federal assistance is being requested under the following COPS Office funding category:
Please select the funding category that was selected on the COPS Application Attachment to SF -424.
Tribal Resources Grant Program MX Targeted -Technology Program
Targeted -Methamphetamine Initiative F_� Universal Hiring Program
[� Community Policing Development Programs ❑ Child Sexual Predator Program
[] Secure Our Schools
A. Sworn Officer Positions
No Sworn Officer Positions Requested
Instructions: For COPS programs which fund sworn officer• positions, you may apply for entry-level salaries and benefits of
newly hired, additional law enforcement officers. Please refer to the Application Guide for information on the length of the
grant term for the specific program which you are applying.
This worksheet will assist your agency in property organizing your maximum estimated salary and benefit costs and
providing the necessary financial details for review by the COPS Office. Please list the entry-level base salary and fringe
benefits rounded to the nearest whole dollar for one sworn officer position within your agency. COPS hiring funds may
also be used to pay for entry-level salaries and benefits of newly -hired, additional officers who will backfill the positions of
locally -funded veteran officers that will be deployed into community policing specialty areas (i.e., School Resource Officers).
Do not Include employee contributions.
Complete part 1 if you are requesting funds for full-time officer positions.
Officer Positions Requested:
Full-time:
Enter the number of new, entry-level full-time and/or part-time officer positions that are being requested. Do not include any
officers already funded (or for which funding has been requested) under any other COPS grants or any positions otherwise
funded with state, local, tribal, or BIA funds. Your request should be consistent with your agency's law enforcement needs.
Do not request more positions than your agency can support and retain.
Applicant Legal Name:
City of Miami, Florida
A. Sworn Officer Positions
Part 1: Full time sworn officer information
Total Entry -Level Base $ X❑ Years = $
Salary for One Position
(Base Salary Subtotal)
B. Fringe Benefit Cost
° of Base Additional information
ORI #:
FLO1306
Social Security If Exempt Check Here: Fixed Rate:
Can't Exceed 6.2% of total base salary. If less than 6.2%, exempt or fixed rate, provide an explanation in the "Sworn Officer Position
Budget Summary':
Medicare If Exempt Check Here: 1:1 Fixed Rate:
Can't Exceed 1.45% of total base salary. If less than 1.45%, exempt, or fixed rate, provide an explanation in the "Sworn Officer
Position Budget Summary':
Health Insurance Family Coverage? E] Yes 0 No Fixed Rate:
Can't Exceed 30% of total base salary for individual plans, or 45% for family plans. If it exceeds these rates oris a fixed rate, provide
an explanation in "Sworn Officer Position Budget Summary".
Life Insurance
Vacation �- Number of Hours Annually:
Sick Leave Number of Hours Annually:
Retirement Fixed Rate:
Can't Exceed 20% of the total base salary (unless a fixed rate). If a fixed rate, provide an explanation in the "Sworn Officer Position
Budget Summary':
Worker's Comp 1 If Exempt Check Here: [] Fixed Rate: 0
Can't Exceed 10% of the total base salary. If exempt or if it exceeds this rate, provide an explanation in the "Sworn Officer Position
Budget Summary".
Unemployment Ins. If Exempt Check Here: .0 Fixed Rate: El
Can't Exceed 5% of the total base salary. If exempt or if it exceeds this rate, provide an explanation in the "Sworn Officer Position
Budget Summary':
Other
Other
Describe:
Describe:
Other Describe:
Total Salary (Part A) Total Fringe Benefits (Part B) # of Positions Sworn Officer Total
$ + F x _
Transfer to Budget Summary Line 1
Applicant Legal Name:
City of Miami, Florida
ORI #:
FLO1306
Part 2: Sworn Officer Position Budget Summary (all applicants requesting officer position(s) must complete
this section.)
After completing Part 1 of this form, answer the following questions. if necessary, attach an explanation of how you computed
salaries and benefits for this worksheet. Be sure to answer EVERY question. Missing or erroneous information could significantly
delay the review of your agency's request.
1. if your agency's second and third -year costs for salaries and/or fringe benefits are greater than the first year, check the
reason(s) why in the space below. You must check at least one.
[] Cost of living adjustment (COLA) [] Step Raises F-1 Change in benefit costs
Other - please explain briefly:
2. If an explanation is required for any of the following categories, please provide in the space below: 1) Social Security, 2)
Medicare, 3) Health Insurance, 4) Retirement, 5) Workers Compensation, and 6) Unemployment Insurance.
1) Social Security:
2) Medicare:
3) Health Insurance:
4) Retirement:
i) Worker's Compensation:
6) Unemployment Insurance:
Hcant Legal Name:
'City of Miami, Florida
B. Civilian/Other Personnel
ORI #:
FLO1306
No Civilian Personnel Positions Requested
Instructions: Each position must be listed and computed separately. On this page you can enter one civilian position and then by
adding another Civilian/Other Personnel page, can enter 19 more unique positions for a total of 20. Complete each position in
accordance with the instructions.
Part 1: Total Base Salary and Fringe Benefits for Civilian/Other Personnel
Civilian/Other Personnel Page 1 of 1
Position Title: 10Nra`�'., W W � . ��I ' M�2 N.w { i
Base Salary. _-�ri== "..{ T' �r �$m
Computation: (( "` `k `° X TOM. )= X ,"gym > r �� (Base Salary Subtotal)
((Annual Base Salary X Percent of Time Devoted to the Project) X Number of Months Devoted to the Project)
Fringe Benefit Cos % of Base Salami Subtotal Additional Information
-
Social Security 1011_1- 21- If Exempt Check Here: ❑ Fixed Rate: ❑
Can't Exceed 6.2% of total base salary. if less than 6.2%, exempt or fixed rate, provide an explanation in the "civilia ilhon-sworn
personnel budget summary".
Medicare
�' �iT " If Exempt Check Here: ❑ Fixed Rate: ❑
�Se� ��
Can't Exceed 1.45% of total base salary, if less than 9.45%, exempt, or fixed rate, provide an explanation in the "civilian/non-sworn
personnel budget summary.
Health Insurance Family Coverage? ❑ Yes ❑ No Fixed Rate: ❑
Can't Exceed 30% of total base salary for individual plans, or 45% for family plans. If it exceeds these rates or is a fixed rate, provide
an explanation in the "civillan1non-sworn personnel budget summary':
Life Insurance
Vacation Number of Hours Annually:
Sick Leave Number of Hours Annually:
Retirement Fixed Rate: ❑
Can't Exceed 20% of the total base salary (unless a fixed rate). If a fixed rate, provide an explanation in the "civiliWnon-sworn
personnel budget summary".
Worker's Comp F If Exempt Check Here: ❑ Fixed Rate: ❑
Can't Exceedl0% of the total base salary. if exempt or if it exceeds this rate, provide an explanation in the "civilian/non-swom
personnel budget summary".
Unemployment Ins. �❑ If Exempt Check Here: ❑ Fixed Rate: ❑
Can't Exceed 5% of the total base salary. If exempt or if it exceeds this rate, provide an explanation in the "civilian/non-sworn
personnel budget summary°
Other F Describe:
Other Describe:
i
Total Fringe Benefits:
I
Subtotal Position Salary and Benefits:
CIViLIANIOTHER PERSONNEL TOTAL: Total Civilian/Other Personnel Cost
(Add together all Subtotals per position) (Transfer to Budget Summary Line 2)
Please include a detailed position description for all positions listed in the Budget Narrative
Applicant Legal Name: ORI #:
City of Miami, Florida FL01306
Part 2: Civilian/Non-Sworn Personnel Budget Summary (all applicants requesting civilian/non-sworn position(s)
must complete this section.)
After completing Part 1 of this form, answer the following questions. If necessary, attach an explanation of how you computed
salaries and benefits for this worksheet Be sure to answer EVERY question. Missing or erroneous information could significantly
delay the review of your agency's request.
1. If your agency's second and third -year costs for salaries and/or fringe benefits are greater than the first year, check the
reason(s) why In the space below. You must check at least one.
M Cost of living adjustment (COLA) 7 Step Raises F� Change in benefit costs
Other - please explain briefly:
2. If an explanation Is required for any of the following categories, please provide in the space below: 1) Social Security, 2)
Medicare, 3) Health Insurance, 4) Retirement, 5) Workers Compensation, and 6) Unemployment Insurance.
1) Social Security:
2) Medicare:
3) Health Insurance:
4) Retirement:
Worker's Compensation:
6) Unemployment Insurance:
nt Lecral Name:
!City of Miami, Florida
C. EQUIPMENT/TECHNOLOGY
ORI #:
FLO1306
No Equipment/Technology Requested
Instructions: List non -expendable items that are to be purchased. Non -expendable equipment is tangible property (e.g., technology)
having a useful life of more than two years. Expendable items should be included either in the "SUPPLIES" or "OTHER" categories.
Applicants should analyze the cost benefits of purchasing versus leasing equipment, especially for high -price items and those subject to
rapid technical advances. Rented or leased equipment costs should be listed in the "CONTRACTS/ CONSULTANTS" category. If
additional budget information is required to be entered for this category please complete the information in an electronic format and attach
the document using the "Other Attachments" form found in the Grants.gov forms package.
Pursuant to the Continuing Appropriations Resolution, 2008, (P.L.110-161), be advised that, to the greatest extent practical, all
equipment and products purchased with these funds must be American-made.
For agencies purchasing items related to enhanced communications systems, the COPS Office expects and encourages
that, wherever feasible, such voice or data communications equipment should be incorporated Into an intra- or
interjurisdictional strategy for communications Interoperability among federal, state, and local law enforcement agencies.
See the COPS Application Guide for a list of allowable/unallowable costs for the particular program for which you are applying.
Computation
UnIVItem Description (# of'Items/Units X Unit Cost) Per Item Subtotal
Dell Optiplex 960 Mini Tower
Desktop Computers
B�— 1,554.58 12,436.64
Dell Power Edge 2950 III
Server
2
8,898.23 17,796.46
Cannon EOS 50D digital camera
outfit
30
F 3,242.20
97,266.00
CannonV BP -511A Battery Pack
920OA001
60
47.00 2,820.00
Lexar 4 GB Prof UDMA Compact
Flash 30OX CF4GBB300381
60 61.001 3,660.00
Supply, installation and
training of a law enforcement
Digital Photo Lab System
1 266,020.90 266,020.90
EQUIPMENT TOTAL: 400, 000.00
Transfer to Budget
Summary Line 3
Please include a detailed description for all items listed in the Budget Narrative
I Name:
JCity of Miami, Florida
D. OTHER COSTS
ORI #:
FLO1306
No Other Costs Requested]
Instructions: List other requested items that will support the project goals and objectives as outlined in your application. Other costs may
include items such as overtime and background investigations for law enforcement officer positions and/or civilian positions if allowable
under the program for which you are applying. If additional budget information is required to be entered for this category please complete
the information in an electronic format and attach the document using the "Other Attachments" form found in the Grants.gov forms package.
Pursuant to the Continuing Appropriations Resolution, 2008, (P.L.110-161), be advised that, to the greatest extent practical, all equipment
and products purchased with these funds must be American-made.
See the COPS Application Guide for a list of allowable/unallowable costs for the particular program for which you are applying.
Computation
Unitlltem Description (# of Items/Units X Unit Cost) Per Item Subtotal)
OTHER COST TOTAL:
Transfer to Budget
Summary Line 4
Please include a detailed description for all items listed in the Budget Narrative
nt Lecial Name:
JCity of Miami, Florida
E. SUPPLIES
ORI #:
FL01306
No Supplies Requested
Instructions; List items by type (office supplies; postage; training materials; copying paper; books; hand-held tape recorders; etc).
Generally, supplies include any materials that are expendable or consumed during the course of the project. if additional budget information
is required to be entered for this category please complete the information in an electronic format and attach the document using the "Other
Attachments" form found in the Grants.gov forms package.
See the COPS Application Guide for a list of allowable/unallowable costs for the particular program for which you are applying.
Computation
Unitlltem Description (# of Items/Units X Unit Cost) Per Item Subtotal
SUPPLIES TOTAL: I`
Transfer to Budget
Summary Line 5
Please Include a detailed description for all items listed in the Budget Narrative
Applicant Legal Name:
'City of Miami, Florida
F. TRAVELITRAINING
ORI #:
FLO1306
No Travel/Training Costs Requested
Instructions: Itemize travel expenses of project personnel by purpose (e.g., mandatory training, staff to training, field interviews, advisory
group meetings). Show the basis of computation (e.g., 6 staff members times the unit cost per person for lodging for 3 days). Training
projects, training fees, travel, lodging and per diem rates for trainees should be listed as separate travel items. Show the number of staff
attending any event and the unit costs per person Involved. Identify the location of travel, when possible. Note: Any local training costs
(within a 50 -mile radius) should be listed under Section D ("Other Costs"). If additional budget information is required to be entered for this
category please complete the information in an electronic format and attach the document using the "Other Attachments" form found in the
Grants,gov forms package.
See the COPS Application Guide for a list of allowable/unallowable costs for the particular program for which you are applying.
Reason for Travel/
Training & Location
of Travel/Training
Travel/
Training Item
Computation
# of Days/
TRAVEL/TRAINING TOTAL:
Transfer to Budget
Summary Line 6
Please include a detailed description for all Items listed in the Budget Narrative
Applicant Legal Name: ORI #:
City of Miami, Florida FLO1306
G. CONTRACTS/CONSULTANTS No Contracts/Consultants Costs Requested 12
Instructions: See the COPS Application Guide for a list of allowable/unallowable costs for the particular program for which you are applying.
If additional budget information is required to be entered for this category please complete the information in an electronic format and attach
the document using the "Other Attachments" form found in the Grants.gov forms package.
Contracts: Provide a description of the product or service to be procured by contract and an estimate of the cost. Applicants are
encouraged to promote free and open competition in awarding contracts. If awarded, requests for sole source procurements of equipment,
technology or services in excess of $100,000 must be submitted to the COPS Office for prior approval.
Contract Description Per Contract Subtotal
Contracts Subtotal•--il(G1)
Consultant Fees: For each consultant enter the name (if known), service to be provided, hourly or daily fee (based upon an 8 -hour day),
and estimated length of time on the project. Unless otherwise approved by the COPS Office, approved consultant rates will be based on
the salary a consultant receives from his or her primary employer. Consultant fees in excess of $550 per day require additional written
Justification in the Budget Narrative and must be pre -approved in writing by the COPS Office.
Computation Per Consultant
Consultant Name/Title Service Provided (Cost X # Days or# Hours) Fee Subtotal
Consultant Fees Subtotal: I (G2)
Consultant Expenses: List all expenses to be paid from the grant to the individual consultants separate from their consultant fees
(e.g., travel, meals, lodging). Computation Per Consultant
Consultant Name/Title Service Provided (Cost X # of Days) Fee Subtotal
CONTRACTS/CONSULTANTS TOTAL:
Contracts (G1) + Consultant Fees (G2) + Consultant Expenses (G3)
Transfer to Budget
Please include a detailed description for all contracts listed In the Budget Narrative. Summary Line 7
Consultant Subtotal:
CONTRACTS/CONSULTANTS TOTAL:
Contracts (G1) + Consultant Fees (G2) + Consultant Expenses (G3)
Transfer to Budget
Please include a detailed description for all contracts listed In the Budget Narrative. Summary Line 7
Applicant Legal Name: ORI M
City of Miami, Florida FLO1306
H. INDIRECT COSTS No Indirect Costs Requested FKI
Instructions: Indirect costs are allowed under a very limited number of specialized COPS Training and Technical Assistance programs.
Please see the COPS Application Guide for a list of allowable/unallowable costs for the particular program for which you are applying. If
additional budget information is required to be entered for this category please complete the information in an electronic format and attach
the document using the "Other Attachments" form found in the Grants.gov forms package.
If indirect costs are requested, a copy of the agency's fully-executed, negotiated Federal Rate Approval Agreement must be attached to
this application.
Indirect Cost Description Computation Per Indirect Cost Subtotal
INDIRECT COSTS TOTAL: I—
Transfer to Budget
Summary Line B