I want to input the number of daily customers and the daily sales produced by each member of my wait staff (sales person). The sales I need to track are for their total sales, their Liquor Beer and Wine Sales seperatley. I also want to enter the number of Voids (errors made) and Comps (dollar amount of food given away due to poor service). I want to be able to get a "per Customer" average on all items so for example; Sales divided by Customer count = Avg Chk per Customer. I would like to be able to enter data on a daily basis and retreive Waiters info over a period of time that I can specify (monthly quarterly, etc).
Lastly, I need to be able to calculate two different percentages of their sales (1.5% and 3%) which must be calculated to determine their share of tips for that given day. I need that amount to be divided amongst the Host and Bar staff.I divide this up amongst the Host and Bar stafff based on the number of hours worked, for example I will have a sheet for today with Host 1 working 4hrs and Host 2 working 6 hrs so it would be split 40% and 60% respectivley.
I have attached the Excel Spread sheet we use currently (which we over write daily.
13 freelancers are bidding on average $357 for this job
I have 15 years exp in custom access database developments and design. I am confident I can build the firms you need to see the data the way you want to see it. Donna
I'm an expert Access and database programmer and can develop the database for data-input and reporting as per your stated requirements. I can deliver in 3 days. Thank you for considering my bid. Bests, Larry