U We report under the Materials Department. Our main role is to establish the Media Demand Plan to support the Drive MS (Master Schedule). It involves translating the Drive MS qty into Media quantities by products to derive the overall RMO Demand Plan (RDP). Thereafter, the factory planners will use this RDP to work out what it\xe2\x80\x99s factory can produce to meet the RDP requirements, taking into consideration of all product\xe2\x80\x99s yields, machines/tooling & materials\xe2\x80\x99 constraints to establish the Master Production Schedule (MPS). Once the MPS is published, respective factory personnel are to execute per the MPS to ensure continuous supply of Media to meet Drive MS requirements. It is critical that Media Demands are correctly translated from the Drive MS Demand. As the planning files are using excel spreadsheets, we need enhancement to them for added checks & faster turnaround.
About the role - you will:
There are 3 projects aligned as follows:
Enhance the current tracker to improve consistency on the Media Supply for Adexa (DSD upload).
Develop a standard Media demand computation format for faster turn-around for the EBO/LRP process and what if scenarios
Enhance existing files with relevant linkages to \xe2\x80\x9cdata-source\xe2\x80\x9d to achieve shorter turn-around time
About you:
Good with numbers & analytically skills
Strong knowledge of Microsoft Excel software is essential as all planning templates are using excel spreadsheets.
Comfortable working with people to get the job done. Teamwork is essential.
Application knowledge on Microsoft programs is a MUST.
Your experience includes:
Create working templates using Microsoft Excel, involving link files, formulae, setting criteria, pivot tables, v-look up
Create tables, charts using Microsoft Excel
Create workflows using powerpoint
Document what have been done/improved to related planning files & share/hand-over to team members for continuity
Location:
Location: Woodlands, Singapore, W2 Travel: None
Beware of fraud agents! do not pay money to get a job
MNCJobz.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.