Our Guest Post today comes from Howard Weiss, who is Professor of Operations Management at Temple University. Howard has developed both POM for Windows and Excel OM for our text.
When I began to use Excel in my classes, my main objective was to make the computations easier for the students so that we could focus on the models, inputs and outputs. At this point though, I have changed my priorities and I think it is important for us as OM (or Finance or Stat) professors to help the students develop their Excel skills as best as we can in our courses. To that end, I have taken a different approach to teaching Breakeven Analysis.
In the past, I used to develop the Break-even point algebraically just as is done in Heizer/Render/Munson and just about every other OM or business textbook. At the computer lab I would have my students enter into Excel the Fixed cost, Variable cost, Price and then the formula for the break-even point F/(P-V).
Recently, I have instead used Goal Seek, rather than the formula, to have the students find the break-even point. Instead of entering the break-even formula, I have them create a cell for the number of units, a cell for the total revenue and a cell for the total cost based on the number of units. I think expressing the total cost and total revenue in Excel helps the student to better understand these two admittedly simply concepts. I then tell the students that instead of finding the number of units where TC = TR we will create a cell for the difference between the two and use Goal Seek to search for a difference of 0 between TC and TR. 
The spreadsheet for Example S5 (Supp. 7) in the textbook appears as follows, along with a capture of the Goal Seek window.
I think this approach gives the student a better understanding of both break-even analysis and Goal seek.
Very interesting! Thank you so much for sharing!