Award

Financial Modeller

THE INSOLVENCY SERVICE

This public procurement record has 1 release in its history.

Award

18 Mar 2022 at 12:20

Award Notice
Summary of the contracting process

The procurement process involves the awarding of a contract for the role of Financial Modeller, initiated by The Insolvency Service, based in Birmingham, England. This procurement falls under the services industry category, specifically recruitment services (CPV code: 79600000). The contract is part of a selective procurement method and was awarded following a call-off from a framework agreement. Key dates include the contract start date on 1st April 2022, with an end date of 30th December 2022. The tender period concluded on 1st March 2022.

This opportunity for a Financial Modeller provides a pathway for small and medium-sized enterprises (SMEs) with expertise in financial modelling, analysis, and accounting. Companies that specialise in developing complex financial models and possess strong proficiency in Excel will be well-positioned to compete. Given the delivery location in the United Kingdom, local businesses familiar with the public sector could particularly benefit from this contract, helping them grow through their involvement in significant financial planning projects.

Find more tenders on our Open Data Platform.
How relevant is this notice?

D3 Tenders Premium

Win More Public Sector Contracts

AI-powered tender discovery, pipeline management, and market intelligence — everything you need to grow your public sector business.

Start Free Trial Book a Demo
All Features Pricing

Notice Information

Notice Title

Financial Modeller

Notice Description

Financial Modeller The Financial Modeller will provide key support to the Financial Planning and strategy project teams, leading development of the financial models and analysis needed to inform the strategy implementation and 5-year Strategic Business Plan. The role will require strong financial modelling and accounting skills and experience, use of excel to produce and maintain multi-year spreadsheet models, and an ability to work with colleagues from finance and across operations to interpret data and explain modelling requirements and outputs and produce graphics for senior managers. Deliverables: * Develop financial models. Developing and implementing financial forecasting and budgeting model. * Develop reporting tools that automatically imports Business Plans into a consolidation model. * Develop models into an integrated reporting suite. * Creating a series of Excel and PowerPoint that could update charts and tables in presentation packs * Provide support to fix and develop financial models. * Work with the finance/Ops team to understands the complex requirements and accurately implemented data in various modules. * Utilise data manipulation techniques in Excel to populate models with accounting data. * Develop investment appraisal model that allow for the potential cost or revenue benefits to be compared with the costs of the project. o Decision models whereby answering a series of questions determine the level of authority, e.g. board, committee or delegated authority, required for making an investment or accepting a customer. * Developed best practice model build, version control and model review methodologies

Notice Details

Publication & Lifecycle

Open Contracting ID
ocds-b5fd17-ac829e70-e903-4471-bdda-3601518ab9af
Publication Source
Contracts Finder
Latest Notice
https://www.contractsfinder.service.gov.uk/Notice/49a9bc7b-36db-4086-b84c-d785c274ca8c
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
SME

Common Procurement Vocabulary (CPV)

CPV Divisions

79 - Business services: law, marketing, consulting, recruitment, printing and security

CPV Codes

79600000 - Recruitment services

Notice Value(s)

Tender Value
£91,935 Under £100K
Lots Value
Not specified
Awards Value
£91,935 Under £100K
Contracts Value
Not specified

Notice Dates

Publication Date
18 Mar 20223 years ago
Submission Deadline
1 Mar 2022Expired
Future Notice Date
Not specified
Award Date
16 Mar 20223 years ago
Contract Period
31 Mar 2022 - 30 Dec 2022 6-12 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
THE INSOLVENCY SERVICE
Contact Name
Jane Cooper
Contact Email
jane.cooper@insolvency.gov.uk
Contact Phone
Not specified

Buyer Location

Locality
BIRMINGHAM
Postcode
B4 6FD
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

Supplier Information

Number of Suppliers
1
Supplier Name

ROBERTSON BELL

Further Information

Open Contracting Data Standard (OCDS)

View full OCDS Record for this contracting process

