Attachment_1_Pricing_Sheet_(1).xlsx

XLSX spreadsheet 45 KB Posted

Attached to
Business Transformation Federal contract opportunity
Solicitation number
FA7014-16-R-3004
Issued by
Department of the Air Force Headquarters District Washington

View the file

Other files for this federal contract opportunity

Show all 15

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 Business Transformation 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.

Business Transformation 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.

BT TO 0001 Pricing Sheet

Offeror's Name:
Company ABCFA7014-16-R-3004 Attachment 1On-Site (fully burdened) TO 0001Off-Site (fully burdened) TO 0001
BUSINESS TRANSFORMATION TO 0001 Pricing SheetAnticipated POP 15 Nov 2015 -14 Nov 2016Anticipated POP 15 Nov 2015 -14 Nov 2016
Offeror Proposed Labor CategoryTask #TaskIDIQ PWS RequirementLow LCAT Salary Range
IAW 52.222-46High LCAT Salary Range
IAW 52.222-46Labor Hrs per yrFTEGOVT FTEHourly Labor RateTotal Labor CostHourly Labor RateTotal Labor Cost
Example1Program Manager1.3$100,000.00$110,000.004001ERROR:#REF!$50.00$20,000.00$51.00$20,400.00ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
2Consultant Senior1.3ERROR:#REF!$0.00$0.00ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
3Consultant 11.3ERROR:#REF!$0.00$0.00ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
4Consultant 21.3ERROR:#REF!$0.00$0.00ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
5Consultant 31.3ERROR:#REF!$0.00$0.00ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
6Consultant 41.3ERROR:#REF!$0.00$0.00ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
7Subject Matter Expert 11.3ERROR:#REF!$0.00$0.00
8Subject Matter Expert 21.3ERROR:#REF!$0.00$0.00
9Subject Matter Expert 31.3ERROR:#REF!$0.00$0.00
10Info Analyst1.3ERROR:#REF!$0.00$0.00
11Project Manager1.3ERROR:#REF!$0.00$0.00
12MS Sharepoint Manager1.3ERROR:#REF!$0.00$0.00
13Senior WebPage/Multi-media Specialist1.3ERROR:#REF!$0.00$0.00
ERROR:#REF!$0.00$0.00ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
ERROR:#REF!$0.00$0.00ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
ERROR:#REF!$0.00$0.00ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
ERROR:#REF!$0.00$0.00ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
ERROR:#REF!$0.00$0.00ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
ERROR:#REF!$0.00$0.00ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
ERROR:#REF!$0.00$0.00ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
TOTAL FTE1.0ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!

TOTAL ANNUAL LABOR COST $20,000.00 $20,400.00

Travel
TravelNOT TO EXCEED AMOUNT (DO NOT CHANGE)$ 25,000.00
Total Travel$ 25,000.00
Travel Handling Rate0.00%
Other Direct Costs (ODC)
Other Direct CostsNOT TO EXCEED AMOUNT (DO NOT CHANGE)$ 10,000.00
Total Other Direct Costs$ 10,000.00
ODC Handling Rate0.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-16-R-3004 Attachment 1
Company ABCYear 1Year 2Year 3Year 4Year 5
Anticipated POP 15 Nov 2015 -14 Nov 2016Anticipated POP 15 Nov 2016 -14 Nov 2017Anticipated POP 15 Nov 2017 -14 Nov 2018Anticipated POP 15 Nov 2018 -14 Nov 2019Anticipated POP 15 Nov 2019 -14 Nov 2020
Offeror Proposed Labor CategoryGOVT FTEOn-Site (fully burdened) Hourly Labor RateOff-Site (fully burdened) Hourly Labor RateOn-Site (fully burdened) Hourly Labor RateOff-Site (fully burdened) Hourly Labor RateOn-Site (fully burdened) Hourly Labor RateOff-Site (fully burdened) Hourly Labor RateOn-Site (fully burdened) Hourly Labor RateOff-Site (fully burdened) Hourly Labor RateOn-Site (fully burdened) Hourly Labor RateOff-Site (fully burdened) Hourly Labor Rate
ExampleERROR:#REF!$50.00$51.00$52.00$53.00$54.00$55.00ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!$54.00$55.00$54.00$55.00
Program ManagerERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
Consultant SeniorERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
Consultant 1ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
Consultant 2ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
Consultant 3ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
Consultant 4ERROR:#REF!
Subject Matter Expert 1ERROR:#REF!
Subject Matter Expert 2ERROR:#REF!
Subject Matter Expert 3ERROR:#REF!
Info AnalystERROR:#REF!
Project ManagerERROR:#REF!
MS Sharepoint ManagerERROR:#REF!
Senior WebPage/Multi-media SpecialistERROR:#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 .