Financial Planner CoGS at The Coca-Cola Company

Key Outputs and Accountabilities

Cost of Goods Sold

• 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    
Qualifications and Experience 

• BCom Honours or equivalent. 
• Chartered Accountant of South Africa (CA(SA)) / Certified Institute of Management Accountants (CIMA) would be advantageous.
• 4 years’  operational finance experience.
• Previous experience in managing a complex reporting function an advantage.