Safety Stock and Replenishment Tool

[dmb41]

Does any one have any plug-ins or spreadsheets they are willing to share related to:

Safety Stock
Replenishment
Reorder point
etc.

Thanks in advance!

 

[Akashwani]

Hi,

You have had over 10 views and no answers, so I guess that means you need to provide a little bit more information to get a satisfactory reply.

Have you tried to set up a spreadsheet yourself?
How many products do you have?
Will the number of products increase/decrease over time?
What do you want the spreadsheet to do?
How will data be changed within the spreadsheet?

As you can see there are many questions to be asked.
I think that you need to be 100% clear what you want, how the spreadsheet will function and what help you require before you get any answers.

If you have created a spreadsheet and you are unsure how to proceed further, post a link to it here...
http://www.4shared.com/
Explain the problem(s) you have and you may be lucky enough to get the solution(s) you seek.

Good luck

Ak

 

[dmb41]

Basically what I am looking for is something similar to the following:

http://office.microsoft.com/en-us/e...before-i-reorder-HA001124602.aspx#BMinventory

If anyone knows of a similar tool for excel

 

[Smitty]

Have you looked at Excel's What-If Analysis tools?

 

[dmb41]

Nope, never in detail. I'll have to spend some time looking at those tools.

 

[Smitty]

I just went through a training session teaching them, and if you're not comfortable setting up your own models then they're well worth the time to get to know.

Good luck, and if you have any questions on them then post back. In all the years I've been posting here I can't recall a single question about them, so I think that they're just overlooked, but very powerful tools.