Attachment_1_Pricing_Sheet.xlsx
XLSX spreadsheet 33 KB Posted
- Attached to
- Business, Engineering & Technical Assistance (BETA) Federal contract opportunity
- Solicitation number
- FA7014-15-R-5012
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| FA7014-15-R-5012-0001.doc | DOC document | |
| FA7014-15-R-5012.doc | DOC document | |
| Attachment_4_DD_FORM_254.pdf | ||
| Attachment_2_PPQ_Cover_Letter.pdf | ||
| Attachment_5_QASP.pdf | ||
| Attachment_3_PPQ.pdf |
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Instructions
Instructions: This format shall be used for the BETA price proposal. Offerors shall fill in the blocks in pink. Blocks highlighted blue are automatically calculated from information provided and should not be filled in individually.
General: It is the offeror's responsibility to ensure all columns and rows with formulas calculate correctly and provide a true representation of the proposed effort.
BETA TO 0001 Pricing Sheet
1. The offeror will provide separate pricing for locating personnel at government and contractor facilities.
2. OFFEROR INPUT: Offeror's Name: Self-Explanatory
3. OFFEROR INPUT: Offeror Proposed Labor Category: Column A is the labor category assigned to the position by the Offeror.
4. Columns B - H of the Labor portion of the Pricing Sheet are provided for your convenience. These columns provide a description of the work and direct offerors to the relevant section of the PWS . NOTE: The position description is not a labor category. Assigning a labor category is the offerors responsibility.
5. OFFEROR INPUT: Low/High Salary Range(s): Offeror fills in salary range(s) as applicable for each labor category. Inputs are used for the evaluation of compensation plans in accordance with FAR Provision 52-222-46.
6. OFFEROR INPUT: Labor Hours/Year: Offeror fills in labor hours per year for each FTE.
7. OFFEROR INPUT: FTE: Column H is for the number of FTEs for each given line of the Pricing Sheet by year.
8. OFFEROR INPUT: Hourly Labor Rate: Offeror fills in only the columns labeled "Hourly Labor Rate". The spreadsheet will automatically populate the blue column labeled "Total Labor Cost".
9. Total FTE and Total Labor Cost are automatically calculated based on offeror inputs. Labor costs are broken down by year and duty location (i.e. government or contractor facility).
10. Travel: Travel Cost assumptions provided by the government. Do not change the assumptions.
11. Other Direct Costs (ODCs): Material Cost assumptions provided by the government. Do not change the assumptions.
12. OFFEROR INPUT: Travel and ODC Handling Rates: Travel Handling Fee and Material Handling Fee if applicable are requested in the pink blocks in Column B. The associated dollar value will automatically calculate and become part of the Total Travel and Total Other Direct Cost rows.
13. Total Annual Labor Cost: This column auto calculates.
14. Total Travel: This column auto calculates.
15. Total Other Direct Costs: This column auto calculates.
16. TOTAL LABOR TRAVEL & ODC: This column auto calculates.
17. TOTAL PROPOSED ON-SITE/OFF-SITE: Ensure the total includes the total proposed. This will represent the total proposed price for Task Order 0001.
Hourly Labor Rates
1. OFFEROR INPUT: Offeror's Name: Self-Explanatory
2. OFFEROR INPUT: Offeror Proposed Labor Category: Column A is the labor category assigned to the position by the Offeror.
3. OFFEROR INPUT: On-Site/Off-Site Hourly Labor Rates: Offeror fills in only the columns labeled "Hourly Labor Rate" in pink.
BETA TO 0001 Pricing Sheet
| Offeror's Name: | |||||||||||||||||
| Company ABC | FA7014-15-R-5012 Attachment 1 | On-Site (fully burdened) TO 0001 | Off-Site (fully burdened) TO 0001 | ||||||||||||||
| BETA TO 0001 Pricing Sheet | Anticipated POP 15 Nov 2015 -14 Nov 2016 | Anticipated POP 15 Nov 2015 -14 Nov 2016 | |||||||||||||||
| Offeror Proposed Labor Category | Task # | Task | TO 0001 PWS Requirement | Low LCAT Salary Range | |||||||||||||
| IAW 52.222-46 | High LCAT Salary Range | ||||||||||||||||
| IAW 52.222-46 | Labor Hrs per yr | FTE | GOVT FTE | Hourly Labor Rate | Total Labor Cost | Hourly Labor Rate | Total Labor Cost | ||||||||||
| Example | 1 | Business Process Re-Engineering Support | 3.1 | $100,000.00 | $110,000.00 | 400 | 1 | ERROR:#REF! | $50.00 | $20,000.00 | $51.00 | $20,400.00 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| 2 | Program Management Expertise | 3.2 | ERROR:#REF! | $0.00 | $0.00 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||||||||
| 3 | SDDP Step 3 Support | 3.3 | ERROR:#REF! | $0.00 | $0.00 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||||||||
| 4 | SDDP Workshop Facilitation Support | 3.4 | ERROR:#REF! | $0.00 | $0.00 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||||||||
| 5 | Data Capture Support | 3.5 | ERROR:#REF! | $0.00 | $0.00 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||||||||
| 6 | Service Reference Model Support | 3.6 | ERROR:#REF! | $0.00 | $0.00 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||||||||
| 7 | Compliance Support | 3.7 | ERROR:#REF! | $0.00 | $0.00 | ||||||||||||
| 8 | Data Reference Model Support | 3.8 | ERROR:#REF! | $0.00 | $0.00 | ||||||||||||
| 9 | COI Support | 3.9 | ERROR:#REF! | $0.00 | $0.00 | ||||||||||||
| 10 | COI Support | 3.10 | ERROR:#REF! | $0.00 | $0.00 | ||||||||||||
| 11 | System Architecture Support | 3.11 | ERROR:#REF! | $0.00 | $0.00 | ||||||||||||
| 12 | Part-Time Chief Technology Officer Support | 3.12 | ERROR:#REF! | $0.00 | $0.00 | ||||||||||||
| 13 | Web Development | 3.13 | ERROR:#REF! | $0.00 | $0.00 | ||||||||||||
| 14 | Program Management | 3.14 | ERROR:#REF! | $0.00 | $0.00 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||||||||
| 15 | SDDP Guidance Support | 3.15 | ERROR:#REF! | $0.00 | $0.00 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||||||||
| 16 | Integrated Master Scheduling | 3.16 | ERROR:#REF! | $0.00 | $0.00 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||||||||
| 17 | Support Maintenance of Target Baseline | 3.17 | ERROR:#REF! | $0.00 | $0.00 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||||||||
| 18 | Community of Interest Coordination Panel Support | 3.18 | ERROR:#REF! | $0.00 | $0.00 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||||||||
| 19 | PAD/PGL Support | 3.19 | ERROR:#REF! | $0.00 | $0.00 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||||||||
| 20 | Administration Support | 3.20 | ERROR:#REF! | $0.00 | $0.00 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||||||||
| TOTAL FTE | 1.0 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
TOTAL ANNUAL LABOR COST $20,000.00 $20,400.00
| Travel | ||||
| Travel | NOT TO EXCEED AMOUNT (DO NOT CHANGE) | $ 25,000.00 | ||
| Total Travel | $ 25,000.00 | |||
| Travel Handling Rate | 0.00% | |||
| Other Direct Costs (ODC) | ||||
| Other Direct Costs | NOT TO EXCEED AMOUNT (DO NOT CHANGE) | $ 10,000.00 | ||
| Total Other Direct Costs | $ 10,000.00 | |||
| ODC Handling Rate | 0.00% | |||
| TOTAL LABOR, TRAVEL & ODC | $55,000.00 | $55,400.00 |
TOTAL LABOR, TRAVEL & ODC $55,000.00 $55,400.00
| TOTAL Proposed On-Site (fully burdened) TO 0001 | $55,000.00 |
| TOTAL Proposed Off-Site (fully burdened) TO 0001 | $55,400.00 |
Hourly Labor Rates
| Offeror's Name: | FA7014-15-R-5012 Attachment 1 | |||||||||||
| Company ABC | Year 1 | Year 2 | Year 3 | |||||||||
| Anticipated POP 15 Nov 2015 -14 Nov 2016 | Anticipated POP 15 Nov 2016 -14 Nov 2017 | Anticipated POP 15 Nov 2017 -14 Nov 2018 | ||||||||||
| Offeror Proposed Labor Category | GOVT FTE | On-Site (fully burdened) Hourly Labor Rate | Off-Site (fully burdened) Hourly Labor Rate | On-Site (fully burdened) Hourly Labor Rate | Off-Site (fully burdened) Hourly Labor Rate | On-Site (fully burdened) Hourly Labor Rate | Off-Site (fully burdened) Hourly Labor Rate | |||||
| Example | ERROR:#REF! | $50.00 | $51.00 | $52.00 | $53.00 | $54.00 | $55.00 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||||||||
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||||||||
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||||||||
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||||||||
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||||||||
| ERROR:#REF! | ||||||||||||
| ERROR:#REF! | ||||||||||||
| ERROR:#REF! | ||||||||||||
| ERROR:#REF! | ||||||||||||
| ERROR:#REF! | ||||||||||||
| ERROR:#REF! | ||||||||||||
| ERROR:#REF! | ||||||||||||
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
File details come from the government source that posted it. Updated .