Construct a model use Solver when applicable to construct the model Case information: Last month the CEO of the Australian Banking Corporation (ABC), Pierre De Posit, had sat at his desk shuffling through endless reports and the graphs showing ABC’s dec

profileMichelle_Michy
20180227004343qbm__individual_assignment___australian_banking_corporation____raw_data2.xlsx
Home>Applied Sciences homework help>Construct a model use Solver when applicable to construct the model Case information: Last month the CEO of the Australian Banking Corporation (ABC), Pierre De Posit, had sat at his desk shuffling through endless reports and the graphs showing ABC’s dec

Focus Group Data

AUSTRALIAN BANKING CORPORATION (ABC)
Potential Online Advertising Sites
$5,500 $7,000 $7,200 $5,000 $5,500 $3,000 $3,000 $3,300 $2,900 $4,250
A B C D E F G H I J
Surveyed Focus Group 1 0 0 0 0 0 0 0 0 0 1
2 1 0 0 1 0 0 0 0 0 0
3 1 0 0 0 0 0 0 0 0 0
4 0 1 1 0 0 0 0 0 0 0
5 1 0 0 0 1 1 0 0 0 0
6 1 0 1 0 0 0 0 0 0 0
7 0 0 1 0 1 0 0 0 0 0
8 0 0 1 0 0 0 0 0 0 0
9 0 1 0 0 0 0 1 0 0 0
10 0 1 0 0 0 0 1 1 0 0
11 0 0 0 0 0 0 1 0 0 0
12 0 0 1 0 0 0 0 0 0 0
13 0 0 0 0 1 0 0 0 0 1
14 1 1 0 0 0 0 0 0 0 0
15 0 0 0 0 0 0 0 0 1 1
16 0 0 0 0 0 0 0 1 0 0
17 1 0 0 0 1 0 0 0 0 1
18 0 0 1 0 0 0 0 0 0 0
19 0 0 0 0 0 0 0 0 0 1
20 1 0 0 0 1 0 0 1 1 0
21 0 1 1 0 0 0 0 0 0 0
22 1 0 0 0 1 1 0 0 0 0
23 1 0 1 0 0 0 0 0 0 0
24 0 0 1 0 1 0 1 0 0 0
25 0 0 1 0 0 0 0 0 0 0
26 0 1 0 0 0 0 1 0 0 0
27 0 0 1 0 0 0 0 0 0 0
28 0 1 0 0 0 0 1 0 0 0
29 0 1 0 0 0 0 1 1 0 1
30 0 0 0 0 0 0 1 0 0 0

Advertising Cost Index Data

Sequential Month Online Advertising Cost Index
1 969
2 1020
3 1089
4 1099
5 873
6 1322
7 1043
8 1011
9 999
10 1050
11 1111
12 1134
13 1189
14 1206
15 1212
16 1225
17 1232
18 1245
19 1251
20 1247
21 1232
22 1291
23 1291
24 1292
25 1362
26 1421
27 1405
28 1373
29 1360
30 1403
31 1432
32 1456
33 1542
34 1517
35 1499
36 1505
37 1504