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.
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.
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.
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
(R1 + R2)
(N1 + N2) >=20
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.
Potential new customers
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.
Potential new customers
If the advertising campaign were to maximize the number of potential new customers reached, our recommendation would change…
The new media schedule would be:
Tables, charts, etc.
Include the complete mathematical model here
Include Excel Spreadsheet
Insert Answer Report from Solver
Insert Sensitivity Report from Solver