Media Research Assignment

profileDonald Trump
icebreak_competitive_expenditure_2016.xlsx
Home>Business & Finance homework help>Media Research Assignment

Investment Summary

Aqx Standard Report New File*
Period 3/01/2016 - 31/12/2016
Data Types $(000's)
Dictionary Selection Made
System Filter Print Insert:INSERT NOT COSTED , Outdoor Movement:BY REGION , RTV Spot Type:All Spots
Data Source AQX_monthly
Data Entitlements Applied
Grand Total Metropolitan Television Regional Television Metropolitan Press Regional Press Magazines Metropolitan Radio Online Cinema Out of Home Direct Mail Digital
Betta Milk Co-Op Society Ltd
Betta Jive Flavoured Milk $ 16 $ 16
Betta Milk Co-Op Society Ltd Total $ $ 16 $ 16
Brownes Dairy P/L
Brownes Chill Flavoured Milk $ 16 $ 16
Brownes Dairy P/L Total $ $ 16 $ 16
Coca Cola South Pacific
Barista Bros Flavoured Milk $ 558 $ 119 $ 101 $ 337 $ 1
Coca Cola South Pacific Total $ $ 558 $ 119 $ 101 $ 337 $ 1
Cor De Coco
Cor De Coco Coconut Iced Coffee $ 6 $ 6
Cor De Coco Total $ $ 6 $ 6
Frucor Beverages Australia P/L
V Iced Coffee $ 286 $ 286
Frucor Beverages Australia P/L Total $ $ 286 $ 286
Lion Dairy & Drinks
Big M Flavoured Milk $ 545 $ 212 $ 42 $ 263 $ 27
Dare Flavoured Milk $ 927 $ 565 $ 362
Dare Iced Coffee $ 2,631 $ 1,395 $ 594 $ 190 $ 313 $ 140
Farmers Union Iced Coffee $ 326 $ 108 $ 5 $ 27 $ 185
Masters M Flavoured Milk $ 159 $ 58 $ 11 $ 70 $ 20
Masters M Flavoured Milk Iced Coffee $ 49 $ 49
Moove Flavoured Milk $ 400 $ 71 $ 60 $ 203 $ 63 $ 4
Lion Dairy & Drinks Total $ $ 5,036 $ 1,845 $ 712 $ 1,317 $ 1,019 $ 143
Murray Goulburn Co-operative Co Limited
8 Bar Iced Coffee $ 414 $ 351 $ 61 $ 2
Devondale Milkshakes $ 631 $ 631
Murray Goulburn Co-operative Co Limited Total $ $ 1,045 $ 351 $ 692 $ 2
Nestle Australia Ltd
Milo Ready To Drink $ 440 $ 338 $ 102
Sustagen Energy Drink $ 385 $ 385
Nestle Australia Ltd Total $ $ 826 $ 338 $ 102 $ 385
NuLac Foods
Coach House Dairy Flavoured Milk * *
NuLac Foods Total $ * *
Parmalat Australia P/L
Breaka Flavoured Milk Drink $ 37 $ 17 $ 20
Ice Break Iced Coffee $ 2,289 $ 713 $ 512 $ 269 $ 228 $ 453 $ 113
Ice Break Iced Coffee-Comp $ 4 $ 4
Oak Flavoured Milk $ 1,564 $ 565 $ 437 $ 92 $ 189 $ 250 $ 31
Rush Barista Style Iced Coffee $ 55 $ 55
Rush Flavoured Milk $ 82 $ 82
Parmalat Australia P/L Total $ $ 4,030 $ 1,282 $ 949 $ 92 $ 286 $ 417 $ 860 $ 144
Vitaco Health Limited
Aussie Bodies Protein Revival Drink $ 15 $ 15
Vitaco Health Limited Total $ $ 15 $ 15
Warrnambool Cheese&Butter Fcty
Sungold Flavoured Milk $ 36 $ 36
Warrnambool Cheese&Butter Fcty Total $ $ 36 $ 36
Grand Total $ 11,871 $ 3,817 $ 1,780 $ 107 $ 36 $ 791 $ 1,835 $ 3,210 $ 296

Investment by Market

Aqx Standard Report New File*
Period 3/01/2016 - 31/12/2016
Data Types $(000's)
Dictionary Selection Made
System Filter Print Insert:INSERT NOT COSTED , Outdoor Movement:BY REGION , RTV Spot Type:All Spots
Data Source AQX_monthly
Data Entitlements Applied
Grand Total National New South Wales Victoria Queensland South Australia Western Australia Tasmania Northern Territory
8 Bar Iced Coffee $ 414 $ 2 $ 174 $ 173 $ 63 $ 1 $ 1
Aussie Bodies Protein Revival Drink $ 15 $ 15
Barista Bros Flavoured Milk $ 558 $ 1 $ 172 $ 156 $ 121 $ 55 $ 51 $ 1 $ 2
Betta Jive Flavoured Milk $ 16 $ 16
Big M Flavoured Milk $ 545 * $ 544 *
Breaka Flavoured Milk Drink $ 37 $ 37
Brownes Chill Flavoured Milk $ 16 $ 16
Coach House Dairy Flavoured Milk * *
Cor De Coco Coconut Iced Coffee $ 6 $ 6
Dare Flavoured Milk $ 927 $ 278 $ 279 $ 197 $ 78 $ 94
Dare Iced Coffee $ 2,631 $ 140 $ 1,060 $ 554 $ 471 $ 131 $ 247 $ 26 $ 2
Devondale Milkshakes $ 631 $ 282 $ 192 $ 156
Farmers Union Iced Coffee $ 326 $ 19 $ 301 $ 5
Ice Break Iced Coffee $ 2,289 $ 113 $ 458 $ 571 $ 655 $ 200 $ 289 $ 3
Ice Break Iced Coffee-Comp $ 4 $ 2 $ 1 * * *
Masters M Flavoured Milk $ 159 $ 159
Masters M Flavoured Milk Iced Coffee $ 49 $ 49
Milo Ready To Drink $ 440 $ 215 $ 92 $ 75 $ 16 $ 33 $ 9
Moove Flavoured Milk $ 400 $ 4 $ 395 $ 1 $ 1
Oak Flavoured Milk $ 1,564 $ 31 $ 712 $ 266 $ 317 $ 93 $ 144
Rush Barista Style Iced Coffee $ 55 $ 27 $ 28
Rush Flavoured Milk $ 82 $ 82
Sungold Flavoured Milk $ 36 $ 36
Sustagen Energy Drink $ 385 $ 158 $ 107 $ 56 $ 23 $ 40
V Iced Coffee $ 286 $ 89 $ 88 $ 65 $ 20 $ 24
Grand Total $ 11,871 $ 296 $ 4,038 $ 3,172 $ 2,232 $ 920 $ 1,150 $ 57 $ 6

Investment by Month

Aqx Standard Report New File*
Period 3/01/2016 - 31/12/2016
Data Types $(000's)
Dictionary Selection Made
System Filter Print Insert:INSERT NOT COSTED , Outdoor Movement:BY REGION , RTV Spot Type:All Spots
Data Source AQX_monthly
Data Entitlements Applied
Grand Total Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16
8 Bar Iced Coffee $ 414 $ 120 $ 102 $ 131 $ 61
Aussie Bodies Protein Revival Drink $ 15 $ 15
Barista Bros Flavoured Milk $ 558 $ 1 $ 1 $ 380 $ 122 $ 54
Betta Jive Flavoured Milk $ 16 $ 1 $ 15
Big M Flavoured Milk $ 545 $ 80 $ 57 $ 99 $ 61 $ 61 * $ 48 * $ 33 $ 105
Breaka Flavoured Milk Drink $ 37 $ 20 $ 17
Brownes Chill Flavoured Milk $ 16 $ 16
Coach House Dairy Flavoured Milk * * *
Cor De Coco Coconut Iced Coffee $ 6 $ 6 *
Dare Flavoured Milk $ 927 $ 160 $ 53 $ 231 $ 54 $ 139 * $ 113 $ 12 $ 164
Dare Iced Coffee $ 2,631 $ 360 $ 134 $ 184 $ 268 $ 176 $ 257 $ 204 $ 139 $ 212 $ 244 $ 130 $ 323
Devondale Milkshakes $ 631 $ 180 $ 158 $ 292
Farmers Union Iced Coffee $ 326 $ 39 $ 7 $ 4 $ 10 $ 10 $ 13 $ 43 $ 57 $ 47 $ 55 $ 40
Ice Break Iced Coffee $ 2,289 $ 1 $ 225 $ 105 $ 134 $ 4 $ 269 $ 291 $ 373 $ 639 $ 185 $ 63
Ice Break Iced Coffee-Comp $ 4 $ 4
Masters M Flavoured Milk $ 159 $ 40 $ 15 $ 26 $ 13 $ 23 $ 9 $ 12 $ 20
Masters M Flavoured Milk Iced Coffee $ 49 $ 8 $ 8 $ 7 $ 7 $ 8 $ 10
Milo Ready To Drink $ 440 $ 279 $ 161 *
Moove Flavoured Milk $ 400 $ 114 $ 62 $ 80 $ 16 $ 47 * $ 16 $ 64
Oak Flavoured Milk $ 1,564 $ 129 $ 60 $ 41 $ 2 * $ 34 $ 33 $ 760 $ 432 $ 10 $ 62
Rush Barista Style Iced Coffee $ 55 $ 24 $ 30
Rush Flavoured Milk $ 82 $ 10 $ 39 $ 33
Sungold Flavoured Milk $ 36 $ 2 $ 4 $ 3 $ 4 $ 5 $ 4 $ 4 $ 3 $ 2 $ 4 $ 2 $ 1
Sustagen Energy Drink $ 385 $ 112 $ 51 $ 69 $ 27 $ 42 $ 84
V Iced Coffee $ 286 $ 105 $ 181
Grand Total $ 11,871 $ 1,071 $ 1,128 $ 896 $ 817 $ 453 $ 498 $ 769 $ 817 $ 1,458 $ 1,966 $ 1,009 $ 988