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

Other files attached to Partner Participation in Lead Safe Units Rebid, newest first.
File Type Posted
2-SSA - Form Agreement Example.pdf PDF
4-Supplier Submission Page-PPLSUR25.pdf PDF
6-RFP - PPLSUR.25.pdf PDF
5-SOW - Partner Participation in Lead Safe Units Rebid.pdf PDF
1-EEO Form.pdf 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:

CityFront-EndBack-EndTotal #Total Amounts for LSA Units by Source
Month# UnitsLSA AmountCDBG AmountP/DP/DUnitsGrand
LSA LeadLSA P/DLSA CDBGTotal
Mar-25$$$$$$$$
03/10/2025Janurary - March Quarterly Report$$#$$$
Apr-25$$$$$$$$
May-25$$$$$$$$
Jun-25$$$$$$$$
07/10/25April - June Quarterly Report#$
Jul-25$$$$$$$$
Aug-25$$$$$$$$
Sep-25$$$$$$$$
08/10/25July - September Quarterly Report#$
Oct-25$$$$$$$$
Nov-25$$$$$$$$
Dec-25$$$$$$$$
01/10/26October - December Quarterly Report$#$$$$
CityFront-EndBack-EndTotal #Total Amounts for LSA Units by Source
Month# UnitsLSA AmountCDBG AmountP/DP/DUnitsGrand
LSA LeadLSA P/DLSA CDBGTotal
Jan-26$$$$$$$$
Feb-26$$$$$$$$
Mar-26$$$$$$$
04/10/26January - March Quarterly Report$#$ - 0$
Apr-26$$$$$$$$
May-26$$$$$$$$
Jun-26$$$$$$$$
07/10/26April - June Quarterly Report$#$$ - 0$ - 0$
Jul-26$$$$$$$$
Aug-26$$$$$$$$
Sep-26$$$$$$$$
10/10/26July - September Quarterly Report#$$$ - 0$
Oct-26$$$$$$$$
Nov-26$$$$$$$$
Dec-26$$$$$$$$
01/10/27October - December Quarterly Report$#$$$$
CityFront-EndBack-EndTotal #Total Amounts for LSA Units by Source
Month# UnitsLSA AmountCDBG AmountP/DP/DUnitsGrand
LSA LeadLSA P/DLSA CDBGTotal
26-Jan$$$$$$$$
26-Feb$$$$$$$$
26-Mar$$$$$$$
4/10/26January - March Quarterly Report$#$ -$
26-Apr$$$$$$$$
26-May$$$$$$$$
26-Jun$$$$$$$$
7/10/26April - June Quarterly Report$#$$ -$ -$
26-Jul$$$$$$$$
26-Aug$$$$$$$$
26-Sep$$$$$$$$
10/10/26July - September Quarterly Report#$$$ -$
26-Oct$$$$$$$$
26-Nov$$$$$$$$
26-Dec$$$$$$$$
CityFront-EndBack-EndTotal #Total Amounts for LSA Units by Source
Month# UnitsLSA AmountCDBG AmountP/DP/DUnitsGrand
LSA LeadLSA P/DLSA CDBGTotal
Jan-28$$$$$$$$
Feb-28$$$$$$$$
Mar-28$$$$$$$$
04/10/28January - March Quarterly Report$#$$$$
Apr-28$$$$$$$$
May-28$$$$$$$$
Jun-28$$$$$$$$
07/10/2028April - June Quarterly Report$#$$$$
Jul-28$$$$$$$$
Aug-28$$$$$$$$
Sep-28$$$$$$$$
10/10/2028July -September Quarterly Report$#$$$$
Oct-28$$$$$$$$
Nov-28$$$$$$$$
Dec-28$$$$$$$$
01/10/2029October- December Quarterly Report$#$$$$
Jan-29$$$$$$$$
Feb-29$$$$$$$$
Mar-29$$$$$$$$
04/10/29January - March Quarterly Report$$#$$$$

CBW

OLHCHH Budget Worksheet Tool - Sub-Grantee #1

