Your Sales and Service company has become so successful over the past months that you have decided to hire two part-time employees to assist you with sales and office duties. In researching your computerized accounting program, you have found that it does not include the options to perform payroll calculations and print paychecks. To computerize the payroll calculations and assist you in drafting the journal entries, you decide to use Microsoft Excel for the necessary payroll functions.

Complete the following using theModule 05Payroll Transactions Written Assignment template.

  

   

Transcribed Image Text:

Calculate payroll for Karen Rodriguez and Adam Seyd for the June 14th and June 28th payrolls. These employees are paid bi-weekly, meaning every other week. June 14 Payroll Karen Rodriguez Adam Seyd Total Gross Pay FICA Tax Federal Income Tax State Income Tax Net Pay June 28 Payroll Karen Rodriguez Adam Seyd Total Gross Pay FICA Tax Federal Income Tax State Income Tax Net Pay 2. Journalize the transactions necessary to record the payrolls. Calculate payroll for Karen Rodriguez and Adam Seyd for the June 14th and June 28th payrolls. These employees are paid bi-weekly, meaning every other week. June 14 Payroll Karen Rodriguez Adam Seyd Total Gross Pay FICA Tax Federal Income Tax State Income Tax Net Pay June 28 Payroll Karen Rodriguez Adam Seyd Total Gross Pay FICA Tax Federal Income Tax State Income Tax Net Pay 2. Journalize the transactions necessary to record the payrolls.