Prerequisites: Junior Standing; minimum grade of "C-" in SCMG 332 or SCMG 332H or SCMG 232 or SCMG 232H; INFS 247 or INFS 247H; ISSCM 241 or ISSCM 241H or STAT 103.
This course studies various analytical methods and tools for making decisions that will lead to cost effective products, services and processes. Topics include developing decision-making optimization models and implementing those models in Excel. The course will highlight models used in supply chain management; including facility location, transportation network design and vehicle routing.
Outcomes: Students will develop an understanding of optimization modeling, implementing optimization models in Excel and problem-solving techniques; Students will learn how to build and solve decision-making optimization and simulation models in Excel to develop skills in spreadsheet modeling/optimization/engineering.
This course studies various analytical methods and tools for making decisions that will lead to cost effective products, services and processes. Topics include developing decision-making optimization models and implementing those models in Excel. The course will highlight models used in supply chain management; including facility location, transportation network design and vehicle routing.
Outcomes: Students will develop an understanding of optimization modeling, implementing optimization models in Excel and problem-solving techniques; Students will learn how to build and solve decision-making optimization and simulation models in Excel to develop skills in spreadsheet modeling/optimization/engineering.