Question
Please help to calculate Order Receiving Cost, Inventory Holding Cost, Total Cost, Service Level (K) when Service Level (Percentage) is say 95%, 99%, 97.5%, Average
Please help to calculate Order Receiving Cost, Inventory Holding Cost, Total Cost, Service Level (K) when Service Level (Percentage) is say 95%, 99%, 97.5%, Average Demand, Average Lead Time, Standard Deviation of Demand, Standard Deviation of Lead Time and Combined Standard Deviation of Lead Time. Kindly rounded to the nearest integer and please share the answers with calculations from the above google drive link location. Some of the questions to answer are as below, but please answer all the topics put for Product A to E with calculations so that any questions that is asked I can answer and not just below mentioned ones as they are just few given for reference where as we have more such questions.
1. For Product A, what is the total Inventory Holding Cost? (please enter it in the following format xxx, xxxx, or xxxxx)
2. For Product B, what is the EOQ? (please enter it in the following format xxx, xxxx, or xxxxx
3. For product E, what is the EOQ? (please enter it in the following format xxx, xxxx, or xxxxx)
4. For Product B, what is the Total Cost (of holding and ordering inventory)?(please enter it in the following format xxx, xxxx, or xxxxx)
5. For product C, what is the Inventory Holding Cost? (please enter it in the following format xxx, xxxx, or xxxxx)
6. For product D, what is the Inventory Holding Cost? (please enter it in the following format xxx, xxxx, or xxxxx)
8. For product E, what is the Inventory Holding Cost? (please enter it in the following format xxx, xxxx, or xxxxx)
9. For Product A, what is the safety stock you would hold if you wanted to reach a 99% fill rate? (rounded to the nearest integer, e.g. xx.xx-->xx)
10. For Product A, what is the combined standard deviation of lead time and demand? (rounded to the nearest integer, e.g. xx.xx-->xx)
11. For Product B, what is the combined standard deviation of lead time and demand? (rounded to the nearest integer, e.g. xx.xx-->xx)
12. For Product C, what is the combined standard deviation of lead time and demand? (rounded to the nearest integer, e.g. xx.xx-->xx)
13. For Product D, what is the combined standard deviation of lead time and demand? (rounded to the nearest integer, e.g. xx.xx-->xx)
14. For Product E, what is the safety stock you would hold if you wanted to reach a 90% fill rate? (rounded to the nearest integer, e.g. xx.xx-->xx)
15. For Product B, what is the safety stock you would hold if you wanted to reach a 97.5% fill rate? (rounded to the nearest integer, e.g. xx.xx-->xx)
16. For Product D, what is the safety stock you would hold if you wanted to reach a 95% fill rate? (rounded to the nearest integer, e.g. xx.xx-->xx)
17. For Product E, what is the safety stock you would hold if you wanted to reach a 90% fill rate? (rounded to the nearest integer, e.g. xx.xx-->xx)
https://drive.google.com/file/d/1KC8I6oem-546LDXokuR_QwvJxlY1qA05/view?usp=sharing
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started