Please show work in excel An ad campaign for a new snack chip will be conducted in a limited geographical area and can use TV time, radio time, and newspaper ads. Information about each medium is shown below. If thenumber of TV ads cannot exceed the number of radio ads by more than 4, and if the advertising budget is $10000, develop the LP model that will maximize the number reached and achieve anexposure quality if at least 1000. Create the LP in Tab #11Medium Cost Per # Reached ExposureAdTV500Radio200Newspape 400r1000030005000Quality304025

Given Data : Information about different mediums as per the ad campaign conducted : Medium Cost Per Ad No. reached Exposure Quality TV 500 10000 30 Radio 200 3000 40 Newspaper 400 5000 25To develop : A Linear Programming (LP) model for the table given : Let x = number of TV ads Let y = number of radio ads Let z = number of newspaper ads Then the chart looks like this : Medium Cost Per Ad No. reached Exp. Quality TV x 500x 10,000x 30x Radio y 200y 3,000y 40y News z 400z 5,000z 25z Total 10,000 N 1,000 And we have these inequalities : x ≥ 0y ≥ 0z ≥ 0x ≤ y + 4 500x + 200y + 400z ≤ 10,00030x + 40y + 50z ≥ 1,000 Objective function : N = 10,000x + 3,000y + 5,000z The solver gives the following output for optimization : x y z 14.28571 14.28571 0 185714.3 7142.857 2857.143 0 10000 ≤ 10000 428.5714 571.4286 0 1000 ≥ 1000 14.28571 14.28571 -4 ≤ 0 So, the maximum value is 185714.3.