Intern - Corporate Finance - FOB Forecasting & Analysis - (6 months - Jan 2019)

Job description

Country: Hong Kong
Job Function: Accounting & Finance

State / Province: Hong Kong
Position Type: Intern

City / Location: Hong Kong
Brand: adidas

Relocation:

Somewhere, in one of our workshops right now, the future is taking shape. We are constantly working to redefine the way clothing and footwear transforms the pitch, court or course. This is what drives us: the feeling of discovery and the urge to innovate. When we create a product that makes our hearts beat faster, we know we’re onto something.

If this sounds inspiring, you might be one of us: Someone who loves to create the present, as well as shape the future. There’s a reason adidas has been at the forefront of defining sport for more than 60 years: We never stand still. Everyday, we work to improve everything we create.

At adidas, interesting, amazing and inspiring aren’t just ideas. They are what we do every single day.

Purpose & Overall Relevance for the Organization:

· Bring transparency and create value added analysis for adidas group to enable accurate financial planning, fact-based decision making based on solid product costing, pricing and sourcing knowledge
· Support Purchase Price Variance (PPV) analysis
· Support Free On Board (FOB) Forecasting
· Support Macroeconomic analysis

Key Responsibilities and Projects :

· Purchase Price Variance (PPV) analysis [35%]
· Support the preparation of forecast/month-end report for PPV analysis
· Support creating PPV analysis model to extended markets
· Drive automations in various report creation process
· Asist in enhancing and modifying the logic and mechanism of existing calculation models and database.
· Free On Board (FOB) Forecasting / Landed Cost tracking and analysis [25%]
· Assist in tracking various key cost components (e.g. material cost, minimum wages, freight, duties)
· Assist in any ad hoc FOB or landed cost analysis
· Assist in preparing powerpoints for management presentation
· Support Macroeconomic Business Intelligence (MBI) Analysis[20%]
· Assist in researching, data mining and writing for the Quarterly Macroeconomic Business Intelligence Report
· Support analysis and tracking of macroeconomic trends across divisions
· Mini Project [20%]
· Conduct analysis on trends of various commodity prices and their impact on adidas FOB. Enhance existing FOB forecast mechanism.
· Enhance FOB visibility. Create reports and newletters that summarize and link up various FOB related topics across divisions and departments.


Key Objectives (special tasks and learnings):

· Understand the end-to-end adidas FOB forecasting cycle. Understand FOB, FOB forecast elements, PPV, PPV elements and their respective working process
· Build understanding of how macroeconomic factors may impact product costs through trend analysis
· Project work involvement to enhance understanding on how different initiatives make business impacts and the linkage to the company's strategic goals

Key Relationships:

1. aSL Finance HK - FOB Forecasting team

2. Sourcing Costing teams

3. TradeCo team

Required main study courses:

· Information Technology
· Computer Science
· Business Administration (Information System)
· Economics
· Finance
· Statistics
· Supply Chain

Required language skills:

· Good organization and communication skills
· Strong English skills required

Additional skills/ qualifications:

· Technically savvy with intermediate/ advanced knowledge of MS Office applications, especially in excel, access (e.g. query) and powerpoint
· Exposure to large data sets
· Strong analytical and systematic approach to handling numbers, information and interpretation
· Proactive mindset with the ability to think end-to-end
· Technical coding skills & Engineering Knowledge and Skills is a plus
· Knowledge of database management and BI applications is a plus
· Knowledge of SAP usage is a plus

Internship regulations:

The internship is 6 months full time starting in January 2019

Studentmust be enrolled at the university for the complete duration of the internship

#LILC