Attachment_0039_-_Currency_Fluctuation_Worksheet.xlsx

XLSX spreadsheet 39 KB Posted

Attached to
Lake City Army Ammunition Plant (LCAAP) - Draft RFP
Solicitation number
W52P1J-17-R-0141
Issued by

About this file

Written by GovTribe AI ·

This document contains an example currency fluctuation worksheet and related federal contract opportunity notice for ammunition components. The currency fluctuation worksheet provides illustrative pricing examples for various ammunition components designated by DODIC codes, including MK211 Mod 1, MK211 Mod 0, and MK263, with pricing in U.S. dollars, Norwegian kroner, and Canadian dollars. It outlines methodology for adjusting component pricing based on fluctuations in currency exchange rates against the U.S. dollar. The related federal contract opportunity is a pre-solicitation notice for the Lake City Army Ammunition Plant seeking ammunition components to be acquired over multiple delivery orders during the contract period. Relevant federal agencies involved are the Department of the Army Materiel Command and Joint Munitions Command. Response and award dates are not specified.

From the source

Attachment 0039 - Currency Fluctuation Worksheet

View the file

Other files

File Type Posted
LCAAP_Draft_RFP_Q&As__1_Rev_1.pdf PDF
LCAAP_Draft_RFP_Q&As__2.pdf PDF
LCAAP_Draft_RFP_Q&As.pdf PDF
W52P1J-17-R-0141_-_DRAFT_Rev_1_-_19JUL18.pdf PDF
Attachment_0037_-_Price_Matrix_-_Summary_Evaluation_Matrix.xlsx XLSX spreadsheet
Attachment_0046_-_Component_Suppliers_Template.xlsx XLSX spreadsheet
Attachment_0011_-_PWS_11_-_Occupational_Health_and_Industrial_Hygiene.pdf PDF
Attachment_0016_-_PWS_16-_On-Site_Government_Personnel_Support.pdf PDF
Attachment_0029_-_Price_Matrix__7.62mm_Family.xlsx XLSX spreadsheet
Exhibit_B_-_Contract_Data_Requirements_List_-_7.62mm.pdf PDF
Exhibit_E_-_Contract_Data_Requirements_List_-_Caliber_.22.pdf PDF
Attachment_0040__-_Price_Matrix_(INDEMNIFIED)_-_5.56mm_Family.xlsx XLSX spreadsheet
Attachment_0017_-_PWS_17_-_Armament_Retooling_and_Manufacturing_Support.pdf PDF
Attachment_0007_-_PWS_7_-_Government_Property_in_Possession_of_the_Contractor.pdf PDF
Attachment_0027_-_Award_Term_Plan.pdf PDF
Attachment_0002_-_PWS_2_-_Safety.pdf PDF
Attachment_0050_-_Example_Order_-_7.62mm.pdf PDF
Attachment_0024_-_DD254_-_Contract_Security_Classification_Specification_(FOR_POSTING).pdf PDF
Attachment_0034_-_FAAT_Price_Matrix_-_.50_Caliber.xlsx XLSX spreadsheet
Attachment_0009_-_PWS_9_-_Contract_Production_and_Delivery_Reporting.pdf PDF
Exhibit_A_-_Contract_Data_Requirements_List_-_5.56mm.pdf PDF
Attachment_0003_-_PWS_3_-_Security_and_Antiterrorism_(FOR_POSTING).pdf PDF
Attachment_0025_-_Hazardous_Material_Classification.pdf PDF
Attachment_0001_-_PWS_1_-_Maintenance.pdf PDF
Exhibit_F_-_Contract_Data_Requirements_List_-_PWS.pdf PDF
Attachment_0012_-_PWS_12_-_Support_of_Onsite_Government_BSO_and_NATO_North_American_Regional_Test_Center.pdf PDF
Attachment_0047_-_Small_Business_Participation_Plan.pdf PDF
Attachment_0030_-_Price_Matrix__.50_Caliber_Family.xlsx XLSX spreadsheet
Attachment_0033_-_FAAT_Price_Matrix_-_7.62mm.XLSX XLSX spreadsheet
Attachment_0010_-_PWS_10_-_Contract_Start-Up_and_Transition.pdf PDF
Attachment_0013_-_PWS_13_-_Mowing_(FOR_POSTING).pdf PDF
Attachment_0020_-_EPR_NDA_-_Corporate.pdf PDF
Attachment_0008_-_PWS_8_-_Ammunition_Materiel_Management.pdf PDF
Attachment_0049_-_Example_Order_-_5.56mm.pdf PDF
Exhibit_C_-_Contract_Data_Requirements_List_-_.50_Caliber.pdf PDF
Attachment_0044_-_Virtual_Techncial_Library_-_On-Site_Library_Contents_(FOR_POSTING).pdf PDF
Attachment_0043_-_Price_Matrix_(INDEMNIFIED)_-_.22_Caliber.xlsx XLSX spreadsheet
Attachment_0028_-_Price_Matrix_-_5.56mm_Family.xlsx XLSX spreadsheet
Attachment_0045_-_SAIC_Non-Disclosure_Agreement.pdf PDF
Attachment_0023_-_Government_Owned_Equipment_(FOR_POSTING).pdf PDF
Attachment_0041_-_Price_Matrix_(INDEMNIFIED)_-_7.62mm_Family.xlsx XLSX spreadsheet
Attachment_0022_-_Sample_OPSEC_Plan.pdf PDF
Attachment_0018_-_PWS_18_-_Facility_Plans,_Strategies,_and_Analyses.pdf PDF
Attachment_0048_-_Past_Performance_Questionnaire.pdf PDF
W52P1J-17-R-0141_-_DRAFT_29JUN18.pdf PDF
Attachment_0031_-_Price_Matrix_-_.22_Caliber_Family.xlsx XLSX spreadsheet
Attachment_0006_-_PWS_6_-_Fire_and_Emergency_Services.pdf PDF
Attachment_0035_-_FAAT_Price_Matrix_-_.22_Caliber.xlsx XLSX spreadsheet
Attachment_0038_-_EPA_Material_Content_Factors.pdf PDF
Exhibit_D_-_Contract_Data_Requirements_List_-_.30_Caliber.pdf PDF
Show 40 more

