Spring 2007

 

CIS331: INTRODUCTION TO MATHEMATICAL MODELLING IN MANAGEMENT SCIENCE

 

Instructor:

 

Robert Zimmer:

         Wednesdays 12-1 and Thursdays 6-7

 

 

Course Text Book:

 

Winston and Albright:

Spreadsheet Modeling and Applications: Essentials of Practical Management Science  

Online Shops

 

 

 

 

Other Resources

 

Some Online Excel Tutorials

 

http://www.usd.edu/trio/tut/excel/

 

http://www.quasar.ualberta.ca/edit202/tutorial/spreadsheet/ExcelBasics/ExcelBasics.htm

 

http://www.quasar.ualberta.ca/edit202/tutorial/spreadsheet/RDC-exceltips/exceltips.html

 

(The last is particularly about relative and absolute addresses in formulae)

 

More to come

 

Lectures

 

Week

Date

Topics

Slides

Printable

Slides

Pages in Text

1

11 January

Introduction to Modelling in Spreadsheets

    Profit = Revenue – Cost,

    linear models of Cost

Lecture1

Lecture1 Printable

Pages 1-25

2

18 January

 

Lecture2

Lecture2 Printable

 Pages 26-37

3

25 January

 Cancelled

 

 

 

4

1 February

Review, plus uncertainty

Recap Lecture

Recap Lecture Printable

 Pages 38-50

5

8 February

 Optimisation, Linear Programming Basics,

Lines, inequalities, feasible regions

Lecture3

Lecture3 Printable

 Pages 58-78

6

12 February

 Linear Programming Models

Lecture4

Lecture4 Printable

 

7

22 February

 Linear Programming Models Continued

 

 

 

8

1 March

 Network Models

Lecture5

Lecture5 Printable

 Pages 185-204

9

8 March

 Network Models: Theory

Write-up to follow

 

 

10

15 March

 Network Models in Spreadsheets

Lecture6

Lecture5 Printable

 Pages 205-241

11

22 March

 Review

 

 

 

 

 

Labs

Week

Date

Topics

Labsheet

Pages in Text

1

11 January

Review of Spreadsheets

Lab 1

 

2

18 January

 

Lab 2

Pages 1-25

3

25 January

 

 

 

4

1 February

 

 

 

5

8 February

 

Lab 4

 

6

15 February

Coursework One

 

 

7

22 February

 

 

 

8

1 March

 

 

 

9

8 March

 

 

 

10

15 March

 

 

 

11

22 March

 

 

 

 

 

 

Assignments

 

Assignment 1: Due on 1 March

 

Optional Assignment 2: You may hand in your solutions to the sample exam paper before the review session on 3 May as an optional second assignment.

 

 

Course Software

 

            You will need to install TableSolver  (a zipped setup file is at TableSolver)

 

            You may need to install Solver. This is part of Office and you may need to go back to your office installation CD and install the feature.

 

           Then in Excel you will need to tick both SolverTable

 

 

Exam Preparation

 

You should familiarise yourself with the topics laid out in :

 

Revision Sheet:

 

And attempt to do the  

           

Sample Paper:

 

            Before the review session on 3 May,