Question: Need help solving this in Excel Thanks so much! Problem 1: Weekly demand for demand for PCs at R&J Computer Systems is normally distributed, with

Need help solving this in Excel Thanks so much!

Problem 1: Weekly demand for demand for PCs at R&J Computer Systems is normally distributed, with a mean of 2500 and a standard deviation of 500. The lead time for manufacturer to fill the order for R&J is two weeks. The store manager currently orders 10000 PCs when the on hand inventory drops to 6000 units. What are the safety inventory and average inventory carried by R&J? b. What is the average time that a PC spends at R&J? What is the CSL (cycle service level) at R&J? a. c. d. What is the fill rate at R&J

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!

E-1. Analyze the five interviews. In a paragraph, discuss what type of structure each interview has. E-2. List each interview, 1 through 5, and then write a paragraph for each, discussing ways that...

Everything I have is provided. The swimlanes can be done through excel or powerpoint. Faculty and Staff Self Service System Case Background Omega University is a large public multicampus institution...

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...

hi. I'm stuck with a report whose Chic Paints Ltd. and I am finding difficulty to answer some questions such as the organisations accounting system requirements including hardware and software...

Discussion Questions for Crystal View Incorporated Case:(45points)Write-up for Crystal View Inc.should be turned in by the end of October 8(11:59 pm, Oct 8).This is a group exercise. Consider the...

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...

Project Management Casebook David I. Cleland, Karen M. Bursic, Richard Puerzer, and A. Yaroslav Vlasak Library of Congress Cataloging-in-PublicationData Project management casebook /edited by David...

1. Why was the attack on Maersk successful? 2. Identify and explain 5 different effects of how this cyberattack impacted transportation across the globe. Feel free to think broadly about implications...

Connor Formed Metal Products case solution At the close of 1990, Bob Sloss, president of Connor Formed Metal Products, reflected on his accomplishments since taking the helm of his family company in...

Weekly demand for demand for PCs at R&J Computer Systems is normally distributed, with a mean of 2500 and a standard deviation of 500. The lead time for a manufacturer to fill the order for R&J is...

How can government, businesses and households solve the economic issues in this article in terms of circular flow model? There have been growing concerns about the increase in prices in Singapore. On...

Explain this image? 35 45 100 20 FRONT 50 50

is ( are ) costs that were incurred in the past and cannot be changed regardless of which future action is taken. A . Sunk costs B . Irrelevant costs C . Relevant information D . Relevant costs

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...