Notice Information
Notice Title
CPSP 130 Commercial data Standardisation and Management Support
Notice Description
Estimate Data review and Standardise Non-RIS2 schemes estimates' data cleanse and migration from old tracker to MP estimates database. 1) Understand data journey made over the last couple of months and the processes currently in place for MP estimates. 2) Normalise data for the ~1.4k lines of MP estimates logged on the superseded excel tracker not currently in the MP Estimates database. 3) Sift out technical notes (ad hoc requests) and OD estimates from tracker. 4) Obtain RET extracts from SHARE or specific location on shared drives. 5) Make necessary changes to the RET collation tool to allow analysis of older versions of RETs. 6) Collate RET information from all sources RETs. 7) Validate line entries against corresponding RET information. 8) Batch import estimates information into current MP Estimates database. Notes / caveats: a) Where it is not possible to get source data (release email, RET, Form200, Form300) it will not be possible to validate the line entry. In this case, the entry will be submitted to the database 'as is' following the data normalising exercise. b) There will be a requirement to liaise with Jane Searle for the sourcing of information from the commercial services division mailbox. c) On obtaining estimates information: i) This does not include sifting through CE folders on shared drives with a view to source RETs (or indeed peer reviews, Form200s and Form300s). ii) If associated files are not available on SHARE or a specific location on the shared drives then we will be unable to import this in the database, and therefore will not be able to validate line entries. iii) If associated files are stored as hard copies within the office we will not be able to validate the estimate information on the estimates tracker. MP Estimate Data 1) MP Estimates database (continued): a) Make the necessary changes to the database and dashboard that have been requested. b) Develop database and dashboard further to include ability to capture and report on technical notes. c) Updating guidance and continual support for estimating Co-ordinator. 2) Draft Scheme Budget Setting: a) Work with HE CP to understand requirements b) Implement reporting solution for the tracking of estimates and budgets c) Develop dashboard for viewing budget setting information. 3) OD CP reporting solution: (separate workstream) a) Manage solution delivery: oversee exercise and provide guidance for technical analyst responsible for solution design and implementation. b) Provide support as and when needed. 5) Ad hoc support for Cost Planning team. Estimating data Pipeline The CPT require a better forward view of their pipeline of estimating work. Current management is reactive and there is a requirement to move to a proactive position to enable better planning and organisation of the team to take place. 1) Understand the data available and produce a tracking schedule/plan 2) Specify and develop engagement plan 3) Obtain stakeholder buy in and agreement of solution by
Notice Details
Publication & Lifecycle
- Open Contracting ID
- ocds-b5fd17-0a147a05-ff71-4b33-a9f5-e7d87f7a3f2a
- Publication Source
- Contracts Finder
- Latest Notice
- https://www.contractsfinder.service.gov.uk/Notice/36213e1d-730a-4f37-a56a-8c91fd91b481
- Current Stage
- Award
- All Stages
- Award
Procurement Classification
- Notice Type
- Award Notice
- Procurement Type
- Framework
- Procurement Category
- Services
- Procurement Method
- Selective
- Procurement Method Details
- Call-off from a framework agreement
- Tender Suitability
- SME
- Awardee Scale
- Large
Common Procurement Vocabulary (CPV)
- CPV Divisions
71 - Architectural, construction, engineering and inspection services
-
- CPV Codes
71244000 - Calculation of costs, monitoring of costs
Notice Value(s)
- Tender Value
- £153,899 £100K-£500K
- Lots Value
- Not specified
- Awards Value
- £153,899 £100K-£500K
- Contracts Value
- Not specified
Notice Dates
- Publication Date
- 21 Feb 20215 years ago
- Submission Deadline
- 19 Nov 2020Expired
- Future Notice Date
- Not specified
- Award Date
- 24 Nov 20205 years ago
- Contract Period
- 24 Nov 2020 - 31 Mar 2021 1-6 months
- Recurrence
- Not specified
Notice Status
- Tender Status
- Complete
- Lots Status
- Not Specified
- Awards Status
- Active
- Contracts Status
- Not Specified
Buyer & Supplier
Contracting Authority (Buyer)
- Main Buyer
- HIGHWAYS ENGLAND
- Contact Name
- Not specified
- Contact Email
- cpspf@highwaysengland.co.uk
- Contact Phone
- Not specified
Buyer Location
- Locality
- BIRMINGHAM
- Postcode
- B1 1RN
- Post Town
- Birmingham
- Country
- England
-
- Major Region (ITL 1)
- TLG West Midlands (England)
- Basic Region (ITL 2)
- TLG3 West Midlands
- Small Region (ITL 3)
- TLG31 Birmingham
- Delivery Location
- Not specified
-
- Local Authority
- Birmingham
- Electoral Ward
- Ladywood
- Westminster Constituency
- Birmingham Ladywood
Further Information
Notice Documents
-
https://www.contractsfinder.service.gov.uk/Notice/36213e1d-730a-4f37-a56a-8c91fd91b481
21st February 2021 - Awarded contract notice on Contracts Finder
Open Contracting Data Standard (OCDS)
View full OCDS Record for this contracting process
The Open Contracting Data Standard (OCDS) is a framework designed to increase transparency and access to public procurement data in the public sector. It is widely used by governments and organisations worldwide to report on procurement processes and contracts.
{
"tag": [
"compiled"
],
"id": "ocds-b5fd17-0a147a05-ff71-4b33-a9f5-e7d87f7a3f2a-2021-02-21T13:28:38Z",
"date": "2021-02-21T13:28:38Z",
"ocid": "ocds-b5fd17-0a147a05-ff71-4b33-a9f5-e7d87f7a3f2a",
"language": "en",
"initiationType": "tender",
"tender": {
"id": "tender_198985/927209",
"title": "CPSP 130 Commercial data Standardisation and Management Support",
"description": "Estimate Data review and Standardise Non-RIS2 schemes estimates' data cleanse and migration from old tracker to MP estimates database. 1) Understand data journey made over the last couple of months and the processes currently in place for MP estimates. 2) Normalise data for the ~1.4k lines of MP estimates logged on the superseded excel tracker not currently in the MP Estimates database. 3) Sift out technical notes (ad hoc requests) and OD estimates from tracker. 4) Obtain RET extracts from SHARE or specific location on shared drives. 5) Make necessary changes to the RET collation tool to allow analysis of older versions of RETs. 6) Collate RET information from all sources RETs. 7) Validate line entries against corresponding RET information. 8) Batch import estimates information into current MP Estimates database. Notes / caveats: a) Where it is not possible to get source data (release email, RET, Form200, Form300) it will not be possible to validate the line entry. In this case, the entry will be submitted to the database 'as is' following the data normalising exercise. b) There will be a requirement to liaise with Jane Searle for the sourcing of information from the commercial services division mailbox. c) On obtaining estimates information: i) This does not include sifting through CE folders on shared drives with a view to source RETs (or indeed peer reviews, Form200s and Form300s). ii) If associated files are not available on SHARE or a specific location on the shared drives then we will be unable to import this in the database, and therefore will not be able to validate line entries. iii) If associated files are stored as hard copies within the office we will not be able to validate the estimate information on the estimates tracker. MP Estimate Data 1) MP Estimates database (continued): a) Make the necessary changes to the database and dashboard that have been requested. b) Develop database and dashboard further to include ability to capture and report on technical notes. c) Updating guidance and continual support for estimating Co-ordinator. 2) Draft Scheme Budget Setting: a) Work with HE CP to understand requirements b) Implement reporting solution for the tracking of estimates and budgets c) Develop dashboard for viewing budget setting information. 3) OD CP reporting solution: (separate workstream) a) Manage solution delivery: oversee exercise and provide guidance for technical analyst responsible for solution design and implementation. b) Provide support as and when needed. 5) Ad hoc support for Cost Planning team. Estimating data Pipeline The CPT require a better forward view of their pipeline of estimating work. Current management is reactive and there is a requirement to move to a proactive position to enable better planning and organisation of the team to take place. 1) Understand the data available and produce a tracking schedule/plan 2) Specify and develop engagement plan 3) Obtain stakeholder buy in and agreement of solution by",
"status": "complete",
"classification": {
"scheme": "CPV",
"id": "71244000",
"description": "Calculation of costs, monitoring of costs"
},
"items": [
{
"id": "1",
"deliveryAddresses": [
{
"countryName": "British Oversea Territories"
},
{
"countryName": "Channel Islands"
},
{
"countryName": "Europe"
},
{
"countryName": "Isle of Man"
},
{
"countryName": "Rest of the World"
},
{
"countryName": "United Kingdom"
}
]
}
],
"value": {
"amount": 153899.41,
"currency": "GBP"
},
"procurementMethod": "selective",
"procurementMethodDetails": "Call-off from a framework agreement",
"tenderPeriod": {
"endDate": "2020-11-19T14:00:00Z"
},
"contractPeriod": {
"startDate": "2020-11-24T00:00:00Z",
"endDate": "2021-03-31T23:59:59+01:00"
},
"suitability": {
"sme": true,
"vcse": false
},
"mainProcurementCategory": "services"
},
"parties": [
{
"id": "GB-CFS-79964",
"name": "Highways England",
"identifier": {
"legalName": "Highways England"
},
"address": {
"streetAddress": "The Cube",
"locality": "Birmingham",
"postalCode": "B1 1RN",
"countryName": "England"
},
"contactPoint": {
"email": "cpspf@highwaysengland.co.uk"
},
"roles": [
"buyer"
]
},
{
"id": "GB-CFS-37462",
"name": "Turner & Townsend",
"identifier": {
"legalName": "Turner & Townsend"
},
"address": {
"streetAddress": "Leeds"
},
"details": {
"scale": "large",
"vcse": false
},
"roles": [
"supplier"
]
}
],
"buyer": {
"id": "GB-CFS-79964",
"name": "Highways England"
},
"awards": [
{
"id": "ocds-b5fd17-0a147a05-ff71-4b33-a9f5-e7d87f7a3f2a-1",
"status": "active",
"date": "2020-11-24T00:00:00Z",
"datePublished": "2021-02-21T13:28:38Z",
"value": {
"amount": 153899.41,
"currency": "GBP"
},
"suppliers": [
{
"id": "GB-CFS-37462",
"name": "Turner & Townsend"
}
],
"contractPeriod": {
"startDate": "2020-11-24T00:00:00Z",
"endDate": "2021-03-31T23:59:59+01:00"
},
"documents": [
{
"id": "1",
"documentType": "awardNotice",
"description": "Awarded contract notice on Contracts Finder",
"url": "https://www.contractsfinder.service.gov.uk/Notice/36213e1d-730a-4f37-a56a-8c91fd91b481",
"datePublished": "2021-02-21T13:28:38Z",
"format": "text/html",
"language": "en"
},
{
"id": "2",
"documentType": "tenderNotice",
"description": "n/a",
"url": "https://www.contractsfinder.service.gov.uk/Notice/Attachment/2b8853b1-313f-420c-91c1-84b4d80270ad",
"format": "application/vnd.openxmlformats-officedocument.wordprocessingml.document"
}
]
}
]
}