Attachment_0039_-_Currency_Fluctuation_Worksheet.xlsx

XLSX spreadsheet 37 KB Posted

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

About this file

Written by GovTribe AI ·

This document contains an attachment and related federal contract opportunity notice. The attachment appears to be a template currency fluctuation worksheet for a small caliber ammunition contract, providing examples of pricing adjustments for various contract line items based on exchange rate fluctuations between the contract award and delivery order dates.

The related federal contract opportunity is a notice for solicitation number W52P1J-17-R-0141 to produce small caliber ammunition at the Lake City Army Ammunition Plant and provide production base support and modernization services from fiscal year 2020 through 2029. The Army Contracting Command-Rock Island intends to conduct a best value source selection and award a firm-fixed-price production contract consisting of a base period and five one-year ordering periods, with options to extend for two additional one-year periods and a three-year award term. The contract will include a one-year transition period after the base ordering periods are completed.

From the source

Attachment 0039 - Currency Fluctuation Worksheet

View the file

Other files

File Type Posted
LCAAP_J&A_-_Redacted.pdf PDF
Attachment_0030_-_Price_Matrix__.50_Caliber_Family.xlsx XLSX spreadsheet
Attachment_0033_-_FAT_Price_Matrix_-_7.62mm.xlsx XLSX spreadsheet
Attachment_0039_-_Currency_Fluctuation_Worksheet.xlsx XLSX spreadsheet
W52P1J-17-R-0141_0003.pdf PDF
W52P1J-17-R-0141_0003.pdf PDF
Attachment_0033_-_FAT_Price_Matrix_-_7.62mm.xlsx XLSX spreadsheet
Attachment_0030_-_Price_Matrix__.50_Caliber_Family.xlsx XLSX spreadsheet
Attachment_0001_-_PWS_1_-_Maintenance.pdf PDF
Attachment_0035_-_FAT_Price_Matrix_-_.22_Caliber.xlsx XLSX spreadsheet
Attachment_0032_-_FAT_Price_Matrix_-_5.56mm.xlsx XLSX spreadsheet
Attachment_0007_-_PWS_7_-_Government_Property_in_Possession_of_the_Contractor.pdf PDF
Attachment_0034_-_FAT_Price_Matrix_-_.50_Caliber.xlsx XLSX spreadsheet
W52P1J-17-R-0141_0002.pdf PDF
Attachment_0033_-_FAT_Price_Matrix_-_7.62mm.xlsx XLSX spreadsheet
Exhibit_A_-_Contract_Data_Requirements_List_-_Production_Items.pdf PDF
Attachment_0042_-_Price_Matrix_(INDEMNIFIED)_-_.50_Caliber_Family.xlsx XLSX spreadsheet
Exhibit_B_-_Contract_Data_Requirements_List_-_PWS.pdf PDF
Attachment_0034_-_FAT_Price_Matrix_-_.50_Caliber.xlsx XLSX spreadsheet
Attachment_0021_-_Ammunition_Data_Card_Component_Listings.pdf PDF
Attachment_0030_-_Price_Matrix__.50_Caliber_Family.xlsx XLSX spreadsheet
W52P1J-17-R-0141_0001.pdf PDF
Attachment_0018_-_PWS_18_-_Facility_Plans_Strategies_and_Analyses.pdf PDF
Attachment_0030_-_Price_Matrix__.50_Caliber_Family.xlsx XLSX spreadsheet
LCAAP_RFP_Q&As.pdf PDF
Attachment_0042_-_Price_Matrix_(INDEMNIFIED)_-_.50_Caliber_Family.xlsx XLSX spreadsheet
Attachment_0034_-_FAT_Price_Matrix_-_.50_Caliber.xlsx XLSX spreadsheet
Attachment_0041_-_Price_Matrix_(INDEMNIFIED)_-_7.62mm_Family.xlsx XLSX spreadsheet
Attachment_0030_-_Price_Matrix__.50_Caliber_Family.xlsx XLSX spreadsheet
Attachment_0031_-_Price_Matrix_-_.22_Caliber_Family.xlsx XLSX spreadsheet
Attachment_0042_-_Price_Matrix_(INDEMNIFIED)_-_.50_Caliber_Family.xlsx XLSX spreadsheet
Attachment_0026_-_ARMS_Tenant_Use_Agreements_(FOR_POSTING).pdf PDF
Attachment_0002_-_PWS_2_-_Safety.pdf PDF
Attachment_0016_-_PWS_16_-_On-Site_Government_Personnel_Support.pdf PDF
Attachment_0001_-_PWS_1_-_Maintenance.pdf PDF
Attachment_0032_-_FAT_Price_Matrix_-_5.56mm.xlsx XLSX spreadsheet
Attachment_0008_-_PWS_8_-_Ammunition_Materiel_Management.pdf PDF
Attachment_0003_-_PWS_3_-_Security_and_Antiterrorism_(FOR_POSTING).pdf PDF
Attachment_0019_-_PWS_19_-_Army_Family_Housing.pdf PDF
Attachment_0004_-_PWS_4_-_Environmental.pdf PDF
Attachment_0021_-_Ammunition_Data_Card_Component_Listings.pdf PDF
Attachment_0020_-_Enhanced_Performance_Round_Non-Disclosure_Agreements.pdf PDF
Attachment_0051_-_Example_Order_-_.50_Caliber.pdf PDF
Attachment_0018_-_PWS_18_-_Facility_Plans_Strategies_and_Analyses.pdf PDF
Attachment_0027_-_Award_Term_Plan.pdf PDF
Attachment_0023_-_Government_Furnished_Property_(FOR_POSTING).pdf PDF
Attachment_0005_-_PWS_5_-_Utilities_and_Energy.pdf PDF
Attachment_0052_-_CDRL_Guidance.pdf PDF
Attachment_0014_-_PWS_14_-_Mail_Services.pdf PDF
Attachment_0037_-_Price_Matrix_-_Summary_Evaluation_Matrix.xlsx XLSX spreadsheet
Show 40 more

