HomeMy WebLinkAboutExhibit 6OMB APPROVAL NO. 1121-01BB
EXPIRES 5-98 (Rev. 1/97)
Budget Detail Worksheet
Purpose: The Budget Detail Worksheet may be used as a guide to assist you in the preparation of
the budget and budget narrative, You may submit the budget and budget narrative using this form or in
the format of your choice (plain sheets, your own form, or a variation of this form), However, all
required information (including the budget narrative) must be provided. Any category of expense not
applicable to your budget may be deleted.
A. Personnel - List each position by title and name of employee, if available. Show the annual
salary rate and the percentage of time to be devoted to the project. Compensation paid for employees
engaged in grant activities must be consistent with that paid for similar work within the applicant
organization.
Name/Position Computation Cost
Accountant
$41,450.08 x 1 x ( 2years)
$82;900.16
Administrative Aide II & Administrative Assistant 1
$64,444.03 x 3 i $48,033.25 x 3 x (2 years)
$674,863.68
Crime Analyst I
$41,45D.08 x 2 x (2 years)
1
$165,800.34
Information Technicians III
$48,D33.25 x 2), (2 years)
$192,132.98
Maintenance Mechanics
$37,646.69 x 2 x (2 years)
$150,586.76
Senior Staff Analyst
$55,574.49 x 1 x (2 years)
$1 1 1,148.98
SUB -TOTAL $1,377,432,911
B. Fringe Benefits - Fringe benefits should be based on actual known costs or an established
formula. Fringe benefits are for the personnel listed in budget category (A) and only for the
percentage of time devoted to the project. Fringe benefits on overtime hours are limited to FICA,
Worlman's Compensation, and Unemployment Compensation.
Name/Position Computation Cost
Social Securlly (7.65%) $688,716.44,,10.26%.Y, (2 years) $141 ,324,62
Workers Compensation (2,61%)
Fringe benefit 3
Fringe benefit 4
Fringe benefit 5
SUB -TOTAL $141,324.62
Total Personnel & Fringe Benefits $1,518,757.;
OJP FORM 7150/1 (5-95)
C. Travel - Itemize travel expenses of project personnel by purpose (e.g., staff to training, field
interviews, advisory group meeting, etc.), Show the basis of computation (e.g., six people to 3 -day
training at $X airfare, $X lodging, $X subsistence). In training projects, travel and meals for trainees
should be listed separately. Show the number of trainees and the unit costs involved. Identify the
location of travel, if known. Indicate source of Travel Policies applied, Applicant or Federal Travel
Regulations.
Purpose of ravel Location Item Computation Cost
Travel entry 1, two lines per
entry F -1= I
Travel entry 2
Travel entry 3
Travel entry 4
Travel entry 5
"yelen, 6
Travel entry 7
TOTAL $0.00
A Equipment - List non -expendable items that are to be purchased, Non -expendable equipment
is tangible property having a useful life of more than two years and an acquisition cost of $5,000 or
more per unit. (Note: Organization's own capitalization policy may be, used for items costing less than
$5,000). Expendable items should be included either in the "supplies" category or in the "Other"
category. Applicants should analyze the cost benefits of purchasing versus leasing equipment, espe-
cially high cost items and those subject to rapid technical advances, Rented or leased equipment costs
should be listed in the "Contractual" category. Explain how the equipment is necessary for the success
of the project. Attach a narrative describing the procurement method to be used,
Item Computation Cost
Computers-PC/Laptop/Warrentles/Software/Accessories 162 x $6,000 706.14 $810,706.14
eglupmenl entry 2
equipment entry 3
equipment -entry 4 _..__ .... ..._..-......_ _—_ -- _
equipment entry 5
TOTAL $810,706.14
E. Supplies - List items by type (office supplies, postage, training materials, copying paper, and
expendable equipment items costing less that $5,000, such as books, hand held tape recorders) and
show the basis for computation. (Note, Organization's own capitalization policy may be used for
items casting less than $5,000). Generally, supplies include any materials that are expendable or
consumed duruig the course of the project.
Supply Items Computation Cost
Supply Item 1, one line per entry
supply Item 2
supply Item 3
supply Item 4
supply Item 5
supply Item 6
supply Item 7
supply Item 8
supply Item 9
TOTAL$o.00
F Construction - As a rule, construction costs are not allowable. In some cases, minor repairs 'or
renovations may be allowable. Check with the program office before budgeting funds in this
category.
Purpose Description of Work
four lines per entry, use boxes below or an additional
page for more space If required
Cost
TOTAL $0.00
FGCOnsultants/Contracts -.Indicate wbetber applicant's formal, written Procurement Policy or
deral Acquisition Regulations are follo«1ed.
ltant Fees: For each consultant enter the name, if known, service to be provided, hourly or daily
fee (8 -hour day), and estimated time on the project. Consultant fees in excess of $450 per day require
additional justification and prior approval from OJR
Name of Consultant Service Provided Computation Cost
Supply Item 1, one line per entry
r—ey,lmum of three lines
Supply Item 1, one line per entry
Supply Item 1, one line per entry
--1
Supply Item 1, one line per entry—�
Subtotal $0.00
Consultant Expenses: List all expenses to be paid from the grant to the individual consultants in
addition to thein fees (i,e., travel, meals, lodging, etc.)
Item Location Computation Cost
Consultant expense entry 1, one line p
maximum of three lines F
�I
�7
maximum of three fines
Consultant expense entry 1, one line p
maximum of three lines
Subtotal $0.00
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.
A separate justification must be provided for sole source contracts in excess of $100,000,
Item Cost
maximum of four lines, additional information should be attached on a separate sheet(s)
maximum of four lines
Subtotal $0,00
TOTAL $0.00
H. Other Costs -List items (e,g., rent, reproduction, telephone, janitorial or security services,
and investigative or confidential funds) by major t3,pe and the basis of the computation. For example,
provide the square footage and the cost per square foot for rent, or provide a monthly rental cost and
how many months to rent,
Description Computation Cost
four lines per entry, use boxes below or an additional
page for more space If required
TOTAL $0.00
I. Indirect Costs - Indirect costs are allowed only if the applicant has a Federally approved indirect
cost rate. A copy of the rate approval, (a fully executed, negotiated agreement), must be attached, If
the applicant does not have an approved rate, one can be requested by contacting the applicant's
cognizant Federal agency, which will review all documentation and approve a rate for the applicant
organization, or if the applicant's accounting system permits, costs may be allocated in the direct costs
categories.
Description Computation Cost
Costs associated with administering JAG funds $2,329,463.64 X 10% $232,946,36
Costs assoclatad with administering JAG funds
$2,329,463,64 X 10%
--------------
TOTAL $232,946,36
Budget Summary- When you have completed the budget worksheet, transfer the totals for each
category to the spaces below.
Compute the total direct costs and the total project costs. Indicate the
amount of Federal requested and the amount of non -Federal funds that will support the project.
Budget Category
Amount
A. Personnel
$1,377,432.90
B. Fringe Benefits
$141,324.62
C. Travel
$0.00
$810,706.14
D. Equipment
E. Supplies
$0.00
R Construction
$0.00
G. Consultants/Contracts
$0.00
$0.00
H. Other
Total Direct Costs
$2,329,463.66
I. Indirect Costs
TOTAL PROJECT COSTS $2,562,410.Cd
Federal Request $2,562,410.00
Non -Federal Amount
Position
Starting Salary
3% in 10109
Travel
Sub-Total
9 of
Positions
Total Salary
10.26% Fringe
Benefits
Total (salary +
fringe) Year 1
Total (salary +
fringe) Year 2
Accountant
$
40,242.80
$
1,207.28
$
41,450.03
1
S 41,450.08
$
4,252.78
$
45,702.86
$ 91,405,73
Adm_ Aide II
$
62,567.02
$
1,877.01
1
64,444.03
3
3193,332.09
$
19,835.87
$
213,167.96
$ 426,335.93
Adm_ Asst I
$
46,634.22
$
1,399.03
$
48,033.25
3
$144,099.74
$
14,784.63
$
158,884.37
5 317,768.75
Crime Analyst 1
$
40,242.80
$
1,207.28
$
41,450.08
2
$ 82,900.17
$
8,505.56
$
9I,405.73
$ 182,811.45
I_T. Technicians III
$
46,634.22
$
1,399.03
$
48,033.25
2
$ 96,066.49
$
9,956.42
$
105,922.92
$ 211,845.83
Maintenance Mechanics
$
36,550.18
$
1,096.51
$
37,646.69
2
$ 75,293.37
$
7,725.10
$
83,018.47
$ 166,036.94
Senior Staff Analyst$
53,955.82
$
1,618.67
$
55,574.49
1
$ 55,574.49
$
5,701.94
$
61,276.44
$ 122,552.88
One-year total
' $
i
326,327.06
$
9,304.81
$
336,631.87
$688,716.44
$
70,66231
$
759,378.75
$ 1518,751.50
Budget SummarY
Personnel
51,518,757.50
Travel
50.00
Equipment (i62 computers @ '.
approximately 55,000; to
include PCILaptap/Software/
Warranties/ Bracket Docking
Stations/Accessories)
5810,706.14
Supplies
50.00
Construction
50.00
Consultant/Contracts
50.00
Other Costs
50.00
Total Direct Costs
52,329,463.64
indirect Cost (10%) Costs
Associated with
administering JAG funds
523294636
TOTAL PROJECT COSTS
52,562,410.00
Total Allocated
52,562,410.00
Difference
50.00