| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MS EXCELL
Need formula to figure safety stock.
Safety stock is 3 months usage Forecast is 23 per month Lead Time is 120 days What should be my safety stock? HELP |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MS EXCELL
Leadtime+safety stock*usage
MAXIMA wrote: Need formula to figure safety stock. Safety stock is 3 months usage Forecast is 23 per month Lead Time is 120 days What should be my safety stock? HELP |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MS EXCELL
Hi
safety stock (m) Usage (mth) lead time Minimum re-order level 3 23 4 161 and the formula for re-order level is =(A2*B2)+C2*B2 At 161 in stock it will take 4 months to get new stock. In that 4 months usage will be (4*23)= 92 so stock will fall to 69 which is the minimum safety dtock Mike "MAXIMA" wrote: Need formula to figure safety stock. Safety stock is 3 months usage Forecast is 23 per month Lead Time is 120 days What should be my safety stock? HELP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to open MS Excell 2007 Sheet in MS Excell 2000??? | New Users to Excel | |||
| create a slides show with excell spreadsheets using excell | Charts and Charting in Excel | |||
| editing documents with excell that are not excell format | Excel Discussion (Misc queries) | |||
| Can I view an excell document without excell (not installed wit. | Excel Discussion (Misc queries) | |||
| how do you open an excell email attacment, if I dont have excell | Excel Discussion (Misc queries) | |||
Linear Mode
