I need help in this question. Please show me how to use solver table. Please I know how to use SOLVER but we need to do this with SOLVER TABLE. so please show me all the steps and do it correctly and accurately. please show me all the solutions and steps.
B D E F G H J K L 1 4 com wn- The General Flakes Company sells a brand of low-fat breakfast cereal that appeals to people of all age groups and both genders. The company advertises this cereal in a variety of 30- second television ads, and these ads can be placed in a variety of television shows. The ads in different shows vary by cost-some 30-second slots are much more expensive than others-and by the types of viewers they are likely to reach. The company has segmented the potential viewers into six mutually exclusive categories: males age 18 to 35; males age 36 to 55; males over 55; females age 18 to 35; females age 36 to 55; and females over 55. A rating service can supply data on the numbers of viewers in each of these categories who will watch a 30-second ad on any particular television show. Each such viewer is called an exposure. The company has determined the required number of exposures it wants to obtain for each group. It wants to know how many ads to place on each of several television shows to obtain these required exposures at minimum cost. The data on costs per ad, numbers of exposures per ad, and minimal required exposures are listed below, where numbers of exposures are expressed in millions, and costs are in thousands of dollars. 6 8 10 11 12 If the company has a budeget of 1 million (1000 thousand), a.) build a linear programming model to find the maximum excess exposure the company could get (do not require integer solutions); b.) use SolverTable to test the company's pronfits and correspoinding numbers of ads when the budget is 600, 800, 1000, 1200, 1400, 1600 thousand. F G H J 15 Inputs A B B C D E 13 Advertising model 14 Note: All monetary values are in $1000s, and all exposures to ads are in millions of exposures. 16 Exposures to various groups per ad 17 Timeless Sunday Night Football The Simpsons SportsCenter 18 Men 18-35 2 10 3 4 19 Men 36-55 9 1 3 4 20 Men >55 6 4 5 1 21 Women 18-35 3 3 5 4 22 Women 36-55 3 4 3 2 23 Women >55 8 6 4 0 24 Total viewers 25 26 Cost per ad 69 57 48 36 27 Cost per million exposures 28 29 Advertising plan 30 Timeless Sunday Night Football The Simpsons SportsCenter 31 Number ads purchased 32 Homeland Rachael Ray 7 2 2 1 3 7 7 3 3 9 9 7 CNN Madam Secretary Daily Show 1 9 4 6 8 5 7 6 10 5 4 4 2 10 0 4 8 9 2 6 54 61 51 94 72 Homeland Rachael Ray CNN Madam Secretary Daily Show Excess exposures Required exposures 80 90 40 70 75 32 33 Constraints on numbers of exposures 34 Actual exposures 35 Men 18-35 36 Men 36-55 37 Men >55 38 Women 18-35 39 Women 36-55 40 Women >55 41 42 Budget constraint 43 Total cost 44 45 46 Objective to maximize 47 Total Excess Exposures 48 55 Budget 55 6 4 5 1 21 Women 18-35 3 3 5 4 22 Women 36-55 3 4 3 2 23 Women >55 8 6 4 0 24 Total viewers 25 26 Cost per ad 69 57 48 36 27 Cost per million exposures 28 29 Advertising plan 30 Timeless Sunday Night Football The Simpsons SportsCenter 31 Number ads purchased 32 Homeland Rachael Ray 7 2 2 1 3 7 7 3 3 9 9 7 CNN Madam Secretary Daily Show 1 9 4 6 8 5 7 6 10 5 4 4 2 10 0 4 8 9 2 6 54 61 51 94 72 Homeland Rachael Ray CNN Madam Secretary Daily Show Excess exposures Required exposures 80 90 40 70 75 32 33 Constraints on numbers of exposures 34 Actual exposures 35 Men 18-35 36 Men 36-55 37 Men >55 38 Women 18-35 39 Women 36-55 40 Women >55 41 42 Budget constraint 43 Total cost 44 45 46 Objective to maximize 47 Total Excess Exposures 48 55 Budget
