Teaching Study and Application on the Location Selection by Gravity Approach Based on Spreadsheet Teaching Method

In the logistics professional teaching for undergraduates, to strengthen their ability to locate selection by gravity approach more efficiently, this paper adopts the Spreadsheet teaching method, which focuses on solving problem with high speed, rather than theoretical derivation and complicated calculating, and software application becomes the key. Then, this paper tries to use three kinds of software to solve the gravity problem, that is excel, lingo, logware-cog, and make a further compare of them from three aspects: iterative time, visibility and the difficulty level for bachelor student to learn. Finally, this paper put forward the further research directionon software development.