Description
Scope of Responsibilities/Expectations:- Spend/Savings monthly reporting (actuals & forecast)
- Prepare charts for monthly reporting
- Adhoc reporting for category team
- Provide Volume/Price/Mix analysis
- Track & manually move parts to ensure reporting is accurate
- Maintain accurate by-Commodity reporting
- Manually forecast parts not driven by Schedule Sharing
- Track top parts/products
- Validate base costs and make adjustments where appropriate
- Maintain family groupings for similar parts
- Validate forecast accuracy - volume, pricing, award share
- Identify suppliers/parts for negotiation
- Identify opportunity for savings through sourcing strategy
- Do what-if analysis to support various scenarios such as strategic pulls, future negotiations, etc
- Track price and receipt compliance; identify and pursue recoveries
- Monitor & drive compliance
- Ensure interlock (spend & savings)
- Establish by commodity targets using industry & historical data
- Ensure interlock with Category teams
- Load systems for monthly reporting/tracking
- Validate pricing files
- Drive negotiation calendar
- Load BOMs for component categories.
- Gather price/unit data and size claims
- Tie off with supplier on facts
- Work with CM or Buyer to obtain credit memo or issue RCA
- Load details into CRIS
- Interlock with Finance for savings reporting
Bachelors Degree required; Finance or Supply Chain Major
- CRIS, Oracle, SAP experience a plus
- Must have excellent Excel skills
- Microsoft Access/BrioQuery desirable