Attachment F - Price Workbook v2~1.xlsx

Intro & Instructions

Offeror: Enter Offeror Name Here

NOTE: It is important all Offerors understand that price proposals must be developed using this workbook, and uploaded to the Attachments Tab in BidBuy as instructed in section C.1. and F.6. of the RFP. Utilization of this workbook ensures all Offerors are pricing Offers in the same manner leading to a truer apples-to-apples comparison. Details within this workbook will also support stronger management of the potential future contract; therefore, this workbook shall be submitted with the complete offer.

2. Enter level of effort (human work hours) required to complete each deliverable.

3. Within each Service Domain Deliverables group, add any deliverables specific to your offer in the provided space, and repeat steps 1 and 2. Note: If rows are added, the Offeror is responsible for ensuring formulas are carried forward & properly rolling up into Worksheet 1. Total Price Summary.

2. Each row should be a separate detailed assumption or expectation.

3. The specific section, page, and paragraph of the Offer must be provided to support each assumption or expectation.

4. If the Offeror's typical pricing model does not normally charge for a specific deliverable/service provided within this workbook, please provide a statement in this worksheet regarding the Offeror's methodology (e.g., not applicable, no additional charge).

NOTE: Assumption that do not impact price need not be entered here. No price assumptions or exceptions shall be in conflict with the Terms and Conditions of this solicitation. There will be no future negotiation allowed for assumptions or exceptions not listed within this worksheet upon submission of the offer.

5. Blended Rate Card This worksheet is designed to collect the hourly rates for each key role to establish a blended hourly rate. The Offeror shall enter the hourly rate for all prepopulated roles as identified in the RFP. 1. Resource Level: Enter the resource level (Sr./Jr.) for the managed service.

2. Composition Weight: Enter the percent composition of each role as weighted.

3. Hourly Rate: Enter the hourly rate for each role.

4. The Offeror will be responsible for entering the estimated year-over-year increase in cell G8, which will determine the hourly rate for each role for that year.

http://invalid.urihttp://invalid.urihttp://invalid.urihttp://invalid.urihttp://invalid.uri

1. Total Price Summary

X1A0T X1A0T X1A0T X1A0T

2. Deliverables Costs

2. Column B: Enter the total one-time cost for each deliverable. Note: Weekly Status Reports 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.

3. Column C: Enter the contract month the deliverable is expected to be completed and submitted for invoicing. The month entered here must align with the workplan provided as part of the Offeror's offer.

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.

(# of human work hours)

(# of human work hours)

(# of human work hours)

(# of human work hours)

(# of human work hours)

(# of human work hours)

(# of human work hours)

(# of human work hours)

(# of human work hours)

(# of human work hours)

(# of human work hours)

(# of human work hours)

X2A0T X1A0T X1A0T X1A0T X1A0T

3. Ongoing Costs

2. Column B: This column identifies the Year to which the cost applies.

3. Column C: This column is an automatic calculation of the total cost for the month.

4. Column D: The Offeror shall use this column to input the monthly cost for Maintenance & Operations (M&O) services. This cost should begin with the start of the M&O phase, which follows the successful completion of the hypercare phase, as aligned with the proposed project workplan. For all months prior to this phase, please enter $0.

5. Column E: The Offeror shall use this column to input the number of user licenses included in Monthly Cost listed column F. This cost should begin once the Solution is fully in production, as aligned with the proposed project workplan. For all months prior to this, please enter $0. For a detailed breakdown of current user counts by role, please refer to section B.2. Volumes & Quantities of the RFP.

6. Column F: The Offeror shall use this column to input a Monthly Cost for solution licensing/hosting based on the number of users identified in Column E. This cost should begin once the Solution is fully in production, as aligned with the proposed project workplan. For all months prior to this, please enter $0. The table will identify the Annual Cost for four hundred (400) Enhancement hours (see Attachment C -Glossary provided in section G.3. of the RFP for definitions) throughout the contract term. The Annual Period is defined as a rolling twelve (12) months, not a calendar year.

1. Column J: This column identifies the Annual Period to which the cost applies.

2. Column K: The Offeror shall specify the month of the contract when Annual Period 1 will begin (K11). This month should align with the start of M&O services as noted in the workplan submitted with the Offer. All other Annual Period months will auto-populate based upon the month selected for Annual Period 1.

3. Column L: The Offeror shall specify the year of the contract when Annual Period 1 will begin (L11). This year should also align with the start of M&O services as noted in the workplan submitted with the Offer. All other Annual Period years will auto-populate based upon the year selected for Annual Period 1.

4. Column M: This column identifies the Annual Hours available for use at the discretion of IDPH for the design, development/configuration, implementation, and hypercare support of any enhancements to the Solution. IDPH does not guarantee the number of hours used annually.

5. Column N: This column will auto calculate the Annual Cost, leveraging the blended hourly rate of all Key Vendor Roles for Year 1 as calculated in worksheet 5. Blended Rate Card, cell E26.

Annual Hours will be used for any enhancement Task Order(s) until exhausted. Hours needed to complete deliverables associated with a Task Order will then leverage the appropriate contracted blended rate. Any unused Allotted Annual Hours not used by IDPH shall roll-over to the next Annual Period, and continue rolling over into subsequent Annual Periods, unless otherwise agreed upon.

X3A0T

X1A0T X1A0T X1A0T

4. Price Assumptions

2. Column B: The specific section, page, and paragraph of the Offer must be provided to support each assumption or expectation.

2. Column C: Provide details pertaining to any and all assumptions, expectations, and/or vendor performance parameters that have been used as the basis for the price offer.

3. Column D: Each row should be a separate detailed assumption or expectation.

4. Column E: If the Offeror's typical pricing model does not normally charge for a specific deliverable/service provided within this workbook, please provide a statement in this worksheet regarding the Offeror's methodology (e.g., not applicable, no additional charge).

NOTE: Assumption that do not impact price need not be entered here. No price assumptions or exceptions shall be in conflict with the Terms and Conditions of this solicitation. There will be no future negotiation allowed for assumptions or exceptions not listed within this worksheet upon submission of the offer.

X4A0T

X1A0T X1A0T X1A0T

5. Blended Rate Card

2. Column B: Offerors must enter the resource level (Sr./Jr.) whom has been identified to fill each role within the Offer.

3. Column C: Offerors must enter the composition weight of each role. Composition Weight is defined as the percentage contribution of each role to the overall cost per hour by calculating the proportion of total costs each role represents.

4. Column D: Offerors must enter the Year 1 hourly rate for each role.

5. Cell G8: Offerors must enter the year-over-year percent increase for hourly rates.

6. Hourly Rate for Year 2 through Year 10 will auto calculate using the year-over-year increase entered into cell G7.

7. Composition Rate will auto calculate by multiplying the hourly rate by the composition weight.

8. Blended Composite Rate, shown in columns E, G, I, K, M, O, Q, S, U, and W of row 25, is derived by summing the products of each role's composition weight and their respective hourly rates, providing a single blended rate. The blended composition rate will be calculated using only key vendor roles proposed within section A.2.2. of the RFP.

NOTE: Offerors proposing key roles beyond those listed below shall use Table 2. Managed Services Rates for Additional Roles to identify these roles. Offeror shall populate the light green cells using the same instruction as provided for Table 1.

Vendor Role Composition Weight Must Equal 100% Blended Composition Rate X5A0T X1A0T X1A0T