Question
Please show excel steps to help me better understand You must decide on how much safety stock to carry. Past records indicate that the standard
Please show excel steps to help me better understand
You must decide on how much safety stock to carry. Past records indicate that the standard deviation of demand is 33 units per week. The item you are investigating is sourced overseas and arrives via barge, which on average takes half a year. If you desire to have a 95% service level, how much safety stock would you recommend? Round the safety stock to the nearest unit (0 dp*)
If a company has a safety stock of 543 units for a product that has a standard deviation of demand of 222.7 units per day and a lead time of one week, what is their average service level in decimal percentage rounded to 4 decimal places?
What is the recommended safety stock for a firm that desires a 98% service level when the average lead time is one month and yearly demand over the last 10 years is as follows?
31 260 278 181 222 118 166 81 281 288
Round the safety stock to the nearest unit (0 dp)
If the current safety stock level is found to be 27 units, what service level is the firm
currently working at? (decimal format of the percentage rounded to 4 dp)
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