Question: Please solve for ROP, Ave demand and Zscore in excel using the given data B C D E F _ J K L MN 1

Please solve for ROP, Ave demand and Zscore in excel using the given data

Please solve for ROP, Ave demand and Zscore in

B C D E F _ J K L MN 1 Instructions: Find the Reorder Point for product X (including safety stock), Average Demand and the Z score & show your calculations 2 Product X Annual Demand =1000 units 3 Work Days per Year = 250 4 Lead-time = 15 days 5 Service Level = 95% Std Deviation of Demand 6 during Lead-time = 25 units ROP = Ave Demand = Z score = Desired cycle service level Z-score 84 85 90 95 Reorder Point = Average demand during lead time(d*L) + safety stock (Z* L) 97 1.04 1.28 1.65 1.88 2.05 2.33 3.09 98 99 99.9

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!

Problem 4. By observing and using the information reported in the following screen output answer the following questions by writing them in the box provided. Let ' 1 ' and ' 2 ' be methane and...

informs Vol. 34, No. 3, May-June 2004, pp. 191-205 issn 0092-2102 \u0001 eissn 1526-551X \u0001 04 \u0001 3403 \u0001 0191 doi 10.1287/inte.1030.0068 2004 INFORMS Inventory Decisions in Dell's Supply...

Group: PERON A+ PERSON B +PERSON C 1- Introduction 2- Literature a. Definition of operation management b. Definition of operation strategy and why it is important c. Components of operations strategy...

IOE 419 Mark S. Daskin Service Operations Management IOE Department Winter, 2017 University of Michigan Problem set 4 DUE: MONDAY - February 20, 2017 Points: 100 points total Problem 1: Babette has...

Having difficulty with this lab :/ any kind of help would be useful and very much appreciated! Learning Objectives: Deeper understanding about the costs associated with an Ordering policy (i.e. an...

Hospital purchasing agent Abby Smith needs to order examination gloves for the hospital. Currently, she orders 1,000 boxes of gloves whenever she thinks there is a need. Abby has heard that there is...

You have been hired as a consultant by the Ontario Provincial Government to help identify "efficiencies". One potential area of cost reduction is to centralize the procurement of basic supplies...

M5 Assignment: Inventory Management Instructions Text Resources for Inventory Models I suggest that you take a look at the text beginning where the discussion of safety stock begins...this continues...

Year Quarter Location CarClass Revenue NumCars 2018 Q2 Airport Premium 303242 1933 2018 Q2 Airport Hybrid 303607 1982 2018 Q2 Airport SUV 303199 2027 2019 Q2 Airport Economy 368286 2153 2018 Q1...

help needed on lab please and thank you If annual demand is 1739 , holding costs are $9 per unit per year, and setup costs are $89 per order, what is the economic order quantity? Answer: What is the...

Center for Learning and Technology COURSE SYLLABUS PRINCIPLES OF STATISTICS STA-201-GS Course Syllabus PRINCIPLES OF STATISTICS STA-201-GS Thomas Edison State College May 2015 Course Essentials...

Prepare a journal entry on October 31 for the withdrawal of $4,500 by Amy Sykes for personal use.

Explain caulking and fullering processes. Where do you use them? Determine the forces acting on all the rivets and the size of the rivet for the structural joint shown below if the permissible shear...

*12128. If the roller coaster starts from rest at A and its speed increases at at = (6 - 0.06s) m>s2, determine the magnitude of its acceleration when it reaches B where sB = 40 m. 30 m- Probs....

9.5.1 I imagine one of the top two is the incorrect statement I'm just not sure which one 0/1 point (graded) What is true about the long-run expansion path? (Select each correct answer.) V It...