PricingMatrix.xls

XLS spreadsheet 212 KB Posted

Attached to
Maintenance, Repair, and Rebuilding of Equipment
Solicitation number
FA8224-07-R-1001
Issued by

About this file

Pricing Matrix

View the file

Other files

File Type Posted
1_UTWageDetermination.pdf PDF
FA822407R1001_______0011.pdf PDF
FA822407R1001_______0010.pdf PDF
Notice20080204.pdf PDF
SafetyHealthSpecs20080128.pdf PDF
FA822407R1001_______0009.pdf PDF
Amendment0007Notice.doc DOC document
Amendment0008Notice.pdf PDF
FA820007R1001_______0008.pdf PDF
SectionLAmendment8.pdf PDF
DOCATsNotice20071219.doc DOC document
DOCATSFA8224-07-R-1001Amendment0007.PDF PDF
UTWageDetermination.PDF PDF
FA822407R1001_______0006(2).pdf PDF
SectionLAmendment0006.pdf PDF
SectionMAmendment0006.pdf PDF
QuestionsAnswers20070821.doc DOC document
DOCATSSectionL20070816RFPAmendment5.pdf PDF
FA822407R1001_______0005.RTF RTF text file
DO-CATRatesTEPWorksheet20070816Amendment0005.xls XLS spreadsheet
Notice20070808.doc DOC document
FA822407R1001_______0004.RTF RTF text file
DOCATPWSDraftRFP20070806.pdf PDF
18AZWD05-2025R4.pdf PDF
DOCATSSectionL20070802RFPAmendment4.pdf PDF
SampleQuestionnaireCoverLetter-amendment03.doc DOC document
SectionL03.pdf PDF
FA822407R1001_______0003.RTF RTF text file
FA822407R1001_______0002(2).RTF RTF text file
SectionL02.pdf PDF
Amendment0001Notice.pdf PDF
AppendixA-DIDsCDRLs.pdf PDF
FA822407R1001.RTF RTF text file
FA822407R1001_______0001.RTF RTF text file
SectionM.pdf PDF
CrossReferenceMatrix.xls XLS spreadsheet
AZWageDetermination.pdf PDF
PWS.pdf PDF
PastPerformanceQuestionnaire.doc DOC document
ClientAuthLetter.doc DOC document
TeamList.doc DOC document
UTWageDetermination.pdf PDF
SampleConsentLetter.doc DOC document
SectionL.pdf PDF
SampleQuestionnaireCoverLetter.doc DOC document
DD254.pdf PDF
QuestionsafterIndustryDay20070619.doc DOC document
ConsolidatedQuestionsandAnswers20070611.pdf PDF
MaintenanceBriefforDO-CATS Updated20070524.pdf PDF
309thAMARGMissionBrief Updated20070523.pdf PDF
Show 40 more

Latest 50 of 54 listed here. See the rest on GovTribe.

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

TEP WORKSHEET INSTRUCTIONS

Additional Instructions / Comments
1Note: The TEP worksheets are illustrative as far as the sample LABOR HOUR RATES & TEP AMOUNTS. The illustrative amounts were used to develop the formulas. The offeror will populate the NTE LABOR HOUR BASE RATES columns (yellow), the OVERTIME MULTIPLIER (pink), and the SHIFT DIFFERENTIAL PERCENTAGES (yellow) for both Utah and Arizona in Attachments 15 and 16 and the NTE FULLY-LOADED LABOR HOUR RATES columns (yellow) for both Utah and Arizona in Attachments 4 and 5. These proposed NTE LABOR HOUR BASE RATES, NTE FULLY-LOADED LABOR HOUR RATES, OVERTIME MULTIPLIER, and SHIFT DIFFERENTIAL PERCENTAGES are contractually binding. The TEP amounts will be computed automatically. See Table 3 - Total Evaluated Price on the TEP Roll-up Worksheet.
2Note: The TEP worksheet contains the mathematical formulas. This spreadsheet must be submitted electronically as a Microsoft Excel spreadsheet and not in any other format. DO NOT limit/protect the worksheet to "read" only format. The Evaluation Team will need to perform validation check on the formulas and amounts. Please do not change the formulas unless you receive permission from the PCO.
3Note that the developed TEP values are for "award selection purposes only"; they are not contractually binding. Some CLINs such as the CRNF CLINs are not included in the TEP computation. See Part 1 - THE SCHEDULE SECTION B SUPPLIES OR SERVICES AND PRICES/COSTS of the RFP.
4Note: The estimated hours are notional and used for evaluation purposes only. They are hidden and cell protected so they cannot be adjusted.
5The TEP values in the TEP worksheets will be used in the best value decision to determine the awardee(s) for the basic contract. See Section M of the RFP for additional details on how the award(s) will be made for the basic contract and follow-on task orders.

