Question: Please provide Excel formula for required fields and please for upvoting provide true excel formulas step by step: Expected demand E(D): Re-order point s: -service-level:

Please provide Excel formula for required fields and please for upvoting provide true excel formulas step by step:

Expected demand E(D):
Re-order point s:
-service-level:
Expected backlog E(B)
-service-level:

Please provide Excel formula for required fields

A B C D E F G H 1 J K L L M N 0 P 1 Demand D P(D) Required safety stock 6 100 order size a 0 0 10 20 30 Development of the stock for (s, q) policy (with backlog) physical Inventory inventory level 2 3 4 5 6 7 8 9 10 11 12 13 0.05 0.15 0.40 0.25 0.10 0.05 10 order quantity (9) 40 50 order quantity (9) 8 Expected demand E(D): 6 lead time Re-order point s: 14 4 a-service-level: 15 16 re-order point (s) 2 Expected backlog E(B) 17 Safety stock (SS) 0 B-service-level: 18 19 20 21 02 4 6 8 Shortage (=backlog) 14 16 time 10 12

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!