Question: Please use Bxcel what-if analysis or solver to solve the problems below. Problem 1: Ereeflight Airlines is presently operating at 70 percent of capacity. Management
Please use Bxcel what-if analysis or solver to solve the problems below. Problem 1: Ereeflight Airlines is presently operating at 70 percent of capacity. Management of the airline is considering dropping Freeflight's routes between Burope and the United States. If these routes are dropped, the revenue associated with the routes would be lost and the related variable costs saved. In addition, the company's total fixed costs would be reduced by 20 percent. Secmented incomectatements for a tumical month annear as follosis. Required: 2. To what extent the company can drop its current sales of the routes between Europe and the United States and still want to keep it? b. Should Freeflight drop the routes between Europe and the United States if the company expects its sales to be $2,500,000? How about $2,200,000
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
