Financial Planner

To own the maintenance of product costing and the bill of materials. Ensure timeous analysis and insights on Cost of Goods Sold performance for CCBSA in order to support timeous and accurate business decision-making.

**Key Duties & Responsibilities**:
Prepare the Bill of Material (BOM) analysis (month and year to date) versus multiple plans and Prior Year (PY) and provide insightful commentary on the analysis.
- Preparation of variance analysis against comparatives (Budget, Rolling Estimates, prior periods) and provide insightful commentary.
- Prepare and submit monthly CoGS slides for review prior to inclusion into the business review.
- Problem solve any discrepancies relating to master data to ensure accurate or complete costing.
- Identify and communicate any issues on product costing related to value chains to senior management to enable meaningful negotiations between CCBSA and The Coca-Cola Company (TCCC).
- Analyse and provide insights on price variances to ensure accurate costing across existing ERP systems.
- Identify and execute process improvement initiatives for BOM analysis, product costing, raw material analysis etc.
- Ownership of and accountability for the accuracy of all costing data for CCBSA (including new products, promotional products etc.).
- Work with Technical and Commercial department on the costing of new products.
- Prepare the budget product costing models for each plant to support the delivery of the CoGS budget.
- Prepare the BOM budgets for plant and company to ensure accurate CoGS targets are set.
- Prepare and perform product cost estimates for ERP (monthly, annual, ad-hoc) as part of maintaining costing on the ERP system.
- Create costing runs for updates required at month end due to change in standard prices.
- Identify focus areas where commodity increases are not in line with the Consumer Price Index (CPI) or market related to ensure risks and opportunities are timeously identified and communicated.
- Complete statutory templates covering raw material purchasing and management for submission to the Financial Controller.

Governance
- Implement the identified Risk and Control Matrix (RACM) controls to comply with the RACM framework requirements and mitigate financial risk to the business.
- Conduct quarterly self-assessment to identify areas of non-compliance relating to management reporting and cost of goods.
- Attend quarterly full-stock count within region, as a management control requirement, to ensure accurate stock reporting.
- Attend the monthly commodity stock counts to ensure accurate stock reporting.
- Source and provide information required for the statutory audit process for identified entities in the South African statutory group structure to ensure compliance to International Financial Reporting Standards (IFRS) and audit controls.
- Upload collated evidence onto relevant platform as required by Corporate Audit Division (CAD) as per The Coca-Cola Company (TCCC) as well as internal auditors and external auditors to assess internal controls compliance and correct accounting aligned to IFRS.
- Implement action plans to ensure closure of audit findings and mitigation of further risk to the business.
- Prepare General Ledger reconciliations for identified accounts, as per RACM requirements.

**Skills, Experience & Education**:

- BCom Honours degree in Accounting or Financial Management.
- Chartered Accountant of South Africa (CA (SA)) or Certified Institute of Management Accountants (CIMA) would be advantageous.
- 3-5 years of experience in financial management or management accounting.
- Experience in costing would be advantageous.

**General**:
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.