Suoritettu

Build Excel Spreadsheet Formula Calculations

I would like to create an expel spreadsheet that can calculate employee tip sharing. Each employee gets a certain percentage of tips. The tip share is outlined below. Each employee starts with the tip share outlined below but if they have disciplinary action they will lose tips. We want to track this with a point system. When employee lose points they will loose some of there tips.

Tip Share 100%

Tinter 1 25%

Tinter 2 25%

Tinter 3 25%

Shop Assistant 1 2.5%

Shop Assistant 2 2.5%

Sales 1 10%

Sales 2 10%

This is how we would like the point system to work

3 Employees called Tinter receive 75% of tips to be divided evenly. Each tinter receives 25% share of tips. All tinters are on a point system. They each start with 12 points. 12 points is equal to 25%. We should be able to reduce points and the tinters 25% share should be reduced also. For example if a tinter has 12 points they would receive 25% of tips. If a tinter has 0 points they would receive 0% of tips.

2 Employees called Shop Assistance receive 5% of tips to be divided evenly. Each shop assistance receives 2.5% share of tips. All shop assistance are on a point system. They each start with 12 points. 12 points is equal to 2.5%. We should be able to reduce points and the shop assistance 2.5% share should be reduced also. For example if a shop has 12 points they would receive 2.5% of tips. If a shop assistant has 0 points they would receive 0% of tips.

2 Employees called Sales receive 20% of tips to be divided evenly. Each sales receives 10% share of tips. All sales are on a point system. They each start with 12 points. 12 points is equal to 10%. We should be able to reduce points and the sales 10% share should be reduced also. For example if a sale has 12 points they would receive 10% of tips. If a sales has 0 points they would receive 0% of tips.

I have created a sample spreadsheet . We just want to be able to enter the total amount of tips collected and adjust points if necessary. The spreadsheet should do all calculations.

Can this be done?

Taidot: Excel, Tiedonsyöttö, Tietojenkäsittely, Tutkimusten kirjoitus, Rahoitus

Tietoa asiakkaasta:
( 98 arvostelua ) McDonough, United States

Projektin tunnus: #33775836

Myönnetty käyttäjälle:

PERPETUAL0

Hello there i can make the full system excel for tip calculation thats Ok Use VBA with Formula ?

$115 USD 2 päivässä
(136 Arvostelua)
5.8

38 freelanceria on tarjonnut keskimäärin $89 tähän työhön

saminakiran2

Hi Mate! I can assist you with this project related to Build Excel Spreadsheet Formula Calculations. I am experienced in Research Writing, Finance, Data Entry, Data Processing and Excel. I have completed many similar a Lisää

$100 USD 1 päivässä
(512 arvostelua)
8.2
AccountantArman

"Sir, You will get a spreadsheet I am Excel Advanced Level Expert. This is basic work for me. I can complete this project with added quality. About me I am a Chartered Accountant with more than 4 years of experience f Lisää

$120 USD 1 päivässä
(197 arvostelua)
6.6
maaria1991

Hi, Hope you are doing well. I can assist you in plagiarism free research writing as I have already done several related projects of research writing, report writing, ghost writing and copywriting. I have a master qua Lisää

$30 USD 1 päivässä
(147 arvostelua)
6.3
academicwrriter

Hello, I am a professional article, essay, research, and summary writer with experience of 7+ years. If you need a professional article, essay, research, or summary on any topic then you are exactly in the right place. Lisää

$30 USD 2 päivässä
(41 arvostelua)
6.0
(83 arvostelua)
6.4
(123 arvostelua)
6.4
SShtv

Hello, I am interested in your project. Your task is clear to me and I am ready to solve it. I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA. These Lisää

$150 USD 3 päivässä
(120 arvostelua)
6.5
(40 arvostelua)
5.5
HelpingDoor

Build Excel Spreadsheet Formula Calculations According to your given instructions I am the BEST CANDIDATE to complete this project. I have read all details in depth, please message me so we can finalize the deal. Lisää

$30 USD 1 päivässä
(102 arvostelua)
5.4
tbrifki64

Hi there, I would like to assist you. Kindly advise me for further instructions. Thank you very much. I will be waiting for your message.

$140 USD 5 päivässä
(32 arvostelua)
5.1
WritingLabb

Build Excel Spreadsheet Formula Calculations I am Minahil Hameed with a vast amount of experience in multiple fields like; Finance & Economics, Accounting & Cost Accounting, Business & Management, Taxation & Auditing. Lisää

$30 USD 1 päivässä
(65 arvostelua)
5.1
(10 arvostelua)
4.4
ACCASpogmai

"Sir, I am Excel Advanced Level Expert. This is basic work for me. I can complete this project with added quality. About me I am a Chartered Accountant with more than 4 years of experience from the worlds leading Acco Lisää

$50 USD 1 päivässä
(27 arvostelua)
4.1
prasitkeng

I read all of your requirements and attachment and I strongly believe that this project can be done within a couple of days. Your requirement can be fulfilled by simply completed with Excel formula or using VBA if you Lisää

$30 USD 3 päivässä
(2 arvostelua)
1.1
topacademictutor

Build Excel Spreadsheet Formula Calculations I have 13 years of experience in the Writing Industry and I can provide you with “SUPREME QUALITY WORK” within your “GIVEN DEADLINE” with “PERFECT GRAMMAR” and “ZERO PLAGIA Lisää

$30 USD 1 päivässä
(0 arvostelua)
0.0
Girishkumar90240

I am Girish Kumar Data entry professional. I have good speed and I do work without any mistake. My forte is, that I achieve targets.I

$110 USD 2 päivässä
(0 arvostelua)
0.0
mdmilonhossain36

Hi there , I will be able to edit your bid of the project. I have read your project details. My aim is to make provider happy with the use of my skills & honesty. You will give me document. I will complete your work. P Lisää

$130 USD 10 päivässä
(0 arvostelua)
0.0
AnaMaleencorsino

Hi there, As what you need in this kind of work, I am willing and assure you that I can help you validate some data and data entry in a form. I can manage work with efficient and productive results at the same time Lisää

$30 USD 7 päivässä
(0 arvostelua)
0.0
maryalayaay2

Customer service means a lot to me. Making sure that customers must feel that they are valued, they feel appreciated and that can be done through warm welcome with them. Customers service is also about making sure that Lisää

$140 USD 7 päivässä
(0 arvostelua)
0.0
munzmaqs

Calculation and analysis is something that i deal everyday as a customs broker. Plus i enjoy playing with numbers, so this task would be easy and enjoyable for me.

$140 USD 7 päivässä
(0 arvostelua)
0.0