Waiter Sales Tracker
This project received 15 bids from talented freelancers with an average bid price of $344 USD.Get free quotes for a project like this
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.
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online