Questions from Spreadsheet Modeling


Q: Blue Ridge Hot Tubs manufactures and sells two models of hot tubs

Blue Ridge Hot Tubs manufactures and sells two models of hot tubs: the Aqua-Spa and the Hydro-Lux. Howie Jones, the owner and manager of the company, needs to decide how many of each type of hot tub t...

See Answer

Q: The owner of the Weiner-Meyer meat processing plant wants to

The owner of the Weiner-Meyer meat processing plant wants to determine the best blend of meats to use in the next production run of hamburgers. Three sources of meat can be used. The following table s...

See Answer

Q: A new Italian restaurant called the Olive Grove is opening in a

A new Italian restaurant called the Olive Grove is opening in a number of locations in the Memphis area. The marketing manager for these stores has a budget of $150,000 to use in advertising and promo...

See Answer

Q: The city of Abingdon is determining its tax rate structure for the

The city of Abingdon is determining its tax rate structure for the coming year. The city needs to generate $6 million in tax revenue via taxes of property, sales, prepared food, and utilities. The fol...

See Answer

Q: The Royal Seas Company runs a three-night cruise to the

The Royal Seas Company runs a three-night cruise to the Caribbean from Port Canaveral. The company wants to run TV ads promoting its cruises to high-income men, high-income women, and retirees. The co...

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 plant...

See Answer

Q: The Way gate Corporation makes five different types of metal casing for

The Way gate Corporation makes five different types of metal casing for personal computers. The company is in the process of replacing its machinery with three different new models of metal stamping...

See Answer

Q: Is there an optimal solution to a GP or MOLP problem?

Is there an optimal solution to a GP or MOLP problem? Explain.

See Answer

Q: The central Florida high school basketball tournament pits teams from four different

The central Florida high school basketball tournament pits teams from four different counties against one another. The average distance (in miles) between tournament locations in each country is given...

See Answer

Q: Alaskan Railroad is an independent, stand-alone railroad operation not

Alaskan Railroad is an independent, stand-alone railroad operation not connected to any other rail service in North America. As a result, rail shipments between Alaska and the rest of North America mu...

See Answer