15 - Base Rates - UT

Attachment 15: BASE RATES - UTAHFill in the Shift Differential Percentages for Swing Shift and Graveyard highlighted (yellow) and the Overtime multiplier (pink). These percentages and multiplier will be contractually binding and will adjust the base rates accordingly.
Swing ShiftGraveyard
SHIFT DIFFERENTIAL PERCENTAGES1.500%2.000%
OVERTIME MULTIPLIER1.50
Labor CategoriesDoL CodeThe contractor shall subsitute their proposed Base Rates for the rates highlighted in yellow. The proposed Rates will be contractually binding, and along with the overtime rates, are the only portions of the composite rates that will will be adjusted as required by the service contract act. The shift differential percentage will automatically adjust with the base rates.
NTE Labor Hour Base Rates
FY 08FY 09FY 10
Electrician23160$8.00$9.00$10.00
Computer Operator I14041$8.00$9.00$10.00
Computer Operator II14042$8.00$9.00$10.00
Computer Operator III14043$8.00$9.00$10.00
Computer Operator IV14044$8.00$9.00$10.00
Computer Operator V14045$8.00$9.00$10.00
Electronic Technician I23181$8.00$9.00$10.00
Electronic Technician II23182$8.00$9.00$10.00
Electronic Technician III23183$8.00$9.00$10.00
Engineering Technician IV30084$8.00$9.00$10.00
Engineering Technician V30085$8.00$9.00$10.00
Engineering Technician VI30086$8.00$9.00$10.00
Material Handling Laborer21050$8.00$9.00$10.00
Material Expeditor21040$8.00$9.00$10.00
Helper, Aircraft23040$8.00$9.00$10.00
Helper, Automotive05220$8.00$9.00$10.00
Inspector99240$8.00$9.00$10.00
Mechanic, Aircraft I23021$8.00$9.00$10.00
Mechanic, Aircraft II23022$8.00$9.00$10.00
Mechanic, Aircraft III23023$8.00$9.00$10.00
Mechanic, Automotive05190$8.00$9.00$10.00
Mechanic, Ground Support23380$8.00$9.00$10.00
Mechanic, Heavy Equipment23430$8.00$9.00$10.00
Mechanic, Instrument23460$8.00$9.00$10.00
Painter, Aircraft23050$8.00$9.00$10.00
Painter, Automotive05310$8.00$9.00$10.00
Production Control Clerk01270$8.00$9.00$10.00
Scheduler01300$8.00$9.00$10.00
Servicer, Aircraft23060$8.00$9.00$10.00
Servicer, Ground Support23381$8.00$9.00$10.00
Sheet Metal Worker23890$8.00$9.00$10.00
Shop Machinist23550$8.00$9.00$10.00
Technical Writer I30461$8.00$9.00$10.00
Welder, Combination Maintenance23960$8.00$9.00$10.00
Woodworker23980$8.00$9.00$10.00
Worker, Aircraft23080$8.00$9.00$10.00
Worker, Automotive05070$8.00$9.00$10.00
Worker, Ground Support23382$8.00$9.00$10.00

4 - Prime & Sub Comp Rate - UT