Latest 50 of 64 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
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Summary - EXAMPLE

Attachment 0039
June 20, 2018
Currency Fluctuation Example
All figures utilized in this spreadsheet are for illustrative purposes onlyDODIC Contract Award Price
ComponentDODICFX AdjustmentDODIC Order QuantityDODIC Matrix Price

Administrator: Price reflects the .50 Cal matrix price for the specific DODIC and the applicable range.

Matrix CostComponent Quantity Required (BOM)FX AdjustmentFX Adjusted CostFX Adjusted Matrix Price
MK211, Mod 0A606$7.56701,000,000$ 7.00007,000,000.001,000,0007,566,960.4914,566,960.49$ 14.5670

MK211, Mod 1 A607 $7.5670 1,000,000 $ 7.5000 7,500,000.00 1,000,000 7,566,960.49 15,066,960.49 $ 15.0670

MK211, Mod 1AA06$7.56701,000,000$ 8.00008,000,000.001,000,0007,566,960.4917,880,736.81$ 17.8807
MK263AA06$2.31381,000,0001,000,0002,313,776.32
MK211, Mod 1AA50$7.56701,000,000$ 8.50008,500,000.001,000,0007,566,960.4918,380,736.81$ 18.3807
MK263AA50$2.31381,000,0001,000,0002,313,776.32

MK263 AA58 $2.3138 1,000,000 $ 9.0000 9,000,000.00 1,000,000 2,313,776.32 11,313,776.32 $ 11.3138

