Georgia SHINES Modularization May 2024

Open folder in Drive ↗

• Login
• Intake
• Investigation
• Family Support Services
• Family Preservation
• Administration
• Reports

• {"name":"Completion of Training Documentation (M15/End of Roll-Out)","value":111882.6}
• {"name":"Completion of Vulnerability Test Reports (M15/End of Roll-Out)","value":61880.4}
• {"name":"Completion of Performance Test Reports (M15/End of Roll-Out)","value":75451.5}
• {"name":"Completion of Roll-Out & Stabilization / System Health Report (M15/End of Roll-Out)","value":813122.7}

contract_term_monthscounties_or_officesddi_valueduration_months_ddiduration_months_molicense_valuemo_valuenon_opportunity_reasonprimesaas_valuethird_party_valuetotal_person_monthsuser_countuser_count_notevalue_by_yearwarranty_value

This 32-tab Gen-2 workbook has ~12 near-duplicate Implementation Plan variants and 4 Milestone Pricing variants with no tab self-marked as truly final (per recon.md); however 'Final Ver SOR Milestone Pricing' and 'V1 Final Ver SOR Milestone Pric' independently agree on the grand total ($7,475,334), so that was used as tab_used. The much smaller 'Summary' tab total ($2,305,655) is scoped only to a specific SaaS module ('Redetermination Notices & Appeal Mgmt') and is recorded as a variant, not the primary total. Milestone pricing shows a split 'Cardinality' $4,371,360 vs 'Virtus rate with MSP' $2,016,840 (a partial reconciliation of the $7.48M total; Virtus recorded as subcontractor/rate-card provider, not necessarily prime). Role-level staffing not extracted given the ~12 conflicting implementation-plan variants; hours_basis_per_month=160 taken from the 'M Vs D 160hrs' tab name and recon.md notes. RFP Summary tab contains an apparent copy-paste error (references a Minnesota DHS email address) — captured verbatim per instructions rather than corrected. Sibling files 'GA CMM - Project Financials' (actuals) and 'Virtus Staffing Plan' exist in the same folder but were not the chosen primary workbook.