Tab_12_-_Attachment_2_-_Schedule_of_Services.xlsx

XLSX spreadsheet 66 KB Posted

Attached to
Amendment #1: Program Depot Maintenance Support Services Federal contract opportunity
Solicitation number
70Z03819RL0000001
Issued by
Department of Homeland Security US Coast Guard

About this file

Schedule of Services - Excel Version Amendment 1

View the file

Other files for this federal contract opportunity

Other files attached to Amendment #1: Program Depot Maintenance Support Services, newest first.
File Type Posted
Tab_12_-_Attachment_1_-_Terms_and_Conditions.docx DOCX document
PDM_Servies_70Z03819RL0000001_Questions.docx DOCX document
Attachment_4_-_CBA.pdf PDF
Attachment_1_-_Terms_and_Conditions.pdf PDF
Attachment_2_-_Schedule_of_Services.pdf PDF
Attachment_3_-_PDM_Statement_of_Work.pdf PDF
Attachment_5_-_Non-Disclosure.pdf PDF
Attachment_6_-_Past_Performance_Information_Sheet.pdf PDF
Attachment_7_-_Wage_Determination.pdf PDF

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

Base Period

Fill in the Gray boxes only. All other cell's will automatically calculate.
Base Period
CLINLABOR CATEGORYOccupation Code# Of PositionsFully Burdend Hourly Rate

CGTaber: CGTaber:

This would equal Total Cost plus Profit Overtime Rate Estimated Hours Total Yearly Price

0001Production Control Clerk23,840$ - 0
0002Aircraft Mechanic III - Senior1$ - 0$ - 01,920$ - 0
0003Aircraft Mechanic I - General10$ - 0$ - 019,200$ - 0
0004Aircraft Mechanic I - Sheet Metal8$ - 0$ - 015,360$ - 0
0005Aircraft Mechanic I - Electrician - Day5$ - 0$ - 09,600$ - 0
0006Aircraft Mechanic I - Electrician - Night5$ - 0$ - 09,600$ - 0
0007Aircraft Mechanic I - Avionics4$ - 0$ - 07,680$ - 0
0008Aircraft Mechanic Helper1$ - 0$ - 01,920$ - 0
0009Aircraft Worker - Day4$ - 0$ - 07,680$ - 0
0010Aircraft Worker - Night3$ - 0$ - 05,760$ - 0
0011Machine Tool Operator1$ - 0$ - 01,920$ - 0
0012Ground Support Equipment Mechanic1$ - 0$ - 01,920$ - 0
0013Aircraft Painter1$ - 0$ - 01,920$ - 0
0014Supply Clerk2$ - 0$ - 03,840$ - 0
0015Program Specialist2$ - 0$ - 03,840$ - 0
0016Material Coordinator1$ - 0$ - 01,920$ - 0
Total Option Base Period$ - 0
Note: Labor Category requirements and shift schedule's can change during any period of performance.

&"Times New Roman,Bold"ATTACHMENT 2 - PDM Schedule of Services

70Z03819RL0000001

Option Period One

Fill in the Gray boxes only. All other cell's will automatically calculate.
Option Period One
CLINLABOR CATEGORYOccupation Code# Of PositionsFully Burdend Hourly Rate

CGTaber: CGTaber:

This would equal Total Cost plus Profit Overtime Rate Estimated Hours Total Yearly Price

