Exhibit_C_-_Community_Hub_Budget_REVISED_Spreadsheet_06042025.xlsx
XLSX spreadsheet 22 KB Posted
- Attached to
- AZ|CTR078421
- Contract number
- CTR078421
- Issued by
- Arizona
About this file
The document is a detailed budget spreadsheet for a Community Hub, appearing to be an internal budgeting exhibit for a state or local government human services program. The spreadsheet provides a comprehensive breakdown of personnel, expenses, and operational costs across two budget iterations, with the first column representing an initial budget and the second column showing a revised, expanded budget.
The budget is structured to support a Community Hub program with key personnel including a Program Director and multiple Family Advocates, totaling five full-time equivalent (FTE) positions. The budget covers various operational expenses such as personnel services, employee-related expenses, telecommunications, office supplies, professional development, direct services, and program incentives. The initial budget is $500,000, while the revised budget increases to $759,827, with a 10% indirect cost rate applied. Direct services notably include human services assistance like food vouchers, rent payments, and utility payments, estimated at $16,416.67 per month. The budget also allocates funds for community information fairs, staff training, and program incentives for community training attendees.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| CI_ADCS_Pilgrim_s_Rest_Foundation_Approved_11.15.2023.pdf | ||
| COI_-_Expiring_08-04-2026.pdf | ||
| CTR078421_Contract.pdf |
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
Community Hub (2)
| Budget Category | Line Item Description | Requested Funds | Total Cost | ||
| PERSONNEL SERVICES | Personnel Services Sub Total | $288,300 | |||
| Salaries | |||||
| Program Director | 1.0 FTE | Annual Salary $82,400 | $82,400 | $82,400 | |
| Family Advocate | 1.0 FTE | Annual Salary $61,800 | $61,800 | $61,800 | |
| Family Advocate | 1.0 FTE | Annual Salary $61,800 | $61,800 | $61,800 | |
| Family Advocate | 1.0 FTE | Annual Salary $61,800 | $61,800 | $61,800 | |
| $0 |
| Administrative Assistant | .5 FTE | Annual Salary $41,000 | $20,500 | $20,500 | |
| EMPLOYEE RELATED EXPENSES | Employee Related Expenses Sub Total | $77,841 | |||
| Fringe Benefits or Other ERE | |||||
| Fringe Benefits or Other ERE | 27% | Social Security and Medicare Tax (7.65 % of total salaries) Unemployment Insurance (2.32% of total salaries) Worker's Comp Insurance (1.03% of total salaries) Health Insurance (16% of total salaries) | $77,841 | $77,841 | |
| PROFESSIONAL & OUTSIDE SERVICES | Professional & Outside Services Bus Total | $0 | |||
| Professional & Outside Services | |||||
| $0 | $0 | ||||
| $0 | $0 | ||||
| $0 | $0 | ||||
| $0 | |||||
| TRAVEL | Travel sub total | $0 | |||
| Travel | |||||
| In-State Travel (Program Director) | 1.0 FTE | Monthly Auto Allowance of $200 x12 | $0 | $0 | |
| In-State Travel (Family Advocate) | 0 | Monthly Auto Allowance of $400 x 12 | $0 | $0 | |
| $0 | |||||
| Out of State Travel | $0 | ||||
| AID TO ORGANIZATIONS OR INDIVIDUALS | Aid to Organizations /Individuals Sub totals | $0 | |||
| Aid to Organizations or Individuals | |||||
| Subgrants or Subcontracts to organizations, agencies, entities | $0 | $0 | |||
| OTHER OPERATING EXPENSES | Other Operating Expenses Sub totals | $88,405 | |||
| Other Operating Expenses | |||||
| Telephones | 5 | x $40 per month x 12 months | $2,400 | $2,400 | |
| Software | 5 | Microsoft Office Suite | $275 | $275 | |
| General Office Supplies | 150 x 12 months (pens, paper, file folders, etc.) | $1,500 | $1,500 | ||
| Food | 2 Community Information Fairs per month 5000 per session | $0 | $0 | ||
| Occupancy | $583.33 x 12months for office space and cleaning | $7,000 | $7,000 | ||
| Dues/Subscriptions | Zoom Pro subscription @ 149.90 per year; Charity Tracker Pro $60 x 5(users) x 12 months | $3,750 | $3,750 | ||
| Postage | $50 per month x 12 | $600 | $600 | ||
| Printing/ Copying | Flyers, brochures and marketing materials $250 x 12 mos. | $0 | $0 | ||
| Professional Development Staff Training | 5 | Mandated Report/Supporter +Trauma Informed Care (TIPP) (2)+ ACES Training (3) + Neurosequential Model for Caregivers (11) + Protective Factors (3) + De-escalation Training (2) = 21 sessions x $2000 per sesssion + $3000 for materials; Prevent Child Abuse AZ Annual Summit for 8 pp x 400 | $0 | $0 | |
| Direct Services | Human Services assistance including food vouchers, rent payments and utility payments estimated at $16,416.67 per month x 12 months | $59,680 | $59,680 | ||
| Soft Costs | Infrastructure development of new Community Hub to expand services and delivery | $0 | $0 | ||
| Program Incentives | Community training attendees (of NPP and Triple P) 1 x $100 per session (8) x 12 months | $9,600 | $9,600 | ||
| Insurance | General liability for $300 x 12 months | $3,600 | $3,600 | ||
| CAPITAL EQUIPMENT | Capital Equipment Sub Total | $0 | |||
| Capital Equipment Expenses | |||||
| Equipment $5,000 or greater | $0 | $0 | |||
| NON-CAPITAL EQUIPMENT | Non-Capital Equipment Sub Total | $0 | |||
| Non-Capital Equipment Expenses | |||||
| Equipment $4,999 or less | $0 | $0 | |||
| Subtotal Direct Program Costs | $454,546 | ||||
| ADMINISTRATIVE/INDIRECT COSTS | Total Admin/Indirect | $45,455 | |||
| Indirect/Admin Costs | 10% Indirect Cost Rate | $45,455 | $45,455 | ||
| Total | $500,000 | $500,000 |
Community Hub
| Budget Category | Line Item Description | Requested Funds | Total Cost | ||
| PERSONNEL SERVICES | Personnel Services Sub Total | $350,100 | |||
| Salaries | |||||
| Program Director | 1.0 FTE | Annual Salary $82,400 | $82,400 | $82,400 | |
| Family Advocate | 1.0 FTE | Annual Salary $61,800 | $61,800 | $61,800 | |
| Family Advocate | 1.0 FTE | Annual Salary $61,800 | $61,800 | $61,800 | |
| Family Advocate | 1.0 FTE | Annual Salary $61,800 | $61,800 | $61,800 | |
| Family Advocate | 1.0 FTE | Annual Salary $61,800 | $61,800 | $61,800 |
| Administrative Assistant | .5 FTE | Annual Salary $41,000 | $20,500 | $20,500 | |
| EMPLOYEE RELATED EXPENSES | Employee Related Expenses Sub Total | $94,527 | |||
| Fringe Benefits or Other ERE | |||||
| Fringe Benefits or Other ERE | 27% | Social Security and Medicare Tax (7.65 % of total salaries) Unemployment Insurance (2.32% of total salaries) Worker's Comp Insurance (1.03% of total salaries) Health Insurance (16% of total salaries) | $94,527 | $94,527 | |
| PROFESSIONAL & OUTSIDE SERVICES | Professional & Outside Services Bus Total | $0 | |||
| Professional & Outside Services | |||||
| $0 | $0 | ||||
| $0 | $0 | ||||
| $0 | $0 | ||||
| $0 | |||||
| TRAVEL | Travel sub total | $0 | |||
| Travel | |||||
| In-State Travel (Program Director) | 1.0 FTE | Monthly Auto Allowance of $200 x12 | $0 | $0 | |
| In-State Travel (Family Advocate) | 0 | Monthly Auto Allowance of $400 x 12 | $0 | $0 | |
| $0 | |||||
| Out of State Travel | $0 | ||||
| AID TO ORGANIZATIONS OR INDIVIDUALS | Aid to Organizations /Individuals Sub totals | $0 | |||
| Aid to Organizations or Individuals | |||||
| Subgrants or Subcontracts to organizations, agencies, entities | $0 | $0 | |||
| OTHER OPERATING EXPENSES | Other Operating Expenses Sub totals | $246,125 | |||
| Other Operating Expenses | |||||
| Telephones | 5 | x $40 per month x 12 months | $2,400 | $2,400 | |
| Software | 5 | Microsoft Office Suite | $275 | $275 | |
| General Office Supplies | 175 x 12 months (pens, paper, file folders, etc.) | $2,100 | $2,100 | ||
| Food | 2 Community Information Fairs per month 5000 per session | $10,000 | $10,000 | ||
| Occupancy | $600 x 12months for office space and cleaning | $7,200 | $7,200 | ||
| Dues/Subscriptions | Zoom Pro subscription @ 149.90 per year; Charity Tracker Pro $60 x 5(users) x 12 months | $3,750 | $3,750 | ||
| Postage | $50 per month x 12 | $600 | $600 | ||
| Printing/ Copying | Flyers, brochures and marketing materials $250 x 12 mos. | $0 | $0 | ||
| Professional Development Staff Training | 5 | Mandated Report/Supporter +Trauma Informed Care (TIPP) (2)+ ACES Training (3) + Neurosequential Model for Caregivers (11) + Protective Factors (3) + De-escalation Training (2) = 21 sessions x $2000 per sesssion + $3000 for materials; Prevent Child Abuse AZ Annual Summit for 8 pp x 400 | $0 | $0 | |
| Direct Services | Human Services assistance including food vouchers, rent payments and utility payments estimated at $16,416.67 per month x 12 months | $197,000 | $197,000 | ||
| Soft Costs | Infrastructure development of new Community Hub to expand services and delivery | $0 | $0 | ||
| Program Incentives | Community training attendees (of NPP and Triple P) 2 x $100 per session (8) x 12 months | $19,200 | $19,200 | ||
| Insurance | General liability for $300 x 12 months | $3,600 | $3,600 | ||
| CAPITAL EQUIPMENT | Capital Equipment Sub Total | $0 | |||
| Capital Equipment Expenses | |||||
| Equipment $5,000 or greater | $0 | $0 | |||
| NON-CAPITAL EQUIPMENT | Non-Capital Equipment Sub Total | $0 | |||
| Non-Capital Equipment Expenses | |||||
| Equipment $4,999 or less | $0 | $0 | |||
| Subtotal Direct Program Costs | $690,752 | ||||
| ADMINISTRATIVE/INDIRECT COSTS | Total Admin/Indirect | $69,075 | |||
| Indirect/Admin Costs | 10% Indirect Cost Rate | $69,075 | $69,075 | ||
| Total | $759,827 | $759,827 |
File details come from the government source that posted it. Updated .