RFQATTACH.SPE4AK18Q0027.0002.XLSX

XLSX spreadsheet 47 KB Posted

Attached to
REPAIR KIT Federal contract opportunity
Solicitation number
SPE4AK18Q0027
Issued by
Defense Logistics Agency Aviation

View the file

Other files for this federal contract opportunity

Other files attached to REPAIR KIT, newest first.
File Type Posted
RFQATTACH.SPE4AK18Q0027.0004.XLSX XLSX spreadsheet
RFQATTACH.SPE4AK18Q0027.0003.XLSX XLSX spreadsheet
SPE4AK18Q0027.PDF PDF
RFQATTACH.SPE4AK18Q0027.0005.DOC DOC document
RFQATTACH.SPE4AK18Q0027.0000.DOC DOC document
RFQATTACH.SPE4AK18Q0027.0001.XLSX XLSX spreadsheet

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

J-3 Pricing Sheet Solicitation Number: Kit NSN: 1560015027377 0 0 0 0 0 0 Contractor Fill In Provide Pricing for the sum of Spot Buy quantities for parts listed more than once. DLA Buy Price per Component (aka MAUC) Sum of Spot Buy DLA Buy Price per Kit Tracy McEntee-Hamrick: WHEN PRODUCING THE DELIVERALBE:

Delete column AO: DLA Buy Price per Component and delete column AP: Sum of Spot Buy DLA Buy Price per Kit, in addition to all other deliverable steps.This column must remain
SPE4AK-18-Q-0027Kit Clin:0001000200030004000500060007Items to Tan
Kit Qty:18000000
Kit NSN:0000000
Kit Clin:0008000900100011001200130014
Kit Qty:0000000
Kit CLINComp CLINComponent NSNICPAMCAMSCNomenclaturePrimary CAGEPart NumberSUP (UI)UPA (UM)

DSCR: This is the quantity of this part to be included in each kit UI UM Conv Factor DSCR: This is the quantity included in the unit of issue: HD =100, Each = 1, etc.

CSI FSI

DSCR: CSI= Critical Safety Item FSI = Flight Safety Indicator A "Y" means that this part is coded as either CSI or FSI and DLA has sufficient stock on hand A "YP" means this part is coded as either CSI or FSI and DLA does not have enough stock on hand or due in to meet the requirement A "N" means this is not a CSI or FSI part FAT DSCR: FAT = First Article Test is required for this part

Tracy McEntee-Hamrick: WHEN PRODUCING THE DELIVERALBE:

