Question: 1. Problem 1 is adapted from Problem 29 at the end of Chapter 11. Please use Excel to solve this problem and submit your Excel

1. Problem 1 is adapted from Problem 29 at the end of Chapter 11. Please use Excel to solve this problem and submit your Excel file. The problem is as follows: A warehouse distributor of carpet faces a normally distributed demand for its carpet. The average demand for carpet from the stores that purchase from the distributor is 4,500 yards per month, with a standard deviation of 900 yards. a. Suppose the distributor keeps 6,000 yards of carpet in stock during a month. What is the probability that a customer's order will not be met during a month? (This situation is referred to 35 a stockout.) b. What is the probability that the demand will be between 5000 and 7000 yards? c. How many yards of carpet should this warehouse distributor order from its supplier to ensure that 97% of the demand is met? (The percent of customer demand/orders satisfied is referred to as service level. In this question, the service level is 97%.)

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!

please use excel! EXCEL ONLY! please screenshot answers. Ch 13 Assignment Lab 1. Do Problem 13-20 on page 459 of the textbook - Chapter 13, problem 20, and answer the corresponding questions in...

please answer in excel. and if possible use the same cells. : 4-25 The total expenses of a hospital are related to many factors. Two of these factors are the number of beds in the hospital and the...

please answer in excel and give points for x and y : 4-25 The total expenses of a hospital are related to many factors. Two of these factors are the number of beds in the hospital and the number of...

AF325: Theory of Corporate Finance Fall 2020 Assignment 5 - Making Investment Decisions Submit in Blackboard by October 15, 5:30 PM. Please use Excel to solve the assignment and submit as an excel...

Please use excel to solve. Thanks! Assignment 6-Time Series Analysis Note this is not a timed assignment. For each question on this assignment you must create a separate worksheet in Excel. You will...

4. Work on problem 15 from the problems and exercises section at the end of chapter 9 of Evans. Excel file Nuclear Power is attached (20 pts). Hint: Go through the Worked example 9.12 from Chapter 9...

: 4-25 The total expenses of a hospital are related to many factors. Two of these factors are the number of beds in the hospital and the number of admissions. Data were collected on 14 hospitals, as...

Please use excel and text references Sarah Chang is the owner of a small electronics company. In six months, a proposal is due for an electronic timing system for the next Olympic Games. For several...

Janice Morgan, age 32, is single and has no dependents. She is a freelance writer. In January 2011, Janice opened her own office located at 2751 Waldham road, Pleasat Hill, NM 88135. She called her...

Let X and Y be independent binomial random variables with parameters (n, p1) and (m, p2), respectively. (a) Find E (X/n Y/n) (b) Find Var (X/n Y/n) (c) Show that (x/n Y/n) ~ N (E(Y/n Y/n), Var...

Company C purchased a machine costing Rs. 15, 00,000 for its production process. It paid freight Rs. 25000. Cartage Rs. 2000 and installation charges Rs 18000. The company spent an additional amount...

ane paper - filed a Form 1 0 4 0 - X . She left most of the form blank, but included a copy of a new, completed Form 1 0 4 0 with the word "Amended" written on top. Assuming that Jane completed her...

Which of of the following MRP-related issues was not discussed as being determining the quantity and timing of material requirements? Deciding when to place the order (needed date minus lead time)...