About the role This is a senior analytical role involved in the preparation of budgets and forecasts, including long-term planning, for Booker.
The role works closely with the wider finance team to co-ordinate, consolidate, analyse and challenge the budgets & forecasts proposed.
It will be required to work with the Tesco FP&A team to ensure deadlines are met and queries are answered and resolved.
There will also be involvement in some period end reporting activities.
The role will be play a key part in driving forward the ongoing FP&A agenda in Booker.
Main Responsibilities Management and co-ordination of the budgeting & forecasting process including: Preparation of timetables, submission templates and consolidation models.
Consolidation, review and analysis of inputs received from the Finance team.
Submission of excel templates to Tesco FP&A to required timetable.
Preparation of presentations of budget & forecast output for Exec and other meetings.
Ongoing improvement and development of budget & forecasting processes and models.
Management and co-ordination of the financial submissions for the long-term plan (LTP).
Preparation, maintenance and continual improvement of the consolidation model for the LTP financial data.
Consolidation, review and analysis of inputs received from the Finance team.
Submission of excel templates to Tesco FP&A to required timetable.
Involvement in preparation of presentations as required.
Ownership for the calculation and reporting of statutory sales.
Calculation of periodic statutory sales split between key business areas, identifying LFL movements and splitting between inflation and volume/mix movements.
Reporting of statutory sales to Tesco FP&A, including commentary on drivers of variances, via the 'flash' process.
Preparation of quarterly 'SIP' file for submission to Tesco FP&A to be used in the external market reporting.
Preparation of the PowerPoint document for verification and sign-off of the Booker numbers and narrative included in the quarterly market reports.
Other period end tasks.
Reconciliation of the BRP sales between SAP and the sales & margin reports.
Allocation of all levels of Commercial Gross for BRP into the brands.
Preparation of the indicative P&L by customer & channel including calculation of the cost allocations and input into TM1.
Preparation of the periodic sales development slide for the Management Accounts.
You will need Experience relevant for this job: Qualified accountant.
FP&A experience preferred.
Strong communication and presentation skills.
Skills relevant for this job Commercial acumen and Know How and Inquisitive.
Desire to learn / add value / drive progress.
Excellence in building positive relationships, whilst robustly challenging norms.
Intermediate/Advanced Excel skills.
Strong tech and business analytics skills.
What's in it for you At Booker, along with being a great place to work and giving you an opportunity to get on in your career, we also offer the following fantastic package of benefits: A Booker colleague card with 10% off purchases at Booker and double discount events up to three times a year.
After 3 months service, a Tesco colleague discount card with 10% increasing to 15% off most purchases at Tesco for a 4 day period after every four-weekly pay day, ie.
thirteen times a year.
In addition to 10% off at Tesco Cafe and 20% off all F&F purchases.
10% off pay monthly & SIM only deals with Tesco Mobile for yourself, along with further great deals through-out the year.
Up to 30% off car, pet and home insurance at Tesco bank.
Terms and conditions apply.
Free eye test when you spend £50 or more.
You can also save 30% when you spend £50 or more on glasses, prescription sunglasses and contact lenses.
50% off health checks at Tesco Pharmacy.
Exclusive access to discounted RAC breakdown cover rates An exclusive deals and discounts website saving you money on everyday purchases including a cycle to work scheme.
After 3 months service, you can join our annual Save As You Earn share scheme which allows you to buy Tesco shares in the future at a discount.
Retirement savings plan (pension) - save up to 5% and Booker will match your contribution.
Life Assurance - You are covered for death in service life cover of up to three times annual pay Health and Wellbeing support and resources including our 24/7, confidential Employee Assistance Programme and Virtual GP for you and your family.
A great holiday package