The following course contents are created to assist your learning of COB291, Management Science.  The materials include most of the lecture notes, stream videos for most of the topics, audio recordings and mp3 files for some of the contents as well.:

(Thanks Cydney Fox for providing these) Here are some of the commands to use with excel for Mac's:
To change the calculations to manual, you go to Excel at the top left hand corner, and thenPreferences, then click on calculation and then manual. 
The F4 key on an Mac is Command "T"
The F9 key on a Mac is Command "+="

This list has the course materials for Introduction to Management Science Course, most in either pdf or video format.  Here is the link for most of solutions of HW problems.

Course Materials: Previous tests and solutions and others
pdf video Content Title and Web Link Author Descriptioin
  v  JMU Blackboard Acces Ping Wang How to access JMU Blackboard.  Due to system upgrades, some of the contents may be out of date.
pdf v Course Syllabus & Video Ping Wang COB 291 Course
  v Goal and Analytic skills (4 mins) Ping Wang Show the opportunity cost to delay graduate for one more semester
 
Excel Skills
  v Excel Tutorials Ping Wang How to use Excel Frequency, RN, Bar Chart, Line Chart, Scatter Plot, Histogram, Polygon, Pareto Diagram
  v Tableau and Graphs Snarrinstitute Use Excel to create tables and graphs.
  v Basic Excel skills robertbobm Basic Excel skills and use of Excel formulas
  v Atomic Learning JMU Many short videos for basic use of Excel
 
  v Chapter 1 (5 mins) Ping Wang Ragsdale text Introduction to Management Science and Business Analytics
 
Breakeven analysis:
  v Breakeven Part S Step 1 Ping Wang Breakeven analysis: basic procedure and set up Excel to find out the units to make
  v Two Breakeven Part S Step 2 Ping Wang Breakeven analysis: Goal seek, one and two way tables, line charts
pdf   Breakeven Analysis PQ Problem Ping Wang Screen shots of One and Two Way Tables, Goal Seek and Line Chart
pdf   Part S Breakeven on One page and  Excel formulas. Ping Wang  Print the Breakeven analysis results on One page and another page for formula views
         
  v Basic Breakeven concepts (6 mins)  Cameron  
  v Basic Breakeven concepts(2.5 mins) About.com  
  v Excel Goal Seeks (4 mins) Danny Rocks Breakeven by with four scenarios
  v Scenario analysis  (4 mins) Plumsolution.com, very brief
  v Excel Data Table(5 mins) and Chart 3 (mins) IntroToOM for Breakeven analysis
links   probability and statistics for business   useful web links
Probability Reviews:
pdf   Worryson P-Review: answers Ping Wang  Solutions for Worryson example as review of concepts of prior, conditional, joint, and posterior probabilities
pdf   DecisionNoteT1F08.pdf Ping Wang  Detailed answers for Decision Analysis portion on Test 1 in Fall 2008.  Example of Buyers vs. Identified Buyers and compute posterior probabilities, and so on, and the ice cream example for Decision Tree portion
pdf v DukeFun: P-Review (5 mins) Ping Wang Use DukeFun example from Test 1 F08 to briefly review concepts of prior, conditional, joint and posterior probabilities. Here is the DecisionNoteT1F08.pdf handwritten class notes
  v DukeFun: P-Review (17 mins) Ping Wang The same DukeFun example, just in more details and notes in typed format. DecisionNotesT1F08Long.pdf -- a longer version of T1F08 Ice Cream example
pdf   Test 1 in Summer 2008 Ping Wang Detailed solution for Decision Analysis Portion of the Test
pdf   DecisionNotesF08T1Long.pdf Ping Wang Detailed answers for Fall 08 Test with an example of a vendor faced decision to sell either ice cream or soft drinks on Game days.
  v Basic Probabilities in Lecture 1 Snarrinstitute basic probability concepts from Snarrinstitute website.
  v Basic Probabilities in lecture 2 Snarrinstitute basic probability concepts from Snarrinstitute website.
         
