{"id":22952,"date":"2022-04-05T15:00:41","date_gmt":"2022-04-05T07:00:41","guid":{"rendered":"https:\/\/cde.nus.edu.sg\/isem\/?post_type=nus-news&#038;p=22952"},"modified":"2024-12-27T17:16:14","modified_gmt":"2024-12-27T09:16:14","slug":"optimization-workshop-at-annual-business-analytics-case-competition-2022","status":"publish","type":"nus-news","link":"https:\/\/cde.nus.edu.sg\/isem\/news\/optimization-workshop-at-annual-business-analytics-case-competition-2022\/","title":{"rendered":"Optimization Workshop at  Annual Business Analytics Case Competition 2022"},"content":{"rendered":"<p>Every year, our ISE student club organizes a business analytics case competition (BACC) for pre-university students and current engineering undergraduates. This year\u2019s competition (BACC 2022) was jointly organized with Micron. As part of the event, we (Napat and Chin Hon) were invited by the ISE club to conduct an optimization workshop for the participants. Optimization is concerned with finding the best decision\/policy that abides by a set of predetermined constraints. It has been used in various domains, such as engineering, economics, and healthcare. Many domestic and international companies have benefitted from using optimization one way or another. In this workshop, we gave several examples of practical \u201clinear\u201d optimization problems. We also looked at how to transform a non-linear problem into a linear one to emphasize the flexibility of this framework.<\/p>\n<figure id=\"attachment_22953\" aria-describedby=\"caption-attachment-22953\" style=\"width: 507px\" class=\"wp-caption alignleft\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-22953\" src=\"https:\/\/cde.nus.edu.sg\/isem\/wp-content\/uploads\/sites\/12\/2024\/04\/MS-excel-screenshot.jpg\" alt=\"\" width=\"507\" height=\"282\" srcset=\"https:\/\/cde.nus.edu.sg\/isem\/wp-content\/uploads\/sites\/12\/2024\/04\/MS-excel-screenshot.jpg 859w, https:\/\/cde.nus.edu.sg\/isem\/wp-content\/uploads\/sites\/12\/2024\/04\/MS-excel-screenshot-300x167.jpg 300w, https:\/\/cde.nus.edu.sg\/isem\/wp-content\/uploads\/sites\/12\/2024\/04\/MS-excel-screenshot-768x427.jpg 768w\" sizes=\"auto, (max-width: 507px) 100vw, 507px\" \/><figcaption id=\"caption-attachment-22953\" class=\"wp-caption-text\">Screenshot of MS Excel worksheet<\/figcaption><\/figure>\n<p>There are many optimization software out there. MS Excel Solver was selected for this workshop as most participants already have a working knowledge of MS Excel.<\/p>\n<p>We demonstrated how a linear optimization problem can be defined in MS Excel and solved using the Solver add-in programme.<\/p>\n<p>&nbsp;<\/p>\n<p>17 Mar 2022<\/p>\n<p>Dr Napat Rujeerapaiboon &amp; Dr Tan Chin Hon<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>The recordings of the workshop (12 Feb 2022) can be viewed below:<\/p>\n<div class=\"ast-oembed-container \" style=\"height: 100%;\"><iframe loading=\"lazy\" title=\"Introduction to Linear Optimization\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/YWDmmdIj3aQ?list=PL4WXmoZLWYEEslaZ1HnJEat-vIc8w0LYG\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/div>\n<p>&nbsp;<\/p>\n<div class=\"ast-oembed-container \" style=\"height: 100%;\"><iframe loading=\"lazy\" title=\"Optimization using MS Excel Solver\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/JIW0iNWlRCQ?list=PL4WXmoZLWYEEslaZ1HnJEat-vIc8w0LYG\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Every year, our ISE student club organizes a business analytics case competition (BACC) for pre-university students and current engineering undergraduates. This year\u2019s competition (BACC 2022) was jointly organized with Micron. As part of the event, we (Napat and Chin Hon) were invited by the ISE club to conduct an optimization workshop for the participants. Optimization<\/p>\n","protected":false},"author":26,"featured_media":22957,"parent":0,"menu_order":0,"template":"","meta":{"_acf_changed":false,"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"footnotes":""},"news_category":[],"class_list":["post-22952","nus-news","type-nus-news","status-publish","has-post-thumbnail","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/cde.nus.edu.sg\/isem\/wp-json\/wp\/v2\/news\/22952","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cde.nus.edu.sg\/isem\/wp-json\/wp\/v2\/news"}],"about":[{"href":"https:\/\/cde.nus.edu.sg\/isem\/wp-json\/wp\/v2\/types\/nus-news"}],"author":[{"embeddable":true,"href":"https:\/\/cde.nus.edu.sg\/isem\/wp-json\/wp\/v2\/users\/26"}],"version-history":[{"count":4,"href":"https:\/\/cde.nus.edu.sg\/isem\/wp-json\/wp\/v2\/news\/22952\/revisions"}],"predecessor-version":[{"id":23766,"href":"https:\/\/cde.nus.edu.sg\/isem\/wp-json\/wp\/v2\/news\/22952\/revisions\/23766"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cde.nus.edu.sg\/isem\/wp-json\/wp\/v2\/media\/22957"}],"wp:attachment":[{"href":"https:\/\/cde.nus.edu.sg\/isem\/wp-json\/wp\/v2\/media?parent=22952"}],"wp:term":[{"taxonomy":"news_category","embeddable":true,"href":"https:\/\/cde.nus.edu.sg\/isem\/wp-json\/wp\/v2\/news_category?post=22952"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}