Management Science in Spreadsheets
MGT 574
Course Description:
Uses Microsoft Excel 2007 to demonstrate optimization modeling (linear, 0-1, and nonlinear programming) and simulation of financial and operations problems. Financial applications include portfolio optimization, short-term cash flow planning, capital budgeting, branch-bank site location, and arbitrage models. Operations applications include aggregate production planning, supply chain optimization, facility location, personnel scheduling, and production scheduling with setup costs. We will do virtually all work in Excel, learning how to use Excel?s features to gain insights into common business problems. Advanced features of Excel, including pivot tables, data tables, form controls, filters, charts, text worksheet functions, subtotals, and efficient downloading of data from the internet, are covered. Prerequisite: A knowledge of Excel fundamentals, such as the SUM, MIN, MAX, and AVERAGE functions, copying and pasting formulas with relative and absolute cell references (such as $A$1), and formatting the number of decimal places in data cells. A test is available from the instructor to determine whether students will be able to keep up with the class. A tutorial is available for those wanting to improve their skills.
2 Credit(s)
Faculty:
- Larry LeBlanc (View Profile)
Subject Area(s):
- Operations Management
Program(s):
- MBA
- MS Finance
Please Note: Not all courses are scheduled each semester. Complete class schedules are available upon enrollment.
