ATTACHMENT 9 BREAKDOWN OF PROPOSED COSTS WITH EXCEL SPREADSHEET.xlsx

INSTRUCTIONS

OMB Control No. 9000-0013

How to use this Excel file:

(Updated 3/24/2003)

Important: Please save this file on your computer before attempting to insert data. Otherwise, you may be prompted for a user name and a password and you will lose all data which you have inserted.

This worksheet is intended to help you prepare your cost proposal. If you provide us with an electronic copy of the cost proposal, we can save time by not recreating it. This will help speed up the review/award process and perhaps reduce the number of questions we need to ask in order to understand your proposal. We understand that one spreadsheet format can not fit every situation; however, we have attempted to create a simple model that fits most circumstances that arise in Government contracting. Feel free to modify the spreadsheet to fit your circumstances, and to use the parts that work for you. There are more specific instructions on specific cost element pages where applicable.

Summary Page Please insert your organization's name in cell A2 and the RFP No. in cell A3.

The totals from each cost element page are automatically carried forward to the Summary worksheet. Enter the start date of the contract in cell C5.

This Excel file is set up for seven periods.

Direct Labor Use the Labor - Percent of Effort worksheet if you track labor on a percent of effort basis. Generally, Universities, Hospitals, and Non-Profit Organizations tract labor by percent of effort.

Use the Labor - Hourly worksheet if you track labor on an hourly basis. Commercial organizations track labor on an hourly basis.

Use both pages if you track some employees by each method. Please do not put any employee on both pages.

The proposed amounts must be based on current payroll information which shows hourly, monthly, or annual rate/salary for each proposed (named) individuals. Acceptable documentation includes any one of the following: 1) personnel action forms, or 2) most recent payroll register showing name, pay rate, and percent of effort if applicable, or 3) copy of pay stub. Supporting documentation may be requested at a later date.

If the proposed positions have not been filled or are to be named or hired, then acceptable documentation includes the following: 1) letter of intent to hire including salary rate and title, or 2) position descriptions and salary scales or organizational wage table showing salary range and a copy of hiring policy, or 3) a comparable employee's payroll document. Supporting documentation may be requested at a later date. Increases for the to be named or hired are not eligible for increases in the first period.

Indirect Rates Including Fringe Benefit Rate(s) for Commercial Organizations If your organization does not have negotiated rates, the following URL contains information which will assist you in computing indirect rates: http://oamp.od.nih.gov/dfas/idcsubmission.html. Please do not submit your indirect proposal to the Division of Financial Advisory Services at this time.

Points of Contact If you have any questions regarding this Excel file, please contact Cindi Brown (301-496-4494), Virgina De Seau (301-496-4611), Carl Henn (301-496-0993), or Leanne Robey (301-496-4494).

If you have contracting questions, please call the NIH Contracting Official who is listed in the RFP.

SUMMARY

* Overhead 0% $0 0% $0 0% $0 0% $0 0% $0 0% $0 0% $0 $0

Not all organizations allocate indirect cost in the same way. It is important that you use the indirect rate structure applicable to your organization. For example, if you have a three tier indirect rate structure, then you will use a three tier structure when proposing indirect costs.

Generally, Universities and Non-Profits have fringe benefit and G&A (or sometimes called F&A) rates, while For-Profit Companies can have various indirect rates such as fringe benefits, overhead, G&A, etc.

The base for overhead costs includes direct labor and fringe benefits. Please modify if your base is different.

If applicable, insert exclusions to the G&A base in row 26.

Please insert the Company's name and the RFP #.

Enter the contract start date in cell C5 and make adjustments for leap year.

LABOR - Percent of Effort

ANNUAL INCREASE FACTOR: 0.00%

ANNUAL INCREASE DATE: 00/00/00

NUMBER OF MONTHS AT NEXT ANNUAL INCREASE 0

*Adjust the number of months per period as recommended in the RFP.

THE FOLLOWING BOXES IN COLUMN "D" BELOW MAY BE USED TO CALCULATE THE ADJUSTED BASE SALARY, AS INDICATED:

(Use of these cells will affect all of the adjusted base salary column; if individual anniversary dates differ, the adjusted base salaries must be entered individually in Column "D" of the spreadsheet and explained in the budget justification) Insert annual CPI % and/or merit increases as applicable and explain the % in the budget justification.

Insert annual increase date.

Insert number of months using the new salary.

LABOR - Hourly

ANNUAL INCREASE DATE: 00/00/00

NUMBER OF MONTHS AT NEXT ANNUAL INCREASE 0

*Adjust the number of months per period as recommended in the RFP.

THE FOLLOWING BOXES IN COLUMN "D" BELOW MAY BE USED TO CALCULATE THE ADJUSTED BASE SALARY, AS INDICATED:

(Use of these cells will affect all of the adjusted base salary column; if individual anniversary dates differ, the adjusted base salaries must be entered individually in Column "D" of the spreadsheet and explained in the budget justification) Insert annual increase date.

Insert annual CPI % and/or merit increases as applicable and explain the % in the budget justification.

Insert number of months using the new salary.

Insert your direct work year.

Materials

&24&USUMMARY OF MATERIALS AND SUPPLIES

Please use current catalog, historical documentation, or vendor quotes. Supporting documentation may be requested at a later date.

Travel

Please review the RFP for the recommended number of trips and destinations if applicable. Please use the company or institutional travel policy unless current Government Per Diem rates are utilized. Please use current vendor quotes for airfare and other travel costs. Supporting documentation may be requested at a later date.

Equipment

&24&USUMMARY OF EQUIPMENT COSTS

All proposed equipment costs should include a justification and be based on current vendor quotes. Supporting documentation may be requested at a later date.

Consultants

Please provide a complete breakdown for each consultant with rates for the number hours or days plus any proposed travel costs (including travel rates). Please obtain a signed letter of commitment which shows the base rate for each consultant. Supporting doucmentation may be requested at a later date.

Other Direct

&24&USUMMARY OF OTHER DIRECT COSTS

Please use current catalog prices, or vendor quotes. Supporting documentation may be requested at a later date.

Patient Care

&24&USUMMARY OF PATIENT CARE COSTS

Please use current institutional costs or vendor quotes. Supporting documentation may be requested at a later date.

Subcontracts

A complete breakdown and summary sheet for each proposed subcontract must be included with the prime proposal. The same format should be used for both the prime and subcontract proposals.