Course Details
Topic 1: Understand Optimisation and Linear Programming Models
- Problem solving and decision making
- Process of Quantitative Analysis
- Structure of a Linear Programming model
- Graphical Solutions
- Special Cases
Topic 2: Use Excel Solver to solve LP Models
- Constructing Excel model
- Activating Excel Solver
- Solver Report Analysis
- Sensitivity Report Analysis
Topic 3: Formulate and solve Linear Programming Models
- Maximise media exposure through channel selection
- Maximise return on investment through portfolio management
- Maximise profit through component blending
- Maximise profit through workforce assignment
Topic 4: Formulate and solve Integer Linear Programming Models
- Maximise profit through selective production
- Maximise market share through new product features
- Maximise number of customers served through office location
- Minimise transportation cost through distribution system
Course Info
Promotion Code
Your will get 10% discount voucher for 2nd course onwards if you write us a Google review.
Minimum Entry Requirement
Knowledge and Skills
- Able to operate using computer functions
- Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)
Attitude
- Positive Learning Attitude
- Enthusiastic Learner
Experience
- Minimum of 1 year of working experience.
Target Age Group: 18-65 years old
Minimum Software/Hardware Requirement
Software:
TBD
Hardware: Window or Mac Laptops
Job Roles
- Operations Manager
- Project Manager
- Supply Chain Manager
- Resource Planner
- Production Manager
- Human Resources Manager
- Facilities Manager
- Logistics Coordinator
- Procurement Specialist
- Inventory Control Specialist
- Workforce Planning Analyst
- Capacity Planner
- Lean Operations Specialist
- Enterprise Resource Planning (ERP) Consultant
- Business Process Improvement Specialist.
Trainers
Dr. Alvin Ang: Dr. Alvin Ang is a ACTA certified trainer. Dr. Alvin Ang did his Ph.D., Masters and Bachelors from NTU, Singapore. Previously he was a Principal Consultant (Data Science) as well as an Assistant Professor. He was also 8 years SUSS adjunct lecturer. His focus and interest is in the area of real world data science. Though an operational researcher by study, his passion for practical applications outweigh his academic background. He owns a startup externally.
Liew Sing Loon: Liew Sing Loon is a ACTA certified trainer. Liew Sing Loon graduated from the National University of Singapore (NUS) in 1992 with a Second Upper Honors Degree in Electrical Engineering. He started his career as an Electronic Product Design Engineer for four years in a Multinational Company which sell the products worldwide. The job provided him practical knowledge in various aspects of manufacturing operations ranges from Design, Quality, Production and Procurement. He then spent fifteen years in Information Technology Sector as a Key Account Manager in selling IT solutions to Banking, Telecommunications and Government clients. The job provided him the opportunities to propose IT solutions, integrating software, hardware and services, to solve customers’ problems to achieve their strategic business objectives. He joint a German Product Test company to develop its business in providing product Safety, Immunity, Electromagnetic Compatibility (EMC) Certification test. While working in the industry, Liew Sing Loon obtained a Master of Science (MSc) in Technology Management from NUS.
In the last decade, Liew Sing Loon has been Adjunct Lecturer in several Institutes of high learning, transferring his knowledge on Quantitative & Statistical Analysis, Operations, Project & Quality Management to learners ranging from Diploma, full time undergraduates and working adults.Liew Sing Loon has a Certificate of Completion in Education Psychology Course and Teaching & Learning in Higher Education Program conducted by National Institute of Education (NIE).
Customer Reviews (2)
- will recommend Review by Course Participant/Trainee
-
1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment
Attending Dr. Ang's course was a truly enriching experience. His profound expertise in data, AI, and engineering was evident as he shared practical insights. Dr. Ang's teaching style, fueled by his genuine passion for data, not only piqued our curiosity but also motivated us to explore the subjects further. Beyond the specific topics he covered, I acquired valuable insights into other relevant skills and areas of development.
In summary, I am highly satisfied with the overall learning experience and wholeheartedly recommend Dr. Alvin Ang as an educator. (Posted on 11/29/2023) - will recommend Review by Course Participant/Trainee
-
1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment
Mr liew is an excellent trainer, very clear in explaining complex concepts. Very patient in answering questions. Great trainer (Posted on 5/27/2021)