COPY OF COPY OF MARICOPA COUNTY SFP OD2A RETENTION BUDGET DRAFT 4323.XLSX

Jurisdictional/State Funded Projects Budget Template
June 10, 2022
This template has been designed to auto calculate and populate data.
Be sure you only enter data in cells highlighted in Yellow.
DO NOT skip rows when entering new data.
Helpful Reminders
Review for additional information
Summary Tab
Enter Project ID, budget period, and budget target information

Unal
1)
2)
3)
4)
Note
1)
2)
3)
Sala
1)
2)
3)
4)
HR R
We r
estim
of ab
1)
2)
3)
4)
Addi
To st

Trav
Mea
M&I
http
IRS 2
1)
2)
3)
SFP

Concur Softeware Fees
Cell Phone costs for core employees
ADP fees
General Office Supplies (Unless approved by sponsoring agency)
Temporary Staffing Agencies are treated as subcontractors and should be in this category. One may
want to consider alloting a portion of the budget for contractual employees.
Build a budget line for costs billed by temporary staffing agencies.
Background checks are allowable in the approved budget and should be coded to "other."
If proposed staff person is unidentified, name may be "TBD" and representative salaries may be used
If proposed staff person is identified, name and salary must be actuals
LOE for Federal Budget Analyst and Federal Grants Manager are included at a minimum of 10%; these
numbers should be confirmed for each project
No base salary may exceed the executive salary cap of $203,700
Contract includes 1 - 5 Open Positions - 25% of an FTE Recruiters time in direct costs 
Contract includes 6 - 10 Open Positions - 50% of an FTE Recruiters time in direct costs 
Contract includes 11 - 15 Open Positions - 75% of an FTE Recruiters time in direct costs 
Contract includes 16+ Open Positions - 100% of an FTE Recruiters time in direct costs 
Laptops for any new employee at 100% LOE: $2000
Cell Phones for any new (non core) employee at 100% LOE: $500
Cell Phone Service: $50/month
PPE (Masks and Gloves): $100/FTE
Software, Adobe Acrobate Pro: $218/FTE (special software only for those requiring)
Zoom License: $180/new FTE
Cell Phone Shipping: $15/unit
Laptop Shipping: $26/unit
allowable Costs
es
aries
Recruitment 
recommend including recruitment for direct cost recovery.  Below is a scale that may help you build an
mate into the template.  We expect the recruiter hourly rate to be $50-55/hour, or an annualized salary
bout $90k.
ditional Budget Costs
tandarize potential costs across federal budgets, the following is recommended

Per Diem expenses are divided into the categories: Lodging expenses, Mileage expenses, and Meal &
Incidental Expenses (abbreviated M&IE). M&IE Per Diem is designed to cover daily cost of food and
other incidental expenses.
58.5 cents per mile driven for business use; Aligns w/ GSA per diem rate
18 cents per mile driven for medical or moving purposes
14 cents per mile driven in service of charitable organizations
If a question arises around the timely payment of invoices, please reach out to your Federal Budget
Analyst and any staff dedicated to ensuring the timely payment of such invoices specifically for
confirmation of paid/unpaid status in Salesforce.  Please do not attempt to contact the sponsoring
agency directly unless instructed to do so.
vel
als & Incidental Expenses (M&IE):
IE Breakdown Per GSA (See weblink below.)
ps://www.gsa.gov/travel/plan-book/per-diem-rates/mie-breakdown
2022 Standard Mileage Rates
Invoicing Guidelines

Project Budget ID
Maricopa County OD2A Retention
Budget Period
7/1/2023-6/30/2024
Budget Category
Total
Salaries and Wages (Employees)
130,594.20
    Direct Personnel
37,894.20
    Program Personnel
92,700.00
Fringe Benefits
32,126.14
    Direct Fringe
9,187.59
    Program Fringe
22,938.55
Supplies
-
Travel
-
Other
-
Contractual
-
Total Direct:
162,720.34
Exclusions from Base (If Applicable)
-
Indirect Cost Base
162,720.34
Total Indirect (@ 16%) :
26,035.25
Total Proposed (Enter Project Budget ID):
$188,755.59
Target:
$0.00
+/-:
$188,755.59
Direct Costs
47,081.79
Program Costs
115,638.55
Indirect Costs
26,035.25

Personnel
Direct (D) /
Program
(P)
Position
 Funding
Source
(Field
Employee
s)
Name
D
CDCF Federal Budget Analyst
TBD
D
CDCF Federal Grants Manager 
TBD
D
CDCF HR Generalist
TBD
D
CDCF Program Manager
TBD
D
CDCF Sr. Program Manager
TBD
D
CDCF Emergency Response Senior Portfolio Manager
TBD
P
Epidemiologist
Ayanna Vasquez

Base
New Hire?
Contract Start
Date
Contract End Date
Next Position
Anniversary Date
$
90,000.00
N
7/1/2023
6/30/2024
8/1/2023
$
83,000.00
N
7/1/2023
6/30/2024
8/1/2023
$
85,000.00
N
7/1/2023
6/30/2024
8/1/2023
$
105,000.00
N
7/1/2023
6/30/2024
8/1/2023
$
110,000.00
N
7/1/2023
6/30/2024
8/1/2023
$
116,000.00
N
7/1/2023
6/30/2024
8/1/2023
$
90,000.00
N
7/1/2023
6/30/2024
7/1/2023

Salary Total
Fringe Total
$
130,594.20 $
32,126.14
Term (In Months)
FTE
Period Base
Fringe Total
12.0
0.10
$
9,247.50 $
2,289.88
12.0
0.05
$
4,264.13 $
1,081.47
12.0
0.05
$
4,366.88 $
1,099.60
12.0
0.10
$
10,788.75 $
2,561.91
12.0
0.05
$
5,651.25 $
1,326.30
12.0
0.03
$
3,575.70 $
828.42
12.0
1.00
$
92,700.00 $
22,938.55

Personnel Total
$
162,720.34
Total
Calculated Rate
$
11,537.38
25%
$
5,345.59
25%
$
5,466.48
25%
$
13,350.66
24%
$
6,977.55
23%
$
4,404.12
23%
$
115,638.55
25%

Supplies
Item
Unit Cost
Number
Contract Start
Date
Contract End
Date
Subscription - Ad hoc
Monthly Cell Phone S
50
`
Cell Phone
499
Cell Phone Shipping
15
Cell Phone Case
30
Laptop
1892
Laptop Shipping
26
General Office Supplie
100
PPE
100

Period Total
Grand Total
$
-
$
-
Term (In
Months)
Period
Total
-
$0.00
$0.00
-
$0.00
$0.00
-
$0.00
$0.00
-
$0.00
$0.00
-
$0.00
$0.00
-
$0.00
$0.00
-
$0.00
$0.00
-
$0.00
$0.00
-
$0.00
$0.00

Destination - Provide a justification,
including how the requested travel is
essential to meet the project activities.
Example:
Site visit- where and why- Travel to X to
discuss and assess programmatic activities.
# of Trips
# of Travelers
Est. Airfare per
Traveler
Airfare Total
Unit Price
Units (Days)
Lodging
Total
Per Day
Days
M&E Total
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

Est. Ground
Transportation
($/trip)
Transportation Total
Est. Training
Registration
Registration Total
Est. Total
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

Grand Total
Other
$
-
Item
Description
Total

09 Contractual
$
-
$
-
$
-
Subcontract/Subaward Name
Total Contract
Amount
Incurred Indirect
Excluded from
Indirect
-
-