Attachment_1_-_Cost_Workbook.xlsx

This is a cost workbook attachment for a Request for Proposals issued by the California Department of General Services, Procurement Division on behalf of the California Department of Public Health for a Hospital Bed and Emergency Medical Services Data System (HBEDS). The solicitation seeks a contractor-hosted, pre-existing Software as a Service solution with hospital onboarding services to support compliance with Assembly Bill 177. The contract term is three years with two optional one-year extensions. The service area is statewide California. Bidders are required to complete the yellow input cells in the cost workbook to provide pricing for hospital data subscription access and hospital onboarding fees. The workbook calculates annual costs based on quarterly per-hospital subscription rates, per-hospital onboarding fees, expected annual onboarded hospitals, and expected annual hospital subscriptions across all contract years.

The cost workbook establishes specific operational parameters for each contract year. Year 1 projects 215 expected annual onboarded hospitals with 215 annual hospital subscriptions; Year 2 projects 85 expected annual onboarded hospitals with 300 annual subscriptions; Year 3 projects 85 expected annual onboarded hospitals with 385 annual subscriptions. Optional Year 1 (fourth year) projects 30 expected onboarded hospitals with 415 annual subscriptions, and Optional Year 2 (fifth year) projects 82 expected onboarded hospitals with 497 annual subscriptions. The workbook provides formulas to calculate annual subscription costs and onboarding fees, with all bidder-supplied pricing fields left blank pending completion by responding firms. The evaluated grand total encompasses costs for all three base years plus both optional years.