Job Details
Skills And Tools:
Job Description
Position Overview:
Job Summary:
Performs calculations and submissions regarding the Actuals Reporting and Forecasts (RE/BP) in his/her responsibility area within EAG. Supports BU P&A Team in optimization and standardization of Planning & Analysis’ processes and tools within his/her responsibility area.
Helps BU P&A Team to create routines and collaborative partnerships to document and share best practices broadly.
Supports Region Finance and BU P&A organizations for efficient, effective and sustainable finance processes and transactions; provides services according to business needs while leveraging leading finance practices across the Group. Ensures timely and accurate financial statements are being provided.
Job Profile:
KEY DUTIES/RESPONSIBILITIES:
Performs Actuals Reporting in his/her responsibility area, while adhering to closing calendar deadlines.
- Performs actual UC reporting
- Ensures actual UC volume is accurate and available in BOFC
- Prepares for weekly UC sales reporting
- Performs GP analysis
- Confirms finalization of actual postings with CPS
- Ensures concentrate revenue and costs are accurately posted
- Performs GP reallocation calculation, if required
- Ensures accuracy of concentrate write off accruals
- Calculates GPIE on quarterly basis and sends JV to RFC and supporting documents to HQ
- Ensures deduction JV is posted timely & accurately
- Performs actual DME closing
- Performs activities for DME reconciliation and charges to/from Bottlers
- Reviews charter campaigns and charge out to BUs
- Reconciles prepaid expense balance in coordination with GFO
- Ensures MPP phasing is accurate in MEM
- Performs year-end & month-end DME accruals
- Runs and validates sales curve adjustment
- Performs actual OPEX closing
- Obtains and controls OPEX actuals and post accrual JVs if required
- Identifies OPEN PO line items and submits OPEX accrual JVs to GFO
- Prepares equity income JV and narratives
- Performs financial control and analysis
- Reviews, controls and analyzes P&L for actual closing
- Performs B/S reconciliation (analyze GL accounts and validate the figures)
- Prepares and submits monthly, quarterly, annual and ad-hoc actual reports including
- Manual templates
- Actual closing narratives (P&L and OPCAP)
- Management Reporting deck for Regions, BUs, EAG
- Ad-hoc reports prepared upon Region, BU requests
- Quarterly CAPEX reporting
- Quarterly SEC representation letter submission
- Annual UC P&L execution and BC reporting•
Management of Forecasts (RE/BP) in his/her responsibility area, while adhering to RE/BP calendar deadlines:
- Prepares input assumptions and adjusts BPC according to Region / BU requests:
- OR/PF
- Concentrate shipment planning (inventory based, DSI based, or manual)
- Volume driven rebates, freight, sales tax
- OPEX
- DME
- Working capital
- Performs RE/BP financial statement line items and adjusts according to Region/BU guidance. Performs RE and BP activities
- Uploads UC and CSE forecast in BPC
- Deduction planning in BPC
- GPIE calculation
- DME planning in BPC (including FDW extractions)
- OPEX planning in BPC (including coordination of OPEX input files in BP period)
- Equity income planning in BPC
- B/S forecasting in BPC
- UC P&L planning in BPC
- Coordinates input and output templates with Regions and BUs
- Prepares RE/BP interim output reports for Regions and BUs during planning period
- Compiles and performs RE/BP management reporting and financial consolidation at BU level
- Controls and analyzes BP/RE management reports (scorecards, dashboards, brand contribution, MEM reports)
Job Requirements
QUALIFICATIONS / COMPETENCIES / SKILLS:
- The ability to apply forecasting techniques and skills to develop and evaluate business goals and strategies, analyzing information to derive insights and implications to initiate planning and/or re-planning, and controlling financial results.
Foundational competencies:
- Accepting and building accountability
- Building value based relationships
- Communicating effectively
- Initiating action
- Planning and organizing
- Thinking systematically
Technical skills:
- Financial analysis
- Planning and forecasting skills
- Performance management
- GAAP, cost accounting / analysis
- Information technology
RELATED EXPERIENCE REQUIREMENTS/ QUALIFICATIONS:
- Minimum 4 years of experience
- Accounting experience is a strong plus
EDUCATIONAL REQUIREMENTS:
- University/Bachelor’s degree - Minimum
- Postgraduate/Master’s degree - Preferred
CULTURAL DIVERSITY:
This position requires working in diverse environments and with multicultural teams.
TRAVEL REQUIREMENTS:
- Minimal travel is required through BU locations.
ADDITIONAL INFORMATION:
The key success-criteria is:
- Communicate clearly about financial concepts in order to act as a true business-partner with local Finance.
- Working for specific regions through a Business Insights Network (pool of resources), but when needed supporting other regions within the BU.