Regarding potential customer reached-costs per advertisement

Assignment Help Financial Management

Reference no: EM131238024

Set up and solve in Excel Solver the following problems:

A company is considering various advertising media to promote its new toy. Pertinent information regarding potential customers reached and costs per advertisement is given below:

No. of Customers Maximum Times Cost per

Media Reached Available per Month Advertisement

Daytime TV 1000 10 $2000

Evening TV 3000 8 $3500

Daytime Radio 500 15 $1000

Evening radio 750 15 $1500

Newspaper 900 4 $500

Currently, the company has a monthly advertising budget of $150,000. The marketing department has imposed the following restrictions:

• No more than $20,000 may be spent on radio advertising each month.

• At least 5 TV ads must be used each month.

Write the linear programming formulation to determine what media should be used to maximize monthly audience exposure.

Reference no: EM131238024

Questions Cloud

Why are sticks rather than logs used to start a fire : What is meant by the "molarity" of a solution? Why are sticks, rather than logs, used to start a fire?

Determining the consumer segment : Set your personal preferences aside, and describe how infrastructure might positively and/or negatively affect Apple's positioning for the Millennial (18-35 year old) consumer segment. It is important to state your assumption of Apple's positionin..

What is the price that leads to the highest level of profits : What is the price that leads to the highest level of profits for this firm? Show the area on the graph that represents the above normal profits earned at the profit maximizing price output combination.

Why are metals gold and silver found as elements in nature : Why are the metals gold and silver found as elements in nature, whereas the metals sodium and magnesium are found in nature only in compounds? What is the relationship between the terms mole and Avogadro's number?

Regarding potential customer reached-costs per advertisement : A company is considering various advertising media to promote its new toy. Pertinent information regarding potential customers reached and costs per advertisement is given below: No. of Customers Maximum Times Cost per. Media Reached Available per Mo..

What general type of reaction does this exemplify : Use the letters A, B, and C to illustrate the general format of a single-replacement reaction. Metals above hydrogen in the activity series react with acids to give what two products? What general type of reaction does this exemplify?

Describe what is seen in a precipitation reaction : Describe what is seen in a precipitation reaction. What is happening on the atomic level to cause what is observed?

New-product launch strategy of google search : Describe the new-product launch strategy of Google search. What were the risks and what factors helped the strategy come to fruition?

Perform a du pont analysis on green valley : Perform a Du Pont analysis on Green Valley - shares of Green Valley's stock outstanding and that some recently sold for $45 per share.

User Account

All Pages