70FB7018R00000024_Attachment_1_IT_Price_Sheet.xlsx
XLSX spreadsheet 29 KB Posted
- Attached to
- Infant and Toddler Kits and Items Federal contract opportunity
- Solicitation number
- 70FB7018R00000024
About this file
ATTACHMENT 1
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| Q_&_As_70FB7018R00000024_Infant_and_Toddler.pdf | ||
| Attachment_5__DHS_Subcontracting_Plan_review_Checklist.pdf | ||
| Attachment_6_PAST_PERFORMANCE_Infant_and_Toddler.docx | DOCX document | |
| RFP_70FB7018R00000024__6.27.18.pdf | ||
| Attachment_2_thru_4.pdf |
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
Historical Data, Complete Kits
| Date | Destination | Quantity Purchased | Cost per kit | Freight Cost | Travel Cost | Detention Cost | Discounts Applied | Total Expendature |
| 9/26/12 | HAW | 2 | $3,203.13 | $3,550.00 | $0.00 | $9,956.26 | ||
| 11/1/12 | Lakehurst, NJ | 10 | $3,599.14 | $2,000.00 | $0.00 | $2,805.00 | $40,079.46 | |
| 01/11/13 | FRD | 30 | $3,202.00 | $1,100.00 | $1,100.00 | $98,260.00 | ||
| 01/15/13 | MOF | 10 | $3,202.13 | $5,175.00 | $2,618.00 | $39,814.30 | ||
| 01/24/13 | GUA | 4 | $3,202.13 | $7,656.75 | $0.00 | $401.28 | $20,063.99 | |
| 01/24/13 | FRD | 15 | $3,202.00 | $1,950.00 | $200.00 | $983.92 | $49,196.08 | |
| 01/24/13 | ATL | 20 | $3,202.13 | $9,795.00 | $2,009.00 | $1,167.54 | $68,679.06 | |
| 07/15/14 | FRD | 20 | $3,211.73 | $2,250.00 | $300.00 | $66,784.00 |
Total $392,833.15
Historical Data, Refreshes
| Date | Destination | Item Description | Quantity Purchased | Extended Cost | Freight Cost | Discounts Applied | Total Expendature | |
| 8/27/14 | HAW | Formula, Soy | 224 | $528.64 | ||||
| HAW | Baby Food | 240 | $152.32 | |||||
| HAW | $871.17 | $1,152.13 | ||||||
| 09/23/14 | HAW | Formula, milk | 448 | $1,057.28 | ||||
| HAW | Diaper rash ointment | 40 | $150.00 | |||||
| HAW | Formula, Hypo | 56 | $864.64 | |||||
| HAW | $1,228.83 | $3,300.75 | ||||||
| 09/30/14 | CAR | Baby Food | 201 | $136.68 | ||||
| CAR | Formula, Soy | 814 | $1,921.04 | |||||
| CAR | $967.00 | $3,024.72 | ||||||
| 11/03/14 | CAR | Formula, milk | 1626 | $3,823.20 | ||||
| CAR | Formula, Hypo | 201 | $3,149.76 | |||||
| CAR | Diaper rash ointment | 144 | $504.00 | |||||
| CAR | $1,417.00 | $8,893.96 | ||||||
| 05/27/14 | CAR | Baby Food | 448 | $304.64 | ||||
| CAR | Oral electrolyte | 997 | $1,593.90 | |||||
| CAR | Nutritional Supplement | 996 | $2,021.88 | |||||
| CAR | $825.00 | $4,745.42 | ||||||
| 10/27/14 | CAR | Baby Food | 24 | $16.32 | ||||
| CAR | $108.00 | $124.32 | ||||||
| 12/30/14 | CAR | Oral electrolyte | 1 | $5.42 | ||||
| CAR | $108.00 | $113.42 | ||||||
| 09/30/14 | GUA | Baby Food | 240 | $163.20 | $677.44 | $840.64 | ||
| 10/27/14 | GUA | Formula, Hypo | 56 | $864.64 | $677.44 | $1,542.08 | ||
| 01/20/15 | GUA | Formula, Soy | 224 | $528.64 | $677.44 | $1,206.08 | ||
| 05/16/14 | MOF | Baby Food | 1200 | $816.00 | ||||
| MOF | Cereal | 320 | $668.80 | |||||
| MOF | Formula, milk | 1128 | $2,643.20 | |||||
| MOF | Formula,soy | 564 | $1,321.60 | |||||
| MOF | Formula, Hypo | 564 | $1,680.00 | |||||
| MOF | Oral electrolyte | 2134 | $896.28 | |||||
| MOF | Nutritional Supplement | 576 | $1,136.80 | |||||
| MOF | Diaper rash ointment | 100 | $375.00 | |||||
| MOF | $720.00 | $10,257.68 | ||||||
| 09/15/14 | ATL | Baby Food | 600 | $437.54 | $352.80 | $790.34 | ||
| 10/14/14 | ATL | Formula, milk | 246 | This was a combined invoice that did not break out individual cost. | ||||
| ATL | Formula, Hypo | 299 | This was a combined invoice that did not break out individual cost. | |||||
| ATL | Diaper rash ointment | 182 | $4,016.92 | $660.00 | $5,467.26 | This was a combined invoice that did not break out individual cost. | ||
| 12/15/14 | ATL | Baby Food | 192 | $4,225.97 | $997.20 | $5,223.17 | This was a combined invoice that did not break out individual cost. | |
| ATL | Formula,soy | 296 | $3,828.18 | $897.60 | $4,725.78 | This was a combined invoice that did not break out individual cost. | ||
| ATL | Oral electrolyte | 290 | This was a combined invoice that did not break out individual cost. | |||||
| 10/14/14 | FRD | Formula, milk | 2280 | $3,085.80 | $484.80 | $3,570.60 | This was a combined invoice that did not break out individual cost. | |
| FRD | Oral electrolyte | 270 | This was a combined invoice that did not break out individual cost. | |||||
| 11/14/14 | FRD | Formula, milk | 2280 | $5,863.24 | $778.80 | $6,642.04 | This was a combined invoice that did not break out individual cost. | |
| FRD | Oral electrolyte | 270 | This was a combined invoice that did not break out individual cost. | |||||
| 12/18/14 | FRD | Formula, Soy | 1120 | $2,060.00 | $484.80 | $2,544.80 | ||
| 12/18/14 | FRD | Refresh complete kits | 20 | $66,784.60 |
Total $130,949.79
| Note: DC Frederick recently refreshed 20 kits. This effort utilized one (1) IMS to pull the expiring product, replace product, rewrap the pallets, put them away and update the paperwork. |
| The process took approximately 3 days at an hourly rate of $26.22 per hour. |
Kit Price Sheet
| Attachment 1: Pricing Sheets |
| Infant & Toddler Kits Pricing MS Excel Spreadsheet |
| CLINT | Item Description | Base Year | Option Year One | Option Year Two | Option Year Three | Option Year Four | |||||||||||
| 0001 | COMPLETE KITS | Unit Price | Maximum Quantity | Amount | Unit Price | Maximum Quantity | Amount | Unit Price | Maximum Quantity | Amount | Unit Price | Maximum Quantity | Amount | Unit Price | Maximum Quantity | Amount | |
| 0001AA | Complete Kit (Steady State) | ||||||||||||||||
| Supply Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||
| Service Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||
| Total Unit Price | $ - 0 | 245.00 | $ - 0 | $ - 0 | 245.00 | $ - 0 | $ - 0 | 245.00 | $ - 0 | $ - 0 | 245.00 | $ - 0 | $ - 0 | 245.00 | $ - 0 | ||
| 0001AB | Complete Kit (Emergency Response) | Unit Price | Maximum Quantity | Amount | Unit Price | Maximum Quantity | Amount | Unit Price | Maximum Quantity | Amount | Unit Price | Maximum Quantity | Amount | Unit Price | Maximum Quantity | Amount | |
| Supply Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||
| Service Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||
| Total Unit Price | $ - 0 | 245.00 | $ - 0 | $ - 0 | 245.00 | $ - 0 | $ - 0 | 245.00 | $ - 0 | $ - 0 | 245.00 | $ - 0 | $ - 0 | 245.00 | $ - 0 | ||
| 0002 | PERISHABLE KITS | Unit Price | Maximum Quantity | Amount | Unit Price | Maximum Quantity | Amount | Unit Price | Maximum Quantity | Amount | Unit Price | Maximum Quantity | Amount | Unit Price | Maximum Quantity | Amount | |
| 0002AA | Perishable Kit (Steady State) | ||||||||||||||||
| Supply Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||
| Service Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||
| Total Unit Price | $ - 0 | 245.00 | $ - 0 | $ - 0 | 245.00 | $ - 0 | $ - 0 | 245.00 | $ - 0 | $ - 0 | 245.00 | $ - 0 | $ - 0 | 245.00 | $ - 0 | ||
| 0002AB | Perishable Kit (Emergency Response) | Unit Price | Maximum Quantity | Amount | Unit Price | Maximum Quantity | Amount | Unit Price | Maximum Quantity | Amount | Unit Price | Maximum Quantity | Amount | Unit Price | Maximum Quantity | Amount | |
| Supply Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||
| Service Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||
| Total Unit Price | $ - 0 | 245.00 | $ - 0 | $ - 0 | 245.00 | $ - 0 | $ - 0 | 245.00 | $ - 0 | $ - 0 | 245.00 | $ - 0 | $ - 0 | 245.00 | $ - 0 | ||
| 0003 | NON-PERISHABLE KITS | Unit Price | Maximum Quantity | Amount | Unit Price | Maximum Quantity | Amount | Unit Price | Maximum Quantity | Amount | Unit Price | Maximum Quantity | Amount | Unit Price | Maximum Quantity | Amount | |
| 0003AA | Perishable Kit (Steady State) | ||||||||||||||||
| Supply Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||
| Service Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||
| Total Unit Price | $ - 0 | 245.00 | $ - 0 | $ - 0 | 245.00 | $ - 0 | $ - 0 | 245.00 | $ - 0 | $ - 0 | 245.00 | $ - 0 | $ - 0 | 245.00 | $ - 0 | ||
| 0003AB | Perishable Kit (Emergency Response) | Unit Price | Maximum Quantity | Amount | Unit Price | Maximum Quantity | Amount | Unit Price | Maximum Quantity | Amount | Unit Price | Maximum Quantity | Amount | Unit Price | Maximum Quantity | Amount | |
| Supply Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||
| Service Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||
| Total Unit Price | $ - 0 | 245.00 | $ - 0 | $ - 0 | 245.00 | $ - 0 | $ - 0 | 245.00 | $ - 0 | $ - 0 | 245.00 | $ - 0 | $ - 0 | 245.00 | $ - 0 | ||
| Shipping | At Cost | At Cost | At Cost | At Cost | At Cost | Total Price | |||||||||||
| TOTAL | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
A-la Carte Price Sheet
| Attachment 1: Pricing Sheets |
| Price Sheet Infant toddler Ala Carte Items |
| Period of Performance: | Base Year | Option Year One | Option Year Two | Option Year Three | Option Year Four | |||
| CLIN: 0004 | Item Description | Minimum | ||||||
| Quantity | Unit Price | Unit Price | Unit Price | Unit Price | Unit Price | |||
| Baby Food - Stage 2 | 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Cereal | 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Formula, Milk | 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Formula, Soy | 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Formula, Hypo | 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Oral Electrolyte | 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Nutritional Drink | 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Sip Cup | 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Diaper- up to 10# (Preemie) | 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Diaper Size 1 | 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Diaper Size 2 | 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Diaper Size 3 | 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Diaper Size 4 | 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Diapers Pull Ups | 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Diaper Ointment Preventative | 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Diaper Ointment w/ zinc | 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Burping Cloths | 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Feeding Bottle-Plastic | 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Nipples for Feeding Bottles | 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Feeding Spoons | 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Disposable Changing Pads | 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Baby Wash | 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Washclothes | 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Towels | 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Lightweight Blankets | 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| TOTAL | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| Total | $0.00 |
File details come from the government source that posted it.