Questions from Spreadsheet Modeling


Q: A debate recently erupted about the optimal strategy for playing a game

A debate recently erupted about the optimal strategy for playing a game on the TV show called “Let’s Make a Deal.” In one of the games on this show, the contestant would be giventhe choice of prizes...

See Answer

Q: Refer to the previous question. Suppose plants 1 and 2 represent

Refer to the previous question. Suppose plants 1 and 2 represent different building alternatives for the same site (i.e., only one of these plants can be built). Similarly, suppose plants 4 and 5 repr...

See Answer

Q: Meredith Shomers manages scholarship endowments for a major public university. Presently

Meredith Shomers manages scholarship endowments for a major public university. Presently, she is trying to determine how much scholarship money may be awarded from an endowment with a current balance...

See Answer

Q: Firebird Packaging Operations manufactures small plastic cups used in a popular single

Firebird Packaging Operations manufactures small plastic cups used in a popular single-cup brewing systems for coffee, tea, and hot chocolate. The cups are thermoformed with several different plastic...

See Answer

Q: Suppose a product must go through an assembly line is made up

Suppose a product must go through an assembly line is made up of five sequential operations. The time it takes to complete each operation is normally distributed with a mean of 180 seconds and standar...

See Answer

Q: Suppose a product must go through an assembly line is made up

Suppose a product must go through an assembly line is made up of five sequential operations. The time it takes to complete each operation is normally distributed with a mean of 180 seconds and standar...

See Answer

Q: Calls to the service center at AutoMax occur at a rate of

Calls to the service center at AutoMax occur at a rate of 27 per hour and follow a Poisson distribution. A single operator answers the calls and can handle an average 25 calls per hour with service ti...

See Answer

Q: Refer to the previous question. Suppose that Road Rambler’s phone system

Refer to the previous question. Suppose that Road Rambler’s phone system can only keep 4 calls on hold at any time, the average profit margin of each call is $55, and sales reps cost the company $12...

See Answer

Q: Suppose that arrivals to a queuing system with one server follow a

Suppose that arrivals to a queuing system with one server follow a Poisson distribution with an average of l 5 5 per time period, and that service times follow an exponential distribution with an aver...

See Answer

Q: Refer to questions 6 and 7 and answer the following questions:

Refer to questions 6 and 7 and answer the following questions: a. What is the probability that the drive-in window is empty? b. What is the probability that a customer must wait for service? c. On ave...

See Answer