Rachel Cook is very concerned. Until recently, she has always had the golden touch, having successfully...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Rachel Cook is very concerned. Until recently, she has always had the golden touch, having successfully launched two start- up companies that made her a very wealthy woman. However, the timing could not have been worse for her latest start-up- a regional airline called Northwest Commuter that operates on the west coast of the United States. All had been well at the beginning. Four airplanes had been leased and the com- pany had become fairly well established as a no-frills airline providing low-cost commuter flights between the west coast cities of Seattle, Portland, and San Francisco. Achieving fast turnaround times between flights had given Northwest Com- muter an important competitive advantage. Then the cost of jet fuel began spiraling upward and the company began going heavily into the red (like so many other airlines at the time). Although some of the flights were still profitable, others were losing a lot of money. Fortunately, jet fuel costs now Flight Number 1257 2576 8312 1109 3752 2498 8787 8423 7922 5623 2448 1842 3487 4361 4299 1288 3335 9348 7400 7328 6386 6923 From Seattle Seattle Seattle Seattle Seattle Seattle Seattle Seattle Portland Portland Portland Portland Portland Portland Portland San Francisco San Francisco San Francisco San Francisco San Francisco San Francisco San Francisco are starting to come down, but it has become clear to Rachel that she needs to find new ways for Northwest Commuter to become a more efficient airline. In particular, she wants to start by dropping unprofitable flights and then identifying the most profitable combination of flights (including some new ones) for the coming year that could feasibly be flown by the four airplanes. To San Francisco Portland San Francisco San Francisco San Francisco A little over a decade ago, Rachel had been an honor gradu- ate of a leading MBA program. She had enjoyed the manage- ment science course she took then and she has decided to apply spreadsheet modeling to analyze her problem. The leasing cost for each airplane is $30,000 per day. At the end of the day, an airplane might remain in the city where it landed on its last flight. Another option is to fly empty overnight to another city to be ready to start a flight from there the next morning. The cost of this latter option is $5,000. Portland San Francisco Portland Seattle San Francisco San Francisco Seattle Seattle San Francisco Seattle Seattle The accompanying table shows the 22 possible flights that are being considered for the coming year. The last column gives the estimated net revenue (in thousands of dollars) for each flight, given the average number of passengers anticipated for that flight. Portland Seattle Seattle Portland Portland Seattle a. To simplify the analysis, assume for now that there is vir- tually no turnaround time between flights so the next flight Depart 8:00 AM 9:30 AM 9:30 AM 12:00 PM 2:30 PM 3:00 PM 5:00 PM 6:30 PM 9:00 AM 9:30 AM 11:00 AM 12:00 PM 2:00 PM 4:00 PM 6:00 PM 8:00 AM 8:30 AM 10:30 AM 12:00 PM 12:00 PM 4:00 PM 5:00 PM Arrive 10:00 AM 10:30 AM 11:30 AM 2:00 PM 4:30 PM 4:00 PM 7:00 PM 7:30 PM 10:00 AM 11:00 AM 12:30 PM 1:00 PM 3:00 PM 5:30 PM 7:00 PM 10:00 AM 10:00 AM 12:30 PM 2:00 PM 1:30 PM 5:30 PM 7:00 PM Expected Revenue ($000) 37 20 25 27 23 18 29 27 20 23 19 NNNNNNN 21 22 29 27 32 26 24 27 24 28 32 can begin as soon as the current flight ends. (If an immediate next flight is not available, the airplane would wait until the next scheduled flight from that city.) Develop a network that displays some of the feasible routings of the flights. (Hint: Include separate nodes for each half hour between 8:00 AM and 7:30 PM in each city.) Then develop and apply the corre- sponding spreadsheet model that finds the feasible combina- tion of flights that maximizes the total profit. b. Rachel is considering leasing additional airplanes to achieve economies of scale. The leasing cost of each one again would be $30,000 per day. Perform what-if analysis to determine whether it would be worthwhile to have 5, 6, or 7 airplanes instead of 4. c. Now repeat part a under the more realistic assumption that there is a minimum turnaround time of 30 minutes on the ground for unloading and loading passengers between the arrival of a flight and the departure of the next flight by the same airplane. (Most airlines use a considerably longer turnaround time.) Does this change the number of flights that can be flown? d. Rachel now is considering having each of the four airplanes carry freight instead of flying empty if it flies overnight to another city. Instead of a cost of $5,000, this would result in net revenue of $5,000. Adapt the spreadsheet model used in part c to find the feasible combination of flights that maxi- mizes the total profit. Does this change the number of air- planes that fly overnight to another city? Rachel Cook is very concerned. Until recently, she has always had the golden touch, having successfully launched two start- up companies that made her a very wealthy woman. However, the timing could not have been worse for her latest start-up- a regional airline called Northwest Commuter that operates on the west coast of the United States. All had been well at the beginning. Four airplanes had been leased and the com- pany had become fairly well established as a no-frills airline providing low-cost commuter flights between the west coast cities of Seattle, Portland, and San Francisco. Achieving fast turnaround times between flights had given Northwest Com- muter an important competitive advantage. Then the cost of jet fuel began spiraling upward and the company began going heavily into the red (like so many other airlines at the time). Although some of the flights were still profitable, others were losing a lot of money. Fortunately, jet fuel costs now Flight Number 1257 2576 8312 1109 3752 2498 8787 8423 7922 5623 2448 1842 3487 4361 4299 1288 3335 9348 7400 7328 6386 6923 From Seattle Seattle Seattle Seattle Seattle Seattle Seattle Seattle Portland Portland Portland Portland Portland Portland Portland San Francisco San Francisco San Francisco San Francisco San Francisco San Francisco San Francisco are starting to come down, but it has become clear to Rachel that she needs to find new ways for Northwest Commuter to become a more efficient airline. In particular, she wants to start by dropping unprofitable flights and then identifying the most profitable combination of flights (including some new ones) for the coming year that could feasibly be flown by the four airplanes. To San Francisco Portland San Francisco San Francisco San Francisco A little over a decade ago, Rachel had been an honor gradu- ate of a leading MBA program. She had enjoyed the manage- ment science course she took then and she has decided to apply spreadsheet modeling to analyze her problem. The leasing cost for each airplane is $30,000 per day. At the end of the day, an airplane might remain in the city where it landed on its last flight. Another option is to fly empty overnight to another city to be ready to start a flight from there the next morning. The cost of this latter option is $5,000. Portland San Francisco Portland Seattle San Francisco San Francisco Seattle Seattle San Francisco Seattle Seattle The accompanying table shows the 22 possible flights that are being considered for the coming year. The last column gives the estimated net revenue (in thousands of dollars) for each flight, given the average number of passengers anticipated for that flight. Portland Seattle Seattle Portland Portland Seattle a. To simplify the analysis, assume for now that there is vir- tually no turnaround time between flights so the next flight Depart 8:00 AM 9:30 AM 9:30 AM 12:00 PM 2:30 PM 3:00 PM 5:00 PM 6:30 PM 9:00 AM 9:30 AM 11:00 AM 12:00 PM 2:00 PM 4:00 PM 6:00 PM 8:00 AM 8:30 AM 10:30 AM 12:00 PM 12:00 PM 4:00 PM 5:00 PM Arrive 10:00 AM 10:30 AM 11:30 AM 2:00 PM 4:30 PM 4:00 PM 7:00 PM 7:30 PM 10:00 AM 11:00 AM 12:30 PM 1:00 PM 3:00 PM 5:30 PM 7:00 PM 10:00 AM 10:00 AM 12:30 PM 2:00 PM 1:30 PM 5:30 PM 7:00 PM Expected Revenue ($000) 37 20 25 27 23 18 29 27 20 23 19 NNNNNNN 21 22 29 27 32 26 24 27 24 28 32 can begin as soon as the current flight ends. (If an immediate next flight is not available, the airplane would wait until the next scheduled flight from that city.) Develop a network that displays some of the feasible routings of the flights. (Hint: Include separate nodes for each half hour between 8:00 AM and 7:30 PM in each city.) Then develop and apply the corre- sponding spreadsheet model that finds the feasible combina- tion of flights that maximizes the total profit. b. Rachel is considering leasing additional airplanes to achieve economies of scale. The leasing cost of each one again would be $30,000 per day. Perform what-if analysis to determine whether it would be worthwhile to have 5, 6, or 7 airplanes instead of 4. c. Now repeat part a under the more realistic assumption that there is a minimum turnaround time of 30 minutes on the ground for unloading and loading passengers between the arrival of a flight and the departure of the next flight by the same airplane. (Most airlines use a considerably longer turnaround time.) Does this change the number of flights that can be flown? d. Rachel now is considering having each of the four airplanes carry freight instead of flying empty if it flies overnight to another city. Instead of a cost of $5,000, this would result in net revenue of $5,000. Adapt the spreadsheet model used in part c to find the feasible combination of flights that maxi- mizes the total profit. Does this change the number of air- planes that fly overnight to another city?
Expert Answer:
Related Book For
Introduction to Management Science A Modeling and Cases Studies Approach with Spreadsheets
ISBN: 978-0078024061
5th edition
Authors: Frederick S. Hillier, Mark S. Hillier
Posted Date:
Students also viewed these general management questions
-
Embassy Club Condominium, located on the west coast of Florida, is undertaking a summer renovation of its main building. The project is scheduled to begin May 1, and a September 1 (17-week)...
-
Flight 120 between Seattle and San Francisco is a popular flight among both leisure and business travelers. The airplane holds 112 passengers in a single cabin. Both a discount 7-day advance fare and...
-
Rachel Rey recently opened her own basketweaving studio. She sells finished baskets in addition to the raw materials needed by customers to weave baskets of their own. Rachel has put together a...
-
Explain how an increase in government expenditure will change the governments budget balance and the loanable funds market. The International Monetary Fund (IMF) reported that it acted effectively in...
-
The trial balance of Giambi Investment Advisers at December 31, 2012, follows: Adjustment data at December 31, 2012: a. Unearned service revenue earned during the year, $500. b. Supplies on hand,...
-
For each lettered space in the following table, determine the appropriate dollar amount: Total Quantity of Fixed Average Output, Cost Fixed Total Variable Variable Cost Total CostMarginal...
-
Choose three categories of stock or bond funds in which you think you might like to invest. Explain why you think they are good investments.
-
Compute FIFO, LIFO, and Average Cost some of the information found on a detail inventory card for Slatkin Inc. for the first month of operations is as follows. (a) From these data compute the ending...
-
Just Right Hair Stylists has begun the preparation of its worksheet as follows: (Click the icon to view the worksheet.) Year-end data include the following: (Click the icon to view the data.)...
-
Emily Jackson (Social Security number 765-12-4326) and James Stewart (Social Security number 466-74-9932) are partners in a partnership that owns and operates a barber shop. The partnerships first...
-
Sheridan Chemical Corporation produces an oil-based chemical product which it sells to paint manufacturers. In 2022, the company incurred $316,480 of costs to produce 36,800 gallons of the chemical....
-
Find the flow rate for an electro-osmotic flow in a tube of diameter \(5 \mu \mathrm{m}\) and length \(10 \mathrm{~cm}\) filled with an aqueous solution. The applied potential is \(1 \mathrm{kV}\)....
-
Analyze the problem of electro-osmotic flow with an additional imposed pressure gradient. Show that the volumetric flow rate can be expressed as \[Q=L_{11} \Delta \phi+L_{12} \Delta P\] where...
-
Verify that the current carried in electro-osmotic flow can be expressed as \[I=\int_{0}^{R} 2 \pi r v_{z} ho_{\mathrm{c}} d r\] Using this relation, derive an expression for the current in...
-
Solve the Debye-Hckel equation for circular pipes whose walls carry a surface potential of \(\phi_{0}\). Show that the potential is given by \[\phi=\phi_{\mathrm{s}} \frac{I_{0}(\kappa...
-
Find the streaming potential when a pressure drop of \(0.1 \mathrm{MPa}\) is applied to a liquid with a specific conductivity of \(0.0014 \mathrm{~S} / \mathrm{m}\). The surface charge is \(100...
-
Why doe Nayak say its important to "start with the pictures not with the numbers"? If the supply voltage in three phase delta connection is 400 V, Calculate phase voltage....
-
Subtract the polynomials. (-x+x-5) - (x-x + 5)
-
Consider the Think-Big Development Co. problem presented in Section 3.2, including the spreadsheet in Figure 3.3 showing its formulation and optimal solution. In parts a-g, use the spreadsheet and...
-
Read the referenced article that fully describes the management science study summarized in the application vignette presented in Section 1.3. Summarize the five major reasons given for why...
-
Weenies and Buns is a food processing plant that manufactures hot dogs and hot dog buns. They grind their own flour for the hot dog buns at a maximum rate of 200 pounds per week. Each hot dog bun...
-
Question: An aunt saw her eight-year-old nephew enter the room, remarked what a nice boy he was, and said, "I would like to take care of him now." She promptly wrote a note, promising to pay the boy...
-
Question: Rick is selling his espresso coffee maker. He sends Tamara an e-mail, offering to sell the machine for $350. Tamara promptly e-mails back, offering to buy the item for $300. She hears...
-
1. Interactive Data Corp. hired Daniel Foley as an assistant product manager at a starting salary of $18,500. Over the next six years, Interactive steadily promoted Foley until he became Los Angeles...
Study smarter with the SolutionInn App