With the recent crisis in the country's airline industry failing to meet customer needs and demand, Rise Airlines is re- evaluating its overbooking policy for its most common routes on their small aircraft. They have hired your team to perform a study of the cost of overbooking vs flying with empty seats using several types of demand distributions. They have provided your team with some information about their last 60 days of flites and cancellations as well as their estimates on demand. On average, a ticket sells for $200 and there are 50 seats on each aircraft. The fixed cost for running their operations is $100,000 per DAY and their variable cost of operations is $2,000 per flite, per day. Rise airlines has the current capacity to fly a mean of 15 flites a day with a standard deviation of 12. The minimum amount of flites they can fly per day and still maintain their gate space is 13 and the maximum they can fly before they run out of functional aircraft is 25. Management is requesting a study of their distributions, the breakeven point, SL and SO. Management would also like recommendations on which distribution should be used and what other factors they should consider. In order to prepare this analysis, you and your team have gathered information and will answer the following questions using excel, graphs, and the case study shell: A. What is the expression for total cost per month? Assume 30 days in the month B. What is the expression for total revenue per month? Assume 30 days in a month c. How many flites need to fly on a daily basis for Rise to breakeven? D. What percentage of Rise's total flite capability must be in the air that day? Hint- set these calculations up in excel to help make any graphics easier.