Questions from Spreadsheet Modeling


Q: Paul Bergey is in charge of loading cargo ships for International Cargo

Paul Bergey is in charge of loading cargo ships for International Cargo Company (ICC) at the port in Newport News, Virginia. Paul is preparing a loading plan for an ICC freighter destined for Ghana. A...

See Answer

Q: A winery has the following capacity to produce an exclusive dinner wine

A winery has the following capacity to produce an exclusive dinner wine at either of its two ineyards at the indicated costs: Four Italian restaurants around the country are interested in purchasing...

See Answer

Q: Acme Manufacturing makes a variety of household appliances at a single manufacturing

Acme Manufacturing makes a variety of household appliances at a single manufacturing facility. The expected demand for one of these appliances during the next four months is shown in the following tab...

See Answer

Q: Carter Enterprises is involved in the soybean business in South Carolina,

Carter Enterprises is involved in the soybean business in South Carolina, Alabama, and Georgia. The president of the company, Earl Carter, goes to a commodity sale once a month where he buys and sells...

See Answer

Q: Home Sweet Home Appliances manufactures specialty kitchen appliances at its factory in

Home Sweet Home Appliances manufactures specialty kitchen appliances at its factory in Hoover, Alabama. Presently, the company is preparing to deliver custom refrigerators and dishwashers to distribut...

See Answer

Q: Use Solver to create a Sensitivity Report for question 13 at the

Use Solver to create a Sensitivity Report for question 13 at the end of Chapter 3 and answer the following questions: a. If the company could get 50 more units of routing capacity, should they do it?...

See Answer

Q: The Dot Com Corporation is implementing a pension plan for its employees

The Dot Com Corporation is implementing a pension plan for its employees. The company intends to start funding the plan with a deposit of $50,000 on January 1, 2022. It plans to invest an additional $...

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

Q: Brue Lee is the Vice President of Purchasing for the consumer electronics

Brue Lee is the Vice President of Purchasing for the consumer electronics division of the Major Electric Corporation (MEC). The company recently introduced a new type of video camcorder that has taken...

See Answer

Q: Use Solver to create a Sensitivity Report for question 14 at the

Use Solver to create a Sensitivity Report for question 14 at the end of Chapter 3 and answer the following questions: a. Is the solution degenerate? b. Does the problem have alternate optimal solution...

See Answer