ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Attachment C - Cost-Reimbursement STEPP RFA Budget Template 12 Month
2
3
Colorado Department of Public Health and Environment - Prevention Services Division
4
5
Budget Template Instructions
6
7
8
General Instructions:
9
The Budget Template should be used to explain how an entity plans to use funds consistently with the proposed implementation plan and project description. The Budget Template includes six worksheets: Instructions, Indirect Cost Guidance, MTDC Budget Example, MTDC Budget Template, S+F Budget Example and S+F Budget Template. The budget example does not reflect the actual dollar amount available for this grant. Budget requests and their associated deliverables need to be in alignment and provide a consistent, logical picture of what is to be accomplished, by whom, and the associated costs. Questions about this budget template should be submitted via the RFA question form. Click here to submit a question.
10
11
The budget groups in the template are provided for guidance purposes only.
12
13
Save this template with the following naming convention FY27_STEPP_ProposedBudget__Program Name_Agency Name. Delete unused tabs, including directions and examples. Attach to the RFA Application form when prompted.
14
15
The information contained in each expenditure category helps PSD understand the budget. Please provide narrative for each category in the "Description of Work" or the "Description of Item" section.
16
17
The form is an Excel worksheet that includes instructions in various cells that can be viewed by hovering the computer mouse over the cells. The instructions below give additional guidance.
18
19
Contact Information
20
Complete the top portion of the form by providing Agency Name, Budget Period, Project Name, and Contact Information for both Program and Fiscal contacts.
21
22
Contractor Name Program Contact Name, Title, Phone and Email
23
Enter agency's nameEnter agency's program contact information here
24
Budget Period Fiscal Contact Name, Title, Phone and Email
25
Enter budget/ project period datesEnter agency's fiscal contact information here
26
Project Name
27
Enter the project name
28
29
Personal Services (Salaried Employees and Hourly Employees)
30
It is expected that agency employees included in this section will complete all of the work related to the project/contract.
31
32
Column B: Position Title
33
Example 1: Project Coordinator (salaried)
34
Example 2: Project Administrator (hourly)
35
36
Column C: Description of Work
37
Use the "Description of Work" column of the budget template to address the role and expected contribution of budgeted personnel. The time commitment of each individual should be justified as a reasonable estimate for the work to be performed. A description of how fringe benefits are projected and what components are included in the calculation (insurance, paid time off, pension, etc.) must be included. For hourly employees, please include hourly rate, hourly fringe and the number of hours budgeted.
38
39
Columns D-F (salaried employees): Gross or Annual Salary / Fringe / Percent of Time on Project
40
Enter the Gross or Annual salary, Fringe, and the Percent of Time Spent on Project for each employee that will work on the project.
41
 For example: A full-time salaried employee is paid $60,000 a year; their fringe benefits rate is 22%; they plan to spend approximately 100% of their time on the project. Their total contribution to the Statement of Work is calculated as follows:
42
43
 $ 60,000 *Gross Annual Salary
44
22%Fringe %
45
 $ 13,200 *Fringe ($60,000 x 22%)
46
 $ 73,200 Annual Salary + Fringe ($60,000 + $13,200)
47
100%*Percent of Time on Project
48
 $ 73,200 Amount Requesting from CDPHE (automatically calculates)
49
*Enter into the Budget Template
50
51
Columns D-F (hourly employees): Hourly Wage / Hourly Fringe / Number of Hours on Project
52
Enter the Hourly Wage, Hourly Fringe and the Total # of Hours on Project than an employee will work on the project. This section may include temporary employees, if paid hourly
53
For example: An hourly employee is paid $15/hour with 25% fringe; their time on the project will be 20 hours/week for 39 weeks. Their total contribution to the Statement of Work is calculated as follows:
54
20 hours/week x 39 weeks = 780 Hours
55
$15/hour x 25% fringe = $3.75/hour fringe
56
$15/hour + $3.75/hour = $18.75/hr
57
$18.75/hour x 780 hours = $14,625
58
59
ENTER ON FORM:
60
 $ 15.00 *Hourly Wage
61
25%Fringe %
62
 $ 3.75 *Hourly Fringe ($15 x 25%)
63
 $ 18.75 Hourly Wage + Fringe ($15.00 + $3.75)
64
 780 *Total # of Hours on Project (20x 39 weeks)
65
 $ 14,625 Amount Requesting from CDPHE (automatically calculates)
66
*Enter into the Budget Template
67
68
Column G: Total Amount Requested from CDPHE
69
This column should reflect the amount(s) the agency is requesting from CDPHE for each employee working on the project.
70
71
Total Personal Services (including fringe benefits)
72
This row should show the totals for each columns and reflect the total amount of Personnel Services costs the agency is requesting from CDPHE. This is a formula and does not require manual entry.
73
74
Supplies & Operating Expenses
75
Supplies and operating expenses may include, but are not limited to, postage, office supplies, paid media, educational materials, and copying.
76
77
Column B: Item
78
This column should list the item to be used in support of the Statement of Work. Noted below are a two examples
79
Example 1: Training Materials - Prevention materials for 225 participants for 5 communities
80
Example 2: Telephone lines/long distance and Internet services
81
82
Column C: Description of Item
83
This is a description of the item(s) listed in Item Column. Use the Item Description Column to describe the rationale for the costs budgeted (how it will be used to advance the Statement of Work) and how cost estimates are calculated.
84
Example 1: Includes work book and other necessary supplies. Work book = $15/student ($15x225=$3,375) and teacher supplies (paper, markers, flip chart, etc…) $20/9 sessions ($20x9=$180). Total cost $3,555.
85
86
Column E: Rate and Column F: Quantity
87
Describe Rate in Column E and Quantity in Column F, if appropriate.
88
Example 1: work books and participant supplies
89
22545 community participants x 5 communities9sessions/days
90
 $ 15.00 work book expense $ 20.00
trainer supplies per sessions
91
 $ 3,375.00 total participant supplies $ 180.00 total trainer supplies
92
93
 $ 3,375.00 total participant supplies
94
 $ 180.00 total trainer supplies
95
 $ 3,555.00 *Total Amount Requested from CDPHE
96
*Enter into the Budget Template
97
98
Example 2: Internet/server access services and telephone services cost averages $206.19 per person x 1 staff.
99
 $ 206.19 *Rate
100
1*Quantity