Decision Analysis:
Excel   treeplan.xla or current version   This link has the current version of the Excel@ add ins for drawing Decision Trees with PCs and MACs. 30 days free trial.
  v Excel for DecisionTree (10mins) Ping Wang Use Treeplan.xla to draw Decision Trees in Excel
  v DecisionSA.html (11:39 min)   Ping Wang Use Excel@ Data/What If/Data Table for Sensitivity Analysis in Decision Analysis. It also shows the use of Payoff Tables.
  v install, one way Table/chart, EMV, EVwPI, EVwSI  (10 mins) Ping Wang Install treeplan.xla (PC version), prepare and do One-way Table/draw line chart, simple EMV tree, EVwPI tree, and EVwSI tree
  v Treeplan installation (3.45mins)   How to install treeplan
  v Decision tree (7 mins) MBABullShitDotCom  How to manually draw decision tree
  v DecisionT1F08 (37 mins) Ping Wang Second part of DecisionNotesT1F08.pdf.  These two videos show how to compute MV, EVwPI, EVwoPI, EVPI, EVwSI, EVwoSI, EVSI, and Efficiency using the ice cream versus soft drinks example.
pdf   LectureDecisionhandout Ping Wang Examples of the airport land purchase, Colonial Motors, Grant Proposal , IPod and Cancer.  The documents also show the concepts of EVwoPI, EVPI, EVwSI, EVwoSI, EVSI, Efficiency, Payoff tables, Decision Trees, Excel@ Data/What If/Data Table in sensitivity analysis. LectureDecison.xlsx. shows how to compute posterior probabilities,  MaxiMAX, MiniMAX, MaxiMIN, EMV, EVwPI, and so on.
Excel   LectureDecison.xlsx Ping Wang Most of the Excel worksheets for Probability and Decision analysis

 

Linear Programming formulations, sensitivity analysis and integer LP for various Business applications
pdf video Content Title and Web Link Author Descriptioin  
    PremSolv for Windows   Use "for Education" when download  
    PremSolv PC and Mac   Current versions for both PC and Mac  
  v Algebra Review (30 mins) Ping Wang Simple MAX and MIN LP Graphic Solutions with pdf Algebra reviews & LP Graphic  
           
pdf   Algebra reviews & LP Graphic Ping Wang Review for algebra and LP graphic solutions and Video Algebra Review (30 mins)  
  v LP graphic solution (26 mins) Ping Wang Min and Max and Excel Solver for pdf LP Graphic solution & use of Solver.  
  v LP Graphics.html (60 mins) Ping Wang LP Graphic Solutions and use of Excel Solver, the longer version of LP Graphic & Solver.  
pdf   LP Graphic & Solver Ping Wang Max: 50X+40Y, Min:10X + 20Y, LP graphic solution and screen shots of use of Excel Solver and its video LP graphic solution (26 mins), and the one LP Graphics.html (60 mins)  
pdf   SA Min(Max) 50X+40Y+ 35Z Ping Wang SA summary for Min (Max) 50X+40Y+35Z of lecture for sensitivity analysis with Solver Answer and Sensitivity Reports  
pdf   LP SA Notes (16 pages) Ping Wang The typed ppt for detailed LP SA go with the videos below  
  v LPSA.pptx(2).html (50 mins) Ping Wang Lectures with LP SA Notes to cover LP SA  
  v
 LPSALecture2.html (48 mins) Ping Wang Might be the same lectures with LP SA Notes to cover LP SA, different class  
pdf   LP Graphics -10X+20Y & SA notes Ping Wang  Min: -10X + 20Y, *** very detailed handwritten lecture notes, concise and complete for LP Graphics and SA  
pdf   LP Graphics 50X + 40Y Ping Wang Max: 50X + 40Y, One page handwritten lecture notes.  
pdf   LP sensitivity analysis Ping Wang Max: 50X + 40Y, SA, and Screen shots of using Solver  
pdf   LP model Blending (Ore) Ping Wang Min 90 R1 + 120 R2 the example from the Text  
pdf   LP Applications Ping Wang Potential business applications for LP modeling, optimization, and analytics  
  v  Sensitivity analysis by Martin,      
  v LP solution MyTutorZone   In Excel  
  v Use of Solve Part I Tallys Yunes in Excel  
  v Use of Solver Part II Tallys Yunes in Excel  
  v LP Word problems vy PatrickJMT PatrickJMT    
  v LP Graphcs      
  v  minimize y = 4x + 2y,      
  v  LP Formulation by KornCast teachertubemath    
  v LP graphic solution by Preston Preston    
           
  v Inventory and Cash Flow  (67mins) Ping Wang Formulating LP inventory and cash flow problem  
