Financial Planner Budgeting & Scenario at Coca-Cola Midrand

Coca-Cola Beverages South Africa (CCBSA) has an exciting opportunity in the Finance department. We are looking for a talented individual with relevant skills and experience for a Financial Planner: Budgeting & Scenario role, which is based in Midrand. The successful candidate will report directly to the Financial Controller for budgeting and scenario Planning. 

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.  

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.

Competencies 

Integrity and Trust 

Is widely trusted; is seen as a direct, truthful individual; can present the unvarnished truth in an appropriate and helpful manner; keeps confidences; admits mistakes; doesn’t misrepresent him/herself for personal gain.

Ethics and Values

Adheres to an appropriate (for the setting) and effective set of core values and beliefs during both good and bad times; acts in line with those values; rewards the right values and disapproves of others; practices what he/she preaches.

Customer Focus 

Is dedicated to meeting the expectations and requirements of internal and external customers; gets first-hand customer information and uses it for improvements in products and services; acts with customers in mind; establishes and maintains effective relationships with customers and gains their trust and respect.

Comfort Around Higher Management

Can deal comfortably with more senior managers; can present to more senior managers without undue tension and nervousness; understands how senior managers think and work; can determine the best way to get things done with them by talking their language and responding to their needs; can craft approaches likely to be seen as appropriate and positive.

Approachability

Is easy to approach and talk to; spends the extra effort to put others at ease; can be warm, pleasant, and gracious; is sensitive to and patient with the interpersonal anxieties of others; builds rapport well; is a good listener; is an early knower, getting informal and incomplete information in time to do something about it.

Action Oriented

Enjoys working hard; is action-oriented and full of energy for the things he/she sees as challenging; not fearful of acting with a minimum of planning; seizes more opportunities than others.

Interpersonal Savvy 

Relates well to all kinds of people, up, down, and sideways, inside and outside the organization; builds appropriate rapport; builds constructive and effective relationships; uses diplomacy and tact; can diffuse even high-tension situations comfortably.

Organizing

Can marshal resources (people, funding, material, support) to get things done; can orchestrate multiple activities at once to accomplish a goal; uses resources effectively and efficiently arranges information and files in a useful manner.

Knowledge

International Financial Reporting Standards (IFRS) reporting standards used to regulate reporting standards.