Questions from Spreadsheet Modeling

Q: Patrick’s luck had changed overnight – but not his skill at mathematical

Patrick’s luck had changed overnight – but not his skill at mathematical reasoning. The day after graduating from college he used the $20 that his grandmother had given him as a graduation gift to buy...

Q: Customers checking out at Food Tiger arrive in a single-line

Customers checking out at Food Tiger arrive in a single-line queue served by two cashiers at a rate of eight per hour according to a Poisson distribution. Each cashier processes customers at a rate of...

Q: Road Rambler sells specialty running shoes and apparel through catalogs and the

Road Rambler sells specialty running shoes and apparel through catalogs and the Web. Customers can phone in orders at any time day or night, 7 days a week. During the 4 a.m. to 8 a.m. shift, a single...

Q: Interstate 81 through southwest Virginia is heavily traveled by long-distance

Interstate 81 through southwest Virginia is heavily traveled by long-distance truckers. To cut down on accidents, The Virginia State Patrol carries out random inspections of a trucks weight and the co...

Q: The drive-thru window at Hokie Burger requires 2.5

The drive-thru window at Hokie Burger requires 2.5 minutes on average to process an order with a standard deviation of 3 minutes. Cars arrive at the window at a rate of 20 per hour. a. On average, how...

Q: Calls arrive at a rate of 150 per hour to the 800

Calls arrive at a rate of 150 per hour to the 800 number for the Land’s Beginning mail-order catalog company. The company currently employs 20 operators who are paid $10 per hour in wages and benefits...

Q: Consider the three queuing configurations shown in Figure 13.2.

Consider the three queuing configurations shown in Figure 13.2. For each configuration, describe a situation (besides the examples mentioned in the chapter) in which you have encountered or observed t...

Q: This chapter implies that customers find waiting in line to be an

This chapter implies that customers find waiting in line to be an unpleasant experience. In addition to reducing the length of the wait itself, what other steps could a business take to reduce the fru...

Q: Describe a situation in which a business might want customers to wait

Describe a situation in which a business might want customers to wait some amount of time before receiving service.

Q: Tri-Cities Bank has a single drive-in teller window

Tri-Cities Bank has a single drive-in teller window. On Friday mornings, customers arrive at the drive-in window randomly, following a Poisson distribution at an average rate of 30 per hour. a. How ma...