Problem 24-1: Compute gross pay. Using the information given for Archway Company, compute the employees' gross...

Problem 24-1: Compute gross pay.

Using the information given for Archway Company, compute the employees' gross pay for the payroll week ending July 14 and the year-to-date gross pay as of July 14. Employees receive time-and-a-half for overtime hours (fill in the shaded areas).

Employee Number	Hours Worked		Pay per Hour	Gross Pay	Year-to-Date Gross Pay
Employee Number	Regular	Overtime	Pay per Hour	Gross Pay	As of July 7	As of July 14
1	38	0	$16.80		$23,200.80
2	40	0	22.40		29,269.60
3	40	2	19.20		24,735.60
4	40	3	24.80		33,665.20
5	40	8	21.20		28,826.40
6	40	4	14.80		16,540.60

Expert Solution

Workings:

ekkarill92 answered 2 months ago

Calculate gross pay for each of the following employees of Launchpad Co. The company offers a...

Calculate gross pay for each of the following employees of Launchpad Co. The company offers a regular wage rate of $8.20/hour to all employees. Under an incentive plan in place for all employees, this rate increases for any employee who can meet weekly production goals. The increased rates and corresponding thresholds that must be met are as follows: $9.40/hour for producing at least 2,000 units $10.60/hour for producing at least 2,800 units $11.80/hour for producing at least 3,700 units $13/hour...

PSc 2-7 Calculate Gross Pay with Commissions Calculate gross pay for each of the following employees....

PSc 2-7 Calculate Gross Pay with Commissions Calculate gross pay for each of the following employees. All are paid an overtime wage rate that is 1.5 times their respective regular wage rates. NOTE: For simplicity, all calculations throughout this exercise, both intermediate and final, should be rounded to two decimal places at each calculation. 1: Dennis McDonald earns both $8.25/hour and a 11% commission on all sales. During the most recent week, he worked 44 hours and made total sales...

Using the attached template, you are to compute the gross pay, federal withholding, Social Security withholding,...

Using the attached template, you are to compute the gross pay, federal withholding, Social Security withholding, Medicare withholding and the net payment for this company. Assume there is no state income tax. Overtime is paid at a rate of 1.5 times the normal wage rate. NOTE: PLEASE DONT FORGET THE PIVOT TABLE! In addition, compute the total gross pay, federal withholding, Social Security withholding, Medicare withholding and net payment for all the employees. Further, create a pivot table indicating the...

The number of hours worked by 24 employees of a company is given below: 40 43...

The number of hours worked by 24 employees of a company is given below: 40 43 40 39 36 44 40 39 39 52 27 50 41 47 40 48 38 36 25 41 35 36 16 40 (a) (6 points) Calculate the mean, variance and standard derivation for the given data (b) (6 points) Calculate the three quartiles (Q1, Q2, and Q3) and the Interquartile range (IQR) (c) (4 points) Calculate the values of the lower fence and the...

Compute the deductions, net pay, and accumulated gross earnings for each weekly pay period. Assume that...

Compute the deductions, net pay, and accumulated gross earnings for each weekly pay period. Assume that Joseph is single and that $28.25 was withheld for medical insurance (pre-tax) and $20 for his United Way contribution. Use the wage bracket method to determine federal income tax. Round answers to the nearest hundredth. Gross Earnings(650.95) Allow.(1) Fed. Inc. Tax Social Security (6.2%)Medicare (1.45%) Medical Insurance Pre-tax United Way Total Deductions Net Pay Accum. Gross Earnings ($1,558.90)

Three employees in a company are up for a special pay increase. You are given a...

Three employees in a company are up for a special pay increase. You are given a file, say Ch3_Ex5Data.txt, with the following data: Miller Andrew 65789.87 5 Green Sheila 75892.56 6 Sethi Amit 74900.50 6.1 Each input line consists of an employee’s last name, first name, current salary, and percent pay increase. For example, in the first input line, the last name of the employee is Miller, the first name is Andrew, the current salary is 65789.87, and the pay...

Three employees in a company are selected for a pay increase. You are given a file...

Three employees in a company are selected for a pay increase. You are given a file (salaries.txt) that contains three lines. Each line in the file consists of an employee’s last name, first name, current salary, and percent pay increase. For example, in the first line, the last name of the employee is Miller, the first name is Andrew, the current salary is 65789.87 and the pay increase is 5%. Write a program that reads data from the file and...

Develop a Java application that determines the gross pay for each of three employees.

(Salary Calculator) Develop a Java application that determines the gross pay for each of three employees. The company pays straight time for the first 40 hours worked by each employee and time and a half for all hours worked in excess of 40. You’re given a list of the employees, their number of hours worked last week and their hourly rates. Your program should input this information for each employee, then determine and display the employee’s gross pay. Use class...

Compute the deductions, net pay, and accumulated gross earnings. Assume that Christina is married and that...

Compute the deductions, net pay, and accumulated gross earnings. Assume that Christina is married and that $40.50 (pre-tax) was withheld for medical insurance and $15 for union dues each week. Use the wage bracket method to determine federal income tax. Round answers to the nearest hundredth. Gross Earnings (786.95) Allow.(2) Fed. Inc. Tax Social Security Medicare Medical Insurance Union Dues Total Deductions Net Pay Accum. Gross Earnings 6.2% 1.45% Pre-tax $5,055.71

Your boss approaches you in mid-December and requests that you pay certain employees their gross pay...

Your boss approaches you in mid-December and requests that you pay certain employees their gross pay amount as if there were no deductions as their year-end bonuses. None of the employees have reached the Social Security wage base for the year. Required: What is the gross-up amount for each of the following employees? (The tax rate on bonuses is 22 percent. The Social Security (6.2%) and Medicare taxes (1.45%) must be added to this rate.) (Round your intermediate calculations and...

Question