sales associate	net sales	hours worked	wage per hour	commission%
frank	9796	38	7.75	2.0
gewn	9362	40	6.45	2.0
heather	6854	32	8.00	1.0
jason	5936	28	8.15	3.0
kathy	4815	20	8.00	3.0
lacey	7491	20	8.00	3.0
tracy	3796	42	6.35	1.9
olivier	5262	34	7.50	2.1
david	9154	30	8.75	1.5
joan	4453	28	6.45	3.0
kelly	6175	20	9.75	3.0
olivia	7321	20	8.00	3.3

Add columns to calculate the selling cost % for:

Each sales associate

For the entire department based on the data given below

Calculate %TTL of net sales for each sales associate (%TTL= Net sales for that employee/Total sales for the department)