Start here Click here for Table of Contents You are here
BarEnd.jpg (765 bytes)

  Babson Excel Center -- Examples and Special Topics

This page covers special topics using tools specific to Excel for more sophisticated analyses.  Each of the following examples is built around a specific problem.

Break-even analysis Linear Programming
Break-even analysis uses tables, formulas,  and graphs to identify sales volumes at which a company begins to make a profit. Linear programming (sometimes called linear optimization)  using an add-in called Solver to calculate an optimal solution for complex problems involving linear expressions.
Files: The Babson Press problem Files:  The burgers and fries diet

ppticon.gif (370 bytes)

First break-even presentation

ppticon.gif (370 bytes)

Second break-even presentation

ppticon.gif (370 bytes)

Third break-even presentation
excelicon.gif (346 bytes) Break-even1.xls goes with the first presentation.
excelicon.gif (346 bytes) Break-even2.xls goes with the second presentation.
excelicon.gif (346 bytes) Break-even3.xls goes with the third presentation.

ppticon.gif (370 bytes)

Linear programming with Solver presentation
excelicon.gif (346 bytes) Burgers&fries.xls goes with the linear programming presentation.