Overview
1.See attached a payroll data report for May 15th pay cycle.
a.Please create a distribution to the relevant account (marked in yellow) per department and location.
b.The employee Loren Q from the attached data has resigned, her last day will be May 22nd. Loren Q has a PTO balance of 2 days. Please describe the steps you should take to finalize her last payment and the calculation used to get to the final pay. Please refer also to the impact on her benefits, payroll, COBRA, etc.
2.Please describe the process of setting up a new hire - the documentation, communications and the steps to set them up in a payroll system. What information would you require from HR. What would the payroll look like for a new hire, and how would it be different than an existing employee.
3.In the attached excel file, you will find a list of all transactions that occurred in a company operating in the US over the period of 2015 to 2018, Year-to-date.
Each state has its own Sales Tax rate, which can differentiate between two products Similarweb sells – Subscription and Custom Reports.
a.Please describe the general process to determine in which state a company should charge sales tax, considering both existing legislation and latest rulings. For each state considered in the file, please describe the criteria for the creation of a nexus.
b.For each state which has taxable products, please create a separate spreadsheet, and calculate the following:
1.How many taxable transactions took place per year
2.Total sales tax charged per year, per product
3.Total overall sales tax liability for the state
Then, please summarize all data in a readable format and make sure to keep the excel organized, simple and efficient.