Closed

Waiter Sales Tracker

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.

Skills: Microsoft Access, Microsoft Exchange

See more: sales tracker excel waiters, want excel spread sheet, microsoft excel spread sheet, daily tracker, tips for customer service, microsoft share, microsoft customer service hours, customer service tips, i need sales staff, wine exchange, time tracker, share 5 tips, sales sheet, sales excel, need sales person, microsoft exchange service, liquor, exchange day, excel split sheet, track customers access, waiters, total share count, excel daily sales items, microsoft access quot, day average access

About the Employer:
( 0 reviews ) United States

Project ID: #4353253

13 freelancers are bidding on average $357 for this job

fastudiovw

I have 20+ years of experience programming ms-access, .net & sql server. At your disposal for any doubt or question, Regards Fabio

$480 USD in 20 days
(618 Reviews)
7.1
Prashantskin

Res.Buyer I have gone through your project requirements. I will develop your application of tracking sales produced by each member of your wait staff in Microsoft Access. Please see PMB for further details Regar More

$300 USD in 5 days
(453 Reviews)
6.9
rhomeu

This sounds good to me. We can develop the program in MS Access database.

$300 USD in 7 days
(38 Reviews)
6.5
jhaynes75

Professional software developer with over 13 years experience. Please see PM.

$350 USD in 7 days
(29 Reviews)
6.1
Premshanks

this is my proposal 1. waiters maintenace - add/edit/delete waiters 2. capture daily sales - split as food/beer/wine & voids & comps. 3. reports like avg sales , avg food/beverages cost etc., 4. commission More

$275 USD in 10 days
(179 Reviews)
6.0
kulhanekd

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

$300 USD in 3 days
(29 Reviews)
5.7
winnet21

Hi, I have experience with this project, I happily if work with you in this project. Best Regards

$380 USD in 10 days
(10 Reviews)
4.7
expertcoder1vw

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

$250 USD in 3 days
(7 Reviews)
4.1
MarlinSoftware

Hi, thank you for your specification. I have over 12 years experience building complex database systems in MS Access and could produce a functional and user friendly system that would match your project specification. More

$300 USD in 7 days
(2 Reviews)
3.2
haseebhm

I can help. Please attach the spreadsheet that you have written about.

$300 USD in 5 days
(4 Reviews)
3.1
www1980

Experienced MS Access and VBA developer. Ready to help you with this project.

$300 USD in 10 days
(4 Reviews)
2.7
paris2785

Consider it done

$449 USD in 5 days
(0 Reviews)
0.0
nawazwasif

Respectable, My name is Muhammad Nawaz. I have spent 15 years of experience in IT field. But on Freelancer.com it will be my 12th project. My services are in internet campaigning, managing emails, contacts, research More

$280 USD in 20 days
(0 Reviews)
0.0
SteveP495

Big banks and finance firms are some of my past clients for Access and Excel VBA work. PM info will back up my claims. SteveP.

$500 USD in 5 days
(0 Reviews)
0.0
vickkey7

I am ready to start this project...... thanks

$400 USD in 3 days
(0 Reviews)
0.0