I need to have an SIMPLE Excel worksheet created that can calculate the breakdown of pay for my employee including the bonus.
Employee is paid bi-monthly with a base pay and a bonus calculated at the end of the month based on the average production per day.
Base pay is $650 per day
Training days are also paid at $650 per day
I have provided all calculations. They just need to input into excel as formulas so that when I INPUT the 4 criteria, I get an 4 outputs.
The following will be the 4 INPUT criteria :
1. Pay Period 1 - days worked: "___"
2. Pay Period 2 - days worked: "___"
3. Training days: "___"
4. Total production for the month: "$"
This will be the 4 OUTPUTs:
1. "Average production per day": $PRODUCTION/total days worked = $____ per day
2. "Pay per day": Calculated depending on the average production per day.
Using the below table: The average production per day will fall in one of the below tiers. Calculate the percent pay for that tier, and add the tiers above to calculate the total pay per day.
A) 0----->$2407, then pay at 27% of this tier (27% of 2407=$649.89)
B) $2408----->$3050, then pay at 29% at this tier (29% of (3050-2408)=$186.18)
C) $3051----->$3693, then pay at 31% at this tier (31% of (3693-3051)=$199.02)
D) $3694 and up, then pay at 34% at this tier (34% of (X-3694)= _____)
3. Total Monthly pay: (Pay per day) X (total days worked) + (training days x 650)= $____
4. Bonus calculated: (Total monthly pay ) - (total day worked x 650)=
Example 1:
INPUT
1. Pay Period 1 - days worked: "5"
2. Pay Period 2 - days worked: "5"
3. Training days: "2"
4. Total production for the month: "$40,000"
This will be the OUTPUT:
1. "Average production per day": $40,000/10 total days = $4,000 per day
2. "Pay per day": Calculated depending on the average production per day.
Using the below table: The average production per day will fall in one of the below tiers. Calculate the percent pay for that tier, and add the tiers above to calculate the total pay per day. SINCE $4,000 FALLS IN THE LAST TIER (D), CALCULATE THE TOTAL FOR THAT TIER(D) AND ADD THE REST OF THE TIERS (D+C+B+A).
A) 0----->$2407, then pay at 27% of average per day (27% of 2407=$649.89)
B) $2408----->$3050, then pay at 29% (29% of (3050-2408)=$186.18)
C) $3051----->$3693, then pay at 31% (31% of (3693-3051)=$199.02)
D) $3694 and up, then pay at 34% (34% of (***$4,000*** - 3694)= $104.04)
***THEREFORE TOTAL PAY PER DAY= $104.04+199.02+186.18+649.89= *$1,139.13*
3. Total Monthly pay: ($1,139.13) X (10) + (2 training days x 650)= $12,691.30
4. Bonus calculated: (Total monthly pay:12,691.30 ) - (10 days x 650)= $6,191.30
Example 2:
INPUT:
1. Pay Period 1 - days worked: "6"
2. Pay Period 2 - days worked: "6"
3. Training days: "1"
4. Total production for the month: "$36,000"
This will be the OUTPUT:
1. "Average production per day": $36,000/12 total days = $3,000 per day
2. "Pay per day": Calculated depending on the average production per day.
Using the below table: The average production per day will fall in one of the below tiers. Calculate the percent pay for that tier, and add the tiers above to calculate the total pay per day. SINCE $3,000 FALLS IN TIER (B), CALCULATE THE TOTAL FOR THAT TIER AND ADD THE REST OF THE TIERS (B+A)
A) 0----->$2407, then pay at 27% of average per day (27% of 2407=$649.89)
B) $2408----->$3050, then pay at 29% (29% of (**3000**-2408)=$171.68)
***THEREFORE TOTAL PAY PER DAY= $171.68+649.89= *$821.57*
3. Total Monthly pay: ($821.57) X (12) + (1 training days x 650)= $10,508.84
4. Bonus calculated: (Total monthly pay:8,620.36 ) - (12 days x 650)= $2,708.84
Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene
PS. The task is done. Please check screenshots below:
[login to view URL]
[login to view URL]
$30 USD en 1 día
5,0 (248 comentarios)
6,4
6,4
80 freelancers están ofertando un promedio de $127 USD por este trabajo
Hi, my name is Sevinc. I am 5-star excel and vba coding expert here at freelancer.com. Pls check my profile and feedbacks first to have some idea about the quality of my previous business. I had many similar excel/vba tasks, incl automated calculations and reports in excel, all achieved with 5/5 rating. I read your excel roject descriptions carefully before bidding. Thank you for detailed explanations... I got what you need and ready to go ahead as soon as we can clarify further project details. Kindly get back to me if you wish to proceed with a top-rated and reliable partner here...pls note that I only deliver best quality at a reasonable price, and I am open for longterm partnerships, if you wish too. I bid my best and awaitingy our replies.....regards.
You dont need to recruit me now. Just drop me a message so that we can discuss further about pricing and job details.
I have a 5,5 years of business analyst experience in a global company and 2,5 years data scientist experience in a game company before my freelancer career. Excel is my legs and arms. I can make any reporting, formulas, pivot tables, macros etc.
**NOTE: I am not a comissioner like "some guys" here around. I do the job myself with highest attention to the detail. Please consider this while awarding your job to those "middlemen".
Thanks,
I m not sure if you already selected freelancer, but just in case you didn't, feel free to contact me. I already finished your project. So just pm and i will send you worksheet to test. I m serious freelancer and i've never took a single dollar unless my solution was perfect.
Thanks, Milan
Hi: I have a quick question: Do you want a simple worksheet or want it to be more professional looking with check boxes, button, etc.? Please note that I have 100% completion rate and 5-star feedback on all projects (>75 total completed projects). More than 80% of my completed projects are related to Excel and Macro (VBA). Please check my profile to confirm the quality of my work. Please connect with me to discuss more.
Hi, I can do this job efficiently. I have more than 10 years of experience in this filed. I am flexible about working time and money. I believe work speaks better than words. Hope to have a positive response. Good day, Anamika
Hi,
The requirements are very clear.I am interested to work in this project. I can complete the excel with in a day for $45.I will use the excel functions to calculate the pay.
Please confirm me to start the work.
Thanks,
Rajesh
I possess excellent Data Analysis, Quantitative Analyses, and Statistical Analyses skills using both Excel and SPSS. As a lecturer, researcher, and academic writer, I have attained utmost discipline in completing all my tasks: delivering quality work has always been my endeavor. You can put my words to test. Customer satisfaction has and will always been my ultimate goal.
Hi, I am really interested to apply and would like to know more about this job. I can start right away after being awarded for this project. Hoping to hear from you soon. Thank you. :)
Hi,
This is Santhosh from India. I am a Business Management Graduate with Computer Science engineering background who is passionate about Data, Mathematics and Technology.
I have worked in few data analytics projects involving SAS & R. Also I have worked on many projects involving Excel (Pivot Table, Macros) and VBA.
I believe I have enough expertise to complete this project as per your requirement. I am sure that you will be 100% satisfied with my work. Please get in touch. Looking forward to hear from you.
Thanks & Regards,
Santhosh Kanna
I am experienced data entry specialist and VBA programmer. I can create the formulas but also a data entry forms if needed. All the task will be according to the presented requirements.
Hi sir!
I'LL FINISH THIS IN MAX 2 days...
I'm a hard-worker, persevent and a meticulous person. i can quaranty 100% satisfaction and good comunication.
I have 5 years experience and all necesary skils in excel, and this files is quite simple, just than it need a very meticulous persone, with a good eye, to track exactly all your requests
I offer unlimited revisions (within reason), so I will work until you are 100% satisfied.
Hope to hear you with good news!
PM first...
Have a nice day,
Denisa Elena
I'm programmer/developer. Expert in excel/macro.
I have reviewed your details.
I can create salary system for your employee easily.
I have worked on Payroll systems and it won't be issue for me
Thanks
I had made your project as per your example.
I have good knowledge in MS Excel. You may contact with me regarding this project..
Description Amount
Pay Period 1 $7.00
Pay Period 2 $7.00
Training Days $2.00
Total Production per month $30,000.00
Base Pay $650.00
Training Days Pay $650.00
1. "Average production per day"= $2,142.86
2. "Pay per day"
A) 0----->$2407, then pay at 27% of average per day (27% of 2407=$649.89) $649.89
B) $2408----->$3050, then pay at 29% (29% of (3050-2408)=$186.18) $186.18
C) $3051----->$3693, then pay at 31% (31% of (3693-3051)=$199.02) $199.02
D) $3694 and up, then pay at 34% (34% of (***$4,000*** - 3694)= $104.04) $104.04
"Pay per day" = $649.89
3. Total Monthly pay: ($1,139.13) X (10) + (2 training days x 650)= $12,691.30 $10,398.46
4. Bonus calculated: (Total monthly pay:12,691.30 ) - (10 days x 650)= $6,191.30 $1,298.46
Greetings!
"THE EXCEL is READY with the specified calculation."
"I request you to start the chat as I cannot start a chat with an Employer"
Start the chat. I will attach and send the excel in the Chat. If you think it is perfect, then only HIRE me and Pay me. I assure you that you will be impressed with work. It is perfectly what you want.
I take this opportunity to introduce myself as a highly talented Accountant and Analyst with strong technical knowledge and with an experience in the areas of Accounting, Algorithm, Audit and Business Analysis.
With the Degrees in Engineering and MBA, I am specialized in Logical approaches and simplifying day to day business processes. With specialization in Excel and other Microsoft Office tools, I can provide the best reports merging different data from different reports exported from the software. If you need Customer/Vendor/Stock Analysis incorporating all data from different reports, then just hire me
Sending customized mails or printing customized letters using Mail merge, or Business Reporting and Analysis or Presentations or Documentation or preparing some daily used templates like Invoice , I am one of the finest choices you can have. If your software cannot give you the right FIFO / LIFO adjustments for stocks / bills adjustment / ageing reports, then I'm the best choice
Give me an opportunity.
I assure you that you will be impressed with work.
I assure you that the EXCEL FILE with specified inputs and output is READY.
Dear Employer
Would love the opportunity to work for you on your project.
Please see my extensive Freelancer Profile and employer feedback, which can be viewed here:
https://www.freelancer.com/u/Snap2Art.html
Please note that the indicated time allocation is to ensure proper communication and customer satisfaction. In most cases work is completed well in advance.
The milestone is set to 100%, to be set up before acceptance of the award but can only be released by you on final completion to your satisfaction.
***** Some remarks from my 5* employers (see my portfolio) *****
“Great freelancer. Will definitely use again!!! ” (USA)
“ Excellent to deal with, understood exactly what I wanted done and changes we required, will be using him again (No hesitation). Six stars all round ” (AUS)
“ Charl is the one person that now has all my business. ” (USA)
“ Wonderful work, would definitely recommend Charl. ” (Canada)
“Very happy .. Brilliant !!” (AUS)
“Snap2Art exceeded my expectations substantially! Very, very impressed. ” (UK)
“ A man of many talents, creative thinking and great communications. Working with Charl is a blessing. ” (UK)
“110% - Fantastic - Exceptional - Thank You Charl” (USA)
“ Work was done very fast, we got exactly what we were looking for! ” (Kazakhstan)
Hope you will grant me the opportunity to render my services to you.
Charl
Hello, i am interesting with your request
My basic is egineerng, and i am very familiar with excel and what do you need
and I also have a lot of time to complete your project
please message me if you want talk anymore
thanks
