Advertising Model (Learn under DR. TAN CHIN LUNG).xlsx

	B	C	D	E	F	G	H	I	J
1
2	Advertising model
3
4	Inputs
5	Exposures to various groups per ad
6		Revenge	SNF	The Simpsoms	SportsCenter	Homeland	Rachael Ray	CNN	TGW
7	Men 18-35	5	6	5	0.5	0.7	0.1	0.1	3
8	Men 36-55	3	5	2	0.5	0.2	0.1	0.2	5
9	Men >55	1	3	0	0.3	0	0	0.3	4
10	Women 18-35	6	1	4	0.1	0.9	0.6	0.1	3
11	Women 36-55	4	1	2	0.1	0.1	1.3	0.2	5
12	Women >55	2	1	0	0	0	0.4	0.3	4
13	Total exposures	21	17	13	1.5	1.9	2.5	1.2	24
14	Cost per ads	140	100	80	9	13	15	8	140
15	Cost per mil exposures	6.67	5.88	6.15	6.00	6.84	6.00	6.67	5.83
16
17		Revenge	SNF	The Simpsoms	SportsCenter	Homeland	Rachael Ray	CNN	TGW
18	Decision Variable	0	0	8	25	2	9	3	6
19
20	Objective, Min (Cost)	1890
21
22	Constraints	LHS	Sign	RHS
23	Men 18-35	73.1	>=	60
24	Men 36-55	60.4	>=	60
25	Men >55	32.4	>=	28
26	Women 18-35	60	>=	60
27	Women 36-55	61	>=	60
28	Women >55	28.5	>=	28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100