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 federal contract opportunity notice related to the production of small caliber ammunition and operation of the Lake City Army Ammunition Plant. The attachment provides an example worksheet for calculating currency fluctuations on component costs for five modifications of MK211 ammunition under a contract with delivery orders over ten years. The federal contract opportunity notice indicates the Army Contracting Command-Rock Island intends to issue a request for proposal for the Lake City Army Ammunition Plant contract covering fiscal years 2020 through 2029. This will be a firm-fixed-price production contract with a base period of five one-year ordering periods, two one-year evaluated option periods, and a three-year award term provision. The contract will also require maintenance and modernization of equipment and facilities at the plant, which produces ammunition such as 5.56mm, 7.62mm, .50 caliber, .30 caliber, and .22 caliber.

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
W52P1J-17-R-0141_0003.pdf PDF
W52P1J-17-R-0141_0003.pdf PDF
Attachment_0039_-_Currency_Fluctuation_Worksheet.xlsx XLSX spreadsheet
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 .