Latest 50 of 81 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.

EXAMPLE - FX Summary & Calc.

Attachment 0039
September 15, 2018
Currency Fluctuation Example - SummaryDODIC Contract Award Price
All figures utilized in this spreadsheet are for illustrative purposes only
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$ 11.73361,000,000$ 7.0000$ 7,000,000.001,000,000$ 11,733,612.0199$ 18,733,612.0199$ 18.7336
MK211, Mod 1A607$ 11.73361,000,000$ 7.5000$ 7,500,000.00800,000$ 9,386,889.6159$ 16,886,889.6159$ 16.8869
MK211, Mod 1AA06$ 11.73361,000,000$ 8.0000$ 8,000,000.00400,000$ 4,693,444.8079$ 12,693,444.8079$ 12.6934
MK211, Mod 1AA50$ 11.73361,000,000$ 8.5000$ 8,500,000.00400,000$ 4,693,444.8079$ 13,193,444.8079$ 13.1934
MK211, Mod 1AA41$ 11.73361,000,000$ 9.5000$ 9,500,000.001,000,000$ 11,733,612.0199$ 21,233,612.0199$ 21.2336
Procurement Factor
MK211, Mod 0A6061.0000
MK211, Mod 1A6070.8000
MK211, Mod 1AA060.4000
MK211, Mod 1AA500.4000
MK211, Mod 1AA411.0000
*Procurement Factors remains constant for all delivery orders
Currency Fluctuation Example - Calculation
All figures utilized in this spreadsheet are for illustrative purposes only
MK211, Mod 1
EoFX rate in contract (constant)8.0000FX Website
PoCurrent USD Component Cost$ 12.5000Price from DO 01-10 tabshttp://www.oanda.com/convert/classic
Current Kroner Component Cost100.0000Interbank Rate
Average Ask Price
ExAdjusted FX4.1265
PxAdjusted USD Component Cost$ 24.2336NOK
9/3/184.1265
Cost diff due to FX$ 11.73369/4/184.1265
9/5/184.1265
MK211, Mod 09/6/184.1265
EoFX rate in contract (constant)8.00009/7/184.1265
PoCurrent USD Component Cost$ 12.5000Price from DO 01-10 tabsAverage4.1265
Current Kroner Component Cost100.0000
ExAdjusted FX4.1265
PxAdjusted USD Component Cost$ 24.2336

Cost diff due to FX $ 11.7336

Attachment 0064 September 08, 2011 http://www.oanda.com/convert/classic EXECUTION - FX Summary & Calc.

Attachment 0039
September 15, 2018
Currency Fluctuation Example - SummaryDODIC Contract Award Price
All figures utilized in this spreadsheet are for illustrative purposes onlyContractor Fill-in
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 0A606ERROR:#DIV/0!1,000,000$ 7.0000$ 7,000,000.000ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
MK211, Mod 1A607ERROR:#DIV/0!1,000,000$ 7.5000$ 7,500,000.000ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
MK211, Mod 1AA06ERROR:#DIV/0!1,000,000$ 8.0000$ 8,000,000.000ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
MK211, Mod 1AA50ERROR:#DIV/0!1,000,000$ 8.5000$ 8,500,000.000ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
MK211, Mod 1AA41ERROR:#DIV/0!1,000,000$ 9.5000$ 9,500,000.000ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Procurement Factor
MK211, Mod 0A6060.0000
MK211, Mod 1A6070.0000
MK211, Mod 1AA060.0000
MK211, Mod 1AA500.0000
MK211, Mod 1AA410.0000
*Procurement Factors remains constant for all delivery orders
Currency Fluctuation Example - Calculation
All figures utilized in this spreadsheet are for illustrative purposes only
MK211, Mod 1
EoFX rate in contract (constant)8.0000FX Website
PoCurrent USD Component Cost$ - 0Price from DO 01-10 tabshttp://www.oanda.com/convert/classic
Current Kroner Component Cost- 0Interbank Rate
Average Ask Price
ExAdjusted FX- 0
PxAdjusted USD Component CostERROR:#DIV/0!NOK
9/3/180.0000
Cost diff due to FXERROR:#DIV/0!9/4/180.0000
9/5/180.0000
MK211, Mod 09/6/180.0000
EoFX rate in contract (constant)8.00009/7/180.0000
PoCurrent USD Component Cost$ - 0Price from DO 01-10 tabsAverage0.0000
Current Kroner Component Cost- 0
ExAdjusted FX- 0
PxAdjusted USD Component CostERROR:#DIV/0!

Cost diff due to FX ERROR:#DIV/0!

Attachment 0064 September 08, 2011 http://www.oanda.com/convert/classic

DO 01

Delivery Order 0001
Po =Current USD Component Cost
MK211, Mod 1MK211, Mod 0Contractor Fill-in
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 0Contractor Fill-in
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 0Contractor Fill-in
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 0Contractor Fill-in
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 0Contractor Fill-in
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 0Contractor Fill-in
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 0Contractor Fill-in
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 0Contractor Fill-in
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 0Contractor Fill-in
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 0Contractor Fill-in
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 .