J_4_Offeror_Discount_Rebate_Workbook.xlsx
XLSX spreadsheet 35 KB Posted
- Solicitation number
- 1605C3-21-R-00011
- Issued by
- Not on record
View the file
Other files
Show all 19
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Instructions
| INSTRUCTIONS FOR OFFERORS | |
| Purpose: | The purpose of this excel workbook is to: |
| 1. Display the Offeror's discount. | |
| 2. Transparently show Offerors the impact of those discounts projected over all option periods. | |
| 3. Will be used as a reference point for the government when evaluating the price/discount proposals from various Offerors. If discrepencies exist between the discounts an Offeror includes in this excel workbook and the discounts an Offeror includes in their submitted proposal pricing volume, the government will utilize the pricing volume in the submitted narrative proposal. The Offerors can not change the Government's pricing model in this excel workbook. | |
| Step | |
| 1 | On the "Discounts.Rebates" Tab: |
-Insert discount percentages into the appropriate rows and columns (yellow cells).
-Discounts should be inserted as negative numbers.
-Discounts for drugs and supplies should be represented as discounts from AWP.
-Discounts for DME should be represented as discounts from the OWCP fee schedule allowed amounts.
*For example, if an Offeror would like to input a 25% discount (AWP - 25%) for retail brand name drugs for the base year, place "-25" in cell B2. Excel will automatically convert it to a percentage.
2 On the "Discounts.Rebates" Tab:
-Place the total rebate per prescription in terms of negative dollars for the (orange cells).
*For example, if an Offeror would like to input a $5 rebate per prescription for brand name retail drugs for the base year, place "-5" in cell B16. Excel will automatically convert it to a dollar amount.
3 View the "Projected Price" tab as needed to continue to improve your overall offeror to the government. This tab will update as the "Discounts.Rebates" tab updates.
*The "Projected Price" tab is populated using estimates from the "GOV Projections" tab. These projections are further described in the RFP under Instructions, Conditions, and Notices to Bidders.
4 Double Check your discounts and rebates for accuracy and ensure they meet any go/no go requirements set forth in the RFP. The Government has provided example tabs ("Discounts.Rebates - Example", and "Projected Price - Example") to further show Offerors an example of how their discounts and rebates may appear.
Discounts.Rebates
| Base Period | Option Period 1 | Option Period 2 | Option Period 3 | Option Period 4 | |
| Discount CLINS | |||||
| Brand Name Retail | |||||
| Generic Name Retail | |||||
| Brand Name (Mail order or 84 or more day supply) | |||||
| Generic Name (Mail order or 84 or more day supply) | |||||
| Compounded Drugs | |||||
| Specialty Drugs (Brand Name Retail) | |||||
| Specialty Drugs (Generic Name Retail) | |||||
| Specialty Drugs (Brand Name Mail order or 84 or more day supply) | |||||
| Specialty Drugs (Generic Name Mail order or 84 or more day supply) | |||||
| Rx Supplies | |||||
| Durable Medical Equipment (DME) |
| Rebate CLINS | |||||
| Brand Name Retail | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Brand Name (mail order or 84 or more day supply) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Specialty Drugs (Brand Name Retail) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Specialty Drugs (Brand Name Mail order or 84 or more day supply) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Projected Price
| Base Period | Option Period 1 | Option Period 2 | Option Period 3 | Option Period 4 | Base + All Option Periods | |
| Discount CLINS | ||||||
| Brand Name Retail | $ 31,331,513.30 | $ 39,477,706.76 | $ 41,451,592.09 | $ 43,524,171.70 | $ 45,700,380.28 | $ 201,485,364.13 |
| Generic Name Retail | $ 24,109,422.73 | $ 29,509,933.42 | $ 30,100,132.09 | $ 30,702,134.73 | $ 31,316,177.43 | $ 145,737,800.39 |
| Brand Name (Mail order or 84 or more day supply) | $ 11,462,666.19 | $ 14,442,959.40 | $ 15,165,107.37 | $ 15,923,362.74 | $ 16,719,530.87 | $ 73,713,626.56 |
| Generic Name (Mail order or 84 or more day supply) | $ 12,923,599.22 | $ 15,818,485.45 | $ 16,134,855.16 | $ 16,457,552.26 | $ 16,786,703.31 | $ 78,121,195.40 |
| Compounded Drugs | $ 2,709,311.29 | $ 1,625,586.77 | $ 812,793.39 | $ 406,396.69 | $ 203,198.35 | $ 5,757,286.49 |
| Specialty Drugs (Brand Name Retail) | $ 39,827,453.30 | $ 51,138,450.04 | $ 54,718,141.54 | $ 58,548,411.45 | $ 62,646,800.25 | $ 266,879,256.60 |
| Specialty Drugs (Generic Name Retail) | $ 3,576,560.75 | $ 4,592,304.01 | $ 4,913,765.29 | $ 5,257,728.86 | $ 5,625,769.88 | $ 23,966,128.77 |
| Specialty Drugs (Brand Name Mail order or 84 or more day supply) | $ 9,025,250.01 | $ 11,588,421.01 | $ 12,399,610.48 | $ 13,267,583.21 | $ 14,196,314.04 | $ 60,477,178.75 |
| Specialty Drugs (Generic Name Mail order or 84 or more day supply) | $ 1,624,262.47 | $ 2,085,553.01 | $ 2,231,541.72 | $ 2,387,749.64 | $ 2,554,892.12 | $ 10,883,998.96 |
| Rx Supplies | $ 543,254.54 | $ 684,500.72 | $ 718,725.75 | $ 754,662.04 | $ 792,395.14 | $ 3,493,538.20 |
| Durable Medical Equipment (DME) | $ 264,228.81 | $ 479,416.75 | $ 419,489.66 | $ 440,464.14 | $ 462,487.35 | $ 2,066,086.70 |
| Total Discount CLINS = | $ 137,397,522.61 | $ 171,443,317.33 | $ 179,065,754.54 | $ 187,670,217.47 | $ 197,004,649.01 | $ 872,581,460.96 |
| Rebate CLINS | ||||||
| Brand Name Retail | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Brand Name (mail order or 84 or more day supply) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Specialty Drugs (Brand Name Retail) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Specialty Drugs (Brand Name Mail order or 84 or more day supply) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Rebate CLINS = | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Total ALL CLINS = $ 137,397,522.61 $ 171,443,317.33 $ 179,065,754.54 $ 187,670,217.47 $ 197,004,649.01 $ 872,581,460.96
Discounts.Rebates - Example
| Base Period | Option Period 1 | Option Period 2 | Option Period 3 | Option Period 4 | |
| Discount CLINS | |||||
| Brand Name Retail | -17.00% | -17.50% | -18.00% | -18.50% | -19.00% |
| Generic Name Retail | -65.00% | -66.00% | -67.00% | -68.00% | -69.00% |
| Brand Name (Mail order or 84 or more day supply) | -20.00% | -20.50% | -21.00% | -21.50% | -22.00% |
| Generic Name (Mail order or 84 or more day supply) | -67.00% | -68.00% | -69.00% | -70.00% | -71.00% |
| Compounded Drugs | -70.00% | -70.00% | -70.00% | -70.00% | -70.00% |
| Specialty Drugs (Brand Name Retail) | -11.00% | -12.00% | -13.00% | -14.00% | -15.00% |
| Specialty Drugs (Generic Name Retail) | -25.00% | -26.00% | -27.00% | -28.00% | -29.00% |
| Specialty Drugs (Brand Name Mail order or 84 or more day supply) | -11.00% | -12.00% | -13.00% | -14.00% | -15.00% |
| Specialty Drugs (Generic Name Mail order or 84 or more day supply) | -25.00% | -26.00% | -27.00% | -28.00% | -29.00% |
| Rx Supplies | -40.00% | -40.00% | -40.00% | -40.00% | -40.00% |
| Durable Medical Equipment (DME) | -5.00% | -5.00% | -5.00% | -5.00% | -5.00% |
| Rebate CLINS | |||||
| Brand Name Retail | $ (3.00) | $ (4.00) | $ (5.00) | $ (6.50) | $ (7.50) |
| Brand Name (mail order or 84 or more day supply) | $ (1.00) | $ (2.00) | $ (3.00) | $ (4.00) | $ (5.00) |
| Specialty Drugs (Brand Name Retail) | $ (8.00) | $ (9.00) | $ (10.00) | $ (11.00) | $ (12.00) |
| Specialty Drugs (Brand Name Mail order or 84 or more day supply) | $ (9.00) | $ (10.00) | $ (11.00) | $ (12.00) | $ (13.00) |
Projected Price - Example
| Base Period | Option Period 1 | Option Period 2 | Option Period 3 | Option Period 4 | Base + All Option Periods | |
| Discount CLINS | ||||||
| Brand Name Retail | $ 26,005,156.04 | $ 32,569,108.07 | $ 33,990,305.52 | $ 35,472,199.93 | $ 37,017,308.03 | $ 165,054,077.59 |
| Generic Name Retail | $ 8,438,297.96 | $ 10,033,377.36 | $ 9,933,043.59 | $ 9,824,683.11 | $ 9,708,015.00 | $ 47,937,417.02 |
| Brand Name (Mail order or 84 or more day supply) | $ 9,170,132.95 | $ 11,482,152.72 | $ 11,980,434.82 | $ 12,499,839.75 | $ 13,041,234.08 | $ 58,173,794.32 |
| Generic Name (Mail order or 84 or more day supply) | $ 4,264,787.74 | $ 5,061,915.34 | $ 5,001,805.10 | $ 4,937,265.68 | $ 4,868,143.96 | $ 24,133,917.82 |
| Compounded Drugs | $ 812,793.39 | $ 487,676.03 | $ 243,838.02 | $ 121,919.01 | $ 60,959.50 | $ 1,727,185.95 |
| Specialty Drugs (Brand Name Retail) | $ 35,446,433.44 | $ 45,001,836.04 | $ 47,604,783.14 | $ 50,351,633.85 | $ 53,249,780.22 | $ 231,654,466.68 |
| Specialty Drugs (Generic Name Retail) | $ 2,682,420.56 | $ 3,398,304.96 | $ 3,587,048.66 | $ 3,785,564.78 | $ 3,994,296.61 | $ 17,447,635.57 |
| Specialty Drugs (Brand Name Mail order or 84 or more day supply) | $ 8,032,472.51 | $ 10,197,810.49 | $ 10,787,661.12 | $ 11,410,121.56 | $ 12,066,866.93 | $ 52,494,932.61 |
| Specialty Drugs (Generic Name Mail order or 84 or more day supply) | $ 1,218,196.85 | $ 1,543,309.23 | $ 1,629,025.46 | $ 1,719,179.74 | $ 1,813,973.40 | $ 7,923,684.68 |
| Rx Supplies | $ 407,440.90 | $ 506,530.53 | $ 524,669.80 | $ 543,356.67 | $ 562,600.55 | $ 2,544,598.46 |
| Durable Medical Equipment (DME) | $ 251,017.37 | $ 455,445.91 | $ 398,515.17 | $ 418,440.93 | $ 439,362.98 | $ 1,962,782.37 |
| Total Discount CLINS = | $ 96,729,149.71 | $ 120,737,466.70 | $ 125,681,130.39 | $ 131,084,205.02 | $ 136,822,541.27 | $ 611,054,493.09 |
| Rebate CLINS | ||||||
| Brand Name Retail | $ (187,934.25) | $ (315,729.54) | $ (414,395.02) | $ (565,649.20) | $ (685,305.77) | $ (2,169,013.78) |
| Brand Name (mail order or 84 or more day supply) | $ (7,793.63) | $ (19,639.94) | $ (30,932.90) | $ (43,306.06) | $ (56,839.20) | $ (158,511.71) |
| Specialty Drugs (Brand Name Retail) | $ (23,219.00) | $ (33,539.85) | $ (39,875.15) | $ (46,933.05) | $ (54,783.67) | $ (198,350.72) |
| Specialty Drugs (Brand Name Mail order or 84 or more day supply) | $ (3,707.55) | $ (5,289.44) | $ (6,225.67) | $ (7,267.05) | $ (8,423.73) | $ (30,913.44) |
| Total Rebate CLINS = | $ (222,654.43) | $ (374,198.76) | $ (491,428.74) | $ (663,155.36) | $ (805,352.36) | $ (2,556,789.65) |
Total ALL CLINS = $ 96,506,495.28 $ 120,363,267.94 $ 125,189,701.66 $ 130,421,049.65 $ 136,017,188.91 $ 608,497,703.45
GOV Projections
| Energy | Black Lung | Total | Total | Total | Total | Total | Total | Total | Projection Assumptions | |
| Discounts (100%AWP for Drugs, and Paid Amounts for DME) | CY2020 - Baseline | CY2020 - Baseline | CY2020 - Baseline | Base Period (10/12) | Option Period 1 | Option Period 2 | Option Period 3 | Option Period 4 | Base + All Option Periods | Assumptions Year over Year |
| Brand Name Retail | $ 24,160,372.64 | $ 11,647,071.13 | $ 35,807,443.77 | $ 31,331,513.30 | $ 39,477,706.76 | $ 41,451,592.09 | $ 43,524,171.70 | $ 45,700,380.28 | $ 201,485,364.13 | 5% |
| Generic Name Retail | $ 22,074,776.75 | $ 6,289,249.99 | $ 28,364,026.74 | $ 24,109,422.73 | $ 29,509,933.42 | $ 30,100,132.09 | $ 30,702,134.73 | $ 31,316,177.43 | $ 145,737,800.39 | 2% |
| Brand Name (Mail order or 84 or more day supply) | $ 12,084,406.20 | $ 1,015,783.73 | $ 13,100,189.93 | $ 11,462,666.19 | $ 14,442,959.40 | $ 15,165,107.37 | $ 15,923,362.74 | $ 16,719,530.87 | $ 73,713,626.56 | 5% |
| Generic Name (Mail order or 84 or more day supply) | $ 14,489,004.31 | $ 715,230.07 | $ 15,204,234.38 | $ 12,923,599.22 | $ 15,818,485.45 | $ 16,134,855.16 | $ 16,457,552.26 | $ 16,786,703.31 | $ 78,121,195.40 | 2% |
| Compounded Drugs | $ 16,255,867.73 | $ - 0 | $ 16,255,867.73 | $ 2,709,311.29 | $ 1,625,586.77 | $ 812,793.39 | $ 406,396.69 | $ 203,198.35 | $ 5,757,286.49 | 80% decline during base period, then a 50% decline YoY |
| Specialty Drugs (Brand Name Retail) | $ 44,553,607.58 | $ 112,695.19 | $ 44,666,302.77 | $ 39,827,453.30 | $ 51,138,450.04 | $ 54,718,141.54 | $ 58,548,411.45 | $ 62,646,800.25 | $ 266,879,256.60 | 7% |
| Specialty Drugs (Generic Name Retail) | $ 3,881,017.46 | $ 130,078.71 | $ 4,011,096.17 | $ 3,576,560.75 | $ 4,592,304.01 | $ 4,913,765.29 | $ 5,257,728.86 | $ 5,625,769.88 | $ 23,966,128.77 | 7% |
| Specialty Drugs (Brand Name Mail order or 84 or more day supply) | $ 10,097,649.77 | $ 24,125.94 | $ 10,121,775.71 | $ 9,025,250.01 | $ 11,588,421.01 | $ 12,399,610.48 | $ 13,267,583.21 | $ 14,196,314.04 | $ 60,477,178.75 | 7% |
| Specialty Drugs (Generic Name Mail order or 84 or more day supply) | $ 1,781,502.80 | $ 40,099.97 | $ 1,821,602.77 | $ 1,624,262.47 | $ 2,085,553.01 | $ 2,231,541.72 | $ 2,387,749.64 | $ 2,554,892.12 | $ 10,883,998.96 | 7% |
| Rx Supplies | $ 614,919.40 | $ 5,942.93 | $ 620,862.33 | $ 543,254.54 | $ 684,500.72 | $ 718,725.75 | $ 754,662.04 | $ 792,395.14 | $ 3,493,538.20 | 5% |
| Durable Medical Equipment (DME) | $ 6,813,998.09 | $ 433,420.67 | $ 7,247,418.76 | $ 264,228.81 | $ 479,416.75 | $ 419,489.66 | $ 440,464.14 | $ 462,487.35 | $ 2,066,086.70 | 5% Penetration Rate YoY assuming 5% increase YoY from baseline total |
| Total Discount CLINS = | $ 156,807,122.73 | $ 20,413,698.33 | $ 177,220,821.06 | $ 137,397,522.61 | $ 171,443,317.33 | $ 179,065,754.54 | $ 187,670,217.47 | $ 197,004,649.01 | $ 872,581,460.96 |
| Rebates (Prescription Volume) | ||||||||||
| Brand Name Retail | 46394 | 25200 | 71594 | 62645 | 78932 | 82879 | 87023 | 91374 | 402853 | 5% |
| Brand Name (mail order or 84 or more day supply) | 8250 | 657 | 8907 | 7794 | 9820 | 10311 | 10827 | 11368 | 50119 | 5% |
| Specialty Drugs (Brand Name Retail) | 3218 | 37 | 3255 | 2902 | 3727 | 3988 | 4267 | 4565 | 19448 | 7% |
| Specialty Drugs (Brand Name Mail order or 84 or more day supply) | 459 | 3 | 462 | 412 | 529 | 566 | 606 | 648 | 2760 | 7% |
| Total Rebate CLINS = | 73753 | 93008 | 97743 | 102722 | 107955 | 475181 | ||||
| DME Total | $ 7,247,418.76 | $ 6,341,491.42 | $ 7,990,279.18 | $ 8,389,793.14 | $ 8,809,282.80 | $ 9,249,746.94 |
File details come from the government source that posted it. Updated .