Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

use the data CallCounts.xls to estimate arrival rates for a piecewise-constant, nonstationary Poisson arrival process. Implement this arrival process in your simulations and describe the

use the data CallCounts.xls to estimate arrival rates for a piecewise-constant, nonstationary Poisson arrival process. Implement this arrival process in your simulations and describe the results.Software Made Personal (SMP) customizes software products in two areas: financial tracking and contact management. They currently have a customer support call center that handles technical questions for owners of their software from the hours of 8 a.m. to 4 p.m. Eastern time. When a customer calls, they first listen to a recording that asks them to select among the product lines; historically 59% are financial products and 41% contact management products. The number of customers who can be connected (talking to an agent or on hold) at any one time is essentially unlimited. Each product line has its own agents. If an appropriate agent is available then the call is immediately routed to the agent; if an appropriate agent is not available, then the caller is placed in a hold queue (and listens to a combination of music and ads). SMP has observed that hang-ups very rarely happen. SMP is hoping to reduce the total number of agents they need by crosstraining agents so that they can answer calls for any product line. Since the agents will not be experts across all products, this is expected to increase the time to process a call by about 5%. The question that SMP has asked you to 78 4 Simulation Programming with VBASim answer is how many cross-trained agents are needed to provide service at the same level as the current system. Incoming calls can be modeled as a Poisson arrival process with a rate of 60 per hour. The mean time required for an agent to answer a question is 5 min, with the actual time being Erlang-2 for financial calls, and Erlang-3 for contact management calls. The current assignment of agents is four for financial and three for contact management. Simulate the system to find out how many agents are needed to deliver the same level of service in the cross-trained system as in the current system the arrival rate is not actually steady 60/h, it varies throughout the day. Data on call counts, by hour, for1 month (31 days) can be found on the book website in CallCounts.xls. Use these data to estimate arrival rates for a piecewise-constant, nonstationary Poisson arrival process. Implement this arrival process in your call center simulations. Does this affect your recommendation? use the data CallCounts.xls to estimate arrival rates for a piecewise-constant, nonstationary Poisson arrival process. Implement this arrival process in your simulations and describe the results.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Principles

Authors: Jerry J. Weygandt, Donald E. Kieso, Paul D. Kimmel, Barbara Trenholm, Valerie Warren, Lori Novak

7th Canadian Edition Volume 2

978-1119048473

Students also viewed these Accounting questions

Question

Who Is on Your Team and What Do They Bring to the Table?

Answered: 1 week ago