Question: PLEASE SHOW EXCEL SOLUTIONS WITH FORMULAS Styles E Format V Filter 033 x fx A B C D D E E F G H T

PLEASE SHOW EXCEL SOLUTIONS WITH FORMULASPLEASE SHOW EXCEL SOLUTIONS WITH FORMULAS Styles

Styles E Format V Filter 033 x fx A B C D D E E F G H T J K L M N P A manufacturer buys an item from its supplier. The purchasing manager needs to find when he/she should place orders for the item from its supplier. Relevant information is as follows: 1 2 3 4 5 6 7 8 8 9 10 11 12 13 14 Average demand is 30 units per day, Standard deviation of the demand 5 units per day, Lead time is 5 days, Service level or the probability that they want to meet the demand during the lead time is 95%. 1. Calculate the safety stock (1 point). 2. Calculate the reorder point (0.5 point) 15 Please show the calculation otherwise you cannot get any score. You can do the calculation on a sheet of paper, and 16 then paste it in this sheet. 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!