Question: show all the work step by step in excel and show the formula as well . 12.47 First Printing has contracts with legal firms in

show all the work step by step in excel and show the formula as well

. 12.47 First Printing has contracts with legal firms in San Francisco to copy their court documents. Daily demand is almost constant at 12,500 pages of documents. The lead time for paper delivery is normally distributed with a mean of 4 days and a stand- ard deviation of 1 day. A 97% service level is expected. Compute First's ROP. PX 1. taleban is that have vari . -- Clipboard ca Glede Format Font Alignment Number Styles G36 Cels Date X iting A 0 B c. D 27 H 28 Given service level Calculating ROP or Safety Stock when Demand during LT is Normal 29 Results 30 Input Data 31 Mean Lead Time 4 LTD Mean 32 Std Dev Lead Time LTD Std DV 1 33 Mean daily Demand 12500 Stock out Probability 0.03 34 Std Dev Daily Demand Reorder Point = 1.8808 35 Desired Service Level 97.00% Safety Stock 1.8808 36 37 Given ROP Calculating Service Level when Demand during LT is Normal 38 Results 39 Input Data Master Sheet2 Sheet3 Couple Settings

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!

HI GOOD AFTERNOON, IS IT POSSIBLE THAT I MAY GET SOME ASSISTANCE WITH THIS ASSIGNMENT. SEE ATTACHMENT INSTRUCTIONS ARE AS FOLLOWS: ONLY THE RELEVANT HISTORY IS IMPORTANT, IN TERMS OF A PROBLEM...

I need to get help with this case study PwC Case Studies in Taxation, 2013, PwC, LLP FLATIRONS, INC. Flatirons, Inc. (dba Flatirons Flapjacks Caf) specializes in unique breakfast and brunch menus and...

Hi I know you opted out of an earlier question. I have several open questions. I really need to get them in. Would you be willing to take any of these questions? I have been waiting for 3 days. I...

please help complete number one and show why its fraud in bulletin points and calculations in excel sheet please. ISSUES IN ACCOUNTING EDUCATION Vol. 19, No. 4 November 2004 pp. 505-527 Interstate...

1) As Martha McCaskey, what would you do? Describe 2 alternative courses of action you can pursue fordealing with this situation. Explain the pros and cons of each alternative. 2) Use Virtue Ethics,...

1) Use Virtue Ethics, Kantian Ethics, Utilitarian theory, Zone of Sustainable Activity and Stakeholder analysis to compare and contrast the two courses of actions outlined above and decide which...

As Martha McCaskey, what would you do? Describe 2 alternative courses of action you can pursue for dealing with this situation . Explain the pros and cons of each alternative . (2 pages) U se Virtue...

What issues is Martha M cCaskey struggling with? What is the ethical dilemma she is facing? 2. As Martha McCaskey, what would you do? Describe 2 alternative courses of action you can pursue for...

What issues is Martha M cCaskey struggling with? What is the ethical dilemma she is facing? ( 1 page) 2. As Martha McCaskey, what would you do? Describe 2 alternative courses of action you can pursue...

07-043 March 13, 2008 Eli Lilly: Recreating Drug Discovery for the 21st Century Rebecca Henderson and Cate Reavis The rise of personalized medicine is one of the most important developments in health...

The reaction below has an cquilibrium constant K.-6.90, If 0.100 mol of BrCl is placed in a 500-ml. flask and allowed to come to equilibrium, what are the equilibrium concentrations of each...

Odonnel Corporation uses a job-order costing system with a single plantwide predetermined overhead rate based on direct labor-hours. The company based its predetermined overhead rate for the current...

In what part of the GASB Codification could a researcher find the Inventory topic ( I 4 0 ) ?

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...