J1 Pricing_CNA.xlsx

XLSX spreadsheet 24 KB Posted Aug 10, 2021

Attached to: Capital Needs Assessment of Public Housing
Solicitation number: 86614821R00012
Issued by: Department of Housing and Urban Development

View the file

Other files

File	Type	Posted
Capital Needs Assessment Solicitation 86614821R00012 Amend 1.pdf	PDF	Aug 10, 2021
Capital Needs Assessment Solicitation 86614821R00012 Amend 2.pdf	PDF	Aug 10, 2021
J2 Labor Hours_CNA.xlsx	XLSX spreadsheet	Aug 10, 2021
Questions for Sol. No. 86614821R00012.docx	DOCX document	Aug 10, 2021
J5 Nondisclosure-Agreement-HUD-and-External-Party.docx	DOCX document	Jul 27, 2021
J4 Past Performance Survey.docx	DOCX document	Jul 27, 2021
J3 Past Performance Chart.docx	DOCX document	Jul 27, 2021
J1 Pricing_CNA.xlsx	XLSX spreadsheet	Jul 27, 2021
J6 Non Disclosure Offeror.docx	DOCX document	Jul 27, 2021
Capital Needs Assessment Solicitation 86614821R00012.pdf	PDF	Jul 27, 2021
J2 Labor Hours_CNA.xlsx	XLSX spreadsheet	Jul 27, 2021

Show all 11

On GovTribe

Work with this file

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

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Pricing

J.1 Pricing: Capital Needs Assessment

II. LABOR COSTS BY TASK

Task 1

Task 2

Task 3

Task 4

Task 5

Task 6

Task 7

Task 8

Task 9

TOTAL HOURS

% Total Labor Hours

Orientation Meeting

Monthly Report and Communication

Final Management & Work Plan

Research Design, Data Collection Instruments & Analysis Plan

OMB Clearance Package

Preliminary Analysis/Implementation

Interim Report

Final Analysis

Final Report and Briefing

Data File and Documentation

Senior Principal Associate/Scientist

ERROR:#DIV/0!

Senior Associate

ERROR:#DIV/0!

Senior Research Associate/Project Manager

ERROR:#DIV/0!

Senior Analyst

ERROR:#DIV/0!

Senior Programmer Analyst

ERROR:#DIV/0!

Programmer/Analyst

ERROR:#DIV/0!

Research Associate/Analyst

ERROR:#DIV/0!

Administrative Staff

ERROR:#DIV/0!

Total Hours

ERROR:#DIV/0!

% of Total Project Hours

ERROR:#DIV/0!

III. LABOR COSTS PER TASK											TOTAL COST	% Total Cost
Senior Principal Associate/Scientist	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	ERROR:#DIV/0!
Senior Associate	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	ERROR:#DIV/0!
Senior Research Associate/Project Manager	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	ERROR:#DIV/0!
Senior Analyst	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	ERROR:#DIV/0!
Senior Programmer Analyst	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	ERROR:#DIV/0!
Programmer/Analyst	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	ERROR:#DIV/0!
Research Associate/Analyst	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	ERROR:#DIV/0!
Administrative Staff	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	ERROR:#DIV/0!
A. Total Labor Costs	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	ERROR:#DIV/0!

IV. OTHER DIRECT COSTS (ODC)											TOTAL COST
Air Travel (per RT)											$ - 0
Ground Transport (each way)											$ - 0
Lodging Per Diem (per night)											$ - 0
Per Diem (per day)											$ - 0
Car Rental (per day)											$ - 0
B. Travel Subtotal	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Expert panel honorarium											$ - 0
Survey incentive - resident											$ - 0
											$ - 0
											$ - 0
C. Subtotal ODCs	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

V. TOTAL ESTIMATED COSTS $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Template Guidance Guidance for Using the Template Using Loaded Labor Rates

II. LABOR COSTS BY TASK

The shaded area of section II is where you will input both your tasks and your estimated number of labor hours by labor category under each task.

If you have more than 10 tasks, simply insert an additional column after task 10.

In the "CLIN Type" row, under the task title row, indicate how the CLIN is structured (firm fixed price or cost reimbursement).

The total and percentage cells will be automatically calculated.

III. LABOR COSTS PER TASK

This section will be automatically calculated based on the estimated labor hours input into section II.

A. Total Labor Costs- totals the labor costs.

IV. OTHER DIRECT COSTS (ODC)

Other Direct Costs (ODCs)include resources (albor and/or materials) purchased particularly for the contract or project. At the end of the contract, no resources will remain.

ODCs for a particular project should include only costs that are being incurred because of the work of the project.

ODCs can include leasing, subcontractors, consultants, photocopying, computing services, and similar costs.

The contractor should have a system for relating the expenditures to particular contracts.

Other Direct Costs are not subject to G&A expense or fee; instead these costs are additive, and reimbursed as allowable.