1001Production Control Clerk2$ - 0$ - 03,840$ - 0
1002Aircraft Mechanic III - Senior1$ - 0$ - 01,920$ - 0
1003Aircraft Mechanic I - General10$ - 0$ - 019,200$ - 0
1004Aircraft Mechanic I - Sheet Metal8$ - 0$ - 015,360$ - 0
1005Aircraft Mechanic I - Electrician - Day5$ - 0$ - 09,600$ - 0
1006Aircraft Mechanic I - Electrician - Night5$ - 0$ - 09,600$ - 0
1007Aircraft Mechanic I - Avionics4$ - 0$ - 07,680$ - 0
1008Aircraft Mechanic Helper1$ - 0$ - 01,920$ - 0
1009Aircraft Worker - Day4$ - 0$ - 07,680$ - 0
1010Aircraft Worker - Night3$ - 0$ - 05,760$ - 0
1011Machine Tool Operator1$ - 0$ - 01,920$ - 0
1012Ground Support Equipment Mechanic1$ - 0$ - 01,920$ - 0
1013Aircraft Painter1$ - 0$ - 01,920$ - 0
1014Supply Clerk2$ - 0$ - 03,840$ - 0
1015Program Specialist2$ - 0$ - 03,840$ - 0
1016Material Coordinator1$ - 0$ - 01,920$ - 0
Total Option Period One$ - 0
Note: Labor Category requirements and shift schedule's can change during any period of performance.

70Z03819RL0000001

Option Period Two

Fill in the Gray boxes only. All other cell's will automatically calculate.
Option Period Two
CLINLABOR CATEGORYOccupation Code# Of PositionsFully Burdend Hourly Rate

CGTaber: CGTaber:

This would equal Total Cost plus Profit Overtime Rate Estimated Hours Total Yearly Price

2001Production Control Clerk2$ - 0$ - 03,840$ - 0
2002Aircraft Mechanic III - Senior1$ - 0$ - 01,920$ - 0
2003Aircraft Mechanic I - General10$ - 0$ - 019,200$ - 0
2004Aircraft Mechanic I - Sheet Metal8$ - 0$ - 015,360$ - 0
2005Aircraft Mechanic I - Electrician - Day5$ - 0$ - 09,600$ - 0
2006Aircraft Mechanic I - Electrician - Night5$ - 0$ - 09,600$ - 0
2007Aircraft Mechanic I - Avionics4$ - 0$ - 07,680$ - 0
2008Aircraft Mechanic Helper1$ - 0$ - 01,920$ - 0
2009Aircraft Worker - Day4$ - 0$ - 07,680$ - 0
2010Aircraft Worker - Night3$ - 0$ - 05,760$ - 0
2011Machine Tool Operator1$ - 0$ - 01,920$ - 0
2012Ground Support Equipment Mechanic1$ - 0$ - 01,920$ - 0
2013Aircraft Painter1$ - 0$ - 01,920$ - 0
2014Supply Clerk2$ - 0$ - 03,840$ - 0
2015Program Specialist2$ - 0$ - 03,840$ - 0
2016Material Coordinator1$ - 0$ - 01,920$ - 0
Total Option Period Two$ - 0
Note: Labor Category requirements and shift schedule's can change during any period of performance.

70Z03819RL0000001

Option Period Three

Fill in the Gray boxes only. All other cell's will automatically calculate.
Option Period Three
CLINLABOR CATEGORYOccupation Code# Of PositionsFully Burdend Hourly Rate

CGTaber: CGTaber:

This would equal Total Cost plus Profit Overtime Rate Estimated Hours Total Yearly Price

3001Production Control Clerk2$ - 0$ - 03,840$ - 0
3002Aircraft Mechanic III - Senior1$ - 0$ - 01,920$ - 0
3003Aircraft Mechanic I - General10$ - 0$ - 019,200$ - 0
3004Aircraft Mechanic I - Sheet Metal8$ - 0$ - 015,360$ - 0
3005Aircraft Mechanic I - Electrician - Day5$ - 0$ - 09,600$ - 0
3006Aircraft Mechanic I - Electrician - Night5$ - 0$ - 09,600$ - 0
3007Aircraft Mechanic I - Avionics4$ - 0$ - 07,680$ - 0
3008Aircraft Mechanic Helper1$ - 0$ - 01,920$ - 0
3009Aircraft Worker - Day4$ - 0$ - 07,680$ - 0
3010Aircraft Worker - Night3$ - 0$ - 05,760$ - 0
3011Machine Tool Operator1$ - 0$ - 01,920$ - 0
3012Ground Support Equipment Mechanic1$ - 0$ - 01,920$ - 0
3013Aircraft Painter1$ - 0$ - 01,920$ - 0
3014Supply Clerk2$ - 0$ - 03,840$ - 0
3015Program Specialist2$ - 0$ - 03,840$ - 0
3016Material Coordinator1$ - 0$ - 01,920$ - 0
Total Option Period Three$ - 0
Note: Labor Category requirements and shift schedule's can change during any period of performance.