Attachment 4: Utah Labor CategoriesDoL CodeThe contractor shall propose the Rates highlighted in yellow. They will replace the illustrative rates. The TEP will automatically be computed. The proposed Rates will be
FY 08FY 09FY 10NTE Fully-Loaded Labor Hour RatesTEP COMPUTATION
Notional Labor HoursNotional Labor HoursNotional Labor HoursFY 08FY 09FY 10FY 08FY 09FY 10
Electrician10010010023160$8.00$9.00$10.00$865$973$1,081804804basic rate
Computer Operator I10010010014041$8.00$9.00$10.00$865$973$1,08180463579% initial hours * basic rate
Computer Operator II10010010014042$8.00$9.00$10.00$865$973$1,08180418115% overtime and overtime multiplier
Computer Operator III10010010014043$8.00$9.00$10.00$865$973$1,081804415% swing shift + swing shift differential
Computer Operator IV10010010014044$8.00$9.00$10.00$865$973$1,08180481% graveyard shift + graveyard shift differential
Computer Operator V10010010014045$8.00$9.00$10.00$865$973$1,081804865
Electronic Technician I10010010023181$8.00$9.00$10.00$865$973$1,081804857
Electronic Technician II10010010023182$8.00$9.00$10.00$865$973$1,081804
Electronic Technician III14,23314,23314,23323183$8.00$9.00$10.00$122,512$137,826$153,140113,864
Engineering Technician IV1,3151,3151,31530084$8.00$9.00$10.00$11,315$12,730$14,14410,516
Engineering Technician V2,5532,5532,55330085$8.00$9.00$10.00$21,978$24,725$27,47220,426
Engineering Technician VI1,2771,2771,27730086$8.00$9.00$10.00$10,989$12,362$13,73610,213
Material Handling Laborer21,37721,37721,37721050$8.00$9.00$10.00$184,003$207,003$230,003171,014
Material Expeditor5,2565,2565,25621040$8.00$9.00$10.00$45,242$50,897$56,55242,048
Helper, Aircraft10010010023040$8.00$9.00$10.00$865$973$1,081804
Helper, Automotive10010010005220$8.00$9.00$10.00$865$973$1,081804
Inspector2,6352,6352,63599240$8.00$9.00$10.00$22,685$25,520$28,35621,084
Mechanic, Aircraft I26,59926,59926,59923021$8.00$9.00$10.00$228,954$257,573$286,192212,792
Mechanic, Aircraft II84,96484,96484,96423022$8.00$9.00$10.00$731,336$822,753$914,170679,712
Mechanic, Aircraft III170,596170,596170,59623023$8.00$9.00$10.00$1,468,422$1,651,975$1,835,5281,364,768
Mechanic, Automotive10010010005190$8.00$9.00$10.00$865$973$1,081804
Mechanic, Ground Support10010010023380$8.00$9.00$10.00$865$973$1,081804
Mechanic, Heavy Equipment10010010023430$8.00$9.00$10.00$865$973$1,081804
Mechanic, Instrument10010010023460$8.00$9.00$10.00$861$968$1,076800
Painter, Aircraft20,99020,99020,99023050$8.00$9.00$10.00$180,673$203,258$225,842167,920
Painter, Automotive10010010005310$8.00$9.00$10.00$865$973$1,081804
Production Control Clerk16,53016,53016,53001270$8.00$9.00$10.00$142,286$160,072$177,858132,242
Scheduler11,55411,55411,55401300$8.00$9.00$10.00$99,452$111,884$124,31592,432
Servicer, Aircraft10010010023060$8.00$9.00$10.00$865$973$1,081804
Servicer, Ground Support10010010023381$8.00$9.00$10.00$861$968$1,076800
Sheet Metal Worker41,75841,75841,75823890$8.00$9.00$10.00$359,437$404,367$449,297334,065
Shop Machinist3,0093,0093,00923550$8.00$9.00$10.00$25,900$29,138$32,37524,072
Technical Writer I10010010030461$8.00$9.00$10.00$865$973$1,081804
Welder, Combination Maintenance10010010023960$8.00$9.00$10.00$865$973$1,081804
Woodworker2,8102,8102,81023980$8.00$9.00$10.00$24,186$27,210$30,23322,479
Worker, Aircraft23,79423,79423,79423080$8.00$9.00$10.00$204,805$230,406$256,007190,348
Worker, Automotive10010010005070$8.00$9.00$10.00$865$973$1,081804
Worker, Ground Support10010010023382$8.00$9.00$10.00$865$973$1,081804
Utah Subtotal$3,902,331$4,390,123$4,877,914