G&A should not be charged on subcontractors or consultants, but some firms still try to do so. Firms may change a "subcontractor handling fee" under ODC.

Travel costs should be included as an ODC; averages for travel are provided in column B, but these can be customized based on the type of travel expected for your project.

If you know the travel locations, use current per diem rates found here: http://www.gsa.gov/portal/category/21287.

B. Travel Subtotal- Additive of all travel costs per task.

Subcontractors and Consultants are included as ODCs. The amount under these lines should be considered an all-inclusive price.

Costs included under ODCs are additive, meaning you do not apply overhead, G&A, fee, etc. to these costs. Rather that price is simply passed along to the government.

The rows laboed "OTHER1, etc." can be customized to your project needs. Examples you might add in this line might be incentive fees or special software or licensing costs specific to the project.

C. Subtotal ODC- Additive of travel costs and all other ODCs.

V. TOTAL ESTIMATED COSTS

Additive total costs = sum of labor subtotal plus subtotal of ODCs.

Labor Categories

These labor classes are used in the Capital Needs Assessment.
Labor Class	Definition
Senior Principal Associate/Scientist	Incumbent may have one of a variety of titles including President, Vice President, Managing Director, or Principal Investigator. Strategic leader directing contract efforts and managing client relationships. Education and experience result in status as an industry expert. Serve as the senior client contact. Broadly oversee the planning, design and implementation of project protocols and procedures through strategy development, problem solving and oversight. Contributes through direct involvement or collaboration with project staff the efforts to translate client project requirements needs and/or objectives into specific deliverables in a timely and cost-efficient manner. Responsible for providing input and review on the technical approach on challenging or unique projects. Demonstrated capability to present and speak at client and professional meetings.
Senior Associate	Incumbent may have one of many position titles which might include Vice President, Director, Program Manager or similar titles. Senior leader responsible for the management of multiple projects for one or more clients. Responsible for the direction and management of the key planning, design and implementation of project protocols and procedures. Serves as the primary client contact and translates client needs and objectives into specific deliverables in a timely and cost-efficient manner. Ensure that all research projects are conducted with sound and well documented methods, protocols and techniques. Demonstrated capability to present and speak at client and professional meetings.
Senior Research Associate/Project Manager	Incumbent may have one of many position titles which might include Manager, Project Director or similar titles. Leads and coordinates complex components of large projects or series of smaller projects with responsibility for the application of research methods and techniques appropriate to the particular project. Lead and manage technical and support staff to provide technical, procedural and programmatic guidance to ensure a consistent, rigorous and quality product. Serves as the ongoing client contact for project work and ensures project guidance and client input are reflected in the project deliverables. Provides briefings on project status and technical issues upon request.
Senior Analyst	Incumbent may have one of many position titles which might include Senior Engineer, Architect, Planner, Analyst, or Researcher. Lead project teams and perform a variety of research tasks including design, collection, analysis and report writing. May independently visit field or remote sites for information collection. Review collected data and analyses using standard practices and techniques in the field(s) of specialization. Devise methods and lead the design computer modeling, stimulation or simple to moderately complex forecasting using standard software packages. Apply quantitative and/or qualitative analysis techniques and methods. Independently, work on assignments that are complex under indirect supervision with latitude for independent action and decision-making. May provide training and technical supervision to less experienced staff.
Senior Programmer Analyst	Provides management leadership and technical support to programming staff. Works independently, under general supervision. Manages data processing tasks and staff, budgets and conducts client briefings. Works independently to design solutions to analytic or data management problems, select the most appropriate and efficient programming tool and system platform. Demonstrated ability to solve difficult technical problems and to provide technical support to other programmers.
Programmer/Analyst	Provide programming and technical support to research and survey projects. Develop moderately complex programs that enable the control, manipulation and analysis of data.
Research Associate/Analyst	Incumbent may have one of many position titles which might include Engineer, Architect, Planner or Researcher or similar titles. Assists experienced professionals in a variety of research and analysis tasks by independently collecting, compiling, checking and analyzing data using standard practices and techniques in the field(s) of specialization. Serve on project teams and perform a variety of research tasks including design, collection, analysis and report writing. May visit field or remote sites for information collection. Review collected data and analyses using standard practices and techniques in the field(s) of specialization. Design computer modeling, stimulation for simple to moderately complex forecasting using standard software packages. Apply quantitative and/or qualitative analysis techniques and methods. May provide training to others in areas of expertise. Writes portions of project reports in an accurate, clear and understandable manner.
Administrative Staff	Assists other project staff in a variety of research and analysis tasks by collecting, compiling and checking data using standard practices and techniques. Under close supervision, may perform computer modeling, simulation or simple forecasting using standard software packages. Performs data input and logistical support for project teams. Might work with subcontractors or service bureaus to coordinate the physical production or media or other project materials. Manages contract subcontract budgets and maintains records on project costs and status.

File details come from the government source that posted it. Updated Aug 10, 2021.