Download

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-ac829e70-e903-4471-bdda-3601518ab9af-2022-03-18T12:20:23Z",
    "date": "2022-03-18T12:20:23Z",
    "ocid": "ocds-b5fd17-ac829e70-e903-4471-bdda-3601518ab9af",
    "language": "en",
    "initiationType": "tender",
    "tender": {
        "id": "TIS0520",
        "title": "Financial Modeller",
        "description": "Financial Modeller The Financial Modeller will provide key support to the Financial Planning and strategy project teams, leading development of the financial models and analysis needed to inform the strategy implementation and 5-year Strategic Business Plan. The role will require strong financial modelling and accounting skills and experience, use of excel to produce and maintain multi-year spreadsheet models, and an ability to work with colleagues from finance and across operations to interpret data and explain modelling requirements and outputs and produce graphics for senior managers. Deliverables: * Develop financial models. Developing and implementing financial forecasting and budgeting model. * Develop reporting tools that automatically imports Business Plans into a consolidation model. * Develop models into an integrated reporting suite. * Creating a series of Excel and PowerPoint that could update charts and tables in presentation packs * Provide support to fix and develop financial models. * Work with the finance/Ops team to understands the complex requirements and accurately implemented data in various modules. * Utilise data manipulation techniques in Excel to populate models with accounting data. * Develop investment appraisal model that allow for the potential cost or revenue benefits to be compared with the costs of the project. o Decision models whereby answering a series of questions determine the level of authority, e.g. board, committee or delegated authority, required for making an investment or accepting a customer. * Developed best practice model build, version control and model review methodologies",
        "status": "complete",
        "classification": {
            "scheme": "CPV",
            "id": "79600000",
            "description": "Recruitment services"
        },
        "items": [
            {
                "id": "1",
                "deliveryAddresses": [
                    {
                        "countryName": "United Kingdom"
                    }
                ]
            }
        ],
        "value": {
            "amount": 91935.76,
            "currency": "GBP"
        },
        "procurementMethod": "selective",
        "procurementMethodDetails": "Call-off from a framework agreement",
        "tenderPeriod": {
            "endDate": "2022-03-01T12:00:00Z"
        },
        "contractPeriod": {
            "startDate": "2022-04-01T00:00:00+01:00",
            "endDate": "2022-12-30T23:59:59Z"
        },
        "suitability": {
            "sme": true,
            "vcse": false
        },
        "mainProcurementCategory": "services"
    },
    "parties": [
        {
            "id": "GB-SRS-supplierregistration.cabinetoffice.gov.uk/PFcF5f84",
            "name": "The Insolvency Service",
            "identifier": {
                "legalName": "The Insolvency Service",
                "scheme": "GB-SRS",
                "id": "supplierregistration.cabinetoffice.gov.uk/PFcF5f84"
            },
            "address": {
                "streetAddress": "Cannon House, 18 Priory Queensway",
                "locality": "Birmingham",
                "postalCode": "B4 6FD",
                "countryName": "England"
            },
            "contactPoint": {
                "name": "Jane Cooper",
                "email": "jane.cooper@insolvency.gov.uk"
            },
            "roles": [
                "buyer"
            ]
        },
        {
            "id": "GB-COH-06278798",
            "name": "ROBERTSON BELL LTD",
            "identifier": {
                "legalName": "ROBERTSON BELL LTD",
                "scheme": "GB-COH",
                "id": "06278798"
            },
            "address": {
                "streetAddress": "3Rd Floor,16 Upper Woburn Place LONDON WC1H 0BS GB"
            },
            "details": {
                "scale": "sme",
                "vcse": false
            },
            "roles": [
                "supplier"
            ]
        }
    ],
    "buyer": {
        "id": "GB-SRS-supplierregistration.cabinetoffice.gov.uk/PFcF5f84",
        "name": "The Insolvency Service"
    },
    "awards": [
        {
            "id": "ocds-b5fd17-ac829e70-e903-4471-bdda-3601518ab9af-1",
            "status": "active",
            "date": "2022-03-16T00:00:00Z",
            "datePublished": "2022-03-18T12:20:23Z",
            "value": {
                "amount": 91935.76,
                "currency": "GBP"
            },
            "suppliers": [
                {
                    "id": "GB-COH-06278798",
                    "name": "ROBERTSON BELL LTD"
                }
            ],
            "contractPeriod": {
                "startDate": "2022-04-01T00:00:00+01:00",
                "endDate": "2022-12-30T23:59:59Z"
            },
            "documents": [
                {
                    "id": "1",
                    "documentType": "awardNotice",
                    "description": "Awarded contract notice on Contracts Finder",
                    "url": "https://www.contractsfinder.service.gov.uk/Notice/49a9bc7b-36db-4086-b84c-d785c274ca8c",
                    "datePublished": "2022-03-18T12:20:23Z",
                    "format": "text/html",
                    "language": "en"
                },
                {
                    "id": "2",
                    "documentType": "contractSigned",
                    "url": "https://www.contractsfinder.service.gov.uk/Notice/Attachment/b0b9b5c1-e616-43ab-bac4-f13634cb89a9",
                    "format": "application/vnd.openxmlformats-officedocument.wordprocessingml.document"
                }
            ]
        }
    ]
}