BUS 190: QUANTITATIVE BUSINESS ANALYSIS Dr. Ron Davis

1
BUS 190 QUANTITATIVE BUSINESS ANALYSISDr. Ron
Davis

• BT 762 408-924-3547
• davis_r_at_cob.sjsu.edu
• www.cob.sjsu.edu/facstaff/davis_r/
• ron_at_mathproservices.com
• www.mathproservices.com

2
Office Hours

• BT 762
• MW 430-530pm
• Tue 230-630pm
• 408-924-3547
• Online the night before exams in WebCT General
  Chatroom for BUS190

3
PREREQUISITES

• MATH 70 FINITE MATH
• BUS 90 Business Statistics
• Equivalency Forms Signed

4
REFERENCE TEXT

• MANAGEMENT SCIENCE READER for QBA
• Online at http//www.cob.sjsu.edu/facstaff/davis_r
  /courses/qbareader/QBAtoc.html
• Order online for delivery in class
• Answer book for problem sets available as
  appendix in reader

5
TOPICS IN OR/MS OPERATIONS RESEARCH
andMANAGEMENT SCIENCE

• NETWORK MODELS
• CPM method for deterministic Project analysis
• LINEAR PROGRAMMING MODELS
• PERT method for stochastic Project analysis
• Continuous Probability Distributions
• PERT SIMULATION using MONTE CARLO

6
COMPUTER TOOLS

• EXCEL SPREADSHEET FUNCTIONS
• SUMPRODUCT(coef_array,variable_array)
• RAND() random number generator (uniform)
• NORMDIST(x,mean,standard_deviation,TRUE)
• NORMINV(p,mean,standard_deviation)
• BETADIST(x,alpha,beta,Amin,Bmax)
• BETAINV(p,alpha,beta,Amin,Bmax)

7
COMPUTER TOOLS

• EXCEL SPREADSHEET ADD-INS
• Data Analysis ToolPak
• Descriptive Statistics Report
• Histogram Report
• SOLVER
• Answer Report
• Sensitivity Report

8
Adding in the ADD-INS

• Click on Tools/Add-ins
• Check Analysis Toolpak
• Check Analysis Toolpak VBA
• Check SOLVER
• Click on OK
• Do incremental install from CD-ROM if any of
  these is missing from the list

9
WebCT WEB Course Technology

• http//courses5.webct.com
• Set up own WebCT account
• Choose own UserID/Password
• Use it immediately to enter course area
• Add BUS 190 to your course list
• Use given CourseID/Password
• First 3(2) Letters of last name (all caps) Last
  3(4) Digits of Student ID

10
BASIS FOR GRADE

• Three Projects
• 100 points each
• Three Exams
• 2 Midterms 150 points each
• Final 250 points
• Extra Credit
• 10 URLS on OR/MS in use today
• 25 points per project

11
EXTRA CREDIT ADJUSTMENT FORMULA

• ST Semester point Total
• EC Extra Credit point total
• SA Adjusted Score
• SA 850(STEC)/(850EC)
• SA computed in EXCEL not WebCT

12
EXAM RULES

• CHEAT SHEETS ALLOWED
• One page notes each midterm
• Three pages for the final
• CHEATING NOT ALLOWED
• No talking until you leave the room
• No passing of papers back and forth
• No copying of answers from neighbor
• Sharing of points for identical answers

13
HINTS FOR YOUR SUCCESS

• Use a three ring notebook binder
• Print stuff from the web
• Punch holes in your printout and store in your
  three ring binder
• Work all the practice problems
• Buy the answer book for the reader
• Browse the web using search engines for extra
  credit points and related info