Wagner-Whitin Algorithm -Part 2
I received an email from a friend and he was asking how he can use the lot sizing spreadsheet in the last post.The whole purpose of this quick note is to clear some of the confusions.
First: I have created a new version, you can download the second version from here
Second: This spreadsheet is developed in “Resolver One” which is a commercial spreadsheet similar to Excel. The good thing is that it is free for academics. It also uses Python instead of VBA which is a huge advantage for me.
In order to use the algorithm (shown below), change the number of periods, holding costs, and setup costs for different periods and click “Calculate”. You will see the updated cost matrix and the code will spit out in which stages you’d better pay the setup cost and avoid the holding cost. I had so much fun developing it and I hope it comes in handy for you too.
Wagner Whitin Screenshot
[...] Please see this post for an updated version and more [...]
Solving the Lot Sizing Problem in Resolver One (Wagner-Whitin Algorithm) « Open Source Research said this on September 5, 2009 at 7:55 pm |
That’s great work. I wonder is there a more accessible way for people to use it? A website maybe rather than a spreadsheet?
Hello
We are students from Tel Aviv University, we want to improve your amazing spreadsheet and to add some more constrains .
For example: we want that the algorithm will be able to calculate not only whole demands but parts of demands (if its better to produce the next demand but maybe it better to produce the next half demand or the quarter next demand)
Thanks for your help
Elad
stauberg@walla.com
Hello, I am a master degree student in Thailand. I ‘m interested in your Wagner-Whitin Algorithm spreadsheet. I would like to use this spreadsheet for my lot sizing problem in my project.
Thanks for your help,
Pornpimon
pornpimon.jin@hotmail.com