Question: You are planning the media strategy for a large consumer products company. You have collected data regarding the media spend for the last 200 weeks.

You are planning the media strategy for a large consumer products company. You have collected data regarding the media spend for the last 200 weeks. The data includes unit sales, TV spend, radio spend and newspaper spend in thousands (000s). You are to build a model predicting what unit sales will be achieved for several different media investment mixes. After an initial attempt to use simple linear regression, you concluded that for every thousand dollars spent on TV you could increase unit sales by 50 units. Unfortunately the model only explained about 60% of variation in sales and results in significantly errors when simulated. You decide to apply a more powerful predictive model that uses multiple variables, but which variables should you use? Is your model better than the simple linear regression model? What unit sales forecast will you provide your leadership team for the different spending scenarios.

With your analysis complete, answer the following questions:

Explain which variables should you include in your predictive model (from any combination of TV, radio, or newspaper)?

What is your predictive model?

What is your prediction for the following media investments?

150,000 dollars spent on TV advertising and 20,000 spent on radio

21,000 dollars spent on TV advertising and 49,000 spent on radio

250,000 dollars spent on TV advertising and 1,000 spent on radio

You are planning the media strategy for a large consumer products

company. You have collected data regarding the media spend for the last

200 weeks. The data includes unit sales, TV spend, radio spend and

newspaper spend in thousands (000s). You are to build a model predicting

what unit sales will be achieved for several different media investment mixes.

After an initial attempt to use simple linear regression, you concluded that

for every thousand dollars spent on TV you could increase unit sales

by 50 units. Unfortunately the model only explained about 60% of variation

in sales and results in significantly errors when simulated. You decide to

apply a more powerful predictive model that uses multiple variables, but which

variables should you use? Is your model better than the simple linear

regression model? What unit sales forecast will you provide your leadership team

for the different spending scenarios. With your analysis complete, answer the following

questions: Explain which variables should you include in your predictive model (from

any combination of TV, radio, or newspaper)? What is your predictive model?

What is your prediction for the following media investments? 150,000 dollars spent

on TV advertising and 20,000 spent on radio 21,000 dollars spent on

TV advertising and 49,000 spent on radio 250,000 dollars spent on TV

