Develop a decision table to determine which aircraft option would maximize the expected value of profit contribution.

If you use excel please show your formulas.

I would prefer if it was done in excel.

An aitline has three different tywes of aircraft in thes thet. The seating capacity and operating costs for the three different aircalt ae as thown beiok: plane have larges incremertal costh, most notally ircluding the cost of tuel to toy the route. Under the tidumption ve are gors toithoose one of these tree ostions, we will uncre thele thsts. distredion shown below. The tirlort price is 3000 per sext and does not depend on which airualt is whed. An aitline has three different tywes of aircraft in thes thet. The seating capacity and operating costs for the three different aircalt ae as thown beiok: plane have larges incremertal costh, most notally ircluding the cost of tuel to toy the route. Under the tidumption ve are gors toithoose one of these tree ostions, we will uncre thele thsts. distredion shown below. The tirlort price is 3000 per sext and does not depend on which airualt is whed