based on the file I attached I want a paragraph recommendation on what we did and you can see all our work in that file I attached I want recommendation based on what we did a paragraph only.

thanks best regards.





alright there`s the work:



Our company, Jacobs & Whybark (J&W), is here to help your company, West Coast Grille, plan an advertising campaign for the upcoming season. We developed an LP model to best determine and make recommendations for how you should allocate your advertising budget across television, radio and newspaper advertisements.

The following report presents an analysis and recommendations for your media mix for the upcoming season. In section 1, we describe the problem, the relevant costs, constraints, and objectives and mention the solution methodology we employ. In section 2, we present and discuss our results along with our recommendations. Tables, charts, and technical details are presented as separate appendices and referenced in the report.



Section 1

Problem:

West Coast is concerned with how to best allocate advertising to reach at least 100,000 new customers, with a budget of $279,000. Our company worked with the following constraints to provide recommendations on how to best allocate your budget.



Objective:

Maximize Profit: 90TV1 + 55TV2 + 25R1 + 20R2 + 10N1 + 5N2



Let R, TV, & N be the number of ads placed in radio, TV, and newspapers.

Let R1 denote the first 15 radio ads, and R2 denote ads thereafter.

Let TV1 denote the first 10 TV ads, and TV2 denote TV ads thereafter.

Let N1 denote the first 20 newspaper ads, and N2 denote newspaper ads thereafter.



Constraints:

Budget: 10,000(TV1+TV2) + 3,000(R1+R2) + 1,000(N1+N2)

Break Point: T1

4000TV1 + 1500 TV2 + 2000R1 + 1200 R2 + 1000N1 + 800N2 >= 100,000

(R1 + R2), (TV1 + TV2), (N1 + N2) >= 0

0=2TV1 + 2TV2 - R1 - R2

14

(R1 + R2)

(N1 + N2) >=20



Section 2

Results

The following schedule shows the numbers of television, radio, and newspaper advertisements we recommend West Coast Grill invest in. It also includes the budget allocation for each media outlet. We also calculated the total exposure and total number of new customers we reached. By allocating $279,000 our total exposure is 2,120 and we reached 124,700 new customers.



Advertising Media

Recommended Number 

Budget Allocation

Total 

Exposure

Potential new customers

TV1

10

$100,000

900

40,000

TV2

5

$50,000

275

7,500

R1

15

$45,000

375

30,000

R2

16

$48,000

320

19,200

N1

20

$20,000

200

20,000

N2

10

$10,000

50

8,000

Totals

76

$273,000

2,120

124,700



If you were to add an additional $10,000 to the advertising budget, making the budget $289,000, the total exposure would change as outlined below. The exposure would increase by 75, and the potential new customers reached would increase by 2,700 people.



Advertising Media

Recommended Number 

Budget Allocation

Total 

Exposure

Potential new customers

TV1

10

$100,000

900

40,000

TV2

6

$60,000

330

9,000

R1

15

$45,000

375

30,000

R2

17

$51,000

340

20,400

N1

20

$20,000

200

20,000

N2

10

$10,000

50

8,000

Total

78

$286,000

2,195

127,400





If the advertising campaign were to maximize the number of potential new customers reached, our recommendation would change…

The new media schedule would be: 



Recommendations



Appendix

Tables, charts, etc.

Include the complete mathematical model here



Include Excel Spreadsheet



Insert Answer Report from Solver

Insert Sensitivity Report from Solver