Clipboard Font A1 HE X r fx TV B. E N 3 4 5 5 g C D 1 TV radio newspape sales 230.1 37.8 69.2 22.1 44.5 39.3 45.1 10.4 17.2 45.9 69.3 9.3 151.5 41.3 58.5 18.5 180.8 10.8 58.4 12.9 7 8.7 48.9 75 7.2 57.5 32.8 23.5 11.8 120.2 19.6 11.6 13.2 10 8.6 2.1 4.8 11 199.8 2.6 21.2 10.6 12 66.1 5.8 24.2 8.6 13 214.7 17.4 23.8 35.1 65.9 9.2 97.5 7.6 7.2 9.7 16 204.1 32.9 46 19 17 195.4 47.7 52.9 22.4 18 67.8 36.6 114 12.5 19 281.4 39.6 55.8 24.4 20 69.2 20.5 18.3 11.3 21 147.3 23.9 19.1 14.6 22 218.4 27.7 53.4 18 Advertising Ready 1 24 4 1 14 15 Clipboard A1 TV E 23 24 25 26 27 12.5 5.6 15.5 9.7 12 15 TUIN QUIN IN N A B 237.4 5.1 13.2 15.9 228.3 16.9 62.3 12.6 262.9 3.5 142.9 29.3 240.1 16.7 248.8 27.1 70.6 16 292.9 28.3 112.9 17.4 97.2 1.5 265.6 20 95.7 1.4 290.7 4.1 266.9 43.8 74.7 49.4 43.1 26.7 228 37.7 202.5 22.3 177 33.4 293.6 27.7 Advertising 23.5 49.6 26.2 18.3 19.5 12.6 22.9 22.9 40.8 43.2 38.6 30 0.3 7.4 8.5 5 45.7 35 15.9 18.9 10.5 21.4 11.9 9.6 17.4 9.5 12.8 25.4 14.7 10.1 21.5 16.6 17.1 20.7 7 38 39 40 41 42 35.1 32 31.6 38.7 1.8 43 44 Ready E 45 12.9 46 26.4 43.3 31.5 8.5 47 35.7 118 249 14.9 10.6 23.2 14.8 9.7 50 51 52 53 18.5 49.9 36.8 34.6 3.6 39.6 58.7 15.9 11.4 10.7 22.6 54 A B 206.9 8.4 25.1 25.7 175.1 22.5 89.7 9.9 239.9 41.5 227.2 15.8 66.9 11.7 199.8 3.1 100.4 9.6 216.4 41.7 182.6 46.2 262.7 28.8 198.9 49.4 7.3 28.1 136.2 19.2 210.8 49.6 210.7 29.5 53.5 2 261.3 42.7 239.3 15.5 102.7 29.6 131.1 42.8 Advertising 55 21.2 S 58 59 60 61 20.2 23.7 5.5 13.2 23.8 18.4 8.1 24.2. 15.7 14 18 60 41.4 16.6 37.7 9.3 21.4 54.7 27.3 8.4 28.9 62 6B 64 65 66 E 67 5 68 69 yo 9.3 9.5 13.4 18.9 22.3 18.3 12.4 8.8 11 17 75 OUT 75 77 A B 69 9.3 31.5 24.6 139.3 14.5 237.4 27.5 216.8 43.9 199.1 30.6 109.8 14.3 26.8 33 129.4 5.7 213.4 24.6 16.9 43.7 27.5 1.6 120.5 28.5 5.4 29.9 116 7.7 76.4 26.7 239.8 4.1 75.3 20.3 68.4 44.5 213.5 43 193.2 18.4 76.3 27.5 Advertising C 0.9 2.2 10.2 11 27.2 38.7 31.7 19.3 31.3 13.1 89.4 20.7 14.2 9.4 23.1 22.3 36.9 32.5 35.6 33.8 65.7 16 73 B 279 8.7 6.9 14.2 5.3 11 80 81 82 8B 84 85 86 87 88 11.8 12.3 11.3 13.6 21.7 15.2 12 D E 16 89 90 91 32 93 C 63.2 73.4 51.4 9.3 33 59 12.9 16.7 91 95 72.3 95 97 9 B 2 99 . 110.7 88.3 109.8 134.3 28.6 217.7 250.9 107.4 163.3 197.6 184.9 289.7 135.2 222.4 296.4 280.2 187.9 238.2 137.9 25 90.4 13.1 B 40.6 25.5 47.8 4.9 1.5 33.5 36.5 14 31.6 3.5 21 42.3 41.7 4.3 36.3 10.1 17.2 34.3 46.4 11 0.3 0.4 100 101 102 103 104 105 106 107 108 109 110 10.9 52.9 5.9 22 51.2 45.9 49.8 100.9 21.4 17.9 5.3 59 29.7 23.2 25.6 11.2 7.3 19.4 22.2 11.5 16.9 11.7 15.5 25.4 17.2 11.7 23.8 14.8 14.7 20.7 19.2 7.2 8.7 5.3 Advertising E A 255.4 19.8 111 112 113 114 225.8 241.7 175.7 B 26.9 8.2 38 15.4 20.6 46.8 35 14.3 5.5 56.5 23.2 2.4 10.7 34.5 52.7 209.6 117 El 118 119 120 121 1212 1213 124 125 126 127 128 129 130 131 132 78.2 75.1 139.2 76.4 125.7 19.4 141.3 18.8 224 123.1 229.5 87.2 7.8 80.2 220.3 59.6 0.7 0.8 36.9 16 26.8 21.7 2.4 34.6 32.3 11.8 38.9 0 49 12 39.6 25.6 14.8 79.2 22.3 46.2 50.4 15.6 12.4 74.2 25.9 50.6 9.2 3.2 43.1 8.7 13.4 21.8 14.1 15.9 14.6 12.6 12.2 9.4 15.9 6.6 15.5 7 11.6 15.2 19.7 10.6 6.6 8.8 24.7 9.7 1.6 Advertising Read D E 133 134 135 136 137 19 10 2 143 -144 145 46 A B 265.2 2.9 8.4 27.2 219.8 33.5 36.9 38.6 48.9 47 25.6 39 273.7 28.9 43 25.9 184.9 43.9 73.4 17 193.7 35.4 220.5 33.2 104.6 5.7 96.2 14.8 140.3 1.9 240.1 7.3 243.2 49 38 40.3 44.7 25.8 280.7 13.9 121 8.4 197.6 23.3 Advertising C 43 2.1 45.1 65.6 8.5 9.3 59.7 20.5 1.7 12.9 75.6 37.9 34.4 38.9 9 8.7 44.3 11.9 20.6 37 48.7 14.2 12.7 5.7 19.6 10.8 11.6 9.5 20.8 9.6 20.7 10.9 19.2 20.1 10.4 11.4 10.3 13.2 25.4 10.9 10.1 16.1 11.6 16.6 148 149 150 151 152 153 154 Et H O OM T147 x for E 37.7 9.5 19 155 156 | 157 158 15.6 3.2 15.3 1610 102 103 164 165 166 167 168 | 169 170 171 172 173 1174 175 176 A B. 171.3 39.7 187.8 21.1 4.1 11.6 93.9 43.5 149.8 1.3 11.7 36.9 131.7 18.4 172.5 18.1 85.7 35.8 188.4 18.1 163.5 36.8 117.2 14.7 234.5 3.4 17.9 37.6 206.8 5.2 215.4 23.6 284.3 10.6 50 11.6 164.5 20.9 19.6 20.1 168.4 7.1 222.4 3.4 Advertising 5.7 50.5 24.3 45.2 34.6 30.7 49.3 25.6 7.4 5.4 84.8 21.6 19.4 57.6 6.4 18.4 47.4 17 12.8 13.1 10.1 7.3 12.9 14.4 13.3 14.9 18 11.9 11.9 8 12.2 17.1 15 8.4 14.5 7.6 11.7 11.5 6 B E 177 178 179 1180 48.9 30.2 7.8 2.3 10 12.6 1313 104 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 5.4 5.7 43 21.3 45.1 2.1 28.7 13.9 12.1 41.1 10.8 4.1 42 35.6 3.7 4.9 9.3 42 8.6 C 41.8 20.3 35.2 23.7 17.6 8.3 27.4 29.7 71.8 30 19.6 26.6 18.2 3.7 23.4 5.8 6 31.6 3.6 6 13.8 8.1 6.4 66.2 87 27 20.2 11.7 11.8 12.6 10.5 12.2. 8.7 26.2 17.6 22.6 10.3 17.3 15.9 6.7 10.8 9.9 5.9 19.6 17.3 7.6 9.7 12.8 25.5 134 Clipboard Font A1 H. TV B E N 4 6 1 A C D 1 TV radio newspape sales 230.1 37.8 69.2 22.1 3 44.5 39.3 45.1 10.4 17.2 45.9 69.3 9.3 5 151.5 41.3 58.5 18.5 180.8 10.8 58.4 12.9 7 8.7 48.9 75 7.2 57.5 32.8 23.5 11.8 9 120.2 19.6 11.6 13.2 10 8.6 2.1 4.8 11 199.8 2.6 21.2 10.6 12 66.1 5.8 24.2 8.6 13 214.7 17.4 23.8 35.1 65.9 9.2 97.5 7.6 7.2 9.7 16 204.1 32.9 46 19 17 195.4 47.7 52.9 22.4 18 67.8 36.6 114 12.5 19 281.4 39.6 55.8 24.4 20 69.2 20.5 18.3 11.3 21 147.3 23.9 19.1 14.6 22 218.4 27.7 53.4 18 Advertising Ready 24 4 14 15 Clipboard A1 TV E 23.5 23 24 25 26 27 B 5.1 15.9 16.9 49.6 26.2 18.3 19.5 12.5 5.6 15.5 9.7 12 15 15.9 12.6 TUIN QUI NIINN TOUT 20 30 31 32 33 A 237.4 13.2 228.3 62.3 262.9 142.9 240.1 248.8 70.6 292.9 112.9 97.2 265.6 95.7 290.7 266.9 74.7 43.1 228 202.5 177 293.6 12.6 3.5 29.3 16.7 27.1 16 28.3 17.4 1.5 20 1.4 4.1 43.8 49.4 26.7 37.7 22.3 33.4 27.7 22.9 22.9 40.8 43.2 38.6 30 0.3 7.4 8.5 5 45.7 35.1 32 31.6 38.7 1.8 7 18.9 10.5 21.4 11.9 9.6 17.4 9.5 12.8 25.4 14.7 10.1 21.5 16.6 17.1 20.7 38 39 40 41 42 43 44 Advertising Read E 45 12.9 46 26.4 43.3 31.5 47 18 49 8.5 14.9 10.6 23.2 14.8 9.7 35.7 18.5 49.9 36.8 34.6 3.6 50 51 52 5 11.4 10.7 22.6 55 B 206.9 8.4 25.1 25.7 175.1 22.5 89.7 9.9 239.9 41.5 227,2 15.8 66.9 11.7 199.8 3.1 100.4 9.6 216.4 41.7 182.6 46.2 262.7 28.8 198.9 49.4 7.3 28.1 136.2 19.2 210.8 49.6 210.7 29.5 53.5 2 261.3 42.7 239.3 15.5 102.7 29.6 131.1 42.8 Advertising 21.2 ) 59 60 39.6 58.7 15.9 60 41.4 16.6 37.7 9.3 21.4 54.7 27.3 8.4 28.9 61 20.2 23.7 5.5 13.2 23.8 18.4 8.1 24.2 15.7 14 18 62 6B 64 65 66 1 m 9.3 67 68 9.5 13.4 69 70 18.9 22.3 18.3 12.4 8.8 75 11 17 75 77 B 69 9.3 31.5 24.6 139.3 14.5 237.4 27.5 216.8 43.9 199.1 30.6 109.8 14.3 26.8 33 129.4 5.7 213.4 24.6 16.9 43.7 27.5 1.6 120.5 28.5 5.4 29.9 116 7.7 76.4 26.7 239.8 4.1 75.3 20.3 68.4 44.5 213.5 43 193.2 18.4 76.3 27.5 Advertising C 0.9 2.2 10.2 11 27.2 38.7 31.7 19.3 31.3 13.1 89.4 20.7 14.2 9.4 23.1 22.3 36.9 32.5 35.6 33.8 65.7 16 78 B 279 8.7 6.9 14.2 5.3 11 80 81 82 8B 84 85 86 87 88 11.8 12.3 11.3 13.6 21.7 15.2 12 B E A 110.7 88.3 63.2 89 90 91 16 73.4 12.9 16.7 51.4 32 9.3 40.6 25.5 47.8 4.9 1.5 33.5 36.5 14 -93 33 91 9 95 97 93 99 e 100 101 102 109.8 134.3 28.6 217.7 250.9 107.4 163.3 197.6 184.9 289.7 135.2 222.4 296.4 280.2 187.9 238.2 137.9 25 90.4 13.1 59 72.3 10.9 52.9 5.9 22 51.2 45.9 49.8 100.9 21.4 17.9 5.3 59 29.7 23.2 25.6 31.6 3.5 21 42.3 41.7 4.3 36.3 10.1 17.2 34.3 46.4 11 0.3 0.4 11.2 7.3 19.4 22.2 11.5 16.9 11.7 15.5 25.4 17.2 11.7 23.8 14.8 14.7 20.7 19.2 7.2 8.7 5.3 103 104 105 106 107 108 109 110 Advertising E A 255.4 B 26.9 111 19.8 112 113 8.2 38 225.8 241.7 175.7 209.6 114 11.15 78.2 75.1 15.4 20.6 46.8 35 14.3 5.5 56.5 23.2 2.4 10.7 34.5 52.7 25.6 14.8 79.2 22.3 46.2 50.4 0.8 36.9 1118 119 120 121 122 1213 124 125 126 127 128 129 130 131 132 139.2 76.4 125.7 19.4 141.3 18.8 224 123.1 229.5 87.2 7.8 80.2 220.3 59.6 0.7 16 26.8 21.7 2.4 34.6 32.3 11.8 38.9 0 49 12 39.6 13.4 21.8 14.1 15.9 14.6 12.6 12.2 9.4 15.9 6.6 15.5 7 11.6 15.2 19.7 10.6 6.6 8.8 24.7 9.7 1.6 15.6 12.4 74.2 25.9 50.6 9.2 3.2 43.1 8.7 Advertising Read E 133 134 135 136 2 143 144 145 146 147 148 149 150 151 152 153 154 A B 265.2 2.9 8.4 27.2 219.8 33.5 36.9 38.6 48.9 47 25.6 39 273.7 28.9 43 25.9 184.9 43.9 73.4 17 193.7 35.4 220.5 33.2 104.6 5.7 96.2 14.8 140.3 1.9 240.1 7.3 243.2 49 38 40.3 44.7 25.8 280.7 13.9 121 8.4 197.6 23.3 Advertising C 43 2.1 45.1 65.6 8.5 9.3 59.7 20.5 1.7 12.9 75.6 37.9 34.4 38.9 9 8.7 44.3 11.9 20.6 37 48.7 14.2 D 12.7 5.7 19.6 10.8 11.6 9.5 20.8 9.6 20.7 10.9 19.2 20.1 10.4 11.4 10.3 13.2 25.4 10.9 10.1 16.1 11.6 16.6 Et O JUL OM T147 . x D m 37.7 9.5 19 155 156 157 158 15.6 3.2 15.3 119 1010 102 103 164 165 1616 167 168 169 170 171 172 173 1174 175 176 A B. 171.3 39.7 187.8 21.1 4.1 11.6 93.9 43.5 149.8 1.3 11.7 36.9 131.7 18.4 172.5 18.1 85.7 35.8 188.4 18.1 163.5 36.8 117.2 14.7 234.5 3.4 17.9 37.6 206.8 5.2 215.4 23.6 284.3 10.6 50 11.6 164.5 20.9 19.6 20.1 168.4 7.1 222.4 3.4 Advertising 5.7 50.5 24.3 45.2 34.6 30.7 49.3 25.6 7.4 5.4 84.8 21.6 19.4 57.6 6.4 18.4 47.4 17 12.8 13.1 10.1 7.3 12.9 14.4 13.3 14.9 18 11.9 11.9 8 12.2 17.1 15 8.4 14.5 7.6 11.7 11.5 Enter B E 177 178 179 180 48.9 30.2 7.8 2.3 10 2.6 182 1313 194 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 2009 PA 5.4 5.7 43 21.3 45.1 2.1 28.7 13.9 12.1 41.1 10.8 4.1 42 35.6 3.7 4.9 9.3 41.8 20.3 35.2 23.7 17.6 8.3 27.4 29.7 71.8 30 19.6 26.6 18.2 3.7 23.4 5.8 6 31.6 3.6 6 13.8 8.1 6.4 66.2 27 20.2 11.7 11.8 12.6 10.5 12.2. 8.7 26.2 17.6 22.6 10.3 17.3 15.9 6.7 10.8 9.9 5.9 19.6 17.3 7.6 9.7 12.8 25.5 134 42 8.6 87 Clipboard Font A1 HE X r fx TV B. E N 3 4 5 5 g C D 1 TV radio newspape sales 230.1 37.8 69.2 22.1 44.5 39.3 45.1 10.4 17.2 45.9 69.3 9.3 151.5 41.3 58.5 18.5 180.8 10.8 58.4 12.9 7 8.7 48.9 75 7.2 57.5 32.8 23.5 11.8 120.2 19.6 11.6 13.2 10 8.6 2.1 4.8 11 199.8 2.6 21.2 10.6 12 66.1 5.8 24.2 8.6 13 214.7 17.4 23.8 35.1 65.9 9.2 97.5 7.6 7.2 9.7 16 204.1 32.9 46 19 17 195.4 47.7 52.9 22.4 18 67.8 36.6 114 12.5 19 281.4 39.6 55.8 24.4 20 69.2 20.5 18.3 11.3 21 147.3 23.9 19.1 14.6 22 218.4 27.7 53.4 18 Advertising Ready 1 24 4 1 14 15 Clipboard A1 TV E 23 24 25 26 27 12.5 5.6 15.5 9.7 12 15 TUIN QUIN IN N A B 237.4 5.1 13.2 15.9 228.3 16.9 62.3 12.6 262.9 3.5 142.9 29.3 240.1 16.7 248.8 27.1 70.6 16 292.9 28.3 112.9 17.4 97.2 1.5 265.6 20 95.7 1.4 290.7 4.1 266.9 43.8 74.7 49.4 43.1 26.7 228 37.7 202.5 22.3 177 33.4 293.6 27.7 Advertising 23.5 49.6 26.2 18.3 19.5 12.6 22.9 22.9 40.8 43.2 38.6 30 0.3 7.4 8.5 5 45.7 35 15.9 18.9 10.5 21.4 11.9 9.6 17.4 9.5 12.8 25.4 14.7 10.1 21.5 16.6 17.1 20.7 7 38 39 40 41 42 35.1 32 31.6 38.7 1.8 43 44 Ready E 45 12.9 46 26.4 43.3 31.5 8.5 47 35.7 118 249 14.9 10.6 23.2 14.8 9.7 50 51 52 53 18.5 49.9 36.8 34.6 3.6 39.6 58.7 15.9 11.4 10.7 22.6 54 A B 206.9 8.4 25.1 25.7 175.1 22.5 89.7 9.9 239.9 41.5 227.2 15.8 66.9 11.7 199.8 3.1 100.4 9.6 216.4 41.7 182.6 46.2 262.7 28.8 198.9 49.4 7.3 28.1 136.2 19.2 210.8 49.6 210.7 29.5 53.5 2 261.3 42.7 239.3 15.5 102.7 29.6 131.1 42.8 Advertising 55 21.2 S 58 59 60 61 20.2 23.7 5.5 13.2 23.8 18.4 8.1 24.2. 15.7 14 18 60 41.4 16.6 37.7 9.3 21.4 54.7 27.3 8.4 28.9 62 6B 64 65 66 E 67 5 68 69 yo 9.3 9.5 13.4 18.9 22.3 18.3 12.4 8.8 11 17 75 OUT 75 77 A B 69 9.3 31.5 24.6 139.3 14.5 237.4 27.5 216.8 43.9 199.1 30.6 109.8 14.3 26.8 33 129.4 5.7 213.4 24.6 16.9 43.7 27.5 1.6 120.5 28.5 5.4 29.9 116 7.7 76.4 26.7 239.8 4.1 75.3 20.3 68.4 44.5 213.5 43 193.2 18.4 76.3 27.5 Advertising C 0.9 2.2 10.2 11 27.2 38.7 31.7 19.3 31.3 13.1 89.4 20.7 14.2 9.4 23.1 22.3 36.9 32.5 35.6 33.8 65.7 16 73 B 279 8.7 6.9 14.2 5.3 11 80 81 82 8B 84 85 86 87 88 11.8 12.3 11.3 13.6 21.7 15.2 12 D E 16 89 90 91 32 93 C 63.2 73.4 51.4 9.3 33 59 12.9 16.7 91 95 72.3 95 97 9 B 2 99 . 110.7 88.3 109.8 134.3 28.6 217.7 250.9 107.4 163.3 197.6 184.9 289.7 135.2 222.4 296.4 280.2 187.9 238.2 137.9 25 90.4 13.1 B 40.6 25.5 47.8 4.9 1.5 33.5 36.5 14 31.6 3.5 21 42.3 41.7 4.3 36.3 10.1 17.2 34.3 46.4 11 0.3 0.4 100 101 102 103 104 105 106 107 108 109 110 10.9 52.9 5.9 22 51.2 45.9 49.8 100.9 21.4 17.9 5.3 59 29.7 23.2 25.6 11.2 7.3 19.4 22.2 11.5 16.9 11.7 15.5 25.4 17.2 11.7 23.8 14.8 14.7 20.7 19.2 7.2 8.7 5.3 Advertising E A 255.4 19.8 111 112 113 114 225.8 241.7 175.7 B 26.9 8.2 38 15.4 20.6 46.8 35 14.3 5.5 56.5 23.2 2.4 10.7 34.5 52.7 209.6 117 El 118 119 120 121 1212 1213 124 125 126 127 128 129 130 131 132 78.2 75.1 139.2 76.4 125.7 19.4 141.3 18.8 224 123.1 229.5 87.2 7.8 80.2 220.3 59.6 0.7 0.8 36.9 16 26.8 21.7 2.4 34.6 32.3 11.8 38.9 0 49 12 39.6 25.6 14.8 79.2 22.3 46.2 50.4 15.6 12.4 74.2 25.9 50.6 9.2 3.2 43.1 8.7 13.4 21.8 14.1 15.9 14.6 12.6 12.2 9.4 15.9 6.6 15.5 7 11.6 15.2 19.7 10.6 6.6 8.8 24.7 9.7 1.6 Advertising Read D E 133 134 135 136 137 19 10 2 143 -144 145 46 A B 265.2 2.9 8.4 27.2 219.8 33.5 36.9 38.6 48.9 47 25.6 39 273.7 28.9 43 25.9 184.9 43.9 73.4 17 193.7 35.4 220.5 33.2 104.6 5.7 96.2 14.8 140.3 1.9 240.1 7.3 243.2 49 38 40.3 44.7 25.8 280.7 13.9 121 8.4 197.6 23.3 Advertising C 43 2.1 45.1 65.6 8.5 9.3 59.7 20.5 1.7 12.9 75.6 37.9 34.4 38.9 9 8.7 44.3 11.9 20.6 37 48.7 14.2 12.7 5.7 19.6 10.8 11.6 9.5 20.8 9.6 20.7 10.9 19.2 20.1 10.4 11.4 10.3 13.2 25.4 10.9 10.1 16.1 11.6 16.6 148 149 150 151 152 153 154 Et H O OM T147 x for E 37.7 9.5 19 155 156 | 157 158 15.6 3.2 15.3 1610 102 103 164 165 166 167 168 | 169 170 171 172 173 1174 175 176 A B. 171.3 39.7 187.8 21.1 4.1 11.6 93.9 43.5 149.8 1.3 11.7 36.9 131.7 18.4 172.5 18.1 85.7 35.8 188.4 18.1 163.5 36.8 117.2 14.7 234.5 3.4 17.9 37.6 206.8 5.2 215.4 23.6 284.3 10.6 50 11.6 164.5 20.9 19.6 20.1 168.4 7.1 222.4 3.4 Advertising 5.7 50.5 24.3 45.2 34.6 30.7 49.3 25.6 7.4 5.4 84.8 21.6 19.4 57.6 6.4 18.4 47.4 17 12.8 13.1 10.1 7.3 12.9 14.4 13.3 14.9 18 11.9 11.9 8 12.2 17.1 15 8.4 14.5 7.6 11.7 11.5 6 B E 177 178 179 1180 48.9 30.2 7.8 2.3 10 12.6 1313 104 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 5.4 5.7 43 21.3 45.1 2.1 28.7 13.9 12.1 41.1 10.8 4.1 42 35.6 3.7 4.9 9.3 42 8.6 C 41.8 20.3 35.2 23.7 17.6 8.3 27.4 29.7 71.8 30 19.6 26.6 18.2 3.7 23.4 5.8 6 31.6 3.6 6 13.8 8.1 6.4 66.2 87 27 20.2 11.7 11.8 12.6 10.5 12.2. 8.7 26.2 17.6 22.6 10.3 17.3 15.9 6.7 10.8 9.9 5.9 19.6 17.3 7.6 9.7 12.8 25.5 134 Clipboard Font A1 H. TV B E N 4 6 1 A C D 1 TV radio newspape sales 230.1 37.8 69.2 22.1 3 44.5 39.3 45.1 10.4 17.2 45.9 69.3 9.3 5 151.5 41.3 58.5 18.5 180.8 10.8 58.4 12.9 7 8.7 48.9 75 7.2 57.5 32.8 23.5 11.8 9 120.2 19.6 11.6 13.2 10 8.6 2.1 4.8 11 199.8 2.6 21.2 10.6 12 66.1 5.8 24.2 8.6 13 214.7 17.4 23.8 35.1 65.9 9.2 97.5 7.6 7.2 9.7 16 204.1 32.9 46 19 17 195.4 47.7 52.9 22.4 18 67.8 36.6 114 12.5 19 281.4 39.6 55.8 24.4 20 69.2 20.5 18.3 11.3 21 147.3 23.9 19.1 14.6 22 218.4 27.7 53.4 18 Advertising Ready 24 4 14 15 Clipboard A1 TV E 23.5 23 24 25 26 27 B 5.1 15.9 16.9 49.6 26.2 18.3 19.5 12.5 5.6 15.5 9.7 12 15 15.9 12.6 TUIN QUI NIINN TOUT 20 30 31 32 33 A 237.4 13.2 228.3 62.3 262.9 142.9 240.1 248.8 70.6 292.9 112.9 97.2 265.6 95.7 290.7 266.9 74.7 43.1 228 202.5 177 293.6 12.6 3.5 29.3 16.7 27.1 16 28.3 17.4 1.5 20 1.4 4.1 43.8 49.4 26.7 37.7 22.3 33.4 27.7 22.9 22.9 40.8 43.2 38.6 30 0.3 7.4 8.5 5 45.7 35.1 32 31.6 38.7 1.8 7 18.9 10.5 21.4 11.9 9.6 17.4 9.5 12.8 25.4 14.7 10.1 21.5 16.6 17.1 20.7 38 39 40 41 42 43 44 Advertising Read E 45 12.9 46 26.4 43.3 31.5 47 18 49 8.5 14.9 10.6 23.2 14.8 9.7 35.7 18.5 49.9 36.8 34.6 3.6 50 51 52 5 11.4 10.7 22.6 55 B 206.9 8.4 25.1 25.7 175.1 22.5 89.7 9.9 239.9 41.5 227,2 15.8 66.9 11.7 199.8 3.1 100.4 9.6 216.4 41.7 182.6 46.2 262.7 28.8 198.9 49.4 7.3 28.1 136.2 19.2 210.8 49.6 210.7 29.5 53.5 2 261.3 42.7 239.3 15.5 102.7 29.6 131.1 42.8 Advertising 21.2 ) 59 60 39.6 58.7 15.9 60 41.4 16.6 37.7 9.3 21.4 54.7 27.3 8.4 28.9 61 20.2 23.7 5.5 13.2 23.8 18.4 8.1 24.2 15.7 14 18 62 6B 64 65 66 1 m 9.3 67 68 9.5 13.4 69 70 18.9 22.3 18.3 12.4 8.8 75 11 17 75 77 B 69 9.3 31.5 24.6 139.3 14.5 237.4 27.5 216.8 43.9 199.1 30.6 109.8 14.3 26.8 33 129.4 5.7 213.4 24.6 16.9 43.7 27.5 1.6 120.5 28.5 5.4 29.9 116 7.7 76.4 26.7 239.8 4.1 75.3 20.3 68.4 44.5 213.5 43 193.2 18.4 76.3 27.5 Advertising C 0.9 2.2 10.2 11 27.2 38.7 31.7 19.3 31.3 13.1 89.4 20.7 14.2 9.4 23.1 22.3 36.9 32.5 35.6 33.8 65.7 16 78 B 279 8.7 6.9 14.2 5.3 11 80 81 82 8B 84 85 86 87 88 11.8 12.3 11.3 13.6 21.7 15.2 12 B E A 110.7 88.3 63.2 89 90 91 16 73.4 12.9 16.7 51.4 32 9.3 40.6 25.5 47.8 4.9 1.5 33.5 36.5 14 -93 33 91 9 95 97 93 99 e 100 101 102 109.8 134.3 28.6 217.7 250.9 107.4 163.3 197.6 184.9 289.7 135.2 222.4 296.4 280.2 187.9 238.2 137.9 25 90.4 13.1 59 72.3 10.9 52.9 5.9 22 51.2 45.9 49.8 100.9 21.4 17.9 5.3 59 29.7 23.2 25.6 31.6 3.5 21 42.3 41.7 4.3 36.3 10.1 17.2 34.3 46.4 11 0.3 0.4 11.2 7.3 19.4 22.2 11.5 16.9 11.7 15.5 25.4 17.2 11.7 23.8 14.8 14.7 20.7 19.2 7.2 8.7 5.3 103 104 105 106 107 108 109 110 Advertising E A 255.4 B 26.9 111 19.8 112 113 8.2 38 225.8 241.7 175.7 209.6 114 11.15 78.2 75.1 15.4 20.6 46.8 35 14.3 5.5 56.5 23.2 2.4 10.7 34.5 52.7 25.6 14.8 79.2 22.3 46.2 50.4 0.8 36.9 1118 119 120 121 122 1213 124 125 126 127 128 129 130 131 132 139.2 76.4 125.7 19.4 141.3 18.8 224 123.1 229.5 87.2 7.8 80.2 220.3 59.6 0.7 16 26.8 21.7 2.4 34.6 32.3 11.8 38.9 0 49 12 39.6 13.4 21.8 14.1 15.9 14.6 12.6 12.2 9.4 15.9 6.6 15.5 7 11.6 15.2 19.7 10.6 6.6 8.8 24.7 9.7 1.6 15.6 12.4 74.2 25.9 50.6 9.2 3.2 43.1 8.7 Advertising Read E 133 134 135 136 2 143 144 145 146 147 148 149 150 151 152 153 154 A B 265.2 2.9 8.4 27.2 219.8 33.5 36.9 38.6 48.9 47 25.6 39 273.7 28.9 43 25.9 184.9 43.9 73.4 17 193.7 35.4 220.5 33.2 104.6 5.7 96.2 14.8 140.3 1.9 240.1 7.3 243.2 49 38 40.3 44.7 25.8 280.7 13.9 121 8.4 197.6 23.3 Advertising C 43 2.1 45.1 65.6 8.5 9.3 59.7 20.5 1.7 12.9 75.6 37.9 34.4 38.9 9 8.7 44.3 11.9 20.6 37 48.7 14.2 D 12.7 5.7 19.6 10.8 11.6 9.5 20.8 9.6 20.7 10.9 19.2 20.1 10.4 11.4 10.3 13.2 25.4 10.9 10.1 16.1 11.6 16.6 Et O JUL OM T147 . x D m 37.7 9.5 19 155 156 157 158 15.6 3.2 15.3 119 1010 102 103 164 165 1616 167 168 169 170 171 172 173 1174 175 176 A B. 171.3 39.7 187.8 21.1 4.1 11.6 93.9 43.5 149.8 1.3 11.7 36.9 131.7 18.4 172.5 18.1 85.7 35.8 188.4 18.1 163.5 36.8 117.2 14.7 234.5 3.4 17.9 37.6 206.8 5.2 215.4 23.6 284.3 10.6 50 11.6 164.5 20.9 19.6 20.1 168.4 7.1 222.4 3.4 Advertising 5.7 50.5 24.3 45.2 34.6 30.7 49.3 25.6 7.4 5.4 84.8 21.6 19.4 57.6 6.4 18.4 47.4 17 12.8 13.1 10.1 7.3 12.9 14.4 13.3 14.9 18 11.9 11.9 8 12.2 17.1 15 8.4 14.5 7.6 11.7 11.5 Enter B E 177 178 179 180 48.9 30.2 7.8 2.3 10 2.6 182 1313 194 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 2009 PA 5.4 5.7 43 21.3 45.1 2.1 28.7 13.9 12.1 41.1 10.8 4.1 42 35.6 3.7 4.9 9.3 41.8 20.3 35.2 23.7 17.6 8.3 27.4 29.7 71.8 30 19.6 26.6 18.2 3.7 23.4 5.8 6 31.6 3.6 6 13.8 8.1 6.4 66.2 27 20.2 11.7 11.8 12.6 10.5 12.2. 8.7 26.2 17.6 22.6 10.3 17.3 15.9 6.7 10.8 9.9 5.9 19.6 17.3 7.6 9.7 12.8 25.5 134 42 8.6 87

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

