Attachment 2 - CLIN Structure KSA PSC r1 A00001 corrected.xlsx
XLSX spreadsheet 44 KB Posted
- Solicitation number
- W912ER22R0041
View the file
Other files
| File | Type | Posted |
|---|---|---|
| ProjNet Responses 20221011.pdf | ||
| Attachment 2 - CLIN Structure KSA PSC r1 A00001.xlsx | XLSX spreadsheet | |
| W912ER22R0041 AMD 0001.pdf | ||
| Attachment 6 - KSA PSC PRS r1 Sep22.pdf | ||
| Attachment 4 - Project List A00001.pdf | ||
| Bidder inquiry 20220929.pdf | ||
| Attachment 1 - Labor Category Worksheet KSA PSC r1 A00001.xls | XLS spreadsheet | |
| Attachment 4 - Project List.pdf | ||
| Solicitation W912ER22R0041.pdf | ||
| Attachment 1 - Price Break Down Workbook KSA PSC.xls | XLS spreadsheet | |
| Attachment 7 - Position Duty Descriptions.pdf | ||
| Attachment 3 - Flat Rate (travel) by Region.xlsx | XLSX spreadsheet | |
| Attachment 6 - KSA PSC PRS.pdf | ||
| Attachment 2 - CLIN Structure KSA PSC.xlsx | XLSX spreadsheet | |
| Attachment 5 - Map of KSA by region.pdf |
Show all 15
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
KSA PSC Att 2 CIN structure Attachment 2 - CLIN Structure, KSA Personal Services green cells indicate formulas and do not require contractor input
CLIN CLIN Description Quantity Unit of measure Unit Price Total Notes
| BASE | Base Year | |||||
| 0001 | Phase-In | |||||
| Phase-In activities in accordance with PWS 5.0 & 5.1 | 1 | Job | $ - 0 | $0.00 | ||
| 0002 | Personal Services - Base Year | |||||
| The base year ordering period starts on day 61 and ends on day 365. The Government may elect to order some or all of the services listed on Attachment 1, , SCLINs 0002AA-0002CR | 50,200 | hours | $ - 0 | $0.00 | From sample labor for award eval worksheet of Att 2 Workbook | |
| 0003 | Program Office Costs - Base Year | |||||
| Program Management Office (PMO) Support IAW PWS requirements to support Personal Services efforts. Reference PMO Worksheet in Attachment 1 & SCLINs 0003AA-0003AG | 10 | Months | $ - 0 | $0.00 | From PMO worksheet of Att 2 Workbook | |
| 0004 | Travel Costs - Base Year | |||||
| This is a not-to-exceed line item that includes costs associated with billeting/lodging, meals and other approved incidental expenses. For lodging and meals, flat rates, by region, will be negotiated for contract award. | 1 | Job | NTE | $225,000.00 | Government-Provided NTE Amount | |
| 0005 | Per Diem/Mileage - Base Year | |||||
| This is a not-to-exceed line item for mileage re-imbursement at .57/mile as established and defined in the PWS. | 1 | Job | NTE | $125,000.00 | Government-Provided NTE Amount | |
| 0006 | Unscheduled Overtime | |||||
| This is a not-to-exceed line item for unsecheduled overtime. Reference PWS 3.4.2. | 1 | Job | NTE | $10,000.00 | Government-Provided NTE Amount | |
| 0007 | Contractor Manpower Reporting - Base Year | |||||
| Contractor Manpower Reporting in accordance with contract requirements. | 1 | Job | $ - 0 | $0.00 | ||
| 0008 | Phase Out | |||||
| Phase-Out activities in accordance with PWS 5.0 & 5.2 | 1 | Job | $ - 0 | $0.00 | ||
| TOTAL BASE YEAR | $360,000.00 | |||||
| OY1 | Option Year 1: | |||||
| 1002 | Personal Services - Option Year 1 | |||||
| Pricing is established on the Price Breakdown Worksheet (Attachment 1). The base ordering period starts on day 61 and ends on day 365. The Government may elect to order some or all of the services listed on the Price Breakdown Worksheet SCLINs 1002AA-1002AS. | 60,400 | hours | $ - 0 | $0.00 | From sample labor for award eval worksheet of Att 2 Workbook | |
| 1003 | Program Office Costs - Option Year 1 | |||||
| Program Management Office (PMO) Support IAW PWS requirements to support Personal Services efforts. Reference PMO Worksheet in Attachment 1 | 12 | Months | $ - 0 | $0.00 | From PMO worksheet of Att 2 Workbook | |
| 1004 | Travel Costs - Option Year 1 | |||||
| This is a not-to-exceed line item that includes costs associated with billeting/lodging, meals and other approved incidental expenses per the contractors negotiated rates by region. For lodging and meals, flat rates, by region, will be negotiated for contract award. | 1 | Job | NTE | $250,000.00 | Government-Provided NTE Amount | |
| 1005 | Per Diem/Mileage - Option Year 1 | |||||
| This is a not-to-exceed line item for mileage re-imbursement at .57/mile as established and defined in the PWS. | 1 | Job | NTE | $150,000.00 | Government-Provided NTE Amount | |
| 1006 | Unscheduled Overtime | |||||
| This is a not-to-exceed line item for unsecheduled overtime. Reference PWS 3.4.2. | 1 | Job | NTE | $10,000.00 | Government-Provided NTE Amount | |
| 1007 | Contractor Manpower Reporting - Option Year 1 | |||||
| Contractor Manpower Reporting in accordance with contract requirements. | 1 | Job | $ - 0 | $0.00 | ||
| TOTAL OPTION YEAR 1 | $410,000.00 | |||||
| TOTAL BASE YEAR + OPTION YEAR | $770,000.00 | |||||
| 52.217-8 | 6 Month Extension of Services | |||||
| 2002 | Personal Services - 52.217-8 Ext of Services | |||||
| Pricing is established on the Price Breakdown Worksheet (Attachment 1). The base ordering period starts on day 61 and ends on day 365. The Government may elect to order some or all of the services listed on the Price Breakdown Worksheet, SCLINs 3002AA-3002AS. | 30,200 | days | $ - 0 | $0.00 | From sample labor for award eval worksheet of Att 2 Workbook | |
| 2003 | Program Office Costs - 52.217-8 Ext of Services | |||||
| Program Management Office (PMO) Support IAW PWS requirements to support Personal Services efforts. Reference PMO Worksheet in Attachment 1 | 6 | Months | $ - 0 | $0.00 | From PMO worksheet of Att 2 Workbook | |
| 2004 | Travel Costs - 52.217-8 Ext of Services | |||||
| This is a not-to-exceed line item that includes costs associated with billeting/lodging, meals and other approved incidental expenses per the contractors negotiated rates by region. For lodging and meals, flat rates, by region, will be negotiated for contract award. | 1 | Job | NTE | $125,000.00 | Government-Provided NTE Amount | |
| 2005 | Per Diem/Mileage - 52.217-8 Ext of Services | |||||
| This is a not-to-exceed line item for mileage re-imbursement at .57/mile as established and defined in the PWS. | 1 | Job | NTE | $75,000.00 | Government-Provided NTE Amount | |
| 2006 | Unscheduled Overtime | |||||
| This is a not-to-exceed line item for unsecheduled overtime. Reference PWS 3.4.2. | 1 | Job | NTE | $5,000.00 | Government-Provided NTE Amount | |
| 2007 | Contractor Manpower Reporting - 52.217-8 Ext of Services | |||||
| Contractor Manpower Reporting in accordance with contract requirements. | 1 | Job | $ - 0 | $0.00 | ||
| TOTAL EXT OF SERVICES | $205,000.00 | |||||
| TOTAL BASE YEAR + ALL OPTIONS, INCLUDING EXTENSION OF SERVICES (30 MONTHS TOTAL) | $975,000.00 |
sample labor for award eval Att 2 Sample Labor for Proposal Evaluation The below selected labor categories and quantities represent the table provided in PWS Para 3.2 for planning purposes
| PROJECT: KSA PSC SUPPORT SERVICES LABOR | green cells indicate formulas and do not require contractor input | PROPOSER: | ||||||
| LOCATION: SAUDI ARABIA | NOTE: Proposed prices in this worksheet should match the same as proposed on Attachment 1 for the 13 sample postions listed below | DATE: | ||||||
| ITEM | DESCRIPTION | ESTIMATED TOTAL LABOR MAN-HOURS | DIRECT LABOR COST | DIRECT EQUIPMENT COST | DIRECT MATERIALS COST | SUB CONTRACTOR COST | TOTAL |
DIRECT
COST OVERHEAD PROFIT TOTAL PROPOSED COST DAILY RATE PER POSITION
CLIN 0002 Base Year Support Services in accordance with the contract documents Man hours @ 2,008 hours = 1 FTE @ 2,088 hours (based on 6 8-hour days for 43.5 weeks) less 80 hours for 10 holidays.
NOTE: Since it is unknown when the holidays may occur within or outside the 60-day phase-in period depending on the award date, it is assumed for the purpose of the daily rate calculation that the holidays all occur outside the phase-in period.
| 0002AA | Administrative Assistant - LN | 2,008 | 0.00 | 0.00 | 0.00 | ||||||
| 0002AE | Cost Estimator - LN | 2,008 | 0.00 | 0.00 | 0.00 | ||||||
| 0002AG | Lead Engineer Assistant (LEA) - LN | 2,008 | 0.00 | 0.00 | 0.00 | ||||||
| 0002AL | Engineer Tech Asst Mid (Civil) - LN | 2,008 | 0.00 | 0.00 | 0.00 | ||||||
| 0002BL | Program Manager (PgM) Sr - LN | 2,008 | 0.00 | 0.00 | 0.00 | ||||||
| 0002BN | Program Manager (PgM) Mid - LN | 2,008 | 0.00 | 0.00 | 0.00 | ||||||
| 0002BS | Project Engineer Assistant (PEA) Sr - LN | 2,008 | 0.00 | 0.00 | 0.00 | ||||||
| 0002CA | Quality Assurance Rep (QAR) Sr - LN | 14,056 | 0.00 | 0.00 | 0.00 | ||||||
| 0002CC | Quality Assurance Rep (QAR) Mid - LN | 10,040 | 0.00 | 0.00 | 0.00 | ||||||
| 0002CE | Quality Assurance Rep (QAR) Jr - LN | 6,024 | 0.00 | 0.00 | 0.00 | ||||||
| 0002CJ | Safety Officer - LN | 2,008 | 0.00 | 0.00 | 0.00 | ||||||
| 0002CL | Translator/Interpreter - LN | 2,008 | 0.00 | 0.00 | 0.00 | ||||||
| 0002CN | Project Scheduler - LN | 2,008 | 0.00 | 0.00 | 0.00 | ||||||
| TOTAL Base Year (25 FTEs) | 50,200 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| 1002 | Option Year #1 Support Services in accordance with the contract documents | Man hours @ 2,416 hours = 1 FTE @ 2,496 hours (based on 6 8-hour days for 52 weeks) less 80 hours for 10 holidays | |||||||||
| 1002AA | Administrative Assistant - LN | 2,416 | $0.00 | $0.00 | $0.00 | ||||||
| 1002AE | Cost Estimator - LN | 2,416 | $0.00 | $0.00 | $0.00 | ||||||
| 1002AG | Lead Engineer Assistant (LEA) - LN | 2,416 | $0.00 | $0.00 | $0.00 | ||||||
| 1002AL | Engineer Tech Asst Mid (Civil) - LN | 2,416 | $0.00 | $0.00 | $0.00 | ||||||
| 1002BL | Program Manager (PgM) Sr - LN | 2,416 | $0.00 | $0.00 | $0.00 | ||||||
| 1002BN | Program Manager (PgM) Mid - LN | 2,416 | $0.00 | $0.00 | $0.00 | ||||||
| 1002BS | Project Engineer Assistant (PEA) Sr - LN | 2,416 | $0.00 | $0.00 | $0.00 | ||||||
| 1002CA | Quality Assurance Rep (QAR) Sr - LN | 16,912 | $0.00 | $0.00 | $0.00 | ||||||
| 1002CC | Quality Assurance Rep (QAR) Mid - LN | 12,080 | $0.00 | $0.00 | $0.00 | ||||||
| 1002CE | Quality Assurance Rep (QAR) Jr - LN | 7,248 | $0.00 | $0.00 | $0.00 | ||||||
| 1002CJ | Safety Officer - LN | 2,416 | $0.00 | $0.00 | $0.00 | ||||||
| 1002CL | Translator/Interpreter - LN | 2,416 | $0.00 | $0.00 | $0.00 | ||||||
| 1002CN | Project Scheduler - LN | 2,416 | $0.00 | $0.00 | $0.00 | ||||||
| TOTAL Option Year (25 FTEs) | 60,400 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | $0.00 | |
| 2002 | 6-Month Extension of Serices (52.217-8) in accordance with the contract documents | Man hours @ 1,208 hours = 1 FTE @ 1,248 hours (based on 6 8-hour days for 26 weeks) less 40 hours for 5 holidays; |
NOTE: Since it is unknown when the holidays may occur within or outside the 6-month Extension of Services period, depending on the award date, it is assumed for the purpose of the daily rate calculation that half of the holidays all occur during this period.
| 2002AA | Administrative Assistant - LN | 1,208 | $0.00 | $0.00 | $0.00 | ||||||
| 2002AE | Cost Estimator - LN | 1,208 | $0.00 | $0.00 | $0.00 | ||||||
| 2002AG | Lead Engineer Assistant (LEA) - LN | 1,208 | $0.00 | $0.00 | $0.00 | ||||||
| 2002AL | Engineer Tech Asst Mid (Civil) - LN | 1,208 | $0.00 | $0.00 | $0.00 | ||||||
| 2002BL | Program Manager (PgM) Sr - LN | 1,208 | $0.00 | $0.00 | $0.00 | ||||||
| 2002BN | Program Manager (PgM) Mid - LN | 1,208 | $0.00 | $0.00 | $0.00 | ||||||
| 2002BS | Project Engineer Assistant (PEA) Sr - LN | 1,208 | $0.00 | $0.00 | $0.00 | ||||||
| 2002CA | Quality Assurance Rep (QAR) Sr - LN | 8,456 | $0.00 | $0.00 | $0.00 | ||||||
| 2002CC | Quality Assurance Rep (QAR) Mid - LN | 6,040 | $0.00 | $0.00 | $0.00 | ||||||
| 2002CE | Quality Assurance Rep (QAR) Jr - LN | 3,624 | $0.00 | $0.00 | $0.00 | ||||||
| 2002CJ | Safety Officer - LN | 1,208 | $0.00 | $0.00 | $0.00 | ||||||
| 2002CL | Translator/Interpreter - LN | 1,208 | $0.00 | $0.00 | $0.00 | ||||||
| 2002CN | Project Scheduler - LN | 1,208 | $0.00 | $0.00 | $0.00 | ||||||
| TOTAL Ext of Services (25 FTEs) | 30,200 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | $0.00 | |
| TOTAL - Base + OY | 110,600 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | $0.00 | |
| TOTAL = Base + OY + Ext of Services | 140,800 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | $0.00 |
PMO
| PMO Worksheet | |||||||||
| NOTE: Please include all applicable and allowable PMO costs. Add rows if needed | |||||||||
| DESCRIPTION | ESTIMATED TOTAL LABOR MAN-HOURS | DIRECT LABOR COST | DIRECT EQUIPMENT COST | DIRECT MATERIALS COST | SUB CONTRACTOR COST | TOTAL DIRECT COST | OVERHEAD | PROFIT | TOTAL PROPOSED COST |
| Base Year Program Office Costs (PMO) in accordance with the contract documents | ||||||||||
| List est hours below | ||||||||||
| List Position Description here | $0.00 | $0.00 | ||||||||
| List Position Description here | $0.00 | $0.00 | ||||||||
| List Position Description here | $0.00 | $0.00 | ||||||||
| List Position Description here | $0.00 | $0.00 | ||||||||
| List Position Description here | $0.00 | $0.00 | ||||||||
| List Position Description here | $0.00 | $0.00 | ||||||||
| List Position Description here | $0.00 | $0.00 | ||||||||
| List Position Description here | $0.00 | $0.00 | ||||||||
| add more positions if needed | $0.00 | $0.00 | ||||||||
| add more positions if needed | $0.00 | $0.00 | ||||||||
| add more positions if needed | $0.00 | $0.00 | ||||||||
| Lodging/LSA | $0.00 | $0.00 | ||||||||
| Vehicles | $0.00 | $0.00 | ||||||||
| R&R Flights | $0.00 | $0.00 | ||||||||
| Office Lease | $0.00 | $0.00 | ||||||||
| Other Lease(s) | $0.00 | $0.00 | ||||||||
| Peripherals | $0.00 | $0.00 | ||||||||
| Communications - Phone | $0.00 | $0.00 | ||||||||
| Communications - Internet | $0.00 | $0.00 | ||||||||
| Offie Supplies | $0.00 | $0.00 | ||||||||
| Insurance | $0.00 | $0.00 | ||||||||
| Other | $0.00 | $0.00 | ||||||||
| Other | $0.00 | $0.00 | ||||||||
| Other | $0.00 | $0.00 | ||||||||
| Other | $0.00 | $0.00 | ||||||||
| Other | $0.00 | $0.00 | Mo Cost | |||||||
| TOTAL PMO BASE YEAR | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
DESCRIPTION ESTIMATED TOTAL LABOR MAN-HOURS DIRECT LABOR COST DIRECT EQUIPMENT COST DIRECT MATERIALS COST SUB CONTRACTOR COST TOTAL DIRECT COST OVERHEAD PROFIT TOTAL PROPOSED COST
| Option Year Program Office Costs (PMO) in accordance with the contract documents | ||||||||||
| List est hours below | ||||||||||
| List Position Description here | $0.00 | $0.00 | ||||||||
| List Position Description here | $0.00 | $0.00 | ||||||||
| List Position Description here | $0.00 | $0.00 | ||||||||
| List Position Description here | $0.00 | $0.00 | ||||||||
| List Position Description here | $0.00 | $0.00 | ||||||||
| List Position Description here | $0.00 | $0.00 | ||||||||
| List Position Description here | $0.00 | $0.00 | ||||||||
| List Position Description here | $0.00 | $0.00 | ||||||||
| add more positions if needed | $0.00 | $0.00 | ||||||||
| add more positions if needed | $0.00 | $0.00 | ||||||||
| add more positions if needed | $0.00 | $0.00 | ||||||||
| Lodging/LSA | $0.00 | $0.00 | ||||||||
| Vehicles | $0.00 | $0.00 | ||||||||
| R&R Flights | $0.00 | $0.00 | ||||||||
| Office Lease | $0.00 | $0.00 | ||||||||
| Other Lease(s) | $0.00 | $0.00 | ||||||||
| Peripherals | $0.00 | $0.00 | ||||||||
| Communications - Phone | $0.00 | $0.00 | ||||||||
| Communications - Internet | $0.00 | $0.00 | ||||||||
| Offie Supplies | $0.00 | $0.00 | ||||||||
| Insurance | $0.00 | $0.00 | ||||||||
| Other | $0.00 | $0.00 | ||||||||
| Other | $0.00 | $0.00 | ||||||||
| Other | $0.00 | $0.00 | ||||||||
| Other | $0.00 | $0.00 | ||||||||
| Other | $0.00 | $0.00 | ||||||||
| TOTAL PMO OPTION YEAR | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
DESCRIPTION ESTIMATED TOTAL LABOR MAN-HOURS DIRECT LABOR COST DIRECT EQUIPMENT COST DIRECT MATERIALS COST SUB CONTRACTOR COST TOTAL DIRECT COST OVERHEAD PROFIT TOTAL PROPOSED COST
| Extension of Services Program Office Costs (PMO) in accordance with the contract documents | ||||||||||
| List est hours below | ||||||||||
| List Position Description here | $0.00 | $0.00 | ||||||||
| List Position Description here | $0.00 | $0.00 | ||||||||
| List Position Description here | $0.00 | $0.00 | ||||||||
| List Position Description here | $0.00 | $0.00 | ||||||||
| List Position Description here | $0.00 | $0.00 | ||||||||
| List Position Description here | $0.00 | $0.00 | ||||||||
| List Position Description here | $0.00 | $0.00 | ||||||||
| List Position Description here | $0.00 | $0.00 | ||||||||
| add more positions if needed | $0.00 | $0.00 | ||||||||
| add more positions if needed | $0.00 | $0.00 | ||||||||
| add more positions if needed | $0.00 | $0.00 | ||||||||
| Lodging/LSA | $0.00 | $0.00 | ||||||||
| Vehicles | $0.00 | $0.00 | ||||||||
| R&R Flights | $0.00 | $0.00 | ||||||||
| Office Lease | $0.00 | $0.00 | ||||||||
| Other Lease(s) | $0.00 | $0.00 | ||||||||
| Peripherals | $0.00 | $0.00 | ||||||||
| Communications - Phone | $0.00 | $0.00 | ||||||||
| Communications - Internet | $0.00 | $0.00 | ||||||||
| Offie Supplies | $0.00 | $0.00 | ||||||||
| Insurance | $0.00 | $0.00 | ||||||||
| Other | $0.00 | $0.00 | ||||||||
| Other | $0.00 | $0.00 | ||||||||
| Other | $0.00 | $0.00 | ||||||||
| Other | $0.00 | $0.00 | ||||||||
| Other | $0.00 | $0.00 | ||||||||
| TOTAL PMO EXT OF SERVICES | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
TOTAL PMO BASE + OPTIONS 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
File details come from the government source that posted it. Updated .