# 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.

Qualified Writers
Rated 4.9/5 based on 2480 reviews

# 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:

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 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.

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.

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