16 - Base Rates - AZ

Attachment 16: BASE RATES - ARIZONAFill in the Shift Differential Percentages for Swing Shift and Graveyard highlighted (yellow) and the Overtime multiplier (pink). These percentages and multiplier will be contractually binding and will adjust the base rates accordingly.
Swing ShiftGraveyard
SHIFT DIFFERENTIAL PERCENTAGES1.500%2.000%
OVERTIME MULTIPLIER1.50
Labor CategoriesDoL CodeThe contractor shall subsitute their proposed Base Rates for the rates highlighted in yellow. The proposed Rates will be contractually binding, and along with the overtime rates, are the only portions of the composite rates that will will be adjusted as required by the service contract act. The shift differential percentage will automatically adjust with the base rates.
NTE Labor Hour Base Rates
FY 08FY 09FY 10
Electrician23160$8.00$9.00$10.00
Computer Operator I14041$8.00$9.00$10.00
Computer Operator II14042$8.00$9.00$10.00
Computer Operator III14043$8.00$9.00$10.00
Computer Operator IV14044$8.00$9.00$10.00
Computer Operator V14045$8.00$9.00$10.00
Electronic Technician I23181$8.00$9.00$10.00
Electronic Technician II23182$8.00$9.00$10.00
Electronic Technician III23183$8.00$9.00$10.00
Engineering Technician IV30084$8.00$9.00$10.00
Engineering Technician V30085$8.00$9.00$10.00
Engineering Technician VI30086$8.00$9.00$10.00
Material Handling Laborer21050$8.00$9.00$10.00
Material Expeditor21040$8.00$9.00$10.00
Helper, Aircraft23040$8.00$9.00$10.00
Helper, Automotive05220$8.00$9.00$10.00
Inspector99240$8.00$9.00$10.00
Mechanic, Aircraft I23021$8.00$9.00$10.00
Mechanic, Aircraft II23022$8.00$9.00$10.00
Mechanic, Aircraft III23023$8.00$9.00$10.00
Mechanic, Automotive05190$8.00$9.00$10.00
Mechanic, Ground Support23380$8.00$9.00$10.00
Mechanic, Heavy Equipment23430$8.00$9.00$10.00
Mechanic, Instrument23460$8.00$9.00$10.00
Painter, Aircraft23050$8.00$9.00$10.00
Painter, Automotive05310$8.00$9.00$10.00
Production Control Clerk01270$8.00$9.00$10.00
Scheduler01300$8.00$9.00$10.00
Servicer, Aircraft23060$8.00$9.00$10.00
Servicer, Ground Support23381$8.00$9.00$10.00
Sheet Metal Worker23890$8.00$9.00$10.00
Shop Machinist23550$8.00$9.00$10.00
Technical Writer I30461$8.00$9.00$10.00
Welder, Combination Maintenance23960$8.00$9.00$10.00
Woodworker23980$8.00$9.00$10.00
Worker, Aircraft23080$8.00$9.00$10.00
Worker, Automotive05070$8.00$9.00$10.00
Worker, Ground Support23382$8.00$9.00$10.00

5 - Prime & Sub Comp Rate - AZ

