Specific Duties and Responsibilities:
Revenue Analysis & Reporting
- Responsible for design & generation of regular sales reports such as but not limited to:
- Daily Sales Dashboard
- Monthly Sales Report
- Detailed Sales Variance Analysis
- Sales & Gross Margin Analysis
- Sales Monthly Trend
- Generation of special purpose reports such:
- TM Concrete Sales, Volume & Margin Report
- TM Industry Sales & Margin Report
- Cross-Selling Report
- Key Project Management Reports
- Generation of special or adhoc reports or data request coming from Sales Group Heads, TM, Finance and GM for purpose of monthly business reviews, regional reporting, customer reviews, special projects progress reporting.
- Drive data collation and synthesis of budgeting, forecasting and all kinds of forward- looking revenue & margin projections such as:
- Sales Bridge (Weekly & Monthly Sales Plan, Actuals & Forecast)
- 12 Month - Rolling Forecast
- Annual Sales Budgeting Files
- Seasonal Sales Projections Exercise
- Special Purpose Projections (e.g. for RPA input)
- Analytical calculations for purpose deriving conclusion on trends and behavior of revenue and margin in relation to customer, product, volume, segments, sections and other slices of data as the situation demands.
- Regularly interacts and coordinate with different sales & marketing group for purpose of getting insights on relevant reports as well as giving guidance on how to accomplish various budgeting, forecasting and analysis templates.
Pricing Generation and Maintenance
- To facilitate the annual pricing review exercise (SMP/SRP Review) by:
- Collate relevant financial data for historical references such average prices, discounts, costs, margins, and volume
- Gather inputs from sales and marketing group in terms of target price, competitor’s prices, volume projections, data outliers (i.e. product promotions)
- Gather inputs from costing and inventory officer for product costing, inventory information, product lifecycle, SLOB considerations, critical costing assumptions.
- Provide a working template to synthesize all relevant reference, inputs and calculation in aid of pricing decision-making.
- To manage end to end pricing requests (SMP/SRP request) in terms of accuracy, timeliness and completeness, going through the required inputs from relevant department or personnel.
- To generate control and monitoring pricing reports such as price effect reports, pricing initiatives progress reports, price waterfall analysis and other pricing analytics.
- To maintain and keep updated all types of pricing records in different systems such as but not limited to Microsoft AX (including Trade Agreements), Salesforce Pricebook, Pricelists (Broadcasted Internal & External).
- To maintain and keep updated database of competitors equivalent products and prices periodically for purpose of providing supporting assumption on price positioning.
- To provide insights and feedback to pricing committee in terms of pricing suggestions, pricing issues, price improvements and price competitiveness.