Question

Employee	Project	Hours Week1	Hours Week2	Hours Week3	Hours Week4
Sophia	APC101	47	64	73	25
Isabella	APC101	33	72	73	46
Emma	APC101	33	51	44	53
Olivia	APC101	31	3	49	19
Ava	APC101	37	35	60	21
Emily	APC101	62	32	58	11
Abigail	APC101	37	65	47	77
Madison	FXCK301	33	40	12	50
Mia	FXCK301	15	49	5	57
Chloe	FXCK301	69	55	58	21
Elizabeth	FXCK301	46	60	7	38
Ella	FXCK301	38	58	77	25
Addison	FXCK301	14	55	28	38
Natalie	FXCK301	66	9	11	74
Lily	VERZ123	28	74	52	22
Grace	VERZ123	52	18	36	21
Samantha	VERZ123	25	67	56	46
Avery	VERZ123	76	49	43	50
Sofia	TMOB001	43	30	51	56
Aubrey	TMOB001	47	44	40	23
Brooklyn	TMOB001	6	3	40	35
Lillian	TMOB001	64	55	17	44
Victoria	TMOB001	42	57	41	27
Evelyn	TCK999	41	51	27	36
Hannah	TCK999	4	49	15	58
Alexis	TCK999	50	48	48	16
Charlotte	TCK999	58	55	33	19
Zoey	TCK999	51	46	8	34
John	STUB301	73	42	60	46
Nathan	STUB301	24	16	79	43
Lucas	STUB301	42	57	10	50
Christian	STUB301	51	56	34	79
Jonathan	STUB301	17	58	58	74
Caleb	STUB301	10	58	64	30
Dylan	VN095	22	51	50	52
Landon	VN095	51	41	59	40
Isaac	VN095	5	38	54	54
Gavin	VN095	53	41	54	10
Brayden	VN095	59	2	44	67
Tyler	VN095	65	47	7	53
Luke	VN095	48	5	9	41
Evan	VN095	58	52	26	56
Carter	VN095	2	38	57	20
Nicholas	VN095	44	54	65	6
Isaiah	VN095	67	50	26	75
Owen	VN095	48	32	19	48
Jack	GUA001	51	67	62	44
Jordan	GUA001	50	7	61	29
Brandon	GUA001	54	53	42	61
Wyatt	GUA001	63	73	26	17
Julian	GUA001	26	34	60	61
Aaron	GUA001	52	28	52	38
Jeremiah	DEF001	40	43	17	11
Angel	DEF001	75	31	17	44
Cameron	DEF001	10	58	40	62
Connor	DEF001	15	60	17	70
Hunter	DEF001	52	62	69	37
Adrian	DEF001	38	40	24	8

Employee	Employee ID	Rate per hour ($)
Aaron	1	94
Aarony	2	55
Abigail	3	21
Addison	4	60
Adrian	5	16
Alex	6	55
Alexis	7	44
Angel	8	55
Aubrey	9	46
Ava	10	79
Avan	11	44
Avery	12	69
Brand	13	55
Brandon	14	22
Brayden	15	95
Brooklyn	16	14
Caleb	17	37
Cameron	18	79
Carter	19	42
Charlotte	20	90
Chloe	21	65
Christian	22	42
Christianie	23	55
Connor	24	83
Connory	25	55
Dylan	26	12
Elizabeth	27	30
Ella	28	68
Emily	29	46
Emma	30	15
Evan	31	38
Evelyn	32	95
Evene	33	55
Gavin	34	72
Grace	35	95
Hannah	36	44
Hunter	37	94
Isaac	38	89
Isabell	39	11
Isabella	40	28
Isaiah	41	59
Jack	42	59
Jeremiah	43	98
John	44	50
Jonath	45	55
Jonathan	46	8
Jordan	47	76
Julian	48	92
Landon	49	33
Lillian	50	60
Lily	51	88
Lucas	52	18
Luke	53	16
Madison	54	77
Mia	55	12
Miana	56	33
Natalia	57	55
Natalie	58	28
Nathan	59	59
Nicholas	60	13
Olivia	61	55
Owen	62	71
Samantha	63	83
Sofi	64	55
Sofia	65	44
Sophia	66	54
Tyler	67	49
Victoria	68	22
Wyatt	69	75
Zoey	70	18

Project	Payments
STUB301	12,000
FXCK301	10,000
TCK999	10,000
VERZ123	10,000
FXCK301	9,000
GUA001	3000
TMOB001	10,000
STUB301	20,000
VN095	17,000
DEF001	35000
VN095	5,000
DEF001	5000
VN095	9,000
GUA001	23000
APC101	15000
TCK999	3,000
GUA001	8000
STUB301	16,000
DEF001	4000
FXCK301	10,000
VN095	15,000
STUB301	18,000
TCK999	15,000
VN095	13,000
FXCK301	10,000
TMOB001	10,000
GUA001	18000
APC101	5000
APC101	15000
TMOB001	10,000
VN095	11,000
FXCK301	1,000
VERZ123	10,000
VERZ123	10,000
GUA001	13000
DEF001	5000
TMOB001	10,000
VERZ123	10,000
VN095	7,000
TCK999	5,000
APC101	15000
APC101	25000
STUB301	14,000
DEF001	15000
DEF001	25000
STUB301	10,000
FXCK301	1,000
TCK999	10,000
APC101	5000
GUA001	28000
APC101	5000

	General question for the company:
1	How many projects does this company have?
2	What is the average total working hours per week for the whole company?
3	Who work the most during this 4 weeks? Report his/her ID (clearly it is not included in Working hours sheet but you have to find it)
4	Over this reporting period, who have the highest pay rate?
	Project level questions:
5	Which project have the highest revenue?
6	What is the total profit for the company over this reporting window?
7	What is the (%) gross profit margin for the whole company? If the answer is 25.23%, simply put 25.23 on Sakai
8	Which project posts the largest $ profit?
9	Which project posts the largest profit margin?
10	Which project posts the largest dollar loss?
11	Which project posts the lowest profit margin?
12	Report the (%) gross profit margin for project that have the highest margin. If the answer is 25.23%, simply put 25.23 on Sakai

Answer 1

Ans 1) The company have 9 projects. Ans 2) on calculatng all 4 weeks we find that total 9740 hrs have been worked weekly. Hence Average total working hours for the whole company is 9740/4 = 2185 hours.

Ans 3) Abigail is the employee who works the most in these 4 hours. He works for 226 hours in the span of 4 weeks.

Ans 4) Jeremiah has the highest pay rate. i.e. 98 dollars per hour.

Ans 5 ) in case of project GUA001 the revenue is 93000 which is the maximum revenue of an individua project.

Ans 6) Total profiit = Total revenue - total expense = 603000 - 516220 = 86780

Ans 7) Gross profit Margin = gross profit/ revenue *100 = 86780/603000*100 = 14.39

Ans 8) STUB 301 project gives the highest profit.

Ans 9) GUA 001 gives largest profit margin.

Ans10) TMOB 001 suffers the largest dollar loss.

Ans 11) TMOB001 gives the lowest profit margin.

Ans 12) APC 101 will have the highest gross profit margins among the projects.