For the purpose of your assignment, you can use the spreadsheet model provided t

For the purpose of your assignment, you can use the spreadsheet model provided t

For the purpose of your assignment, you can use the spreadsheet model provided to you as a starting point.
Evaluate SkyLine’s current policy. Note that because it is now only 10.5 days prior to the flight, the current policy utilizes the high-fare only. What is SkyLine’s expected revenue generated by the remaining 70 seats?
Propose at least two types of policy classes related to the activation of the two fares, and explain the rationale behind them. Note that the spreadsheet model allows you to set the opening and closing of fares for each time tick.
Propose an interesting metric that relates to your performance vis-à-vis the market segment of the HV customers. Explain the rationale behind your choice.
Conduct an analysis of the policy classes you proposed above to identify an activation policy that can improve SkyLine’s expected revenue performance. Discuss potential challenges in the implementation of your recommended policy. Discuss all issues you think that SkyLine should consider if they choose to implement your proposal.
Using the policy classes you developed in question (2), construct a trade-off graph with expected revenue performance as the y-axis, and the metric you defined in question (3) above as the x-axis.