pdf   LP Model Notes updated Part I and Part II
LP modeling lecture notes (This is part of Parts I and II above)		 Ping Wang Class notes for LP formulations for Product Mix with additional constraints, Make or Buy, Investment, Transportation, Blending, Multi period production and inventory planning (all in Part I), and multi period cash flow (Part II) problems.  Some of the Excel Solver solutions are also included.  
  mp3 LP formulation lectures Ping Wang mp3 audio for LP formulations with the lectures of LP modeling lecture notes  
pdf   Integer LP Ping Wang *** Class notes for ILP formulation include: Product mix, Employee scheduling, Capital budgeting problems.  
  v ILP.html (70 mins) Ping Wang Video from classes for ILP formulation include: Product mix, Employee scheduling, Capital budgeting problems.  
docx    LP SA Lecture Example Ping Wang LP sensitivity analysis lecture notes MAX: 50X + 40Y  
    Mutiperiod cash flow Grayson    
     Mutiperiod cash flow  slideserve    
           
Queuing or Waiting Line Analysis:  
  v Queue lecture Ping Wang JMU Bookstore pages 73 - 79 as in JMU Bookstore or LectureQueue.pdf  
pdf   QueueSummary Ping Wang two pages to  summarize major concepts in queuing models: Arrival/Serivce/Servers.  
pdf   JMU Bookstore, Ping Wang LectureQueue.pdf JMU Bookstore, 75-79 are for s >=2.  
  xlsx Queue.xlsx Ping Wang examples used in classes.  
  xlsx Q.xls   Excel template for  M/M/s, G/G/s and other models ---- the Excel Add-ins for solving Queuing or waiting line applications  
pdf   msPack5QueueF8T2    and add some details in lecture  
  v LectureQueueT2F08.htm (40 mins)   video JMU Health Center from LectureQueueT2F08.pdf to cover POISSION and EXPONENTIAL distributions, and M/M/1 and M/M/s queuing models.  
pdf   QueuingHandout.pdf    questions in JMU Bookstore example, but no answers.  
  v Queue.html (65 mins)   is the video made during class with QueuingHandout.pdf and LectureQueue.pdf, to.cover the same contents as LectureQueueT2F08.htm with different examples or applications, except, queue.html also covers M/G/s queue at the very end.  
  v     Yourtube videos on queueing models: by IIT basic intro, single server queue, multiple server queue,  
           
Simulation  
pdf   Visio-SIMChart.pdf  

one page summary

 
  v SIM.htm (31 mins):   SIM Lecture.pdf.  
  xls simlec.xls   short examples to use  =VLOOKUP(), =NORMINV(), =IF(), =MIN(), =MAX(), =AVERAGE(), =COUNTIF() and MonteCarlito.  
pdf   SIM Lecture.pdf 29 pages      business logics, inventory and queuing.  
    Simulation models:    detailed examples and answers in inventory and queuing.  
  v sim2.html (59 mins)    video of class in fall 08, based on Simulation models. Simulation lecture recording at http://cob.jmu.edu/wangpx/kj/cob291vd/sim2/sim2.html  
  xls LectureSIM.xlsx    examples used in lecture SIM Lecture.pdf and Simulation models  
pdf   Simulation Handout:    abbreviated version of Simulation models  
        Two mp3 files are on Blackboard/Course Documents/Lecture Notes/Simulation.  
pdf   Required Supplemental readings   Covered simulations of inventory and waiting lines  
  xls MonteCarlito_v1_05.xls
