Attachment 2 - PPVG GEN V - Price Proposal Submission Spreadsheet updated Amendment 0004.xlsx

XLSX spreadsheet 26 KB Posted May 9, 2024

Attached to: Pharmaceutical Prime Vendor Global GEN V Solicitation
Solicitation number: SPE2DX-24-R-0001_SOLICITATION
Issued by: Defense Logistics Agency Troop Support Medical

About this file

Written by GovTribe AI · May 9, 2024

This document is an Excel price proposal workbook for the Pharmaceutical Prime Vendor Generation V (PPV-G GEN V) Solicitation SPE2DX-24-R-0001 issued by the Defense Logistics Agency Troop Support Medical.

The workbook provides pricing details for brand, generic, and specialty pharmaceutical line items in the North/EUCOM, West/PACOM, South/SOUTHCOM, Fleet, and Back-Up regions over three 30-month option periods. The total aggregate price across all regions and periods is $29,335,798,340.96. The workbook requires offerors to input a distribution fee percentage, which will automatically calculate the total price for each line item. There are no period savings values provided. This appears to be a pricing template for offerors to submit their proposals in response to the PPV-G GEN V solicitation.

View the file

Other files

File	Type	Posted
SPE2DX24R0001 revised by Amendment 0008.pdf	PDF	Jun 6, 2024
SPE2DX24R0001 AMENDMENT 0008.pdf	PDF	Jun 6, 2024
SPE2DX24R0001 AMENDMENT 0007.pdf	PDF	May 22, 2024
SPE2DX24R0001 AMENDMENT 0006.pdf	PDF	May 20, 2024
Attachment 9 - NIST SP 800-171 Assessment Summary updated Amendment 0006.xlsx	XLSX spreadsheet	May 20, 2024
SPE2DX24R0001 AMENDMENT 0005.pdf	PDF	May 15, 2024
SPE2DX24R0001 AMENDMENT 0004.pdf	PDF	May 9, 2024
Attachment 6 - PPV-G PVR-WRM Requirements Spreadsheet Updated Amendment 0004.xlsx	XLSX spreadsheet	May 9, 2024
Amendment 0004 Submitted Questions and Answers.pdf	PDF	May 9, 2024
Amendment 0004 Language -solicitation changes.pdf	PDF	May 9, 2024
SPE2DX24R0001 Revised by Amendment 0004.pdf	PDF	May 9, 2024
SPE2DX24R0001 AMENDMENT 0003.pdf	PDF	Apr 24, 2024
Attachment 3 - PPV-G Specialty Drug List 3.27.24.xlsx	XLSX spreadsheet	Mar 27, 2024
SPE2DX24R0001 AMENDMENT 0002.pdf	PDF	Mar 27, 2024
SPE2DX24R0001 AMENDMENT 0001.pdf	PDF	Mar 19, 2024
Attachment 2 - PPVG GEN V - Price Proposal Submission Spreadsheet.xlsx	XLSX spreadsheet	Mar 13, 2024
Attachment 8 - NIST SP 800-171 System Security Plan Template.docx	DOCX document	Mar 13, 2024
Attachment 11 - NIST.SP.800-171(r2) Publication.pdf	PDF	Mar 13, 2024
Attachment 5 - Preservation Packaging Packing Labeling and Marking PPPLM.pdf	PDF	Mar 13, 2024
Attachment 6 - PPV-G PVR-WRM Requirements Spreadsheet.xlsx	XLSX spreadsheet	Mar 13, 2024
Attachment 9 - NIST SP 800-171 Assessment Summary.xlsx	XLSX spreadsheet	Mar 13, 2024
SPE2DX24R0001 Final 3.13.24.pdf	PDF	Mar 13, 2024
Attachment 7 - PPV-G Day-to-Day Requirements Spreadsheets.xlsx	XLSX spreadsheet	Mar 13, 2024
Attachment 1 - PPVG GEN IV 2023 SALES BY NDC.xlsx	XLSX spreadsheet	Mar 13, 2024
Attachment 10 - NIST SP 800-171 Assessment Methodology.pdf	PDF	Mar 13, 2024
Attachment 3 - PPV-G Specialty Drug List.xlsx	XLSX spreadsheet	Mar 13, 2024
Attachment 4 - Discrepancy Report Template.XLSX	XLSX spreadsheet	Mar 13, 2024

Show all 27

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.

NORTH-EUCOM

PPVG GEN V PRICE PROPOSAL WORKBOOK

