Eddie Kelly is running for reelection as mayor of a small town in Alabama. Jessica Martinez, Kellys campaign manager during this election, is planning the marketing campaign, and there is some stiff competition. Martinez has selected four ways to advertise: television ads, radio ads, billboards, and newspaper ads. The costs of these, the audience reached by each type of ad, and the maximum number available are shown in the following table (pictured below):

In addition, Martinez has decided that there should be at least six ads on TV or social media or some combination of those two. The amount spent on billboards and newspapers together must not exceed the amount spent on TV ads. While fund-raising is still continuing, the monthly budget for advertising has been set at $15,000. How many ads of each type should be placed to maximize the total number of people reached?

(Please show what data is entered into the excel file that is pictured)

Just need to know what data to add into excel

TYPE COST AUDIENCE MAX- OF AD PER REACHED/ADIMUM AD NUM- BER TV $800 30,000 10 10 Social $400 22,000 media Bill- $500 24,000 10 boards News- $100 8,000 10 papers M N Problem 8-6 D E G H I K End then there To DATA on the convento en SOLVE ISOLVER Unea, Integer and Mixed Integer Programming Pepe 10 LHS Sarpus D 0 D O . 0 12 am 13 14 Mai TV 15 Maximum di media ads 16 Mainboards 17 wamewer 18 medias o TV 20 21 22 wishes 23 Othe . D a o D 0 0 3 Linear, Integer and Mixed Integer Programming 4 5 Signs 6 7 8 less than or equal to equals (You need to enter an apostrophe first greater than or equal to T R B N sign RHS 10 Data 11 12 Maximize 13 Budget 14 Maximum TV ads 15 Maximum social media ads 16 Maximum billboard ads 17 Maximum newspaper ads 18 TV + social media ads 19 S on TV, bill and news 20 21 Results 22 Variables 23 Objective 24 25 26 27 28 29 30 32 33 34