Question: ****** PLEASE USE EXCEL******* Please explain all of your steps and use excel to solve the question. Weekly demand for LG TVs at a Walmart

****** PLEASE USE EXCEL*******

Please explain all of your steps and use excel to solve the question. Weekly demand for LG TVs at a Walmart store is normally distributed with a mean of 120 and a standard deviation of 35. Inventory is continuously monitored and an order of 400 TVs is placed each time the inventory drops to 330 TVs. The replenishment lead-time is two weeks.

  • How much safety inventory does the store carry? What is the CSL?
  • Assume that the supply lead-time from LG is normally distributed with a mean of two weeks and a standard deviation of one week. How much safety inventory should Walmart carry if it wants to provide a CSL of 98 percent?

************PLEASE DO NOT COPY AND PASTE*******

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!

Q:

****** PLEASE USE EXCEL******* Please explain all of your steps and use excel to solve this question. NIA Manufacturing needs to build a new plant to serve four market regions. NIA has three supply...

Q:

Please help understand the study questions with explanations If unable to show work on excel, copy and paste work into a table 1. Given the following set of data (it is a population): 14, 22, 12, 19,...

Q:

Show your work! If unable to show work on excel, copy and paste work into a table 1. Given the following set of data (it is a population): 14, 22, 12, 19, 99, 12, 27, 16, 26, 19, 12, 39, 44, 12, 18,...

Q:

Nissan LEAF The Nissan Leaf is a compact five-door hatchback electric car manufactured by Nissan and introduced in Japan and the United States in December 2010. The first vehicles sold in North...

Q:

For the exclusive use of M. Xin, 2016. CASE: OIT-71B DATE: 10/15/10 WALMART'S SUSTAINABILITY STRATEGY (B): 2010 UPDATE I don't think there's better money that we're spending anywhere. Fred Krupp,...

Q:

Beststyle is a leading clothing brand with multiple retail stores across India. Their outlets are well spread in tier 1 and 2 cities of India. Moreover, within the tier 1 cities, they have maintained...

Q:

ECO550 Week 7 Discussion Board 7 Predicting Price-Setting Strategies...

Q:

For some years now, you've owned a small specialty bookshop in a college town. You sell some textbooks but mainly cater to a broader customer base. Your store always stocks the latest fiction,...

Q:

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

Q:

iv. V. Instructions: 1. You need to follow the following steps for ALL questions: i Identify the objective of the firm manager as specified in the problem. Identify the decision variables in the...

Q:

An experiment can result in one of five equally likely simple events, E1, E2, . . . , E5. Events A, B, and C are defined as follows: A: E1, E3 P(A) = .4 B: E1, E2, E4, E5 P(B) = .8 C: E3, E4 P(C) =...

Q:

Monroe County, New York, passed a local law requiring a sign on each fuel pump at a filling station showing the price, taxes, and octane rating. The law was passed to prevent fraudulent practices in...

Q:

1. The horizontal line in a menu is called . a. a menu bar b. a separator bar c. an item separator d. none of the above

Q:

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...