Pricing Document.xlsx
XLSX spreadsheet 13 KB Posted
- Attached to
- IVHL Pharmacy Bid
- Solicitation number
- 25-497DVA-LASAL-B-47044
- Issued by
- Lasalle County, Lee Center CDP, Illinois
About this file
This is a Pricing Document for contract 25-497DVA-LASAL-B, which appears to be a pharmaceutical and healthcare services procurement opportunity. The contract covers a 38-month term and encompasses multiple product and service categories including brand name pharmaceuticals, generic pharmaceuticals, over-the-counter drugs, pharmacist and registered nurse consulting hours, and services for 70%-100% service-connected residents. The total estimated yearly spend is $919,000, with an estimated monthly cost of $76,583.33.
The pricing document allows vendors to input percentage discounts off wholesale acquisition cost (WAC) for pharmaceutical categories and hourly rates for consulting services. Vendors are required to complete yellow-highlighted fields that will automatically calculate estimated yearly and monthly costs. The final bid price will be the estimated monthly cost, which will be entered into BidBuy. The contract specifically notes a unique provision for residents with 70%-100% service connection, who cannot be billed through Medicare or other public/private insurance, representing $108,000 of the total estimated spend.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| ATTACHMENT A.Pharmacy~2.xlsx | XLSX spreadsheet | |
| U-Plan V.25.1~2.pdf | ||
| Pharmacy Services -Invitation for Bid Vendor Instructions and Requirements v.25.2.docx | DOCX document | |
| invitation-for-bid-offer-to-the-state-of-illinois-v-25-3-2-24-25~1.pdf | ||
| ipg-active-registered-vendor-disclosure-formerly-forms-b.docx | DOCX document | |
| Pharmacy Contract~1.docx | DOCX document | |
| vendor-disclosure-formerly-forms-a.docx | DOCX document |
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
Sheet1
| PRICING DOCUMENT - 25-497DVA-LASAL-B- | ||||
| Vendor is to enter data into the yellow fields that will automatically calculate Estimated Yearly Cost. | ||||
| For lines 10, 11, and 12 - please enter a percentage "plus" or "minus". Plus being it will be less than the WAC cost or Minus | ||||
| being it will be more than the WAC cost. | ||||
| Example of Plus: $550,000 times 2.5 (for 2.5%) = $536,250 | ||||
| Example of Minus: $550,000 times -2.5 (for -2.5%) = $563,750 | ||||
| For lines 13 and 14 - please enter an hourly rate. | ||||
| The cost that will be entered into BidBuy, after all calculations, will be the number that appears in RED below - Estimated Monthly Cost. | ||||
| DESCRIPTION | YEARLY SPEND/HOURS ESTIMATE | % Discount off of WAC/Per Hour Cost - VENDOR FILL IN | ESTIMATED YEARLY COST | |
| Brand Name Pharmaceuticals | $ 550,000.00 | $ | $ 550,000.00 | |
| Generic Pharmaceuticals | $ 250,000.00 | $ | $ 250,000.00 | |
| Over the Counter Drugs | $ 11,000.00 | $ | $ 11,000.00 | |
| Consulting Fee - Pharmacist by Hours | 200 | Hrs | $ - 0 | |
| Consulting Fee - Registered Nurse by Hours | 75 | Hrs | $ - 0 | |
| Estimate of 70%-100% Service Connected Residents (cannot bill Medicare of pther public or private insurance) | $ 108,000.00 | $ | $ 108,000.00 | $ 108,000.00 |
Total (Brand Name + Generic + Consulting Fee-Pharmacist+Consulting Fee Registered Nurse+Estimate of 70% to 100% Connected Residents = $ 919,000.00
| Bidding Vendor - fill in yellow area; Estimated Yearly Cost column will automatically calculate. | ||
| Estimated Yearly Cost divided by 12 (months) = Estimated Monthly Cost | $ 76,583.33 | (This will update automatically when Column D is filled in) |
| Monthly Cost Times 38 Months for the terms of the contract = TOTAL COST | $ 2,910,166.67 | (This will update automatically when Column D is filled in) |
This is the figure, after all calculations, that gets entered into BidBuy - Estimated Monthly Cost $ 76,583.33 (This will update automatically when Column D is filled in)
File details come from the government source that posted it. Updated .