Make a payroll sheet (example is included here but can create your own) that calculates the federal withholding tax, social security tax, state income tax of 5%, medicare tax and the net pay for each of the worker in your business. Figure out any other deductions that your workers may possibly have..

Assume the Social Security tax rate is 6.2% and the medicare tax rate is 1.45%. You had calculated your wages in Bahrain Dinars. You are required to convert those wages into USD.

2. Analyse your data by answering the following questions: Which employee had the largest net pay for the month?

Which employee had the highest percentage of take-home for the month?

What was the total amount of income taxes that were withheld from their wages?

Salary of the employees designation Method of salary Salary per month Name of the employee Zainab Senior Bank transfer 2000BHD manager Job description Job time period She will be reposnsible for 7 years managing the role and responsibilities of other employees, to ensure that the business operations are running efficiently diHe will be reposnsible for 5 years organizing, planning and completion of the specific project. and will also ensure that the projects are finished on time Ali Project Bank transfer 1200 BHD manager Talha 5 years Bank transfer 1300 BHD Amyrah Pay cheque 1000 BHD Anaya Pay cheque 1300 BHD Taif Bank transfer 1 BHD Creative Responsible for making layouts designer and designs for product illustrations Quality Quality control officer will look 7 years control officer after the quality of the products that is it up to standard. Finance Finance officer will manage the 4 years officer monetary transactions of the company. The officer will also be responsible for making, budget for the firm Marketing Will be responsible for creating 5 years officer different marketing strategies for the marketing of business in the competitive market. IT specialist He will look after the 3 years maintenance, implementation and monitoring of the marketing system Sales manager Sales manager will lead the | sales team by setting sale goals, sales quota and sale plans. Sales officer Sales officer will work under 4 years the guidance of sales manager to produce best possible sale strategies and plans Raza Bank transfer 1700 BHD Maria 5 years Pay cheque 1200 BHD Zohan Commission 700 BHD Rohan Sales man 2 years + monthly salary through pay cheque Commission + monthly salary through pay cheque Sales man will be responsible for selling the products to the customers 300 BHD