Published date: 15 November 2021

Awarded contract - This means that the contract has been awarded to a supplier.


Closing: 26 February 2021, 5pm

Contract summary

Industry

  • General management consultancy services - 79411000

Location of contract

West Midlands, London

Value of contract

£23,520

Procurement reference

PROC.01.0683

Published date

15 November 2021

Closing date

26 February 2021

Closing time

5pm

Contract start date

11 March 2021

Contract end date

31 March 2021

Contract type

Service contract

Procedure type

Single tender action (below threshold)

A direct contract with a single supplier, without competition.

This procedure can be used for procurements below the relevant contract value threshold.

Contract is suitable for SMEs?

Yes

Contract is suitable for VCSEs?

No

Description

The Supplier shall provide the following services to Ofwat:
Excel and VBA support in the creation, and testing, of the Annual Performance
Review (APR) 2021 Excel based data collection template. This includes;
1. Building data tables in Excel based on the data collection requirements of the APR 2021 process, these requirements will be defined by Ofwat;
2. Populating data tables with the required formulas. The formulas will be defined, and reviewed, by Ofwat;
3. Where applicable, implementing data validation rules e.g. enforcing data types, or ensuring answers are consistent across data tables;
4. Where applicable, protecting sheets and ranges to reduce the end user's ability to edit the format of the data tables. Ofwat will be provided with any passwords used to protect the template;
5. Creating a worksheet that pulls data from the underlying tables. This worksheet, referred to as an F Output by Ofwat, is the mechanism used to push data into Ofwat's SQLDatabase 'Fountain';
6. Complete data upload test runs to ensure the F-output worksheet is compatible with Fountain

More information

Additional text

For further information, please contact procurement@ofwat.gov.uk

Award information

Awarded date

10 March 2021

Contract start date

11 March 2021

Contract end date

31 March 2021

Total value of contract

£23,520

This contract was awarded to 1 supplier.

Price Waterhouse Coopers Llp

Address

1 Embankment Place
WC2N 6RH
GB

Reference

Companies House number: OC309347

Supplier is SME?

Yes

Supplier is VCSE?

No

About the buyer

Address

Birmingham
Birmingham
B54UA
England

Email

mailbox@ofwat.gov.uk