Concept explainers
a)
To determine: The average of 200 numbers with the AVERAGE function.
Introduction: In order to predict the waiting time and length of the queue, queueing model will be framed. Queueing theory is the mathematical model that can be used for the decision-making process regarding the resources required to provide a service.
b)
To determine: The standard deviation of 200 numbers with the STDEV function.
Introduction: In order to predict the waiting time and length of the queue, queueing model will be framed. Queueing theory is the mathematical model that can be used for the decision-making process regarding the resources required to provide a service.
c)
To create: A histogram for the random numbers.
Introduction: In order to predict the waiting time and length of the queue, queueing model will be framed. Queueing theory is the mathematical model that can be used for the decision-making process regarding the resources required to provide a service.
d)
To create: Whether the interarrival times is exponentially distributed.
Introduction: In order to predict the waiting time and length of the queue, queueing model will be framed. Queueing theory is the mathematical model that can be used for the decision-making process regarding the resources required to provide a service.
Want to see the full answer?
Check out a sample textbook solutionChapter 12 Solutions
Practical Management Science
- Use the RAND function and the Copy command to generate 100 random numbers. a. What fraction of the random numbers are smaller than 0.5? b. What fraction of the time is a random number less than 0.5 followed by a random number greater than 0.5? c. What fraction of the random numbers are larger than 0.8? d. Freeze these random numbers. However, instead of pasting them over the original random numbers, paste them onto a new range. Then press the F9 recalculate key. The original random numbers should change, but the pasted copy should remain the same.arrow_forwardQ) The sin() function can be evaluated by the following infinite series: x3 sin x = x - 3! 5! Create an M-file to implement this formula so that it computed and displays the values of sin(x) as each term in the series is added up to fifteenth order. For each step, compute and display the percent relative error as following: true – series approximation %error x 100% truearrow_forwardModels that have no random input are called iconic models. Select one: True Falsearrow_forward
- Convert the following IEEE single precision floating point numberto base 10: 010001010000 0101 0010 0110 0000 0000arrow_forwardMaximize z=4x+5y Subject to: x+y<or=4 x-y>or=-2 x<or=3 x>or=0, y>or=0arrow_forwardWhat would the formula be for Cells B9 and C9 be to populate 0? Or is it just left blank?arrow_forward
- 3. Gursoy is selling Christmas trees. She purchases trees for $10 and sells for $25 each. The number of trees she can sell is normally distributed with a mean of 100 and standard deviation of 30. How many trees should Gursoy purchase?arrow_forwardWe can use the methods below to control extraneous variables except O Manual control O Design control O Statistical control Randomization O Matchingarrow_forwardMarkov process models can be used to describe the probability that a consumer purchasing brand A in one time period 1.will sell brand A in the next period 2. all of the answers are correct. 3.will sell brand A after three time periods 4. will not purchase brand A in the next periodarrow_forward
- We all hate to bring small change to the store. Usingrandom numbers, we can eliminate the need for change andgive the store and the customer a fair shake.a Suppose you buy something that costs $.20. How could you use random numbers (built into the cash reg-ister system) to decide whether you should pay $1.00 or nothing? This eliminates the need for change!b If you bought something for $9.60, how would youuse random numbers to eliminate the need for change?c In the long run, why is this method fair to both thestore and the customer?arrow_forwardThe upper limit and lower limit condition can be tested through Select one: a. whatif function alone b. If within if function c. Single if function d. Countif with count functionarrow_forwardFor the next 6 numbers: Refer to the Management Scientist output of a maximization LP problem. The constraints are defined as follows: Constraint 1: advertising budget ( ) Constraint 2: sales force availability ( ) Constraint 3: production level (=) Constraint 4: retail stores requirement ( ) Optimal Solution Objective Function Value - Variable. Constraint X1 X2 X1 X2 X3 X4 X3 X4 1 2 Variable 1 2 3 3 4 OBJECTIVE COEFFICIENT RANGES 4 Constraint RIGHT HAND SIDE RANGES Value Slack/Surplus Lover Limit 25.000 425.000 150.000 0.000 84.000 50.000 No Lover Linit No Lover Linit Lover Limit 48450.000 0.000 25.000 0.000 0.000 4950.000 1775.000 515.000 0.000 Reduced Costs Dual Prices Current Value 90.000 84.000 70.000 60.000 Current Value 0.000 0.000 0.000 45.000 5000.000 1800.000 600.000 150.000 3.000 0.000 60.000 -17.000 Upper Limit No Upper Linit 90.000 87.000 105.000 Upper Linit 5850.000 No Upper Limit 603.571 200.000arrow_forward
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,