Question: can you help me answer this? The solution has to be done on excel so please mention the given and give details accordingly. Q6.3 (Philly

can you help me answer this? The solution has to be done on excel so please mention the given and give details accordingly. can you help me answer this? The solution has to
can you help me answer this? The solution has to
Q6.3 (Philly Air) Philly Air Inc. offers low cost air travel between Philadelphia and Atlantic City, Philly Air's invested capital is $5,000,000, corresponding to the investment in the two planes the company owns. Each of the two planes can carry 50 passengers. Each plane does 12 daily trips from Philadelphia to Atlantic City and 12 from Atlantic City to Philadelphia. The price is $100 for each one-way ticket. The current load factor is 70 percent (i.e., 35 seats are sold on the average flight). The annual cost of operating the service and running the business is $60,000,000 (including all costs, such as labor, fuel, marketing, gate fees, landing fees, maintenance, etc.). The company operates 365 days a year. a. Draw an ROIC (return on invested capital) tree for the company that incorporates all of the above information. [6.2] b. What is the current ROIC? [6.2] c. What is the minimum load factor at which the company breaks even? [6.3] d. What load factor would the company have to achieve so that it obtained a 10 percentage-point increase in the ROIC (e.g., an ROIC increasing from 5 percent to 15 percent)? [6.31

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!