Attachment_5_-_Price_Estimate_Formatting_Example.xlsx
XLSX spreadsheet 15 KB Posted
- Attached to
- CTP Third Party Tobacco Compliance Inspections
- Solicitation number
- 16-223-SOL-00018
About this file
Attachment 5 - Price Estimate Formatting Example
View the file
Other files
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
Text version
Sample Layout
| Attachment 5 - Fixed Price Format and Example |
| FIXED PRICE |
| This document has multiple sheets, including a completed example cost estimate. |
FIXED PRICE COST ELEMENTS
| Direct Labor: | Quantity | Time or % | Rate | Total Est. Cost |
| Program Coordinator | ||||
| Backup Program Coordinator | ||||
| Admin. | ||||
| Inspector | ||||
| Minor | ||||
| Chaperone | ||||
| Total Direct Labor Costs |
Fringe Benefits
| Subcontract: |
| Inspectors |
| Minors |
| Other subcontractor costs |
| Total Sobcontract Costs |
| Other Direct Costs: |
| PC Training/Travel |
| Inspection Travel |
| Materials and Supplies (itemize) |
| Equipment (itemize) |
| Other |
| Total Other Direct Costs |
| Indirect Costs: |
| General and Administrative |
| Overhead |
| Total Indirect Costs |
**TOTAL FIXED PRICE COSTS
| FIXED PRICE UNITS | |||
| # of Units | Price Per Unit | Total Price | |
| Undercover Buy Inspections | |||
| A&L Inspections | |||
| Compliance Followup Inspections | |||
| Other Directed Inspecitons/Assignments | |||
| Program Management | |||
| PC Training and Travel |
**TOTAL FIXED PRICE COSTS (Inspection + PM Totals)
| **The two TOTAL FIXED PRICE COSTS lines must approximately equal each other |
| Some of the above costs will not apply to how your agency has proposed to conduct inspections. |
Example Format
FIXED PRICE COST ELEMENTS
| Direct Labor: | Quantity | Time or % | Rate | Total Est. Cost |
| Program Coordinator | 1 | 2080 | $32.00 | $66,560.00 |
| Backup Program Coordinator | 1 | 1040 | $26.50 | $27,560.00 |
| Admin. | 1 | 200 | $13.75 | $2,750.00 |
| Inspector | 5 | 2080 hrs/ea | $20.00/hour | $208,000.00 |
| Chaperone | 10 | 375 hrs/ea | $12.50/hour | $46,875.00 |
| Total Direct Labor Costs | $351,745.00 |
Fringe Benefits 20% $70,349.00
| Subcontract: | ||||
| Inspectors | 4 | 1040 hrs/ea | $15.75/hour | $65,520.00 |
| Minor | 15 | 250 hrs/ea | $7.75/hour | $29,062.50 |
| Total Sobcontract Costs | $94,582.50 |
| Other Direct Costs (ODC's): | |||
| Program Coordinators' Training/Travel | $1,453.57 | ||
| Inspection Travel | 25,000 miles | $0.565/mile | $14,125.00 |
| Materials and Supplies (itemize) | |||
| Paper | 6 boxes | $40.00 | $240.00 |
| Office supplies | 12 months | $200.00 | $2,400.00 |
| Equipment (itemize) | |||
| Laptops | 2 | $1,200.00 | $2,400.00 |
| File cabinets | 4 | $780.00 | $3,120.00 |
| Cameras | 8 | $97.00 | $776.00 |
| Buy money for minors | 300 buys | $7.00 | $2,100.00 |
| Office Space rental | 12 months | $965.00 | $11,580.00 |
Total ODC's $38,194.57
TOTAL DIRECT COSTS (Direct Labor + Fringe + Subcontract + ODC's) $554,871.07
| Indirect Costs: | ||
| General and Administrative | 3.50% | $15,235.76 |
| Overhead | 40.00% | $228,042.73 |
| Total Indirect Costs | $243,278.49 |
**TOTAL FIXED PRICE COSTS $798,149.56
| FIXED PRICE UNITS | |||
| # of Units | Price Per Unit | Total Price | |
| Undercover Buy Inspections | 6,750 | 60.00 | $405,000 |
| A&L Inspections | 2250 | 50.00 | $112,500 |
| Compliance Followup Inspections | 810 | 115.69 | $93,709 |
| Other Directed Inspections/Assignments | 5 | 54.40 | $272 |
| Program Management | 12 | 15,430.38 | 185164.57 |
| PC Training and Travel | 1 | $1,504.44 |
**TOTAL FIXED PRICE COSTS (Inspection + PM Totals) $798,149.91
| **The two TOTAL FIXED PRICE COSTS lines must approximately equal each other** |
| Some of the above costs will not apply to how your agency has proposed to conduct inspections. |
Sheet3
File details come from the government source that posted it. Updated .