Attachment 7 - Summary of Proposed Costs.xls

Instructions OMB Control No. 9000-0013

&A Page &P How to use this Excel file:

(Updated 1/3/2006) This file 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 many 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 sheets where applicable.

Summary Sheet Please insert the contractor's Name in cell B2.

The totals from each cost element sheet are automatically carried forward to the Summary sheet.

Labor Use the Labor sheet to show direct labor hours by labor category. The proposed amounts must be based on current and projected payroll information. Supporting documentation may be requested at a later date.

Indirect Costs and Fee or Profit Utilize the blank Indirect Costs and Fee or Profit sheets as needed. Include any additional breakdowns, as applicable, on the other blank sheets in this spreadsheet. Add additional lines or columns as needed to any existing spreadsheet. You may use the Indirect Costs sheet to explain fringe benefit rates.

Note Please provide a brief summary statement to explain any changes made to this model spreadsheet format.

Summary

&L&12ATTACHMENT 7

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 22.

Please insert the Company's name.

Labor

Page &P

Materials

&L&24&USUMMARY OF MATERIALS AND SUPPLIES

Page &P Please use current catalog or vendor quotes. Supporting documentation may be requested at a later date.

Travel

Page &P 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

&L&24&USUMMARY OF EQUIPMENT COSTS

Page &P 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

Page &P 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 letter of commitment which shows the base rate for each consultant. Supporting documentation may be requested at a later date.

Other Direct

&L&24&USUMMARY OF OTHER DIRECT COSTS

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

Patient Care

&L&24&USUMMARY OF PATIENT CARE COSTS

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

Subcontracts

Page &P 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.

Indirect Costs

&A Page &P

Profit

&A Page &P