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