Question

In excel please show formula of how you got the answer and equation.

You have the responsibility for making a report to help the company administrators to implement new employee's career plan, providing data to the investment/budget committee. So, you are managing the employee's payroll data from the new division of Data Research, created two years ago to provide the company departments (Marketing, Sales and Operations) with collection/analyze/update/report of real time market information, by making the calculation of their pay checks shown below. As the division's head, you want to demonstrate alternatives to justify the maintenance of 5.5% salary raise police to the administrators debate regarding the company's employees career plan, justifying the inclusion of Data Research division employees in the salary raise police. You have been asked to prepare a spreadsheet to put together the payroll data and summarizing the impacts of the actual salaries to the career plan in order to demonstrate the amount spent with the division, analyzing how the degradation of the salaries might impact in the retention of the division's employees and demonstrating to the board reasons to support/justify the improvement in the employee's compensations by include them the percent of the salary raise. The values shown are the total hours of each worker in the month and the value of the hour work for each one in the department and the total/average monthly values spent which department's workers, put your name in the indicated cell; a. Create a spreadsheet illustrating each employee's incomings/discounts data in the month. To do this, you will first enter the data shown in the figure below. Then compute the values of each columns/lines, for the monthly values as indicated below: 1 PAYROLL PAVOLL YOUR NAME & CLASS SECTION 3 LAST FIRST HOURS PAY GROSS TIME GROS 5 DeGlass Phil 6 Endime Nicole 7 Graw Marty 8 Daire Sunny 42 $13.50 35 12.50 50 13.25 32 16.75 Total 11 Average Salary Raise Request Analysis

Answer 1

PAYROLL
		Regular Hrs = 40						7.65%
Last	First	Hours	Pay	Overtime Hrs	Reg Gross	Over Time	Adj Gross	FICA	Net
DeGlass	Phil	42	13.50	2	540.00	40.50	580.50	44.41	536.09
Endime	Nicole	35	12.50	0	437.50		437.50	33.47	404.03
Graw	Marty	50	13.25	10	530.00	198.75	728.75	55.75	673.00
Daize	Sunny	32	16.75	0	536.00		536.00	41.00	495.00
Total					2,043.50	239.25	2,282.75	174.63	2,108.12
Average					510.88	119.63	570.69	43.66	527.03

I cannot attach the file