70Z03819RL0000001

Option Period Four

Fill in the Gray boxes only. All other cell's will automatically calculate.
Option Period Four
LABOR CATEGORYOccupation Code# Of PositionsFully Burdend Hourly Rate

CGTaber: CGTaber:

This would equal Total Cost plus Profit Overtime Rate Estimated Hours Total Yearly Price

Production Control Clerk2$ - 0$ - 03,840$ - 0
Aircraft Mechanic III - Senior1$ - 0$ - 01,920$ - 0
Aircraft Mechanic I - General10$ - 0$ - 019,200$ - 0
Aircraft Mechanic I - Sheet Metal8$ - 0$ - 015,360$ - 0
Aircraft Mechanic I - Electrician - Day5$ - 0$ - 09,600$ - 0
Aircraft Mechanic I - Electrician - Night5$ - 0$ - 09,600$ - 0
Aircraft Mechanic I - Avionics4$ - 0$ - 07,680$ - 0
Aircraft Mechanic Helper1$ - 0$ - 01,920$ - 0
Aircraft Worker - Day4$ - 0$ - 07,680$ - 0
Aircraft Worker - Night3$ - 0$ - 05,760$ - 0
Machine Tool Operator1$ - 0$ - 01,920$ - 0
Ground Support Equipment Mechanic1$ - 0$ - 01,920$ - 0
Aircraft Painter1$ - 0$ - 01,920$ - 0
Supply Clerk2$ - 0$ - 03,840$ - 0
Program Specialist2$ - 0$ - 03,840$ - 0
Material Coordinator1$ - 0$ - 01,920$ - 0
Total Option Period Four$ - 0
Note: Labor Category requirements and shift schedule's can change during any period of performance.

70Z03819RL0000001

Sheet1

Fill in the Gray boxes only. All other cell's will automatically calculate.
Option Period One
LABOR CATEGORYOccupation CodeFully burdend Hourly Rate

CGTaber: CGTaber:

This would equal Total Cost plus Profit Overtime Rate Estimated Hours Total Yearly Price

On-Site SupervisorFirm Fixed Price - Put the full Monthly Total in the Fully Burdened Hourly Rate Column$0.00$0.00
Aircraft Mechanic II (MRR) - Days23022$0.00$0.001,920$0.00
Aircraft Mechanic II (MRR) - Nights23022$0.00$0.001,920$0.00
Aircraft Mechanic I - Days23021$0.00$0.00
Aircraft Mechanic I - General (SRR)7,680$0.00
Aircraft Mechanic I - Sheet Metal (SRR)Not currently Filled-
Aircraft Mechanic I - Electrical/Avionics (SRR)Not currently Filled-
Aircraft Mechanic I - General (MRR)67,200$0.00
Aircraft Mechanic I - Sheet Metal (MRR)59,520$0.00
Aircraft Mechanic I - Electrical/Avionics (MRR)28,800$0.00
Aircraft Mechanic I - General (IOD)23,040$0.00
Aircraft Mechanic I - Sheet Metal (IOD)1,920$0.00
Aircraft Mechanic I - Nights23021$0.00$0.00
Aircraft Mechanic I - General (SRR)11,520$0.00
Aircraft Mechanic I - Sheet Metal (SRR)17,280$0.00
Aircraft Mechanic I - Electrical/Avionics (SRR)3,840$0.00
Aircraft Mechanic I - General (MRR)5,760$0.00
Aircraft Mechanic I - Sheet Metal (MRR)19,200$0.00
Aircraft Mechanic I - Electrical/Avionics (MRR)3,840$0.00
Aircraft Worker (MRR) - Days23080$0.00$0.0021,120$0.00
Aircraft Worker (MRR) - Nights23080$0.00$0.009,600$0.00
Aircraft Mechanic Helper (Sheet Metal) (MRR) - Days23040$0.00$0.007,680$0.00
Aircraft Mechanic Helper (Sheet Metal) (MRR) - Nights23040$0.00$0.001,920$0.00
Machine Tool Operator (IOD) - Days19010$0.00$0.0011,520$0.00
Machine Tool Operator (IOD) - Nights19010$0.00$0.0021,120$0.00
Tools and Parts Attendant (MRR) - Days21210$0.00$0.003,840$0.00
Tools and Parts Attendant (MRR) - Nights21210$0.00$0.001,920$0.00
Ground Support Equipment Servicer (MRR)23381$0.00$0.001,920$0.00
Ground Support Equipment Worker (MRR)23382$0.00$0.001,920$0.00
Ground Support Equipment Mechanic (MRR)23380$0.00$0.003,840$0.00
Aircraft Stripper (IOD) - Days23050$0.00$0.001,920$0.00
Aircraft Stripper (IOD) - Nights23050$0.00$0.009,600$0.00
Aircraft Survival Flight Equipment Tech (IOD)23070$0.00$0.003,840$0.00
Total Base Period$0.00

