im planning on opening a concept bar lounge that will be based on the Exchange market concept, means that ill have a computr in the bar recieving information from the selling point about number of beers and beverages sold. the price changes will be displayed on the screen.
before ill build the program itself i need a testing enviroment in order to find a good price\change relations.
i need to have a table in excel with around 10 items, each item will have
- number of orders entry(which i can change myself each time)
-description (the name of the beverage)
the idea is that every beverage sold will increase its price by 0.10 dollars, and reduce it 0.10 for all the other products.
for example if heiniken beer sold 10 times so its price will increase by 1$ and it will reduce 1$ from all the other beverages.
also i need to set a highest price in which if the item is reaching it its not longer reducing the price of other products in the list, but the other products will be able to reduces its price.
do you get what type of table i need?
its important me to be able to enter the entries myself, i just need the platform with the algorithms.
how much time will it take?