Material Department Intern Media Planning

Singapore, Singapore

Job Description




About our group:


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.


Job Detail

  • Job Id
    JD1256116
  • Industry
    Not mentioned
  • Total Positions
    1
  • Job Type:
    Full Time
  • Salary:
    Not mentioned
  • Employment Status
    Permanent
  • Job Location
    Singapore, Singapore
  • Education
    Not mentioned