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