Commercial Reporting Admin (Manufacturing) | AU | WFH
National Capital Region - Philippines
Job Summary
- Monitor and report on key commercial activities and customer requirements
- Track whether customers have placed their required monthly orders
- Pull and analyze data relating to product lead-time performance
- Assist with regular and ad-hoc commercial reports and forecasts
- Maintain accurate commercial records and reporting information
- Identify outstanding actions discrepancies or issues and follow up with relevant stakeholders
- Coordinate daily and weekly cost change activities that are not development dependent
- Manage customer-specific cost change requirements including:
- DHS / ECI / ECR TMCA
- CRQ Ford
- Maintain and update relevant EGR systems including:
- CR System Intranet
- CCS Teamcenter
- Assist with resolving discrepancies between customer purchase order pricing and QAD pricing
- Coordinate updates to price lists and pricing books where required
- Assist with ad-hoc customer pricing update requests
- Assist with end-to-end commercial requirements for customer programs
- Liaise with Product Development regarding:
- Development progress
- SIS dates and date changes
- Cost changes
- Timing plans
- Participate in relevant customer and internal meetings as required
- Track commercial actions and follow up to ensure requirements are completed within agreed timelines
- Provide commercial administration support for new program launches
- Coordinate IOQ/Purchase Order requests from customers
- Ensure pricing is accurate and established correctly at the commencement of new programs
- Assist with forecast and safety stock settings for new parts
- Coordinate safety stock revisions and status changes for replacement or superseded parts
- Assist with maintaining item-level information including model codes and model year ranges
- Assist with monthly tooling cost recovery activities
- Manage customer-specific tooling cost recovery requirements including:
- DV TMCA
- Cost Break Downs Client A / Client B / Client C
- Coordinate tooling-related RFQs through Teamcenter
- Prepare and submit invoice requests using the relevant internal processes
- Monitor outstanding tooling cost recovery and follow up as required
- Support weekly and monthly cost recovery activities as required
- Coordinate air freight requests and courier approvals
- Obtain customer purchase orders for applicable costs
- Track freight invoices with Finance
- Prepare and submit invoice requests
- Submit invoices to customers and monitor outstanding payments
- Assist Finance and Accounts Receivable with customer follow-ups where funding or payment is overdue
- Investigate and assist with resolving payment and pricing discrepancies
- Support the resolution of customer account and invoicing issues
- Assist with new customer account setup in conjunction with Finance including credit account requirements
- Provide ongoing administrative support to the OEM Sales team
- Assist with customer forecasts and obtain updated forecasts from customers
- Support contract and supplier agreement facilitation
- Assist with:
- Obsolescence claims
- Parts retirement
- All-Time Buy reviews
- Requoting for out-of-production parts
- MOQ management
- Orders below MOQ
- Requoting for orders below MOQ
- Assist with regular and ad-hoc margin reviews
- Support annual price increase and pricing review activities
- Assist with reviews of tool condition and coordinate funding requirements for repairs or rebuilds
- Assist internal teams and customers with product availability enquiries
- Provide information relating to:
- Product lead times
- Customer order requirements
- MOQs
- Acceptance of orders below MOQ
- Provide general customer service support including identifying appropriate OEM contacts and assisting with
- customer enquiries relating to matters such as warranty processes
- Bachelors degree in Business Administration Commerce Accounting Finance Operations Management Supply Chain Management Industrial Engineering or a related field.
- Strong sales reporting and data analytics experience.
- Previous experience in commercial administration sales administration reporting finance or a similar role is highly desirable.
- Strong Excel and data analysis skills.
- Strong attention to detail and ability to manage multiple priorities.
- Experience in a manufacturing automotive OEM or similar environment.
- HMO Dental and Life Insurance for you and one free dependent from day one (with the option to enroll additional dependents).
- Paid Leaves: Birthday Vacation Medical and Maternity (up to 6 Vacation Leaves are convertible to cash on your anniversary).
- Employee Engagement Activities: Year-End Party Family Day Team Building and more!.
Required Skills:
What You Bring Were looking for someone with: Bachelors degree in Business Administration Commerce Accounting Finance Operations Management Supply Chain Management Industrial Engineering or a related field. Strong sales reporting and data analytics experience. Previous experience in commercial administration sales administration reporting finance or a similar role is highly desirable. Strong Excel and data analysis skills. Strong attention to detail and ability to manage multiple priorities. Experience in a manufacturing automotive OEM or similar environment.