3-Production Schedule Example.xlsx
XLSX spreadsheet 40 KB Posted
- Attached to
- Partner Participation in Lead Safe Units Rebid State and local contract opportunity
- Solicitation number
- PPLSUR/25 -
- Issued by
- Summit County, Akron City, Ohio
About this file
The file is a comprehensive project production schedule and budget worksheet for the Akron Lead Hazard Reduction Grant Consortium, involving Nazareth Housing Development Corp. as a sub-grantee for the Lead Safe Akron program. The project aims to complete lead hazard reduction work on 85 total units (79 inside city limits and 6 outside city limits) between January 2, 2020, and June 30, 2023, with a planned performance schedule that progressively increases unit completions across quarterly milestones. The contract opportunity involves partner participation in lead safe units, with a contract term extending to March 15, 2029, and allows for a 30-day cancellation notice by the City of Akron.
The total budget for the project is $1,500,000, with $1,105,000 coming from HUD share and $395,000 as applicant match. The budget includes detailed line items for activities such as local travel, application intake, specification writing, bidding, construction oversight, relocation, and targeted advertising. The project has specific quarterly drawdown milestones, with planned incremental fund releases tied to unit completion rates. The proposal includes a scoring mechanism with 104 possible points across categories like organizational capacity, financial profile, responsiveness, project schedule, deliverables, and use of minority and women-owned businesses. Notably, the proposal lost one point for not including Section 3 contractors.
View the file
Other files for this state and local contract opportunity
| File | Type | Posted |
|---|---|---|
| 2-SSA - Form Agreement Example.pdf | ||
| 4-Supplier Submission Page-PPLSUR25.pdf | ||
| 6-RFP - PPLSUR.25.pdf | ||
| 5-SOW - Partner Participation in Lead Safe Units Rebid.pdf | ||
| 1-EEO Form.pdf |
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Proposal RFP Proposal for Lead Safe Akron Production Schedule
Agency Name:
Date Submitted:
| City | Front-End | Back-End | Total # | Total Amounts for LSA Units by Source | ||||||
| Month | # Units | LSA Amount | CDBG Amount | P/D | P/D | Units | Grand | |||
| LSA Lead | LSA P/D | LSA CDBG | Total | |||||||
| Mar-25 | $ | $ | $ | $ | $ | $ | $ | $ | ||
| 03/10/2025 | Janurary - March Quarterly Report | $ | $ | # | $ | $ | $ | |||
| Apr-25 | $ | $ | $ | $ | $ | $ | $ | $ | ||
| May-25 | $ | $ | $ | $ | $ | $ | $ | $ | ||
| Jun-25 | $ | $ | $ | $ | $ | $ | $ | $ | ||
| 07/10/25 | April - June Quarterly Report | # | $ | |||||||
| Jul-25 | $ | $ | $ | $ | $ | $ | $ | $ | ||
| Aug-25 | $ | $ | $ | $ | $ | $ | $ | $ | ||
| Sep-25 | $ | $ | $ | $ | $ | $ | $ | $ | ||
| 08/10/25 | July - September Quarterly Report | # | $ | |||||||
| Oct-25 | $ | $ | $ | $ | $ | $ | $ | $ | ||
| Nov-25 | $ | $ | $ | $ | $ | $ | $ | $ | ||
| Dec-25 | $ | $ | $ | $ | $ | $ | $ | $ | ||
| 01/10/26 | October - December Quarterly Report | $ | # | $ | $ | $ | $ |
| City | Front-End | Back-End | Total # | Total Amounts for LSA Units by Source | ||||||
| Month | # Units | LSA Amount | CDBG Amount | P/D | P/D | Units | Grand | |||
| LSA Lead | LSA P/D | LSA CDBG | Total | |||||||
| Jan-26 | $ | $ | $ | $ | $ | $ | $ | $ | ||
| Feb-26 | $ | $ | $ | $ | $ | $ | $ | $ | ||
| Mar-26 | $ | $ | $ | $ | $ | $ | $ | |||
| 04/10/26 | January - March Quarterly Report | $ | # | $ - 0 | $ | |||||
| Apr-26 | $ | $ | $ | $ | $ | $ | $ | $ | ||
| May-26 | $ | $ | $ | $ | $ | $ | $ | $ | ||
| Jun-26 | $ | $ | $ | $ | $ | $ | $ | $ | ||
| 07/10/26 | April - June Quarterly Report | $ | # | $ | $ - 0 | $ - 0 | $ | |||
| Jul-26 | $ | $ | $ | $ | $ | $ | $ | $ | ||
| Aug-26 | $ | $ | $ | $ | $ | $ | $ | $ | ||
| Sep-26 | $ | $ | $ | $ | $ | $ | $ | $ | ||
| 10/10/26 | July - September Quarterly Report | # | $ | $ | $ - 0 | $ | ||||
| Oct-26 | $ | $ | $ | $ | $ | $ | $ | $ | ||
| Nov-26 | $ | $ | $ | $ | $ | $ | $ | $ | ||
| Dec-26 | $ | $ | $ | $ | $ | $ | $ | $ | ||
| 01/10/27 | October - December Quarterly Report | $ | # | $ | $ | $ | $ |
| City | Front-End | Back-End | Total # | Total Amounts for LSA Units by Source | ||||||
| Month | # Units | LSA Amount | CDBG Amount | P/D | P/D | Units | Grand | |||
| LSA Lead | LSA P/D | LSA CDBG | Total | |||||||
| 26-Jan | $ | $ | $ | $ | $ | $ | $ | $ | ||
| 26-Feb | $ | $ | $ | $ | $ | $ | $ | $ | ||
| 26-Mar | $ | $ | $ | $ | $ | $ | $ | |||
| 4/10/26 | January - March Quarterly Report | $ | # | $ - | $ | |||||
| 26-Apr | $ | $ | $ | $ | $ | $ | $ | $ | ||
| 26-May | $ | $ | $ | $ | $ | $ | $ | $ | ||
| 26-Jun | $ | $ | $ | $ | $ | $ | $ | $ | ||
| 7/10/26 | April - June Quarterly Report | $ | # | $ | $ - | $ - | $ | |||
| 26-Jul | $ | $ | $ | $ | $ | $ | $ | $ | ||
| 26-Aug | $ | $ | $ | $ | $ | $ | $ | $ | ||
| 26-Sep | $ | $ | $ | $ | $ | $ | $ | $ | ||
| 10/10/26 | July - September Quarterly Report | # | $ | $ | $ - | $ | ||||
| 26-Oct | $ | $ | $ | $ | $ | $ | $ | $ | ||
| 26-Nov | $ | $ | $ | $ | $ | $ | $ | $ | ||
| 26-Dec | $ | $ | $ | $ | $ | $ | $ | $ | ||
| City | Front-End | Back-End | Total # | Total Amounts for LSA Units by Source | ||||||
| Month | # Units | LSA Amount | CDBG Amount | P/D | P/D | Units | Grand | |||
| LSA Lead | LSA P/D | LSA CDBG | Total | |||||||
| Jan-28 | $ | $ | $ | $ | $ | $ | $ | $ | ||
| Feb-28 | $ | $ | $ | $ | $ | $ | $ | $ | ||
| Mar-28 | $ | $ | $ | $ | $ | $ | $ | $ | ||
| 04/10/28 | January - March Quarterly Report | $ | # | $ | $ | $ | $ | |||
| Apr-28 | $ | $ | $ | $ | $ | $ | $ | $ | ||
| May-28 | $ | $ | $ | $ | $ | $ | $ | $ | ||
| Jun-28 | $ | $ | $ | $ | $ | $ | $ | $ | ||
| 07/10/2028 | April - June Quarterly Report | $ | # | $ | $ | $ | $ | |||
| Jul-28 | $ | $ | $ | $ | $ | $ | $ | $ | ||
| Aug-28 | $ | $ | $ | $ | $ | $ | $ | $ | ||
| Sep-28 | $ | $ | $ | $ | $ | $ | $ | $ | ||
| 10/10/2028 | July -September Quarterly Report | $ | # | $ | $ | $ | $ | |||
| Oct-28 | $ | $ | $ | $ | $ | $ | $ | $ | ||
| Nov-28 | $ | $ | $ | $ | $ | $ | $ | $ | ||
| Dec-28 | $ | $ | $ | $ | $ | $ | $ | $ | ||
| 01/10/2029 | October- December Quarterly Report | $ | # | $ | $ | $ | $ | |||
| Jan-29 | $ | $ | $ | $ | $ | $ | $ | $ | ||
| Feb-29 | $ | $ | $ | $ | $ | $ | $ | $ | ||
| Mar-29 | $ | $ | $ | $ | $ | $ | $ | $ | ||
| 04/10/29 | January - March Quarterly Report | $ | $ | # | $ | $ | $ | $ |
CBW
OLHCHH Budget Worksheet Tool - Sub-Grantee #1
| Grant Agreement Number: OHLHD | Nazareth Housing Development Corp. | ||||||||||
| Name and Address of Applicant: | |||||||||||
| Nazareth Housing Development Corp. | |||||||||||
| 795 Russell Ave. | |||||||||||
| Akron, OH 44307 | |||||||||||
| Date Completed: 08/26/2020 | |||||||||||
| Category | Detailed Description of Budget (for full grant period) | ||||||||||
| 7. Contracts and Sub-Grantees (List individually) | Quantity | Unit Cost | Other | Admin | Direct | Estimated Cost | HUD Share Total | HUD Share Admin | HUD Share Direct | Total Match | Applicant Match |
| 7a. inside City limits | 79 | $15,000.00 | 100% | $1,185,000.00 | $790,000.00 | $0.00 | $790,000.00 | $395,000.00 | $395,000.00 | ||
| 7b. outside City limits | 6 | $10,000.00 | 100% | $60,000.00 | $60,000.00 | $0.00 | $60,000.00 | $0.00 | $0.00 | ||
| 7c. Partner Project Delivery/Unit: | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||
| 1.) Local Travel | 85 | $35.00 | 100% | $2,975.00 | $2,975.00 | $0.00 | $2,975.00 | $0.00 | |||
| 2.) Application Intake & Processing | 85 | $500.00 | 100% | $42,500.00 | $42,500.00 | $0.00 | $42,500.00 | $0.00 | |||
| 3.) Specification Writing | 85 | $300.00 | 100% | $25,500.00 | $25,500.00 | $0.00 | $25,500.00 | $0.00 | |||
| 4.) Bidding | 85 | $300.00 | 100% | $25,500.00 | $25,500.00 | $0.00 | $25,500.00 | $0.00 | |||
| 5.) Construction Oversight | 85 | $450.00 | 100% | $38,250.00 | $38,250.00 | $0.00 | $38,250.00 | $0.00 | |||
| 6.) Relocation | 85 | $500.00 | 100% | $42,500.00 | $42,500.00 | $0.00 | $42,500.00 | $0.00 | |||
| 7.) Targeted Advertising & Outreach | 85 | $415.00 | 100% | $35,275.00 | $35,275.00 | $0.00 | $35,275.00 | $0.00 | |||
| 8.) Preparation for Lead Review Committee & | 85 | $500.00 | 100% | $42,500.00 | $42,500.00 | $0.00 | $42,500.00 | $0.00 | |||
| Loan/Legal Document Prep | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||
| 7d. | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||
| 7e. | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||
| 7f. | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||
| 7g. | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||
| 7h. | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||
| 7i. | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||
| 7j. | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||
| 7k. | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||
| Total Subcontracts Cost | $1,500,000.00 | $1,105,000.00 | $0.00 | $1,105,000.00 | $395,000.00 | $395,000.00 | |||||
| Sub-Grantee Detailed Budget Worksheet | |||||||||||
| Detailed Description of Budget | |||||||||||
| Analysis of Total Sub-Grantee Estimated Costs | Percent of Total | Estimated Cost | HUD Share Total | HUD Share Admin | HUD Share Direct | Total Match | |||||
| 1. Personnel (Direct Labor) | 0% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| 2. Fringe Benefits | 0% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| 3. Travel | 0% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| 4. Equipment | 0% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| 5. Supplies and Materials | 0% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| 6. Consultants | 0% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| 7. Contract and Sub-Grantees | 100% | $1,500,000.00 | $1,105,000.00 | $0.00 | $1,105,000.00 | $395,000.00 | |||||
| 8. Construction | 0% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| 9. Other Direct Costs | 0% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| 10. Indirect Costs | 0% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| Total: | 100% | $1,500,000.00 | $1,105,000.00 | $0.00 | $1,105,000.00 | $395,000.00 | |||||
| Percentage of HUD Share Total: | 73.67% | 0.00% | 73.67% | 26.33% |
Benchmarks
| 04/16/25 |
| WORK PLAN DEVELOPMENT WORKSHEET WITH MINIMUM BENCHMARK PERFORMANCE STANDARDS |
| Sub-grantee: |
Period of Performance: January 2, 2020 - June 30, 2023
| Grantee Organization: Akron Lead Hazard Reduction Grant Consortium | |||||||||||||||||
| Grant Number: OHLHB0735-19 | |||||||||||||||||
| ACTIVITY | Q1 2020 | Q2 2020 | Q3 2020 | Q4 2020 | Q5 2021 | Q6 2021 | Q7 2021 | Q8 2021 | Q9 2022 | Q10 2022 | Q11 2022 | Q12 2022 | Q13 2023 | Q14 2023 | |||
| Enter Calendar Quarters here: | Jan-March | April-June | July-Sept. | Oct. - Dec | Jan-March | April-June | July-Sept. | Oct. - Dec | Jan-March | April-June | July-Sept. | Oct. - Dec | Jan-March | April - June | |||
| City Units Completed and Cleared: | |||||||||||||||||
| Performance Standard | % is | ||||||||||||||||
| adjustable | 0% | 0% | 3% | 9% | 15% | 28% | 42% | 48% | 54% | 67% | 80% | 87% | 95% | 92% | |||
| Work Plan Milestone | 79 | actual # | 0 | 0 | 2 | 5 | 5 | 10 | 11 | 5 | 5 | 10 | 10 | 6 | 6 | 4 | |
| Actual # Completed | 0 | ||||||||||||||||
| Actual % Completed | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | |
| County Units Completed and Cleared: | |||||||||||||||||
| Performance Standard | % is | ||||||||||||||||
| adjustable | 0% | 0% | 0% | 0% | 0% | 17% | 33% | 33% | 33% | 67% | 83% | 83% | 83% | 100% | |||
| Work Plan Milestone | 6 | actual # | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 2 | 1 | 0 | 0 | 1 | |
| Actual # Completed | 0 | ||||||||||||||||
| Actual % Completed | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | |
| Total Units Completed and Cleared: | |||||||||||||||||
| Performance Standard | % is | ||||||||||||||||
| adjustable | 0% | 0% | 3% | 9% | 15% | 29% | 44% | 50% | 56% | 71% | 85% | 93% | 100% | 99% | |||
| Work Plan Milestone | 80 | actual # | 0 | 0 | 2 | 5 | 5 | 11 | 12 | 5 | 5 | 12 | 11 | 6 | 6 | 5 | |
| Actual # Completed | 0 | ||||||||||||||||
| Actual % Completed | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | |
| LOCCS DRAWDOWNS Grant Award Amount = $ enter here | |||||||||||||||||
| Performance Standard | % is | ||||||||||||||||
| adjustable | 0.00% | 0.00% | 2.50% | 8.75% | 15.00% | 28.75% | 43.75% | 50.00% | 56.25% | 71.25% | 85.00% | 92.50% | 100% | 98.75% | |||
| LOCCS Drawdown Work Plan Milestone | $1,040,000 | actual # | $0 | $0 | $26,000 | $65,000 | $65,000 | $143,000 | $156,000 | $65,000 | $65,000 | $156,000 | $143,000 | $78,000 | $78,000 | $65,000 | |
| Actual LOCCS Drawdown | $0.00 | ||||||||||||||||
| Actual Cumulative LOCCS Drawdown % | 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% | 0.00% |
| Q1 2020 | Q2 2020 | Q3 2020 | Q4 2020 | Q5 2021 | Q6 2021 | Q7 2021 | Q8 2021 | Q9 2022 | Q10 2022 | Q11 2022 | Q12 2022 | Q13 2023 | Q14 2023 | |
| Jan-March | April-June | July-Sept. | Oct. - Dec | Jan-March | April-June | July-Sept. | Oct. - Dec | Jan-March | April-June | July-Sept. | Oct. - Dec | Jan-March | April - June | |
| completed & cleared | 0 | 0 | 2 | 5 | 5 | 11 | 12 | 5 | 5 | 12 | 11 | 6 | 6 | 5 |
| Budget | Count | |||||||||||||||
| jobs (2,500,000 /250=10,000) | $850,000.00 | $ 850,000.00 | $ - 0 | $ - 0 | $ 20,000.00 | $ 50,000.00 | $ 50,000.00 | $ 110,000.00 | $ 120,000.00 | $ 50,000.00 | $ 50,000.00 | $ 120,000.00 | $ 110,000.00 | $ 60,000.00 | $ 60,000.00 | $ 50,000.00 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Partner project delivery (3,000 x 85) | $ 255,000.00 | $ 255,000.00 | $ - 0 | $ - 0 | $ 6,000.00 | $ 15,000.00 | $ 15,000.00 | $ 33,000.00 | $ 36,000.00 | $ 15,000.00 | $ 15,000.00 | $ 36,000.00 | $ 33,000.00 | $ 18,000.00 | $ 18,000.00 | $ 15,000.00 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Total | $ 1,105,000.00 | $ - 0 | $ - 0 | $ 26,000.00 | $ 65,000.00 | $ 65,000.00 | $ 143,000.00 | $ 156,000.00 | $ 65,000.00 | $ 65,000.00 | $ 156,000.00 | $ 143,000.00 | $ 78,000.00 | $ 78,000.00 | $ 65,000.00 |
RFP Score
| Review of RFP for |
| NHDC Proposal for Lead Safe Akron |
| RFP Evaluation & Scoring Worksheeet |
| April 16, 2025 |
Number of Units Awarded
RFP Reference # RFP Criteria Available Points Present in Proposal Points Earned
| a | Organizational Capacity | 30 | √ | ||
| i | Program Oversight Experience | √ | 3 | ||
| ii | Writing Lead Specs | √ | 3 | ||
| iii | Site Monitoring Experience | √ | 3 | ||
| iv | Successful Accomplishments of Similar Projects | √ | 3 | ||
| v | Professional Training & Certifications | √ | 3 | ||
| vi | Current Similar Federal Programs | √ | 3 | ||
| vii | Management Staff Experience | √ | 3 | ||
| viii | Service Capabilities | √ | 3 | ||
| ix | Monitoring & Reporting Experience | √ | 3 | ||
| x | Staff Credentials | √ | 3 |
| b | Financial Profile of Organization | 15 | √ | 15 | |
| c | Responsiveness to RFP | 10 | √ | 10 | |
| d | Proposed Project Schedule | 10 | √ | 10 | |
| e | Deliverables | 10 | √ | 10 | |
| f | Use of Minority & Women Buisness Enterprises & Section 3 Contractors | ||||
| i | Minority Businesses | 2 | √ | 2 | |
| ii | Women-owend Buinesses | 2 | √ | 2 | |
| iii | Section 3 contractors | 1 | √ | 0 | |
| g | Project Marketing Plan | 10 | √ | 10 | |
| h | Project Cost Proposal (Budget) | 10 | √ | 10 | |
| i | Bonus | ||||
| i. | Additional Leverage Funds | 5 | √ | 5 | |
| 104 |
Reasons for Points Reduction:
f. iii. No Section 3 contactors
File details come from the government source that posted it. Updated .