MK211, Mod 1 AA41 $7.5670 1,000,000 $ 9.5000 9,500,000.00 1,000,000 7,566,960.49 17,066,960.49 $ 17.0670

Procurement Factor:
MK211, Mod 0A6061.0000

MK211, Mod 1 A607 1.0000

MK211, Mod 1AA061.0000
MK263AA061.0000
*Procurement Factors remains constant for all delivery orders
MK211, Mod 1AA501.0000
MK263AA501.0000

MK263 AA58 1.0000

MK211, Mod 1 AA41 1.0000

Attachment 0064 September 08, 2011

FX Adj. - EXAMPLE

Currency Fluctuation Example
All figures utilized in this spreadsheet are for illustrative purposes only
MK211, Mod 1PROJ MK211 Cal 50 Mod 1NOK
EoFX rate in contract (constant)6.00009/3/184.1265
PoCurrent USD Component Cost16.6667Component price will be pulled from DO 01-10 tabs9/4/184.1265
Current Kroner Component Cost100.0002009/5/184.1265
9/6/184.1265
ExAdjusted FX4.12659/7/184.1265
PxAdjusted USD Component Cost$ 24.233660Average4.1265
Cost diff due to FX$7.566960
MK211, Mod 0PROJ MK211 Cal 50 Mod 0
EoFX rate in contract (constant)6.0000
PoCurrent USD Component Cost16.6667Component price will be pulled from DO 01-10 tabs
Current Kroner Component Cost100.000200
ExAdjusted FX4.1265
PxAdjusted USD Component Cost$ 24.233660
Cost diff due to FX$7.566960
MK263CTG MK263 CAL 50CAD
EoFX rate in contract (constant)1.10009/3/180.97916
PoCurrent USD Component Cost20.0000Component price will be pulled from DO 01-10 tabs9/4/180.98555
Current Canadian Component Cost22.0000009/5/180.98558
9/6/180.98845
ExAdjusted FX0.9859389/7/180.99095
PxAdjusted USD Component Cost$ 22.313776Average0.985938
Cost diff due to FX$2.313776
FX website called out in contract:
http://www.oanda.com/convert/classic
Interbank Rate
Average Ask Price

http://www.oanda.com/convert/classic Summary - EXECUTION

Currency Fluctuation ExampleContractor Fill-in
DODIC Contract Award Price
DODICComponent
FXOrderDODIC MatrixMatrixQuantityFXFX AdjustedFX Adjusted
ComponentDODICAdjustmentQuantityPrice

Administrator: Price reflects the .50 Cal matrix price for the specific DODIC and the applicable range.

Cost Required (BOM) Adjustment Cost Matrix Price

MK211, Mod 0 A606 $0.0000 1 $0.0000 0 $0.0000 $0.0000 $0.0000

MK211, Mod 1 A607 $0.0000 1 $0.0000 0 $0.0000 $0.0000 $0.0000

MK211, Mod 1AA06$0.00001$0.00000$0.0000$0.0000$0.0000
MK263AA06$0.000010$0.0000
MK211, Mod 1AA50$0.00001$0.00000$0.0000$0.0000$0.0000
MK263AA50$0.000010$0.0000

MK263 AA58 $0.0000 1 $0.0000 0 $0.0000 $0.0000 $0.0000

MK211, Mod 1 AA41 $0.0000 1 $0.0000 0 $0.0000 $0.0000 $0.0000

Procurement Factor:
MK211, Mod 0A606

MK211, Mod 1 A607

MK211, Mod 1AA06
MK263AA06
*Procurement Factors remains constant for all delivery orders
MK211, Mod 1AA50
MK263AA50

MK263 AA58

MK211, Mod 1 AA41

FX Adj. - EXECUTION

