inventories.xlsx (27.8 KB)
I would like to learn about inventory optimization with solution about
How to reducing inventory by 20%
How to reach a target of 99.5% service level
Assumptions
Shipping lead time to markets incl. quality release of goods:
• Air freight: 5 days no matter the destination (std. dev. 1 day)
• Truck: 3 days within same continent (std. dev. 2 days)
• Sea freight: 23 days freight between continents (std. dev: 7 days)
*** READ FIRST ***
Before you send your question.
Make sure that all details relevant to your question is complete:
- Your current work-in-progress PBIX file - VERY IMPORTANT
- A clear explanation of the problem you are experiencing
- A mockup of the results you want to achieve
- Your underlying data file
Check out this thread on Tools and Techniques for Providing PBIX Files with Your Forum Questions
Also make sure that your data file contains no confidential information. If it does, click the link above.
*** DELETE THIS MESSAGE IF YOU ARE SURE ALL YOUR DETAILS ARE COMPLETE OR IF THE ABOVE INFORMATION IS NOT APPLICABLE TO YOUR QUESTION.***