Solving the Lot Sizing Problem in Resolver One (Wagner-Whitin Algorithm)
I was working on a lot sizing problem today and implemented a Wagner-Whitin algorithm in Resolver One. I just want to share it with you here. Some people use a MIP solver to solve lot sizing problems while Wagner and Whitin have devised an algorithm that can be implemented quickly on a spreadsheet and there is no need to use an expensive solver. You can download the spreadsheet from this link.
In the classical lot sizing problem we have the following assumptions:
- We have a single product (with the production quantity in period t
)
- Discrete Time (unlike EOQ model)
- Demand is known but varies over time (e.g., we have orders)
- No shortage is allowed
- No capacity constraints
- There is a positive setup cost that might be varying over time
- The unit production cost is constant
- The objective is to minimize the total setup cost and inventory costs
Here is the formulation for the model:
setup cost in period t
inventory holding cost per unit remaining at end of period t
demand in period t
a large number (will be used in the MIP model)
production quantity in period t
if
and is 0 otherwise
inventory remaining at the end of period t
The MIP model will be:
Wagner and Whitin have solved this problem using the forward dynamic programming. In this spreadsheet we implement the forward dynamic programming for the lot sizing problem. The spreadsheet then suggests the time period than it is optimal to pay for the setup cost, in other time periods it is cheaper to carry an inventory.
Update: Please see this post for an updated version and more information
i need your help Mr, for my Thesis,,cause my Thesis Title also likes your scribd in this blog.how can i call u or always chat with you.i really dont know about my problem. plez,,help me Mr.
this is my title :
Integer Program Model for Resolving Issues Lot Size
Coordinated with deterministic Dynamic Demand
can you give me some books that relation with my title ,,Mr???ples yaaaaaaaa
budi Irwansyah said this on October 24, 2009 at 11:03 pm |
Click to access xuinventory.pdf
ridwan said this on November 12, 2009 at 2:48 pm |
http://e-optimization.com/resources/uploads/Optimierung.DOC
ridwan said this on November 12, 2009 at 3:04 pm |
Hi there:
I am an undergraduate student at SUNY Buffalo. I wanted to open the sample spreadsheet file you have posted, but it is an .RSL file, and I can’t find information about that extension online. Which program can I use to open it?
Thanks!
Alex
Please email me at:
admills@buffalo.edu
Alex Mills said this on November 28, 2009 at 2:15 pm |
Sir, how can i able to access your journals freely. As i am a Ph. D. scholar in Assam University Silchar, India.
Thank you
Please e-mail me at:
mantukls86@gmail.com
Mantu Das said this on April 25, 2010 at 9:21 am |
hi,
May I know how to open the .RSL file? Which program should I use to open these extensive file? Thanks for sharing this information.
Yvonne said this on October 5, 2010 at 10:10 am |
May I suggest as an alternative the SCperf package for R where the WW() function implements the Wagner-Within algorithm (forward and backward methods). Here is the link http://cran.r-project.org/web/packages/SCperf/index.html
Thanks.
marlene marchena said this on March 26, 2012 at 5:44 pm |
Very Nice, posted it on twitter too.
marksalen said this on March 26, 2012 at 5:50 pm |