Reference no: EM131251440
Discussion Questions -
Q1. Use the spreadsheet template in Table 7.9 to simulate a customer service desk with two servers. The start time of the process is 9:00 AM (cell C4), and the inter-arrival times (cells B5 to B14) are given in minutes. Assume that the process consists of a single queue operating under a first-in-first-out discipline. That is, customers join the queue and move to the first available customer service representative in the order in which they arrived. Calculate the average waiting time and the utilization of each server.
Q2. The chief of staff in the emergency room of Exercise is considering the computerization of the admissions process. This change will not reduce the 10 min service time, but it wills male it constant. Develop a spreadsheet simulation to compare the performance of the proposed automated process with the performance of the manual existing process. Hint: Note that inter arrival and service times that follow an exponential distribution can be generated with the Excel functions RAND() and LN() and the following expressions:
Aj = -(1/λ)xLN(RAND())
Sj = -(1/μ)xLN(RAND())
where
μ is the mean service rate
λ is the mean arrival rate
The Excel formula RAND() generates a random number between 0 and 1. The natural logarithm of the random number is found to transform this number into an exponentially distributed value. The transformation to an exponential distribution is completed when the value is divided by the appropriated mean rate and the negative sign applied. (Simulate 500 patient is each case.)
Q3. At Letchworth Community College, one person, the registrar, registers students for classes. Students arrive at a rate of 10/h (Poisson arrivals), and the registration process takes 5 min on the average (exponential distribution). The registrar is paid $5 per hour, and the cost of keeping students waiting is estimated to be $2 for each student for each hour waited (not including service time). Develop a process driven spreadsheet simulation to compare the estimated hourly cost of the following three systems.
a. The current system.
b. A computerized system that results in a service time of exactly 4 min. The computer leasing cost is $7 per hour.
c. Hiring a more efficient registrar. Service time could be reduced to an average of 3 min (exponentially distributed), and the new registrar would be paid $5 per hour.
|
What is the current share price
: Investors require a return of 13 percent for the first three years, a return of 11 percent for the next three years, and a return of 9 percent thereafter. What is the current share price? (Do not round intermediate calculations and round your answ..
|
|
Develop recommendation for utilizing a specific forecasting
: Given the information available and your knowledge of different forecasting techniques, develop a recommendation for utilizing a specific forecasting technique in the subsequent study.
|
|
What role does the nat play in the process
: What role does the NAT play in the process? What about the PAT? Which one bridges the internal network to the external? What about internal tracking of devices?
|
|
How was native american tribe impacted by westward expansion
: What Federal policies governed treatment of the chosen Native groups? Native American group. How was this tribe impacted by Westward Expansion?
|
|
Calculate the average waiting time
: Use the spreadsheet template in Table 7.9 to simulate a customer service desk with two servers. The start time of the process is 9:00 AM (cell C4), and the inter-arrival times (cells B5 to B14) are given in minutes. Calculate the average waiting ti..
|
|
Find the spectrum for the manchester encoded
: Thus, a PAM pulse shape of the Manchester type, as given by Eq. (3-46a), is used. The PAM sampling frequency is 10 kHz. Find the spectrum for the Manchester encoded flat-topped PAM waveform. Sketch your result.
|
|
After-tax cash inflow to the firm
: A corporation sell a piece of equipment it own today for $31,000. This equipment has been fully depreciated, using MACRS rules and had an original cost of $265,000. The company's tax rate is 38%. What is the after-tax cash inflow to the firm fr..
|
|
What did you learn and why was it interesting
: These chapters talk about hiring ethical people and codes of conduct/Code of ethics. What did you learn and why was it interesting? Use at LEAST five of the KEY WORDS at the end of each chapter to support your thoughts in EACH section of your pape..
|
|
What is web security were mentioned in the last six months
: Write a research paper/presentation on what is application/web security and recent attacks that were mentioned in the last 6 months. Present your views and experts' views, if available on the breaches referenced in your paper/presentation.
|