II.2.3) Place of performance
NUTS code:
UK
Main site or place of performance:
UNITED KINGDOM
II.2.4) Description of the procurement
The objectives of the solution are:
•All budgeting and forecasting to be undertaken directly within the solution:
oCosts and revenues - management expenses, project costs, compensation costs, levy and recoveries income;
oNon-P&L items including claims volumes; and
oHeadcount/FTE and contractors.
•All associated reporting to be produced from the solution.
•Actuals for all items listed to be automatically and regularly loaded into the solution to support the budgeting and forecasting process and enable variance analysis.
•The solution must be easy to use:
oFSCS requires a solution that is logical and would be readily manageable for input and parameterisation by Finance and Accounting staff. These are expected to be at a semi-professional level and therefore numerate and skilled to intermediate excel proficiency as a minimum and will understand accounting concepts. We would not expect them to have SQL skills, but it is anticipated that the skill level can be called upon from the business in exceptional cases.
•The solution must be flexible and be able to quickly reflect any changes to requirements. For example, the solution must easily allow for any changes or additions to any organisational structures, ABC categories, funding classes, claims products, account lines or cost centres.
•Ability to view real time information – including any cost allocations - once updates and changes are made to budgets and forecasts.
•Budget holders to be able to access the solution with restricted access based on their individually defined cost centres. Budget holders to be able to view latest forecasts and real time access to transactions.
•There will be approximately, not limited to:
o10 full users. These include Finance Team users, who will have full access to the system (Read, Create, Update and Delete) to the data, models, users, configuration, etc.
o3 support users. These will be IT support users, who would have full access (Read, Create, Update and Delete) but to only data and user/admin functions.
o37 read-only users. This includes Budget holders – who will only require access to view data and run report.
•Cost allocations – the solution must be able to perform allocations of actual and budget/forecast data based on defined drivers that may not remain static (e.g., YTD headcount and claims volumes) throughout the year.
•Scenario planning – to have a separate module or area in the solution where various alternate scenarios can be modelled and does not impact the current forecasts and budgets.
•Administration of the solution should be able to be performed circa 80% in-house, once fully implemented. Administration comprises activities such as creating new cost centres, changes to organisational structure, amending user access, amending controllable and volume driven cost classifications, funding classes, claims products and amend calculations.
•Must be able to upload data daily from the ledger system (currently SunSystems), to include full P&L and balance sheet.
•Must be able to upload prescribed system data to the Data Warehouse and have the ability to load data back into the Data Warehouse also.
•Must have a facility to provide confidence that the data loaded into the system is complete and accurate, whether through reconciliation or other means.
•The solution must be adaptable for potential future changes in the systems that it integrates with e.g., Data warehouse or change of Finance systems or other data feeds and possibly move to a more API (Application Programming Interface) based connector.
II.2.5) Award criteria
Price is not the only award criterion and all criteria are stated only in the procurement documents
II.2.6) Estimated value
Value excluding VAT:
1 150 000.00
GBP
II.2.7) Duration of the contract, framework agreement or dynamic purchasing system
Duration in months: 36
This contract is subject to renewal: Yes
Description of renewals:
This includes the option to extend for a further period of 2 years and then subsequent two 12- month contract extensions.
II.2.9) Information about the limits on the number of candidates to be invited
II.2.10) Information about variants
Variants will be accepted:
No
II.2.11) Information about options
Options:
No
II.2.13) Information about European Union funds
The procurement is related to a project and/or programme financed by European Union funds:
No
II.2.14) Additional information
The estimated value of the contract includes the initial term in addition all extension options