BAA_Attachment_4.xls
XLS spreadsheet 101 KB Posted
- Attached to
- BROAD AGENCY ANNOUNCEMENT (ATTRI)
- Solicitation number
- DTFH6116R00022
About this file
Attachment 4 - Sample Pricing Template
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Instructions_for_Submission_of_Proposals _Amendment_3.pdf | ||
| Instructions_for_Submission_of_Proposals _Amendment_2.pdf | ||
| BAA_DTFH6116R00022_Questions_Answers.pdf | ||
| BAA_DTFH6116R00022 _Amendment_1.pdf | ||
| Instructions_for_Submission_of_Proposals _Amendment_1.pdf | ||
| BAA_Attachment_8.docx | DOCX document | |
| BAA_Attachment_6.docx | DOCX document | |
| BAA_Attachment_2.docx | DOCX document | |
| BAA_Attachment_7.docx | DOCX document | |
| Instructions_for_Submission_of_Proposals.pdf | ||
| BAA_DTFH6116R00022.pdf | ||
| BAA_Attachment_3.docx | DOCX document | |
| BAA_Attachment_1.docx | DOCX document | |
| BAA_Attachment_8.docx | DOCX document | |
| BAA_Attachment_5.pdf | ||
| BAA_Attachment_-_Three_Phase_Development_Sample.docx | DOCX document |
Show all 16
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Instructions
| Sample Pricing Template | |
| Overview | |
| This worksheet is very simple to use and makes a Cost Estimate very simple to do | |
| once you have gathered the necessary data. Basically what you will do is work from the back of the form (the | |
| details) and the front page of the form (the summary) will be practically created for you! | |
| First, you will need to go to the "Hours & Tasks" worksheet. In this worksheet, you should first define the | |
| tasks that need to be accomplished by filling out the information under the "Task Titles and Assumptions | |
| Used" portion. Once this is complete, enter the estimated number of hours that will be required on each task | |
| by personnel at each level. The higher the person is on the list, the more they cost per hour. | |
| While you are on this page, You should enter the title for this cost estimate. The title that you enter on this | |
| page will appear on all three pages of this cost estimate. | |
| Next, go to the "Travel, ADP, Wages, Direct Cost" worksheet. Fill out all of the appropriate areas in this | |
| worksheet that contains the detail level for travel, ADP services, subcontracts, direct wages and salaries, | |
| and other direct costs. The totals of each of these categories will be reflected on the summary page. | |
| Finally, go to the "Summary" worksheet. By this time, this worksheet is almost entirely filled in! There are | |
| only a couple of items that you should verify/edit. In section A, if there are any costs for line items 1 and/or 2, | |
| you should enter these costs here. Also, verify that the percentage entered for line item 7 is appropriate for | |
| this estimate. Next, in section B, there are three different types of organizations that are listed and their | |
| associated overhead costs. You should delete the information for the two organization types that do not apply | |
| to this estimate so the figures associated with them will not be included in your final estimate. You should | |
| edit the percentages here and in the next two sections if necessary. | |
| That's all there is to it! | |
| Tips for Using this Automated Workbook | |
| 1. All cells in the workbook that you can edit are blue so they are easy to spot on the screen. | |
| 2. Any cell that is red is a cell that will be carried from the current worksheet onto the next worksheet in the | |
| cost estimate. For example, a red cell in the "Hours & Tasks" worksheet, will be carried onto the "Travel, | |
| ADP, Wages, Direct Cost" worksheet. | |
| 3. Any cell that is green is a cell that has been brought forward from the previous worksheet. | |
| 4. It is recommended that the calculation for your spreadsheet application is set to "Automatic" so the | |
| worksheet will automatically update itself as soon as you enter your figures. If it is set to "Manual", you will | |
| need to tell the worksheet to recalculate the formulas each time you make a change. | |
| 5. This worksheet has been created to be generic enough so it should require no editing other than the blue | |
| cells. If, however, you need to edit the worksheet to fulfill your specific needs, feel free to do so as the format | |
| of this worksheet is in the public domain. There has been protection set in this worksheet, however, to protect | |
| the cells that should not be edited in the current format from being edited. You will need to "unprotect" each | |
| worksheet in this file to edit it and you will need to "unprotect" the workbook if you want to change the | |
| structure of the workbook. You will need to refer to the online help or documentation for your spreadsheet | |
| software to find out how to do this. If prompted for a password, just hit OK. No passwords were set. | |
| 6. You can use the print option from the file menu of your spreadsheet package to print this workbook as you | |
| would any other spreadsheet. |
Hours & Tasks
| Sample Pricing Template -- Page 3 | |||||||||||||
| Replace this text with the first line of the title of this estimate. This will appear on all pages. | |||||||||||||
| Replace this text with the second line of the title of this estimate. This will appear on all pages. | |||||||||||||
| ATTACHMENT to A.6; Direct Salaries and Wages | |||||||||||||
| Person-Hours by Task | |||||||||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | TOTALS | |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ||
| Corp Exec | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Proj Dir | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Sr Prof | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Mid Prof | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Jr Prof | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Sect/Cler | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| - | - | - | - | - | - | - | - | - | - | - | - | ||
| Task Totals | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Task Titles and Assumptions Used | |||||||||||||
| Task 1 - | Put the title and assumptions for task #1 here | ||||||||||||
| Task 2 - | Put the title and assumptions for task #2 here (continue on down until all tasks are listed) | ||||||||||||
| Task 3 - | |||||||||||||
| Task 4 - | |||||||||||||
| Task 5 - | |||||||||||||
| Task 6 - | |||||||||||||
| Task 7 - | |||||||||||||
| Task 8 - | |||||||||||||
| Task 9 - | |||||||||||||
| Task 10 - | |||||||||||||
| Task 11 - | |||||||||||||
| Task 12 - |
Travel, ADP, Wages, Direct Cost
| Sample Pricing Template -- Page 2 | ||||||
| Replace this text with the first line of the title of this estimate. This will appear on all pages. | ||||||
| Replace this text with the second line of the title of this estimate. This will appear on all pages. | ||||||
| FOOTNOTES: Cost Estimate Detail | ||||||
| A.3 TRAVEL | ||||||
| Local Travel | 0.0 | miles at | $0.000 | each | $0.00 | |
| Common Carrier (Air & Ground) costs: | ||||||
| Air | 0.0 | trips at | $0.00 | each | $0.00 | |
| Ground | 0.0 | trips at | $0.00 | each | $0.00 | |
| Vehicle Rental (& fuel) | 0.0 | days at | $0.00 | per day | $0.00 | |
| Per Deim: | 0.0 | days at | $0.00 | each | $0.00 | |
| - | ||||||
| TOTAL TRAVEL | $0.00 | |||||
| A.4 ADP SERVICES | ||||||
| Systems Analysis | $0.00 | |||||
| Programming | $0.00 | |||||
| Data Entry | $0.00 | |||||
| Machine Costs | $0.00 | |||||
| Other | $0.00 | |||||
| - | ||||||
| TOTAL ADP SERVICES | $0.00 | |||||
| A.5 SUBCONTRACTS | ||||||
| Subcontract #1 | $0.00 | |||||
| Subcontract #2 | $0.00 | |||||
| - | ||||||
| TOTAL SUBCONTRACTS | $0.00 | |||||
| A.6 DIRECT WAGES AND SALARIES (see attachment; hours by task) | ||||||
| Corporate Executive | $0.00 | 0.0 | hours | $0.00 | ||
| Project Director | $0.00 | 0.0 | hours | $0.00 | ||
| Senior Professional | $0.00 | 0.0 | hours | $0.00 | ||
| Midlevel Professional | $0.00 | 0.0 | hours | $0.00 | ||
| Junior Professional | $0.00 | 0.0 | hours | $0.00 | ||
| Secretarial/Clerical | $0.00 | 0.0 | hours | $0.00 | ||
| - | - | |||||
| TOTAL DIRECT WAGES & SAL. | 0.0 | hours | $0.00 | |||
| A.8 OTHER DIRECT COSTS | ||||||
| Consultants | $0 | per day x | 0.0 | days | $0.00 | |
| Consultants | $0 | per day x | 0.0 | days | $0.00 | |
| Express Del. | $0 | per pkg x | 0.0 | packages | $0.00 | |
| Reproduction | $0.00 | /doc'mt x | 0.0 | documents | $0.00 | |
| Telephone | $0 | per call x | 0.0 | calls | $0.00 | |
| Equipt. Rent | $0 | per item x | 0.0 | items | $0.00 | |
| - | ||||||
| TOTAL OTHER DIRECT COSTS | $0.00 |
Summary
| Sample Pricing Template-- Page 1 | |||
| Replace this text with the first line of the title of this estimate. This will appear on all pages. | |||
| Replace this text with the second line of the title of this estimate. This will appear on all pages. | |||
| A. TOTAL DIRECT COST | |||
| 1. Direct Materials and Supplies | $0.00 | ||
| 2. Non-Expendable Equipment | $0.00 | ||
| 3. Travel (See Footnote #A.3) | $0.00 | ||
| 4. ADP Services (See Footnote #A.4) | $0.00 | ||
| 5. Subcontracts (See Footnote #A.5) | $0.00 | ||
| 6. Direct Wages and Salaries (See Footnote #A.6) | $0.00 | ||
| 7. Fringe Benefits | |||
| Multiply A.6 by the following percentage ... | 35% | $0.00 | |
| 8. Other Direct Costs (See Footnote #A.8) | $0.00 | ||
| - | |||
| TOTAL DIRECT COSTS | $0.00 | ||
| B. OVERHEAD COSTS | |||
| For-profit Organizations | |||
| Multiply A.6 + A.7 by the following % ...... | 100% | $0.00 | |
| Not-for-profit Organizations | |||
| Multiply A.6 + A.7 by the following % ...... | 90% | $0.00 | |
| Educational Organizations | |||
| Multiply A.6 + A.7 by the following % ...... | 55% | $0.00 | |
| C. GENERAL AND ADMINISTRATIVE EXPENSES (if applicable) | |||
| Multiply TOTAL DIRECT COSTS and OVERHEAD COSTS | |||
| (excluding A.2 Non-expendable Equipment and A.4 Subcontracts) | |||
| by the following percentage .. | 15% | $0.00 | |
| - | |||
| SUBTOTAL (A, B, & C) | $0.00 | ||
| D. FEE (if applicable) | |||
| Multiply the sum of all the above costs | |||
| by the following percentage ..................... | 8% | $0.00 | |
| - | |||
| TOTAL ESTIMATED COSTS | $0.00 | ||
| TOTAL ESTIMATED COSTS (Rounded) | $0.00 | ||
| = |
File details come from the government source that posted it. Updated .