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

1. In addition to the limit of no more than 10 ads on a given show assume at least two ads must be placed in each show.

2. the actual exposures obtained for women must not exceed that of men.

3. the actual exposures obtained for 35 and under population must be at least 75% of the actual exposures obtained for the older population.

Hint: Required exposures = Original exposure + Extra exposures needed Use zero as the initial value for extra exposures needed. use extra exposures needed as the input cell to answer (b).

Total Cost must = 1948

NI w ... HAD - 100) In search the webwinnype SURLO OP Search the Web or type 0 8:04 PM 276/2020 AutoSave Of H S B : Sp20-3560-ETOS-Ch04-1-Shell (2) - Excel Search 0 X Comments File Home Insert Draw P age Layout Formulas Data Review View Help Calibri 10 === General 12 EX AA A Paste L5 Sign in - Share Er 48 0 5 Sort & Find & Ideas Filter Select Editing Wrap Text 3 Merge & Center - BI U D $ -% -8 Insert Delete Format Conditional Format as Formatting Table Styles Cell Styles Clipboard Font Alignment Number Cells Ideas A1 - Spring 2020 - MGT 3560: ET05-Ch04-1 Name: Cole Baxter (UTC ID: tgx696) BC K L M N 5 #1. Problem #4 -- 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. 103. The actual exposures obtained for 35 and under population must be at least 75% of the actual exposures obtained for older population. 12 13 Note: All monetary values are in $1000s, and all exposures to ads are in millions of exposures. Caution: Do not alter the si cells, or renaming slightly to accom Not following the All cells in all she number format a appropriate fashi 15 a. Homeland Rachael Ray CNN Madam Secretary 0.1 Set up a Solver model and determine the least cost advertising plan. (25 points) Exposures to various groups per ad Timeless day Night Football The Simpsons Men 18-35 Men 36-55 Men >55 Women 18-35 Women 36-55 Women >55 SportsCenter 0.5 0.5 0.3 0.1 0.2 0.3 En w En w R 0.1 0 0.4 0.3 Sheet1 Sheet2 Sheet3 + @ J -_ + NI w ... HAD - 100) In search the webwinnype SURLO OP Search the Web or type 0 8:04 PM 276/2020 AutoSave Of H S B : Sp20-3560-ETOS-Ch04-1-Shell (2) - Excel Search 0 X Comments File Home Insert Draw P age Layout Formulas Data Review View Help Calibri 10 === General A 12 D E AA A Wrap Text 3 Merge & Center - Sign in - Share E' 47 O Sort & Find & Ideas Filter Select Editing Paste LG BI U D $ -% -8 Insert Delete Format Conditional Format as Formatting Table Styles Cell Styles Clipboard Font Alignment Number Cells Ideas - X for Women >55 Spring 2020 - MGT 3560: ET05-Ch04-1 Name: Cole Baxter (UTC ID: tgx696) C D E F G 0 H I J K L M 2 0 0.4 0.3 4 Cost per ad - 140 100 80 CO 140 Minimum ads per show Maximum ads per show Timeless day Night Football The Simpsons SportsCenter Homeland Rachael Ray CNN Madam Secretary Advertising plan Minimum required Number of ads purchased Maximum allowed Required exposures Original required Constraints on numbers of exposures Actual exposures Men 18-35 Men 36-55 Men >55 Women 18-35 Women 36-55 Sheet1 Sheet2 Sheet3 Hint: Required exposel Use zero as the in Use Extra exposui 60 42 43 + @ 0 - - NI w ... HAD - 100) In search the webwinnype SURLO 0 P Search the Web or type 0 8:04 PM 276/2020 AutoSave Of H S B : Sp20-3560-ETOS-Ch04-1-Shell (2) - Excel Search 0 X Comments File Home Insert Draw P age Layout Formulas Data Review View Help Calibri 10 === General E AA A Wrap Text 3 Merge & Center - Sign in - Share E AY O 5 Sort & Find & Ideas Filter Select Editing Paste BI U D $ -% -8 Insert Delete Format Conditional Format as Formatting Table Styles Cell Styles Clipboard Font Alignment Number Cells Ideas for A1 A Spring 2020 - MGT 3560: ET05-Ch04-1 Name: Cole Baxter (UTC ID: tgx696) C D E K L M N 43 60 X B Women 36-55 Women >55 Total Exposure requirements Extra exposures needed 35 & under minimum 0.75 Actual for age/gender Required for age/gender Exposure constraints Women and men 35 & under and the rest Answer key: Tota Objective to minimize Total cost 57 58 b. Run a Solver Table with two inputs, (i) Maximum ads per show as stated in the problem, and (ii) extra exposures needed. Sheet1 Sheet2 Sheet3 + @ J -_ w In search the webwinnype SURLO 3 0 - OP Search the Web or type 1 8:05 PM 2/6/2020 AutoSave Of H S B : Sp20-3560-ETOS-Ch04-1-Shell (2) - Excel Search 0 X Comments File Home Insert Draw P age Layout Formulas Data Review View Help Calibri 10 === General 12 EX E' 48 AA A 5 Sign in - Share 0 Sort & Find & Ideas Filter Select Editing Ideas Wrap Text 3 Merge & Center - Paste BI U D $ -% -8 Insert Delete Format Conditional Format as Formatting Table Styles Cell Styles Clipboard Font Alignment Number Cells A1 x for Spring 2020 - MGT 3560: ET05-Ch04-1 Name: Cole Baxter (UTC ID: tgx696) A K L M N 35 & under and the rest Answer key: Tota Objective to minimize Total cost Run a Solver Table with two inputs, (i) Maximum ads per show as stated in the problem, and (ii) extra exposures needed. (10 points) Use the following as input values: Maximum ads per show: 8 to 14 in increments of 1 Extra exposures needed: 0 to 8 in increments of 1. Sheet1 Sheet2 Sheet3 + @ J - - + NI w ... HAD - 100) In search the webwinnype SURLO OP Search the Web or type 0 8:04 PM 276/2020 AutoSave Of H S B : Sp20-3560-ETOS-Ch04-1-Shell (2) - Excel Search 0 X Comments File Home Insert Draw P age Layout Formulas Data Review View Help Calibri 10 === General 12 EX AA A Paste L5 Sign in - Share Er 48 0 5 Sort & Find & Ideas Filter Select Editing Wrap Text 3 Merge & Center - BI U D $ -% -8 Insert Delete Format Conditional Format as Formatting Table Styles Cell Styles Clipboard Font Alignment Number Cells Ideas A1 - Spring 2020 - MGT 3560: ET05-Ch04-1 Name: Cole Baxter (UTC ID: tgx696) BC K L M N 5 #1. Problem #4 -- 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. 103. The actual exposures obtained for 35 and under population must be at least 75% of the actual exposures obtained for older population. 12 13 Note: All monetary values are in $1000s, and all exposures to ads are in millions of exposures. Caution: Do not alter the si cells, or renaming slightly to accom Not following the All cells in all she number format a appropriate fashi 15 a. Homeland Rachael Ray CNN Madam Secretary 0.1 Set up a Solver model and determine the least cost advertising plan. (25 points) Exposures to various groups per ad Timeless day Night Football The Simpsons Men 18-35 Men 36-55 Men >55 Women 18-35 Women 36-55 Women >55 SportsCenter 0.5 0.5 0.3 0.1 0.2 0.3 En w En w R 0.1 0 0.4 0.3 Sheet1 Sheet2 Sheet3 + @ J -_ + NI w ... HAD - 100) In search the webwinnype SURLO OP Search the Web or type 0 8:04 PM 276/2020 AutoSave Of H S B : Sp20-3560-ETOS-Ch04-1-Shell (2) - Excel Search 0 X Comments File Home Insert Draw P age Layout Formulas Data Review View Help Calibri 10 === General A 12 D E AA A Wrap Text 3 Merge & Center - Sign in - Share E' 47 O Sort & Find & Ideas Filter Select Editing Paste LG BI U D $ -% -8 Insert Delete Format Conditional Format as Formatting Table Styles Cell Styles Clipboard Font Alignment Number Cells Ideas - X for Women >55 Spring 2020 - MGT 3560: ET05-Ch04-1 Name: Cole Baxter (UTC ID: tgx696) C D E F G 0 H I J K L M 2 0 0.4 0.3 4 Cost per ad - 140 100 80 CO 140 Minimum ads per show Maximum ads per show Timeless day Night Football The Simpsons SportsCenter Homeland Rachael Ray CNN Madam Secretary Advertising plan Minimum required Number of ads purchased Maximum allowed Required exposures Original required Constraints on numbers of exposures Actual exposures Men 18-35 Men 36-55 Men >55 Women 18-35 Women 36-55 Sheet1 Sheet2 Sheet3 Hint: Required exposel Use zero as the in Use Extra exposui 60 42 43 + @ 0 - - NI w ... HAD - 100) In search the webwinnype SURLO 0 P Search the Web or type 0 8:04 PM 276/2020 AutoSave Of H S B : Sp20-3560-ETOS-Ch04-1-Shell (2) - Excel Search 0 X Comments File Home Insert Draw P age Layout Formulas Data Review View Help Calibri 10 === General E AA A Wrap Text 3 Merge & Center - Sign in - Share E AY O 5 Sort & Find & Ideas Filter Select Editing Paste BI U D $ -% -8 Insert Delete Format Conditional Format as Formatting Table Styles Cell Styles Clipboard Font Alignment Number Cells Ideas for A1 A Spring 2020 - MGT 3560: ET05-Ch04-1 Name: Cole Baxter (UTC ID: tgx696) C D E K L M N 43 60 X B Women 36-55 Women >55 Total Exposure requirements Extra exposures needed 35 & under minimum 0.75 Actual for age/gender Required for age/gender Exposure constraints Women and men 35 & under and the rest Answer key: Tota Objective to minimize Total cost 57 58 b. Run a Solver Table with two inputs, (i) Maximum ads per show as stated in the problem, and (ii) extra exposures needed. Sheet1 Sheet2 Sheet3 + @ J -_ w In search the webwinnype SURLO 3 0 - OP Search the Web or type 1 8:05 PM 2/6/2020 AutoSave Of H S B : Sp20-3560-ETOS-Ch04-1-Shell (2) - Excel Search 0 X Comments File Home Insert Draw P age Layout Formulas Data Review View Help Calibri 10 === General 12 EX E' 48 AA A 5 Sign in - Share 0 Sort & Find & Ideas Filter Select Editing Ideas Wrap Text 3 Merge & Center - Paste BI U D $ -% -8 Insert Delete Format Conditional Format as Formatting Table Styles Cell Styles Clipboard Font Alignment Number Cells A1 x for Spring 2020 - MGT 3560: ET05-Ch04-1 Name: Cole Baxter (UTC ID: tgx696) A K L M N 35 & under and the rest Answer key: Tota Objective to minimize Total cost Run a Solver Table with two inputs, (i) Maximum ads per show as stated in the problem, and (ii) extra exposures needed. (10 points) Use the following as input values: Maximum ads per show: 8 to 14 in increments of 1 Extra exposures needed: 0 to 8 in increments of 1. Sheet1 Sheet2 Sheet3 + @ J - - +