Attachment_17_as_of_26July.xlsx

XLSX spreadsheet 233 KB Posted

Attached to
Weapon Planning Software (WPS) Federal contract opportunity
Solicitation number
FA8681-18-R-0006
Issued by
Department of the Air Force Materiel Command Lifecycle Management Center Eglin Air Force Base

About this file

This draft request for proposal concerns continuing development of the Weapons Planning Software suite. The Department of Defense, United States Air Force, Air Force Materiel Command, and Air Force Life Cycle Management Center are seeking feedback on requirements, compliance documentation, cost spreadsheets, and other aspects of the draft RFP. Interested vendors must submit an export control request form by June 15th to receive the draft documents. One-on-one feedback sessions will be held June 5th-6th, with vendors providing available times by May 24th. The agencies are seeking input on labor categories, contract types including time and materials approval, and the sufficiency of requirements and compliance materials. Foreign vendors will be ineligible due to distribution controlled information.

DRAFT Section J, Attachment 17 - Cost/Price Spreadsheet

View the file

Other files for this federal contract opportunity

Other files attached to Weapon Planning Software (WPS), newest first.
File Type Posted
FA8681-18-R-0006_0002.pdf PDF
FA8681-18-R-0006_Q&A_Round_3.pdf PDF
WPS_FA8681-18-R-0006-Q&A_Round_2.pdf PDF
WPS_FA8681-18-R-0006_Q&A.pdf PDF
DO_1_SOW__18_Sep.docx DOCX document
FA8681-18-R-0006_0001.pdf PDF
DO_Attach_1_-_DO_1_SOW_9_Aug.docx DOCX document
Attachment_14_-_Proposal_Cross-Reference_Matrix_13_Aug.xlsx XLSX spreadsheet
ComplianceDocMatrix.xlsx XLSX spreadsheet
WPS_FY19_Build_Plan_8_Aug.pptx PPTX presentation
Attachment_17_-_Cost_Spreadsheet_27_Aug.xlsx XLSX spreadsheet
WPS_Second_DRFP_Q&A.pdf PDF
DRFP2_FA8681-18-R-0006_26_July_2018.pdf PDF
DRFP_Final_Q&A_13_July.pdf PDF
Attachment_18_-_Export_Controlled_Info_Request.pdf PDF
FA8681-18-R-0006_DRAFT_RFP_5-16-18_Updated.pdf PDF
FA8681-18-R-0006_DRAFT_RFP_5-16-18.pdf PDF
Attachment_18_-_Export_Controlled_Info_Request.pdf PDF
FA8681-18-R-0006_DRAFT_RFP_5-15-18.pdf PDF
Show all 19

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

Read First Instructions

Instructions for Completing Attachment 17
General Instructions
1. The labor hours in Tabs 1-6 "Government Labor Hours" columns are provided as representative of historical/estimated use of the respective labor categories. The Government makes no claim that future usage will in any way mirror prior usage. The hours are provided to show the relative weighting amongst the different labor categories. Do not change the Government Labor Hours column for Tabs 1-6. A Total Evaluated Price (TEP) will be utilized for the evaluation.

Color Legend: Yellow = Offeror adjusts according to business practices. Blue = Values required to be carried forward to Tab 13. Green = Values to be carried forward to Tab 12.

