Questions from Spreadsheet Modeling


Q: Cuts-R-Us provides low cost haircuts at a shopping

Cuts-R-Us provides low cost haircuts at a shopping center in Boise, Idaho. During the day, customers arrive at an average rate of 9 per hour following an exponential distribution. After a customer is...

See Answer

Q: In the solution to the Blue Ridge Hot Tubs problem, the

In the solution to the Blue Ridge Hot Tubs problem, the optimal values for X1 and X2 turned out to be integers (whole numbers). Is this a general property of the solutions to LP problems? In other wor...

See Answer

Q: On Friday nights, patients arrive at the emergency room at Mercy

On Friday nights, patients arrive at the emergency room at Mercy Hospital following a Poisson distribution at an average rate of seven per hour. Assume that an emergency-room physician can treat an av...

See Answer

Q: Seabreeze Furniture in Orlando maintains a large, central warehouse where it

Seabreeze Furniture in Orlando maintains a large, central warehouse where it stores items until they are sold or needed by the company’s many stores in the Central Florida area. A four-person crew wor...

See Answer

Q: The Madrid Mist outlet store at Chiswell Mills sells discount luggage and

The Madrid Mist outlet store at Chiswell Mills sells discount luggage and does most of its daily business in the evening between the hours of 6 and 9 pm. During this time, customers arrive at the chec...

See Answer

Q: The manager of the Radford Credit Union (RCU) wants to

The manager of the Radford Credit Union (RCU) wants to determine how many part-time tellers to employ to cover the peak demand time in its lobby from 11:00 a.m. to 2:00 p.m. RCU currently has three fu...

See Answer

Q: The Westland Title Insurance Company leases one copying machine for $45

The Westland Title Insurance Company leases one copying machine for $45 per day that is used by all individuals at their office. An average of five persons per hour arrive to use this machine, with ea...

See Answer

Q: The Orange Blossom Marathon takes place in Orlando, Florida, each

The Orange Blossom Marathon takes place in Orlando, Florida, each December. The organizers of this race are trying to solve a problem that occurs at the finish line each year. Thousands of runners tak...

See Answer

Q: State University allows students and faculty to access its super computer by

State University allows students and faculty to access its super computer by high-speed proxy servers. The university has 15 proxy server connections that can be used. When all of the proxy server con...

See Answer

Q: During tax season, the IRS hires seasonal workers to help answer

During tax season, the IRS hires seasonal workers to help answer the questions of taxpayers who call a special 800 telephone number for tax information. Suppose that calls to this line occur at a rate...

See Answer