CTR063562_A3_Pricing_Workbook_Rev_7.xlsx
XLSX spreadsheet 45 KB Posted
- Attached to
- Master Agreement AZ|CTR063562
- Contract number
- CTR063562
- Issued by
- Arizona
About this file
This document is a detailed pricing workbook (Revision 7) for a UI Benefits Modernization contract between Geographic Solutions and the Arizona Department of Economic Security (ADES), identified by contract numbers CTR063562 and BPM003908. The pricing workbook comprehensively outlines the implementation and ongoing costs for a modernized unemployment insurance benefits system over a 10-year period.
The contract involves implementation services, software licensing, and hosting for a modernized UI benefits system, with a total projected cost of $38,794,709. The pricing structure includes one-time implementation costs of $8,063,369 concentrated in Years 1-2, and ongoing annual costs ranging from $1,706,592 to $4,013,328. Key components include software licensing, operations and maintenance, hosting infrastructure, and various development phases such as system configuration, testing, deployment, and post-implementation support. The contract includes unlimited user licensing, scalability provisions, and assumptions about project resources, methodology, and potential additional costs at a rate of $160 per hour for scope changes.
View the file
Other files
Show all 21
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
1. Total Costs Summary
| CTR063562 / BPM003908 UI Benefits Modernization | |||||||||||
| Pricing Workbook Rev. 7: Total Costs Summary | |||||||||||
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | Total Costs | |
| Implementation Costs (One-Time) | |||||||||||
| Implementation Services and Deliverables | $ 3,487,865 | $ 4,575,504 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 8,063,369 |
| License Pricing | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Hosting/Infrastructure Pricing | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Ongoing Costs (Recurring) | |||||||||||
| Operations and Maintenance | $ - 0 | $ 1,476,072 | $ 2,804,532 | $ 2,888,664 | $ 2,975,328 | $ 3,061,968 | $ 3,153,828 | $ 3,248,448 | $ 3,345,912 | $ 3,446,304 | $ 26,401,056 |
| License Pricing | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Hosting/Infrastructure Pricing | $ - 0 | $ 230,520 | $ 461,040 | $ 474,876 | $ 489,120 | $ 503,796 | $ 518,916 | $ 534,480 | $ 550,512 | $ 567,024 | $ 4,330,284 |
| Total Solution Costs | $ 3,487,865 | $ 6,282,096 | $ 3,265,572 | $ 3,363,540 | $ 3,464,448 | $ 3,565,764 | $ 3,672,744 | $ 3,782,928 | $ 3,896,424 | $ 4,013,328 | $ 38,794,709 |
BPM003908 Total Cost Summary
2. Implementation Costs
| CTR063562 / BPM003908 UI Benefits Modernization |
| Pricing Workbook Rev. 7: Implementation Costs |
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | Total Costs | ||||
| Implementation Services and Deliverables | Description | Project Phase Milestone | ||||||||||||
| Project Planning | Project Management Plan, Detailed Project Schedule and ALM tool delivery | 1. Planning Phase | $ 422,549 | $ 422,549 | ||||||||||
| Manage Requirements | Gap Analysis sessions, RTM, Data Quality Assessment, Solution Architecture Document | 2. Analysis Phase | $ 845,098 | $ 845,098 | ||||||||||
| Configure Base System | Process Design, System Design, Data Quality Assessment, Integration Plan, Data Conversion Plan | 3. Design Phase | $ 793,123 | $ 793,123 | ||||||||||
| Modify and Complete Build of Modernized UI Benefits System | Code specific ADES requirements | 4. Development Phase | $ 523,600 | $ 1,144,500 | $ 1,668,100 | |||||||||
| Development | Application Development Plan, Hardware and Software Plan, Data Conversion | 4. Development Phase | $ 750,750 | $ 770,084 | $ 1,520,834 | |||||||||
| Update System Alert | Update system alert 745 to add new question/answer to Work Search Verification Form sent to Employer. | 4. Development Phase | $ 2,170 | $ 2,170 | ||||||||||
| Overpayment Waiver Change | Change Overpayments functionality to update text of waiver approval if waiver was not requested by claimant | 4. Development Phase | $ 2,790 | $ 2,790 | ||||||||||
| VHSS Update for Contract Scenarios | Update to split contract question on VHSS previous employment reduction page into 2 questions. Update the functionality needed for possible scenarios of how those questions are answered. | 4. Development Phase | $ 6,820 | $ 6,820 | ||||||||||
| System Alert Update to Weekly Certification Paper Form | Update System Alert 792 (Weekly Certification Paper Form) to align with recent changes to able and available questions. | 4. Development Phase | $ 6,665 | $ 6,665 | ||||||||||
| Deactivate Trigger - School Bus Issue | Deactivate the trigger for issue code School Bus Contractor Holiday or Vacation Period when the user selects 'Yes' to the specific | |||||||||||||
| questions on the Employer Detail screen. | 4. Development Phase | $ 2,790 | $ 2,790 | |||||||||||
| Change to Appeals Language on 540 Alert | Update verbiage on system alert ID 540 (Non-monetary Determinations) | 4. Development Phase | $ 3,100 | $ 3,100 | ||||||||||
| Weekly Certifications Results Change | Update the Weekly Certifications Result page; add statements indicating next actionable steps for the claimant to take are listed at the bottom of the page. | 4. Development Phase | $ 3,410 | $ 3,410 | ||||||||||
| Conduct System Testing | Manual and automated software testing including internal Quality Assurance and external Unit Acceptance Testing | 5. Test Phase | $ 1,124,378 | $ 1,124,378 | ||||||||||
| Deployment Planning and Execution | Install system in all environments, go live | 6. Implementation Phase | $ 511,371 | $ 511,371 | ||||||||||
| Conducting System Training | User Training and related materials | 6. Implementation Phase | $ 256,900 | $ 256,900 | ||||||||||
| Appeals Module | Implementation | 6. Implementation Phase | $ 125,000 | $ 125,000 | ||||||||||
| Post-Implementation | Application Support, Operations and Maintenance | 7. Post-Implementation Phase | $ 768,271 | $ 768,271 | ||||||||||
| $ - 0 | ||||||||||||||
| $ - 0 | ||||||||||||||
| $ - 0 | ||||||||||||||
| $ - 0 | ||||||||||||||
| $ - 0 | ||||||||||||||
| $ - 0 | ||||||||||||||
| $ - 0 | ||||||||||||||
| $ - 0 | ||||||||||||||
| $ - 0 | ||||||||||||||
| $ - 0 | ||||||||||||||
| $ - 0 | ||||||||||||||
| $ - 0 | ||||||||||||||
| $ - 0 | ||||||||||||||
| License Pricing (including SaaS) | Description | |||||||||||||
| $ - 0 | ||||||||||||||
| $ - 0 | ||||||||||||||
| $ - 0 | ||||||||||||||
| $ - 0 | ||||||||||||||
| $ - 0 | ||||||||||||||
| Hosting/Infrastructure Pricing | Description | |||||||||||||
| $ - 0 | ||||||||||||||
| $ - 0 | ||||||||||||||
| $ - 0 | ||||||||||||||
| $ - 0 |
Total Implementation Costs $ 3,487,865 $ 4,575,504 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 8,063,369
BPM003908 Implementation Costs
3. Ongoing Costs
| CTR063562 / BPM003908 UI Benefits Modernization | ||||||||||||
| Pricing Workbook Rev. 7: Ongoing Costs | ||||||||||||
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | Total Costs | ||
| Operations and Maintenance Costs | Description | |||||||||||
| Annual GUS Software License | O&M services including support, maintenance, and unlimited use software license | $ 1,476,072 | $ 2,804,532 | $ 2,888,664 | $ 2,975,328 | $ 3,061,968 | $ 3,153,828 | $ 3,248,448 | $ 3,345,912 | $ 3,446,304 | $ 26,401,056 | |
| … | $ - 0 | |||||||||||
| … | $ - 0 | |||||||||||
| License Pricing (including SaaS) | Description | |||||||||||
| … | $ - 0 | |||||||||||
| … | $ - 0 | |||||||||||
| … | $ - 0 | |||||||||||
| … | $ - 0 | |||||||||||
| Hosting/Infrastructure Pricing | Description | |||||||||||
| Software Hosting | Hosting of production site, disaster recovery, development, unit acceptance testing, reports, and training environments. | $ 230,520 | $ 461,040 | $ 474,876 | $ 489,120 | $ 503,796 | $ 518,916 | $ 534,480 | $ 550,512 | $ 567,024 | $ 4,330,284 | |
| … | $ - 0 | |||||||||||
| … | $ - 0 | |||||||||||
| … | $ - 0 | |||||||||||
| Total Ongoing Costs | $ - 0 | $ 1,706,592 | $ 3,265,572 | $ 3,363,540 | $ 3,464,448 | $ 3,565,764 | $ 3,672,744 | $ 3,782,928 | $ 3,896,424 | $ 4,013,328 | $ 30,731,340 |
BPM003908 Ongoing Costs
4. Key Assumptions
| CTR063562 / BPM003908 UI Benefits Modernization |
| Pricing Workbook Rev. 7: Key Assumptions and Normalization Explanations |
| # | Category | Offeror Assumptions | Estimated Impact/Comments |
| 1 | Total Costs Summary | Cost represents the Annual Software License of the GUS system. | We are not proposing to build the system from scratch/license cost- it is firm-fixed regardless of the number of users. |
| 2 | Total Costs Summary | Pricing is based on an 18-month system implementation schedule | Additional costs due to change in scope will be billed at a $160/hr rate for all positions. |
| 3 | Implementation Services | Implementation fees on tab 2 reflect the requirements set forth in BPM003908 | Changes will be vetted through change control process, outlining time, budget and scope. |
| 4 | Implementation Services | There will be adequate staff available from ADES and Geographic Solutions to define the vision/scope and requirements and to design, develop, test and deploy the application. | Lack of adequate resources may impact project schedule and cost. |
| 5 | Implementation Services | Implementation cost assumes Geographic Solutions will complete the project using tools and techniques prescribed by the Rapid Implementation and Development Methodology | Geographic Solutions uses Rapid Implementation Development Methodology |
| 6 | Implementation Services | Geographic Solutions will be responsible for conversion of data from legacy system in the Arizona Unemployment Benefits Solution database structure. | Geographic Solutions will follow Section 8.6 in Scope of Work (Data Conversion). |
| 7 | Implementation Services | Geographic Solutions will be responsible for developing interfaces between the Arizona Unemployment Benefits Solution and current legacy systems. | Geographic Solutions will implement interfaces in Section 8.7 (Exhibit C) in Scope of Work. |
| Implementation Services | Cost of implementation of external fraud products included | Licenses and services fees from fraud prevention vendors are not included | |
| 8 | Implementation Services | Staff training costs assume 42 days of staff training in person, or virtually. If in person, pricing assumes training facility will be provided by ADES. | Training requirements in SOW 8.11 will be provided virtually to ADES. |
| 9 | License Pricing | Pricing is for an unlimited use license for all system user types. | Software license is a firm-fixed cost regardless of the number of users. Geographic Solutions will accommodate maximum scalability as described in 3.2.5 with no additional cost. |
| 10 | License Pricing | Pricing assumes hosting through Geographic Solutions | Cost for hosting through Geographic Solutions has been outlined in costs. System can be hosted in the cloud for an additional fee, with a DES preferred cloud hosting provider. |
| 11 | License Pricing | System will scale to accommodate increased traffic with no additional fees to ADES | System will scale to meet expectations of SOW 3.2.5 |
| 12 | |||
| 13 | |||
| 14 | |||
| 15 | |||
| 16 | |||
| 17 | |||
| 18 | |||
| 19 | |||
| 20 | |||
| 21 | |||
| 22 | |||
| 23 | |||
| 24 | |||
| 25 | |||
| 26 | |||
| 27 | |||
| 28 | |||
| 29 | |||
| 30 | |||
| 31 | |||
| 32 | |||
| 33 | |||
| 34 | |||
| 35 | |||
| 36 | |||
| 37 | |||
| 38 | |||
| 39 | |||
| 40 | |||
| 41 | |||
| 42 | |||
| 43 | |||
| 44 | |||
| 45 | |||
| 46 | |||
| 47 | |||
| 48 | |||
| 49 | |||
| 50 |
BPM003908 Key Assumptions
Criteria
| Total Costs Summary |
| Implementation Services |
| Operations and Maintenance |
| License Pricing |
| Infrastructure Pricing |
0. Summary and Instructions
| CTR063562 / BPM003908 UI Benefits Modernization |
| Pricing Workbook Rev. 7: Summary and Instructions |
| General Instructions for Offerors |
| 1. RFP Solicitation Requirements, Exhibit A. Detailed Requirements, provides a detailed list of mandatory requirements that the Solution must adhere to. Offerors must include the cost of all mandatory requirements in this Pricing Workbook. Any "Optional" requirements provided in the Offeror's response as a "Meets" must also be included in the Pricing Workbook, or otherwise specified if there is an additional cost. |
2. All costs shall be entered in US dollars.
3. There are four (4) tabs in addition to the Summary and Instructions tab. Offeror is to complete each tab per the Completion Instructions.
4. For each tab, information should be entered into the green cells only. Do not enter any information into the blue cells.
5. For each tab, fill in only the cells that are applicable to your proposal. If needed, insert lines for additional costs, but do not delete any lines.
| Tab # | Tab Name | Completion Instructions |
| 1 | Total Costs Summary | This tab must reflect the total cost of the Offeror's solution for the entire Scope of Work annually, providing the Total Cost cumulatively. Offerors are responsible for ensuring that all totals from the other tabs are correctly transferred to the corresponding spaces on the Total Costs Summary tab, and that all totals on the Total Costs Summary tab are mathematically accurate. |
| 2 | Implementation Costs | This tab must reflect all implementation costs through the completion of the project, including all project deliverables specifying the Project Phase Milestone for each deliverable as provided in RFP Solicitation Requirements, SOW Section 15.2.2. Project Phase Milestones. |
Each Project Phase Milestone shall meet the specified percentage of the Total System Cost as follows:
1. Planning Phase is 5% of Total System Cost
2. Analysis Phase is 10% of Total System Cost
3. Design Phase is 10% of Total System Cost
4. Development Phase is 40% of Total System Cost
5. Test Phase is 15% of Total System Cost
6. Implementation Phase is 10% of Total System Cost
7. Post-Implementation Phase is 10% of Total System Cost
Offerors are responsible for ensuring that all totals are mathematically accurate.
+ "Implementation Services and Deliverables" includes the project deliverables and professional services costs associated with project management, installation, configuration, customization, documentation, data migration, data conversion, economic research, system interfaces, testing, and training of the proposed solution.
+ "License Pricing" includes all application software licenses required to satisfy the Scope of Work. One-time, up-front costs for software licenses, including any SaaS costs must be captured here.
+ "Hosting/Infrastructure Pricing" includes all hosting infrastructure required to satisfy the Scope of Work. One-time, up-front costs associated with hosting and infrastructure must be captured here.
| 3 | Ongoing Costs | This tab must reflect all costs extending beyond the completion of the implementation project. Ongoing costs encompass recurring Operations and Maintenance Costs, recurring License Pricing (including SaaS), and recurring Hosting/Infrastructure Pricing. Offerors are responsible for ensuring that all totals are mathematically accurate. |
| 4 | Key Assumptions | Offerors must indicate all assumptions upon which the pricing proposal is based. Please also include any additional comments to help contextualize the assumptions, and how changes to the assumptions may impact pricing. |
List
| 1. Planning Phase |
| 2. Analysis Phase |
| 3. Design Phase |
| 4. Development Phase |
| 5. Test Phase |
| 6. Implementation Phase |
| 7. Post-Implementation Phase |
File details come from the government source that posted it. Updated .