Final Draft - Pricing Structure Template - Medical Freight Transportation Contract.xlsx
XLSX spreadsheet 37 KB Posted
- Attached to
- Medical Freight Transportation Federal contract opportunity
- Solicitation number
- SP4701-22-R-0029
- Issued by
- Defense Logistics Agency
About this file
This document contains a pricing template for a medical freight transportation contract solicitation. The solicitation requires transportation services for ambient and hazardous medical cargo shipments to over forty destinations in four regions—Europe, the Pacific, Central Command, and North America—from originating locations in the continental United States. Services must be provided within transit time requirements ranging from three to nine days depending on the destination. The template seeks pricing for minimum charges and rates per pound for various weight breaks to enable delivery within the required transit times. It includes historical shipment data and identifies accessorial charges that may apply. Questions regarding the solicitation are due by November 4th, 2022 and proposals must be submitted by November 10th, 2022. The solicitation is being conducted by the Defense Logistics Agency to contract for global medical freight transportation services.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| Amendment 01-RFP SP4701-22-R-0029.pdf | ||
| Tab 1 - JnA - Medical Freight Transportation-_Redacted.pdf | ||
| Attachment Z - VPAT.docx | DOCX document | |
| Amendment 01-SP4701-22-R-0029-Questions and Answers.xlsx | XLSX spreadsheet | |
| Amendment 01-RFP SP4701-22-R-0029.pdf | ||
| Attachment 5-Pricing Structure Template-.xlsx | XLSX spreadsheet | |
| Attachment 3 Expeditious Routing Matrix.xlsx | XLSX spreadsheet | |
| Attachment 5 Pricing Structure Template.xlsx | XLSX spreadsheet | |
| RFP SP4701-22-R-0029 Medical Freight Transportation.pdf | ||
| Attachment 2 Point of Contact Listing.docx | DOCX document | |
| Attachment 7 - Past Performance Template.docx | DOCX document | |
| Attachment 4 Weekly Shipment Detail Report.xlsx | XLSX spreadsheet | |
| Attachment 1 Authorized Negotiator Letter.docx | DOCX document | |
| Attachment 6 Escalation Rate Template.xlsx | XLSX spreadsheet |
Show all 14
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Pricing Structure Template
| There are 4 destination theaters, each having many destination countries. Each destination country has an ambient and a hazardous lane, with its own unique CLIN and transit time requirement. Historical shipment volume has been provided. Enter a competetive minimum charge and rate for each weight break, that will enable delivery in accordance with the required transit time. | |
| *If a carrier wants to bid on an ambient lane in a destination theater (column A), then the carrier must bid on every ambient lane for that destination theater. | |
| * If a carrier wants to bid on a HAZMAT lane in a destination theater (column A), then the carrier must bid on every HAZMAT lane for that destination theater. |
| Dest. Theater | From | Commonly Used Origins | Commonly Used Destinations | Dest. Country | CLIN | TYPE | Transit Time (days) | Number of Shipments | Number of Pieces | Total Actual Weight (lbs.) | Total Billable Weight (lbs.) | Total Spend | ACCESSORIAL USAGE | Weight breaks (lbs.) | Rates (min. and per/lb) | |
| EUCOM | CONUS (Not including AK & HI) | Bethlehem, PA; Park Ridge, IL; Baltimore, MD | Kaiserslautern, Dulmen, | |||||||||||||
| Ramstein, Landstul, Spangdahlem | Germany | DEUA | Ambient | 3 | 2,405 | 8,733 | 3,351,546 | 5,792,643 | $ 7,266,143.22 | 520, 665, 670, LDS, EXP | Min. charge | $? | ||||
| 301 - 500 | $? | |||||||||||||||
| 501 - 1100 | $? | |||||||||||||||
| 1101 - 2200 | $? | |||||||||||||||
| 2201 + | $? | |||||||||||||||
| DEUH | HAZ | 6 | 127 | 460 | 176,397 | 304,876 | $ 382,428.59 | 520, 665, 670, HAZ, HMA, HMI, LDS, EXP | Min. charge | $? | ||||||
| 301 - 500 | $? | |||||||||||||||
| 501 - 1100 | $? | |||||||||||||||
| 1101 - 2200 | $? | |||||||||||||||
| 2201 + | $? | |||||||||||||||
| CONUS (Not including AK & HI) | Bethlehem, PA; Park Ridge, IL; Baltimore, MD | Aviano |
Sigonella
| Naples | Italy | ITAA | Ambient | 5 | 260 | 345 | 67,572 | 195,802 | $ 297,555.75 | 520, 665, 670, LDS, EXP | Min. charge | $? | ||||
| 301 - 500 | $? | |||||||||||||||
| 501 - 1100 | $? | |||||||||||||||
| 1101 - 2200 | $? | |||||||||||||||
| 2201 + | $? | |||||||||||||||
| ITAH | HAZ | 6 | 14 | 18 | 3,556 | 10,305 | $ 15,660.83 | 520, 665, 670, HAZ, HMA, HMI, LDS, EXP | Min. charge | $? | ||||||
| 301 - 500 | $? | |||||||||||||||
| 501 - 1100 | $? | |||||||||||||||
| 1101 - 2200 | $? | |||||||||||||||
| 2201 + | $? | |||||||||||||||
| CONUS (Not including AK & HI) | Bethlehem, PA; Park Ridge, IL; Baltimore, MD | Rota | Spain | ESPA | Ambient | 5 | 27 | 27 | 5,065 | 14,720 | $ 25,038.67 | 520, 665, 670, LDS, EXP | Min. charge | $? | ||
| 301 - 500 | $? | |||||||||||||||
| 501 - 1100 | $? | |||||||||||||||
| 1101 - 2200 | $? | |||||||||||||||
| 2201 + | $? | |||||||||||||||
| ESPH | HAZ | 7 | 1 | 1 | 267 | 775 | $ 1,317.82 | 520, 665, 670, HAZ, HMA, HMI, LDS, EXP | Min. charge | $? | ||||||
| 301 - 500 | $? | |||||||||||||||
| 501 - 1100 | $? | |||||||||||||||
| 1101 - 2200 | $? | |||||||||||||||
| 2201 + | $? | |||||||||||||||
| CONUS (Not including AK & HI) | Bethlehem, PA; Park Ridge, IL; Baltimore, MD; Hanover, MD | Lakenheath | Great Britain | GBRA | Ambient | 4 | 294 | 505 | 115,230 | 276,492 | $ 371,774.09 | 520, 665, 670, LDS, EXP | Min. charge | $? | ||
| 301 - 500 | $? | |||||||||||||||
| 501 - 1100 | $? | |||||||||||||||
| 1101 - 2200 | $? | |||||||||||||||
| 2201 + | $? | |||||||||||||||
| GBRH | HAZ | 6 | 15 | 27 | 6,065 | 14,552 | $ 19,567.06 | 520, 665, 670, HAZ, HMA, HMI, LDS, EXP | Min. charge | $? | ||||||
| 301 - 500 | $? | |||||||||||||||
| 501 - 1100 | $? | |||||||||||||||
| 1101 - 2200 | $? | |||||||||||||||
| 2201 + | $? | |||||||||||||||
| CONUS (Not including AK & HI) | Bethlehem, PA; Park Ridge, IL; Baltimore, MD; Hanover, MD | Incirlik AB | Turkey | TURA | Ambient | 8 | 3 | 5 | 681 | 1,541 | $ 10,717.30 | 520, 665, 670, LDS, EXP | Min. charge | $? | ||
| 301 - 500 | $? | |||||||||||||||
| 501 - 1100 | $? | |||||||||||||||
| 1101 - 2200 | $? | |||||||||||||||
| 2201 + | $? | |||||||||||||||
| TURH | HAZ | 9 | 0 | 0 | 36 | 81 | $ 564.07 | 520, 665, 670, HAZ, HMA, HMI, LDS, EXP | Min. charge | $? | ||||||
| 301 - 500 | $? | |||||||||||||||
| 501 - 1100 | $? | |||||||||||||||
| 1101 - 2200 | $? | |||||||||||||||
| 2201 + | $? |
| PACOM | CONUS (Not including AK & HI) | Ontario, CA; City of Industry, CA; Sacramento, CA; Park Ridge, IL | Santa Rita, Yigo, Agana | Guam | GUMA | Ambient | 5 | 454 | 1,020 | 65,672 | 524,528 | $ 1,417,566.72 | 520, 665, 670, LDS, EXP | Min. charge | $? |
| 301 - 500 | $? | ||||||||||||||
| 501 - 1100 | $? | ||||||||||||||
| 1101 - 2200 | $? | ||||||||||||||
| 2201 + | $? | ||||||||||||||
| GUMH | HAZ | 9 | 24 | 54 | 3,456 | 27,607 | $ 74,608.77 | 520, 665, 670, HAZ, HMA, HMI, LDS, EXP | Min. charge | $? | |||||
| 301 - 500 | $? | ||||||||||||||
| 501 - 1100 | $? | ||||||||||||||
| 1101 - 2200 | $? | ||||||||||||||
| 2201 + | $? | ||||||||||||||
| CONUS (Not including AK & HI) | Ontario, CA; City of Industry, CA; Sacramento, CA; Park Ridge, IL | Yokosuka, Yokota AB, Misawa AB | Japan | JAPA | Ambient | 4 | 1,532 | 4,302 | 354,265 | 1,734,013 | $ 2,398,049.83 | 520, 665, 670, LDS, EXP | Min. charge | $? | |
| 301 - 500 | $? | ||||||||||||||
| 501 - 1100 | $? | ||||||||||||||
| 1101 - 2200 | $? | ||||||||||||||
| 2201 + | $? | ||||||||||||||
| JAPH | HAZ | 5 | 81 | 226 | 18,646 | 91,264 | $ 126,213.15 | 520, 665, 670, HAZ, HMA, HMI, LDS, EXP | Min. charge | $? | |||||
| 301 - 500 | $? | ||||||||||||||
| 501 - 1100 | $? | ||||||||||||||
| 1101 - 2200 | $? | ||||||||||||||
| 2201 + | $? | ||||||||||||||
| CONUS (Not including AK & HI) | Ontario, CA; City of Industry, CA; Sacramento, CA; Park Ridge, IL | Camp Carroll, Kunsan AB, Osan AB | Korea | KORA | Ambient | 5 | 958 | 1,972 | 298,328 | 1,273,239 | $ 1,235,205.80 | 520, 665, 670, LDS, EXP | Min. charge | $? | |
| 301 - 500 | $? | ||||||||||||||
| 501 - 1100 | $? | ||||||||||||||
| 1101 - 2200 | $? | ||||||||||||||
| 2201 + | $? | ||||||||||||||
| KORH | HAZ | 7 | 50 | 104 | 15,701 | 67,013 | $ 65,010.83 | 520, 665, 670, HAZ, HMA, HMI, LDS, EXP | Min. charge | $? | |||||
| 301 - 500 | $? | ||||||||||||||
| 501 - 1100 | $? | ||||||||||||||
| 1101 - 2200 | $? | ||||||||||||||
| 2201 + | $? | ||||||||||||||
| CONUS (Not including AK & HI) | Ontario, CA; City of Industry, CA; Sacramento, CA; Park Ridge, IL | Camp Foster, Kadena AB, Camp Kinser | Okinawa | OKAA | Ambient | 5 | 267 | 1,307 | 204,727 | 306,170 | $ 459,296.99 | 520, 665, 670, LDS, EXP | Min. charge | $? | |
| 301 - 500 | $? | ||||||||||||||
| 501 - 1100 | $? | ||||||||||||||
| 1101 - 2200 | $? | ||||||||||||||
| 2201 + | $? | ||||||||||||||
| OKAH | HAZ | 7 | 14 | 69 | 10,775 | 16,114 | $ 24,173.53 | 520, 665, 670, HAZ, HMA, HMI, LDS, EXP | Min. charge | $? | |||||
| 301 - 500 | $? | ||||||||||||||
| 501 - 1100 | $? | ||||||||||||||
| 1101 - 2200 | $? | ||||||||||||||
| 2201 + | $? | ||||||||||||||
| CONUS (Not including AK & HI) | Ontario, CA; City of Industry, CA; Sacramento, CA; Park Ridge, IL | US Embassy | Phillippines | PHLA | Ambient | 4 | - 0 | - 0 | - 0 | - 0 | $ - 0 | 520, 665, 670, LDS, EXP | Min. charge | $? | |
| 301 - 500 | $? | ||||||||||||||
| 501 - 1100 | $? | ||||||||||||||
| 1101 - 2200 | $? | ||||||||||||||
| 2201 + | $? | ||||||||||||||
| PHLH | HAZ | 7 | - 0 | - 0 | - 0 | - 0 | $ - 0 | 520, 665, 670, HAZ, HMA, HMI, LDS, EXP | Min. charge | $? | |||||
| 301 - 500 | $? | ||||||||||||||
| 501 - 1100 | $? | ||||||||||||||
| 1101 - 2200 | $? | ||||||||||||||
| 2201 + | $? | ||||||||||||||
| CONUS (Not including AK & HI) | Ontario, CA; City of Industry, CA | US Embassy | Thailand | THIA | Ambient | 4 | 3 | 7 | 767 | 2,065 | $ 5,545.73 | 520, 665, 670, LDS, EXP | Min. charge | $? | |
| 301 - 500 | $? | ||||||||||||||
| 501 - 1100 | $? | ||||||||||||||
| 1101 - 2200 | $? | ||||||||||||||
| 2201 + | $? | ||||||||||||||
| THIH | HAZ | 7 | 0 | 0 | 40 | 109 | $ 291.88 | 520, 665, 670, HAZ, HMA, HMI, LDS, EXP | Min. charge | $? | |||||
| 301 - 500 | $? | ||||||||||||||
| 501 - 1100 | $? | ||||||||||||||
| 1101 - 2200 | $? | ||||||||||||||
| 2201 + | $? | ||||||||||||||
| CONUS (Not including AK & HI) | Ontario, CA | Not specifiied | Australia | AUSA | Ambient | 7 | - 0 | - 0 | - 0 | - 0 | $ - 0 | 520, 665, 670, LDS, EXP | Min. charge | $? | |
| 301 - 500 | $? | ||||||||||||||
| 501 - 1100 | $? | ||||||||||||||
| 1101 - 2200 | $? | ||||||||||||||
| 2201 + | $? | ||||||||||||||
| AUSH | HAZ | 9 | - 0 | - 0 | - 0 | - 0 | $ - 0 | 520, 665, 670, HAZ, HMA, HMI, LDS, EXP | Min. charge | $? | |||||
| 301 - 500 | $? | ||||||||||||||
| 501 - 1100 | $? | ||||||||||||||
| 1101 - 2200 | $? | ||||||||||||||
| 2201 + | $? |
| CENTCOM | CONUS (Not including AK & HI) | Bethlehem, PA; Park Ridge, IL; Baltimore, MD; Hanover, MD | Not specifiied | UAE | UAEA | Ambient | 8 | - 0 | - 0 | - 0 | - 0 | $ - 0 | 520, 665, 670, LDS, EXP | Min. charge | $? |
| 301 - 500 | $? | ||||||||||||||
| 501 - 1100 | $? | ||||||||||||||
| 1101 - 2200 | $? | ||||||||||||||
| 2201 + | $? | ||||||||||||||
| UAEH | HAZ | 9 | - 0 | - 0 | - 0 | - 0 | $ - 0 | 520, 665, 670, HAZ, HMA, HMI, LDS, EXP | Min. charge | $? | |||||
| 301 - 500 | $? | ||||||||||||||
| 501 - 1100 | $? | ||||||||||||||
| 1101 - 2200 | $? | ||||||||||||||
| 2201 + | $? | ||||||||||||||
| CONUS (Not including AK & HI) | Bethlehem, PA; Park Ridge, IL; Baltimore, MD; Hanover, MD | Not specifiied | Qatar | QATA | Ambient | 5 | 61 | 160 | 54,918 | 124,395 | $ 123,160.79 | 520, 665, 670, LDS, EXP | Min. charge | $? | |
| 301 - 500 | $? | ||||||||||||||
| 501 - 1100 | $? | ||||||||||||||
| 1101 - 2200 | $? | ||||||||||||||
| 2201 + | $? | ||||||||||||||
| QATH | HAZ | 5 | 3 | 8 | 2,890 | 6,547 | $ 6,482.15 | 520, 665, 670, HAZ, HMA, HMI, LDS, EXP | Min. charge | $? | |||||
| 301 - 500 | $? | ||||||||||||||
| 501 - 1100 | $? | ||||||||||||||
| 1101 - 2200 | $? | ||||||||||||||
| 2201 + | $? | ||||||||||||||
| CONUS (Not including AK & HI) | Bethlehem, PA; Park Ridge, IL; Baltimore, MD; Hanover, MD | Not specifiied | Iraq | IRQA | Ambient | 8 | - 0 | - 0 | - 0 | - 0 | $ - 0 | 520, 665, 670, LDS, EXP | Min. charge | $? | |
| 301 - 500 | $? | ||||||||||||||
| 501 - 1100 | $? | ||||||||||||||
| 1101 - 2200 | $? | ||||||||||||||
| 2201 + | $? | ||||||||||||||
| IRQH | HAZ | 9 | - 0 | - 0 | - 0 | - 0 | $ - 0 | 520, 665, 670, HAZ, HMA, HMI, LDS, EXP | Min. charge | $? | |||||
| 301 - 500 | $? | ||||||||||||||
| 501 - 1100 | $? | ||||||||||||||
| 1101 - 2200 | $? | ||||||||||||||
| 2201 + | $? | ||||||||||||||
| CONUS (Not including AK & HI) | Bethlehem, PA; Park Ridge, IL; Baltimore, MD; Hanover, MD | Not specifiied | Oman | OMNA | Ambient | 8 | - 0 | - 0 | - 0 | - 0 | $ - 0 | 520, 665, 670, LDS, EXP | Min. charge | $? | |
| 301 - 500 | $? | ||||||||||||||
| 501 - 1100 | $? | ||||||||||||||
| 1101 - 2200 | $? | ||||||||||||||
| 2201 + | $? | ||||||||||||||
| OMNH | HAZ | 9 | - 0 | - 0 | - 0 | - 0 | $ - 0 | 520, 665, 670, HAZ, HMA, HMI, LDS, EXP | Min. charge | $? | |||||
| 301 - 500 | $? | ||||||||||||||
| 501 - 1100 | $? | ||||||||||||||
| 1101 - 2200 | $? | ||||||||||||||
| 2201 + | $? |
| NORTHCOM | CONUS (Not including AK & HI) | Ontario, CA | Fairbanks, Ankorage | Alaska | AKA | Ambient | 3 | - 0 | - 0 | - 0 | - 0 | $ - 0 | 520, 665, 670, LDS, EXP | Min. charge | $? |
| 301 - 500 | $? | ||||||||||||||
| 501 - 1100 | $? | ||||||||||||||
| 1101 - 2200 | $? | ||||||||||||||
| 2201 + | $? | ||||||||||||||
| AKH | HAZ | 5 | - 0 | - 0 | - 0 | - 0 | $ - 0 | 520, 665, 670, HAZ, HMA, HMI, LDS, EXP | Min. charge | $? | |||||
| 301 - 500 | $? | ||||||||||||||
| 501 - 1100 | $? | ||||||||||||||
| 1101 - 2200 | $? | ||||||||||||||
| 2201 + | $? | ||||||||||||||
| CONUS (Not including AK & HI) | Ontario, CA | Honolulu | Hawaii | HIA | Ambient | 3 | - 0 | - 0 | - 0 | - 0 | $ - 0 | 520, 665, 670, LDS, EXP | Min. charge | $? | |
| 301 - 500 | $? | ||||||||||||||
| 501 - 1100 | $? | ||||||||||||||
| 1101 - 2200 | $? | ||||||||||||||
| 2201 + | $? | ||||||||||||||
| HIH | HAZ | 5 | - 0 | - 0 | - 0 | - 0 | $ - 0 | 520, 665, 670, HAZ, HMA, HMI, LDS, EXP | Min. charge | $? | |||||
| 301 - 500 | $? | ||||||||||||||
| 501 - 1100 | $? | ||||||||||||||
| 1101 - 2200 | $? | ||||||||||||||
| 2201 + | $? | ||||||||||||||
| CONUS (Not including AK & HI) | Baltimore, MD | Not specifiied | Puerto Rico | PRA | Ambient | 3 | - 0 | - 0 | - 0 | - 0 | $ - 0 | 520, 665, 670, LDS, EXP | Min. charge | $? | |
| 301 - 500 | $? | ||||||||||||||
| 501 - 1100 | $? | ||||||||||||||
| 1101 - 2200 | $? | ||||||||||||||
| 2201 + | $? | ||||||||||||||
| PRH | HAZ | 5 | - 0 | - 0 | - 0 | - 0 | $ - 0 | 520, 665, 670, HAZ, HMA, HMI, LDS, EXP | Min. charge | $? | |||||
| 301 - 500 | $? | ||||||||||||||
| 501 - 1100 | $? | ||||||||||||||
| 1101 - 2200 | $? | ||||||||||||||
| 2201 + | $? |
Accessorial Charges
| Service Code | Service Description | Carrier | Business Rule | Not Offered | No Charge | Unit Cost | Min Charge |
| 670 | Saturday Pickup | Cost calculated per rated pound, subject to a minimum charge per shipment, whichever is greater. | |||||
| 665 | Saturday Delivery | Cost calculated per rated pound, subject to a minimum charge per shipment, whichever is greater. | |||||
| HAZ | Hazardous Material Handling | Cost calculated per Hazardous UN number | |||||
| HMA | Accessible Hazardous Materials | Cost calculated per Hazardous UN number | |||||
| HMI | Inaccessible Hazardous Materials | Cost calculated per Hazardous UN number | |||||
| LDS | Life and Death Emergency On-board Courier Service | Cost calculated on a per shipment basis. | |||||
| 520 | Oversized Freight | 1. The consignor must make advanced arrangements with the air Transportation Service Provider (TSP) to transport the following oversized shipments: |
a. Piece(s) that exceeds 125 inches in length and/or prevent other freight from being loaded on the same pallet(s) because of special tie-down requirements.
b. Piece(s) that exceeds 88 inches in width but are less than 125 inches in width and/or prevent other freight from being loaded on the same pallet(s) because of special tie-down requirements.
c. Piece(s) that exceeds 59 inches in height.
d. Pieces that exceeds 300 inches in length and girth combined shall be defined as an oversized shipment.
2. Charges: (stated in whole percent). On shipments of oversized freight, as described in paragraph 1a-1d above, the TSP will be entitled to a surcharge of _______ % of the per-pound rate for the costed lane of travel for each oversized piece.
3. Transit Time: Oversized Freight shipments will receive the benefit of 3 additional transit days, when the accessorial is applied on the bill of lading.
EXP Expedited Service EXP is an accessorial service. The shipper can request to have the selected TSP guarantee delivery before the country-to-country transit time established under this contract.
When the transit time to meet the required delivery date, is less than the transit time established under the this contract, EXP is required to be annotated on the Bill of Lading. The shipper will annotate the remarks section of the bill of lading with, “Expedited service is required for this shipment as the RDD on this bill of lading is less than the RDD established under this contract.” TSP must ensure BL is annotated with EXP request for charges to apply.
If the transit time is less than that established under this contract and the requirement for EXP has not been annotated in the remarks section of the BL, the TSP is relieved from meeting the RDD and shall deliver the shipment IAW the transit time established under this contract. This accessorial can be used with any other accessorial identified on the task order.
A charge for expedited service shall be EXP(1) $_____ per pound, per shipment; subject to a minimum charge of EXP(2) $_____ per shipment.
This accessorial will be invoiced as an eBill that is linked to the invoice for the bill of lading. The request for this accessorial will appear in the remarks section of the bill of lading. If the transit time to meet the required delivery date, is less than the transit time established under the this contract and the requirement for EXP has not been annotated in the remarks section of the BL, the TSP cannot charge the shipper for expedited service.
File details come from the government source that posted it. Updated .