Option Period One

Fill in the Gray boxes only. All other cell will automatically calculate.
Option Period One
LABOR CATEGORYOccupation CodeHourly Rate

CGTaber: CGTaber:

This is the hourly rate before anything is added to the rate (i.e. benefits). This is calculated using your company's accounting practices. Overhead Fringe G&A Total Cost Fixed Hourly Rate CGTaber: CGTaber:

This would equal Total Cost plus Profit Overtime Rate Estimated Hours Max # of Employees Total Yearly Price

Enter the percentage rate CGTaber: CGTaber:

Enter the percentage rate CGTaber: CGTaber:

Enter the percentage rate CGTaber: CGTaber:

This would equal Total Cost plus ProfitOn-Site SupervisorFirm Fixed Price - Put the full Monthly Total in the Hourly Rate Column$0.001$0.00
Aircraft Mechanic II - Days23022$0.00$0.00$0.00$0.00$0.001,9201$0.00
Aircraft Mechanic II - Nights23022$0.00$0.00$0.00$0.00$0.001,9201$0.00
Aircraft Mechanic I - Days23021$0.00$0.00$0.00$0.00$0.00199,680104$0.00
Aircraft Mechanic I - General
Aircraft Mechanic I - Sheet Metal
Aircraft Mechanic I - Electrical/Avionics
Aircraft Mechanic I - Nights23021$0.00$0.00$0.00$0.00$0.0080,64042$0.00
Aircraft Mechanic I - General
Aircraft Mechanic I - Sheet Metal
Aircraft Mechanic I - Electrical/Avionics
Aircraft Worker - Days23080$0.00$0.00$0.00$0.00$0.0021,12011$0.00
Aircraft Worker - Nights23080$0.00$0.00$0.00$0.00$0.009,6005$0.00
Aircraft Mechanic Helper - Days23040$0.00$0.00$0.00$0.00$0.007,6804$0.00
Aircraft Mechanic Helper - Nights23040$0.00$0.00$0.00$0.00$0.001,9201$0.00
Machine Tool Operator - Days19010$0.00$0.00$0.00$0.00$0.007,6804$0.00
Machine Tool Operator - Nights19010$0.00$0.00$0.00$0.00$0.0013,4407$0.00
Tools and Parts Attendant - Days21210$0.00$0.00$0.00$0.00$0.001,9201$0.00
Tools and Parts Attendant - Nights21210$0.00$0.00$0.00$0.00$0.001,9201$0.00
Ground Support Equipment Servicer23381$0.00$0.00$0.00$0.00$0.001,9201$0.00
Ground Support Equipment Worker23382$0.00$0.00$0.00$0.00$0.001,9201$0.00
Ground Support Equipment Mechanic23380$0.00$0.00$0.00$0.00$0.003,8402$0.00
Aircraft Stripper- Days23050$0.00$0.00$0.00$0.00$0.001,9201$0.00
Aircraft Stripper - Nights23050$0.00$0.00$0.00$0.00$0.009,6005$0.00
Aircraft Survival Flight Equipment Tech23070$0.00$0.00$0.00$0.00$0.003,8402$0.00
Total Option Period One$0.00

