Closed

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
Employer working
Project Budget
N/A
Total Bids
15
Project Description

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online