Delete column AO: DLA Buy Price per Component and delete column AP: Sum of Spot Buy DLA Buy Price per Kit, in addition to all other deliverable steps.DLA Total Component Kit Price (UM)Total Qty per Kit CLIN Qty (UM)Spot Buy for Proposal (UM)Revised DLA Kit Unit Price (UM)Unit Cost (UM)Total Spot Buy PriceDays Until Avaliable (Days ARO)Mfg's CAGE CodeDealer's CAGE CodeTooling Cost
CLIN 9925CLIN 1 LEAD TIMECLIN 2 LEAD TIMECLIN 3 LEAD TIMECLIN 4 LEAD TIMECLIN 5 LEAD TIMECLIN 6 LEAD TIMECLIN 7 LEAD TIMECLIN 8 LEAD TIMECLIN 9 LEAD TIMECLIN 10 LEAD TIMECLIN 11 LEAD TIMECLIN 12 LEAD TIMECLIN 13 LEAD TIMECLIN 14 LEAD TIME
000100011560004689164SMS3CPANEL ACCESSU9143F292681$62.6620PGEA2NN$626.60360360$0.00$0.00$0.00$0.0000000000000000$62.66$626.60
000100021560995510259SMS3CBRACKET,STRUCTURAL COMPONENT,AIRK198775A326532-1001$356.112EAEA1NN$712.22360$712.22$0.00$0.00$0.0000000000000000$356.11$0.00Potential Problem
000100031560996443997SMS3QBRACKET,STRUCTURAL COMPONENT,AIRU914375A325359-1001$440.852EAEA1NN$881.703636$0.00$0.00$0.00$0.0000000000000000$440.85$881.70
000100041560997334377SMS3QBRACKET,STRUCTURAL COMPONENT,AIRU914375A326873-2003$481.092EAEA1NN$962.18360$962.18$0.00$0.00$0.0000000000000000$481.09$0.00Potential Problem
000100051560997992356SMS3QBRACKET,STRUCTURAL COMPONENT,AIRU914375A326532-1005$991.172EAEA1NN$1,982.343636$0.00$0.00$0.00$0.0000000000000000$991.17$1,982.34
000100061560998148660SMS3CBRACKET,STRUCTURAL COMPONENT,AIRU914375A326532-1003$462.282EAEA1NN$924.563636$0.00$0.00$0.00$0.0000000000000000$462.28$924.56
000100073040013374384SMS3LCONNECTING LINK,RIGID1623675A327426-1001$365.292EAEA1NN$730.58360$730.58$0.00$0.00$0.0000000000000000$365.29$0.00
000100083040013377572SMS3LCONNECTING LINK,RIGID1623675A326692-1001$263.484EAEA1NN$1,053.92720$1,053.92$0.00$0.00$0.0000000000000000$263.48$0.00
000100093040997988611SMS3CCONNECTING LINK,RIGIDU914375A327429-2001$214.092EAEA1YN$428.18360$428.18$0.00$0.00$0.0000000000000000$214.09$0.00
000100103120012949511SMS1GBUSHING,SLEEVE763014M139C12-27$11.964EAEA1NN$47.84720$47.84$0.00$0.00$0.0000000000000000$11.96$0.00
000100113120013119412SMS1GBUSHING,SLEEVE763014M139C6-16$11.168EAEA1NN$89.281440$89.28$0.00$0.00$0.0000000000000000$11.16$0.00
000100123120013123986SMS1GBUSHING,SLEEVE763014M139C9-25$8.474EAEA1NN$33.88720$33.88$0.00$0.00$0.0000000000000000$8.47$0.00
000100135305003478294SMS1GSCREW,CLOSE TOLERANCE80205NAS663V5HT$2.0410EAEA1NN$20.401800$20.40$0.00$0.00$0.0000000000000000$2.04$0.00
000100145306003167424SMS1GBOLT,CLOSE TOLERANCE80205NAS6303U4H$1.778EAEA1NN$14.161440$14.16$0.00$0.00$0.0000000000000000$1.77$0.00
000100155306003545158SMS1GBOLT,SHEAR80205NAS6303U14D$2.614EAEA1NN$10.44720$10.44$0.00$0.00$0.0000000000000000$2.61$0.00
000100165306004922990SMS1GBOLT,SHEAR80205NAS6304U2$1.166EAEA1NN$6.961080$6.96$0.00$0.00$0.0000000000000000$1.16$0.00
000100175306012412643SMS1GBOLT,SHEAR80205NAS6305U5$2.924EAEA1NN$11.687272$0.00$0.00$0.00$0.0000000000000000$2.92$11.68
000100185310004689163SMS3LWASHER,RECESSEDK1987F292680$46.0810EAEA1NN$460.80180180$0.00$0.00$0.00$0.0000000000000000$46.08$460.80
000100195310006419202SMS1GWASHER,FLAT98897726038-3$0.198EAEA1NN$1.521440$1.52$0.00$0.00$0.0000000000000000$0.19$0.00
000100205310008352041SMS1GWASHER,KEY96906MS9276-11$0.414EAEA1NN$1.64720$1.64$0.00$0.00$0.0000000000000000$0.41$0.00
000100215310009484002SMS1GWASHER,FLAT59364S9011F3-060$1.134EAEA1NN$4.52720$4.52$0.00$0.00$0.0000000000000000$1.13$0.00
000100225310009694466SMS1GWASHER,KEY81343MS9276-10$11.236HDEA100NN$0.671080$0.67$0.00$0.00$0.0000000000000000$11.23$0.00
000100235310011815045SMS1CNUT,SELF-LOCKING,EXTENDED WASHER76301ST3M787-3$13.1916EAEA1NN$211.04288288$0.00$0.00$0.00$0.0000000000000000$13.19$211.04
000100245310013515309SMS3LWASHER,FLATU914375A325416-2009$43.722EAEA1NN$87.44360$87.44$0.00$0.00$0.0000000000000000$43.72$0.00
000100255310013529575SMS1GWASHER,FLAT80205NAS1149C0363R$2.4458HDEA100NN$1.421,0440$1.42$0.00$0.00$0.0000000000000000$2.44$0.00
000100265310991986013SMS3LWASHER,FLATK198775A325416-2007$48.622EAEA1NN$97.24360$97.24$0.00$0.00$0.0000000000000000$48.62$0.00
000100275315001089886SMS1GPIN,STRAIGHT,HEADED96906MS9463-07$2.172EAEA1NN$4.34360$4.34$0.00$0.00$0.0000000000000000$2.17$0.00
000100285315002341854SMS1GPIN,COTTER80205MS24665-153$1.1116HDEA100NN$0.182880$0.18$0.00$0.00$0.0000000000000000$1.11$0.00
000100295315002341856SMS1GPIN,COTTER80205MS24665-155$1.8810HDEA100NN$0.191800$0.19$0.00$0.00$0.0000000000000000$1.88$0.00
000100305315991310222SMS3LPIN,HOLLOW HEADEDK198775A325361-2001$58.444EAEA1NN$233.76720$233.76$0.00$0.00$0.0000000000000000$58.44$0.00
000100315315994772570SMS3LPIN,HOLLOWED HEADK198775A325362-2001$72.084EAEA1NN$288.327272$0.00$0.00$0.00$0.0000000000000000$72.08$288.32
000100325315995878762SMS3LPIN,HOLLOW,HEADEDK198775A325360-2001$60.554EAEA1NN$242.207272$0.00$0.00$0.00$0.0000000000000000$60.55$242.20
000100335315999938517SMS3LPIN,HOLLOW,HEADEDK198775A325363-2001$43.764EAEA1NN$175.04720$175.04$0.00$0.00$0.0000000000000000$43.76$0.00
000100345365009152111SMS1GSHIM763014M38C10L$0.6516EAEA1NN$10.402880$10.40$0.00$0.00$0.0000000000000000$0.65$0.00
Total Parts Cost with All GFM (UM):$10,357.63
Revised Total GFM Cost (UM) - CFM:$4,728.39
PRICE PER KIT CLIN 00010001000200030004000500060007
4728.3946Price of Component Parts available from DLA:$85,111.10$0.00$0.00$0.00$0.00$0.00$0.00
PARTS PLUS 41.5% CCR0Spot Buy Price per Kit CLIN:$0.00$0.00$0.00$0.00$0.00$0.00$0.00
ERROR:#VALUE!
0Tooling Cost (CLIN 9925)
per Kit CLIN:$0.00$0.00$0.00$0.00$0.00$0.00$0.00