&"Times New Roman,Bold"ATTACHMENT 2 - AMS Schedule of Services

70Z03818RJ0000001

Option Period Two

Fill in the Gray boxes only. All other cell will automatically calculate.
Option Period Two
LABOR CATEGORYOccupation CodeHourly Rate

CGTaber: CGTaber:

This is the hourly rate before anything is added to the rate (i.e. benefits). This is calculated using your company's accounting practices. Overhead Fringe G&A Total Cost Fixed Hourly Rate

This would equal Total Cost plus Profit Overtime Rate Estimated Hours Max # of Employees Total Yearly Price

Enter the percentage rate CGTaber: CGTaber:

Enter the percentage rate CGTaber: CGTaber:

Enter the percentage rate CGTaber: CGTaber:

This would equal Total Cost plus ProfitOn-Site SupervisorFirm Fixed Price - Put the full Monthly Total in the Hourly Rate Column$0.001$0.00
Aircraft Mechanic II - Days23022$0.00$0.00$0.00$0.00$0.001,9201$0.00
Aircraft Mechanic II - Nights23022$0.00$0.00$0.00$0.00$0.001,9201$0.00
Aircraft Mechanic I - Days23021$0.00$0.00$0.00$0.00$0.00199,680104$0.00
Aircraft Mechanic I - General
Aircraft Mechanic I - Sheet Metal
Aircraft Mechanic I - Electrical/Avionics
Aircraft Mechanic I - Nights23021$0.00$0.00$0.00$0.00$0.0080,64042$0.00
Aircraft Mechanic I - General
Aircraft Mechanic I - Sheet Metal
Aircraft Mechanic I - Electrical/Avionics
Aircraft Worker - Days23080$0.00$0.00$0.00$0.00$0.0021,12011$0.00
Aircraft Worker - Nights23080$0.00$0.00$0.00$0.00$0.009,6005$0.00
Aircraft Mechanic Helper - Days23040$0.00$0.00$0.00$0.00$0.007,6804$0.00
Aircraft Mechanic Helper - Nights23040$0.00$0.00$0.00$0.00$0.001,9201$0.00
Machine Tool Operator - Days19010$0.00$0.00$0.00$0.00$0.007,6804$0.00
Machine Tool Operator - Nights19010$0.00$0.00$0.00$0.00$0.0013,4407$0.00
Tools and Parts Attendant - Days21210$0.00$0.00$0.00$0.00$0.001,9201$0.00
Tools and Parts Attendant - Nights21210$0.00$0.00$0.00$0.00$0.001,9201$0.00
Ground Support Equipment Servicer23381$0.00$0.00$0.00$0.00$0.001,9201$0.00
Ground Support Equipment Worker23382$0.00$0.00$0.00$0.00$0.001,9201$0.00
Ground Support Equipment Mechanic23380$0.00$0.00$0.00$0.00$0.003,8402$0.00
Aircraft Stripper- Days23050$0.00$0.00$0.00$0.00$0.001,9201$0.00
Aircraft Stripper - Nights23050$0.00$0.00$0.00$0.00$0.009,6005$0.00
Aircraft Survival Flight Equipment Tech23070$0.00$0.00$0.00$0.00$0.003,8402$0.00
Total Option Period Two$0.00
Estimated Contract Total$0.00

&"Times New Roman,Bold"ATTACHMENT 2 - AMS Schedule of Services

70Z03818RJ0000001

File details come from the government source that posted it.