Currency Fluctuation Example
MK211, Mod 1PROJ MK211 Cal 50 Mod 1NOK
EoFX rate in contract (constant)6.00009/3/181
PoCurrent USD Component Cost0.0000Component price will be pulled from DO 01-10 tabs9/4/181
Current Kroner Component Cost0.0000009/5/181
9/6/181
ExAdjusted FX19/7/181
PxAdjusted USD Component Cost$ - 0Average1
Cost diff due to FX$0.000000
MK211, Mod 0PROJ MK211 Cal 50 Mod 0
EoFX rate in contract (constant)6.0000
PoCurrent USD Component Cost0.0000Component price will be pulled from DO 01-10 tabs
Current Kroner Component Cost0.000000
ExAdjusted FX1
PxAdjusted USD Component Cost$ - 0
Cost diff due to FX$0.000000
MK263CTG MK263 CAL 50CAD
EoFX rate in contract (constant)1.10009/3/181
PoCurrent USD Component Cost0.0000Component price will be pulled from DO 01-10 tabs9/4/181
Current Canadian Component Cost0.0000009/5/181
9/6/181
ExAdjusted FX19/7/181
PxAdjusted USD Component Cost$ - 0Average1

Cost diff due to FX $0.000000

FX website called out in contract:
http://www.oanda.com/convert/classic
Interbank Rate
Average Ask Price

http://www.oanda.com/convert/classic

DO 01

Delivery Order 0001
Po =Current USD Component Cost
MK211, Mod 1MK211, Mod 0MK263
110,000,00019,999,999
220,000,00029,999,999
330,000,00039,999,999
440,000,00054,999,999
555,000,00075,000,000

DO 02

Delivery Order 0002
Po =Current USD Component Cost
MK211, Mod 1MK211, Mod 0MK263
110,000,00019,999,999
220,000,00029,999,999
330,000,00039,999,999
440,000,00054,999,999
555,000,00075,000,000

DO 03

Delivery Order 0003
Po =Current USD Component Cost
MK211, Mod 1MK211, Mod 0MK263
110,000,00019,999,999
220,000,00029,999,999
330,000,00039,999,999
440,000,00054,999,999
555,000,00075,000,000

DO 04

Delivery Order 0004
Po =Current USD Component Cost
MK211, Mod 1MK211, Mod 0MK263
110,000,00019,999,999
220,000,00029,999,999
330,000,00039,999,999
440,000,00054,999,999
555,000,00075,000,000

DO 05

Delivery Order 0005
Po =Current USD Component Cost
MK211, Mod 1MK211, Mod 0MK263
110,000,00019,999,999
220,000,00029,999,999
330,000,00039,999,999
440,000,00054,999,999
555,000,00075,000,000

DO 06

Delivery Order 0006
Po =Current USD Component Cost
MK211, Mod 1MK211, Mod 0MK263
110,000,00019,999,999
220,000,00029,999,999
330,000,00039,999,999
440,000,00054,999,999
555,000,00075,000,000

DO 07

Delivery Order 0007
Po =Current USD Component Cost
MK211, Mod 1MK211, Mod 0MK263
110,000,00019,999,999
220,000,00029,999,999
330,000,00039,999,999
440,000,00054,999,999
555,000,00075,000,000

DO 08

Delivery Order 0008
Po =Current USD Component Cost
MK211, Mod 1MK211, Mod 0MK263
110,000,00019,999,999
220,000,00029,999,999
330,000,00039,999,999
440,000,00054,999,999
555,000,00075,000,000

DO 09

Delivery Order 0009
Po =Current USD Component Cost
MK211, Mod 1MK211, Mod 0MK263
110,000,00019,999,999
220,000,00029,999,999
330,000,00039,999,999
440,000,00054,999,999
555,000,00075,000,000

DO 10

Delivery Order 0010
Po =Current USD Component Cost
MK211, Mod 1MK211, Mod 0MK263
110,000,00019,999,999
220,000,00029,999,999
330,000,00039,999,999
440,000,00054,999,999
555,000,00075,000,000

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