We're Open
+44 7340 9595 39
+44 20 3239 6980

[Solved] West Coast is concerned with how to best allocate advertising to reach at least 100,000 new customers, with a budget of $

  100% Pass and No Plagiarism Guaranteed

[Solved] 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.

DCSI Recommendations

INSTRUCTIONS:

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

CONTENT:

Recommendations Name: Instructor: Institution: 1st April 2015. With the observable and other unavoidable constraints, t

...
 

100% Plagiarism Free & Custom Written,
Tailored to your instructions


International House, 12 Constance Street, London, United Kingdom,
E16 2DQ

UK Registered Company # 11483120


100% Pass Guarantee

STILL NOT CONVINCED?

View our samples written by our professional writers to let you comprehend how your work is going to look like. We have categorised this into 3 categories with a few different subject domains

View Our Samples

We offer a £ 2999

If your assignment is plagiarised, we will give you £ 2999 in compensation

Recent Updates

Details

  • Title: [Solved] 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.
  • Price: £ 89
  • Post Date: 2021-10-14T04:47:02+00:00
  • Category: New Samples
  • No Plagiarism Guarantee
  • 100% Custom Written

Customer Reviews

[Solved] 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. [Solved] 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.
Reviews: 5

A masterpiece of assignment by , written on 2020-03-12

Writing is not my field. I take help from this website for my accounting assignment. The work is good and I scored good grades in it. Thank you from the bottom of my heart.
Reviews: 5

A masterpiece of assignment by , written on 2020-03-12

I have tried other sites for assignment help but the result that Insta Research has produced outweighs others. Since I am weak at writing and shaping the data logically, I am glad I took help from this site. Thanks to my writer for such a great quality of the assignment in Business.