User Account

All Pages

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.

Reviews

Write a Review

Financial Management Questions & Answers

  Shares of common stock-bond issues outstanding

Erna Corp. has 7 million shares of common stock outstanding. The current share price is $86, and the book value per share is $5. Erna Corp. also has two bond issues outstanding. The first bond issue has a face value of $70 million, has a coupon rate ..

  Calculate the share price for bills bakery

Bill’s Bakery expects earnings per share of $2.18 next year. Current book value is $3.9 per share. The appropriate discount rate for Bill’s Bakery is 13 percent. Calculate the share price for Bill’s Bakery if earnings grow at 4 percent forever.

  Computerized machine tool lathe which costs

Your firm needs a computerized machine tool lathe which costs $51,000 and requires $12,100 in maintenance for each year of its 3-year life. After three years, this machine will be replaced. The machine falls into the MACRS 3-year class life category...

  Appropriate expected rates of return for three securities

The expected return for the general market is 13 percent, and the risk premium in the market is 9.1 percent. Tasaco, LBM, and Exxos have betas of 0.824, 0.652, and 0.549, respectively. What are the appropriate expected rates of return for the three s..

  Debt and is expected to have free cash flow

Heavy Metal Corporation has $2 million in excess cash, $3.5 million in debt and is expected to have free cash flow of $12.5 million next year. Its FCF is then expected to grow at a rate of 2.5% forever. If Heavy Metal’s WACC is 10%, and it has 3.2 mi..

  What is ri-the required rate of return on stock

What is ri, the required rate of return on Stock i? Round your answer to two decimal places. Now assume that rRF remains at 6% but rM increases to 13%. The slope of the SML does not remain constant. How would these changes affect ri? Round your answe..

  Debt with both face and market value

Salmon Inc. has debt with both a face and a market value of $3,000. This debt has a coupon rate of 7% and pays interest annually. The expected earnings before interest and taxes is $1,200, the tax rate is 34%, and the unlevered cost of capital is 12%..

  What is the market value of the firms equity and debt

Sunburn Sunscreen has a zero coupon bond issue outstanding with a $21,000 face value that matures in one year. The current market value of the firm's assets is $21,000. The standard deviation of the return on the firm's assets is 34 percent per year,..

  Calculate mean-variance and sharpe ratio of cash flows

Calculate mean, variance, and Sharpe ratio of the following cash flows. a 25% probability of making $1000, a 20% probability of making $200, a 10% probability of making $100, and a 45% probability of making nothing

  What is this firms cost of equity

Sweet Treats common stock is currently priced at $17.15 a share. The company just paid $1.22 per share as its annual dividend. The dividends have been increasing by 2.4 percent annually and are expected to continue doing the same. What is this firm's..

  Statement regarding bankruptcy costs

statement below regarding bankruptcy costs.

  Computes a quarterly and annualized return on the portfolio

Calculates a quarterly and annualized return on the portfolio, and the expected return for the portfolio (students may use the closing prices as of December 31st of last year).

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd