Attachment 5 TEP workbook.xlsx

Instructions This workbook includes four (4) Total Evalauted Price (TEP) worksheets, one for each Homeownership Center (HOC): Atlanta (AHOC), (DHOC), (PHOC), and (SAHOC). Offerors are encouraged to submit multiple offers presenting offers for more than one of the Homeownership Centers (HOCs), if an offeror is capable of providing services within the entire geographic areas of that HOC. To be considered for award, an offeror must demonstrate they are capable of providing all of the services within the entire geographic area of the HOC for which they are proposing.

Step 1: Select HOC worksheet for which your firm intends on submitting an offer. The Proposal Letter referenced for that corresponding HOC will also be referenced with the title uised on the written proposal(s) and must be consistent with the submission of the email subject line requirements: FOUO\\INFO: Insert Solicitation Number, Company Name/Proposal and Name of HOC/Offer.

Step 2: In Column "E" provide the corresponding CLIN Firm-Fixed Prices (FFP). All FFP must be rounded to the nearest dollar. The Proposal Worksheets inlcude math to develop the TEP. No further action is needed on Proposal Worksheets.

Step 3: Provide pricing data in the "Supporting Math Data" and "Supporting Narrative" worksheets. If you need a conintuation worksheet for either one of those to supporting worksheets, you may create another worksheet. Further instructions are provided within each worksheet.

Proposal A "AHOC" Atlanta HOC (AHOC): Alabama, Florida, Georgia, Kentucky, Illinois, Indiana, Mississippi, North Carolina, South Carolina, and Tennessee, Puerto Rico, and the Virgin Islands

Proposal B "DHOC" Denver HOC (DHOC): Montana, North Dakota, South Dakota, Wyoming, Utah, Colorado, Nebraska, Kansas, New Mexico, Oklahoma, Texas, Minnesota, Wisconsin, Iowa, Missouri, Arkansas, Louisiana

Proposal C "PHOC" Philadelphia (PHOC): Michigan, Connecticut, New Hampshire, Vermont, Maine, Massachusetts, New York, Rhode Island, New Jersey, Ohio, District of Columbia, Delaware, Maryland, Pennsylvania, Virginia, and West Virginia

Proposal D "SAHOC" Santa Ana (SAHOC): Arizona, California, Hawaii, Nevada, Alaska, Idaho, Oregon, Washington, Guam, and Northern Mariana Islands

Supporting Narrative This worksheet will include all pricing pricing sources, facts, judgmental factors and assumptions to support an offeror's proposed pricing. For example, if the offeror proposes annual cost of living increases, the offeror must support the proposed increases with historical and relevant market index information. The pricing data and supporting information should be sufficient for an adequate evaluation and support the offeror’s Technical Capability. Submit benefits information not included in the Price Proposal written narrative IAW FAR 52.222-46 EVALAUTION OF COMENSATION FOR PROFESSIONAL EMPLOYEES. A written Business Proposal requires pricing narrative, such as the place where offerors must submit Corporate Filings and FAR 52.219-14 "Limitations on Subcontracting".

Supporting Math Data If the offeror proposes annual cost of living increases, the offeror must support the proposed increases and show application of the mathematical formula in the TEP workbook. Offerors shall continue to provide a mathematical break down of their total price to reflect labor categories, labor rates, number of hours, materials and any other costs that make up the bottom-line price and necessary to permit an adequate evaluation of the proposed price in accordance with 15.403-3. The pricing data and supporting information should be sufficient for an adequate evaluation and support the offeror’s Technical Capability. Submit minimum wage/salary and benefit information.