Pricing Sheet Submitted by: (Enter Company Name Below) 0 Total Packing/Labeling Materials Price per Kit CLIN: $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

0Total Service Fee per Kit CLIN:$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Click Here for Service Fee Pricing
TOTAL AY FEE PER KITTotal CLIN Kit Price:$85,111.10$0.00$0.00$0.00$0.00$0.00$0.00
Date:0
Kit Unit Price (includes GFM costs):$4,728.39ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Longest Estd Kit Delivery After Receipt of OrderTOTAL CONTRACT PRICEKit Unit Contract Price (minus GFM and Tooling costs):$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
0
0 DaysLongest Component Lead Time0 Days0 Days0 Days0 Days0 Days0 Days0 Days

Estimated Kit Delivery Days After Receipt of Order 0 0 0 0 0 0 0

0008000900100011001200130014
Price of Component Parts available from DLA:$0.00$0.00$0.00$0.00$0.00$0.00$0.00

Spot Buy Price per Kit CLIN: $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Tooling Cost (CLIN 9925)
per Kit CLIN:$0.00$0.00$0.00$0.00$0.00$0.00$0.00

Total Packing/Labeling Materials Price per Kit CLIN: $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Total Service Fee per Kit CLIN: $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Total CLIN Kit Price: $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Kit Unit Price (includes GFM costs): ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!

Kit Unit Contract Price (minus GFM and Tooling costs): ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!

Longest Component Lead Time 0 Days 0 Days 0 Days 0 Days 0 Days 0 Days 0 Days

Estimated Kit Delivery Days After Receipt of Order 0 0 0 0 0 0 0

&A KIT NSN &F

Service Fee Pricing Sheet

SERVICE FEE PRICING SHEET

Solicitation Number:SPE4AK-18-Q-0027
KIT NSNKIT QTYKIT CLINDIRECT LABOROVER HEADG&APROFITTOTALS
Enter dollar amounts for the total kit quantity
1560015027377181$0.00
002$0.00
003$0.00
004$0.00
005$0.00
006$0.00
007$0.00
008$0.00
009$0.00
0010$0.00
0011$0.00
0012$0.00
0013$0.00
0014$0.00
Return to J-3 Pricing Sheet
Pricing Sheet Submitted by:

&A 01-26-17 KIT NSN

&F

File details come from the government source that posted it.