last modified by J. F. Aieta on Monday, December 20, 1999 10:32 AM


Excel Companion
for Quantitative Methods with Calculus

1995 -1997 Joseph F. Aieta

Chapters, Workbooks, and Worksheets

The Excel Companion consists of more than twenty Excel workbooks and related applications designed to introduce basic concepts of mathematical modeling. The text is organized into five main chapters, EC_1 through EC_5, and four appendices. All Excel files are stored and maintained on the college network in the shared campus directory:

K:\COURSES\EXCLCMPN\

Table of Contents

EC_1   ELEMENTARY FUNCTIONS
  LinDepr.xls Linear Depreciation
  LinBE.xls Break-even: Manufacturer’s Perspective, Accountant’s Perspective
  LinSD.xls Linear Supply & Demand
  Highway.xls Addition of Functions
  Plot.xls (GrafCalc.xls) General Graphing Utilities
  NonlinBE.xls Finding Break-even Points
  NonlinSD.xls Finding the Equilibrium Point
     
EC_2   LINEAR OPTIMIZATION
  Vitamins.xls Two variable LP Minimization
  Machines.xls Two variable LP Maximization
  Rlestate.xls Integer Programming
     
EC_3   TIME VALUE of MONEY
    Terminolgy and Notation
  TVM1.xls Simple versus Compound Interest Future Value, Doubling Time, Present Value
    Financial Calculator 1
    Continuous Compounding
  TVM2.xls FV of Ordinary Annuity
    PV of Ordinary Annuity
    Financial Calculator 2
    Car Loan Amortization
    Home Loan Amortization
     
EC_4   RATES of CHANGE: SECANT LINES and TANGENT LINES
  Marginal.xls Rates of Change in Economics
      Marginal Cost, Marginal Revenue, and Marginal Profit
  TimeTemp.xls
Average and Instantaneous Rates of Rates of Change
  Tangents.xls Slopes of Tangent Lines
  Secants.xls Secant Lines as Approximations to the Tangent Line at a Point
  DiffQuot.xls Approximating Slope Functions with the Difference Quotient
     
EC_5   NON-LINEAR OPTIMIZATION
  MaxVolum.xls Classical Volume Maximization
  ClsscMin.xls Three Classical Minimization Problems

Minimum surface area of open and closed boxes

Minimum cost of building open and closed boxes

Minimum surface area of cylinder (tin can)

  PointMP.xls Point Marginal Profit: Derivatives
  EOQ.xls Economic Order Quantity
      Ordering and Holding Cost, Total Cost with Discount
  Response.xls New Product Promotion

APPENDICES

Appendix A Building a basic worksheet for the graph of a function
Appendix B Using Solver for Linear Programming
Appendix C Line fitting with least squares, Trendlines
Appendix D Bisection method, Newton’s method

 

Return to Table of Contents]

Copyright Joseph F. Aieta, Babson College 1997