Grant Agreement Number: OHLHDNazareth Housing Development Corp.
Name and Address of Applicant:
Nazareth Housing Development Corp.
795 Russell Ave.
Akron, OH 44307
Date Completed: 08/26/2020
CategoryDetailed Description of Budget (for full grant period)
7. Contracts and Sub-Grantees (List individually)QuantityUnit CostOtherAdminDirectEstimated CostHUD Share TotalHUD Share AdminHUD Share DirectTotal MatchApplicant Match
7a. inside City limits79$15,000.00100%$1,185,000.00$790,000.00$0.00$790,000.00$395,000.00$395,000.00
7b. outside City limits6$10,000.00100%$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 Travel85$35.00100%$2,975.00$2,975.00$0.00$2,975.00$0.00
2.) Application Intake & Processing85$500.00100%$42,500.00$42,500.00$0.00$42,500.00$0.00
3.) Specification Writing85$300.00100%$25,500.00$25,500.00$0.00$25,500.00$0.00
4.) Bidding85$300.00100%$25,500.00$25,500.00$0.00$25,500.00$0.00
5.) Construction Oversight85$450.00100%$38,250.00$38,250.00$0.00$38,250.00$0.00
6.) Relocation85$500.00100%$42,500.00$42,500.00$0.00$42,500.00$0.00
7.) Targeted Advertising & Outreach85$415.00100%$35,275.00$35,275.00$0.00$35,275.00$0.00
8.) Preparation for Lead Review Committee &85$500.00100%$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 CostsPercent of TotalEstimated CostHUD Share TotalHUD Share AdminHUD Share DirectTotal Match
1. Personnel (Direct Labor)0%$0.00$0.00$0.00$0.00$0.00
2. Fringe Benefits0%$0.00$0.00$0.00$0.00$0.00
3. Travel0%$0.00$0.00$0.00$0.00$0.00
4. Equipment0%$0.00$0.00$0.00$0.00$0.00
5. Supplies and Materials0%$0.00$0.00$0.00$0.00$0.00
6. Consultants0%$0.00$0.00$0.00$0.00$0.00
7. Contract and Sub-Grantees100%$1,500,000.00$1,105,000.00$0.00$1,105,000.00$395,000.00
8. Construction0%$0.00$0.00$0.00$0.00$0.00
9. Other Direct Costs0%$0.00$0.00$0.00$0.00$0.00
10. Indirect Costs0%$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
ACTIVITYQ1 2020Q2 2020Q3 2020Q4 2020Q5 2021Q6 2021Q7 2021Q8 2021Q9 2022Q10 2022Q11 2022Q12 2022Q13 2023Q14 2023
Enter Calendar Quarters here:Jan-MarchApril-JuneJuly-Sept.Oct. - DecJan-MarchApril-JuneJuly-Sept.Oct. - DecJan-MarchApril-JuneJuly-Sept.Oct. - DecJan-MarchApril - June
City Units Completed and Cleared:
Performance Standard% is
adjustable0%0%3%9%15%28%42%48%54%67%80%87%95%92%
Work Plan Milestone79actual #002551011551010664
Actual # Completed0
Actual % Completed0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%
County Units Completed and Cleared:
Performance Standard% is
adjustable0%0%0%0%0%17%33%33%33%67%83%83%83%100%
Work Plan Milestone6actual #00000110021001
Actual # Completed0
Actual % Completed0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%
Total Units Completed and Cleared:
Performance Standard% is
adjustable0%0%3%9%15%29%44%50%56%71%85%93%100%99%
Work Plan Milestone80actual #002551112551211665
Actual # Completed0
Actual % Completed0%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
adjustable0.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,000actual #$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 2020Q2 2020Q3 2020Q4 2020Q5 2021Q6 2021Q7 2021Q8 2021Q9 2022Q10 2022Q11 2022Q12 2022Q13 2023Q14 2023
Jan-MarchApril-JuneJuly-Sept.Oct. - DecJan-MarchApril-JuneJuly-Sept.Oct. - DecJan-MarchApril-JuneJuly-Sept.Oct. - DecJan-MarchApril - June
completed & cleared002551112551211665
BudgetCount
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

aOrganizational Capacity30√
iProgram Oversight Experience√3
iiWriting Lead Specs√3
iiiSite Monitoring Experience√3
ivSuccessful Accomplishments of Similar Projects√3
vProfessional Training & Certifications√3
viCurrent Similar Federal Programs√3
viiManagement Staff Experience√3
viiiService Capabilities√3
ixMonitoring & Reporting Experience√3
xStaff Credentials√3
bFinancial Profile of Organization15√15
cResponsiveness to RFP10√10
dProposed Project Schedule10√10
eDeliverables10√10
fUse of Minority & Women Buisness Enterprises & Section 3 Contractors
iMinority Businesses2√2
iiWomen-owend Buinesses2√2
iiiSection 3 contractors1√0
gProject Marketing Plan10√10
hProject Cost Proposal (Budget)10√10
iBonus
i.Additional Leverage Funds5√5
104

Reasons for Points Reduction:

f. iii. No Section 3 contactors

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