ISB_Sample_(1).xls

XLS spreadsheet 47 KB Posted

Attached to
Youth Crime Prevention Program
Solicitation number
HSD-RFP-26-0074
Issued by
Maricopa County, Phoenix City, Arizona

About this file

This is an Itemized Service Budget (ISB) template for the City of Phoenix Human Services Department's Youth Crime Prevention Program, a three-year professional services contract commencing January 1, 2025, and extending through December 31, 2027. The program targets juvenile crime reduction in four Phoenix neighborhoods: Maryvale, South Phoenix, Alhambra, and Central City, serving youth aged 12-17 through intervention services including violence prevention, substance abuse prevention, after-school enrichment, mental health services, dropout prevention, and family support. Key deliverables include 360 mentoring hours, 48 group family workshops, and 540 hours of after-school recreation utilizing the Eisenhower Quantum Opportunities Curricula. The staffing model comprises 2.10 Full-Time Equivalents (FTEs) distributed across an Executive Director (0.10 FTE), Supervisor (1.00 FTE), and Caseworker I (1.00 FTE), with implementation occurring at four locations: Cesar Chavez High School, Alhambra High School, ABC Community Center, and City of Phoenix Burton Barr Library.

The total contract cost is $708,471 for the three-year period, with the City of Phoenix contributing $500,000 and Valley of the Sun United Way providing $208,471 in matching funds. Direct costs total $596,676, comprising personnel ($385,500), employee-related benefits ($61,680), professional and outside services including audit and interpreting services ($35,100), travel and mileage reimbursement ($2,340), materials and supplies ($5,616), operating services for communications and facilities ($28,440), equipment including laptops and cell phones ($4,200), and direct client assistance for bus passes and fuel cards ($73,800). An indirect cost allocation of $111,795, representing 25 percent of salaries and employee-related expenses, is included subject to City of Phoenix approval. The City's cost share totals $499,999.50, with Disadvantaged Business Enterprise (DBE) and small business participation requirements mandating contractors track and report DBE engagement through the City's Certification and Compliance System.

View the file

Other files

File Type Posted
Youth_Crime_Prevention_Program.pdf PDF
Youth_Crime_Prevention_Program.pdf PDF
Youth_Crime_Prevention_Program.pdf PDF
EXHIBIT_A_-_Youth_Crime_Prevention_Scope_of_Work_FINAL.docx DOCX document
EXHIBIT_A_-_Youth_Crime_Prevention_Scope_of_Work_FINAL.docx DOCX document
EXHIBIT_A_-_Youth_Crime_Prevention_Scope_of_Work_FINAL.docx DOCX document
EXHIBIT_B_Page_2.pdf PDF
EXHIBIT_B_Page_2.pdf PDF
EXHIBIT_B_Page_2.pdf PDF
Acceptance_of_Offer_Form_2025.pdf PDF
Acceptance_of_Offer_Form_2025.pdf PDF
EXHIBIT_D.docx DOCX document
EXHIBIT_D.docx DOCX document
Acceptance_of_Offer_Form_2025.pdf PDF
EXHIBIT_D.docx DOCX document
EXHIBIT_B_(1).docx DOCX document
EXHIBIT_B_(1).docx DOCX document
EXHIBIT_B_(1).docx DOCX document
ISB_Sample_(1).xls XLS spreadsheet
ISB_Sample_(1).xls XLS spreadsheet
ISB_TEMPLATE.xlsx XLSX spreadsheet
ISB_TEMPLATE.xlsx XLSX spreadsheet
ISB_TEMPLATE.xlsx XLSX spreadsheet
Attachment_-_PTD_Disadvantaged_Business_Enterprise_-_Small_Business_Participation_Plan_Annual.pdf PDF
Sensitive_Security_Information_Acknowledgement_Form.docx DOCX document
Attachment_-_Request_for_Substitution_-_Exemption.pdf PDF
Attachment_B_-_FTA_-_Federal_Certifications_(March_2025).pdf PDF
Attachment_-_PTD_Disadvantaged_Business_Enterprise_-_Small_Business_Participation_Plan_Initial_Plan.pdf PDF
Attachment_-_Request_for_Substitution_-_Exemption.pdf PDF
Attachment_B_-_FTA_-_Federal_Certifications_(March_2025).pdf PDF
Supplemental_Terms_And_Conditions_To_All_Airport_Agreements_(Rev._5-22-24-Formatting_Rev._7-11-24).pdf PDF
Supplemental_Terms_And_Conditions_To_All_Airport_Agreements_(Rev._5-22-24-Formatting_Rev._7-11-24).pdf PDF
Attachment_-_Certification_of_Full_-_Final_Payments_to_DBE_Firms.pdf PDF
Attachment_-_PTD_Disadvantaged_Business_Enterprise_-_Small_Business_Participation_Plan_Annual.pdf PDF
Attachment_B_-_FTA_-_Federal_Certifications_(March_2025).pdf PDF
Supplemental_Terms_And_Conditions_To_All_Airport_Agreements_(Rev._5-22-24-Formatting_Rev._7-11-24).pdf PDF
Attachment_-_Certification_of_Full_-_Final_Payments_to_DBE_Firms.pdf PDF
Attachment_-_PTD_Disadvantaged_Business_Enterprise_-_Small_Business_Participation_Plan_Annual.pdf PDF
Attachment_-_PTD_Disadvantaged_Business_Enterprise_-_Small_Business_Participation_Plan_Initial_Plan.pdf PDF
Attachment_-_Request_for_Substitution_-_Exemption.pdf PDF
Attachment_-_Certification_of_Full_-_Final_Payments_to_DBE_Firms.pdf PDF
Attachment_-_PTD_Disadvantaged_Business_Enterprise_-_Small_Business_Participation_Plan_Initial_Plan.pdf PDF
Sensitive_Security_Information_Acknowledgement_Form.docx DOCX document
Sensitive_Security_Information_Acknowledgement_Form.docx DOCX document
Addendum_Form.docx DOCX document
Addendum_Form.docx DOCX document
Addendum_Form.docx DOCX document
Show all 47

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

