These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Monday, April 12, 2010

Inventory Optimizer - Andrea Cordani, Winter 2010

You all Supply Chain guys.. you know you need it.

Have you ever wondered how many items you need to keep in your warehouse to keep your customers happy?
This is the tool you were looking for. By automatizing Solver (and fixing with a code a major bug) and by facilitating interface through the use of a couple of forms, I created this spreadsheet that will allow you to save a lot of money with a single click.

Try it!
Spreadsheet: here!
Paper: here!

No comments:

Post a Comment

Blog Archive