Question: Using the random number generator in Excel Analysis ToolPak, generate 200 demand numbers. Demand should follow a normal distribution with the mean of 120 units

Using the random number generator in Excel Analysis ToolPak, generate 200 demand numbers. Demand should follow a normal distribution with the mean of 120 units and the standard deviation of 30 units. 4 They correspond to the weekly demand for 200 weeks. Co = .30 and Cu = 1.70 cu Please find out the total lost minimizing inventory level and the corresponding service level.

- Using the random number generator in Excel Analysis ToolPak, generate 200 demand numbers. - Demand should follow a normal distribution with the mean of 120 units and the standard deviation of 30 units. - They correspond to the weekly demand for 200 weeks. - co=.30 and cu=1.70 - Please find out the total lost minimizing inventory level and the corresponding service level

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!

Lab 4 This assignment is due before the end of your Monday/Tuesday section. For every section you will submit your handwritten work to your TA. Only neat and organized assignments will be graded for...

Complete class diagram (phase 5 and 6). 17 Questions. 17 To be submitted: 18 Marking Criteria. 20 Appendix A: Sample Output for a completed phase 6. 22 Objectives In this assignment you will develop...

Florida Institute of Technology Instructions: Read the questions very carefully because the requirements for each are specific. Each group should turn in one copy of this WORD document (email to me)...

3. [9 points] Using Excel or Minitab, construct one graph showing the probability density functions from 0 to 15 for the following three distributions: a. Hypergeometric, where n = 9, N = 50, D = 20...

Laboratory Exercise Making use of lab4C.c for child process generation, you can create a program that will generate separate child processes to help dividing up a lot of processing tasks to be...

General Education Common Graded Assignment: MATH 153 Spring 2017 Inferences from Data on the \"Working Poor\" in the U.S. MATH 153: Introductory Statistics is a general education course designed to...

Question 1 (Network design optimization). [20 points] ABC Limited Corp. has won contracts to supply a high-tech product to customers in Asia, North America, Europe, and South America. The company has...

Problem 2-30 Thomas Kratzer is the purchasing manager for the headquarters of a large insurance company chain with a central inventory operation Thomas's fastest moving inventory item has a demand of...

not clear on what to enter in the random number generator. these instructions are a bit confusing. i know the subject title on this is misleading but the correct option to choose from wasnt there....

1 Use data in Worksheet Q1-9 to answer questions 1 to 9. The data is for a sample of dealerships and was collected for the second week of August 2016. Which variables are qualitative? A. New Car...

Following table shows the demand for three goods: Price of good A $120 $140 Quantity Sold of good A 4000 3600 Quantity Sold of good B 1000 800 Quantity Sold of good C 2000 2400 Please calculate...

The null and alternate hypotheses are: H0: 1 = 2 H1: 1 2 (a) State the decision rule, (b) Compute the pooled estimate of the population variance, (c) Compute the test statistic, (d) State your...

Use the example of Trident Company described in the notes. The company has 1 million Pound receivable. They are comparing the hedging result of each hedging tool. According this graph, indicate ( 1 )...

Free cash flow valuation You are evaluating the potential purchase of a small business with no debt or preferred stock that is currently generating $ 4 2 , 7 0 0 of free cash flow ( F C F 0 = $ 4 2 ,...