Attachment F - Price Workbook FINAL.xlsx

Intro & Instructions

Offeror: Enter Offeror Name Here

Please refer to RFP for details describing the services and scope of the system implementation, and Laboratory Information Management System (LIMS) services to be provided and priced in accordance with this Price Workbook. In addition to the instructions presented in this "Instructions" tab, there may be more instructions and guidance presented in the subsequent tabs of this Workbook. Offeror should also refer to sections C and F.6. of the main RFP document for additional instructions and requirements for submitting this price proposal.

Cells requiring Offeror data entry are marked in light-green highlight to clearly indicate which cells are available for data entry as indicated above left.

It is important to note that all vendors will ONLY be evaluated by the pricing information on BidBuy and not this workbook. This workbook should still be submitted with the Offer as it contains additional detail for use during contract management.

Note: Offerors are responsible for ensuring that all formulas calculate correctly throughout the workbook.

2. Deliverables Cost Tab for one-time deliverables costs. This tab lists the deliverables specified in RFP Attachment G, tab 6, Service Requirements . The Offeror will enter fixed pricing and the level of effort required to complete each deliverable. Offerors may add additional deliverables, as deemed necessary, by inserting rows into the tab at the bottom of each deliverable group list. In this case, the associated formulas must be copied. The Column 'Contract Month for Deliverable Completion, per proposed project schedule' is for the Offeror to enter the month the deliverable will be completed per the project schedule.

Note: Offerors are responsible to ensure all calculations are correct.

If the Offeror's typical pricing model does not normally charge for a specific element provided within this workbook, please provide a statement in the tab "4. Price Assumptions" regarding the Offeror methodology for charging for that element (e.g., not applicable, no additional charge) and enter $0 in the corresponding charge on the appropriate tab and columns.

5. Rate Card Tab for Offeror to list hourly rates for all staff roles. This tab shall be used by the Offeror to provide hourly rates broken down by staff role. All staff roles identified in Attachment G - Traceability Matrix, tab 9, have already been populated, but the Offeror must add any additional roles they identified as necessary to support the approach presented to meeting the requirements of this RFP. Note the additional Roles as needed Rows are not evaluated and will not be part of the Offerors BidBuy Response.

Note: Hourly Role Rates beyond Year 2 shall be addressed through a CPI request made by the Vendor an on annual basis through the contract term.

6. Offeror BidBuy Response Tab the Offeror shall use as a guide for populating their official price proposal within BidBuy as noted within section C. of the main RFP document. Most of this tab will auto populate with pricing as the Offeror completes tabs 2, 3, and 5. The Offeror shall enter any applicable discount percent into column F per print sequence.

Note: It is important to note that all Offers will ONLY be evaluated by the pricing information on BidBuy and not this workbook. This workbook should still be submitted with the Offer as it contains additional detail for use during contract management.

PLEASE NOTE:

1. The Offeror Name in the space provided in light-green highlight will populate across all other worksheets.

2. Cells requiring Offeror data entry are marked in light-green highlight to clearly indicate which cells are available for data entry as indicated above left.

3. It is the Offeror's responsibility to ensure the integrity of the Price Workbook formulas and links.

Insert Offeror Name here

1. Total Price Summary

2. Deliverables Costs

2. Column B: Enter the total one-time cost for each deliverable. Note: Monthly Status Reports (cell A15) are a project management deliverable that will not be invoiced separately. The cost of these ongoing reports must be built into associated deliverables throughout the delivery period. Please refer to Attachment G, tab 6 for deliverable details. If there is no value, please enter $0.

3. Column C: Enter the contract month (1-60) the deliverable is expected to be completed and submitted for invoicing. This month must align with the Offeror's workplan submitted with the proposal.

4. Column D: Enter the number of human work hours necessary for successful completion and approval of this deliverable for which the Offeror is basing the cost off. This level of effort may be used during the contract term if new functionality development is requested by DoIT during the maintenance and operations phase of the contract.

One-time

One-time

One-time

One-time

One-time

One-time

One-time

One-time

One-time

One-time

3. Ongoing Costs

2. Column E: Enter the total number of end users for each month for which the Solution hosting/provisioning will be affected. The "# End Users" must align with the user counts provided in Attachment G - Traceability Matrix, tab 5, requirement T172 as a baseline for providing the monthly costs. Offerors may provide a number range for "# End Users" for which the monthly cost applies.

3. Column F: Enter Solution hosting/provisioning monthly cost for each month of the five (5) year contract period. This cost should only begin once the Solution is fully implemented and in use by DoIT, and must align with Offeror's workplan submitted with the proposal. If there is no value, please enter $0.

4. Column H: Enter the annual cost for enhancement support services for the duration of the five (5) year contract period. These annual hours and associated cost are for use of the discretion of DoIT to support legislative changes and enhancements (new functionality development) to the Solution as determined by DoIT.

Note: DoIT is not required to use the Enhancement Support annual hours, and annual cost shall not be invoiced by the Vendor if annual hours are not used. Any unused funds will rollover into the following year unless otherwise negotiated in the contract. DoIT may use any percent of these hours as determined necessary, and the Vendor shall invoice the associated percent of cost using the following formula: ((Actual Hours Used / Annual Hours) * Annual Cost) = Actual Cost.

Example: Annual cost for 400 annual hours is contracted as $5,000. DoIT requests enhancement support requiring the use of 200 hours. ((200 / 400) * $5,000 = $2,500.

Enhancement support requiring the use of more hours than available to DoIT at any time during the contract period will leverage the costs provided in tab 5. Rate Card to establish an agreeable cost between DoIT and the Vendor prior to initiation of the requested enhancement support.

by Contract Year

4. Price Assumptions

1. Column B: Enter the specific location in the proposal to which the price assumption refers.

2. Column C: Describe the price assumption.

3. Column D: Describe the rationale for the price assumption.

4. Column E: Enter the cost increase or decrease if the price assumption turns out to be invalid.

5. Rate Card

1. Column A: Starting at A#, insert additional roles as needed to fully align with the approach to staffing within the Offeror proposal. Note: additional roles and associated hourly rates will not be included in the evaluation of the Offeror's price proposal to ensure accurate comparison between offers.

2. Column B: Enter the on-site (meaning at a State of Illinois facility) rate for a senior level resource for Year 1 of the contract.

3. Column C: Enter the offsite/remote (meaning not at a State of Illinois facility) rate for a senior level resource for Year 1 of the contract.

4. Column D: Enter the on-site (meaning at a State of Illinois facility) rate for a junior level resource for Year 1 of the contract.

5. Column E: Enter the offsite/remote (meaning not at a State of Illinois facility) rate for a junior level resource for Year 1 of the contract.

6. Column F: Enter the on-site (meaning at a State of Illinois facility) rate for a senior level resource for Year 2 of the contract.

7. Column G: Enter the offsite/remote (meaning not at a State of Illinois facility) rate for a senior level resource for Year 2 of the contract.

8. Column H: Enter the on-site (meaning at a State of Illinois facility) rate for a junior level resource for Year 2 of the contract.

9. Column I: Enter the offsite/remote (meaning not at a State of Illinois facility) rate for a junior level resource for Year 2 of the contract.

6. Offeror BidBuy Response

2) Populate column F with any applicable discount per print sequence.

3) Use this information when entering your pricing information where applicable into BidBuy, as noted in section C. of the main RFP document. Each header in the below tab maps to the field names used in the State Procurement System, BidBuy.

NOTE: It is important to note that all vendors will ONLY be evaluated by the pricing information on BidBuy and not this workbook. This workbook should still be submitted with the Offer as it contains additional detail for use during contract management.