Questions from Spreadsheet Modeling


Q: Radmore Memorial Hospital has a problem in its fluids analysis lab.

Radmore Memorial Hospital has a problem in its fluids analysis lab. The lab has three machines available that analyze various fluid samples. Recently, the demand for analyzing blood samples has incre...

See Answer

Q: Sam Ellis is worried. As president and CEO of Forward Software

Sam Ellis is worried. As president and CEO of Forward Software, Sam introduced a new spreadsheet product, Cinco, to the market last year. Forward Software has been developing and marketing high-qualit...

See Answer

Q: Virginia Tech operates its own power generating plant. The electricity generated

Virginia Tech operates its own power generating plant. The electricity generated by this plant supplies power to the university and to local businesses and residences in the Blacksburg area. The plan...

See Answer

Q: The Pitts Barbecue Company makes three kinds of barbecue sauce: Extra

The Pitts Barbecue Company makes three kinds of barbecue sauce: Extra Hot, Hot, and Mild. Pitts’ vice president of marketing estimates that the company can sell 8,000 cases of its Extra Hot sauce plus...

See Answer

Q: The Pelletier Corporation has just discovered that it will not have enough

The Pelletier Corporation has just discovered that it will not have enough warehouse space for the next five months. The additional warehouse space requirements for this period are listed in the follo...

See Answer

Q: The Sentry Lock Corporation manufactures a popular commercial security lock at plants

The Sentry Lock Corporation manufactures a popular commercial security lock at plants in Macon, Louisville, Detroit, and Phoenix. The per unit cost of production at each plant is $35.50, $37.50, $39.0...

See Answer

Q: A paper recycling company converts newspaper, mixed paper, white office

A paper recycling company converts newspaper, mixed paper, white office paper, and cardboard into pulp for newsprint, packaging paper, and print stock quality paper. The following table summarizes the...

See Answer

Q: AutoMax is an online car retailer that supports its customers with a

AutoMax is an online car retailer that supports its customers with a live call center. The call center operates daily from 8:00 am to 9:00 pm. Call center employees work 9 hour shifts that may begin...

See Answer

Q: Ho wie Jones used the following information to calculate the profit coefficients

Ho wie Jones used the following information to calculate the profit coefficients for AquaSpasand Hydro- Luxes: pumps cost $225 each, labor costs $12 per hour, tubing costs $2 per foot. In addition to...

See Answer

Q: A variable that assumes an optimal value between its lower and upper

A variable that assumes an optimal value between its lower and upper bounds has a reduced cost value of zero. Why must this be true? (Hint: What if such a variable’s reduced cost value is not zero? Wh...

See Answer