ISB Template

ITEMIZED SERVICE BUDGET
CONTRACT SERVICE:Youth Crime Prevention ProjectSAMPLE ISBNAME:SAMPLE ISB
Contract Period:January 1, 2025 - December 31, 2027
I.PERSONNEL
Number of PositionsFTE Level- to be allocated to the servicePosition TitleTotal Salary for Contract Period Per Position% Allocated To Service * A + DTotal Service Cost (B * D)City Cost
10.10Executive Director$ 255,000.00A 5% + D 5% = 10%$25,500.00$12,750.00
($85,000 Per Year X 3 Yr)
11.00Supervisor$ 195,000.00A 30% + D 70% = 100%$195,000.00$97,500.00
($65,000 Per Year X 3 Yr)
11.00Caseworker I$ 165,000.00A 20% + D 80% = 100%$165,000.00$165,000.00
('$55,000 Per Year X 3 Yr)
22.10TOTAL:$385,500.00$275,250.00
*A = % Administrative Functions D = % Direct Service Functions
II.EMPLOYEE RELATED EXPENSES
TOTALCITY
ITEMBASISCOSTCOST
Various Fringe Benefits16% of Salaries Charged$61,680.00$44,040.00
FICA (0.0765%), Health Insurance
Unemployment Insurance, Workers Compensation, etc.
$61,680.00$44,040.00
III.PROFESSIONAL AND OUTSIDE SERVICES
TOTALCITY
ITEMBASISCOSTCOST
Audit Services$6,000 per year X 15% charged to the service$2,700.00$2,700.00
Professional Interpreting Svcs$90 per hour X 10 hrs per mo. X 36 months$32,400.00$16,200.00
TOTAL:$35,100.00$18,900.00
IV.TRAVEL
TOTALCITY
ITEMBASISCOSTCOST
Staff Mileage Reimbursement2 Staff X 100 miles per month X 36 months X .65 Cents$2,340.00$1,170.00
Per Mile reimbursement rate
TOTAL:$2,340.00$1,170.00
V.MATERIALS AND SUPPLIES
TOTALCITY
ITEMBASISCOSTCOST
Office Supplies$152 Per Month X 36 Months$5,616.00$5,616.00
TOTAL:$5,616.00$5,616.00
VI.OPERATING SERVICES
TOTALCITY
ITEMBASISCOSTCOST
Cellular Phones & Internet Fees$72 per month X 2 Lines X 36 Months$5,400.00$2,700.00
Office Space/Security Systems, WiFi, Utilities$3600 per month X 36 months X 15%$19,440.00$19,440.00
Parking Fees$50 per month X 2 Staff X 36 Months$3,600.00$3,600.00
TOTAL:$28,440.00$25,740.00
VII.EQUIPMENT
TOTALCITY
ITEMBASISCOSTCOST
Laptops, Monitors, Docking Stations2 Laptops @ $1,400 per item$2,800.00$2,800.00
Cell Phones2 Cell Phones @ $700 per item$1,400.00$1,400.00
TOTAL:$4,200.00$4,200.00
VIII.DIRECT CLIENT ASSISTANCE
TOTALCITY
ITEMBASISCOSTCOST
Bus Passes, Fuel Cards$50 X 40 passes per month x 36 months$73,800.00$45,261.00
TOTAL:$73,800.00$45,261.00
SUBTOTAL DIRECT COST:$596,676.00$420,177.00
VIIII.INDIRECT(must have prior City of Phoenix approval)
TOTALCITY
ITEMBASISCOSTCOST
Federally Approved Indirect Cost Rate25% of Salaries & Employee Related Expenses$111,795.00$79,822.50
$0.00
TOTAL:$0.00$0.00
SUBTOTAL ADMIN COST:$111,795.00$79,822.50
TOTAL SERVICE COST:$708,471.00$499,999.50
REVENUE SOURCES:
City of Phoenix$500,000.00$500,000.00
Valley of the Sun United Way$208,471.00
TOTAL REVENUE:$708,471.00$500,000.00
$0.00$0.50

&L&8&D &Z&F

Sheet1

File details come from the government source that posted it. Updated .