Attachment 2 - Pricing Workbook.xlsx
XLSX spreadsheet 254 KB Posted
- Solicitation number
- FA254926R0002
- Issued by
- Not on record
About this file
This is a Pricing Workbook in Excel format for the Civilian Guardian Course (CGC) Curriculum Development and Iteration solicitation (FA254926R0002). The workbook serves as the template for vendors to submit pricing proposals for developing a 40-hour, multi-modal curriculum and supporting instructional materials for the U.S. Air Force. The file enables vendors to structure their cost estimates for curriculum development activities including lesson creation, instructor guides, student materials, learning management system (LMS) configuration, and participation in all phases of curriculum development from pre-execution through post-execution, including mandatory government review and approval cycles.
The pricing template accommodates the accelerated four-month completion timeline and supports a full and open solicitation to all qualified vendors. Vendors must use this workbook to present their labor costs, material costs, space expert consultant fees, and other direct costs associated with building out the 40-hour foundational curriculum block with synchronous and asynchronous elements, plus the one-week capstone event featuring performance-based activities and instructor-led simulations. The pricing submission is critical given the compressed schedule and the requirement that all vendor-developed elements meet government specifications and receive formal approval prior to deployment in the government-provided LMS.
View the file
Other files
Show all 18
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
Start Here (Instructions)
COST MODEL INSTRUCTIONS
1. The Contractor and Subcontractors (if applicable) shall provide the cost/price proposal in the format similar to the one attached to this RFP. The deliverable document shall include accessible cell formulas and shall not be password protected.
2. Below are the contents and instructions for the attached Cost Model template.
Tab A – Cover Sheet – Self Explanatory.
Tab B – List all key ground rules and assumptions that have significant impact on the proposed cost and pricing.
Tab 1 Summary – Please organize the pricing summary by Contract Line Item Numbers (CLINs), and by cost elements as shown in the summary tab. The aggregate cost/pricing information shall be corelated from the corresponding data in tabs 2A and 2B. Ensure clarity and accuracy in capturing the sum of the cost elements associated with each CLIN.
Tab 2A Cost Breakdown by CLINS – Please furnish a detailed breakdown summarizing costs by element for each Contract Line Item Number (CLIN) individually, such as CLINs 0001, 0002, etc., adhering to the structure outlined in tab 2A. Kindly include additional rows as necessary to accommodate all applicable cost elements for each CLIN.
Tab 2B Cost Breakdown by Site Location – If performance is at multiple site locations, Please provide a comprehensive breakdown, delineating costs by element for each site location individually. Specifically, include details for locations such as Location 1 - Colorado Springs, CO, Location 2 - Remote, etc., ensuring adherence to the structured format outlined in tab 2B. Kindly include additional rows as necessary to accommodate all applicable cost elements for each respective site location.
Tab 3 – Bill of Materials - If other direct costs are not baselined, kindly present a Bill of Materials. This should entail a thorough identification of the purchase period, the corresponding Contract Line Item Number (CLIN) under which the purchase will be charged, and the specific site location where the materials will be utilized. Provide a detailed breakdown of items including part number, part name, description, quantity, unit price, total amount, and the source of estimate. Additionally, incorporate vendor-written quotes or screenshots of material quotes within the cost narrative. Kindly include additional rows as necessary to capture all materials.
Tab 4 – Travel- If other direct costs are not baselined, provide a summary of all travel. This should entail a thorough identification of the travel period, the corresponding Contract Line Item Number (CLIN) under which the travel will be charged. For each trip, specify the purpose, number of trips, origin, destination(s), duration, and the number of travelers. Additionally, provide a detailed breakdown of all travel costs, encompassing airfare, per diem, car rental, and any other relevant expenses. Kindly include additional rows as necessary to capture additional trips.
Tab 5 – Labor Mapping - The Contractor and Subcontractors (if applicable) shall map the proposed labor positions and rates with ongoing Collective Bargaining Agreement (CBA) rate or Service Contract Act Wage Determination (SCA WD) rate and with Economic Research Institute (ERI) using a format similar to the one shown in tab 5.
Tab 6 – Rates and Factors – The Contractor and Subcontractors (if applicable) shall furnish details of Direct and Indirect rates utilized, including profit/fee rate, organized by contractor fiscal year in developing the proposal. It is essential to corelate these rates and factors with those employed in creating the cost breakout outlined in tab 2A and 2B.
A-Cover Sheet
COVER SHEET
1. Solicitation Number
2. Name and Address of Offeror including CAGE Code
3. Name, telephone number and email address of authorized representative
4. Name, telephone number and email address of Contract Administration Office (if applicable)
5. Name, telephone number and email address of Cognizant Federal Agency (if applicable)
| 6. List the business names with CAGE code of | |||
| proposed Sub-Contractors with dollar values (if applicable) | PROPOSED SUBCONTRACRORS & | ||
| CAGE Code | Proposed |
$ Amount
TOTAL SUBCONTRACTED $ - 0
| 9. Date of proposal submission and | ||
| proposal validity statement. | Submitted: |
Period of Validity: 90 Days
10. Name, title, and signature of authorized representative.
B-Ground Rules and Assumptions
The offeror shall include a listing of all Key Ground Rules and Assumptions that have significant impacts on the proposed cost and pricing.
Per RFP instructions: The proposal shall include a brief narrative describing the assumptions considered in their price buildup, and explanation for any price fluctuations or suggestions used in the unit prices.
Offeror's Narrative:
1-Summary
Summary by CLINs Summary by CLINs EXAMPLE
| CLINs | Base Period | Total | CLINs | Base Period | Total |
| CLIN 0001 | CLIN 0001 | $1,000.00 | $1,000.00 | ||
| CLIN 0002 | CLIN 0002 | $1,000.00 | $1,000.00 | ||
| CLIN 0003 | CLIN 0003 | $1,000.00 | $1,000.00 | ||
| CLIN 0004 | CLIN 0004 | $1,000.00 | $1,000.00 | ||
| CLIN 0005 | CLIN 0005 | $1,000.00 | $1,000.00 | ||
| CLIN 0006 | CLIN 0006 | $1,000.00 | $1,000.00 | ||
| Total | $0.00 | Total | $6,000.00 |
Summary by Performance Sites Summary by Performance Sites EXAMPLE
| LOCATIONS | Base Period | Total | LOCATIONS | Base Period | Total |
| Colorado Springs, CO | $1,000.00 | $1,000.00 | |||
| Remote | $2,000.00 | $2,000.00 | |||
| Total | $0.00 | $0.00 | Total | $3,000.00 | $3,000.00 |
| Summary by Cost Elements | |
| Cost Element | Total Amount |
| Direct Labor | |
| Fringe | |
| Labor Overhead | |
| Subtotal | |
| Subcontractor Costs |
Direct Labor Subcontractor Costs G&A Consultant Costs (List all consultants costs separately. Add or insert more rows below to include additional Consultants)
| Other Direct Costs |
| Subcontracts/Material Overhead |
| Subtotal |
| G&A |
| Total Costs |
| Fee/Profit |
| Gross Receipts Taxes |
(If applicable) Total Price $ - 0
2A-Cost Breakdown by CLINs COST BREAKDOWN BY CLINs COST BREAKDOWN BY CLINs Example
| CLIN 0001 - Design, Develop, and Iterate CGC Program Guardian Fundamentals Curriculum | CLIN 0001 | ||||||
| Cost Elements | Base Period | TOTAL | |||||
| (Base + All Option Period) | Cost Elements | Base Period | TOTAL |
(Base + All Option Period)
| Base | Rate | $ Amount | Base | Rate | $ Amount | Base | Rate | $ Amount | Base | Rate | $ Amount | ||||
| Design, Develop, and Iterate CGC Program Guardian Fundamentals Curriculum | Design, Develop, and Iterate CGC Program Guardian Fundamentals Curriculum | 1480 | $ 79.33 | $ 117,408.40 | 1480 | $ 79.33 | $ 117,408.40 | ||||||||
| Fringe | $ 196,917.65 | $ 196,917.65 | |||||||||||||
| Subtotal | Subtotal | $ 314,326.05 | $ 314,326.05 | ||||||||||||
| Subcontracts | |||||||||||||||
| (List all subcontractors costs separately. Add or insert more rows below to include additional subcontractors) | Subcontracts |
(List all subcontractors costs separately. Add or insert more rows below to include additional subcontractors)
| Subtotal | Subtotal | $ 314,326.05 | $ 314,326.05 | ||
| G&A | G&A | $ 158,041.94 | $ 158,041.94 | ||
| Total Costs | Total Costs | $ 472,367.99 | $ 472,367.99 | ||
| Fee/Profit | Fee/Profit | $ 115,139.17 | $ 115,139.17 | ||
| Gross Receipts Taxes | |||||
| (If applicable) | Gross Receipts Taxes |
Total Price $ - 0 $ - 0 Total Price $ 587,507.16 $ 587,507.16
| CLIN 0002 -Materials and Other Direct Costs (ODC) IAW PWS | ||
| Cost Elements | Base Period | TOTAL |
(Base + All Option Period)
| Base | Rate | $ Amount | Base | Rate | $ Amount | |
| Materials and Other Direct Costs (ODC) IAW PWS | ||||||
| Fringe | ||||||
| Subtotal | ||||||
| Subcontracts |
(List all subcontractors costs separately. Add or insert more rows below to include additional subcontractors)
| Subtotal |
| G&A |
| Total Costs |
| Fee/Profit |
| Gross Receipts Taxes |
(If applicable) Total Price $ - 0 $ - 0
| CLIN 0003 - Contract Program Manager | ||
| Cost Elements | Base Period | TOTAL |
(Base + All Option Period)
| Base | Rate | $ Amount | Base | Rate | $ Amount | |
| Prime Direct Labor |
(List all labor categories separately, including exempt and non-exempt positions. Add or insert more rows below to include additional labor categories)
| Fringe |
| Labor Overhead |
| Subtotal |
| Subcontracts |
(List all subcontractors costs separately. Add or insert more rows below to include additional subcontractors)
| Subtotal |
| G&A |
| Total Costs |
| Fee/Profit |
| Gross Receipts Taxes |
(If applicable) Total Price $ - 0 $ - 0
| CLIN 0004 - Multi-Media Specialist IAW PWS 2.3 | ||
| Cost Elements | Base Period | TOTAL |
(Base + All Option Period)
| Base | Rate | $ Amount | Base | Rate | $ Amount | |
| Prime Direct Labor |
(List all labor categories separately, including exempt and non-exempt positions. Add or insert more rows below to include additional labor categories)
| Fringe |
| Labor Overhead |
| Subtotal |
| Subcontracts |
(List all subcontractors costs separately. Add or insert more rows below to include additional subcontractors)
| Subtotal |
| G&A |
| Total Costs |
| Fee/Profit |
| Gross Receipts Taxes |
(If applicable) Total Price $ - 0 $ - 0
| CLIN 0005 - Instructional System Design Specialist IAW PWS 2.3 | ||
| Cost Elements | Base Period | TOTAL |
(Base + All Option Period)
| Base | Rate | $ Amount | Base | Rate | $ Amount | |
| Prime Direct Labor |
(List all labor categories separately, including exempt and non-exempt positions. Add or insert more rows below to include additional labor categories)
| Fringe |
| Labor Overhead |
| Subtotal |
| Subcontracts |
(List all subcontractors costs separately. Add or insert more rows below to include additional subcontractors)
| Subtotal |
| G&A |
| Total Costs |
| Fee/Profit |
| Gross Receipts Taxes |
(If applicable) Total Price $ - 0 $ - 0
| CLIN 0006 - Space Subject Matter Expert IAW PWS 2.3 | ||
| Cost Elements | Base Period | TOTAL |
(Base + All Option Period)
| Base | Rate | $ Amount | Base | Rate | $ Amount | |
| Prime Direct Labor |
(List all labor categories separately, including exempt and non-exempt positions. Add or insert more rows below to include additional labor categories)
| Fringe |
| Labor Overhead |
| Subtotal |
| Subcontracts |
(List all subcontractors costs separately. Add or insert more rows below to include additional subcontractors)
| Subtotal |
| G&A |
| Total Costs |
| Fee/Profit |
| Gross Receipts Taxes |
Total Price $ - 0 $ - 0
2B-Cost Breakdown by Location COST BREAKDOWN BY PERFORMANCE LOCATION COST BREAKDOWN BY PERFORMANCE LOCATION EXAMPLE
| Colorado Springs, CO | Colorado Springs, CO | ||||||
| Cost Elements | Base Period | TOTAL | |||||
| (Base + All Option Period) | Cost Elements | Base Period | TOTAL |
(Base + All Option Period)
| Base | Rate | $ Amount | Base | Rate | $ Amount | Base | Rate | $ Amount | Base | Rate | $ Amount | ||
| Prime Direct Labor | |||||||||||||
| (List all labor categories separately, including exempt and non-exempt positions. Add or insert more rows below to include additional labor categories) | Prime Direct Labor |
(List all labor categories separately, including exempt and non-exempt positions. Add or insert more rows below to include additional labor categories)
| CGC PM/Space Operations SME | CGC PM/Space Operations SME | 1480 | $ 76.92 | $ 113,841.60 | 1480 | $ 76.92 | $ 113,841.60 | ||
| Fringe | Fringe | $ 41,267.58 | $ 41,267.58 | ||||||
| Labor Overhead | Labor Overhead | $ 14,130.45 | $ 14,130.45 | ||||||
| Subtotal | Subtotal | $ 169,239.63 | $ 169,239.63 | ||||||
| Subcontracts | |||||||||
| (List all subcontractors costs separately. Add or insert more rows below to include additional subcontractors) | Subcontracts |
(List all subcontractors costs separately. Add or insert more rows below to include additional subcontractors)
| Consultants | ||
| (List all consultants costs separately. Add or insert more rows below to include additional Consultants) | Consultants |
(List all consultants costs separately. Add or insert more rows below to include additional Consultants)
| Other Direct Costs | ||
| (List all Other Direct costs separately. Add or insert more rows below to include additional Other Direct Costs) | Other Direct Costs |
(List all Other Direct costs separately. Add or insert more rows below to include additional Other Direct Costs)
| Subcontracts/Material Overhead | ||
| (If applicable) | Subcontracts/Material Overhead |
(If applicable)
| Subtotal | Subtotal | $ 169,239.63 | $ 169,239.63 | ||
| G&A | G&A | $ 26,926.02 | $ 26,926.02 | ||
| Total Costs | Total Costs | $ 196,165.65 | $ 196,165.65 | ||
| Fee/Profit | Fee/Profit | $ 19,616.57 | $ 19,616.57 | ||
| Gross Receipts Taxes | |||||
| (If applicable) | Gross Receipts Taxes |
Total Price $ - 0 $ - 0 Total Price $ 215,782.22 $ 215,782.22
| Remote | Remote | ||||||
| Cost Elements | Base Period | TOTAL | |||||
| (Base + All Option Period) | Cost Elements | Base Period | TOTAL |
(Base + All Option Period)
| Base | Rate | $ Amount | Base | Rate | $ Amount | Base | Rate | $ Amount | Base | Rate | $ Amount | ||
| Prime Direct Labor | |||||||||||||
| (List all labor categories separately, including exempt and non-exempt positions. Add or insert more rows below to include additional labor categories) | Prime Direct Labor |
(List all labor categories separately, including exempt and non-exempt positions. Add or insert more rows below to include additional labor categories)
| CGC Multimedia Developer | CGC Multimedia Developer | 1480 | $ 59.13 | $ 87,512.40 | 1480 | $ 59.13 | $ 87,512.40 | ||
| CGC Curriculum Developer | CGC Curriculum Developer | 1480 | $ 59.13 | $ 87,512.40 | 1480 | $ 59.13 | $ 87,512.40 | ||
| CGC Curriculum Developer | CGC Curriculum Developer | 1480 | $ 59.13 | $ 87,512.40 | 1480 | $ 59.13 | $ 87,512.40 | ||
| CGC Civilian Guardian SME | CGC Civilian Guardian SME | 1480 | $ 72.12 | $ 106,737.60 | 1480 | $ 72.12 | $ 106,737.60 | ||
| CGC Civilian Guardian SME | CGC Civilian Guardian SME | 1480 | $ 72.12 | $ 106,737.60 | 1480 | $ 72.12 | $ 106,737.60 | ||
| Fringe | Fringe | $ 172,554.51 | $ 172,554.51 | ||||||
| Labor Overhead | Labor Overhead | $ 59,084.45 | $ 59,084.45 | ||||||
| Subtotal | Subtotal | $ 707,651.36 | $ 707,651.36 | ||||||
| Subcontracts | |||||||||
| (List all subcontractors costs separately. Add or insert more rows below to include additional subcontractors) | Subcontracts |
(List all subcontractors costs separately. Add or insert more rows below to include additional subcontractors)
| CGC LMS Administrator/ISD Lead | CGC LMS Administrator/ISD Lead | 1480 | $ 116.43 | $ 172,316.40 | 1480 | $ 116.43 | $ 172,316.40 | ||
| CGC Multimedia Developer | CGC Multimedia Developer | 1480 | $ 94.87 | $ 140,407.60 | 1480 | $ 94.87 | $ 140,407.60 | ||
| CGC Curriculum Developer | CGC Curriculum Developer | 1480 | $ 94.87 | $ 140,407.60 | 1480 | $ 94.87 | $ 140,407.60 | ||
| CGC Curriculum Developer | CGC Curriculum Developer | 1480 | $ 94.87 | $ 140,407.60 | 1480 | $ 94.87 | $ 140,407.60 | ||
| CGC Space Operations SME | CGC Space Operations SME | 1480 | $ 148.34 | $ 219,543.20 | 1480 | $ 148.34 | $ 219,543.20 | ||
| Consultants | |||||||||
| (List all consultants costs separately. Add or insert more rows below to include additional Consultants) | Consultants |
(List all consultants costs separately. Add or insert more rows below to include additional Consultants)
| Other Direct Costs | ||||
| (List all Other Direct costs separately. Add or insert more rows below to include additional Other Direct Costs) | Other Direct Costs | |||
| (List all Other Direct costs separately. Add or insert more rows below to include additional Other Direct Costs) | $ 8,627.38 | $ 8,627.38 | ||
| Subcontracts/Material Overhead | ||||
| (If applicable) | Subcontracts/Material Overhead |
(If applicable)
| Subtotal | Subtotal | $ 1,529,361.14 | $ 1,529,361.14 | ||
| G&A | G&A | $ 243,321.36 | $ 243,321.36 | ||
| Total Costs | Total Costs | $ 1,772,682.50 | $ 1,772,682.50 | ||
| Fee/Profit | Fee/Profit | $ 176,268.25 | $ 176,268.25 | ||
| Gross Receipts Taxes | |||||
| (If applicable) | Gross Receipts Taxes |
Total Price $ - 0 $ - 0 Total Price $ 1,948,950.75 $ 1,948,950.75
3-Bill of Materials
MATERIALS, SUPPLIES & OTHER DIRECT COSTS
| Contract Period | |||||||||||||
| (Base/Option Period #) | CLIN # | Site Location | Part Number | Part Name | Description | Quantity | $ Unit Cost | $ G&A | $ Amount | ||||
| BASE | 4909 | Peterson SFB | N/A | Refer to Vol 2 Section 3.1 | Refer to Vol 2 Section 3.1 | 1 | $ 17,254.77 | $ 2,745.23 | $ 20,000.00 | ||||
| Base | 0002 | Colorado | Example | Example |
6. Rates and Factors
Offeror shall use RATES and FACTORS tab to clearly identify Direct, Indirect Rates and Profit/fee rate used to develop the proposal.
It is essential to corelate these rates and factors with those employed in creating the cost breakout outlined in tab 2A and 2B.
Example Escalation rate on Direct Labor
Example Direct Rates Exempt/Non Exempt (if non-exempt list CBA or SCA) HARIYANI, HARSH CIV USAF AFMC AFRL/RDKB: Collective Barganing Agreement (CBA) or Service Contract Act Wage Determination (SCA WD)
| Performance | |||||||
| Location | Phase In | Base Year | |||||
| CGC PM/Space Operations SME | Exempt | Remote | N/A | $ 76.92 | |||
| CGC Multimedia Developer | Exempt | Remote | N/A | $ 59.13 | |||
| CGC Curriculum Developer | Exempt | Remote | N/A | $ 59.13 | |||
| CGC Civilian Guardian SME | Exempt | Remote | N/A | $ 72.12 | |||
| CGC Curriculum Developer | Exempt | Remote | N/A | $ 94.87 | |||
| CGC Space Operations SME | Exempt | Remote | N/A | $ 148.34 |
| Example | Indirect Rates | Contractor Fiscal Year (CFY) 2027 | CFY 2026 | ||||
| Fringe Rate (Exempt) | 36.25% | 36.54% | |||||
| Overhead Rate (Exempt) | 9.11% | 7.28% | |||||
| G&A Rate | 15.91% | 18.79% | |||||
| Material and Subcontractor handling | N/A | N/A | |||||
| CLIN 0001 | CLIN 0002 | CLIN 0003 | CLIN 004 | CLIN 0005 | CLIN 0006 | ||
| Example | Fee/Profit rate | 10% | 10% | 10% | 10% | 10% | 10% |
4-Travel
PROPOSED TRAVEL DETAILS
| Note 1: Please input only unit prices in columns K to R. |
| Note 2: Utilize columns P, Q, and R to document any additional costs that may be applicable. This includes miscellaneous expenses that may not have been accounted for in the primary columns. Ensure to change the header in these columns to explicitly specify the corresponding cost elements. |
| Contract Period | ||||||||||||||
| (Base/Option Period #) | CLIN # | From | To | Purpose | # of Trips | # of Tvlrs | # of Days | Per Diem | Lodging | Rental Car | Parking | Air Fare | POV Mileage @ $0.725/mile | Other costs |
| Miscellaneous | Other costs | |||||||||||||
| G&A | Total |
$ Amt.
Base CLIN 0003 Example Peterson SFB, CO Patrick SFB, FL 1 1 4 $74 $166 $125 $30 $1,000 $80 $25 $427 $3,112 HARIYANI, HARSH CIV USAF AFMC AFRL/RDKB: Formula in Place. DO NOT EDIT Base CLIN 0003
| HARIYANI, HARSH CIV USAF AFMC AFRL/RDKB: Formula in Place. DO NOT EDIT | Base | CLIN 0004 | |||
| Base | CLIN 0005 | ||||
| Base | CLIN 0006 | ||||
| $0 | |||||
| TOTAL | $0 |
5-Labor Mapping
The offeror shall map the proposed labor categories and rates with ongoing Collective Bargaining Agreement (CBA) rate or Service Contract Act Wage Determination (SCA WD) rate and with Economic Research Institute (ERI) using a format similar to the one shown below.
| Offeror Proposed | Map with CBA or SCA WD | Map with ERI | ||||
| Site Location | Contractor | Proposed | ||||
| Labor Position | Proposed |
Labor Rate
| (Unburdened) | Applicable |
| (CBA or SCA) | CBA or SCA |
| Labor Position | CBA or SCA |
Rate
| (Unburdened) | Geographical | |||
| Location | Contractor | ERI Labor Position | Experience |
Level (In years) Labor Rate (Unburdened)
| Peterson, SFB | Aleut | 319 CTS OTC DL Task Lead/Cyber SME | $ 79.33 | N/A | N/A | N/A | Colorado Springs, Colorado | Aleut | Program Manager (Government Contractor) | 8 | $ 75.67 |
| Colorado Springs, CO | ABC Company | CGC PM/Space Operations SME | Colorado Springs, Colorado | ABC Company | Spacecraft Operations Engineer | 8 | $ 73.34 | ||||
| Remote | CDE Company | CGC Space Operations SME | Remote Los Angeles | CDE Company | Space Operations S ME | 15 | $ 40.25 |
Note: When Comparing Column E to Column N -- Highlighted Yellow Cells in Column E Represent Sub-Hourly Rates and not Unburdened DL Rates.
File details come from the government source that posted it. Updated .