Question

The following given set of data shows a set of 15-minute kW demands for four customers over a 24-hour period. A 25kVA single-phase transformer serves all the customers.

(a) Find the maximum 15-minute demand for each customer and the average 15-minute demand for each customer

(b) Find the total kWh usage and the load factor for each customer.

(c) For the 25kVA transformer, compute the maximum 15-minute coincident demand, the maximum 15-minute non-coincident demand and the load diversity.

Time	Cust #1	Cust #2	Cust #3	Cust #4
	kW	kW	kW	kW
0:15	0.56	3.16	2.4	1.28
0:30	0.52	4.48	3.04	1.76
0:45	0.48	4.48	3.36	1.12
1:00	4.24	4.68	2.56	2.4
1:15	0.48	4.12	2.56	0.64
1:30	0.48	3.04	2.4	1.28
1:45	0.56	2.56	2.08	2.4
2:00	0.48	2.96	2.08	0.96
2:15	0.48	2.4	2.24	0.96
2:30	0.56	0.4	1.6	1.92
2:45	0.44	0.56	1.6	1.28
3:00	0.52	0.72	0.96	2.08
3:15	0.52	0.4	0.64	1.76
3:30	0.48	0.6	0.48	1.92
3:45	0.52	0.48	1.12	0.48
4:00	0.48	0.12	0.96	2.24
4:15	0.48	0.52	0.32	1.12
4:30	0.52	0.6	0.64	1.76
4:45	0.52	0.2	1.92	0.8
5:00	0.44	0.32	2.24	1.6
5:15	0.52	0.6	1.76	2.08
5:30	0.84	0.36	2.24	0.32
5:45	4.44	0.2	2.24	2.08
6:00	0.68	0.56	1.44	1.28
6:15	0.56	0.48	1.6	1.76
6:30	0.56	0.16	1.28	0.64
6:45	0.56	0.52	0.8	1.76
7:00	0.52	1.68	2.72	1.92
7:15	0.48	0.96	1.28	0.32
7:30	0.72	1.2	1.44	2.08
7:45	1.48	1.44	1.28	1.12
8:00	2.12	1.04	2.88	2.4
8:15	0.88	1.04	2.56	0.8
8:30	2.44	1.4	2.08	2.24
8:45	0.88	1.08	1.44	2.16
9:00	1	1.08	1.92	1.44
9:15	0.92	2.52	1.28	1.44
9:30	5.2	2.76	0.96	1.92
9:45	1.04	2.24	0.64	1.12
10:00	6	4.88	0.32	0.8
10:15	11.52	2.28	1.6	2.56
10:30	11.44	6.2	3.04	0.96
10:45	4.2	7.04	4.64	0.96
11:00	10.16	3.8	3.68	1.92
11:15	4.52	3.36	3.68	1.28
11:30	9.04	2.08	3.04	1.76
11:45	12.68	6.2	3.2	0.8
12:00	8.36	6.48	3.8	2.24
12:15	8.8	3.92	4.96	1.92
12:30	2.64	4.04	4.32	1.92
12:45	9.6	2.04	2.72	1.48
13:00	5.12	4.84	1.6	5.52
13:15	3.68	5.08	2.24	3.52
13:30	10.4	3.48	2.56	3.52
13:45	4.88	2.52	2.24	0.8
14:00	5.96	2.28	2.88	1.44
14:15	9.48	2.84	4.16	2.24
14:30	2.28	1.8	4.16	0.8
14:45	7.64	1.56	4	1.44
15:00	7.4	1.8	3.36	1.76
15:15	1.76	1.76	4.16	1.44
15:30	9.64	1.88	4.16	2.24
15:45	5.08	4.08	3.2	0.16
16:00	5.8	5.84	2.56	2.08
16:15	10.16	5.32	2.56	1.92
16:30	5	3.64	3.04	1.12
16:45	5.92	4.16	8.64	1.6
17:00	8.8	4.96	11.04	1.44
17:15	2.12	3.16	7.04	1.6
17:30	9.48	7.08	7.68	2.4
17:45	7.16	5.08	6.08	0.8
18:00	6.04	3.12	4.32	1.12
18:15	9.88	6.56	5.12	2.24
18:30	4.68	6.88	6.56	1.12
18:45	5.12	3.84	8.48	2.24
19:00	10.44	4.44	4	1.12
19:15	3.72	8.52	3.68	0.96
19:30	8.72	4.52	0.32	2.56
19:45	10.84	2.92	3.04	1.28
20:00	6.96	2.08	2.72	1.92
20:15	6.6	1.48	3.2	1.12
20:30	7.04	2	4.16	1.76
20:45	6.6	1.89	4.96	2.72
21:00	1.88	1.64	4.32	2.4
21:15	9.88	1.72	4.64	1.76
21:30	3.56	2	7.2	1.44
21:45	4.28	1.84	4.96	1.44
22:00	6.36	1.6	3.68	2.4
22:15	2.2	1.84	3.2	0.8
22:30	9.08	2.04	3.52	1.12
22:45	2.4	2	3.2	2.56
23:00	3	1.84	3.36	1.12
23:15	3	2.72	2.56	1.44
23:30	0.48	1.44	2.4	1.6
23:45	0.48	0.32	3.2	1.12
24:00:00	0.56	0.44	3.04	2.56

Answer 1