PLEASE SHOW FORMULAS AND INSTRUCTIONS PLEASE!

Suppose that General Flakes decides that it shouldnt place any more than 10 ads on any given show. Modify the (original) advertising model appropriately to incorporate this constraint, and then reoptimize (with integer constraints on the numbers of ads). Finally, run SolverTable to see how sensitive the optimal solution is to the maximum number of ads per show allowed. You can decide on a reasonable range for the sensitivity analysis.

A H 1 J B D E F G 5 #1. Problem 14 -- modified (35 points) 6 Modifications to problem #4 7 1. In addition to the limit of no more than 10 ads on any given show assume at least 2 ads must be 8 placed in each show. 9 2. The actual exposures obtained for women must not exceed that of men. 10 3. The actual exposures obtained for 35 and under population must be at least 75% of the actual 11 exposures obtained for older population 12 13 Note: All monetary values are in $1000s, and all exposures to ads are in millions of exposures. 14 15 a. Set up a Solver model and determine the least cost advertising plan. (25 points) 16 Exposures to various groups per ad Sunday Night 17 Timeless Football The Simpsons SportsCenter Homeland 18 Men 18-35 6 0.5 0.7 19 Men 36-55 3 5 2 0.5 0.2 20 Men >55 1 3 0 0.3 0 21 Women 18-35 6 1 4 0.1 0.9 22 Women 36-55 4 1 2 0.1 0.1 23 Women >55 2 1 0 0 0 24 25 Cost per ad 140 100 80 13 26 27 Minimum ads per sho 28 Maximum ads per sho 10 Madam Secretary Rachael Ray 0.1 0.1 0 0.6 13 0.4 CNN 0.1 0.2 0.3 0.1 0.2 0.3 9 15 8 140 Formula Bar B E F G H Timeless ight Football The Simpsons SportsCenter Homeland Rachael Ray Advertising plan Minimum required CNN Madam Secretary 29 30 31 32 33 34 35 36 37 Number of ads purcha 0 O 0 0 0 0 0. 0 Maximum allowed Original required 60 38 39 40 41 Constraints on numbers of exposures Actual exposures Men 18-35 0 Men 36-55 0 Men >55 0 Women 18-35 0 Women 36-55 0 Women >55 0 Total 0 Required exposures 0 0 0 0 0 0 8888 42 43 28 45 46 Exposure requirements Extra exposures needed 35 & under minimum 47 0 0.75 48 49 C D G H 49 Actual for Required for 50 Exposure constraints age/gender are/render 51 Women and men O 35 & under and the rest 0 0 53 54 objective to minimize 55 Total cost 56 57 50 6. Run a Solver Table with two inputs. (0) Maximum ads per show as stated in the problem, and (1) extra exposures needed. 59 (10 points) 60 Use the following as input values: 61 Maximum adsper show: 3 to 34 in increments of 1 Extra exposures needed: 0 to 3 in increments of 1 Answer key. Total cost - 1948 A H 1 J B D E F G 5 #1. Problem 14 -- modified (35 points) 6 Modifications to problem #4 7 1. In addition to the limit of no more than 10 ads on any given show assume at least 2 ads must be 8 placed in each show. 9 2. The actual exposures obtained for women must not exceed that of men. 10 3. The actual exposures obtained for 35 and under population must be at least 75% of the actual 11 exposures obtained for older population 12 13 Note: All monetary values are in $1000s, and all exposures to ads are in millions of exposures. 14 15 a. Set up a Solver model and determine the least cost advertising plan. (25 points) 16 Exposures to various groups per ad Sunday Night 17 Timeless Football The Simpsons SportsCenter Homeland 18 Men 18-35 6 0.5 0.7 19 Men 36-55 3 5 2 0.5 0.2 20 Men >55 1 3 0 0.3 0 21 Women 18-35 6 1 4 0.1 0.9 22 Women 36-55 4 1 2 0.1 0.1 23 Women >55 2 1 0 0 0 24 25 Cost per ad 140 100 80 13 26 27 Minimum ads per sho 28 Maximum ads per sho 10 Madam Secretary Rachael Ray 0.1 0.1 0 0.6 13 0.4 CNN 0.1 0.2 0.3 0.1 0.2 0.3 9 15 8 140 Formula Bar B E F G H Timeless ight Football The Simpsons SportsCenter Homeland Rachael Ray Advertising plan Minimum required CNN Madam Secretary 29 30 31 32 33 34 35 36 37 Number of ads purcha 0 O 0 0 0 0 0. 0 Maximum allowed Original required 60 38 39 40 41 Constraints on numbers of exposures Actual exposures Men 18-35 0 Men 36-55 0 Men >55 0 Women 18-35 0 Women 36-55 0 Women >55 0 Total 0 Required exposures 0 0 0 0 0 0 8888 42 43 28 45 46 Exposure requirements Extra exposures needed 35 & under minimum 47 0 0.75 48 49 C D G H 49 Actual for Required for 50 Exposure constraints age/gender are/render 51 Women and men O 35 & under and the rest 0 0 53 54 objective to minimize 55 Total cost 56 57 50 6. Run a Solver Table with two inputs. (0) Maximum ads per show as stated in the problem, and (1) extra exposures needed. 59 (10 points) 60 Use the following as input values: 61 Maximum adsper show: 3 to 34 in increments of 1 Extra exposures needed: 0 to 3 in increments of 1 Answer key. Total cost - 1948