Financial Planner Budgeting & Scenario at The Coca-Cola Company

Key Purpose  

• To execute scenario and business planning processes by conducting various analyses and running of financial models, used to support the delivery of the CCBSA Annual Business Plan (ABP), Long Range Plan (LRP) and forecasts, aligned to the CCBSA business strategy.

Key Duties & Responsibilities    
Key Outputs and Accountabilities 

Budgeting and Scenario Planning (Group, Regional and Forecasts)

• Calculate revenue, raw materials and discounts across CCBSA, using input model and submit into the budgeting platform tool for ABP, LRP and forecasts. 
• Prepare and compile templates for the ABP, LRP and forecast related information in preparation for submission, as part of the pre-budgeting process.
• Upload approved ABP, LRP and forecast information onto budgeting reporting platform for submission to Group Office. 
• Propose timelines for regional forecast submissions, through collaboration with business stakeholders, to ensure timeous completion. 
• Conduct variance analyses and provide input into commentary for month-to-month movements, in the respective financial statements, to identify the key drivers of these movements. 
• Prepare mid-month forecast model to determine the forecast view of the income statement.
• Prepare the rolling estimate forecast (Income Statement, Balance Sheet and Cash Flow) for all entities in the South African statutory group structure, and upload onto the statutory reporting platform post final approval.
• Prepare master data requests and log calls to ensure alignment of budgeting tool platform to identified models, enabling ensure adequate preparation for the budgeting process. 
• Draft presentations to illustrate comparisons across regional and group budgets and provide input into commentary. 
• Upload regional budgets onto the ERP platform to ensure regions are able to measure monthly financial performance against the budget. 
• Run adhoc scenario planning models to predict future outputs and feedback to business stakeholders. 
• Train and upskill new users on the budgeting tool to drive capability. 
• Coach regional finance teams on the budgeting tool to resolve any queries and build capability.

Governance 

• Pull reports from the statutory reporting platform to be used as evidence in the Corporate Audit Division (CAD), internal and external auditing processes. 
• Attend quarterly full-stock count within region, as a management control requirement, to ensure accurate stock reporting.
• Execute action plans to ensure closure of audit findings.  

Skills, Experience & Education    
Qualifications and Experience

• BCom Honours degree in Accounting or Financial Management.
• Chartered Accountant of South Africa (CA(SA)) / Certified Institute of Management Accountant would be advantageous.
• 3-5 years of finance experience.
• Direct operational experience would be advantageous.