See below

q1_case_5_excel_spreadsheet.xls

Day Customers

Purchase	Purchase
Revenue	Cost	Night Avg. Rev. per purchase		Night Avg. Cost per purchase
35.29	29.00	30.52		23.25
29.66	22.20		Night Avg. Profit per purchase
30.87	21.01		7.27
31.40	25.60
25.95	21.95
28.69	19.42
28.82	22.89
29.92	20.07
30.15	22.39
27.89	19.99
31.30	25.63
33.44	26.51
27.49	22.36
29.91	22.26
47.78	34.08
32.43	25.81
25.20	16.86
32.99	23.54
21.90	16.19
42.19	31.88
28.48	22.12
39.20	33.09
28.52	19.76
32.15	23.24
30.81	23.79
32.61	22.68
25.29	21.51
26.07	20.27
19.35	16.50
29.90	25.07

Purchase	Purchase
Revenue	Cost	Total Avg. Rev. per purchase		Total Avg. Cost per purchase
27.50	20.89	29.43		22.25
30.22	22.90		Total Avg. Profit per purchase
34.99	27.40		7.18
18.08	13.53
34.48	25.32
25.55	17.17
19.77	15.49
25.13	18.11
26.16	21.91
29.67	22.75
27.37	22.03
35.71	26.61
28.07	20.31
38.86	26.51
40.88	33.39
37.31	26.83
31.69	26.89
38.59	25.51
26.38	20.55
27.09	18.66
21.78	14.93
21.39	15.38
28.84	19.96
27.39	22.24
20.29	14.72
16.11	11.41
22.60	19.23
32.79	22.50
33.37	26.00
22.14	18.31
35.29	29.00
29.66	22.20
30.87	21.01
31.40	25.60
25.95	21.95
28.69	19.42
28.82	22.89
29.92	20.07
30.15	22.39
27.89	19.99
31.30	25.63
33.44	26.51
27.49	22.36
29.91	22.26
47.78	34.08
32.43	25.81
25.20	16.86
32.99	23.54
21.90	16.19
42.19	31.88
28.48	22.12
39.20	33.09
28.52	19.76
32.15	23.24
30.81	23.79
32.61	22.68
25.29	21.51
26.07	20.27
19.35	16.50
29.90	25.07

Purchase Rev. - Purchase Cost