2.The offeror is required to populate ALL provided Office of Management and Budget's (OMB)Standard Occupational Classification Labor Categories and Skill Levels (SOC Labor Categories/Skill Levels) the offeror considersdirect labor for the three years provided. If the listed labor categories do not directly align to the offeror's labor categories, the offeror shall map their labor categories to the most appropriate SOC labor categories/skill levels. If mapping, the offeror shall distribute the Government provided hours evenly between mapped labor categories and it shall add up to the Government provided hours. Failure to do such may make the offeror unawardable. For SOC Labor Categories/Skill Levels that the offerorconsiders to be solely indirect labor, enter a zero in the respective direct labor rate column. If the offeror does not plan to utilize any of the labor categories/levels, the offeror shall still provide a rate and complete the worksheet in the same manner of the other rates. Note: The prime shall include the subcontractor categories (or any teaming categories) with the subcontractor Direct Labor Rate (which would be fully burdened with fee) and then show any prime burdens to build to the BLR. The offeror shall require the subcontractor to provide Attachment 17 completed fully either to the Prime (include within proposal) or the subcontractor shall provide the completed Attachment 17 directly to the Government NLT than the proposal due date.
3. Each Offeror shall enter Burdened Labor Rates (BLR)/Fully Burdened Labor Rates (FBLR) for the first 3 years of contract performance in separate tabs for each year (Tabs 1-3 for BLR, Tabs 4-6 for FBLR) assuming period of performance beginning in 2019. The Offeror shall insert the 2017 BLS Wage Data Rate for each category (specific to location) as the baseline for establishing the 2019, 2020, 2021 rates for each of the SOC categories/skill levels. Then the offeror shall insert their proposed 2017 rate for each of the offeror's company proposed rate for each of the mapped labor categories/skill levels. The offeror shall insert the % escalation and provide an explanation for the escalation. Finally, the offeror shall apply their % of escalation to the proposed 2017 rate to reach the proposed Direct Labor Rate for each year (2019, 2020 & 2021). Any proposed 2017 labor rates that significantly deviate (+/- 15%) from the 2017 BLS Wage Data Rate OMB SOC percentile wage estimates from May 2017 shall be supported with an explanation and applicable supporting data in the narrative of the cost/price proposal. Additionally, the offeror shall carry forward each Labor Category/Level BLR, proposed fee & COM on the BLR tabs and FBLR rates and any material indirect rates into Tab 13 which will become Attachment 7 on the awarded contract.
4. Each Offeror shall enter their Delivery Order proposed costs for each CLIN (Tabs 7-11) assuming a 1 May 2019 start date. Note: The Government is providing a NTE amount for DO CLIN 0700 Time and Material. No action is required for this CLIN. However, refer to CLIN 0700 Descriptive Data, the Basic Contract SOW paragraph 2.7 and Section J Attachment 8 T&M request and Approval Form for details. Tab 12 TEP includes the Government provided NTE amount for T&M that will be used in determining the Total Evaluated Price (TEP). All pricing of the DO shall utilize Tab 13 (Basic Contract Atch 7) information and the offeror shall identify a BOE reference to algin costs with proposed performance.
5. Rate build up must provide % and $ (rounded to cents, except for Cost of Money) and must be in accordance with the offeror's approved accounting system.
6. If Cost of Money (COM) is proposed, do not include in the profit and fee calculation For BLRs, the COM is not included in the rate , and is added to the total labor cost. For FBLRs, COM is included in the rate.
Specific Instructions
7. (Tabs 1, 2, & 3 BLR Years): Offerors must build up their BLRs for the Basic IDIQ CLINs(CLINs 0100, 0200, 0300,0400) for the WPS provided SOC Labor Categories/Skill Levels as listed and according to Section J, Attachment 5 Labor Category Descriptions. The BLRs shall be calculated for the first 3 years in accordance with their approved accounting system (see BLR tab). BLR buildups include all direct & indirect cost elements (excluding fee and COM). Offerors MUST propose on every SOC Labor Category/Skill Level for all periods (unless it is considered to be solely an indirect labor category/skill level as described above in item 2. The offeror shall (if applicable) insert the company equivalent labor category/skill level title and/or any subcontractor equivalent aligned to the most appropriate SOC Labor Categories/Skill Levels provided. The offeror may "map" multiple company equivalent labor categories/skill levels to the most appropriate SOC Labor Categories by adding lines (rows) in a similar manner to the examples at the top of each tab. This will allow for instances where the offeror has multiple labor categories/skill levels that can be mapped to a single SOC Labor Category/Skill Level. In these instances, the offeror shall divide provided Government Labor Hours EQUALLY amongst the company labor categories/skill levels, which added together shall equal the total number of Government Labor Hours for each SOC Labor Category/Skill Level. At the bottom of each tab, the offeror shall propose a composite fee rate to be utilized on all CPFF CLINs for the first three years. The proposed fee will be applied to the total BLR labor cost for each year (excluding COM). The offerors shall, if applicable, calculate COM in accordance with the offeror's accounting practices. Then, Total BLR Labor Costs plus the applied fee calculation plus COM (if applicable) equals the "BLR Year "X" Total". Additionally, for evaluation purposes, the "BLR Year "X" Total" will carry forward to the Column titled "Offeror's Total Proposed Amount (TPA)" in Tab 12 TPA/TEP for each of the respective years. The proposed indirect rates used for the build up and each Labor Category and Labor Category Rate within the column titled "Burdened Labor Rate (BLR)" for each of the respective years, will carry forward to Tab 13 which becomes the Section J "Attachment 7 Rates" at contract award. The COM rate at the bottom of each tab will be carried forward to the Section J "Attachment 7 Rates" for each year.
8. (Tabs 4, 5 and 6 T&M Year): The offeror's BLR rate from this worksheet's Tabs 1, 2 and 3 will carry forward to the respective year to complete the rest of the build up for their Fully Burdened Labor Rates (FBLR) (T&M only (CLIN 0700))(including COM and Profit ). FBLRs shall be calculated for the first 3 years in accordance with their approved accounting system (see FBLR tab). FBLR buildups include all direct & indirect cost elements. Offerors MUST propose on every SOC Labor Category/Skill Level for all periods (unless it is considered to be solely an indirect labor category/skill level as described above in item 2). The offeror shall (if applicable) insert the company equivalent labor category/skill level title and/or any subcontractor equivalent aligned to the most appropriate SOC Labor Categories/Skill Levels provided. The offeror may "map" multiple company equivalent labor categories/skill levels to the most appropriate SOC Labor Categories by adding lines in a similar manner to the examples at the top of each tab. This will allow for instances where the offeror has multiple labor categories/skill levels that can be mapped to a single SOC Labor Category/Skill Level. In these instances, the offeror shall divide provided Government Labor Hours EQUALLY amongst the company labor categories/skill levels, which added together shall equal the total number of Government Labor Hours for each SOC Labor Category/Skill Level. The sum of all labor categories will be shown at the bottom of each sheet "Total Labor Cost Including Profit." The offeror shall complete the material information at the bottom of each sheet utilizing the provided $5,000 estimate (do not change). For evaluation purposes, the Total T&M (TLC+Material Cost) will carry forward to the Column titled "Offeror's Total Proposed Amount (TPA)" in Tab 12 TPA/TEP for each of the respective years. Each Labor Category and Labor Category Rate within the column titled "Fully Burdened Labor Rate (FBLR)" for each of the respective years, will carry forward to Tab 13 which becomes the Section J "Attachment 7 Rates" at contract award.
9. (Tabs 4, 5, and 6 FBLR Years): Material: for evaluation purposes, material costs will be calculated based on $5,000 per year for T&M (CLIN 0700). The Offeror shall propose a material rate consistent with their disclosed accounting practices. If there is no rate, please enter 0%.
Specific Instructions continued.
10. (Tabs 7 and 8 DO CLINs): Tab 7: DO CLIN 0100 Software Development (DO SOW paragraph 2.2) and Tab 8: DO CLIN 0200 Legacy Enhancements (DO SOW 2.3): For the Delivery Order (DO) cost proposal, each offeror shall utilize the spreadsheet Tabs 7 and 8 by entering the hours and Other Direct Costs (ODC), if applicable, for each respective CLIN showing costs separated by year. To clearly price DO CLIN 0100 Software Development,the offeror shall use subtabs for DO SOW Table 1 tasks and a subtab for depicting the remaining hours (Subtabs 7a, 7b, 7c, 7d). The main Tab 7 DO CLIN 0100 Total, shall be the summary total for all subtabs (7a through 7d). To clearly price DO CLIN 0200 Legacy Enhancements ,the offeror shall use use subtabs for DO SOW Table 2 tasks and a subtab for depicting the remaining hours (Subtabs 8a, 8b, 8c, 8d). The main Tab 8 DO CLIN 0200 Total, shall be the summary total for all subtabs (8a through 8d). For ODC, the offeror shall reflect a rate including all direct and indirect rates in accordance with the offeror's accounting practices and adjust the categories accordingly. These costs will be included in the sum for each year of each CLIN. The proposed amounts, "Total DO CLIN XXXX for 2019" and "Total DO CLIN XXXX for 2020" added together will be the total for each respective CLIN ,"Total DO CLIN XXXX", and will carry forward to the Column titled "Proposed Amount" in Tab 12 TEP for each of the respective DO CLINs. The labor categories and rates for the Delivery Order Proposal shall be based on the completed Tab 13 which becomes the Section J "Attachment 7 Rates" at contract award. The total CLIN price will be added to Tab 12 - TEP as described below. For bidding purposes the Delivery Order start date will be 1 May 2019. The Government reserves the right to award earlier or later than 1 May 2019. These CLINs are Option CLINS that will be evaluated within the TEP and executed either at award or later than award based on the timing. (For these Tabs, insert a zero in the rate if you are not utilizing a particular category/skill level for performance within each CLIN.)
11. (Tab 9 DO CLIN 0500 Travel): Each Offeror shall propose the estimated costs associated with the DO SOW Table 3 Travel. The proposed amount shall only include travel expenses not labor hours. The Total Travel amount proposed will carry forward to the Column titled "Offeror's Total Proposed Amount" in Tab 12 TEP for the respective DO CLIN 0500. For planning and evaluation purposes, the offeror shall split the costs for this CLIN evenly across both years and apply the applicable rates in accordance with the offeror's accounting system. The Government reserves the right to award earlier or later than 1 May 2019. This CLIN is an Option CLIN that will be evaluated within the TEP and executed either at award or later than award based on the timing.
12. (Tab 10 DO CLIN 0600 Material): Each Offeror shall propose the estimated costs associated with the DO SOW paragraph 2.5 Materials: The Total Material amount proposed will carry forward to the Column titled "Offeror's Total Proposed Amount" in Tab 12 TEP for the respective DO CLIN 0600. The Government anticipates the material being purchased as soon as possible upon award, therefore account for these costs within 2019 and apply the applicable rates in accordance with the offeror's accounting system. The Government reserves the right to award earlier or later than 1 May 2019.
13. (Tab 11 DO CLIN 0800 Transition): Each Offeror shall utilize the BLRs from Tab 13 (2019) to propose Tab 11 as a Firm Fixed Price amount, and provide their proposed profit & COM (if applicable) rates and dollar value for executing Transition as outlined in the DO SOW paragraph 2.1. If the offeror has any additional direct costs the offeror shall indicate such near the bottom of the labor rates and provide a narrative. The Total amount proposed for Transition will carry forward to the Column titled "Offeror's Total Proposed Amount" in Tab 12 TEP for the respective DO CLIN 0800. The Government reserves the right to award earlier or later than 1 May 2019. (For this Tab, insert a zero in the rate if you are not utilizing a particular category/skill level for performance within this CLIN.)
Specific Instructions continued.
14. (Tab 12 - Total Evaluated Price (TEP)): On the TEP Tab, the Offeror shall carry forward the numbers discussed above on all the previous tabs to the column titled "Offeror's Total Proposed Amount (TPA)"

For evaluation purposes, the Government will validate the TPA for consistency in carrying forward the numbers. Additionally, the Government will determine a Probable Cost (PC) and may, if applicable, make adjustments, in the column titled "PC Adjustment Amount," to the Offeror's TPA. The calculation for the TEP is the sum of all the rows (Tab 1 thru Tab 11) to include the T&M NTE amount for the column "Offeror's Total Proposed Amount (TPA)" plus any "PC Adjustment Amount."

15. Tab 13 - Section J Attachment 7 Rates: On the Section J Attachment 7 Rates: The offeror shall carry forward the BLRs for each proposed Labor Category/Skill level, CPFF fee rate, COM, FBLRs for each proposed labor category/skill level and indirect rates as described in the previous tabs. This will become the Section J Attachment 7 Rates for the first three years of the contract. All DOs shall be based on the established ceiling rates.

&12FA8681-18-R-0006 DRFP

Section J - Atch 17 WPS Cost Spreadsheet

Tab 1 - BLR YEAR 1 Tab 1 - Burdened Labor Rate (BLR) Cost Element Summary Year 1 (2019) Representative of Basic IDIQ CLINs 0100, 0200, 0300, and 0400

SOC Labor Category/LevelOfferor Labor Category/Level (If applicable)2017 BLS Wage Data RateOfferor's 2017 Proposed Direct Labor RateProposed Escalation RateDirect Labor Rate ($)
2019Fringe RateFringe Cost ($)O/H
RateO/H
Cost ($)G&A
RateG&A Cost ($)Burdened Labor Rate (BLR)Government Labor HoursOfferor Evenly Distrubuted HoursTotal BLR Labor Costs
Example: Sr Software Developer$ 30.00$ 2,018.001920
Ex: Sr Software DeveloperEngineer 5$ 34.00X.X%$ 35.005%$1.755%$1.835%$1.90$40.48640$25,906.56
Ex: Sr Software DeveloperEngineer 4$ 29.00X.X%$ 30.005%$1.505%$1.585%$1.65$34.73640$22,226.56
Ex: Sr Software DeveloperSubcontractor A$ 32.005%$1.60$33.60640$21,504.00
Sr General and Operations ManagersThis calculation format is provided as a sample for your buildup. Please adjust according to your acounting procedures.309
General and Operations Managers Level 3722
General and Operations Managers Level 2722
General and Operations Managers Level 1309
Sr Computer and Information Systems Manager73
Computer and Information Systems Manager 3170
Computer and Information Systems Manager 2170
Computer and Information Systems Manager 173
Sr Financial Managers238
Financial Managers Level 3556
Financial Managers Level 2556
Financial Managers Level 1238
Sr Purchasing Managers178
Purchasing Managers Level 3415
Purchasing Managers Level 2415
Purchasing Managers Level 1178
Sr Architectural and Engineering Manager657
Architectural and Engineering Manager 31532
Architectural and Engineering Manager 21532
Architectural and Engineering Manager 1657
Sr Project Management Specialist276
Project Management Specialist 3644
Project Management Specialist 2644
Project Management Specialist 1276
Sr Computer Systems Analysts384
Computer Systems Analysts Level 3897
Computer Systems Analysts Level 2897
Computer Systems Analysts Level 1384
Sr Computer Programmer1327
Computer Programmer Level 33096
Computer Programmer Level 23096
Computer Programmer Level 11327
Sr Software Developer3096
Software Developer Level 37225
Software Developer Level 27225
Software Developer Level 13096
Sr Software Quality Assurance Analysts and Testers3458
Software Quality Assurance Analysts and Testers Level 38069
Software Quality Assurance Analysts and Testers Level 28069
Software Quality Assurance Analysts and Testers Level 13458
Sr Bookkeeping, Accounting, & Auditing Clerks38
Bookkeeping, Accounting, & Auditing Clerks Level 389
Bookkeeping, Accounting, & Auditing Clerks Level 289
Bookkeeping, Accounting, & Auditing Clerks Level 138
Sr Financial Clerks, All Others38
Financial Clerks, All Others Level 389
Financial Clerks, All Others Level 289
Financial Clerks, All Others Level 138
TOTALS671520
Total BLR Labor Cost Year 1 (excludes COM and Fee)$ - 0
Proposed Fee for CPFF 2019 (insert rate into Tab 13)_____%$ - 0
FCCOM (Total Labor Cost x COM Rate) (insert COM rate into Tab 13)____%$ - 0
BLR Year 1 Total$ - 0
Insert into Tab 12 as TPA for Tab 1

Tab 2 - BLR YEAR 2 Tab 2 - Burdened Labor Rate (BLR) Cost Element Summary Year 2 (2020) Representative of Basic IDIQ CLINs 0100, 0200, 0300, and 0400

SOC Labor Category/LevelOfferor Labor Category/Level2017 BLS Wage Data RateOfferor's 2017 Proposed Direct Labor RateProposed Escalation RateDirect Labor Rate ($)Fringe RateFringe Cost ($)O/H
RateO/H
Cost ($)G&A
RateG&A Cost ($)Burdened Labor Rate (BLR)Government Labor HoursOfferor Evenly Distrubuted HoursTotal BLR Costs
Example: Sr Software Developer$ 30.001920
Ex: Sr Software DeveloperEngineer 5$ 34.00X.X%$ 35.005%$1.755%$1.835%$1.90$40.48640$25,906.56
Ex: Sr Software DeveloperEngineer 4$ 29.00X.X%$ 30.005%$1.505%$1.585%$1.65$34.73640$22,226.56
Ex: Sr Software DeveloperSubcontractor A$ 32.005%$1.60$33.60640$21,504.00
Sr General and Operations ManagersThis calculation format is provided as a sample for your buildup. Please adjust according to your acounting procedures.309
General and Operations Managers Level 3722
General and Operations Managers Level 2722
General and Operations Managers Level 1309
Sr Computer and Information Systems Manager73
Computer and Information Systems Manager 3170
Computer and Information Systems Manager 2170
Computer and Information Systems Manager 173
Sr Financial Managers238
Financial Managers Level 3556
Financial Managers Level 2556
Financial Managers Level 1238
Sr Purchasing Managers178
Purchasing Managers Level 3415
Purchasing Managers Level 2415
Purchasing Managers Level 1178
Sr Architectural and Engineering Manager657
Architectural and Engineering Manager 31532
Architectural and Engineering Manager 21532
Architectural and Engineering Manager 1657
Sr Project Management Specialist276
Project Management Specialist 3644
Project Management Specialist 2644
Project Management Specialist 1276
Sr Computer Systems Analysts384
Computer Systems Analysts Level 3897
Computer Systems Analysts Level 2897
Computer Systems Analysts Level 1384
Sr Computer Programmer1327
Computer Programmer Level 33096
Computer Programmer Level 23096
Computer Programmer Level 11327
Sr Software Developer3096
Software Developer Level 37225
Software Developer Level 27225
Software Developer Level 13096
Sr Software Quality Assurance Analysts and Testers3458
Software Quality Assurance Analysts and Testers Level 38069
Software Quality Assurance Analysts and Testers Level 28069
Software Quality Assurance Analysts and Testers Level 13458
Sr Bookkeeping, Accounting, & Auditing Clerks38
Bookkeeping, Accounting, & Auditing Clerks Level 389
Bookkeeping, Accounting, & Auditing Clerks Level 289
Bookkeeping, Accounting, & Auditing Clerks Level 138
Sr Financial Clerks, All Others38
Financial Clerks, All Others Level 389
Financial Clerks, All Others Level 289
Financial Clerks, All Others Level 138
TOTALS671521920
BLR Total Labor Cost Year 2 (excludes COM and Fee)$ - 0
Proposed Fee for CPFF 2020 (insert rate into Tab 13)______%$ - 0
FCCOM (Total Labor Cost x COM Rate)(insert rate into Tab 13)____%$ - 0
BLR Year 2 Total$ - 0
Insert into Tab 12 as TPA for Tab 2

Tab 3 - BLR YEAR 3 Tab 3 - Burdened Labor Rate (BLR) Cost Element Summary Year 3 (2021) Representative of Basic IDIQ CLINs 0100, 0200, 0300, and 0400

SOC Labor Category/LevelOfferor Labor Category/Level2017 BLS Wage Data RateOfferor's 2017 Proposed Direct Labor RateProposed Escalation RateDirect Labor Rate ($)Fringe RateFringe Cost ($)O/H
RateO/H
Cost ($)G&A
RateG&A Cost ($)Burdened Labor Rate (BLR)Government Labor HoursOfferor Evenly Distrubuted HoursTotal BLR Costs
Example: Sr Software Developer$ 30.001920
Ex: Sr Software DeveloperEngineer 5$ 34.00X.X%$ 35.005%$1.755%$1.835%$1.90$40.48640$25,906.56
Ex: Sr Software DeveloperEngineer 4$ 29.00X.X%$ 30.005%$1.505%$1.585%$1.65$34.73640$22,226.56
Ex: Sr Software DeveloperSubcontractor A$ 32.005%$1.60$33.60640$21,504.00
Sr General and Operations ManagersThis calculation format is provided as a sample for your buildup. Please adjust according to your acounting procedures.309
General and Operations Managers Level 3722
General and Operations Managers Level 2722
General and Operations Managers Level 1309
Sr Computer and Information Systems Manager73
Computer and Information Systems Manager 3170
Computer and Information Systems Manager 2170
Computer and Information Systems Manager 173
Sr Financial Managers238
Financial Managers Level 3556
Financial Managers Level 2556
Financial Managers Level 1238
Sr Purchasing Managers178
Purchasing Managers Level 3415
Purchasing Managers Level 2415
Purchasing Managers Level 1178
Sr Architectural and Engineering Manager657
Architectural and Engineering Manager 31532
Architectural and Engineering Manager 21532
Architectural and Engineering Manager 1657
Sr Project Management Specialist276
Project Management Specialist 3644
Project Management Specialist 2644
Project Management Specialist 1276
Sr Computer Systems Analysts384
Computer Systems Analysts Level 3897
Computer Systems Analysts Level 2897
Computer Systems Analysts Level 1384
Sr Computer Programmer1327
Computer Programmer Level 33096
Computer Programmer Level 23096
Computer Programmer Level 11327
Sr Software Developer3096
Software Developer Level 37225
Software Developer Level 27225
Software Developer Level 13096
Sr Software Quality Assurance Analysts and Testers3458
Software Quality Assurance Analysts and Testers Level 38069
Software Quality Assurance Analysts and Testers Level 28069
Software Quality Assurance Analysts and Testers Level 13458
Sr Bookkeeping, Accounting, & Auditing Clerks38
Bookkeeping, Accounting, & Auditing Clerks Level 389
Bookkeeping, Accounting, & Auditing Clerks Level 289
Bookkeeping, Accounting, & Auditing Clerks Level 138
Sr Financial Clerks, All Others38
Financial Clerks, All Others Level 389
Financial Clerks, All Others Level 289
Financial Clerks, All Others Level 138
TOTALS671521920
BLR Total Labor Cost Year 3 (excludes COM and Fee)$ - 0
Proposed Fee for CPFF 2021 (insert rate into Tab 13)_____%$ - 0
FCCOM (Total Labor Cost x COM Rate) (insert COM rate into Tab 13)____%$ - 0
BLR Year 3 Total$ - 0
Insert into Tab 12 as TPA for Tab 3

Tab 4 - FBLR (T&M) YEAR 1 Tab 4 - Fully Burdened Labor Rates (FBLR) Cost Element Summary Year 1 (2019) Representative of Basic IDIQ CLIN 0700 (T&M)

SOC Labor Category/LevelOfferor Labor Category/LevelBurdened Labor Rate From Tab 1 (Excludes COM and Profit)Profit RateProfit ($)COM RateCOM
Cost ($)Fully Burdened Labor Rate (T&M Rate)Government Labor HoursOfferor Evenly Distrubuted HoursTotal FBLR Costs
Example: Sr Software Developer155
Ex: Sr Software DeveloperEngineer 5$40.485%$2.020.050%$0.02024$42.5252$2,211.21
Ex: Sr Software DeveloperEngineer 4$34.735%$1.740.050%$0.01737$36.4852$1,897.11
Ex: Sr Software DeveloperSubcontractor A$33.605%$1.680.050%$0.01680$35.3051$1,800.14
Sr General and Operations ManagersThis calculation format is provided as a sample for your buildup. Please adjust according to your acounting procedures.15
General and Operations Managers Level 336
General and Operations Managers Level 236
General and Operations Managers Level 115
Sr Computer and Information Systems Manager4
Computer and Information Systems Manager 39
Computer and Information Systems Manager 29
Computer and Information Systems Manager 14
Sr Financial Managers22
Financial Managers Level 328
Financial Managers Level 228
Financial Managers Level 112
Sr Purchasing Managers9
Purchasing Managers Level 321
Purchasing Managers Level 221
Purchasing Managers Level 19
Sr Architectural and Engineering Manager33
Architectural and Engineering Manager 377
Architectural and Engineering Manager 277
Architectural and Engineering Manager 133
Sr Project Management Specialist14
Project Management Specialist 332
Project Management Specialist 232
Project Management Specialist 114
Sr Computer Systems Analysts19
Computer Systems Analysts Level 345
Computer Systems Analysts Level 245
Computer Systems Analysts Level 119
Sr Computer Programmer66
Computer Programmer Level 3155
Computer Programmer Level 2155
Computer Programmer Level 166
Sr Software Developer155
Software Developer Level 3361
Software Developer Level 2361
Software Developer Level 1155
Sr Software Quality Assurance Analysts and Testers173
Software Quality Assurance Analysts and Testers Level 3403
Software Quality Assurance Analysts and Testers Level 2403
Software Quality Assurance Analysts and Testers Level 1173
Sr Bookkeeping, Accounting, & Auditing Clerks2
Bookkeeping, Accounting, & Auditing Clerks Level 34
Bookkeeping, Accounting, & Auditing Clerks Level 24
Bookkeeping, Accounting, & Auditing Clerks Level 12
Sr Financial Clerks, All Others2
Financial Clerks, All Others Level 34
Financial Clerks, All Others Level 24
Financial Clerks, All Others Level 12
TOTALS3368155
(CLIN 0700) TIME AND MATERIAL Year 1
Total Labor Cost (TLC) including profit$ - 0
Material$ 5,000.00
Material Overhead (if applicable)%$ - 0
Material G&A (if applicable)%$ - 0
Material COM(if applicable)%$ - 0
Materials Cost$ - 0
Total T&M Year 1(TLC+Material Cost)$ - 0
Insert into Tab 12 as TPA for Tab 4

Tab 5 - FBLR (T&M) YEAR 2 Tab 5 - Fully Burdened Labor Rates (FBLR) Cost Element Summary Year 2 (2020) Representative of Basic IDIQ CLIN 0700 (T&M)

SOC Labor Category/LevelOfferor Labor Category/LevelBurdened Labor Rate From Tab 1 (Excludes COM and Profit)Profit RateProfit ($)COM RateCOM
Cost ($)Fully Burdened Labor Rate (T&M Rate)Government Labor HoursOfferor Evenly Distrubuted HoursTotal FBLR Costs
Example: Sr Software Developer155
Ex: Sr Software DeveloperEngineer 5$40.485%$2.020.050%$0.02024$42.5252$2,211.21
Ex: Sr Software DeveloperEngineer 4$34.735%$1.740.050%$0.01737$36.4852$1,897.11
Ex: Sr Software DeveloperSubcontractor A$33.605%$1.680.050%$0.01680$35.3051$1,800.14
Sr General and Operations ManagersThis calculation format is provided as a sample for your buildup. Please adjust according to your acounting procedures.15
General and Operations Managers Level 336
General and Operations Managers Level 236
General and Operations Managers Level 115
Sr Computer and Information Systems Manager4
Computer and Information Systems Manager 39
Computer and Information Systems Manager 29
Computer and Information Systems Manager 14
Sr Financial Managers22
Financial Managers Level 328
Financial Managers Level 228
Financial Managers Level 112
Sr Purchasing Managers9
Purchasing Managers Level 321
Purchasing Managers Level 221
Purchasing Managers Level 19
Sr Architectural and Engineering Manager33
Architectural and Engineering Manager 377
Architectural and Engineering Manager 277
Architectural and Engineering Manager 133
Sr Project Management Specialist14
Project Management Specialist 332
Project Management Specialist 232
Project Management Specialist 114
Sr Computer Systems Analysts19
Computer Systems Analysts Level 345
Computer Systems Analysts Level 245
Computer Systems Analysts Level 119
Sr Computer Programmer66
Computer Programmer Level 3155
Computer Programmer Level 2155
Computer Programmer Level 166
Sr Software Developer155
Software Developer Level 3361
Software Developer Level 2361
Software Developer Level 1155
Sr Software Quality Assurance Analysts and Testers173
Software Quality Assurance Analysts and Testers Level 3403
Software Quality Assurance Analysts and Testers Level 2403
Software Quality Assurance Analysts and Testers Level 1173
Sr Bookkeeping, Accounting, & Auditing Clerks2
Bookkeeping, Accounting, & Auditing Clerks Level 34
Bookkeeping, Accounting, & Auditing Clerks Level 24
Bookkeeping, Accounting, & Auditing Clerks Level 12
Sr Financial Clerks, All Others2
Financial Clerks, All Others Level 34
Financial Clerks, All Others Level 24
Financial Clerks, All Others Level 12
TOTALS3368155
(CLIN 0700) TIME AND MATERIAL Year 2
Total Labor Cost (TLC)$ - 0
Material$ 5,000.00
Material Overhead (if applicable)%$ - 0
Material G&A(if applicable)%$ - 0
Material COM(if applicable)%$ - 0
Materials Cost$ - 0
Total T&M Year 2(TLC+Material Cost)$ - 0
Insert into Tab 12 as TPA for Tab 5

Tab 6 - FBLR (T&M) YEAR 3 Tab 6 - Fully Burdened Labor Rates (FBLR) Cost Element Summary Year 3 (2021) Representative of Basic IDIQ CLIN 0700 (T&M)

SOC Labor Category/LevelOfferor Labor Category/LevelBurdened Labor Rate From Tab 1 (Excludes COM and Profit)Profit RateProfit ($)COM RateCOM
Cost ($)Fully Burdened Labor Rate (T&M Rate)Government Labor HoursOfferor Evenly Distrubuted HoursTotal FBLR Costs
Example: Sr Software Developer155
Ex: Sr Software DeveloperEngineer 5$40.485%$2.020.050%$0.02024$42.5252$2,211.21
Ex: Sr Software DeveloperEngineer 4$34.735%$1.740.050%$0.01737$36.4852$1,897.11
Ex: Sr Software DeveloperSubcontractorA$33.605%$1.680.050%$0.01680$35.3051$1,800.14
Sr General and Operations ManagersThis calculation format is provided as a sample for your buildup. Please adjust according to your acounting procedures.15
General and Operations Managers Level 336
General and Operations Managers Level 236
General and Operations Managers Level 115
Sr Computer and Information Systems Manager4
Computer and Information Systems Manager 39
Computer and Information Systems Manager 29
Computer and Information Systems Manager 14
Sr Financial Managers22
Financial Managers Level 328
Financial Managers Level 228
Financial Managers Level 112
Sr Purchasing Managers9
Purchasing Managers Level 321
Purchasing Managers Level 221
Purchasing Managers Level 19
Sr Architectural and Engineering Manager33
Architectural and Engineering Manager 377
Architectural and Engineering Manager 277
Architectural and Engineering Manager 133
Sr Project Management Specialist14
Project Management Specialist 332
Project Management Specialist 232
Project Management Specialist 114
Sr Computer Systems Analysts19
Computer Systems Analysts Level 345
Computer Systems Analysts Level 245
Computer Systems Analysts Level 119
Sr Computer Programmer66
Computer Programmer Level 3155
Computer Programmer Level 2155
Computer Programmer Level 166
Sr Software Developer155
Software Developer Level 3361
Software Developer Level 2361
Software Developer Level 1155
Sr Software Quality Assurance Analysts and Testers173
Software Quality Assurance Analysts and Testers Level 3403
Software Quality Assurance Analysts and Testers Level 2403
Software Quality Assurance Analysts and Testers Level 1173
Sr Bookkeeping, Accounting, & Auditing Clerks2
Bookkeeping, Accounting, & Auditing Clerks Level 34
Bookkeeping, Accounting, & Auditing Clerks Level 24
Bookkeeping, Accounting, & Auditing Clerks Level 12
Sr Financial Clerks, All Others2
Financial Clerks, All Others Level 34
Financial Clerks, All Others Level 24
Financial Clerks, All Others Level 12
TOTALS33680
(CLIN 0700) TIME AND MATERIAL Year 3
Total Labor Cost (TLC)$ - 0
Material$ 5,000.00
Material Overhead (if applicable)%$ - 0
Material G&A(if applicable)%$ - 0
Material COM(if applicable)%$ - 0
Materials Cost$ - 0
Total T&M Year 3(TLC+Material Cost)$ - 0
Insert into Tab 12 as TPA for Tab 6

Tab 7 - DO CLIN 0100 Total

Tab 7 - DO CLIN 0100 Software Development for 2019 TotalDO CLIN 0100 Software Development for 2020 Total
Labor Category/Level (As Necessary)WBS/BOE ReferenceBLR from Tab 13
2019Labor Hours (Input by Offeror)Total Costs (Before Fee)Labor Category/LevelWBS/BOE ReferenceBLR from Tab 13
2020Labor Hours (Input by Offeror)Total Costs (Before Fee)
Example: Sr Software Developer - Engineer 5$40.481920$77,721.60Example: Sr Software Developer - Engineer 5$40.481920$77,721.60
Ex: Sr Software Developer - Engineer 4$34.731920$66,681.60Ex: Sr Software Developer - Engineer 4$34.731920$66,681.60
Ex: Sr Software Developer - Subcontractor A$33.601920$64,512.00Ex: Sr Software Developer - Subcontractor A$33.601920$64,512.00
Sr General and Operations ManagersSr General and Operations Managers
General and Operations Managers Level 3General and Operations Managers Level 3
General and Operations Managers Level 2General and Operations Managers Level 2
General and Operations Managers Level 1General and Operations Managers Level 1
Sr Computer and Information Systems ManagerSr Computer and Information Systems Manager
Computer and Information Systems Manager 3Computer and Information Systems Manager 3
Computer and Information Systems Manager 2Computer and Information Systems Manager 2
Computer and Information Systems Manager 1Computer and Information Systems Manager 1
Sr Financial ManagersSr Financial Managers
Financial Managers Level 3Financial Managers Level 3
Financial Managers Level 2Financial Managers Level 2
Financial Managers Level 1Financial Managers Level 1
Sr Purchasing ManagersSr Purchasing Managers
Purchasing Managers Level 3Purchasing Managers Level 3
Purchasing Managers Level 2Purchasing Managers Level 2
Purchasing Managers Level 1Purchasing Managers Level 1
Sr Architectural and Engineering ManagerSr Architectural and Engineering Manager
Architectural and Engineering Manager 3Architectural and Engineering Manager 3
Architectural and Engineering Manager 2Architectural and Engineering Manager 2
Architectural and Engineering Manager 1Architectural and Engineering Manager 1
Sr Project Management SpecialistSr Project Management Specialist
Project Management Specialist 3Project Management Specialist 3
Project Management Specialist 2Project Management Specialist 2
Project Management Specialist 1Project Management Specialist 1
Sr Computer Systems AnalystsSr Computer Systems Analysts
Computer Systems Analysts Level 3Computer Systems Analysts Level 3
Computer Systems Analysts Level 2Computer Systems Analysts Level 2
Computer Systems Analysts Level 1Computer Systems Analysts Level 1
Sr Computer ProgrammerSr Computer Programmer
Computer Programmer Level 3Computer Programmer Level 3
Computer Programmer Level 2Computer Programmer Level 2
Computer Programmer Level 1Computer Programmer Level 1
Sr Software DeveloperSr Software Developer
Software Developer Level 3Software Developer Level 3
Software Developer Level 2Software Developer Level 2
Software Developer Level 1Software Developer Level 1
Sr Software Quality Assurance Analysts and TestersSr Software Quality Assurance Analysts and Testers
Software Quality Assurance Analysts and Testers Level 3Software Quality Assurance Analysts and Testers Level 3
Software Quality Assurance Analysts and Testers Level 2Software Quality Assurance Analysts and Testers Level 2
Software Quality Assurance Analysts and Testers Level 1Software Quality Assurance Analysts and Testers Level 1
Sr Bookkeeping, Accounting, & Auditing ClerksSr Bookkeeping, Accounting, & Auditing Clerks
Bookkeeping, Accounting, & Auditing Clerks Level 3Bookkeeping, Accounting, & Auditing Clerks Level 3
Bookkeeping, Accounting, & Auditing Clerks Level 2Bookkeeping, Accounting, & Auditing Clerks Level 2
Bookkeeping, Accounting, & Auditing Clerks Level 1Bookkeeping, Accounting, & Auditing Clerks Level 1
Sr Financial Clerks, All OthersSr Financial Clerks, All Others
Financial Clerks, All Others Level 3Financial Clerks, All Others Level 3
Financial Clerks, All Others Level 2Financial Clerks, All Others Level 2
Financial Clerks, All Others Level 1Financial Clerks, All Others Level 1
Other Direct Costs (ODC)RateUnitTotalOther Direct Costs (ODC)RateUnitTotal
Offeror insert as necessary in accordance with accounting practicesOfferor insert as necessary in accordance with accounting practices
Offeror insert as necessary in accordance with accounting practicesOfferor insert as necessary in accordance with accounting practices
Offeror insert as necessary in accordance with accounting practicesOfferor insert as necessary in accordance with accounting practices
TOTAL COST0$TOTAL COST0$
DO CLIN 0100 for 2019DO CLIN 0100 for 2020
Total Cost 2019 (Before Fee and COM)$ - 0Total Cost 2020 (Before Fee and COM)$ - 0
Fee (Excludes COM)%$ - 0Fee (Excludes COM)%$ - 0
COM%$ - 0COM%

Total DO CLIN 0100 for 2019 $ - 0 Total DO CLIN 0100 for 2020 $ - 0

Total DO CLIN 0100 for 2019$ - 0
Total DO CLIN 0100 for 2020$ - 0
Total DO CLIN 0100$ - 0Insert into Tab 12 as TPA for Tab 7

Tab 7a -DOSOW Table 1 - Task 1

Tab 7a - DO CLIN 0100 Software Development for 2019
DO SOW Table 1 - Task 1Tab 7a -DO CLIN 0100 Software Development for 2020

DO SOW Table 1 - Task 1

Labor Category/Level (As Necessary)WBS/BOE ReferenceBLR from Tab 13
2019Labor Hours (Input by Offeror)Total Costs (Before Fee)Labor Category/LevelWBS/BOE ReferenceBLR from Tab 13
2020Labor Hours (Input by Offeror)Total Costs (Before Fee)
Example: Sr Software Developer - Engineer 5$40.481920$77,721.60Example: Sr Software Developer - Engineer 5$40.481920$77,721.60
Ex: Sr Software Developer - Engineer 4$34.731920$66,681.60Ex: Sr Software Developer - Engineer 4$34.731920$66,681.60
Ex: Sr Software Developer - Subcontractor A$33.601920$64,512.00Ex: Sr Software Developer - Subcontractor A$33.601920$64,512.00
Sr General and Operations ManagersSr General and Operations Managers
General and Operations Managers Level 3General and Operations Managers Level 3
General and Operations Managers Level 2General and Operations Managers Level 2
General and Operations Managers Level 1General and Operations Managers Level 1
Sr Computer and Information Systems ManagerSr Computer and Information Systems Manager
Computer and Information Systems Manager 3Computer and Information Systems Manager 3
Computer and Information Systems Manager 2Computer and Information Systems Manager 2
Computer and Information Systems Manager 1Computer and Information Systems Manager 1
Sr Financial ManagersSr Financial Managers
Financial Managers Level 3Financial Managers Level 3
Financial Managers Level 2Financial Managers Level 2
Financial Managers Level 1Financial Managers Level 1
Sr Purchasing ManagersSr Purchasing Managers
Purchasing Managers Level 3Purchasing Managers Level 3
Purchasing Managers Level 2Purchasing Managers Level 2
Purchasing Managers Level 1Purchasing Managers Level 1
Sr Architectural and Engineering ManagerSr Architectural and Engineering Manager
Architectural and Engineering Manager 3Architectural and Engineering Manager 3
Architectural and Engineering Manager 2Architectural and Engineering Manager 2
Architectural and Engineering Manager 1Architectural and Engineering Manager 1
Sr Project Management SpecialistSr Project Management Specialist
Project Management Specialist 3Project Management Specialist 3
Project Management Specialist 2Project Management Specialist 2
Project Management Specialist 1Project Management Specialist 1
Sr Computer Systems AnalystsSr Computer Systems Analysts
Computer Systems Analysts Level 3Computer Systems Analysts Level 3
Computer Systems Analysts Level 2Computer Systems Analysts Level 2
Computer Systems Analysts Level 1Computer Systems Analysts Level 1
Sr Computer ProgrammerSr Computer Programmer
Computer Programmer Level 3Computer Programmer Level 3
Computer Programmer Level 2Computer Programmer Level 2
Computer Programmer Level 1Computer Programmer Level 1
Sr Software DeveloperSr Software Developer
Software Developer Level 3Software Developer Level 3
Software Developer Level 2Software Developer Level 2
Software Developer Level 1Software Developer Level 1
Sr Software Quality Assurance Analysts and TestersSr Software Quality Assurance Analysts and Testers
Software Quality Assurance Analysts and Testers Level 3Software Quality Assurance Analysts and Testers Level 3
Software Quality Assurance Analysts and Testers Level 2Software Quality Assurance Analysts and Testers Level 2
Software Quality Assurance Analysts and Testers Level 1Software Quality Assurance Analysts and Testers Level 1
Sr Bookkeeping, Accounting, & Auditing ClerksSr Bookkeeping, Accounting, & Auditing Clerks
Bookkeeping, Accounting, & Auditing Clerks Level 3Bookkeeping, Accounting, & Auditing Clerks Level 3
Bookkeeping, Accounting, & Auditing Clerks Level 2Bookkeeping, Accounting, & Auditing Clerks Level 2
Bookkeeping, Accounting, & Auditing Clerks Level 1Bookkeeping, Accounting, & Auditing Clerks Level 1
Sr Financial Clerks, All OthersSr Financial Clerks, All Others
Financial Clerks, All Others Level 3Financial Clerks, All Others Level 3
Financial Clerks, All Others Level 2Financial Clerks, All Others Level 2
Financial Clerks, All Others Level 1Financial Clerks, All Others Level 1
Other Direct Costs (ODC)RateUnitTotalOther Direct Costs (ODC)RateUnitTotal
Offeror insert as necessary in accordance with accounting practicesOfferor insert as necessary in accordance with accounting practices
Offeror insert as necessary in accordance with accounting practicesOfferor insert as necessary in accordance with accounting practices
Offeror insert as necessary in accordance with accounting practicesOfferor insert as necessary in accordance with accounting practices
TOTAL COST0$TOTAL COST0$
DO CLIN 0100 Table 1 Task 1 for 2019DO CLIN 0100 Table 1 Task 1 for 2020
Total DO SOW Table 1 Task 1 for 2019 (Before Fee and COM)$ - 0Total DO SOW Table 1 Task 1 for 2020 (Before Fee and COM)$ - 0
Fee (Excludes COM)%$ - 0Fee (Excludes COM)%$ - 0
COM%$ - 0COM%

Total DO SOW Table 1 Task 1 for 2019 $ - 0 Total DO SOW Table 1 Task 1 for 2020 $ - 0

Total DO SOW Table 1 Task 1 for 2019$ - 0
Total DO SOW Table 1 Task 1 for 2020$ - 0
Total DO SOW Table 1 Task 1$ - 0

Tab 7b-DOSOW Table 1 - Task 2

Tab 7b - DO CLIN 0100 Software Development for 2019
DO SOW Table 1 - Task 2Tab 7b- DO CLIN 0100 Software Development for 2020

DO SOW Table 1 - Task 2

Labor Category/Level (As Necessary)WBS/BOE ReferenceBLR from Tab 13
2019Labor Hours (Input by Offeror)Total Costs (Before Fee)Labor Category/LevelWBS/BOE ReferenceBLR from Tab 13
2020Labor Hours (Input by Offeror)Total Costs (Before Fee)
Example: Sr Software Developer - Engineer 5$40.481920$77,721.60Example: Sr Software Developer - Engineer 5$40.481920$77,721.60
Ex: Sr Software Developer - Engineer 4$34.731920$66,681.60Ex: Sr Software Developer - Engineer 4$34.731920$66,681.60
Ex: Sr Software Developer - Subcontractor A$33.601920$64,512.00Ex: Sr Software Developer - Subcontractor A$33.601920$64,512.00
Sr General and Operations ManagersSr General and Operations Managers
General and Operations Managers Level 3General and Operations Managers Level 3
General and Operations Managers Level 2General and Operations Managers Level 2
General and Operations Managers Level 1General and Operations Managers Level 1
Sr Computer and Information Systems ManagerSr Computer and Information Systems Manager
Computer and Information Systems Manager 3Computer and Information Systems Manager 3

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated .