Our customer runs a tour agency. He has an excel spreadsheet containing the following information for people that have contacted them:
Customer name, country, tour duration (requested by customer), tour date, number of people in the tour (usually from 1 to 3), price given to the customer, answer: accepted/rejected (indicates if customer accepted or rejected the price given by the tour agency).
My customer wants a predictor or tool that can let him enter the details given by future customers, e.g:
Number of participants, Tour duration, Country (not sure if necessary?)
And the system will return the best price to charge the customer (so he won't reject the proposal but pay the maximum possible).
Another option would be that the tour agency owner will enter the price and the system will answer "Customer will accept that price" or "Customer will reject that price".
Is this even possible? I think it may be done using neural networks trained with the previous answers from customers that the tour agency owner has in his excel spreadsheet?