There are 3 attachments. The first attachment are the instructions and questions that are to be answered. The following 2 attachments are useful items needed to complete the questions properly....

I need my powerpoint draft edited to ensure all the requirement of the assignment are answered and clearly noted in this powerpoint. I have attached the current Powerepoint draft, the...

There are 3 attachments. The first attachment are the instructions and questions that are to be answered. The following 2 attachments are useful items needed to complete the questions properly....

Hello there, I am having a real hard time figuring out how to arrive at the gross plant & equipment amount for Exercise 4-9 part a Colgate's Average total life span of plant and equipment using their...

S w 9B06A035 SPECTRUM BRANDS, INC. - THE SALES FORCE DILEMMA Joe Falconi wrote this case under the supervision of Professor Don Barclay solely to provide material for class discussion. The authors do...

Brands in the Salesforce Dilem DS. INC: SPECTRUM BRAN company's individual and maintain customer relationships, and to clude competition from tak ing advantage of any perceived disruptions during...

Project 1: Analysis of a 10- K (10%) 1. Locate a 10-K of your choice from the SEC website (www.sec.gov). Present your choice in the conference set up for same in Week #1 for approval by stating the...

Analysis What is the Real Problem tin the case that is be below. a. Common Causes - Compare the causes and look for commonality b. Primary Problem - Based on commonality identify THE primary problem...

Go to www.nucor.com. At the top of the frame you will see the heading Our Story. Then click on Chapter 1 Corporate Overview and read the information under this tab and then click on Chapter 2 History...

1. A speed of 7 mm/u,s is equal to ___________. a) 7000 m/s b) 70 m/s c) 7 m/s d) 0.07 m/s 2. A hockey puck, whose diameter is approximately 3 inches, is to be used to determine the value of to...

In 150 words or fewer, explain how contingent liabilities are accounted for.

In the paper "Data - Driven Denim: Financial Forecasting at Levi Strauss", In the Paper, how would a black swan event impact the algorithmic forecasts?

Hypothesis Testing of a Single Mean LCTCS Tuition: Louisiana Community And Technical College System consist of 2 community colleges across the state. I think RPCC's tuition and fees is lower than the...

Whom do you call when you have exciting news or when youre feeling down? What makes this person a good listener? Are you a good listener in return when this person calls you?

Consider the examples of listening styles weve given here. Do you favor a particular listening style? Are you able to adopt different styles in different situations?

4. Try smiling (genuinely) more than you usually doand with people you might not usually smile at. See what happens. Do you feel differently about yourself and others? Do others respond with more...