Attachment 5: Arizona Labor CategoriesDoL CodeThe contractor shall propose the Rates highlighted in yellow. They will replace the illustrative rates. The TEP will automatically be computed. The proposed Rates will be contractually binding.
FY 08FY 09FY 10NTE Fully-Loaded Labor Hour RatesTEP COMPUTATION
Notional Labor HoursNotional Labor HoursNotional Labor HoursFY 08FY 09FY 10FY 08FY 09FY 10
Electrician10010010023160$8.00$9.00$10.00$865$973$1,081804804basic rate
Computer Operator I10010010014041$8.00$9.00$10.00$865$973$1,08180463579% initial hours * basic rate
Computer Operator II10010010014042$8.00$9.00$10.00$865$973$1,08180418115% overtime and overtime multiplier
Computer Operator III10010010014043$8.00$9.00$10.00$865$973$1,081804415% swing shift + swing shift differential
Computer Operator IV10010010014044$8.00$9.00$10.00$865$973$1,08180481% graveyard shift + graveyard shift differential
Computer Operator V10010010014045$8.00$9.00$10.00$865$973$1,081804865
Electronic Technician I10010010023181$8.00$9.00$10.00$865$973$1,081804857
Electronic Technician II10010010023182$8.00$9.00$10.00$865$973$1,081804
Electronic Technician III10010010023183$8.00$9.00$10.00$865$973$1,081804
Engineering Technician IV10010010030084$8.00$9.00$10.00$865$973$1,081804
Engineering Technician V10010010030085$8.00$9.00$10.00$865$973$1,081804
Engineering Technician VI10010010030086$8.00$9.00$10.00$865$973$1,081804
Material Handling Laborer10010010021050$8.00$9.00$10.00$865$973$1,081804
Material Expeditor10010010021040$8.00$9.00$10.00$865$973$1,081804
Helper, Aircraft10010010023040$8.00$9.00$10.00$865$973$1,081804
Helper, Automotive10010010005220$8.00$9.00$10.00$865$973$1,081804
Inspector15,64315,64315,64399240$8.00$9.00$10.00$134,651$151,482$168,314125,146
Mechanic, Aircraft I10010010023021$8.00$9.00$10.00$865$973$1,081804
Mechanic, Aircraft II128,794128,794128,79423022$8.00$9.00$10.00$1,108,607$1,247,183$1,385,7591,030,352
Mechanic, Aircraft III10010010023023$8.00$9.00$10.00$865$973$1,081804
Mechanic, Automotive10010010005190$8.00$9.00$10.00$865$973$1,081804
Mechanic, Ground Support10010010023380$8.00$9.00$10.00$865$973$1,081804
Mechanic, Heavy Equipment10010010023430$8.00$9.00$10.00$865$973$1,081804
Mechanic, Instrument10010010023460$8.00$9.00$10.00$865$973$1,081804
Painter, Aircraft10010010023050$8.00$9.00$10.00$865$973$1,081804
Painter, Automotive10010010005310$8.00$9.00$10.00$865$973$1,081804
Production Control Clerk10010010001270$8.00$9.00$10.00$865$973$1,081804
Scheduler10010010001300$8.00$9.00$10.00$865$973$1,081804
Servicer, Aircraft10010010023060$8.00$9.00$10.00$865$973$1,081804
Servicer, Ground Support10010010023381$8.00$9.00$10.00$865$973$1,081804
Sheet Metal Worker10010010023890$8.00$9.00$10.00$865$973$1,081804
Shop Machinist10010010023550$8.00$9.00$10.00$865$973$1,081804
Technical Writer I10010010030461$8.00$9.00$10.00$865$973$1,081804
Welder, Combination Maintenance10010010023960$8.00$9.00$10.00$865$973$1,081804
Woodworker2,8102,8102,81023980$8.00$9.00$10.00$24,186$27,210$30,23322,479
Worker, Aircraft23,79423,79423,79423080$8.00$9.00$10.00$204,805$230,406$256,007190,348
Worker, Automotive10010010005070$8.00$9.00$10.00$865$973$1,081804
Worker, Ground Support10010010023382$8.00$9.00$10.00$865$973$1,081804
Arizona Subtotal$1,501,658$1,689,366$1,877,073

14 - TEP Rollup

Attachment 14
Table 3: Total Evaluated Price
FY08FY09FY10Total TEP
Utah Subtotals$3,902,331$4,390,123$4,877,914$13,170,368
Arizona Subtotals$1,501,658$1,689,366$1,877,073$5,068,097
Totals$5,403,990$6,079,488$6,754,987$18,238,465

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