1
1

Hello,

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

kmwest
5317
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.

link

answered 15 Apr '13, 16:30

Andreas%20Cardeneo's gravatar image

Andreas Card...
1762
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.

link

answered 06 Apr '13, 12:35

Samik%20R.'s gravatar image

Samik R.
1.2k1920
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

By RSS:

Answers

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

Tags:

×16
×14
×4

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.