e notes = 9,582,603 items To process every document and case note, the total cost would be 9583 x £7.24 = ~£69,380.92 Total processing cost of ~£85,688.20 This is based on only a small subset of data and does not include the ongoing data storage and compute costs. This does not include LiquidLogic forms. Costs will be impacted by: - Documents that cannot be processed (either because they are an unsupported format or have passwords) will reduce compute costs - The speed of the Azure AI processing (the longer it takes, the greater the bill) - Whether Entity Recognition happens on everything in advance, or it is done on demand as and when needed Ongoing Usage Costs Two key changes to usage have moved the solution from mainly resource-based billing to mainly consumption-based. This reduces costs because with a mainly resource-based solution costs are incurred regardless of use. The reduction in costs were: - £29 a day reduction by moving from Cognitive Search/Azure Function to Data Factory - £13.50 a day reduction by moving the Liquid Logic snapshot SQL Server to be serverless The main resource-based cost after these changes is Azure SQL storage and the cost is proportional to the database size. The main consumption-based costs are: - Data Factory - Azure SQL - AI Services 41 OFFICIAL - SENSITIVE Standing Cost Estimates These are the costs of having the system set-up, doing nothing. The costs are storage and networking costs. - Data Factory Private Endpoint £0.54 per day - SQL Server Storage ~£2.00 per day - Other Networking ~£1 per day - Total: £4.54 x 365 days = £1,657 per year. Ongoing Usage Costs – North Yorkshire Council Estimate There will be additional costs based on SQL Server compute usage, but these are unknown at present. To estimate those expected user-patterns 