The base ticket price for Cloudliner Airlines is determined by the distance traveled and the day of the week a passenger is traveling. In addition, the airline adjusts its ticket prices based on a number of categories. If the seats remaining are greater than 50 percent of capacity and the number of days before the flight is less than 7, the price is deeply discounted with a special Web offer for the flight. If the seats remaining are greater than 50 percent and the flight date is from 7 to 21 days in the future, there is a medium price discount.
If the seats remaining are greater than 50 percent and the number of days before travel are greater than 21, there is only a small discount. If the seats remaining are from 20 to 50 percent and the days before the flight are fewer than 7, the ticket has a medium discount. If the seats remaining are from 20 to 50 percent and the flight date is from 7 to 21 days in the future, there is a low discount for prices. If the seats remaining are from 20 to 50 percent and the number of days before travel are greater than 21, there is no discount.
If the seats remaining are less than 20 percent and the number of days before the flight is less than 7, the ticket has the highest increase in price. If the seats remaining are less than 20 percent and the flight date is from 7 to 21 days in the future, there is a large increase in price.
If the seats remaining are less than 20 percent and number of days before travel are greater than 21, there is a small increase in price. Develop an optimized decision table for the Cloudliner Airlines ticket price adjustment policies.