Questions from Spreadsheet Modeling


Q: Omega Airlines has several nonstop flights between Atlanta and Los Angeles every

Omega Airlines has several nonstop flights between Atlanta and Los Angeles every day. The schedules of these flights are shown in the following table. Omega wants to determine the optimal way of assi...

See Answer

Q: A residential moving company needs to move a family from city 1

A residential moving company needs to move a family from city 1 to city 12 in Figure 5.40 where the numbers on the arcs represent the driving distance in miles between cities. a. Create a spreadshee...

See Answer

Q: Union Express has 60 tons of cargo that needs to be shipped

Union Express has 60 tons of cargo that needs to be shipped from Boston to Dallas. The shipping capacity on each of the routes Union Express planes fly each night is shown in the following table Will...

See Answer

Q: The state of Virginia is one of the largest producers of wood

The state of Virginia is one of the largest producers of wood furniture in the United States, with the furniture industry accounting for 50% of value added to wood materials. Over the past 40 years th...

See Answer

Q: Joe Jones wants to establish a construction fund (or sinking fund

Joe Jones wants to establish a construction fund (or sinking fund) to pay for a new bowling alley he is having built. Construction of the bowling alley is expected to take 6 months and cost $300,000....

See Answer

Q: Telephone calls for the Yak Line, a discount long distance carrier

Telephone calls for the Yak Line, a discount long distance carrier, are routed through a variety of switching devices that interconnect various network hubs in different cities. The maximum number of...

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: E-mail messages sent over the Internet are broken up into

E-mail messages sent over the Internet are broken up into electronic packets that may take a variety of different paths to reach their destination where the original message is reassembled. Suppose th...

See Answer

Q: Refer to the equipment replacement problem discussed in Section 5-3

Refer to the equipment replacement problem discussed in Section 5-3 of this chapter. In addition to the lease costs described for the problem, suppose that it costs Compu-Train $2,000 extra in labor c...

See Answer

Q: The Britt’s & Estragon company manufactures small engines at three different plants

The Britt’s & Estragon company manufactures small engines at three different plants. From the plants, the engines are transported to two different warehouse facilities before bei...

See Answer