Award

Financial Modeller

THE INSOLVENCY SERVICE

This public procurement record has 1 release in its history.

Award

21 Oct 2021 at 18:05

Award Notice
Summary of the contracting process

The recent procurement process titled "Financial Modeller" has been completed by The Insolvency Service, located in Birmingham, England. This contract falls under the recruitment services industry category and was procured through a selective method, specifically a call-off from a framework agreement. The tender period ended on 6th October 2021, and the contract commenced on 20th October 2021, lasting until 31st March 2022, with a total contract value of £55,748.28.

This opportunity could foster significant business growth for SMEs specialising in financial consulting and modelling services. Companies adept in developing financial forecasting models, budget analysis, and reporting tools would be particularly well-positioned to take advantage of similar tenders. The ability to collaborate effectively with public sector bodies and meet complex financial requirements will serve as a competitive advantage in such procurement processes.

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-87be86f4-a4ab-4007-add6-c7d2a3a126e5
Publication Source
Contracts Finder
Latest Notice
https://www.contractsfinder.service.gov.uk/Notice/0eb16ad8-188e-4247-bd42-d9680063a84d
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
£55,748 Under £100K
Lots Value
Not specified
Awards Value
£55,784 Under £100K
Contracts Value
Not specified

Notice Dates

Publication Date
21 Oct 20214 years ago
Submission Deadline
6 Oct 2021Expired
Future Notice Date
Not specified
Award Date
12 Oct 20214 years ago
Contract Period
19 Oct 2021 - 31 Mar 2022 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
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

Notice Documents

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-87be86f4-a4ab-4007-add6-c7d2a3a126e5-2021-10-21T19:05:28+01:00",
    "date": "2021-10-21T19:05:28+01:00",
    "ocid": "ocds-b5fd17-87be86f4-a4ab-4007-add6-c7d2a3a126e5",
    "language": "en",
    "initiationType": "tender",
    "tender": {
        "id": "TIS0486",
        "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": 55748.28,
            "currency": "GBP"
        },
        "procurementMethod": "selective",
        "procurementMethodDetails": "Call-off from a framework agreement",
        "tenderPeriod": {
            "endDate": "2021-10-06T12:00:00+01:00"
        },
        "contractPeriod": {
            "startDate": "2021-10-20T00:00:00+01:00",
            "endDate": "2022-03-31T23:59:59+01:00"
        },
        "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": "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-87be86f4-a4ab-4007-add6-c7d2a3a126e5-1",
            "status": "active",
            "date": "2021-10-13T00:00:00+01:00",
            "datePublished": "2021-10-21T19:05:28+01:00",
            "value": {
                "amount": 55784.28,
                "currency": "GBP"
            },
            "suppliers": [
                {
                    "id": "GB-COH-06278798",
                    "name": "ROBERTSON BELL LTD"
                }
            ],
            "contractPeriod": {
                "startDate": "2021-10-20T00:00:00+01:00",
                "endDate": "2022-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/0eb16ad8-188e-4247-bd42-d9680063a84d",
                    "datePublished": "2021-10-21T19:05:28+01:00",
                    "format": "text/html",
                    "language": "en"
                }
            ]
        }
    ]
}