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 [phone]
• MW 430-545pm Tue 245-545pm
• Online the Sunday night before exams in WebCT
  General Chatroom for BUS190

3
PREREQUISITES

• MATH 70 Finite Math
• BUS 90 Business Statistics
• Get 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 classhttp//www.3dma
  tinee.com/qbareader/
• Answer book for problem sets included as appendix
  in reader

5
TOPICS IN OR/MS OPERATIONS RESEARCH
andMANAGEMENT SCIENCE

• NETWORK MODELS MST, SR, CPM
• TRANSPORTATION MODELS
• LINEAR PROGRAMMING MODELS
• DECISION ANALYSIS risk neutral case(Risk
  Averse case offered in BUS 191)
• PERT method for stochastic Project analysis
• 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//sjsu.webct.com
• WebCT account
• UserID Student ID with W in front
• Password fall (can be reset)
• BUS 190 will be in your course list(notify me
  immediately if not)

10
WEBCT FEATURES

• Course Content
• Calendar
• eMail
• Bulletin Board
• Chat Room

11
BASIS FOR GRADE

• Four Projects
• 50 or 100 points each
• CPM Models Linear Programming
• Decision Analysis PERT Simulation
• Three Exams
• MidTerms 1 2 150 points each
• Final 250 points
• Extra Credit
• 10 URLS on OR/MS in use today (20 pts)
• 25 points per project for extended analysis

12
EXTRA CREDIT ADJUSTMENT FORMULA

• ST Semester point Total
• TP Total Possible points
• EC Extra Credit point total
• SA Adjusted Score
• SA TP(STEC)/(TPEC)
• SA computed in EXCEL not WebCT
• Computations done in Excel, does not show in WebCT

13
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

14
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
• Browse the web using search engines for extra
  credit points and related info