NORTH/EUCOM LINE ITEMS 0001AA - 0002AD
LINE ITEM	REGION	TIME PERIOD	DESCRIPTION	DISTRIBUTION FEE OFFEROR INPUT ↓	PPVG SALES	PERIOD SAVINGS	TOTAL PRICE
0001AA	North/EUCOM	Base 30 Month Period	Brand and Generic		$ 1,699,577,692.79	$ - 0	$ 1,699,577,692.79
0001AB	North/EUCOM	1st 30 Month Option Period	Brand and Generic		$ 1,853,565,814.09	$ - 0	$ 1,853,565,814.09
0001AC	North/EUCOM	2nd 30 Month Option Period	Brand and Generic		$ 2,036,179,050.83	$ - 0	$ 2,036,179,050.83
0001AD	North/EUCOM	3rd 30 Month Option Period	Brand and Generic		$ 2,220,664,519.20	$ - 0	$ 2,220,664,519.20
0002AA	North/EUCOM	Base 30 Month Period	Specialty		$ 424,894,423.20	$ - 0	$ 424,894,423.20
0002AB	North/EUCOM	1st 30 Month Option Period	Specialty		$ 463,391,453.52	$ - 0	$ 463,391,453.52
0002AC	North/EUCOM	2nd 30 Month Option Period	Specialty		$ 509,044,762.71	$ - 0	$ 509,044,762.71
0002AD	North/EUCOM	3rd 30 Month Option Period	Specialty		$ 555,166,129.80	$ - 0	$ 555,166,129.80
TOTAL AGGREGATE PERIOD SAVINGS ---------->						$ - 0
TOTAL AGGREGATE PRICE ---------->							$ 9,762,483,846.13
Input distribution fees in column E as a percentage.
Period savings, total price, total aggregate period savings, and total aggregate price will be calculated automatically.

WEST-PACOM

PPVG GEN V PRICE PROPOSAL WORKBOOK

WEST/PACOM LINE ITEMS 0003AA - 0004AD
LINE ITEM	REGION	TIME PERIOD	DESCRIPTION	DISTRIBUTION FEE OFFEROR INPUT ↓	PPVG SALES	PERIOD SAVINGS	TOTAL PRICE
0003AA	West/Pacom	Base 30 Month Period	Brand and Generic		$ 1,635,519,334.07	$ - 0	$ 1,635,519,334.07
0003AB	West/Pacom	1st 30 Month Option Period	Brand and Generic		$ 1,783,703,527.52	$ - 0	$ 1,783,703,527.52
0003AC	West/Pacom	2nd 30 Month Option Period	Brand and Generic		$ 1,959,433,934.32	$ - 0	$ 1,959,433,934.32
0003AD	West/Pacom	3rd 30 Month Option Period	Brand and Generic		$ 2,136,966,006.94	$ - 0	$ 2,136,966,006.94
0004AA	West/Pacom	Base 30 Month Period	Specialty		$ 408,879,833.52	$ - 0	$ 408,879,833.52
0004AB	West/Pacom	1st 30 Month Option Period	Specialty		$ 445,925,881.88	$ - 0	$ 445,925,881.88
0004AC	West/Pacom	2nd 30 Month Option Period	Specialty		$ 489,858,483.58	$ - 0	$ 489,858,483.58
0004AD	West/Pacom	3rd 30 Month Option Period	Specialty		$ 534,241,501.73	$ - 0	$ 534,241,501.73
TOTAL AGGREGATE PERIOD SAVINGS ---------->						$ - 0
TOTAL AGGREGATE PRICE ---------->							$ 9,394,528,503.57
Input distribution fees in column E as a percentage.
Period savings, total price, total aggregate period savings, and total aggregate price will be calculated automatically.

SOUTH-SOUTHCOM

PPVG GEN V PRICE PROPOSAL WORKBOOK

SOUTH/SOUTHCOM LINE ITEMS 0005AA - 0006AD
LINE ITEM	REGION	TIME PERIOD	DESCRIPTION	DISTRIBUTION FEE OFFEROR INPUT ↓	PPVG SALES	PERIOD SAVINGS	TOTAL PRICE
0005AA	South/SOUTHCOM	Base 30 Month Period	Brand and Generic		$ 1,705,815,594.23	$ - 0	$ 1,705,815,594.23
0005AB	South/SOUTHCOM	1st 30 Month Option Period	Brand and Generic		$ 1,860,368,892.84	$ - 0	$ 1,860,368,892.84
0005AC	South/SOUTHCOM	2nd 30 Month Option Period	Brand and Generic		$ 2,043,652,368.65	$ - 0	$ 2,043,652,368.65
0005AD	South/SOUTHCOM	3rd 30 Month Option Period	Brand and Generic		$ 2,228,814,947.67	$ - 0	$ 2,228,814,947.67
0006AA	South/SOUTHCOM	Base 30 Month Period	Specialty		$ 426,453,898.56	$ - 0	$ 426,453,898.56
0006AB	South/SOUTHCOM	1st 30 Month Option Period	Specialty		$ 465,092,223.21	$ - 0	$ 465,092,223.21
0006AC	South/SOUTHCOM	2nd 30 Month Option Period	Specialty		$ 510,913,092.16	$ - 0	$ 510,913,092.16
0006AD	South/SOUTHCOM	3rd 30 Month Option Period	Specialty		$ 557,203,736.92	$ - 0	$ 557,203,736.92
TOTAL AGGREGATE PERIOD SAVINGS ---------->						$ - 0
TOTAL AGGREGATE PRICE ---------->							$ 9,798,314,754.23
Input distribution fees in column E as a percentage.
Period savings, total price, total aggregate period savings, and total aggregate price will be calculated automatically.

