Please help with solver this what I have so far

Linear Programming Model (Maximize Z = Total Exposure Rating)

Maximize Z = 100S1 + 65S2 + 30M1 + 20M2 + 15R1 + 8R2.

subject to

AdsS1 ? 12; M1 ? 18; R1 ? 25

M1 + M2? 2 (S1+S2)

S1+S2? 20

Budget$10,000 per ad (S1 + S2)? $160,000

$4,000 per ad (M1 + M2)?$140,000

$1,000 per ad (R1 + R2)? $30,000

$10,000(S1 + S2) + $4,000(M1 + M2) + $1000(R1 + R2) ? $350,000

Customers4,000S1 + 1,500S2 + 2,000SM1 + 1,200SM2 + 1,000R1 + 200R2 ? 100,000

S1,S2, M1,M2, R1,R2 ? 0

*S= SiriusXM,M=Social Media,R= Internet Radio

In addition, the variables that we decided to use were:

• S1 - #of SiriusXM Radio Ads with rating of 100 and 4000 new customers
• S2 - # of SiriusXM Radio Ads with rating 65 and 1,500 new customers
• M1 - # of Social Media Ads with rating 30 and 2000 new customers
• M2 - # of Social Media Ads with rating 20 and 1,200 new customers
• R1 - # of Internet Radio with rating 15 and 1,000 new customers
• R2 - # of Internet Radio with rating 8 and 200 new customers

Sunrise Grill is an upscale restaurant located in Key Largo Florida . To help plan the marketing plan for the coming season . Sunrise's management team hired the advertising firm of Kaynan & Keiser ( KK ) . The management team requested KK's recommendation concerning how the advertising budget should be distributed across Internet Radio fog Pandora) . Social Media Marketing , and Sirius XM Radio , The budget has been set at $350 0100 In a meeting with Sunrise's management team . KK consultants provided the following information bout the industry exposure effectiveness rating per ad , their estimate of the number of potential new customers reached per and and the cost for each ad MEDIA Exposure Rating per New Customers per Cost per Ad Sirius XM 1010 4090 $10 0 00 Social Media 2000 $4090 Internet Radio 10DO $1010 The exposure rating is viewed as a measure of the value of the ad to both existing customers and potential new customers . It is a function of such things as image . message recall visual and audio appeal and so on . As expected . the more expensive Sinus XM Radio advertisements has the highest exposure effectiveness rating along with the greatest potential for reaching new customers At this point . the KK consultants pointed out that the data concerning exposure and reach were only applicable to the first few ads in each medium . For Sirius XM KK stated that the exposure rating of 100 and the 4090 new customers reached per and were reliable for the first 16 Sirius XM ads . After 16 ads . the benefit is expected to decline , For planning purposes . KK recommends reducing the exposure rating to 65 and the estimate of the potential new customers reached to 1500 for any Siriu X Mads beyond 16 . For Social Media ads the preceding data are reliable up to a maximum of 20 is Beyond in ads the exposure rating declines to 20 and the number of new customers reached declines to 1200 perad . Similarly for Internet Radio , the preceding data are reliable up to a maximum of 27 : the exposure rating declines to & and the potential number of new customers reached declines to 200 for additional ads Sunrise Grill's management team accepted maximizing the fatal exposure rating . across all media , us the objective of the advertising campaign . Because of management's concern with attracting new customers , management stated that the advertising campaign must reach at least 190 090 new customers , To balance the advertising campaign and make use of all advertising media . Sunni Grill's management team also adopted the following guidelines Use at least twice as many Social Media advertisements as SiriusXM radio advertisements Was no more than 20 SimusXM radio advertisements The Sirius XM radio budget should be at least SIGN thisThe Social Media advertising budget is restricted to a maximum of SISU mom The Internet Radio budget is to be at least $35 . Our KK agreed to work with these guidelines and provide a recommendation us to how the $350 0 0 0 advertising budget should be allocated among the choices . Develop a linear programming model that can be used to determine the advertising budget allocation for the Sunrise Grill . ( HINT : you should define two variables for each media option for 'S number of Sirius XM advertisements with rating of 100 and 4090 new customers and S ; number of Sirius XM advertisements with rating of 65 and 1500 new customers and so on ) Enter the problem into Excel and use Solver to solve for the optimal solution In addition to the Excel file , also prepare an executive summary managenal report . The Executive Summary should be approximately I to 2 pages ( plus Excel file ) and include the following sections ( 20 points ) Case Synopsis finclude a brief summary of the cave and the humorous issueisbeing studied ) ( 20 pilots Methodology (including a discussion of what information was provided and how won need this Infer mat on to analyze the problem ) organize the a slab data and I pe out you full mathematical programming model including defining your decision variables 3 ( 40 points ) Findings and Conclusions Conclude summary of analmore counter ) Based on you Malysh what is Sunrise Grill's (complete ) optimal marketing decision ? A schedule showing the recommended number of Sirius XM Social Media and Internet Radio advertisements and the budget allocation for each medium Show the fatal exposure rate and indicate the total number of potential new customers reached . Also address the following two questions a . How would the total exposure change if an additional $30 090 were added to the advertising rising budget After reviewing KK's recommendation , the Sunrise Grill management team asked how the recommendation would change if the objective of the advertising campaign was to maximize the number of potential new customers reached . Develop the media schedule under this objective Show the foral exposure and indicate the total number of potential new customers reached 4 120 paints + up to In points extra credit , Recommendations . What other factors need to be considered in making the recommendations . Do you agree with the decisions from you quantitative analysis' ? Why or why not ? Using both of these recommendations you made in the findings and conclusions section and your own management perspective (other issues to consider what in your recommendation for the Sunrise Grill sadvertising campaign For extra crude . you can also do Free some outside research on Digital Marketing campaigns and or bust your opinion on you knowledge and or experience with Digital Marketing ( be sure to site any outside sources used )