HomeMy WebLinkAboutBudget Detail WorksheetOMB APPROVAL NO. 1121-0188
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
Six officers/Middle School component 8 x 80 hrs. ea. x $52.42 (avg. o/t rate) $25,162.00
Five officers/Elementary School component 5 x 40 hrs. ea. x $52.42 J $10,484.00
Two officers/Summer component 2 x 20 hrs. ea. x $52.42 $2,097.00
Ten officers/Two field trips 10 x 10 hrs. x $52.42 $5,242.00
Qo5tltion 6
SUB -TOTAL $42,985.00
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,
Workman's Compensation, and Unemployment Compensation.
Name/Position Computation Cost
13 officers $42,985 (personnel) x 10.26% ( FICA & Workers Co $4,410.00
Fringe benefit 2
Fringe benefit 3
Fringe benefit 4
Fringe benefit 5
SUB -TOTAL $4,410.00
Total Personnel & Fringe Benefits $47,395.00
OJP FORM 715011 (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 Travel Location Item Computation Cost
Travel entry 1, two lines per
entry
GREAT Conf. TBA
JAir fare
2 Ofc. x $600/ea.
F$1,200.00
Travel entry 2
Car rental 1[,
x $250.00
$250.00
Travel entry 3
Hotel 2 Ofc, x 5 days x $1501day $1,500.00
Travel entry 4
Registration 2 Ofc. x $225/ea. $450.00
I_7]
Travel entry 5
Meals
2 Ofc. x 5 days x $56.60/d2
$566.00
Travel entry 6
GREAT Training in Orland
Meals, parking, gas, misc. 1[2
Ofc, x 15 days x $64.60/d
$1,938.00
Travel entry 7
TOTAL $5,904.00
D. Equipment - List non -expendable items that are to be purchased. Non -expendable equipment
is tangible property having a useftil 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
Three cellular telephones with monthly cost 3 x $75/ea. per month x 12 months
F
equipment entry 2
equipment entry 3
equipment entry 4
equipment entry 5
. Cost
$2,700.00
TOTAL $2,700,00
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 costing less than $5,000). Generally, supplies include any materials that are expendable or
consumed during the course of the project.
Supply Items Computation Cost
Participant Incentives
1140 participants x $7.42 each
$8,459.00
Recognition/Awards
30 awardees x $30 each
$900.00
Food and beverage for graduations
44 classes x $100/per class
$4,400.00
Cost of admission tickets for field trips and lunch
40 tickets x $20/ea. + $20 parking (2 trips)
$820.00
GREAT Officer polo shirts
13 officers x $26.50 per shirt
$345.00
supply item 6
supply item 7
supply item 8
supply item 9
TOTAL $14,924.00
E 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 Cost
N/A
TOTAL $0.00
G. Consultants/Contracts - Indicate whether applicant's formal, written Procurement Policy or
the Federal Acquisition Regulations are followed.
Consultant 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 0JP.
Name of Consultant Service Provided Computation Cost
N/A
maximum of three lines
Supply item 1, one line per
Supply item 1, one line per entry--�
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 their fees (i.e., travel, meals, lodging, etc.)
Item Location Computation Cost
Consultant expense entry 1, one line p
maximum of three lines
maximum of three lines
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 sen�ices,
and investigative or confidential funds) by major type 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
Match (In-kind)
26 classes x 3hrs x 2 ofc. x $52.42 (overtime) $8,178.00
i
TOTAL $8,178.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
IF
IF
IF
TOTAL $0.00
l�
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
$42,985.00
'B. Fringe Benefits
$4,410.00
C. Travel
$5,904.00
D. Equipment
$2,700.00
E. Supplies
$14,924.00
F Construction
$0'00
G. Consultants/Contracts
$0'00
H. Other
$8,178.00
Total Direct Costs
$79,101.00
$0.00
I. Indirect Costs
$79,101.00
TOTAL PROJECT COSTS
Federal Request $70,923.00
$8,178:00
Non -Federal Amount
�k