Questions from Spreadsheet Modeling


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 four calls on hold at any time, the average profit margin of each call is $55, and sales reps cost the company $1...

See Answer

Q: Several hundred PCs are in use at the corporate headquarters for National

Several hundred PCs are in use at the corporate headquarters for National Insurance Corporation. The pattern of breakdowns for these PCs follows a Poisson distribution with an average rate of 4.5 brea...

See Answer

Q: To determine the feasible region associated with less than or equal to

To determine the feasible region associated with less than or equal to constraints or greater than or equal to constraints, we graphed these constraints as if they were equal to constraints. Why is th...

See Answer

Q: A manufacturer of engine belts uses multipurpose manufacturing equipment to produce a

A manufacturer of engine belts uses multipurpose manufacturing equipment to produce a variety of products. A technician is employed to perform the setup operations needed to change the machines over f...

See Answer

Q: DeColores Paint Company owns 10 trucks that it uses to deliver paint

DeColores Paint Company owns 10 trucks that it uses to deliver paint and decorating supplies to builders. On average, each truck returns to the company’s single loading dock at a rate of three times p...

See Answer

Q: Bullseye department store is a discount retailer of general merchandise in the

Bullseye department store is a discount retailer of general merchandise in the southeastern United States. The company owns more than 50 stores in Florida, Georgia, South Carolina, and Tennessee that...

See Answer

Q: Vacations Inc. (VI) markets time-share condominiums throughout

Vacations Inc. (VI) markets time-share condominiums throughout North America. One way the company generates sales leads is by offering a chance to win a free mini-vacation to anyone who fills out an i...

See Answer

Q: The owner of Blue Ridge Hot Tubs, Howie Jones, has

The owner of Blue Ridge Hot Tubs, Howie Jones, has asked for your assistance analyzing how the feasible region and solution to his production problem might change in response to changes in various par...

See Answer

Q: PC-Express is a computer retail store that sells desktops and

PC-Express is a computer retail store that sells desktops and laptops. The company earns $600 on each desktop computer it sells and $900 on each laptop. The computers PC-Express sells are actually man...

See Answer

Q: An LP model can have more than one optimal solution. Is

An LP model can have more than one optimal solution. Is it possible for an LP model to have exactly two optimal solutions? Why or why not?

See Answer