Attachment 4B Subcontractor Pricing Models dtd 6-2-11
Shared by: xiaopangnv
-
Stats
- views:
- 1
- posted:
- 10/16/2012
- language:
- Korean
- pages:
- 8
Document Sample


GENERAL INSTRUCTIONS AND INFORMATION
RFP N65236-09-R-0074
Prime Pricing Model Version 1 dated 6-2-11
Contract Negotiator: Adam W Christopher (843) 218-5620
Assumptions:
1. The Fringe Benefit allocation base is total labor dollars.
2. The Labor Overhead allocation base is total direct labor dollars PLUS associated fringe benefit.
3. The G&A allocation base is total cost input.
4. Facilities Capital Cost of Money is not incorporated.
5. The Government estimates the annual Full Time Equivalent (FTE) to be 1,880 direct hours per year.
6. Overtime for exempt personnel is based on a total time accounting concept. (Annual salary divided by total hours worked equals the hourly rate.)
7. For evaluation purposes, Other Direct Costs (ODCs) will be incurred by prime contractor, but see # 6 below.
8. Additional ODCs are subject to G&A.
9. Fee is proposed at the Prime level and paid to the subcontractors from the proposed fee/profit pools.
PRIME CONTRACTOR DIRECTIONS:
1. Fill in only those cells that are highlighted in blue:
a. Enter your company name at the top of the Summary sheet.
b. Populate the labor hour fields highlighted in blue for each subcontractor on the Labor Cost sheet.
2. Forward the appropriate Subcontractor Pricing Model to each subcontractor.
SUBCONTRACTOR DIRECTIONS:
1. If the assumptions above are valid, fill in only those cells that are highlighted in yellow:
a. Enter your company name at the top of the Summary sheet.
b. Enter escalation and indirect loading factors at the bottom of the Summary sheet, including allocation base data.
c. Provide the information requested on the Other Labor Data sheet if required (see #4 and #5 below).
d. Provide amounts for Additional ODCs on the Summary sheet, if required (see # 6 below).
e. Complete the YELLOW tabs entitled Benefit Summary and Salary Data if providing 9,400 or more hours per year of professional labor.
2. If above assumptions are not valid, modify appropriate formulas throughout the spreadsheets. Identify changes by highlighting all cells with changed
3. Describe basis for base year direct labor rates and all indirect rates and their application in the proposal narrative.
Suggestion: The proposal narrative information can be provided as a separate page in the pricing model proposal.
4. If company job titles are different from those used by the prime contractor, provide this information on the Other Labor Data sheet. If your estimating
system requires the use of multiple job titles to match the individual job titles in the RFP and pricing model, add a spreadsheet to the pricing model
showing the computation of the base year weighted average direct labor rates.
5. If direct labor rates are calculated by using other than 2,080 hours per year, list the number of hours per year used to calculate the hourly rate for each
category of labor on the Other Labor Data sheet.
6. Although ODCs are assumed to be incurred by the prime contractor, for evaluation purposes, if you, the subcontractor will incur Additional ODCs (i.e.
computer usage, reproduction, etc.) in performance of this contract, you must identify those Additional ODCs on the Summary sheet. Describe the
basis and costing methodology for each in the proposal narrative. (See RFP Clause L329(g)). Failure to identify and provide estimated costs for
these Additional ODCs will result in these costs being determined mutually agreed-upon unallowable costs under this contract.
7. Copy the Labor Cost sheet using COPY, PASTE SPECIAL, and VALUES functions to a separate file and transmit that file to the prime contractor.
8. Transmit entire Pricing Model file in EXCEL format (complete with active formulas) along with supporting narrative (pdf format) to the
Government in accordance with RFP instructions.
9. Provide copies of correspondence from DCAA or DCMA regarding the most recent approval of your rates and/or systems, such as Forward
Pricing Rate Agreements (FPRAs), Provisional Billing Rates (PBRs), and Accounting System Approval. These may be provided with the
Proposal Narrative or added to the pricing model.
e66d482f-6f34-47c8-9fe7-7f5de117c32e.xlsx Directions 1 of 8
Summary
N65236-09-R-0074
Prime Contractor's Name:
Subcontractor's Name:
Base Year Option Year 1 Option Year 2 Option Year 3 Option Year 4 Total % of Hours
Labor Cost 0.00 0.00 0.00 0.00 0.00 0.00
Labor Hours 0 0 0 0 0 0 0.00%
Additional ODCs 0.00 0.00 0.00 0.00 0.00 0.00
Prime G&A on ODCs 0.00 0.00 0.00 0.00 0.00 0.00
Total ODC Costs 0.00 0.00 0.00 0.00 0.00 0.00
Loading Factors Base Year Option Year 1 Option Year 2 Option Year 3 Option Year 4 Allocation Base
Please Fill In
Labor Escalation 0.00% 0.00% 0.00% 0.00% Direct Labor
Fringe Benefit 0.00% 0.00% 0.00% 0.00% 0.00% Direct Labor
OH-Contractor Site - SC 0.00% 0.00% 0.00% 0.00% 0.00%
OH-Government Site - SC 0.00% 0.00% 0.00% 0.00% 0.00%
G&A 0.00% 0.00% 0.00% 0.00% 0.00%
CONTRACTOR CHANGES TO THE PRICING MODEL
Source Selection Information
e66d482f-6f34-47c8-9fe7-7f5de117c32e.xlsx Summary See FAR 2.101 and 3.104 2 of 8
Labor Cost
N65236-09-R-0074
SEND THIS PAGE TO THE PRIME
Charleston, SC Base Year Option Year 1 Option Year 2 Option Year 3 Option Year 4
Contractor Site - Straight Time Hours
Professional Categories Per Year Rate Total Cost Rate Total Cost Rate Total Cost Rate Total Cost Rate Total Cost
Program Manager 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Engineer/Scientist 4 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Engineer/Scientist 3 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Engineer/Scientist 2 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Engineer/Scientist 1 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Security Specialist 2 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Training Specialist 3 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Training Specialist 2 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Training Specialist 1 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Technical Writer/Editor 2 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Subject Matter Expert (SME) 5 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Subject Matter Expert (SME) 4 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Subject Matter Expert (SME) 3 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Subject Matter Expert (SME) 2 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Administrative Assistant 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Illustrator II 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Government Site - Straight Time
Training Specialist 4 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Technical Writer/Editor 2 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Technical Writer/Editor 1 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total Hours/Cost 0 0.00 0.00 0.00 0.00 0.00
Additional ODCs including G&A 0.00 0.00 0.00 0.00 0.00
e66d482f-6f34-47c8-9fe7-7f5de117c32e.xlsx Source Selection Information
Labor Cost See FAR 2.101 and 3.104 3 of 8
Loaded Rates
N65236-09-R-0074
Please do not delete any rows from this sheet
Charleston, SC Base Year Option Year 1 Option Year 2 Option Year 3 Option Year 4
Contractor Site - ST Labor Fringe OH G&A Total Labor Fringe OH G&A Total Labor Fringe OH G&A Total Labor Fringe OH G&A Total Labor Fringe OH G&A Total
Professional Categories Rate Cost Cost Cost ST Rate Cost Cost Cost ST Rate Cost Cost Cost ST Rate Cost Cost Cost ST Rate Cost Cost Cost ST
Program Manager 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Engineer/Scientist 4 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Engineer/Scientist 3 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Engineer/Scientist 2 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Engineer/Scientist 1 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Security Specialist 2 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Training Specialist 3 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Training Specialist 2 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Training Specialist 1 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Technical Writer/Editor 2 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Subject Matter Expert (SME) 5 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Subject Matter Expert (SME) 4 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Subject Matter Expert (SME) 3 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Subject Matter Expert (SME) 2 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Administrative Assistant 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Illustrator II 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Charleston, SC Base Year Option Year 1 Option Year 2 Option Year 3 Option Year 4
Government Site - ST Labor Fringe OH G&A Total Labor Fringe OH G&A Total Labor Fringe OH G&A Total Labor Fringe OH G&A Total Labor Fringe OH G&A Total
Professional Categories Rate Cost Cost Cost ST Rate Cost Cost Cost ST Rate Cost Cost Cost ST Rate Cost Cost Cost ST Rate Cost Cost Cost ST
Training Specialist 4 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Technical Writer/Editor 2 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Technical Writer/Editor 1 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
e66d482f-6f34-47c8-9fe7-7f5de117c32e.xlsx
Loaded Rates Source Selection Information
See FAR 2.101 and 3.104 4 of 8
Other Labor Data
N65236-09-R-0074
UNCOMPENSATED OVERTIME CALCULATION
Note: Complete this section ONLY if proposed rates are
calculated using other than 2,080 hours per year.
Note: Complete this section ONLY if Charleston, SC
company job titles are different from Base Year Labor Rates
those specified in the RFP. Base Effective Effective
Professional Categories Offeror's Labor Categories Rate (1) Rate (2) Hours (3)
Program Manager
Engineer/Scientist 4
Engineer/Scientist 3
Engineer/Scientist 2
Engineer/Scientist 1
Security Specialist 2
Training Specialist 4
Training Specialist 3
Training Specialist 2
Training Specialist 1
Technical Writer/Editor 2
Technical Writer/Editor 1
Subject Matter Expert (SME) 5
Subject Matter Expert (SME) 4
Subject Matter Expert (SME) 3
Subject Matter Expert (SME) 2
Administrative Assistant (1) Base Rate is annual salary divided by 2,080 hours.
Illustrator II (2) Effective Rate is annual salary divided by total hours recorded.
(3) Effective Hours are the total hours recorded, including leave.
Was Uncompensated Overtime used to calculate the professional labor rates? (Yes/No)
Uncompensated Overtime Policy
e66d482f-6f34-47c8-9fe7-7f5de117c32e.xlsx Source Selection Information
Other Labor Data See FAR 2.101 and 3.104
Benefit Summary
N65236-09-R-0074
Company Name:
PROFESSIONAL EMPLOYEE COMPENSATION PLAN
INSTRUCTIONS: Complete this chart and the Salary Data chart if you are providing more than 18,800 hours per year of professional
labor. If completed according to the guidance provided as an attachment to this RFP, no other information is
required for the Professional Employee Compensation Plan, although supplementary information may be submitted,
if desired.
Salaries See Attached Salary Data sheet
Salary Supporting Data See Attached Salary Data sheet
Escalation
Eligibility for Benefits
Vacation
Sick Leave
Holidays
Military Leave
Jury Duty
Medical Insurance
Dental Care
Vision Care
Short Term Disability
Long-Term Disability
Life Insurance
AD&D
Retirement /Pension
Education Assistance
% of Salary/Fringe Rate
Additional Notes:
e66d482f-6f34-47c8-9fe7-7f5de117c32e.xlsx Source Selection Information
Benefit Summary See FAR 2.101 and 3.104 6 of 8
Benefit Summary
e66d482f-6f34-47c8-9fe7-7f5de117c32e.xlsx Source Selection Information
Benefit Summary See FAR 2.101 and 3.104 7 of 8
Salary Data
N65236-09-R-0074
INSTRUCTIONS: Complete this page only if you are providing 18,800 hours or more per year of
professional labor. This page and the preceding Benefit Summary Chart constitute the
Professional Employee Compensation Plan.
PROFESSIONAL SALARIES
Charleston, SC
Labor Category Base Year Salary
Program Manager
Engineer/Scientist 4
Engineer/Scientist 3
Engineer/Scientist 2
Engineer/Scientist 1
Security Specialist 2
Training Specialist 4
Training Specialist 3
Training Specialist 2
Training Specialist 1
Technical Writer/Editor 2
Technical Writer/Editor 1
Subject Matter Expert (SME) 5
Subject Matter Expert (SME) 4
Subject Matter Expert (SME) 3
Subject Matter Expert (SME) 2
Labor rates are based on hours per year
SUPPORTING SALARY DATA
Compensation Survey Name / Compensation Data Source Survey Date
e66d482f-6f34-47c8-9fe7-7f5de117c32e.xlsx Source Selection Information
Salary Data See FAR 2.101 and 3.104
Get documents about "