QTM1300 Summer I  2000

 Quantitative Methods with Calculus

Topical Outline

Course Overview

For direct access to this page, the URL is  http://roger.babson.edu/aieta/qtm1300/topics.htm.   Check this topical outline periodically for modifications or updates. You will also be able to  access this page from  http://ecampus.babson.edu , known as the electronic campus or  just  e-campus.  
     The Excel Center is an excellent resource for learning or reviewing Excel.


Official Source of Course Activities  has a Light Green Background

 

 Code:     B =  Build Model      M = Manipulate/Modify Model      R = Read and Reflect       S =  Solve and Interpret

Topical Strand

 Readings / Exercises   
(in MS Word)

Core Reference Files
(Excel & PowerPoint)

Support / Practice 

Projects
LINEAR FUNCTIONS

forms for two-variable linear equations

linear depreciation

break-even functions 
 (manufacturer's perspective)
  S Linear_act_01
  


 M Linear_Depreciation.xls

 M Break-even Quantity.xls

 B Break-even1.xls   
   See Break-even1.ppt

 B Break-even2.xls
   See Break-even2.ppt

 B Break-even3.xls
   See Break-even3.ppt
 M Gen_Linear .xls







  S Linear1.xls

  S Linear2.xls

  S Linear3.xls
 
piecewise linear functions


  S Linear_act_02    S Piecewise.xls

Ebay pricing decisions 
LINEAR SYSTEMS:

equations and inequalities
in two variables

  S Linear_systems		  
 
 R Linear_systems.ppt
 
 S Solving_linear_system.xls		  
LINEAR OPTIMIZATION
(LINEAR PROGRAMMING)

iso-value lines and the graphical solution for two-variable linear programming problems
 


 S LP_Act_1

 S LP_Act_2

  

 M Burgers&fries_1.xls

 M Machines.xls
 R  Intro_LP.ppt



 M Diskettes.xls




 

using Excel's Solver in  linear programming

 S LP_Act_3

 S LP_Act_4

 B Burgers&fries_2.xls   
    See Solver_LP.ppt  
 
 S Plywood.xls





 

Fast Food Nutrition
TIME VALUE of MONEY

growth of money under simple and compound interest, effective rate, continuous compounding

 R Finance Part I
 S TVM_Act_1

 S TVM_Act_2

 S TVM_Act_3

 

   
 M Single Payment.xls 
 R TI_BA_II+   
      financial calculator
 
   TI - 83 Finance 


  S Review Part 1

  

 

 
 
solving annuity problems:
future value and present value, amortization tables

 R Finance Part 2		  

 S TVM_Act_4

 
 S  TVM_Act_5


 S TVM_Act_6

 

  

 M  Annuities.xls










  S Review Part 2

 





 

 

 

Bonds
 CURVE FITTING:

finding the line of best fit by the method of least squares,

fitting trend lines to data --- polynomials, exponential and logistic functions
 R  t-shirt_business


 S  Poly_Models_123 


 S  Expntl_Logistic_Models 

 
 M  Fit_Best_Line.xls

 



 M  CableTV.xls

  
  M  General Quadratic

  M  General Cubic

  M  General Exponential

  M  General Logistic

  
DERIVATIVES:
CONCEPTS and RULES

 finding the average rate of change  of a function over a small interval  
( slope of secant line)

 finding the  instantaneous rate of change ( slope of tangent line)

  


 R rules for derivatives


 S Derivatives_Act_1


 S Derivatives_Act_2.xls

 

  

  M  secants.xls

 
  M  tangents_to_f.xls


  M  plot_derivatives.xls




 
NON-LINEAR OPTIMIZATION APPLICATIONS 

 classical Max/Min problems

response functions in marketing

marginal analysis in economics

 
 R  Nonlinear Opt_Solver

S  Exponential Response

   
  M  MaxVolume.xls

M exp_response_f g h
  M  Advertising_Campaign.xls


  M  Marginal_Analysis.xls
  M  plot function f 
        graph function  y = f(x)


  M  plot_functions f g h  
       graph up to three functions

 






Trucks


back to Course Overview


Last Updated on 01/17/01
By Joe Aieta