Intern - FOB forecasting, Finance, Hong Kong
Hong Kong Accounting / Management control
Job description
Country: Hong Kong
Job Function: Accounting & Finance
State / Province: Hong Kong
Position Type: Intern
City / Location: Hong Kong
Brand: adidas
Relocation: No Selection
Purpose & Overall Relevance for the Organization:
Support Free On Board (FOB) Forecasting - Researching and tracking macroeconomic information to support better FOB forecasting process.
Support Purchase Price Variance (PPV) analysis - Using SAP and other internal systems for data extraction and supporting various PPV analysis.
Key Responsibilities and Projects:
1) The Macroeconomic Business Intelligence (MBI) [30%]
- Assist in reasearhing and data mining for the Quarterly Macroeconomic Business Intelligence Report
2) FOB/ Landed Cost tracking and analysis [30%]
- 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
3) PPV analysis [20%]
- Support the preparation of forecast/month-end report for PPV analysis
4) Mini Projects [20%]
- Conduct analysis on trends of various commodity prices (e.g. oil) and their impact on adidas FOB
- Build a centralized and systematic tracking methodologies for various FOB components (e.g. Foreign exchange rate, labor wages, material cost) across divisions (Footwear, Apparel, A&G) to facilitate FOB forecasting
Skills and Knowledge:
- Advanced knowledge of MS Office applications, especially in excel and powerpoint
- Strong analytical and systematic approach to handling numbers, information and interpretation
- Proactive mindset with the ability to think end-to-end
- General knowledge in Micro and Macroeconomics
- Knowledge of database management and BI application is a plus
Qualification:
- Student of Business, Supply Chain, Economics, Finance or Information Technology
- Good organization and communication skills
- Strong English skills required
Internship regulations:
1. Student must be enrolled at the university for the complete duration of the internship
2. Duration of internship: 6 months full time commitment