I am working on a supply chain management simulation study that examines the quantity of inventory that reaches its maximum shelf life at given safety stock levels. I've completed a preliminary study in Excel but would like to make a more robust, generalized model. I'm considering building it in Python because of the xlutils and py2exe packages, which would allow easier input/output and deployment. If I build it in Python, are there any simulation packages that you would recommend for this? Simpy doesn't seem to be what I'm needing.

Thanks in advance.

asked 04 Apr '13, 09:46

kmwest's gravatar image

accept rate: 0%

What is it that you need? Are you looking for good random number generators in Python? Those must exist.

(04 Apr '13, 11:10) RaoulCousins

No, not just a RNG (although I will need one) - I'm looking for any package suggestions instead of just using a lot of looping structures.

(04 Apr '13, 14:50) kmwest

Hi, you should consider SimPy, an open source discrete event simulation framework. It is quite well documented with good examples and is very mature.


answered 15 Apr '13, 16:30

Andreas%20Cardeneo's gravatar image

Andreas Card...
accept rate: 10%

I would suggest to continue working with Excel for your model. Excel works reasonably well for these type of scenarios, especially when augmented by add-ins which take care of the RNG, simulation sensitivity analysis and stochastic optimization part. There are a number of add-ins to chose from: Oracle Crystal Ball, @RISK, Risk Solver, ModelRisk etc.

Please take a look at this blog post - it can help you decide which software to use. Also, take a look at this thread in LinkedIn (you might have to become a member in this group) which has a long but detailed discussion about whether to stick to Excel or move to coding.

Finally, I am not averse to python - but python is a powerful generic language. You can also look at statistical modeling environment like R for your purpose. Hope this helps.

Disclaimer: I work for Oracle Crystal Ball.


answered 06 Apr '13, 12:35

Samik%20R.'s gravatar image

Samik R.
accept rate: 2%

Hmm .. scratch that - looks like you are looking to do discrete event simulation of supply chain. The add-ins above do not do DES.

(07 Apr '13, 21:39) Samik R.
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 04 Apr '13, 09:46

Seen: 5,208 times

Last updated: 05 Oct '17, 23:51

OR-Exchange! Your site for questions, answers, and announcements about operations research.