Creating an Productivity Tracker for Team Members

[oosag23]

I want an excel file to track team members production vs. required production daily. Here are the variables....

1. A team member is required to produce 3x the value of his comp + payroll taxes + retirement comp

a) Employee hourly compensation: $20 x 7 hours = $140 + (7.65% of $140) + (Retirement contribution $50) = $200.71
b) Required production: $200.71 x 3 = 602.13
c) Team member is likely to work on multiple jobs a day. Each project has diff values.

I'm not sure how to go about this or how to format. Excel is a foreign language to me.

 

[Skybluekid]

How about the below

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
2								Projects
3		Team Member	Rate	Hours	Taxes	Retirement	Required	1	2	3	4	5	Total	Under/Over
4		A	20	7	10.71	50	602.13	300		225		340	865	Over
5		B	20	7	10.71	50	602.13	122	58	98	102	160	540	Under
6
Sheet1

Cell Formulas
Range	Formula
M4:M5	M4	=SUM(H4:L4)
N4:N5	N4	=IF(M4>G4,"Over","Under")
E4:E5	E4	=(C4*D4)*7.65%
G4:G5	G4	=((C4*D4)+SUM(E4:F4))*3