CLIN ELIN Structure - Example.xlsx
XLSX spreadsheet 32 KB Posted
- Attached to
- Germany Wide Guards Request for Information Federal contract opportunity
- Solicitation number
- Not on record
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| GWG DRAFT EPA Clause .docx | DOCX document |
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Instructions
| INSTRUCTIONS: | |
| Please read the instructions in its entirety before proceeding to the other tabs. |
| 1 | Enter Company Name and Cage Code on the Rollup Tab |
| 2 | The Government has specified the required staffing for guards. Refer to Attachment 4 - Staffing Plan |
| 3 | You must manually enter the value for Phase-in as a total value on the Phase-in tab |
| 4 | Do not propose price for six-month extension period authorized by FAR 52.217-8. To account for price, the Government will take the price for all CLINs of Year 7, prorate it to a six-moth value, and add it to the sum of all CLINs for the whole effort. |
| 5 | For Option Period One (Years 4-7) the Economic Price Adjustment (EPA) is automatically calcluated at 3% for each year for the base guard labor pricing. Note: this is for evaluation purposes only and is not intended nor does it guarantee a 3% increase for years 4-7. The increase will be determined PRIOR to executing the EPA (if necessary) for years 4-7. There may be an upward or downward adjustment at that time prior to each EPA year. You shall input your proposed pricing for the management ELINs throughout all of the ordering periods as there is no adjustment to the management ELINs. |
| 6 | Complete Base Wage Tab for guard services for Years 1-3. This wage will be used to determine the EPA for Year 4. | |
| 7 | Rollup Tab will auto populate based on entries from all the tabs. | |
| 8 | The color code for the guard location tabs are below: | |
| Peach values must be completed by the contractor. | ||
| Green values will be calculated by the sheet. |
ROLLUP
Proposed Germany Wide Guard Services Contract IGCE
| Contractor Name: |
| CAGE: |
| CLIN | Phase-In | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Subtotal | |
| 0001 | USAG Ansbach |
0002 USAG Bavaria
0003 USAG Benelux
0004 USAG Rheinland-Pfalz
0005 USAG Stuttgart
0006 USAG Wiesbaden
0007 Coleman Barracks
0008 DISA/ECRC
0009 DLA Escort Patrol
0010 21st TSC
0011 USAFE
0012 USAREUR-AF G34 Patrols
0013 USAREUR-AF G34 EDD
0014 USAREUR-AF G2 Patrol
0015 Special Events
Special Events
0016 DHA/LRMC
| 0017 | Phase-In |
| Option Period One |
1001 USAG Ansbach
1002 USAG Bavaria
1003 USAG Benelux
1004 USAG Rheinland-Pfalz
1005 USAG Stuttgart
1006 USAG Wiesbaden
1007 Coleman Barracks
1008 DISA/ECRC
1009 DLA Escort Patrol
1010 21st TSC
1011 USAFE
1012 USAREUR-AF G34 Patrols
1013 USAREUR-AF G34 EDD
1014 USAREUR-AF G2 Patrol
1015 Special Events
1016 DHA/LRMC
| Total Cost | € - 0 | € - 0 | € - 0 | € - 0 | € - 0 | € - 0 | € - 0 | € - 0 | € - 0 | |
| FAR 52.217-8 Extension (Six months) | € - 0 | |||||||||
| Total Evaluated Price | € - 0 |
Location A
| Base Period Firm Fixed Price CLIN 0017 | Option Period One with Economic Price Adjustment CLIN 1017 | |||||||||||||||
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | ||||||||||
| GWG Location A | Unit Price | Extended Price | Unit Price | Extended Price | Unit Price | Extended Price | Unit Price | Extended Price | Unit Price | Extended Price | Unit Price | Extended Price | Unit Price | Extended Price | ||
| 1 Month | 1 Year | 1 Month | 1 Year | 1 Month | 1 Year | 1 Month | 1 Year | 1 Month | 1 Year | 1 Month | 1 Year | 1 Month | 1 Year | |||
| 0017AA | Labor | GWG Location A Labor | ||||||||||||||
| Location A | 017AA | Location A Inner Perimeter Foot Patrols (1 person) x 2 (PWS 5.1.6) - Labor | € 1,000.00 | € 12,000.00 | € 1,050.00 | € 12,600.00 | € 1,100.00 | € 13,200.00 | € 1,188.00 | € 14,256.00 | € 1,223.64 | € 14,683.68 | € 1,260.35 | € 15,124.19 | € 1,298.16 | € 15,577.92 |
| Location A | 017BA | Location A Monitor (PWS 5.1.3) - Labor | € 1,000.00 | € 12,000.00 | € 1,050.00 | € 12,600.00 | € 1,100.00 | € 13,200.00 | € 1,188.00 | € 14,256.00 | € 1,223.64 | € 14,683.68 | € 1,260.35 | € 15,124.19 | € 1,298.16 | € 15,577.92 |
| Location A | 017CA | Location A Motorized Patrol (1 person) x 1 (PWS 5.1.5) - Labor | € 1,000.00 | € 12,000.00 | € 1,050.00 | € 12,600.00 | € 1,100.00 | € 13,200.00 | € 1,188.00 | € 14,256.00 | € 1,223.64 | € 14,683.68 | € 1,260.35 | € 15,124.19 | € 1,298.16 | € 15,577.92 |
| GWG Location A Labor | € 3,000.00 | € 36,000.00 | € 3,150.00 | € 37,800.00 | € 3,300.00 | € 39,600.00 | € 3,564.00 | € 42,768.00 | € 3,670.92 | € 44,051.04 | € 3,781.05 | € 45,372.57 | € 3,894.48 | € 46,733.75 |
| 0017AB | Management | GWG Location A Management | ||||||||||||||
| Location A | 017AB | Location A Inner Perimeter Foot Patrols (1 person) x 2 (PWS 5.1.6) - Management | € 750.00 | € 9,000.00 | € 800.00 | € 9,600.00 | € 850.00 | € 10,200.00 | € 900.00 | € 10,800.00 | € 1,000.00 | € 12,000.00 | € 1,070.00 | € 12,840.00 | € 1,100.00 | € 13,200.00 |
| Location A | 017BB | Location A Monitor (PWS 5.1.3) - Management | € 750.00 | € 9,000.00 | € 800.00 | € 9,600.00 | € 850.00 | € 10,200.00 | € 900.00 | € 10,800.00 | € 1,000.00 | € 12,000.00 | € 1,070.00 | € 12,840.00 | € 1,100.00 | € 13,200.00 |
| Location A | 017CB | Location A Motorized Patrol (1 person) x 1 (PWS 5.1.5) - Management | € 750.00 | € 9,000.00 | € 800.00 | € 9,600.00 | € 850.00 | € 10,200.00 | € 900.00 | € 10,800.00 | € 1,000.00 | € 12,000.00 | € 1,070.00 | € 12,840.00 | € 1,100.00 | € 13,200.00 |
| GWG Location A Management | € 2,250.00 | € 27,000.00 | € 2,400.00 | € 28,800.00 | € 2,550.00 | € 30,600.00 | € 2,700.00 | € 32,400.00 | € 3,000.00 | € 36,000.00 | € 3,210.00 | € 38,520.00 | € 3,300.00 | € 39,600.00 |
SubCLIN ELIN GWG Location A (PWS 5) € 5,250.00 € 63,000.00 € 5,550.00 € 66,600.00 € 5,850.00 € 70,200.00 € 6,264.00 € 75,168.00 € 6,670.92 € 80,051.04 € 6,991.05 € 83,892.57 € 7,194.48 € 86,333.75
Base Wage
| Base Period | Option Period One with EPA | ||||||
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | |
| Hourly Wages for EPA calculation | Unit Price | Unit Price | Unit Price | Unit Price | Unit Price | Unit Price | Unit Price |
| 1 Hour | 1 Hour | 1 Hour | 1 Hour | 1 Hour | 1 Hour | 1 Hour |
| USAG-Rheinland Pfalz | € 15.00 | € 17.00 | € 20.00 | € 21.60 |
| USAG-Stuttgart | ||||
| USAG-Bavaria | ||||
| USAG-Ansbach | ||||
| USAG-Wiesbaden | ||||
| USAG-Benelux | ||||
| Coleman | ||||
| Percentage Change |
| USAG-Rheinland Pfalz | 108.00% | 0% | ERROR:#DIV/0! | ERROR:#DIV/0! |
| USAG-Stuttgart | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| USAG-Bavaria | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| USAG-Ansbach | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| USAG-Wiesbaden | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| USAG-Benelux | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Coleman | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
This section will be filled out before EPA execution for Years 4-7
File details come from the government source that posted it. Updated .