or Newer version		   at http://www.montecarlito.com/---- Excel Add-ins to computer the grand mean and standard error, and proportion in simulations.  You may google to find whether there is a MAC version or it may work just fine on MAC. Let me know please.  
  v Yourtube videos    on simulation: by NTSA intro modeling and simulation,  
           
Regression in Forecasting:  Please note, some of the materials may not be covered in your class, so you may omit them.  
  v Advertising expenditure and sales example   http://cob.jmu.edu/wangpx/kj/cob291vd/Regression.swf. Advertising expenditure and sales example for using regression  
  v Using Excel =Trend() for one and two variables forecasting   http://cob.jmu.edu/wangpx/kj/cob291vd/RegTrend.swf.  Use Excel Trend () and b0+b1*adv for one independent variable only, and use Trend () and b0+b1*adv+b2*month for more than one variables to forecas  
  v Excel for Regression   Use Excel b0+b1*month +b2*adv to forecast at http://cob.jmu.edu/wangpx/kj/cob291vd/RegTrend2.swf.  
        mps audio for Regression is also available on Blackboard/Course Documents/Lecture Notes/Regression/Regression Lecture  
pdf   LectureRegression.pdf    regression, linear models, equations, hypothesis test for slope and intercept with p-values, confidence intervals, and select right models in multiple regression application  
  v Regression.swf (10 mins)     use Data/Data analysis/Regression to get Summary Output tables  
  xls LectureRegression.xls   RegT1P1F08xls  Using Excel for Regression, sample test Fall 2008  
pdf   RegressionNotesSpr09.pdf    hand written regression lecture with car sales versus week and interest rates  
  v RegTrend2.swf (3 mins)   use Excel@ for more of regression, including more on =TREND()  
    Regression 2      
  v     Simple regression lecture 1, lecture 2, lecture 3 (r2), lecture 4 (sy), Hypothesis test for regression , multiple regression 1, spec, estimate, more, Excel output, Hy test, normality, significance by Snarrinstitute  
  v     Regression in Excel by Snarrinstitute: lecture 1/7. lecture 2/7, lecture 3/7, lecture 4/7, lecture 5/7 test normality, lecture 6/7 test autocorrelation, lecture 7/7 hypothesis test,  
Forecasting  
  v Exponential Forecasting
with Excel Solver		   http://cob.jmu.edu/wangpx/kj/cob291vd//EXPwSolver.swf using Excel to so Exponential smoothing  
  v Forecasting Methods   http://cob.jmu.edu/wangpx/kj/cob291vd/Fcst1.swf. using Excel to do moving average and other simple forecasting  
  v Weighted Moving Average   http://cob.jmu.edu/wangpx/kj/cob291vd/WMAwSolver.swf using Excel to do weighted moving average  
        mp3 file go with forecasting lecture notes also on Blackboard/Course Documents/Lecture Notes/Forecasting.  
pdf   FcstLecture.pdf   page 1 of the 19 pages - lecture summary of forecasting  
  v Fcst1.swf (12 mins)   to cover ExcelTutor291.xls:  Forecast, Regression and Use of Solver  
  xls ExcelTutor291.xls   Excel tutorial for using SMA, WMA, EXP,  =SUMPRODUCT(), =AVERAGE(), =STDEV(), and =COUNT()  
pdf xls Forecast 1 Problems / xls /answers   first part of FcstNotesSpr09.pdf.  
  v WMAwSolver.swf (3 mins)  

to find optimal weights with Excel Solver =SUMPRODUCT() for WMA,  =SUMXMY2()/COUNT() for MSE

  
pdf   Forecast 2 Problem   second part of FcstNotesSpr09.pdf.  
  v EXPwSolver.swf (3 mins)  

to use Excel@ to find optimal alpha (α) =SUMXMY2()/COUNT() for MSE

  
pdf   FcstNotesSpr09.pdf   Cars sold in T1F08 and Speeding Tickets in T1Sum08 with hand written and Excel solutions  
pdf   FcstLecture.pdf -  
  • 19 pages: SMA, WMA, EXP, MAD/MAE, MAPE, SSE, MSE, =SUMPRODUCT(), =SUMXMY2()/COUNT()
  • Regression, Use of Solver to find optimal weights and alpha, etc.