FLEET

PPVG GEN V PRICE PROPOSAL WORKBOOK

FLEET (CONUS & OCONUS) LINE ITEMS 0007AA - 0008AD
LINE ITEM	REGION	TIME PERIOD	DESCRIPTION	DISTRIBUTION FEE OFFEROR INPUT ↓	PPVG SALES	PERIOD SAVINGS	TOTAL PRICE
0007AA	FLEET	Base 30 Month Period	Brand and Generic		$ 13,661,333.27	$ - 0	$ 13,661,333.27
0007AB	FLEET	1st 30 Month Option Period	Brand and Generic		$ 14,899,101.37	$ - 0	$ 14,899,101.37
0007AC	FLEET	2nd 30 Month Option Period	Brand and Generic		$ 16,366,960.29	$ - 0	$ 16,366,960.29
0007AD	FLEET	3rd 30 Month Option Period	Brand and Generic		$ 17,849,868.36	$ - 0	$ 17,849,868.36
0008AA	FLEET	Base 30 Month Period	Specialty		$ 3,415,333.32	$ - 0	$ 3,415,333.32
0008AB	FLEET	1st 30 Month Option Period	Specialty		$ 3,724,775.34	$ - 0	$ 3,724,775.34
0008AC	FLEET	2nd 30 Month Option Period	Specialty		$ 4,091,740.07	$ - 0	$ 4,091,740.07
0008AD	FLEET	3rd 30 Month Option Period	Specialty		$ 4,462,467.09	$ - 0	$ 4,462,467.09
TOTAL AGGREGATE PERIOD SAVINGS ---------->						$ - 0
TOTAL AGGREGATE PRICE ---------->							$ 78,471,579.11
Input distribution fees in column E as a percentage.
Period savings, total price, total aggregate period savings, and total aggregate price will be calculated automatically.

BACK-UP

PPVG GEN V PRICE PROPOSAL WORKBOOK

BACK-UP (ALL REGIONS) LINE ITEMS 0009AA - 0010AD
LINE ITEM	REGION	TIME PERIOD	DESCRIPTION	DISTRIBUTION FEE OFFEROR INPUT ↓	PPVG SALES	PERIOD SAVINGS	TOTAL PRICE
0009AA	Back-Up	Base 30 Month Period	Brand and Generic		$ 226,320,502.28	$ - 0	$ 226,320,502.28
0009AB	Back-Up	1st 30 Month Option Period	Brand and Generic		$ 246,825,989.68	$ - 0	$ 246,825,989.68
0009AC	Back-Up	2nd 30 Month Option Period	Brand and Generic		$ 271,143,277.22	$ - 0	$ 271,143,277.22
0009AD	Back-Up	3rd 30 Month Option Period	Brand and Generic		$ 295,709,876.35	$ - 0	$ 295,709,876.35
0010AA	Back-Up	Base 30 Month Period	Specialty		$ 56,580,125.57	$ - 0	$ 56,580,125.57
0010AB	Back-Up	1st 30 Month Option Period	Specialty		$ 61,706,497.42	$ - 0	$ 61,706,497.42
0010AC	Back-Up	2nd 30 Month Option Period	Specialty		$ 67,785,819.31	$ - 0	$ 67,785,819.31
0010AD	Back-Up	3rd 30 Month Option Period	Specialty		$ 73,927,469.09	$ - 0	$ 73,927,469.09
TOTAL AGGREGATE PERIOD SAVINGS ---------->						$ - 0
TOTAL AGGREGATE PRICE ---------->							$ 1,299,999,556.92
Input distribution fees in column E as a percentage.
Period savings, total price, total aggregate period savings, and total aggregate price will be calculated automatically.

File details come from the government source that posted it. Updated May 9, 2024.